From 36e68effaec6ff98ce30118c2e5c8c1696fb0bbc Mon Sep 17 00:00:00 2001 From: Chris Cormack Date: Sat, 19 Jun 2010 20:02:29 +1200 Subject: [PATCH] Missing tables in the kohastructure.sql table. Signed-off-by: Galen Charlton --- installer/data/mysql/kohastructure.sql | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index db5b372d89..f1eb50a499 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -420,6 +420,27 @@ CREATE TABLE `categories` ( UNIQUE KEY `categorycode` (`categorycode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +-- +-- Table: collections +-- +CREATE TABLE collections ( + colId integer(11) NOT NULL auto_increment, + colTitle varchar(100) NOT NULL DEFAULT '', + colDesc text NOT NULL, + colBranchcode varchar(4) DEFAULT NULL comment 'branchcode for branch where item should be held.', + PRIMARY KEY (colId) +) ENGINE=InnoDB DEFAULT CHARACTER SET utf8; + +-- +-- Table: collections_tracking +-- +CREATE TABLE collections_tracking ( + ctId integer(11) NOT NULL auto_increment, + colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId', + itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber', + PRIMARY KEY (ctId) +) ENGINE=InnoDB DEFAULT CHARACTER SET utf8; + -- -- Table structure for table `borrower_branch_circ_rules` -- -- 2.39.2