From cdeada443c0fad1a9e7caf9c0fae129289ef2089 Mon Sep 17 00:00:00 2001 From: Chris Nighswonger Date: Thu, 13 Mar 2008 17:18:02 -0500 Subject: [PATCH] Adding another missing column to deleted items table. Signed-off-by: Joshua Ferraro --- installer/data/mysql/kohastructure.sql | 1 + installer/data/mysql/updatedatabase.pl | 3 ++- 2 files changed, 3 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index aff3c6c5ea..2dcce90055 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -839,6 +839,7 @@ CREATE TABLE `deleteditems` ( `more_subfields_xml` longtext default NULL, `marc` longblob, `copynumber` smallint(6) default NULL, + `enumchron` varchar(80) default NULL, PRIMARY KEY (`itemnumber`), KEY `delitembarcodeidx` (`barcode`), KEY `delitembinoidx` (`biblioitemnumber`), diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index ef4c033334..e3d95d2752 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -1179,7 +1179,8 @@ $DBversion = "3.00.00.063"; if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $dbh->do("ALTER TABLE deleteditems CHANGE COLUMN booksellerid booksellerid MEDIUMTEXT, - ADD COLUMN copynumber SMALLINT(6);"); + ADD COLUMN copynumber SMALLINT(6) DEFAULT NULL, + ADD COLUMN enumchron VARCHAR(80) DEFAULT NULL;"); $dbh->do("ALTER TABLE items CHANGE COLUMN booksellerid booksellerid MEDIUMTEXT, ADD COLUMN copynumber SMALLINT(6);"); -- 2.39.5