X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=installer%2Fdata%2Fmysql%2Fkohastructure.sql;h=f086cbe6aeb143fa89e0c975cfb02e710d34f913;hb=2bcaa4004c2a1e06dc02a342d2950ad7df75ada3;hp=69a7bbf8c4a7a45c4551ce54ff8b489f6edf23d1;hpb=18674cfde322c52fafb3114b397bb1ebe7941b97;p=koha.git

diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 69a7bbf8c4..f086cbe6ae 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -4197,7 +4197,7 @@ CREATE TABLE library_groups (
     description MEDIUMTEXT NULL DEFAULT NULL,    -- Longer explanation of the group, if necessary
     ft_hide_patron_info tinyint(1) NOT NULL DEFAULT 0, -- Turn on the feature "Hide patron's info" for this group
     ft_search_groups_opac tinyint(1) NOT NULL DEFAULT 0, -- Use this group for staff side search groups
-    ft_search_groups_staff tinyint(1) NOT NULL DEFAULT 0, -- Use this group for opac side search groups
+     ft_search_groups_staff tinyint(1) NOT NULL DEFAULT 0, -- Use this group for opac side search groups
     created_on TIMESTAMP NULL,             -- Date and time of creation
     updated_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- Date and time of last
     PRIMARY KEY id ( id ),
@@ -4238,6 +4238,60 @@ CREATE TABLE `circulation_rules` (
   UNIQUE (`branchcode`,`categorycode`,`itemtype`,`rule_name`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 
+--
+-- Table structure for table `stockrotationrotas`
+--
+
+CREATE TABLE IF NOT EXISTS stockrotationrotas (
+    rota_id int(11) auto_increment,          -- Stockrotation rota ID
+    title varchar(100) NOT NULL,            -- Title for this rota
+    description text NOT NULL default '',   -- Description for this rota
+    cyclical tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling?
+    active tinyint(1) NOT NULL default 0,   -- Is this rota currently active?
+    PRIMARY KEY (`rota_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+
+--
+-- Table structure for table `stockrotationstages`
+--
+
+CREATE TABLE IF NOT EXISTS stockrotationstages (
+    stage_id int(11) auto_increment,     -- Unique stage ID
+    position int(11) NOT NULL,           -- The position of this stage within its rota
+    rota_id int(11) NOT NULL,            -- The rota this stage belongs to
+    branchcode_id varchar(10) NOT NULL,  -- Branch this stage relates to
+    duration int(11) NOT NULL default 4, -- The number of days items shoud occupy this stage
+    PRIMARY KEY (`stage_id`),
+    CONSTRAINT `stockrotationstages_rifk`
+      FOREIGN KEY (`rota_id`)
+      REFERENCES `stockrotationrotas` (`rota_id`)
+      ON UPDATE CASCADE ON DELETE CASCADE,
+    CONSTRAINT `stockrotationstages_bifk`
+      FOREIGN KEY (`branchcode_id`)
+      REFERENCES `branches` (`branchcode`)
+      ON UPDATE CASCADE ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+
+--
+-- Table structure for table `stockrotationitems`
+--
+
+CREATE TABLE IF NOT EXISTS stockrotationitems (
+    itemnumber_id int(11) NOT NULL,         -- Itemnumber to link to a stage & rota
+    stage_id int(11) NOT NULL,              -- stage ID to link the item to
+    indemand tinyint(1) NOT NULL default 0, -- Should this item be skipped for rotation?
+    fresh tinyint(1) NOT NULL default 0,    -- Flag showing item is only just added to rota
+    PRIMARY KEY (itemnumber_id),
+    CONSTRAINT `stockrotationitems_iifk`
+      FOREIGN KEY (`itemnumber_id`)
+      REFERENCES `items` (`itemnumber`)
+      ON UPDATE CASCADE ON DELETE CASCADE,
+    CONSTRAINT `stockrotationitems_sifk`
+      FOREIGN KEY (`stage_id`)
+      REFERENCES `stockrotationstages` (`stage_id`)
+      ON UPDATE CASCADE ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;