X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=installer%2Fdata%2Fmysql%2Fupdatedatabase.pl;fp=installer%2Fdata%2Fmysql%2Fupdatedatabase.pl;h=85128f7ee51e1344c9dff00d065c101f8b0d7f52;hb=5d170aa26865ee308f9d44992ea9f8eb9c6e0c19;hp=1af6a0fb4521f50d238019cb15679fbc988f5f66;hpb=7362776897c702bbabe49e24a4875afae5d11a9a;p=koha.git

diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
index 1af6a0fb45..85128f7ee5 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -7707,7 +7707,9 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
       field_value varchar(100) default NULL,
       to_field varchar(3) default NULL,
       to_subfield varchar(1) default NULL,
-      to_regex text,
+      to_regex_search text,
+      to_regex_replace text,
+      to_regex_modifiers varchar(8) default '',
       conditional enum('if','unless') default NULL,
       conditional_field varchar(3) default NULL,
       conditional_subfield varchar(1) default NULL,
@@ -7715,7 +7717,8 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
       conditional_value text,
       conditional_regex tinyint(1) NOT NULL default '0',
       description text,
-      PRIMARY KEY  (mmta_id)
+      PRIMARY KEY  (mmta_id),
+      CONSTRAINT `mmta_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `marc_modification_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE
       ) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
     ");