Bug 12478 : Remove the rest of the references to the old mapping tables
authorChris <chrisc@catalyst.net.nz>
Tue, 12 Apr 2016 20:45:28 +0000 (08:45 +1200)
committerTomas Cohen Arazi <tomascohen@theke.io>
Tue, 26 Apr 2016 13:01:58 +0000 (10:01 -0300)
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
Signed-off-by: Jesse Weaver <jweaver@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>

installer/data/mysql/updatedatabase.pl

index 8f7960c..30b4ce6 100755 (executable)
@@ -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.