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`) |