Attachment #74004 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
       (23, 'stockrotation', 'Manage stockrotation operations', 0);

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




      ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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 `illrequestattributes`
--

    UNIQUE KEY title ( title )
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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 608-612 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

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

Lines 21-24 INSERT INTO userflags (bit, flag, flagdesc, defaulton) VALUES Link Here

(-)a/installer/data/mysql/userflags.sql (+1 lines)
21	(21, 'clubs', 'Patron clubs', '0'),	21	(21, 'clubs', 'Patron clubs', '0'),
22	(22,'ill','The Interlibrary Loans Module',0),	22	(22,'ill','The Interlibrary Loans Module',0),
23	(23,'self_check','Self check modules',0)	23	(23,'self_check','Self check modules',0)
		24	(24, 'stockrotation', 'Manage stockrotation operations', 0)
24	;	25	;

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

(-)a/installer/data/mysql/userpermissions.sql (+2 lines)
85	(21, 'enroll', 'Enroll patrons in clubs'),	85	(21, 'enroll', 'Enroll patrons in clubs'),
86	(23, 'self_checkin_module', 'Log into the self check-in module'),	86	(23, 'self_checkin_module', 'Log into the self check-in module'),
87	(23, 'self_checkout_module', 'Perform self checkout at the OPAC. It should be used for the patron matching the AutoSelfCheckID')	87	(23, 'self_checkout_module', 'Perform self checkout at the OPAC. It should be used for the patron matching the AutoSelfCheckID')
		88	(24, 'can_edit_rotas', 'Create, edit and delete rotas'),
		89	(24, 'can_add_items_rotas', 'Add and remove items from rotas')
88	;	90	;

Lines 22-27 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/permissions.inc (+4 lines)
22	[%- CASE 'clubs' -%]<span>Patron clubs</span>	22	[%- CASE 'clubs' -%]<span>Patron clubs</span>
23	[%- CASE 'ill' -%]<span>Create and modify Interlibrary loan requests</span>	23	[%- CASE 'ill' -%]<span>Create and modify Interlibrary loan requests</span>
24	[%- CASE 'self_check' -%]<span>Self check modules</span>	24	[%- CASE 'self_check' -%]<span>Self check modules</span>
		25	[%- CASE 'stockrotation' -%]<span>Manage stockrotation operations</span>
25	[%- END -%]	26	[%- END -%]
26	[%- END -%]	27	[%- END -%]
27		28
Lines 115-118 Link Here
115	[%- CASE 'self_checkin_module' -%]<span>Log into the self check-in module. Note: this permission prevents the patron from using any other OPAC functionality</span>	116	[%- CASE 'self_checkin_module' -%]<span>Log into the self check-in module. Note: this permission prevents the patron from using any other OPAC functionality</span>
116	[%- CASE 'self_checkout_module' -%]<span>Perform self checkout at the OPAC. It should be used for the patron matching the AutoSelfCheckID</span>	117	[%- CASE 'self_checkout_module' -%]<span>Perform self checkout at the OPAC. It should be used for the patron matching the AutoSelfCheckID</span>
117	[%- END -%]	118	[%- END -%]
		119	[%- CASE 'can_add_items_rotas' -%]<span>Add and remove items from rotas</span>
		120	[%- CASE 'can_edit_rotas' -%]<span>Create, edit and delete rotas</span>
		121	[%- END -%]
118	[%- END -%]	122	[%- END -%]




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

Return to bug 11897

