Attachment #68035 for bug #12768

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

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_12768-update_schema_files.sql (+3 lines)
	1	ALTER TABLE `itemtypes` MODIFY COLUMN `rentalcharge` DECIMAL(28,6) NULL DEFAULT NULL;
	2	ALTER TABLE `itemtypes` ADD `defaultreplacecost` DECIMAL(28,6) NULL DEFAULT NULL AFTER `rentalcharge`;
	3	ALTER TABLE `itemtypes` ADD `processfee` DECIMAL(28,6) NULL DEFAULT NULL AFTER `defaultreplacecost`;

Lines 982-988 DROP TABLE IF EXISTS `itemtypes`; Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +3 lines)
982	CREATE TABLE `itemtypes` ( -- defines the item types	982	CREATE TABLE `itemtypes` ( -- defines the item types
983	itemtype varchar(10) NOT NULL default '', -- unique key, a code associated with the item type	983	itemtype varchar(10) NOT NULL default '', -- unique key, a code associated with the item type
984	description mediumtext, -- a plain text explanation of the item type	984	description mediumtext, -- a plain text explanation of the item type
985	rentalcharge double(16,4) default NULL, -- the amount charged when this item is checked out/issued	985	rentalcharge decimal(28,6) default NULL, -- the amount charged when this item is checked out/issued
		986	defaultreplacecost decimal(28,6) default NULL, -- default replacement cost
		987	processfee decimal(28,6) default NULL, -- default text be recorded in the column note when the processing fee is applied
986	notforloan smallint(6) default NULL, -- 1 if the item is not for loan, 0 if the item is available for loan	988	notforloan smallint(6) default NULL, -- 1 if the item is not for loan, 0 if the item is available for loan
987	imageurl varchar(200) default NULL, -- URL for the item type icon	989	imageurl varchar(200) default NULL, -- URL for the item type icon
988	summary text, -- information from the summary field, may include HTML	990	summary text, -- information from the summary field, may include HTML
989	-

Return to bug 12768