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

(-)a/Koha/Schema/Result/Itemtype.pm (-3 / +19 lines)
Lines 37-45 __PACKAGE__->table("itemtypes"); Link Here
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",
(-)a/installer/data/mysql/atomicupdate/bug_12768-update_schema_files.sql (+3 lines)
Line 0 Link Here
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`;
(-)a/installer/data/mysql/kohastructure.sql (-2 / +3 lines)
Lines 978-984 DROP TABLE IF EXISTS `itemtypes`; Link Here
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