Attachment #87373 for bug #22634

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




-- Table structure for table `stockrotationrotas`
--

DROP TABLE IF EXISTS stockrotationrotas;
CREATE TABLE stockrotationrotas (
    rota_id int(11) auto_increment,         -- Stockrotation rota ID
    title varchar(100) NOT NULL,            -- Title for this rota
    description text NOT NULL,              -- Description for this rota

-- Table structure for table `stockrotationstages`
--

DROP TABLE IF EXISTS stockrotationstages;
CREATE TABLE 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

-- Table structure for table `stockrotationitems`
--

DROP TABLE IF EXISTS stockrotationitems;
CREATE TABLE 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?
- 

Return to bug 22634

Lines 4270-4276 CREATE TABLE `circulation_rules` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-4 / +6 lines)
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	-