From 5c41ae54e68866f9661e853376537059f4d83f70 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Mon, 5 May 2008 10:04:27 -0500 Subject: [PATCH] kohabug 2076: more reconciliation of kohastructure.sql Changes to kohastructure.sql to sync with changes made via updatedatabase.pl: aqbooksellers.name (DB rev 042) subscription.serialsadditems (DB rev 071) Signed-off-by: Joshua Ferraro --- installer/data/mysql/kohastructure.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index f8fa31b3d1..f0130c54b7 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -123,7 +123,7 @@ CREATE TABLE `aqbookfund` ( DROP TABLE IF EXISTS `aqbooksellers`; CREATE TABLE `aqbooksellers` ( `id` int(11) NOT NULL auto_increment, - `name` mediumtext, + `name` mediumtext NOT NULL, `address1` mediumtext, `address2` mediumtext, `address3` mediumtext, @@ -1754,6 +1754,7 @@ CREATE TABLE `subscription` ( `branchcode` varchar(10) NOT NULL default '', `hemisphere` tinyint(3) default 0, `lastbranch` varchar(10), + `serialsadditems` tinyint(1) NOT NULL default '0', PRIMARY KEY (`subscriptionid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2.39.5