From 25494aafa720eace5534fa21ff5c055328ae9d0e Mon Sep 17 00:00:00 2001 From: Chris Nighswonger Date: Mon, 12 Nov 2007 15:49:08 -0600 Subject: [PATCH] Moved location of updater scripts to dbms specific dir. Signed-off-by: Chris Cormack Signed-off-by: Joshua Ferraro --- .../data/mysql}/sample_only_param_tables.sql | 0 .../data/mysql}/update22to30.pl | 0 .../data/mysql/updatedatabase.pl | 25 ------------------- 3 files changed, 25 deletions(-) rename {updater => installer/data/mysql}/sample_only_param_tables.sql (100%) rename {updater => installer/data/mysql}/update22to30.pl (100%) rename updater/updatedatabase => installer/data/mysql/updatedatabase.pl (96%) diff --git a/updater/sample_only_param_tables.sql b/installer/data/mysql/sample_only_param_tables.sql similarity index 100% rename from updater/sample_only_param_tables.sql rename to installer/data/mysql/sample_only_param_tables.sql diff --git a/updater/update22to30.pl b/installer/data/mysql/update22to30.pl similarity index 100% rename from updater/update22to30.pl rename to installer/data/mysql/update22to30.pl diff --git a/updater/updatedatabase b/installer/data/mysql/updatedatabase.pl similarity index 96% rename from updater/updatedatabase rename to installer/data/mysql/updatedatabase.pl index ad2e97a78f..34d03ce7e7 100755 --- a/updater/updatedatabase +++ b/installer/data/mysql/updatedatabase.pl @@ -561,31 +561,6 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } -$DBversion = "3.00.00.023"; -if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - $dbh->do("INSERT INTO `systempreferences` (variable,value,options,explanation,type) - VALUES ('yuipath','http://yui.yahooapis.com/2.3.1/build','Insert the path to YUI libraries','','free')"); - print "Upgrade to $DBversion done (adding new system preference for controlling YUI path)\n"; - SetVersion ($DBversion); -} - -$DBversion = "3.00.00.024"; -if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - $dbh->do("ALTER TABLE biblioitems CHANGE itemtype itemtype VARCHAR(10)"); - print "Upgrade to $DBversion done (changing itemtype to (10))\n"; - SetVersion ($DBversion); -} - -$DBversion = "3.00.00.025"; -if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - $dbh->do("ALTER TABLE items ADD COLUMN itype VARCHAR(10)"); - if(C4::Context->preference('item-level_itypes')){ - $dbh->do('update items,biblioitems set items.itype=biblioitems.itemtype where items.biblionumber=biblioitems.biblionumber and itype is null'); - } - print "Upgrade to $DBversion done (reintroduce items.itype - fill from itemtype)\n "; - SetVersion ($DBversion); -} - =item DropAllForeignKeys($table) -- 2.39.5