From 4d3255518d1eb3ce17fec5bd0fc2acfd604a7c16 Mon Sep 17 00:00:00 2001 From: Ryan Higgins Date: Tue, 22 Apr 2008 17:46:00 -0500 Subject: [PATCH] DB BUMP 71 : add formatstring to labels_conf for specifying labels content Signed-off-by: Joshua Ferraro --- installer/data/mysql/kohastructure.sql | 1 + installer/data/mysql/updatedatabase.pl | 20 ++++++++++++++++++++ 2 files changed, 21 insertions(+) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index c87a170f17..964614ddbe 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1117,6 +1117,7 @@ CREATE TABLE `labels_conf` ( `isbn` int(1) default '0', `startlabel` int(2) NOT NULL default '1', `printingtype` char(32) default 'BAR', + `formatstring` varchar(64) default NULL, `layoutname` char(20) NOT NULL default 'TEST', `guidebox` int(1) default '0', `active` tinyint(1) default '1', diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index c9fddefa70..9f9cad9e77 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -1305,6 +1305,26 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } +$DBversion = "3.00.00.070"; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do(" ALTER TABLE `subscription` ADD `serialsadditems` TINYINT( 1 ) NOT NULL DEFAULT '0';"); + # fill the new field with the previous systempreference value, then drop the syspref + my $sth = $dbh->prepare("SELECT value FROM systempreferences WHERE variable='serialsadditems'"); + $sth->execute; + my ($serialsadditems) = $sth->fetchrow(); + $dbh->do("UPDATE subscription SET serialsadditems=$serialsadditems"); + $dbh->do("DELETE FROM systempreferences WHERE variable='serialsadditems'"); + print "Upgrade to $DBversion done ( moving serialsadditems from syspref to subscription )\n"; + SetVersion ($DBversion); +} + +$DBversion = "3.00.00.071"; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do("ALTER TABLE labels_conf ADD COLUMN formatstring VARCHAR(64) DEFAULT NULL;"); + print "Upgrade to $DBversion done ( Adding format string to labels generator. )\n"; + SetVersion ($DBversion); +} + =item DropAllForeignKeys($table) Drop all foreign keys of the table $table -- 2.39.5