From 5aa82f3df9087824afa61d808e49e99a60c41892 Mon Sep 17 00:00:00 2001 From: hdl Date: Wed, 11 Jul 2007 12:08:09 +0000 Subject: [PATCH] minor changes in SQL --- installer/kohastructure.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/installer/kohastructure.sql b/installer/kohastructure.sql index f7a9a236b5..e8d7374020 100644 --- a/installer/kohastructure.sql +++ b/installer/kohastructure.sql @@ -417,13 +417,13 @@ CREATE TABLE `biblioitems` ( `issn` varchar(9) default NULL, `dewey` varchar(30) default '', `subclass` varchar(3) default NULL, - `publicationyear` smallint(6) default NULL, + `publicationyear` text, `publishercode` varchar(255) default NULL, `volumedate` date default NULL, - `volumeddesc` varchar(255) default NULL, - `seriestitle` text NOT NULL, - `seriesissn` text NOT NULL, - `seriesvolume` text NOT NULL, + `volumeddesc` text, + `collectiontitle` mediumtext NOT NULL, + `collectionissn` text NOT NULL, + `collectionvolume` mediumtext NOT NULL, `editionstatement` text NOT NULL, `editionreponsability` text NOT NULL, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, @@ -433,7 +433,7 @@ CREATE TABLE `biblioitems` ( `size` varchar(255) default NULL, `place` varchar(255) default NULL, `lccn` varchar(25) default NULL, - `marc` blob, + `marc` longblob, `url` varchar(255) default NULL, `lcsort` varchar(25) default NULL, `ccode` varchar(4) default NULL, -- 2.39.5