From 306871578edc592b2b1ff20c19b33d801e2573fc Mon Sep 17 00:00:00 2001 From: Paul Poulain Date: Mon, 7 Mar 2011 13:12:44 -0500 Subject: [PATCH] BZ3624, proposed patch for kohastructure.sql rewritten Signed-off-by: Nicole C. Engard Signed-off-by: Chris Cormack --- installer/data/mysql/kohastructure.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index da1528c813..a62e07c9fb 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2352,6 +2352,9 @@ CREATE TABLE `aqbasketgroups` ( `name` varchar(50) default NULL, `closed` tinyint(1) default NULL, `booksellerid` int(11) NOT NULL, + `deliveryplace` varchar(10) default NULL, + `deliverycomment` varchar(255) default NULL, + `billingplace` varchar(10) default NULL, PRIMARY KEY (`id`), KEY `booksellerid` (`booksellerid`), CONSTRAINT `aqbasketgroups_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE ON DELETE CASCADE -- 2.39.2