From bc21573db4122c64212f40553f4b510918e14dd8 Mon Sep 17 00:00:00 2001 From: Chris Date: Wed, 13 Apr 2016 08:45:28 +1200 Subject: [PATCH] Bug 12478 : Remove the rest of the references to the old mapping tables Signed-off-by: Nick Clemens Signed-off-by: Jesse Weaver Signed-off-by: Tomas Cohen Arazi Signed-off-by: Kyle M Hall Signed-off-by: Brendan Gallagher --- installer/data/mysql/updatedatabase.pl | 24 ------------------------ 1 file changed, 24 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 8f7960c472..30b4ce6d85 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -12255,30 +12255,6 @@ if ( $column_has_been_used ) { SetVersion($DBversion); } - -$DBversion = "XXX"; -if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - $dbh->do(q| - ALTER TABLE search_marc_to_field DROP FOREIGN KEY search_marc_to_field_ibfk_1 - |); - $dbh->do(q| - ALTER TABLE search_marc_to_field - ADD CONSTRAINT search_marc_to_field_ibfk_1 FOREIGN KEY (`search_marc_map_id`) REFERENCES `search_marc_map` (`id`) ON DELETE CASCADE ON UPDATE CASCADE - |); - $dbh->do(q| - ALTER TABLE search_marc_map DROP KEY index_name_2 - |); - $dbh->do(q| - ALTER TABLE search_field ADD COLUMN label VARCHAR(255) AFTER name - |); - $dbh->do(q| - UPDATE search_field SET label=name - |); - - print "Upgrade to $DBversion done (Bug 12478/14899 - DB Changes to the elasticsearch tables)\n"; - SetVersion($DBversion); -} - # DEVELOPER PROCESS, search for anything to execute in the db_update directory # SEE bug 13068 # if there is anything in the atomicupdate, read and execute it. -- 2.39.5