summaryrefslogtreecommitdiff
path: root/fml/etc/src/config.cf.en/mysql.cf
diff options
context:
space:
mode:
authorfukachan <fukachan>2003-07-26 14:16:57 +0000
committerfukachan <fukachan>2003-07-26 14:16:57 +0000
commitd7308cc59ef1f6806001dd1fba4d2c94da7730d1 (patch)
treec7438a1dceacf91a4b5b4bb9055984faa879e348 /fml/etc/src/config.cf.en/mysql.cf
parent2cacd91acefa9309cd68fbd726be1eebdd5e4788 (diff)
downloadfml8-snap-20030726.tar.gz
fml8-snap-20030726.tar.bz2
fml8-snap-20030726.zip
source of config.cf.en, translated config.cf.jasnap-20030726
Diffstat (limited to 'fml/etc/src/config.cf.en/mysql.cf')
-rw-r--r--fml/etc/src/config.cf.en/mysql.cf45
1 files changed, 45 insertions, 0 deletions
diff --git a/fml/etc/src/config.cf.en/mysql.cf b/fml/etc/src/config.cf.en/mysql.cf
new file mode 100644
index 00000000..faeeb84e
--- /dev/null
+++ b/fml/etc/src/config.cf.en/mysql.cf
@@ -0,0 +1,45 @@
+=head1 MySQL example
+
+#
+# [Example]
+# create table ml (
+# fml_ml char(64),
+# fml_address char(64),
+# fml_member int,
+# fml_recipient int
+# );
+
+[mysql:fml]
+
+sql_server = localhost
+sql_user = fml
+sql_password = uja
+sql_database = fml
+sql_table = ml
+
+sql_get_next_key = select fml_address from $sql_table
+ where fml_ml = '$ml_name'
+ and
+ fml_domain = '$ml_domain'
+
+sql_getline = select fml_address from $sql_table
+ where fml_ml = '$ml_name'
+ and
+ fml_domain = '$ml_domain'
+
+sql_add = insert into $sql_table
+ values ('$ml_name', '$ml_domain', '&address', 1, 1)
+
+sql_delete = delete from $sql_table
+ where fml_ml = '$ml_name'
+ and
+ fml_domain = '$ml_domain'
+ and
+ fml_address = '&address'
+
+sql_find = select fml_address from $sql_table
+ where fml_ml = '$ml_name'
+ and
+ fml_domain = '$ml_domain'
+ and
+ fml_address like '%&regexp%'