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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 4247-4255 CREATE TABLE `circulation_rules` ( Link Here
4247
--
4247
--
4248
4248
4249
CREATE TABLE IF NOT EXISTS stockrotationrotas (
4249
CREATE TABLE IF NOT EXISTS stockrotationrotas (
4250
    rota_id int(11) auto_increment,          -- Stockrotation rota ID
4250
    rota_id int(11) auto_increment,         -- Stockrotation rota ID
4251
    title varchar(100) NOT NULL,            -- Title for this rota
4251
    title varchar(100) NOT NULL,            -- Title for this rota
4252
    description text NOT NULL default '',   -- Description for this rota
4252
    description text NOT NULL,              -- Description for this rota
4253
    cyclical tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling?
4253
    cyclical tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling?
4254
    active tinyint(1) NOT NULL default 0,   -- Is this rota currently active?
4254
    active tinyint(1) NOT NULL default 0,   -- Is this rota currently active?
4255
    PRIMARY KEY (`rota_id`)
4255
    PRIMARY KEY (`rota_id`)
(-)a/installer/data/mysql/updatedatabase.pl (-2 / +1 lines)
Lines 16569-16575 if( CheckVersion( $DBversion ) ) { Link Here
16569
          CREATE TABLE `stockrotationrotas` (
16569
          CREATE TABLE `stockrotationrotas` (
16570
            `rota_id` int(11) auto_increment,         -- Stockrotation rota ID
16570
            `rota_id` int(11) auto_increment,         -- Stockrotation rota ID
16571
            `title` varchar(100) NOT NULL,            -- Title for this rota
16571
            `title` varchar(100) NOT NULL,            -- Title for this rota
16572
            `description` text NOT NULL default '',   -- Description for this rota
16572
            `description` text NOT NULL,              -- Description for this rota
16573
            `cyclical` tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling?
16573
            `cyclical` tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling?
16574
            `active` tinyint(1) NOT NULL default 0,   -- Is this rota currently active?
16574
            `active` tinyint(1) NOT NULL default 0,   -- Is this rota currently active?
16575
            PRIMARY KEY (`rota_id`),
16575
            PRIMARY KEY (`rota_id`),
16576
- 

Return to bug 21682