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

(-)a/Koha/Schema/Result/Biblio.pm (-2 / +14 lines)
Lines 89-94 __PACKAGE__->table("biblio"); Link Here
89
  data_type: 'longtext'
89
  data_type: 'longtext'
90
  is_nullable: 1
90
  is_nullable: 1
91
91
92
=head2 deleted_at
93
94
  data_type: 'datetime'
95
  datetime_undef_if_invalid: 1
96
  is_nullable: 1
97
92
=cut
98
=cut
93
99
94
__PACKAGE__->add_columns(
100
__PACKAGE__->add_columns(
Lines 121-126 __PACKAGE__->add_columns( Link Here
121
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 0 },
127
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 0 },
122
  "abstract",
128
  "abstract",
123
  { data_type => "longtext", is_nullable => 1 },
129
  { data_type => "longtext", is_nullable => 1 },
130
  "deleted_at",
131
  {
132
    data_type => "datetime",
133
    datetime_undef_if_invalid => 1,
134
    is_nullable => 1,
135
  },
124
);
136
);
125
137
126
=head1 PRIMARY KEY
138
=head1 PRIMARY KEY
Lines 348-354 __PACKAGE__->has_many( Link Here
348
);
360
);
349
361
350
362
351
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
363
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-05-11 12:03:24
352
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bUv00JjY09Hj2Zj4klqyxA
364
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:L2njvoe0LRdIdDsAEaye9w
353
365
354
1;
366
1;
(-)a/Koha/Schema/Result/BiblioMetadata.pm (-2 / +14 lines)
Lines 59-64 __PACKAGE__->table("biblio_metadata"); Link Here
59
  default_value: current_timestamp
59
  default_value: current_timestamp
60
  is_nullable: 0
60
  is_nullable: 0
61
61
62
=head2 deleted_at
63
64
  data_type: 'datetime'
65
  datetime_undef_if_invalid: 1
66
  is_nullable: 1
67
62
=cut
68
=cut
63
69
64
__PACKAGE__->add_columns(
70
__PACKAGE__->add_columns(
Lines 79-84 __PACKAGE__->add_columns( Link Here
79
    default_value => \"current_timestamp",
85
    default_value => \"current_timestamp",
80
    is_nullable => 0,
86
    is_nullable => 0,
81
  },
87
  },
88
  "deleted_at",
89
  {
90
    data_type => "datetime",
91
    datetime_undef_if_invalid => 1,
92
    is_nullable => 1,
93
  },
82
);
94
);
83
95
84
=head1 PRIMARY KEY
96
=head1 PRIMARY KEY
Lines 132-139 __PACKAGE__->belongs_to( Link Here
132
);
144
);
133
145
134
146
135
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-12-07 10:24:45
147
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-05-11 12:03:24
136
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yMvtHn61obhiDDPh7+CIuQ
148
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xEPDWp2+ol9WHDULIaCtOg
137
149
138
150
139
# You can replace this text with custom code or comments, and it will be preserved on regeneration
151
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Biblioitem.pm (-2 / +14 lines)
Lines 202-207 __PACKAGE__->table("biblioitems"); Link Here
202
  data_type: 'integer'
202
  data_type: 'integer'
203
  is_nullable: 1
203
  is_nullable: 1
204
204
205
=head2 deleted_at
206
207
  data_type: 'datetime'
208
  datetime_undef_if_invalid: 1
209
  is_nullable: 1
