regen: update mysql

1 files changed, 26 insertions, 18 deletions

diff --git a/fml/etc/default_config.cf.ja.in b/fml/etc/default_config.cf.ja.in
index 4ab74386..aea655c9 100644
--- a/fml/etc/default_config.cf.ja.in
+++ b/fml/etc/default_config.cf.ja.in
@@ -1415,26 +1415,34 @@ has_fork	=	yes
 sql_server	=	localhost
 sql_user	=	fml
 sql_password	=	uja
-sql_database	=	ml
-sql_table	=	fml
-
-get_next_key	=	select fml_address from $sql_table
-			where fml_ml = '&ml_name'
-
-getline		=	select * from $sql_table
-			where fml_ml = '&ml_name'
-
-add		=	insert into $sql_table
-			values ('&ml_name', '&address', 1, 1)
-
-delete		=	delete from $sql_table
-			where	fml_ml = '&ml_name'
-				and
+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 * 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'
 
-find		=	select * from $sql_table
-			where	fml_ml = '&ml_name'
-				and
+sql_find	=	select * from $sql_table
+			where	fml_ml = '$ml_name'
+					and
+				fml_domain = '$ml_domain'
+					and
 				fml_address like '&regexp'
 
 =head1 ¥Õ¥Ã¥¯'s