From 204bd197f3691adad7ebb8bbc020e1356cfe1be3 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 25 Aug 2016 10:01:47 +0100 Subject: [PATCH] Bug 10455: Remove biblioitems.marc - DB changes Content-Type: text/plain; charset="utf-8" Signed-off-by: Mason James --- installer/data/mysql/atomicupdate/bug_10455.sql | 2 ++ installer/data/mysql/kohastructure.sql | 2 -- 2 files changed, 2 insertions(+), 2 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_10455.sql diff --git a/installer/data/mysql/atomicupdate/bug_10455.sql b/installer/data/mysql/atomicupdate/bug_10455.sql new file mode 100644 index 0000000..8e81536 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_10455.sql @@ -0,0 +1,2 @@ +ALTER TABLE biblioitems DROP COLUMN marc; +ALTER TABLE deletedbiblioitems DROP COLUMN marc; diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 10bee02..65bcfb3 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -173,7 +173,6 @@ CREATE TABLE `biblioitems` ( -- information related to bibliographic records in `size` varchar(255) default NULL, -- material size (MARC21 300$c) `place` varchar(255) default NULL, -- publication place (MARC21 260$a) `lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a) - `marc` longblob, -- full bibliographic MARC record `url` text default NULL, -- url (MARC21 856$u) `cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2) `cn_class` varchar(30) default NULL, @@ -528,7 +527,6 @@ CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t `size` varchar(255) default NULL, -- material size (MARC21 300$c) `place` varchar(255) default NULL, -- publication place (MARC21 260$a) `lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a) - `marc` longblob, -- full bibliographic MARC record `url` text default NULL, -- url (MARC21 856$u) `cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2) `cn_class` varchar(30) default NULL, -- 2.1.4