210
205
=cut
211
=cut
206
212
207
__PACKAGE__->add_columns(
213
__PACKAGE__->add_columns(
Lines 279-284 __PACKAGE__->add_columns( Link Here
279
  { data_type => "varchar", is_nullable => 1, size => 255 },
285
  { data_type => "varchar", is_nullable => 1, size => 255 },
280
  "totalissues",
286
  "totalissues",
281
  { data_type => "integer", is_nullable => 1 },
287
  { data_type => "integer", is_nullable => 1 },
288
  "deleted_at",
289
  {
290
    data_type => "datetime",
291
    datetime_undef_if_invalid => 1,
292
    is_nullable => 1,
293
  },
282
);
294
);
283
295
284
=head1 PRIMARY KEY
296
=head1 PRIMARY KEY
Lines 326-333 __PACKAGE__->has_many( Link Here
326
);
338
);
327
339
328
340
329
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
341
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-05-11 12:03:24
330
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ogVRTKNaUQSI3BE2xC2lww
342
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uvdBu01oA3TCk0mm2jlhPA
331
343
332
__PACKAGE__->belongs_to( biblio => "Koha::Schema::Result::Biblio", "biblionumber" );
344
__PACKAGE__->belongs_to( biblio => "Koha::Schema::Result::Biblio", "biblionumber" );
333
345
(-)a/Koha/Schema/Result/Deletedbiblio.pm (-161 lines)
Lines 1-161 Link Here
1
use utf8;
2
package Koha::Schema::Result::Deletedbiblio;
3
4
# Created by DBIx::Class::Schema::Loader
5
# DO NOT MODIFY THE FIRST PART OF THIS FILE
6
7
=head1 NAME
8
9
Koha::Schema::Result::Deletedbiblio
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<deletedbiblio>
19
20
=cut
21
22
__PACKAGE__->table("deletedbiblio");
23
24
=head1 ACCESSORS
25
26
=head2 biblionumber
27
28
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_nullable: 0
31
32
=head2 frameworkcode
33
34
  data_type: 'varchar'
35
  default_value: (empty string)
36
  is_nullable: 0
37
  size: 4
38
39
=head2 author
40
41
  data_type: 'longtext'
42
  is_nullable: 1
43
44
=head2 title
45
46
  data_type: 'longtext'
47
  is_nullable: 1
48
49
=head2 unititle
50
51
  data_type: 'longtext'
52
  is_nullable: 1
53
54
=head2 notes
55
56
  data_type: 'longtext'
57
  is_nullable: 1
58
59
=head2 serial
60
61
  data_type: 'tinyint'
62
  is_nullable: 1
63
64
=head2 seriestitle
65
66
  data_type: 'longtext'
67
  is_nullable: 1
68
69
=head2 copyrightdate
70
71
  data_type: 'smallint'
72
  is_nullable: 1
73
74
=head2 timestamp
75
76
  data_type: 'timestamp'
77
  datetime_undef_if_invalid: 1
78
  default_value: current_timestamp
79
  is_nullable: 0
80
81
=head2 datecreated
82
83
  data_type: 'date'
84
  datetime_undef_if_invalid: 1
85
  is_nullable: 0
86
87
=head2 abstract
88
89
  data_type: 'longtext'
90
  is_nullable: 1
91
92
=cut
93
94
__PACKAGE__->add_columns(
95
  "biblionumber",
96
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
97
  "frameworkcode",
98
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 4 },
99
  "author",
100
  { data_type => "longtext", is_nullable => 1 },
101
  "title",
102
  { data_type => "longtext", is_nullable => 1 },
103
  "unititle",
104
  { data_type => "longtext", is_nullable => 1 },
105
  "notes",
106
  { data_type => "longtext", is_nullable => 1 },
107
  "serial",
108
  { data_type => "tinyint", is_nullable => 1 },
109
  "seriestitle",
110
  { data_type => "longtext", is_nullable => 1 },
111
  "copyrightdate",
112
  { data_type => "smallint", is_nullable => 1 },
113
  "timestamp",
114
  {
115
    data_type => "timestamp",
116
    datetime_undef_if_invalid => 1,
117
    default_value => \"current_timestamp",
118
    is_nullable => 0,
119
  },
120
  "datecreated",
121
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 0 },
122
  "abstract",
123
  { data_type => "longtext", is_nullable => 1 },
