Attachment #66760 for bug #12768

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





=head2 rentalcharge

  data_type: 'decimal'
  is_nullable: 1
  size: [28,6]

=head2 defaultreplacecost

  data_type: 'decimal'
  is_nullable: 1
  size: [28,6]

=head2 processfee

  data_type: 'decimal'
  is_nullable: 1
  size: [28,6]

=head2 notforloan


  "description",
  { data_type => "mediumtext", is_nullable => 1 },
  "rentalcharge",
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
  "defaultreplacecost",
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
  "processfee",
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
  "notforloan",
  { data_type => "smallint", is_nullable => 1 },
  "imageurl",

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_12768-update_schema_files.sql (+3 lines)
	1	ALTER TABLE 'itemtypes' ALTER COLUMN 'rentalcharge' DECIMAL(28,6);
	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 978-984 DROP TABLE IF EXISTS `itemtypes`; Link Here

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

Return to bug 12768

Lines 37-45 __PACKAGE__->table("itemtypes"); Link Here

(-)a/Koha/Schema/Result/Itemtype.pm (-3 / +19 lines)
37		37
38	=head2 rentalcharge	38	=head2 rentalcharge
39		39
40	data_type: 'double precision'	40	data_type: 'decimal'
41	is_nullable: 1	41	is_nullable: 1
42	size: [16,4]	42	size: [28,6]
		43
		44	=head2 defaultreplacecost
		45
		46	data_type: 'decimal'
		47	is_nullable: 1
		48	size: [28,6]
		49
		50	=head2 processfee
		51
		52	data_type: 'decimal'
		53	is_nullable: 1
		54	size: [28,6]
43		55
44	=head2 notforloan	56	=head2 notforloan
45		57
Lines 96-102 __PACKAGE__->add_columns( Link Here
96	"description",	108	"description",
97	{ data_type => "mediumtext", is_nullable => 1 },	109	{ data_type => "mediumtext", is_nullable => 1 },
98	"rentalcharge",	110	"rentalcharge",
99	{ data_type => "double precision", is_nullable => 1, size => [16, 4] },	111	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
		112	"defaultreplacecost",
		113	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
		114	"processfee",
		115	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
100	"notforloan",	116	"notforloan",
101	{ data_type => "smallint", is_nullable => 1 },	117	{ data_type => "smallint", is_nullable => 1 },
102	"imageurl",	118	"imageurl",