Attachment #162479 for bug #24718

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

Lines 40-46 foreign key from the borrowers table defining which patron this hold is for Link Here

(-)a/Koha/Schema/Result/OldReserve.pm (-6 / +14 lines)
40		40
41	=head2 reservedate	41	=head2 reservedate
42		42
43	data_type: 'date'	43	data_type: 'datetime'
44	datetime_undef_if_invalid: 1	44	datetime_undef_if_invalid: 1
45	is_nullable: 1	45	is_nullable: 1
46		46
Lines 159-165 the date the item was marked as waiting for the patron at the library Link Here
159		159
160	=head2 expirationdate	160	=head2 expirationdate
161		161
162	data_type: 'date'	162	data_type: 'datetime'
163	datetime_undef_if_invalid: 1	163	datetime_undef_if_invalid: 1
164	is_nullable: 1	164	is_nullable: 1
165		165
Lines 231-237 __PACKAGE__->add_columns( Link Here
231	"borrowernumber",	231	"borrowernumber",
232	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },	232	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
233	"reservedate",	233	"reservedate",
234	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	234	{
		235	data_type => "datetime",
		236	datetime_undef_if_invalid => 1,
		237	is_nullable => 1,
		238	},
235	"biblionumber",	239	"biblionumber",
236	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },	240	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
237	"item_group_id",	241	"item_group_id",
Lines 266-272 __PACKAGE__->add_columns( Link Here
266	"waitingdate",	270	"waitingdate",
267	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	271	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
268	"expirationdate",	272	"expirationdate",
269	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	273	{
		274	data_type => "datetime",
		275	datetime_undef_if_invalid => 1,
		276	is_nullable => 1,
		277	},
270	"patron_expiration_date",	278	"patron_expiration_date",
271	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	279	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
272	"lowestPriority",	280	"lowestPriority",
Lines 407-414 __PACKAGE__->belongs_to( Link Here
407	);	415	);
408		416
409		417
410	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-02-10 14:01:25	418	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-02-27 01:16:31
411	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:evv31XLI36n7e+oYL/hsug	419	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AAF0+7CnidRHohiSb3qAog
412		420
413	__PACKAGE__->belongs_to(	421	__PACKAGE__->belongs_to(
414	"item",	422	"item",

Lines 42-48 foreign key from the borrowers table defining which patron this hold is for Link Here

(-)a/Koha/Schema/Result/Reserve.pm (-7 / +14 lines)
42		42
43	=head2 reservedate	43	=head2 reservedate
44		44
45	data_type: 'date'	45	data_type: 'datetime'
46	datetime_undef_if_invalid: 1	46	datetime_undef_if_invalid: 1
47	is_nullable: 1	47	is_nullable: 1
48		48
Lines 164-170 the date the item was marked as waiting for the patron at the library Link Here
164		164
165	=head2 expirationdate	165	=head2 expirationdate
166		166
167	data_type: 'date'	167	data_type: 'datetime'
168	datetime_undef_if_invalid: 1	168	datetime_undef_if_invalid: 1
169	is_nullable: 1	169	is_nullable: 1
170		170
Lines 235-241 __PACKAGE__->add_columns( Link Here
235	is_nullable => 0,	235	is_nullable => 0,
236	},	236	},
237	"reservedate",	237	"reservedate",
238	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	238	{
		239	data_type => "datetime",
		240	datetime_undef_if_invalid => 1,
		241	is_nullable => 1,
		242	},
239	"biblionumber",	243	"biblionumber",
240	{	244	{
241	data_type => "integer",	245	data_type => "integer",
Lines 275-281 __PACKAGE__->add_columns( Link Here
275	"waitingdate",	279	"waitingdate",
276	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	280	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
277	"expirationdate",	281	"expirationdate",
278	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	282	{
		283	data_type => "datetime",
		284	datetime_undef_if_invalid => 1,
		285	is_nullable => 1,
		286	},
279	"patron_expiration_date",	287	"patron_expiration_date",
280	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	288	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
281	"lowestPriority",	289	"lowestPriority",
Lines 456-463 __PACKAGE__->belongs_to( Link Here
456	);	464	);
457		465
458		466
459	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-11-01 18:21:38	467	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-02-27 01:16:31
460	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6BAjuPSwjtyWJaJN9fcOtg	468	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kASiGJzgrxDCM6fH+arTRw
461		469
462	__PACKAGE__->belongs_to(	470	__PACKAGE__->belongs_to(
463	"item",	471	"item",
464	-

Return to bug 24718