124
);
125
126
=head1 PRIMARY KEY
127
128
=over 4
129
130
=item * L</biblionumber>
131
132
=back
133
134
=cut
135
136
__PACKAGE__->set_primary_key("biblionumber");
137
138
=head1 RELATIONS
139
140
=head2 deletedbiblio_metadatas
141
142
Type: has_many
143
144
Related object: L<Koha::Schema::Result::DeletedbiblioMetadata>
145
146
=cut
147
148
__PACKAGE__->has_many(
149
  "deletedbiblio_metadatas",
150
  "Koha::Schema::Result::DeletedbiblioMetadata",
151
  { "foreign.biblionumber" => "self.biblionumber" },
152
  { cascade_copy => 0, cascade_delete => 0 },
153
);
154
155
156
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
157
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dP0HOIp/+I93Y/u92TDI1g
158
159
160
# You can replace this text with custom content, and it will be preserved on regeneration
161
1;
(-)a/Koha/Schema/Result/DeletedbiblioMetadata.pm (-140 lines)
Lines 1-140 Link Here
1
use utf8;
2
package Koha::Schema::Result::DeletedbiblioMetadata;
3
4
# Created by DBIx::Class::Schema::Loader
5
# DO NOT MODIFY THE FIRST PART OF THIS FILE
6
7
=head1 NAME
8
9
Koha::Schema::Result::DeletedbiblioMetadata
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<deletedbiblio_metadata>
19
20
=cut
21
22
__PACKAGE__->table("deletedbiblio_metadata");
23
24
=head1 ACCESSORS
25
26
=head2 id
27
28
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_nullable: 0
31
32
=head2 biblionumber
33
34
  data_type: 'integer'
35
  is_foreign_key: 1
36
  is_nullable: 0
37
38
=head2 format
39
40
  data_type: 'varchar'
41
  is_nullable: 0
42
  size: 16
43
44
=head2 marcflavour
45
46
  data_type: 'varchar'
47
  is_nullable: 0
48
  size: 16
49
50
=head2 metadata
51
52
  data_type: 'longtext'
53
  is_nullable: 0
54
55
=head2 timestamp
56
57
  data_type: 'timestamp'
58
  datetime_undef_if_invalid: 1
59
  default_value: current_timestamp
60
  is_nullable: 0
61
62
=cut
63
64
__PACKAGE__->add_columns(
65
  "id",
66
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
67
  "biblionumber",
68
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
69
  "format",
70
  { data_type => "varchar", is_nullable => 0, size => 16 },
71
  "marcflavour",
72
  { data_type => "varchar", is_nullable => 0, size => 16 },
73
  "metadata",
74
  { data_type => "longtext", is_nullable => 0 },
75
  "timestamp",
76
  {
77
    data_type => "timestamp",
78
    datetime_undef_if_invalid => 1,
79
    default_value => \"current_timestamp",
80
    is_nullable => 0,
81
  },
82
);
83
84
=head1 PRIMARY KEY
85
86
=over 4
87
88
=item * L</id>
89
90
=back
91
92
=cut
93
94
__PACKAGE__->set_primary_key("id");
95
96
=head1 UNIQUE CONSTRAINTS
97
98
=head2 C<deletedbiblio_metadata_uniq_key>
99
100
=over 4
101
102
=item * L</biblionumber>
103
104
=item * L</format>
105
106
=item * L</marcflavour>
107
108
=back
109
110
=cut
111
112
__PACKAGE__->add_unique_constraint(
113
  "deletedbiblio_metadata_uniq_key",
114
  ["biblionumber", "format", "marcflavour"],
115
);
116
117
=head1 RELATIONS
118
119
=head2 biblionumber
120
121
Type: belongs_to
122
123
Related object: L<Koha::Schema::Result::Deletedbiblio>
124
125
=cut
126
127
__PACKAGE__->belongs_to(
128
  "biblionumber",
129
  "Koha::Schema::Result::Deletedbiblio",
130
  { biblionumber => "biblionumber" },
131
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
132
);
133
134
135
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-12-07 10:24:45
136
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kk2GBiYaECKD+QtnKnycKQ
137
138
139
# You can replace this text with custom code or comments, and it will be preserved on regeneration
140
1;
(-)a/Koha/Schema/Result/Deletedbiblioitem.pm (-296 lines)
Lines 1-296 Link Here
1
use utf8;
2
package Koha::Schema::Result::Deletedbiblioitem;
3
4
# Created by DBIx::Class::Schema::Loader
5
# DO NOT MODIFY THE FIRST PART OF THIS FILE
6
7
=head1 NAME
8
9
Koha::Schema::Result::Deletedbiblioitem
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<deletedbiblioitems>
19
20
=cut
21
22
__PACKAGE__->table("deletedbiblioitems");
23
24
=head1 ACCESSORS
25
26
=head2 biblioitemnumber
27
28
  data_type: 'integer'
