BUGFIX for browser and nozebra tables

[koha_gimpoz] / installer / kohastructure.sql

diff --git a/installer/kohastructure.sql b/installer/kohastructure.sql
index cd83c05..82449f7 100644 (file)
--- a/installer/kohastructure.sql
+++ b/installer/kohastructure.sql
@@ -547,6 +547,19 @@ CREATE TABLE `branchtransfers` (
   CONSTRAINT `branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
+
+--
+-- Table structure for table `browser`
+--
+DROP TABLE IF EXISTS `browser`;
+CREATE TABLE `browser` (
+  `level` int(11) NOT NULL,
+  `classification` varchar(20) NOT NULL,
+  `description` varchar(255) NOT NULL,
+  `number` bigint(20) NOT NULL,
+  `endnode` tinyint(4) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
 --
 -- Table structure for table `categories`
 --
@@ -1078,6 +1091,18 @@ CREATE TABLE `notifys` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 --
+-- Table structure for table `nozebra`
+--
+CREATE TABLE `nozebra` (
+                `server` varchar(20)     NOT NULL,
+                `indexname` varchar(40)  NOT NULL,
+                `value` varchar(250)     NOT NULL,
+                `biblionumbers` longtext NOT NULL,
+                KEY `indexname` (`server`,`indexname`),
+                KEY `value` (`server`,`value`))
+                ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
 -- Table structure for table `opac_news`
 --