Attachment #65737 for bug #11897

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




-- Stock Rotation Rotas

CREATE TABLE IF NOT EXISTS stockrotationrotas (
    rota_id int(11) auto_increment,          -- Stockrotation rota ID
    title varchar(100) NOT NULL,            -- Title for this rota
    description text NOT NULL default '',   -- Description for this rota
    cyclical tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling?
    active tinyint(1) NOT NULL default 0,   -- Is this rota currently active?
    PRIMARY KEY (`rota_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Stock Rotation Stages

CREATE TABLE IF NOT EXISTS 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
    branchcode_id varchar(10) NOT NULL,  -- Branch this stage relates to
    duration int(11) NOT NULL default 4, -- The number of days items shoud occupy this stage
    PRIMARY KEY (`stage_id`),
    CONSTRAINT `stockrotationstages_rifk`
      FOREIGN KEY (`rota_id`)
      REFERENCES `stockrotationrotas` (`rota_id`)
      ON UPDATE CASCADE ON DELETE CASCADE,
    CONSTRAINT `stockrotationstages_bifk`
      FOREIGN KEY (`branchcode_id`)
      REFERENCES `branches` (`branchcode`)
      ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Stock Rotation Items

CREATE TABLE IF NOT EXISTS 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?
    fresh tinyint(1) NOT NULL default 0,    -- Flag showing item is only just added to rota
    PRIMARY KEY (itemnumber_id),
    CONSTRAINT `stockrotationitems_iifk`
      FOREIGN KEY (`itemnumber_id`)
      REFERENCES `items` (`itemnumber`)
      ON UPDATE CASCADE ON DELETE CASCADE,
    CONSTRAINT `stockrotationitems_sifk`
      FOREIGN KEY (`stage_id`)
      REFERENCES `stockrotationstages` (`stage_id`)
      ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- System preferences

INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES
       ('StockRotation','0','If ON, enables the stock rotation module','','YesNo'),
       ('RotationPreventTransfers','0','If ON, prevent any transfers for items on stock rotation rotas, except for stock rotation transfers','','YesNo');

-- Permissions

INSERT IGNORE INTO userflags (bit, flag, flagdesc, defaulton) VALUES
       (21, 'stockrotation', 'Manage stockrotation operations', 0);

INSERT IGNORE INTO permissions (module_bit, code, description) VALUES
       (21, 'can_edit_rotas', 'Create, edit and delete rotas'),
       (21, 'can_add_items_rotas', 'Add and remove items from rotas');




  CONSTRAINT club_fields_ibfk_4 FOREIGN KEY (club_id) REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Table structure for table `stockrotationrotas`
--

CREATE TABLE IF NOT EXISTS stockrotationrotas (
    rota_id int(11) auto_increment,          -- Stockrotation rota ID
    title varchar(100) NOT NULL,            -- Title for this rota
    description text NOT NULL default '',   -- Description for this rota
    cyclical tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling?
    active tinyint(1) NOT NULL default 0,   -- Is this rota currently active?
    PRIMARY KEY (`rota_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Table structure for table `stockrotationstages`
--

CREATE TABLE IF NOT EXISTS 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
    branchcode_id varchar(10) NOT NULL,  -- Branch this stage relates to
    duration int(11) NOT NULL default 4, -- The number of days items shoud occupy this stage
    PRIMARY KEY (`stage_id`),
    CONSTRAINT `stockrotationstages_rifk`
      FOREIGN KEY (`rota_id`)
      REFERENCES `stockrotationrotas` (`rota_id`)
      ON UPDATE CASCADE ON DELETE CASCADE,
    CONSTRAINT `stockrotationstages_bifk`
      FOREIGN KEY (`branchcode_id`)
      REFERENCES `branches` (`branchcode`)
      ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Table structure for table `stockrotationitems`
--

CREATE TABLE IF NOT EXISTS 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?
    fresh tinyint(1) NOT NULL default 0,    -- Flag showing item is only just added to rota
    PRIMARY KEY (itemnumber_id),
    CONSTRAINT `stockrotationitems_iifk`
      FOREIGN KEY (`itemnumber_id`)
      REFERENCES `items` (`itemnumber`)
      ON UPDATE CASCADE ON DELETE CASCADE,
    CONSTRAINT `stockrotationitems_sifk`
      FOREIGN KEY (`stage_id`)
      REFERENCES `stockrotationstages` (`stage_id`)
      ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

Lines 585-589 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/sysprefs.sql (-1 / +3 lines)
585	('XSLTListsDisplay','default','','Enable XSLT stylesheet control over lists pages display on intranet','Free'),	585	('XSLTListsDisplay','default','','Enable XSLT stylesheet control over lists pages display on intranet','Free'),
586	('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),	586	('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),
587	('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),	587	('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
588	('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo')	588	('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo'),
		589	('StockRotation','0',NULL,'If ON, enables the stock rotation module','YesNo'),
		590	('RotationPreventTransfers','0',NULL,'If ON, prevent any transfers for items on stock rotation rotas, except for stock rotation transfers','YesNo')
589	;	591	;

Lines 18-22 INSERT INTO userflags (bit, flag, flagdesc, defaulton) VALUES Link Here

(-)a/installer/data/mysql/userflags.sql (-1 / +2 lines)
18	(18,'coursereserves','Course reserves',0),	18	(18,'coursereserves','Course reserves',0),
19	(19, 'plugins', 'Koha plugins', '0'),	19	(19, 'plugins', 'Koha plugins', '0'),
20	(20, 'lists', 'Lists', 0),	20	(20, 'lists', 'Lists', 0),
21	(21, 'clubs', 'Patron clubs', '0')	21	(21, 'clubs', 'Patron clubs', '0'),
		22	(22, 'stockrotation', 'Manage stockrotation operations', 0)
22	;	23	;

Lines 81-85 INSERT INTO permissions (module_bit, code, description) VALUES Link Here

(-)a/installer/data/mysql/userpermissions.sql (-1 / +3 lines)
81	(20, 'delete_public_lists', 'Delete public lists'),	81	(20, 'delete_public_lists', 'Delete public lists'),
82	(21, 'edit_templates', 'Create and update club templates'),	82	(21, 'edit_templates', 'Create and update club templates'),
83	(21, 'edit_clubs', 'Create and update clubs'),	83	(21, 'edit_clubs', 'Create and update clubs'),
84	(21, 'enroll', 'Enroll patrons in clubs')	84	(21, 'enroll', 'Enroll patrons in clubs'),
		85	(22, 'can_edit_rotas', 'Create, edit and delete rotas'),
		86	(22, 'can_add_items_rotas', 'Add and remove items from rotas')
85	;	87	;

Lines 20-25 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/permissions.inc (+1 lines)
20	[%- CASE 'plugins' -%]<span>Koha plugins</span>	20	[%- CASE 'plugins' -%]<span>Koha plugins</span>
21	[%- CASE 'lists' -%]<span>Lists</span>	21	[%- CASE 'lists' -%]<span>Lists</span>
22	[%- CASE 'clubs' -%]<span>Patron clubs</span>	22	[%- CASE 'clubs' -%]<span>Patron clubs</span>
		23	[%- CASE 'stockrotation' -%]<span>Manage stockrotation operations</span>
23	[%- END -%]	24	[%- END -%]
24	[%- END -%]	25	[%- END -%]
25		26




                  yes: Enable
                  no: Disable
            - "housebound module"
    Stockrotation module:
        -
            - pref: StockRotation
              choices:
                  yes: Enable
                  no: Disable
            - "Enable the stock rotation module"
        -
            - pref: RotationPreventTransfers
              choices:
                  yes: Enable
                  no: Disable
            - "Prevent branchtransfers on items in stockrotation rotas"
    Article Requests:
        -
            - pref: ArticleRequests
- 

Return to bug 11897

Lines 4099-4104 CREATE TABLE IF NOT EXISTS club_fields ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (+54 lines)
4099	CONSTRAINT club_fields_ibfk_4 FOREIGN KEY (club_id) REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE	4099	CONSTRAINT club_fields_ibfk_4 FOREIGN KEY (club_id) REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE
4100	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;	4100	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4101		4101
		4102	--
		4103	-- Table structure for table `stockrotationrotas`
		4104	--
		4105
		4106	CREATE TABLE IF NOT EXISTS stockrotationrotas (
		4107	rota_id int(11) auto_increment, -- Stockrotation rota ID
		4108	title varchar(100) NOT NULL, -- Title for this rota
		4109	description text NOT NULL default '', -- Description for this rota
		4110	cyclical tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling?
		4111	active tinyint(1) NOT NULL default 0, -- Is this rota currently active?
		4112	PRIMARY KEY (`rota_id`)
		4113	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
		4114
		4115	--
		4116	-- Table structure for table `stockrotationstages`
		4117	--
		4118
		4119	CREATE TABLE IF NOT EXISTS stockrotationstages (
		4120	stage_id int(11) auto_increment, -- Unique stage ID
		4121	position int(11) NOT NULL, -- The position of this stage within its rota
		4122	rota_id int(11) NOT NULL, -- The rota this stage belongs to
		4123	branchcode_id varchar(10) NOT NULL, -- Branch this stage relates to
		4124	duration int(11) NOT NULL default 4, -- The number of days items shoud occupy this stage
		4125	PRIMARY KEY (`stage_id`),
		4126	CONSTRAINT `stockrotationstages_rifk`
		4127	FOREIGN KEY (`rota_id`)
		4128	REFERENCES `stockrotationrotas` (`rota_id`)
		4129	ON UPDATE CASCADE ON DELETE CASCADE,
		4130	CONSTRAINT `stockrotationstages_bifk`
		4131	FOREIGN KEY (`branchcode_id`)
		4132	REFERENCES `branches` (`branchcode`)
		4133	ON UPDATE CASCADE ON DELETE CASCADE
		4134	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
		4135
		4136	--
		4137	-- Table structure for table `stockrotationitems`
		4138	--
		4139
		4140	CREATE TABLE IF NOT EXISTS stockrotationitems (
		4141	itemnumber_id int(11) NOT NULL, -- Itemnumber to link to a stage & rota
		4142	stage_id int(11) NOT NULL, -- stage ID to link the item to
		4143	indemand tinyint(1) NOT NULL default 0, -- Should this item be skipped for rotation?
		4144	fresh tinyint(1) NOT NULL default 0, -- Flag showing item is only just added to rota
		4145	PRIMARY KEY (itemnumber_id),
		4146	CONSTRAINT `stockrotationitems_iifk`
		4147	FOREIGN KEY (`itemnumber_id`)
		4148	REFERENCES `items` (`itemnumber`)
		4149	ON UPDATE CASCADE ON DELETE CASCADE,
		4150	CONSTRAINT `stockrotationitems_sifk`
		4151	FOREIGN KEY (`stage_id`)
		4152	REFERENCES `stockrotationstages` (`stage_id`)
		4153	ON UPDATE CASCADE ON DELETE CASCADE
		4154	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
		4155
4102	/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;	4156	/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;
4103	/!40101 SET SQL_MODE=@OLD_SQL_MODE /;	4157	/!40101 SET SQL_MODE=@OLD_SQL_MODE /;
4104	/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;	4158	/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;

Lines 826-831 Circulation: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (-1 / +13 lines)
826	yes: Enable	826	yes: Enable
827	no: Disable	827	no: Disable
828	- "housebound module"	828	- "housebound module"
		829	Stockrotation module:
		830	-
		831	- pref: StockRotation
		832	choices:
		833	yes: Enable
		834	no: Disable
		835	- "Enable the stock rotation module"
		836	-
		837	- pref: RotationPreventTransfers
		838	choices:
		839	yes: Enable
		840	no: Disable
		841	- "Prevent branchtransfers on items in stockrotation rotas"
829	Article Requests:	842	Article Requests:
830	-	843	-
831	- pref: ArticleRequests	844	- pref: ArticleRequests
832	-

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/stockrot_tables.sql (+62 lines)
	1	-- Stock Rotation Rotas
	2
	3	CREATE TABLE IF NOT EXISTS stockrotationrotas (
	4	rota_id int(11) auto_increment, -- Stockrotation rota ID
	5	title varchar(100) NOT NULL, -- Title for this rota
	6	description text NOT NULL default '', -- Description for this rota
	7	cyclical tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling?
	8	active tinyint(1) NOT NULL default 0, -- Is this rota currently active?
	9	PRIMARY KEY (`rota_id`)
	10	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
	11
	12	-- Stock Rotation Stages
	13
	14	CREATE TABLE IF NOT EXISTS stockrotationstages (
	15	stage_id int(11) auto_increment, -- Unique stage ID
	16	position int(11) NOT NULL, -- The position of this stage within its rota
	17	rota_id int(11) NOT NULL, -- The rota this stage belongs to
	18	branchcode_id varchar(10) NOT NULL, -- Branch this stage relates to
	19	duration int(11) NOT NULL default 4, -- The number of days items shoud occupy this stage
	20	PRIMARY KEY (`stage_id`),
	21	CONSTRAINT `stockrotationstages_rifk`
	22	FOREIGN KEY (`rota_id`)
	23	REFERENCES `stockrotationrotas` (`rota_id`)
	24	ON UPDATE CASCADE ON DELETE CASCADE,
	25	CONSTRAINT `stockrotationstages_bifk`
	26	FOREIGN KEY (`branchcode_id`)
	27	REFERENCES `branches` (`branchcode`)
	28	ON UPDATE CASCADE ON DELETE CASCADE
	29	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
	30
	31	-- Stock Rotation Items
	32
	33	CREATE TABLE IF NOT EXISTS stockrotationitems (
	34	itemnumber_id int(11) NOT NULL, -- Itemnumber to link to a stage & rota
	35	stage_id int(11) NOT NULL, -- stage ID to link the item to
	36	indemand tinyint(1) NOT NULL default 0, -- Should this item be skipped for rotation?
	37	fresh tinyint(1) NOT NULL default 0, -- Flag showing item is only just added to rota
	38	PRIMARY KEY (itemnumber_id),
	39	CONSTRAINT `stockrotationitems_iifk`
	40	FOREIGN KEY (`itemnumber_id`)
	41	REFERENCES `items` (`itemnumber`)
	42	ON UPDATE CASCADE ON DELETE CASCADE,
	43	CONSTRAINT `stockrotationitems_sifk`
	44	FOREIGN KEY (`stage_id`)
	45	REFERENCES `stockrotationstages` (`stage_id`)
	46	ON UPDATE CASCADE ON DELETE CASCADE
	47	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
	48
	49	-- System preferences
	50
	51	INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES
	52	('StockRotation','0','If ON, enables the stock rotation module','','YesNo'),
	53	('RotationPreventTransfers','0','If ON, prevent any transfers for items on stock rotation rotas, except for stock rotation transfers','','YesNo');
	54
	55	-- Permissions
	56
	57	INSERT IGNORE INTO userflags (bit, flag, flagdesc, defaulton) VALUES
	58	(21, 'stockrotation', 'Manage stockrotation operations', 0);
	59
	60	INSERT IGNORE INTO permissions (module_bit, code, description) VALUES
	61	(21, 'can_edit_rotas', 'Create, edit and delete rotas'),
	62	(21, 'can_add_items_rotas', 'Add and remove items from rotas');