29
  default_value: 0
30
  is_nullable: 0
31
32
=head2 biblionumber
33
34
  data_type: 'integer'
35
  default_value: 0
36
  is_nullable: 0
37
38
=head2 volume
39
40
  data_type: 'longtext'
41
  is_nullable: 1
42
43
=head2 number
44
45
  data_type: 'longtext'
46
  is_nullable: 1
47
48
=head2 itemtype
49
50
  data_type: 'varchar'
51
  is_nullable: 1
52
  size: 10
53
54
=head2 isbn
55
56
  data_type: 'longtext'
57
  is_nullable: 1
58
59
=head2 issn
60
61
  data_type: 'longtext'
62
  is_nullable: 1
63
64
=head2 ean
65
66
  data_type: 'longtext'
67
  is_nullable: 1
68
69
=head2 publicationyear
70
71
  data_type: 'mediumtext'
72
  is_nullable: 1
73
74
=head2 publishercode
75
76
  data_type: 'varchar'
77
  is_nullable: 1
78
  size: 255
79
80
=head2 volumedate
81
82
  data_type: 'date'
83
  datetime_undef_if_invalid: 1
84
  is_nullable: 1
85
86
=head2 volumedesc
87
88
  data_type: 'mediumtext'
89
  is_nullable: 1
90
91
=head2 collectiontitle
92
93
  data_type: 'longtext'
94
  is_nullable: 1
95
96
=head2 collectionissn
97
98
  data_type: 'mediumtext'
99
  is_nullable: 1
100
101
=head2 collectionvolume
102
103
  data_type: 'longtext'
104
  is_nullable: 1
105
106
=head2 editionstatement
107
108
  data_type: 'mediumtext'
109
  is_nullable: 1
110
111
=head2 editionresponsibility
112
113
  data_type: 'mediumtext'
114
  is_nullable: 1
115
116
=head2 timestamp
117
118
  data_type: 'timestamp'
119
  datetime_undef_if_invalid: 1
120
  default_value: current_timestamp
121
  is_nullable: 0
122
123
=head2 illus
124
125
  data_type: 'varchar'
126
  is_nullable: 1
127
  size: 255
128
129
=head2 pages
130
131
  data_type: 'varchar'
132
  is_nullable: 1
133
  size: 255
134
135
=head2 notes
136
137
  data_type: 'longtext'
138
  is_nullable: 1
139
140
=head2 size
141
142
  data_type: 'varchar'
143
  is_nullable: 1
144
  size: 255
145
146
=head2 place
147
148
  data_type: 'varchar'
149
  is_nullable: 1
150
  size: 255
151
152
=head2 lccn
153
154
  data_type: 'varchar'
155
  is_nullable: 1
156
  size: 25
157
158
=head2 url
159
160
  data_type: 'mediumtext'
161
  is_nullable: 1
162
163
=head2 cn_source
164
165
  data_type: 'varchar'
166
  is_nullable: 1
167
  size: 10
168
169
=head2 cn_class
170
171
  data_type: 'varchar'
172
  is_nullable: 1
173
  size: 30
174
175
=head2 cn_item
176
177
  data_type: 'varchar'
178
  is_nullable: 1
179
  size: 10
180
181
=head2 cn_suffix
182
183
  data_type: 'varchar'
184
  is_nullable: 1
185
  size: 10
186
187
=head2 cn_sort
188
189
  data_type: 'varchar'
190
  is_nullable: 1
191
  size: 255
192
193
=head2 agerestriction
194
195
  data_type: 'varchar'
