From a754051fcdbad7ca5836f22cfff0310720e83782 Mon Sep 17 00:00:00 2001 From: Joshua Ferraro Date: Sun, 30 Sep 2007 18:59:25 -0500 Subject: [PATCH] Remove NOT NULL for new columns in biblioitems as they Signed-off-by: Chris Cormack --- installer/kohastructure.sql | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/installer/kohastructure.sql b/installer/kohastructure.sql index 7a07868230..789ed74df9 100644 --- a/installer/kohastructure.sql +++ b/installer/kohastructure.sql @@ -391,11 +391,11 @@ CREATE TABLE `biblioitems` ( `publishercode` varchar(255) default NULL, `volumedate` date default NULL, `volumeddesc` text, - `collectiontitle` mediumtext NOT NULL, - `collectionissn` text NOT NULL, - `collectionvolume` mediumtext NOT NULL, - `editionstatement` text NOT NULL, - `editionresponsibility` text NOT NULL, + `collectiontitle` mediumtext default NULL, + `collectionissn` text default NULL, + `collectionvolume` mediumtext default NULL, + `editionstatement` text default NULL, + `editionresponsibility` text default NULL, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `illus` varchar(255) default NULL, `pages` varchar(255) default NULL, -- 2.39.5