From f560b5dd20b790ed1cd1f60373dd5163803bf754 Mon Sep 17 00:00:00 2001 From: Chris Nighswonger Date: Tue, 5 Feb 2008 06:27:58 -0500 Subject: [PATCH] Adding 'more_subfields_xml' column to deleteditems table. Signed-off-by: Joshua Ferraro --- installer/data/mysql/kohastructure.sql | 1 + installer/data/mysql/updatedatabase.pl | 7 +++++++ kohaversion.pl | 2 +- 3 files changed, 9 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 66928b212d..40d9768d20 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -836,6 +836,7 @@ CREATE TABLE `deleteditems` ( `materials` varchar(10) default NULL, `uri` varchar(255) default NULL, `itype` varchar(10) default NULL, + `more_subfields_xml` longtext default NULL, `marc` longblob, PRIMARY KEY (`itemnumber`), KEY `delitembarcodeidx` (`barcode`), diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index a1dfb1655f..0a68226d90 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -981,6 +981,13 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } +$DBversion = "3.00.00.052"; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do("ALTER TABLE `deleteditems` ADD `more_subfields_xml` LONGTEXT DEFAULT NULL;"); + print "Upgrade to $DBversion done ( Adding missing column to deleteditems table. )\n"; + SetVersion ($DBversion); +} + =item DropAllForeignKeys($table) Drop all foreign keys of the table $table diff --git a/kohaversion.pl b/kohaversion.pl index d39c32682a..5b5605cb04 100644 --- a/kohaversion.pl +++ b/kohaversion.pl @@ -10,7 +10,7 @@ use strict; sub kohaversion { - our $VERSION = "3.00.00.051"; + our $VERSION = "3.00.00.052"; # version needs to be set this way # so that it can be picked up by Makefile.PL # during install -- 2.39.2