196
  is_nullable: 1
197
  size: 255
198
199
=head2 totalissues
200
201
  data_type: 'integer'
202
  is_nullable: 1
203
204
=cut
205
206
__PACKAGE__->add_columns(
207
  "biblioitemnumber",
208
  { data_type => "integer", default_value => 0, is_nullable => 0 },
209
  "biblionumber",
210
  { data_type => "integer", default_value => 0, is_nullable => 0 },
211
  "volume",
212
  { data_type => "longtext", is_nullable => 1 },
213
  "number",
214
  { data_type => "longtext", is_nullable => 1 },
215
  "itemtype",
216
  { data_type => "varchar", is_nullable => 1, size => 10 },
217
  "isbn",
218
  { data_type => "longtext", is_nullable => 1 },
219
  "issn",
220
  { data_type => "longtext", is_nullable => 1 },
221
  "ean",
222
  { data_type => "longtext", is_nullable => 1 },
223
  "publicationyear",
224
  { data_type => "mediumtext", is_nullable => 1 },
225
  "publishercode",
226
  { data_type => "varchar", is_nullable => 1, size => 255 },
227
  "volumedate",
228
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
229
  "volumedesc",
230
  { data_type => "mediumtext", is_nullable => 1 },
231
  "collectiontitle",
232
  { data_type => "longtext", is_nullable => 1 },
233
  "collectionissn",
234
  { data_type => "mediumtext", is_nullable => 1 },
235
  "collectionvolume",
236
  { data_type => "longtext", is_nullable => 1 },
237
  "editionstatement",
238
  { data_type => "mediumtext", is_nullable => 1 },
239
  "editionresponsibility",
240
  { data_type => "mediumtext", is_nullable => 1 },
241
  "timestamp",
242
  {
243
    data_type => "timestamp",
244
    datetime_undef_if_invalid => 1,
245
    default_value => \"current_timestamp",
246
    is_nullable => 0,
247
  },
248
  "illus",
249
  { data_type => "varchar", is_nullable => 1, size => 255 },
250
  "pages",
251
  { data_type => "varchar", is_nullable => 1, size => 255 },
252
  "notes",
253
  { data_type => "longtext", is_nullable => 1 },
254
  "size",
255
  { data_type => "varchar", is_nullable => 1, size => 255 },
256
  "place",
257
  { data_type => "varchar", is_nullable => 1, size => 255 },
258
  "lccn",
259
  { data_type => "varchar", is_nullable => 1, size => 25 },
260
  "url",
261
  { data_type => "mediumtext", is_nullable => 1 },
262
  "cn_source",
263
  { data_type => "varchar", is_nullable => 1, size => 10 },
264
  "cn_class",
265
  { data_type => "varchar", is_nullable => 1, size => 30 },
266
  "cn_item",
267
  { data_type => "varchar", is_nullable => 1, size => 10 },
268
  "cn_suffix",
269
  { data_type => "varchar", is_nullable => 1, size => 10 },
270
  "cn_sort",
271
  { data_type => "varchar", is_nullable => 1, size => 255 },
272
  "agerestriction",
273
  { data_type => "varchar", is_nullable => 1, size => 255 },
274
  "totalissues",
275
  { data_type => "integer", is_nullable => 1 },
276
);
277
278
=head1 PRIMARY KEY
279
280
=over 4
281
282
=item * L</biblioitemnumber>
283
284
=back
285
286
=cut
287
288
__PACKAGE__->set_primary_key("biblioitemnumber");
289
290
291
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
292
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QLYBa1Ea8Jau2Wy6U+wyQw
293
294
295
# You can replace this text with custom content, and it will be preserved on regeneration
296
1;
(-)a/Koha/Schema/Result/Deleteditem.pm (-415 lines)
Lines 1-415 Link Here
1
use utf8;
2
package Koha::Schema::Result::Deleteditem;
3
4
# Created by DBIx::Class::Schema::Loader
5
# DO NOT MODIFY THE FIRST PART OF THIS FILE
6
7
=head1 NAME
8
9
Koha::Schema::Result::Deleteditem
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<deleteditems>
19
20
=cut
21
22
__PACKAGE__->table("deleteditems");
23
24
=head1 ACCESSORS
25
26
=head2 itemnumber
27
28
  data_type: 'integer'
