-
Notifications
You must be signed in to change notification settings - Fork 54
/
OldReserve.pm
46 lines (37 loc) · 1.5 KB
/
OldReserve.pm
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
package Koha::Schema::OldReserve;
use strict;
use base qw(Koha::Schema::DB::Object::AutoBase1);
__PACKAGE__->meta->setup(
table => 'old_reserves',
columns => [
reservenumber => { type => 'integer', not_null => 1 },
borrowernumber => { type => 'integer' },
reservedate => { type => 'datetime' },
biblionumber => { type => 'integer' },
constrainttype => { type => 'varchar', length => 1 },
branchcode => { type => 'varchar', length => 10 },
notificationdate => { type => 'date' },
reminderdate => { type => 'date' },
cancellationdate => { type => 'date' },
reservenotes => { type => 'scalar', length => 16777215 },
priority => { type => 'integer' },
found => { type => 'varchar', length => 1 },
timestamp => { type => 'timestamp', not_null => 1 },
itemnumber => { type => 'integer' },
waitingdate => { type => 'date' },
expirationdate => { type => 'date' },
displayexpired => { type => 'integer', default => 1, not_null => 1 },
],
primary_key_columns => [ 'reservenumber' ],
foreign_keys => [
biblio => {
class => 'Koha::Schema::Biblio',
key_columns => { biblionumber => 'biblionumber' },
},
borrower => {
class => 'Koha::Schema::Borrower',
key_columns => { borrowernumber => 'borrowernumber' },
},
],
);
1;