Attachment #100645 for bug #24860

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

Lines 46-51 __PACKAGE__->table("old_reserves"); Link Here

(-)a/Koha/Schema/Result/OldReserve.pm (-2 / +30 lines)
46	is_foreign_key: 1	46	is_foreign_key: 1
47	is_nullable: 1	47	is_nullable: 1
48		48
		49	=head2 volume_id
		50
		51	data_type: 'integer'
		52	is_foreign_key: 1
		53	is_nullable: 1
		54
49	=head2 branchcode	55	=head2 branchcode
50		56
51	data_type: 'varchar'	57	data_type: 'varchar'
Lines 154-159 __PACKAGE__->add_columns( Link Here
154	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	160	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
155	"biblionumber",	161	"biblionumber",
156	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },	162	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
		163	"volume_id",
		164	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
157	"branchcode",	165	"branchcode",
158	{ data_type => "varchar", is_nullable => 1, size => 10 },	166	{ data_type => "varchar", is_nullable => 1, size => 10 },
159	"notificationdate",	167	"notificationdate",
Lines 296-304 __PACKAGE__->belongs_to( Link Here
296	},	304	},
297	);	305	);
298		306
		307	=head2 volume
		308
		309	Type: belongs_to
		310
		311	Related object: L<Koha::Schema::Result::Volume>
		312
		313	=cut
		314
		315	__PACKAGE__->belongs_to(
		316	"volume",
		317	"Koha::Schema::Result::Volume",
		318	{ id => "volume_id" },
		319	{
		320	is_deferrable => 1,
		321	join_type => "LEFT",
		322	on_delete => "SET NULL",
		323	on_update => "SET NULL",
		324	},
		325	);
		326
299		327
300	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-06-17 07:24:39	328	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-02-28 13:18:28
301	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZgGAW7ODBby3hGNJ41eeMA	329	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/m1/cy2asQAQbNqcb/45Ug
302		330
303	sub koha_object_class {	331	sub koha_object_class {
304	'Koha::Old::Hold';	332	'Koha::Old::Hold';

Lines 49-54 __PACKAGE__->table("reserves"); Link Here

(-)a/Koha/Schema/Result/Reserve.pm (-2 / +30 lines)
49	is_foreign_key: 1	49	is_foreign_key: 1
50	is_nullable: 0	50	is_nullable: 0
51		51
		52	=head2 volume_id
		53
		54	data_type: 'integer'
		55	is_foreign_key: 1
		56	is_nullable: 1
		57
52	=head2 branchcode	58	=head2 branchcode
53		59
54	data_type: 'varchar'	60	data_type: 'varchar'
Lines 168-173 __PACKAGE__->add_columns( Link Here
168	is_foreign_key => 1,	174	is_foreign_key => 1,
169	is_nullable => 0,	175	is_nullable => 0,
170	},	176	},
		177	"volume_id",
		178	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
171	"branchcode",	179	"branchcode",
172	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },	180	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
173	"notificationdate",	181	"notificationdate",
Lines 335-343 __PACKAGE__->belongs_to( Link Here
335	},	343	},
336	);	344	);
337		345
		346	=head2 volume
		347
		348	Type: belongs_to
		349
		350	Related object: L<Koha::Schema::Result::Volume>
		351
		352	=cut
		353
		354	__PACKAGE__->belongs_to(
		355	"volume",
		356	"Koha::Schema::Result::Volume",
		357	{ id => "volume_id" },
		358	{
		359	is_deferrable => 1,
		360	join_type => "LEFT",
		361	on_delete => "SET NULL",
		362	on_update => "CASCADE",
		363	},
		364	);
		365