29
  default_value: 0
30
  is_nullable: 0
31
32
=head2 biblionumber
33
34
  data_type: 'integer'
35
  default_value: 0
36
  is_nullable: 0
37
38
=head2 biblioitemnumber
39
40
  data_type: 'integer'
41
  default_value: 0
42
  is_nullable: 0
43
44
=head2 barcode
45
46
  data_type: 'varchar'
47
  is_nullable: 1
48
  size: 20
49
50
=head2 dateaccessioned
51
52
  data_type: 'date'
53
  datetime_undef_if_invalid: 1
54
  is_nullable: 1
55
56
=head2 booksellerid
57
58
  data_type: 'longtext'
59
  is_nullable: 1
60
61
=head2 homebranch
62
63
  data_type: 'varchar'
64
  is_nullable: 1
65
  size: 10
66
67
=head2 price
68
69
  data_type: 'decimal'
70
  is_nullable: 1
71
  size: [8,2]
72
73
=head2 replacementprice
74
75
  data_type: 'decimal'
76
  is_nullable: 1
77
  size: [8,2]
78
79
=head2 replacementpricedate
80
81
  data_type: 'date'
82
  datetime_undef_if_invalid: 1
83
  is_nullable: 1
84
85
=head2 datelastborrowed
86
87
  data_type: 'date'
88
  datetime_undef_if_invalid: 1
89
  is_nullable: 1
90
91
=head2 datelastseen
92
93
  data_type: 'date'
94
  datetime_undef_if_invalid: 1
95
  is_nullable: 1
96
97
=head2 stack
98
99
  data_type: 'tinyint'
100
  is_nullable: 1
101
102
=head2 notforloan
103
104
  data_type: 'tinyint'
105
  default_value: 0
106
  is_nullable: 0
107
108
=head2 damaged
109
110
  data_type: 'tinyint'
111
  default_value: 0
112
  is_nullable: 0
113
114
=head2 damaged_on
115
116
  data_type: 'datetime'
117
  datetime_undef_if_invalid: 1
118
  is_nullable: 1
119
120
=head2 itemlost
121
122
  data_type: 'tinyint'
123
  default_value: 0
124
  is_nullable: 0
125
126
=head2 itemlost_on
127
128
  data_type: 'datetime'
129
  datetime_undef_if_invalid: 1
130
  is_nullable: 1
131
132
=head2 withdrawn
133
134
  data_type: 'tinyint'
135
  default_value: 0
136
  is_nullable: 0
137
138
=head2 withdrawn_on
139
140
  data_type: 'datetime'
141
  datetime_undef_if_invalid: 1
142
  is_nullable: 1
143
144
=head2 itemcallnumber
145
146
  data_type: 'varchar'
147
  is_nullable: 1
148
  size: 255
149
150
=head2 coded_location_qualifier
151
152
  data_type: 'varchar'
153
  is_nullable: 1
154
  size: 10
155
156
=head2 issues
157
158
  data_type: 'smallint'
159
  is_nullable: 1
160
161
=head2 renewals
162
163
  data_type: 'smallint'
164
  is_nullable: 1
165
166
=head2 reserves
167
168
  data_type: 'smallint'
169
  is_nullable: 1
170
171
=head2 restricted
172
173
  data_type: 'tinyint'
174
  is_nullable: 1
175
176
=head2 itemnotes
177
178
  data_type: 'longtext'
179
  is_nullable: 1
180
181
=head2 itemnotes_nonpublic
182
183
  data_type: 'longtext'
184
  is_nullable: 1
185
186
=head2 holdingbranch
187
188
  data_type: 'varchar'
189
  is_nullable: 1
190
  size: 10
191
192
=head2 paidfor
193
194
  data_type: 'longtext'
195
  is_nullable: 1
