View | Details | Raw Unified | Return to bug 22634
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-4 / +6 lines)
Lines 4270-4276 CREATE TABLE `circulation_rules` ( Link Here
4270
-- Table structure for table `stockrotationrotas`
4270
-- Table structure for table `stockrotationrotas`
4271
--
4271
--
4272
4272
4273
CREATE TABLE IF NOT EXISTS stockrotationrotas (
4273
DROP TABLE IF EXISTS stockrotationrotas;
4274
CREATE TABLE stockrotationrotas (
4274
    rota_id int(11) auto_increment,         -- Stockrotation rota ID
4275
    rota_id int(11) auto_increment,         -- Stockrotation rota ID
4275
    title varchar(100) NOT NULL,            -- Title for this rota
4276
    title varchar(100) NOT NULL,            -- Title for this rota
4276
    description text NOT NULL,              -- Description for this rota
4277
    description text NOT NULL,              -- Description for this rota
Lines 4283-4289 CREATE TABLE IF NOT EXISTS stockrotationrotas ( Link Here
4283
-- Table structure for table `stockrotationstages`
4284
-- Table structure for table `stockrotationstages`
4284
--
4285
--
4285
4286
4286
CREATE TABLE IF NOT EXISTS stockrotationstages (
4287
DROP TABLE IF EXISTS stockrotationstages;
4288
CREATE TABLE stockrotationstages (
4287
    stage_id int(11) auto_increment,     -- Unique stage ID
4289
    stage_id int(11) auto_increment,     -- Unique stage ID
4288
    position int(11) NOT NULL,           -- The position of this stage within its rota
4290
    position int(11) NOT NULL,           -- The position of this stage within its rota
4289
    rota_id int(11) NOT NULL,            -- The rota this stage belongs to
4291
    rota_id int(11) NOT NULL,            -- The rota this stage belongs to
Lines 4304-4310 CREATE TABLE IF NOT EXISTS stockrotationstages ( Link Here
4304
-- Table structure for table `stockrotationitems`
4306
-- Table structure for table `stockrotationitems`
4305
--
4307
--
4306
4308
4307
CREATE TABLE IF NOT EXISTS stockrotationitems (
4309
DROP TABLE IF EXISTS stockrotationitems;
4310
CREATE TABLE stockrotationitems (
4308
    itemnumber_id int(11) NOT NULL,         -- Itemnumber to link to a stage & rota
4311
    itemnumber_id int(11) NOT NULL,         -- Itemnumber to link to a stage & rota
4309
    stage_id int(11) NOT NULL,              -- stage ID to link the item to
4312
    stage_id int(11) NOT NULL,              -- stage ID to link the item to
4310
    indemand tinyint(1) NOT NULL default 0, -- Should this item be skipped for rotation?
4313
    indemand tinyint(1) NOT NULL default 0, -- Should this item be skipped for rotation?
4311
- 

Return to bug 22634