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

(-)a/Koha/Schema/Result/Itemtype.pm (-5 / +21 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 84-90 __PACKAGE__->add_columns( Link Here
84
  "description",
96
  "description",
85
  { data_type => "mediumtext", is_nullable => 1 },
97
  { data_type => "mediumtext", is_nullable => 1 },
86
  "rentalcharge",
98
  "rentalcharge",
87
  { data_type => "double precision", is_nullable => 1, size => [16, 4] },
99
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
100
  "defaultreplacecost",
101
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
102
  "processfee",
103
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
88
  "notforloan",
104
  "notforloan",
89
  { data_type => "smallint", is_nullable => 1 },
105
  { data_type => "smallint", is_nullable => 1 },
90
  "imageurl",
106
  "imageurl",
Lines 149-156 __PACKAGE__->might_have( Link Here
149
);
165
);
150
166
151
167
152
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2014-04-28 18:01:17
168
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-04-22 16:14:26
153
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:urVYwhpfBgknZLIhjkqhnw
169
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QLnNg3Vp/n5JwZNXjqOlow
154
170
155
171
156
# You can replace this text with custom content, and it will be preserved on regeneration
172
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/installer/data/mysql/atomicupdate/bug_12768-update_schema_files.sql (+2 lines)
Line 0 Link Here
1
ALTER TABLE `itemtypes` ADD `defaultreplacecost` DECIMAL(28,6) NULL DEFAULT NULL AFTER `rentalcharge`;
2
ALTER TABLE `itemtypes` ADD `processfee` DECIMAL(28,6) NULL DEFAULT NULL AFTER `defaultreplacecost`;
(-)a/installer/data/mysql/kohastructure.sql (-2 / +3 lines)
Lines 1274-1280 DROP TABLE IF EXISTS `itemtypes`; Link Here
1274
CREATE TABLE `itemtypes` ( -- defines the item types
1274
CREATE TABLE `itemtypes` ( -- defines the item types
1275
  itemtype varchar(10) NOT NULL default '', -- unique key, a code associated with the item type
1275
  itemtype varchar(10) NOT NULL default '', -- unique key, a code associated with the item type
1276
  description mediumtext, -- a plain text explanation of the item type
1276
  description mediumtext, -- a plain text explanation of the item type
1277
  rentalcharge double(16,4) default NULL, -- the amount charged when this item is checked out/issued
1277
  rentalcharge decimal(28,6) default NULL, -- the amount charged when this item is checked out/issued
1278
  defaultreplacecost decimal(28,6) default NULL, -- default replacement cost
1279
  processfee decimal(28,6) default NULL, -- default text be recorded in the column note when the processing fee is applied
1278
  notforloan smallint(6) default NULL, -- 1 if the item is not for loan, 0 if the item is available for loan
1280
  notforloan smallint(6) default NULL, -- 1 if the item is not for loan, 0 if the item is available for loan
1279
  imageurl varchar(200) default NULL, -- URL for the item type icon
1281
  imageurl varchar(200) default NULL, -- URL for the item type icon
1280
  summary text, -- information from the summary field, may include HTML
1282
  summary text, -- information from the summary field, may include HTML
1281
- 

Return to bug 12768