196
197
=head2 timestamp
198
199
  data_type: 'timestamp'
200
  datetime_undef_if_invalid: 1
201
  default_value: current_timestamp
202
  is_nullable: 0
203
204
=head2 location
205
206
  data_type: 'varchar'
207
  is_nullable: 1
208
  size: 80
209
210
=head2 permanent_location
211
212
  data_type: 'varchar'
213
  is_nullable: 1
214
  size: 80
215
216
=head2 onloan
217
218
  data_type: 'date'
219
  datetime_undef_if_invalid: 1
220
  is_nullable: 1
221
222
=head2 cn_source
223
224
  data_type: 'varchar'
225
  is_nullable: 1
226
  size: 10
227
228
=head2 cn_sort
229
230
  data_type: 'varchar'
231
  is_nullable: 1
232
  size: 255
233
234
=head2 ccode
235
236
  data_type: 'varchar'
237
  is_nullable: 1
238
  size: 10
239
240
=head2 materials
241
242
  data_type: 'mediumtext'
243
  is_nullable: 1
244
245
=head2 uri
246
247
  data_type: 'varchar'
248
  is_nullable: 1
249
  size: 255
250
251
=head2 itype
252
253
  data_type: 'varchar'
254
  is_nullable: 1
255
  size: 10
256
257
=head2 more_subfields_xml
258
259
  data_type: 'longtext'
260
  is_nullable: 1
261
262
=head2 enumchron
263
264
  data_type: 'mediumtext'
265
  is_nullable: 1
266
267
=head2 copynumber
268
269
  data_type: 'varchar'
270
  is_nullable: 1
271
  size: 32
272
273
=head2 stocknumber
274
275
  data_type: 'varchar'
276
  is_nullable: 1
277
  size: 32
278
279
=head2 new_status
280
281
  data_type: 'varchar'
282
  is_nullable: 1
283
  size: 32