Lines 4120-4125 CREATE TABLE illrequests ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (+54 lines)
4120	ON UPDATE CASCADE ON DELETE CASCADE	4120	ON UPDATE CASCADE ON DELETE CASCADE
4121	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;	4121	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4122		4122
		4123	--
		4124	-- Table structure for table `stockrotationrotas`
		4125	--
		4126
		4127	CREATE TABLE IF NOT EXISTS stockrotationrotas (
		4128	rota_id int(11) auto_increment, -- Stockrotation rota ID
		4129	title varchar(100) NOT NULL, -- Title for this rota
		4130	description text NOT NULL default '', -- Description for this rota
		4131	cyclical tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling?
		4132	active tinyint(1) NOT NULL default 0, -- Is this rota currently active?
		4133	PRIMARY KEY (`rota_id`)
		4134	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
		4135
		4136	--
		4137	-- Table structure for table `stockrotationstages`
		4138	--
		4139
		4140	CREATE TABLE IF NOT EXISTS stockrotationstages (
		4141	stage_id int(11) auto_increment, -- Unique stage ID
		4142	position int(11) NOT NULL, -- The position of this stage within its rota
		4143	rota_id int(11) NOT NULL, -- The rota this stage belongs to
		4144	branchcode_id varchar(10) NOT NULL, -- Branch this stage relates to
		4145	duration int(11) NOT NULL default 4, -- The number of days items shoud occupy this stage
		4146	PRIMARY KEY (`stage_id`),
		4147	CONSTRAINT `stockrotationstages_rifk`
		4148	FOREIGN KEY (`rota_id`)
		4149	REFERENCES `stockrotationrotas` (`rota_id`)
		4150	ON UPDATE CASCADE ON DELETE CASCADE,
		4151	CONSTRAINT `stockrotationstages_bifk`
		4152	FOREIGN KEY (`branchcode_id`)
		4153	REFERENCES `branches` (`branchcode`)
		4154	ON UPDATE CASCADE ON DELETE CASCADE
		4155	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
		4156
4123	--	4157	--
4124	-- Table structure for table `illrequestattributes`	4158	-- Table structure for table `illrequestattributes`
4125	--	4159	--
Lines 4158-4163 CREATE TABLE library_groups ( Link Here
4158	UNIQUE KEY title ( title )	4192	UNIQUE KEY title ( title )
4159	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;	4193	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4160		4194
		4195	--
		4196	-- Table structure for table `stockrotationitems`
		4197	--
		4198
		4199	CREATE TABLE IF NOT EXISTS stockrotationitems (
		4200	itemnumber_id int(11) NOT NULL, -- Itemnumber to link to a stage & rota
		4201	stage_id int(11) NOT NULL, -- stage ID to link the item to
		4202	indemand tinyint(1) NOT NULL default 0, -- Should this item be skipped for rotation?
		4203	fresh tinyint(1) NOT NULL default 0, -- Flag showing item is only just added to rota
		4204	PRIMARY KEY (itemnumber_id),
		4205	CONSTRAINT `stockrotationitems_iifk`
		4206	FOREIGN KEY (`itemnumber_id`)
		4207	REFERENCES `items` (`itemnumber`)
		4208	ON UPDATE CASCADE ON DELETE CASCADE,
		4209	CONSTRAINT `stockrotationitems_sifk`
		4210	FOREIGN KEY (`stage_id`)
		4211	REFERENCES `stockrotationstages` (`stage_id`)
		4212	ON UPDATE CASCADE ON DELETE CASCADE
		4213	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
		4214
4161	/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;	4215	/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;
4162	/!40101 SET SQL_MODE=@OLD_SQL_MODE /;	4216	/!40101 SET SQL_MODE=@OLD_SQL_MODE /;
4163	/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;	4217	/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;

Lines 901-906 Circulation: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (-1 / +13 lines)
901	yes: Enable	901	yes: Enable
902	no: Disable	902	no: Disable
903	- "housebound module"	903	- "housebound module"
		904	Stockrotation module:
		905	-
		906	- pref: StockRotation
		907	choices:
		908	yes: Enable
		909	no: Disable
		910	- "the stock rotation module"
		911	-
		912	- pref: RotationPreventTransfers
		913	choices:
		914	yes: Disallow
		915	no: Allow
		916	- "library transfers on items in stockrotation rotas"
904	Article Requests:	917	Article Requests:
905	-	918	-
906	- pref: ArticleRequests	919	- pref: ArticleRequests
907	-

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	(23, 'stockrotation', 'Manage stockrotation operations', 0);
	59
	60	INSERT IGNORE INTO permissions (module_bit, code, description) VALUES
	61	(23, 'can_edit_rotas', 'Create, edit and delete rotas'),
	62	(23, 'can_add_items_rotas', 'Add and remove items from rotas');