[Koha-patches] [PATCH] Missing tables in the kohastructure.sql table.
Chris Cormack
chris at bigballofwax.co.nz
Sat Jun 19 10:02:29 CEST 2010
---
installer/data/mysql/kohastructure.sql | 21 +++++++++++++++++++++
1 files changed, 21 insertions(+), 0 deletions(-)
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index db5b372..f1eb50a 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -421,6 +421,27 @@ CREATE TABLE `categories` (
) 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`
--
--
1.6.3.3
More information about the Koha-patches
mailing list