Lines 4269-4277
CREATE TABLE `circulation_rules` (
Link Here
|
4269 |
-- |
4269 |
-- |
4270 |
|
4270 |
|
4271 |
CREATE TABLE IF NOT EXISTS stockrotationrotas ( |
4271 |
CREATE TABLE IF NOT EXISTS stockrotationrotas ( |
4272 |
rota_id int(11) auto_increment, -- Stockrotation rota ID |
4272 |
rota_id int(11) auto_increment, -- Stockrotation rota ID |
4273 |
title varchar(100) NOT NULL, -- Title for this rota |
4273 |
title varchar(100) NOT NULL, -- Title for this rota |
4274 |
description text NOT NULL default '', -- Description for this rota |
4274 |
description text NOT NULL, -- Description for this rota |
4275 |
cyclical tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling? |
4275 |
cyclical tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling? |
4276 |
active tinyint(1) NOT NULL default 0, -- Is this rota currently active? |
4276 |
active tinyint(1) NOT NULL default 0, -- Is this rota currently active? |
4277 |
PRIMARY KEY (`rota_id`) |
4277 |
PRIMARY KEY (`rota_id`) |