284
285
=cut
286
287
__PACKAGE__->add_columns(
288
  "itemnumber",
289
  { data_type => "integer", default_value => 0, is_nullable => 0 },
290
  "biblionumber",
291
  { data_type => "integer", default_value => 0, is_nullable => 0 },
292
  "biblioitemnumber",
293
  { data_type => "integer", default_value => 0, is_nullable => 0 },
294
  "barcode",
295
  { data_type => "varchar", is_nullable => 1, size => 20 },
296
  "dateaccessioned",
297
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
298
  "booksellerid",
299
  { data_type => "longtext", is_nullable => 1 },
300
  "homebranch",
301
  { data_type => "varchar", is_nullable => 1, size => 10 },
302
  "price",
303
  { data_type => "decimal", is_nullable => 1, size => [8, 2] },
304
  "replacementprice",
305
  { data_type => "decimal", is_nullable => 1, size => [8, 2] },
306
  "replacementpricedate",
307
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
308
  "datelastborrowed",
309
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
310
  "datelastseen",
311
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
312
  "stack",
313
  { data_type => "tinyint", is_nullable => 1 },
314
  "notforloan",
315
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
316
  "damaged",
317
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
318
  "damaged_on",
319
  {
320
    data_type => "datetime",
321
    datetime_undef_if_invalid => 1,
322
    is_nullable => 1,
323
  },
324
  "itemlost",
325
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
326
  "itemlost_on",
327
  {
328
    data_type => "datetime",
329
    datetime_undef_if_invalid => 1,
330
    is_nullable => 1,
331
  },
332
  "withdrawn",
333
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
334
  "withdrawn_on",
335
  {
336
    data_type => "datetime",
337
    datetime_undef_if_invalid => 1,
338
    is_nullable => 1,
339
  },
340
  "itemcallnumber",
341
  { data_type => "varchar", is_nullable => 1, size => 255 },
342
  "coded_location_qualifier",
343
  { data_type => "varchar", is_nullable => 1, size => 10 },
344
  "issues",
345
  { data_type => "smallint", is_nullable => 1 },
346
  "renewals",
347
  { data_type => "smallint", is_nullable => 1 },
348
  "reserves",
349
  { data_type => "smallint", is_nullable => 1 },
350
  "restricted",
351
  { data_type => "tinyint", is_nullable => 1 },
352
  "itemnotes",
353
  { data_type => "longtext", is_nullable => 1 },
354
  "itemnotes_nonpublic",
355
  { data_type => "longtext", is_nullable => 1 },
356
  "holdingbranch",
357
  { data_type => "varchar", is_nullable => 1, size => 10 },
358
  "paidfor",
359
  { data_type => "longtext", is_nullable => 1 },
360
  "timestamp",
361
  {
362
    data_type => "timestamp",
363
    datetime_undef_if_invalid => 1,
364
    default_value => \"current_timestamp",
365
    is_nullable => 0,
366
  },
367
  "location",
368
  { data_type => "varchar", is_nullable => 1, size => 80 },
369
  "permanent_location",
370
  { data_type => "varchar", is_nullable => 1, size => 80 },
371
  "onloan",
372
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
373
  "cn_source",
374
  { data_type => "varchar", is_nullable => 1, size => 10 },
375
  "cn_sort",
376
  { data_type => "varchar", is_nullable => 1, size => 255 },
377
  "ccode",
378
  { data_type => "varchar", is_nullable => 1, size => 10 },
379
  "materials",
380
  { data_type => "mediumtext", is_nullable => 1 },
381
  "uri",
382
  { data_type => "varchar", is_nullable => 1, size => 255 },
383
  "itype",
384
  { data_type => "varchar", is_nullable => 1, size => 10 },
385
  "more_subfields_xml",
386
  { data_type => "longtext", is_nullable => 1 },
387
  "enumchron",
388
  { data_type => "mediumtext", is_nullable => 1 },
389
  "copynumber",
390
  { data_type => "varchar", is_nullable => 1, size => 32 },
391
  "stocknumber",
392
  { data_type => "varchar", is_nullable => 1, size => 32 },
393
  "new_status",
394
  { data_type => "varchar", is_nullable => 1, size => 32 },
395
);
396
397
=head1 PRIMARY KEY
398
399
=over 4
400
401
=item * L</itemnumber>
402
403
=back
404
405
=cut
406
407
__PACKAGE__->set_primary_key("itemnumber");
408
409
410
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-18 16:41:11
411
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xb11fPjp5PyXU7yfFWHycw
412
413
414
# You can replace this text with custom content, and it will be preserved on regeneration
415
1;
(-)a/Koha/Schema/Result/Item.pm (-3 / +14 lines)
Lines 286-291 __PACKAGE__->table("items"); Link Here
286
  is_nullable: 1
286
  is_nullable: 1
287
  size: 32
287
  size: 32
288
288
289
=head2 deleted_at
290
291
  data_type: 'datetime'
292
  datetime_undef_if_invalid: 1
293
  is_nullable: 1
294
289
=cut
295
=cut
290
296
291
__PACKAGE__->add_columns(
297
__PACKAGE__->add_columns(
Lines 406-411 __PACKAGE__->add_columns( Link Here
406
  { data_type => "varchar", is_nullable => 1, size => 32 },
412
  { data_type => "varchar", is_nullable => 1, size => 32 },
407
  "new_status",
413
  "new_status",
408
  { data_type => "varchar", is_nullable => 1, size => 32 },
414
  { data_type => "varchar", is_nullable => 1, size => 32 },
415
  "deleted_at",
416
  {
417
    data_type => "datetime",
418
    datetime_undef_if_invalid => 1,
419
    is_nullable => 1,
420
  },
409
);
421
);
410
422
411
=head1 PRIMARY KEY
423
=head1 PRIMARY KEY
Lines 687-694 __PACKAGE__->might_have( Link Here
687
);
699
);
688
700
689
701
690
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-18 16:41:12
702
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-05-11 12:03:24
691
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CrNXvpDUvvcuPZK2Gfzs/Q
703
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sTN/r9L4MvFONFQnopRNrg
692
704
693
__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
705
__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
694
706
695
- 

Return to bug 20271