Attachment #38367 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",

);


# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-04-22 16:14:26
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QLnNg3Vp/n5JwZNXjqOlow


# You can replace this text with custom content, and it will be preserved on regeneration

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_12768-update_schema_files.sql (+2 lines)
	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`;

Lines 1269-1275 DROP TABLE IF EXISTS `itemtypes`; Link Here

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

Return to bug 12768

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

(-)a/Koha/Schema/Result/Itemtype.pm (-5 / +21 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 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