338		366
339	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-01 07:08:48	367	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-02-24 11:26:50
340	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Pc5zh5iFbdwko5KS51Y9Uw	368	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZH4g79tek2appBHwdFLn5g
341		369
342	__PACKAGE__->belongs_to(	370	__PACKAGE__->belongs_to(
343	"item",	371	"item",

Lines 36-41 __PACKAGE__->table("volumes"); Link Here

(-)a/Koha/Schema/Result/Volume.pm (-6 / +42 lines)
36	is_foreign_key: 1	36	is_foreign_key: 1
37	is_nullable: 0	37	is_nullable: 0
38		38
		39	=head2 display_order
		40
		41	data_type: 'integer'
		42	default_value: 0
		43	is_nullable: 0
		44
39	=head2 description	45	=head2 description
40		46
41	data_type: 'mediumtext'	47	data_type: 'mediumtext'
Lines 45-52 __PACKAGE__->table("volumes"); Link Here
45		51
46	data_type: 'timestamp'	52	data_type: 'timestamp'
47	datetime_undef_if_invalid: 1	53	datetime_undef_if_invalid: 1
48	default_value: '0000-00-00 00:00:00'	54	is_nullable: 1
49	is_nullable: 0
50		55
51	=head2 updated_on	56	=head2 updated_on
52		57
Lines 67-80 __PACKAGE__->add_columns( Link Here
67	is_foreign_key => 1,	72	is_foreign_key => 1,
68	is_nullable => 0,	73	is_nullable => 0,
69	},	74	},
		75	"display_order",
		76	{ data_type => "integer", default_value => 0, is_nullable => 0 },
70	"description",	77	"description",
71	{ data_type => "mediumtext", is_nullable => 1 },	78	{ data_type => "mediumtext", is_nullable => 1 },
72	"created_on",	79	"created_on",
73	{	80	{
74	data_type => "timestamp",	81	data_type => "timestamp",
75	datetime_undef_if_invalid => 1,	82	datetime_undef_if_invalid => 1,
76	default_value => "0000-00-00 00:00:00",	83	is_nullable => 1,
77	is_nullable => 0,
78	},	84	},
79	"updated_on",	85	"updated_on",
80	{	86	{
Lines 114-119 __PACKAGE__->belongs_to( Link Here
114	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },	120	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
115	);	121	);
116		122
		123	=head2 old_reserves
		124
		125	Type: has_many
		126
		127	Related object: L<Koha::Schema::Result::OldReserve>
		128
		129	=cut
		130
		131	__PACKAGE__->has_many(
		132	"old_reserves",
		133	"Koha::Schema::Result::OldReserve",
		134	{ "foreign.volume_id" => "self.id" },
		135	{ cascade_copy => 0, cascade_delete => 0 },
		136	);
		137
		138	=head2 reserves
		139
		140	Type: has_many
		141
		142	Related object: L<Koha::Schema::Result::Reserve>
		143
		144	=cut
		145
		146	__PACKAGE__->has_many(
		147	"reserves",
		148	"Koha::Schema::Result::Reserve",
		149	{ "foreign.volume_id" => "self.id" },
		150	{ cascade_copy => 0, cascade_delete => 0 },
		151	);
		152
117	=head2 volume_items	153	=head2 volume_items
118		154
119	Type: has_many	155	Type: has_many
Lines 130-137 __PACKAGE__->has_many( Link Here
130	);	166	);
131		167
132		168
133	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-02-04 15:22:18	169	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-02-28 14:28:24
134	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cXvLM2TgY18pxE2ZJBMouw	170	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Qg1AhIgW7n2Ws8rAwdFSpw
135		171
136	sub koha_objects_class {	172	sub koha_objects_class {
137	'Koha::Biblio::Volumes';	173	'Koha::Biblio::Volumes';





__PACKAGE__->set_primary_key("id");

=head1 UNIQUE CONSTRAINTS

=head2 C<volume_id>

=over 4

=item * L</volume_id>

=item * L</itemnumber>

=back

=cut

__PACKAGE__->add_unique_constraint("volume_id", ["volume_id", "itemnumber"]);

=head1 RELATIONS

=head2 itemnumber

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-02-24 11:26:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kKgCjlgDCv3FgqYffaAyng

sub koha_object_class {
    'Koha::Biblio::Volume::Item';
- 

Return to bug 24860

Lines 76-81 __PACKAGE__->add_columns( Link Here

(-)a/Koha/Schema/Result/VolumeItem.pm (-3 / +18 lines)
76		76
77	__PACKAGE__->set_primary_key("id");	77	__PACKAGE__->set_primary_key("id");
78		78
		79	=head1 UNIQUE CONSTRAINTS
		80
		81	=head2 C<volume_id>
		82
		83	=over 4
		84
		85	=item * L</volume_id>
		86
		87	=item * L</itemnumber>
		88
		89	=back
		90
		91	=cut
		92
		93	__PACKAGE__->add_unique_constraint("volume_id", ["volume_id", "itemnumber"]);
		94
79	=head1 RELATIONS	95	=head1 RELATIONS
80		96
81	=head2 itemnumber	97	=head2 itemnumber
Lines 109-116 __PACKAGE__->belongs_to( Link Here
109	);	125	);
110		126
111		127
112	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-02-03 18:25:20	128	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-02-24 11:26:50
113	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:i6YHB4Jq+79kVVYmuurzIQ	129	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kKgCjlgDCv3FgqYffaAyng
114		130
115	sub koha_object_class {	131	sub koha_object_class {
116	'Koha::Biblio::Volume::Item';	132	'Koha::Biblio::Volume::Item';
117	-