Attachment #63063 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 579-583 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

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

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 4089-4094 CREATE TABLE IF NOT EXISTS club_fields ( Link Here

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

Lines 813-818 Circulation: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (-1 / +13 lines)
813	yes: Enable	813	yes: Enable
814	no: Disable	814	no: Disable
815	- "housebound module"	815	- "housebound module"
		816	Stockrotation module:
		817	-
		818	- pref: StockRotation
		819	choices:
		820	yes: Enable
		821	no: Disable
		822	- "Enable the stock rotation module"
		823	-
		824	- pref: RotationPreventTransfers
		825	choices:
		826	yes: Enable
		827	no: Disable
		828	- "Prevent branchtransfers on items in stockrotation rotas"
816	Article Requests:	829	Article Requests:
817	-	830	-
818	- pref: ArticleRequests	831	- pref: ArticleRequests
819	-

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');