[Koha-patches] [PATCH] kohabug 2076: more reconciliation of kohastructure.sql

[Galen Charlton]

Changes to kohastructure.sql to sync with changes
made via updatedatabase.pl:

aqbooksellers.name (DB rev 042)
subscription.serialsadditems (DB rev 071)
---
 installer/data/mysql/kohastructure.sql |    3 ++-
 1 files changed, 2 insertions(+), 1 deletions(-)

diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index f8fa31b..f0130c5 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;
 
-- 
1.5.5.rc0.16.g02b00