Attachment #67875 for bug #12768

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





=head2 ean

  data_type: 'mediumtext'
  is_nullable: 1
  size: 13

=head2 publicationyear


  "issn",
  { data_type => "mediumtext", is_nullable => 1 },
  "ean",
  { data_type => "mediumtext", is_nullable => 1 },
  "publicationyear",
  { data_type => "text", is_nullable => 1 },
  "publishercode",

);


# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-09 20:10:31
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OoIhHLWPdPhj8ebykXpT/w

__PACKAGE__->belongs_to( biblio => "Koha::Schema::Result::Biblio", "biblionumber" );






=head2 ean

  data_type: 'mediumtext'
  is_nullable: 1
  size: 13

=head2 publicationyear


  "issn",
  { data_type => "mediumtext", is_nullable => 1 },
  "ean",
  { data_type => "mediumtext", is_nullable => 1 },
  "publicationyear",
  { data_type => "text", is_nullable => 1 },
  "publishercode",

__PACKAGE__->set_primary_key("biblioitemnumber");


# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-09 20:10:31
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ixfwjOm5GxliepneDBVIPQ


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





=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.07042 @ 2017-10-09 20:12:47
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2VGOeAn5FFZjaY1G4hCD6A

# Use the ItemtypeLocalization view to create the join on localization
our $LANGUAGE;

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

Lines 64-72 __PACKAGE__->table("biblioitems"); Link Here

(-)a/Koha/Schema/Result/Biblioitem.pm (-5 / +4 lines)
64		64
65	=head2 ean	65	=head2 ean
66		66
67	data_type: 'varchar'	67	data_type: 'mediumtext'
68	is_nullable: 1	68	is_nullable: 1
69	size: 13
70		69
71	=head2 publicationyear	70	=head2 publicationyear
72		71
Lines 226-232 __PACKAGE__->add_columns( Link Here
226	"issn",	225	"issn",
227	{ data_type => "mediumtext", is_nullable => 1 },	226	{ data_type => "mediumtext", is_nullable => 1 },
228	"ean",	227	"ean",
229	{ data_type => "varchar", is_nullable => 1, size => 13 },	228	{ data_type => "mediumtext", is_nullable => 1 },
230	"publicationyear",	229	"publicationyear",
231	{ data_type => "text", is_nullable => 1 },	230	{ data_type => "text", is_nullable => 1 },
232	"publishercode",	231	"publishercode",
Lines 327-334 __PACKAGE__->has_many( Link Here
327	);	326	);
328		327
329		328
330	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-01-13 08:36:25	329	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-09 20:10:31
331	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cAlg2aIZ7hxeq+Hgl1AJcA	330	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OoIhHLWPdPhj8ebykXpT/w
332		331
333	__PACKAGE__->belongs_to( biblio => "Koha::Schema::Result::Biblio", "biblionumber" );	332	__PACKAGE__->belongs_to( biblio => "Koha::Schema::Result::Biblio", "biblionumber" );
334		333

Lines 63-71 __PACKAGE__->table("deletedbiblioitems"); Link Here

(-)a/Koha/Schema/Result/Deletedbiblioitem.pm (-5 / +4 lines)
63		63
64	=head2 ean	64	=head2 ean
65		65
66	data_type: 'varchar'	66	data_type: 'mediumtext'
67	is_nullable: 1	67	is_nullable: 1
68	size: 13
69		68
70	=head2 publicationyear	69	=head2 publicationyear
71		70
Lines 220-226 __PACKAGE__->add_columns( Link Here
220	"issn",	219	"issn",
221	{ data_type => "mediumtext", is_nullable => 1 },	220	{ data_type => "mediumtext", is_nullable => 1 },
222	"ean",	221	"ean",
223	{ data_type => "varchar", is_nullable => 1, size => 13 },	222	{ data_type => "mediumtext", is_nullable => 1 },
224	"publicationyear",	223	"publicationyear",
225	{ data_type => "text", is_nullable => 1 },	224	{ data_type => "text", is_nullable => 1 },
226	"publishercode",	225	"publishercode",
Lines 289-296 __PACKAGE__->add_columns( Link Here
289	__PACKAGE__->set_primary_key("biblioitemnumber");	288	__PACKAGE__->set_primary_key("biblioitemnumber");
290		289
291		290
292	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-01-13 08:36:25	291	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-09 20:10:31
293	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZFXb+BlsrsArv8qE2DrkkA	292	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ixfwjOm5GxliepneDBVIPQ
294		293
295		294
296	# You can replace this text with custom content, and it will be preserved on regeneration	295	# You can replace this text with custom content, and it will be preserved on regeneration

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 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",
Lines 195-202 __PACKAGE__->has_many( Link Here
195	);	211	);
196		212
197		213
198	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-04-29 10:32:00	214	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-09 20:12:47
199	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1GiikODklVISOurHX37qjA	215	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2VGOeAn5FFZjaY1G4hCD6A
200		216
201	# Use the ItemtypeLocalization view to create the join on localization	217	# Use the ItemtypeLocalization view to create the join on localization
202	our $LANGUAGE;	218	our $LANGUAGE;