From b98726eab278ca81a883465bdc2b1887befa7c38 Mon Sep 17 00:00:00 2001 From: Mason James Date: Thu, 21 Feb 2008 07:43:27 +1300 Subject: [PATCH] Added item.enumchron column, and framework map to 952h. Signed-off-by: Chris Cormack Signed-off-by: Joshua Ferraro --- installer/data/mysql/updatedatabase.pl | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 6600cc6cc2..3b4f03fdb8 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -1028,6 +1028,15 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } +$DBversion = "3.00.00.056"; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + + $dbh->do("INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value` , `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('952', 'h', 'Serial Enumeration / chronology','Serial Enumeration / chronology', 0, 0, 'items.enumchron', 10, '', '', '', 0, 0, '', '', '', NULL) "); + $dbh->do("ALTER TABLE `items` ADD `enumchron` VARCHAR(80) DEFAULT NULL;"); + print "Upgrade to $DBversion done ( Added item.enumchron column, and framework map to 952h )\n"; + SetVersion ($DBversion); +} + =item DropAllForeignKeys($table) -- 2.39.5