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

(-)a/Koha/Schema/Result/Aqbasket.pm (-3 / +3 lines)
Lines 223-229 __PACKAGE__->belongs_to( Link Here
223
  {
223
  {
224
    is_deferrable => 1,
224
    is_deferrable => 1,
225
    join_type     => "LEFT",
225
    join_type     => "LEFT",
226
    on_delete     => "RESTRICT",
226
    on_delete     => "SET NULL",
227
    on_update     => "CASCADE",
227
    on_update     => "CASCADE",
228
  },
228
  },
229
);
229
);
Lines 309-316 Composing rels: L</aqbasketusers> -> borrowernumber Link Here
309
__PACKAGE__->many_to_many("borrowernumbers", "aqbasketusers", "borrowernumber");
309
__PACKAGE__->many_to_many("borrowernumbers", "aqbasketusers", "borrowernumber");
310
310
311
311
312
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
312
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
313
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gSw/f4JmMBzEssEFRg2fAQ
313
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:j41n7K4Pygo6KvdmRKaggA
314
314
315
315
316
# You can replace this text with custom code or comments, and it will be preserved on regeneration
316
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Aqbasketgroup.pm (-4 / +4 lines)
Lines 66-72 __PACKAGE__->table("aqbasketgroups"); Link Here
66
=head2 billingplace
66
=head2 billingplace
67
67
68
  data_type: 'varchar'
68
  data_type: 'varchar'
69
  is_nullable: 1
69
  is_nullable: 0
70
  size: 10
70
  size: 10
71
71
72
=cut
72
=cut
Lines 87-93 __PACKAGE__->add_columns( Link Here
87
  "deliverycomment",
87
  "deliverycomment",
88
  { data_type => "varchar", is_nullable => 1, size => 255 },
88
  { data_type => "varchar", is_nullable => 1, size => 255 },
89
  "billingplace",
89
  "billingplace",
90
  { data_type => "varchar", is_nullable => 1, size => 10 },
90
  { data_type => "varchar", is_nullable => 0, size => 10 },
91
);
91
);
92
92
93
=head1 PRIMARY KEY
93
=head1 PRIMARY KEY
Lines 135-142 __PACKAGE__->belongs_to( Link Here
135
);
135
);
136
136
137
137
138
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
138
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
139
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9cEWAMwcFKPYPEG1CaaD3w
139
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LE9jdrqhTciPR6UG+PnIXQ
140
140
141
141
142
# You can replace this text with custom content, and it will be preserved on regeneration
142
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Aqbookseller.pm (-13 / +12 lines)
Lines 73-80 __PACKAGE__->table("aqbooksellers"); Link Here
73
=head2 currency
73
=head2 currency
74
74
75
  data_type: 'varchar'
75
  data_type: 'varchar'
76
  default_value: (empty string)
76
  is_nullable: 1
77
  is_nullable: 0
78
  size: 10
77
  size: 10
79
78
80
=head2 booksellerfax
79
=head2 booksellerfax
Lines 142-153 __PACKAGE__->table("aqbooksellers"); Link Here
142
  data_type: 'tinyint'
141
  data_type: 'tinyint'
143
  is_nullable: 1
142
  is_nullable: 1
144
143
145
=head2 tax_rate
146
147
  data_type: 'decimal'
148
  is_nullable: 1
149
  size: [6,4]
150
151
=head2 discount
144
=head2 discount
152
145
153
  data_type: 'float'
146
  data_type: 'float'
Lines 160-165 __PACKAGE__->table("aqbooksellers"); Link Here
160
  is_nullable: 1
153
  is_nullable: 1
161
  size: 50
154
  size: 50
162
155
156
=head2 tax_rate
157
158
  data_type: 'decimal'
159
  is_nullable: 1
160
  size: [6,4]
161
163
=head2 deliverytime
162
=head2 deliverytime
164
163
165
  data_type: 'integer'
164
  data_type: 'integer'
Lines 187-193 __PACKAGE__->add_columns( Link Here
187
  "othersupplier",
186
  "othersupplier",
188
  { data_type => "longtext", is_nullable => 1 },
187
  { data_type => "longtext", is_nullable => 1 },
189
  "currency",
188
  "currency",
190
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
189
  { data_type => "varchar", is_nullable => 1, size => 10 },
191
  "booksellerfax",
190
  "booksellerfax",
192
  { data_type => "longtext", is_nullable => 1 },
191
  { data_type => "longtext", is_nullable => 1 },
193
  "notes",
192
  "notes",
Lines 212-223 __PACKAGE__->add_columns( Link Here
212
  { data_type => "tinyint", is_nullable => 1 },
211
  { data_type => "tinyint", is_nullable => 1 },
213
  "invoiceincgst",
212
  "invoiceincgst",
214
  { data_type => "tinyint", is_nullable => 1 },
213
  { data_type => "tinyint", is_nullable => 1 },
215
  "tax_rate",
216
  { data_type => "decimal", is_nullable => 1, size => [6, 4] },
217
  "discount",
214
  "discount",
218
  { data_type => "float", is_nullable => 1, size => [6, 4] },
215
  { data_type => "float", is_nullable => 1, size => [6, 4] },
219
  "fax",
216
  "fax",
220
  { data_type => "varchar", is_nullable => 1, size => 50 },
217
  { data_type => "varchar", is_nullable => 1, size => 50 },
218
  "tax_rate",
219
  { data_type => "decimal", is_nullable => 1, size => [6, 4] },
221
  "deliverytime",
220
  "deliverytime",
222
  { data_type => "integer", is_nullable => 1 },
221
  { data_type => "integer", is_nullable => 1 },
223
);
222
);
Lines 382-389 __PACKAGE__->has_many( Link Here
382
);
381
);
383
382
384
383
385
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
384
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
386
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DyaF9RbcNAOjPQ1lrxHV3A
385
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:i1MBNQ/K1Rh4wMZDnFCEzw
387
386
388
__PACKAGE__->add_columns(
387
__PACKAGE__->add_columns(
389
    '+active' => { is_boolean => 1 },
388
    '+active' => { is_boolean => 1 },
(-)a/Koha/Schema/Result/Aqbudget.pm (-30 / +51 lines)
Lines 23-44 __PACKAGE__->table("aqbudgets"); Link Here
23
23
24
=head1 ACCESSORS
24
=head1 ACCESSORS
25
25
26
=head2 budget_code
27
28
  data_type: 'varchar'
29
  is_nullable: 1
30
  size: 30
31
32
=head2 budget_amount
33
34
  data_type: 'decimal'
35
  default_value: 0.000000
36
  is_nullable: 0
37
  size: [28,6]
38
26
=head2 budget_id
39
=head2 budget_id
27
40
28
  data_type: 'integer'
41
  data_type: 'integer'
29
  is_auto_increment: 1
42
  is_auto_increment: 1
30
  is_nullable: 0
43
  is_nullable: 0
31
44
32
=head2 budget_parent_id
45
=head2 budget_branchcode
33
46
34
  data_type: 'integer'
47
  data_type: 'varchar'
35
  is_nullable: 1
48
  is_nullable: 1
49
  size: 10
36
50
37
=head2 budget_code
51
=head2 budget_parent_id
38
52
39
  data_type: 'varchar'
53
  data_type: 'integer'
40
  is_nullable: 1
54
  is_nullable: 1
41
  size: 30
42
55
43
=head2 budget_name
56
=head2 budget_name
44
57
Lines 46-64 __PACKAGE__->table("aqbudgets"); Link Here
46
  is_nullable: 1
59
  is_nullable: 1
47
  size: 80
60
  size: 80
48
61
49
=head2 budget_branchcode
50
51
  data_type: 'varchar'
52
  is_nullable: 1
53
  size: 10
54
55
=head2 budget_amount
56
57
  data_type: 'decimal'
58
  default_value: 0.000000
59
  is_nullable: 1
60
  size: [28,6]
61
62
=head2 budget_encumb
62
=head2 budget_encumb
63
63
64
  data_type: 'decimal'
64
  data_type: 'decimal'
Lines 88-93 __PACKAGE__->table("aqbudgets"); Link Here
88
=head2 budget_period_id
88
=head2 budget_period_id
89
89
90
  data_type: 'integer'
90
  data_type: 'integer'
91
  is_foreign_key: 1
91
  is_nullable: 1
92
  is_nullable: 1
92
93
93
=head2 sort1_authcat
94
=head2 sort1_authcat
Lines 116-138 __PACKAGE__->table("aqbudgets"); Link Here
116
=cut
117
=cut
117
118
118
__PACKAGE__->add_columns(
119
__PACKAGE__->add_columns(
119
  "budget_id",
120
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
121
  "budget_parent_id",
122
  { data_type => "integer", is_nullable => 1 },
123
  "budget_code",
120
  "budget_code",
124
  { data_type => "varchar", is_nullable => 1, size => 30 },
121
  { data_type => "varchar", is_nullable => 1, size => 30 },
125
  "budget_name",
126
  { data_type => "varchar", is_nullable => 1, size => 80 },
127
  "budget_branchcode",
128
  { data_type => "varchar", is_nullable => 1, size => 10 },
129
  "budget_amount",
122
  "budget_amount",
130
  {
123
  {
131
    data_type => "decimal",
124
    data_type => "decimal",
132
    default_value => "0.000000",
125
    default_value => "0.000000",
133
    is_nullable => 1,
126
    is_nullable => 0,
134
    size => [28, 6],
127
    size => [28, 6],
135
  },
128
  },
129
  "budget_id",
130
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
131
  "budget_branchcode",
132
  { data_type => "varchar", is_nullable => 1, size => 10 },
133
  "budget_parent_id",
134
  { data_type => "integer", is_nullable => 1 },
135
  "budget_name",
136
  { data_type => "varchar", is_nullable => 1, size => 80 },
136
  "budget_encumb",
137
  "budget_encumb",
137
  {
138
  {
138
    data_type => "decimal",
139
    data_type => "decimal",
Lines 157-163 __PACKAGE__->add_columns( Link Here
157
    is_nullable => 0,
158
    is_nullable => 0,
158
  },
159
  },
159
  "budget_period_id",
160
  "budget_period_id",
160
  { data_type => "integer", is_nullable => 1 },
161
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
161
  "sort1_authcat",
162
  "sort1_authcat",
162
  { data_type => "varchar", is_nullable => 1, size => 80 },
163
  { data_type => "varchar", is_nullable => 1, size => 80 },
163
  "sort2_authcat",
164
  "sort2_authcat",
Lines 257-262 __PACKAGE__->has_many( Link Here
257
  { cascade_copy => 0, cascade_delete => 0 },
258
  { cascade_copy => 0, cascade_delete => 0 },
258
);
259
);
259
260
261
=head2 budget_period
262
263
Type: belongs_to
264
265
Related object: L<Koha::Schema::Result::Aqbudgetperiod>
266
267
=cut
268
269
__PACKAGE__->belongs_to(
270
  "budget_period",
271
  "Koha::Schema::Result::Aqbudgetperiod",
272
  { budget_period_id => "budget_period_id" },
273
  {
274
    is_deferrable => 1,
275
    join_type     => "LEFT",
276
    on_delete     => "CASCADE",
277
    on_update     => "CASCADE",
278
  },
279
);
280
260
=head2 suggestions
281
=head2 suggestions
261
282
262
Type: has_many
283
Type: has_many
Lines 298-305 Composing rels: L</aqbudgetborrowers> -> borrowernumber Link Here
298
__PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber");
319
__PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber");
299
320
300
321
301
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-16 13:50:45
322
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
302
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zB7ox8a4KdDGq5fsbQfLGQ
323
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oAGvpiU7zjOnpWEfpOMmDw
303
324
304
325
305
# You can replace this text with custom content, and it will be preserved on regeneration
326
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Aqbudgetperiod.pm (-10 / +27 lines)
Lines 52-63 __PACKAGE__->table("aqbudgetperiods"); Link Here
52
  data_type: 'longtext'
52
  data_type: 'longtext'
53
  is_nullable: 1
53
  is_nullable: 1
54
54
55
=head2 budget_period_total
56
57
  data_type: 'decimal'
58
  is_nullable: 1
59
  size: [28,6]
60
61
=head2 budget_period_locked
55
=head2 budget_period_locked
62
56
63
  data_type: 'tinyint'
57
  data_type: 'tinyint'
Lines 75-80 __PACKAGE__->table("aqbudgetperiods"); Link Here
75
  is_nullable: 1
69
  is_nullable: 1
76
  size: 10
70
  size: 10
77
71
72
=head2 budget_period_total
73
74
  data_type: 'decimal'
75
  is_nullable: 1
76
  size: [28,6]
77
78
=cut
78
=cut
79
79
80
__PACKAGE__->add_columns(
80
__PACKAGE__->add_columns(
Lines 88-101 __PACKAGE__->add_columns( Link Here
88
  { data_type => "tinyint", default_value => 0, is_nullable => 1 },
88
  { data_type => "tinyint", default_value => 0, is_nullable => 1 },
89
  "budget_period_description",
89
  "budget_period_description",
90
  { data_type => "longtext", is_nullable => 1 },
90
  { data_type => "longtext", is_nullable => 1 },
91
  "budget_period_total",
92
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
93
  "budget_period_locked",
91
  "budget_period_locked",
94
  { data_type => "tinyint", is_nullable => 1 },
92
  { data_type => "tinyint", is_nullable => 1 },
95
  "sort1_authcat",
93
  "sort1_authcat",
96
  { data_type => "varchar", is_nullable => 1, size => 10 },
94
  { data_type => "varchar", is_nullable => 1, size => 10 },
97
  "sort2_authcat",
95
  "sort2_authcat",
98
  { data_type => "varchar", is_nullable => 1, size => 10 },
96
  { data_type => "varchar", is_nullable => 1, size => 10 },
97
  "budget_period_total",
98
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
99
);
99
);
100
100
101
=head1 PRIMARY KEY
101
=head1 PRIMARY KEY
Lines 110-118 __PACKAGE__->add_columns( Link Here
110
110
111
__PACKAGE__->set_primary_key("budget_period_id");
111
__PACKAGE__->set_primary_key("budget_period_id");
112
112
113
=head1 RELATIONS
114
115
=head2 aqbudgets
116
117
Type: has_many
118
119
Related object: L<Koha::Schema::Result::Aqbudget>
120
121
=cut
122
123
__PACKAGE__->has_many(
124
  "aqbudgets",
125
  "Koha::Schema::Result::Aqbudget",
126
  { "foreign.budget_period_id" => "self.budget_period_id" },
127
  { cascade_copy => 0, cascade_delete => 0 },
128
);
129
113
130
114
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
131
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
115
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M13qdhmXgKilais2IFkXFw
132
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:V7R0Zdn1ZrQoRIcib6LUIw
116
133
117
134
118
# You can replace this text with custom content, and it will be preserved on regeneration
135
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Aqinvoice.pm (-24 / +3 lines)
Lines 73-79 __PACKAGE__->table("aqinvoices"); Link Here
73
=head2 message_id
73
=head2 message_id
74
74
75
  data_type: 'integer'
75
  data_type: 'integer'
76
  is_foreign_key: 1
77
  is_nullable: 1
76
  is_nullable: 1
78
77
79
=cut
78
=cut
Lines 96-102 __PACKAGE__->add_columns( Link Here
96
  "shipmentcost_budgetid",
95
  "shipmentcost_budgetid",
97
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
96
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
98
  "message_id",
97
  "message_id",
99
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
98
  { data_type => "integer", is_nullable => 1 },
100
);
99
);
101
100
102
=head1 PRIMARY KEY
101
=head1 PRIMARY KEY
Lines 158-183 __PACKAGE__->belongs_to( Link Here
158
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
157
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
159
);
158
);
160
159
161
=head2 message
162
163
Type: belongs_to
164
165
Related object: L<Koha::Schema::Result::EdifactMessage>
166
167
=cut
168
169
__PACKAGE__->belongs_to(
170
  "message",
171
  "Koha::Schema::Result::EdifactMessage",
172
  { id => "message_id" },
173
  {
174
    is_deferrable => 1,
175
    join_type     => "LEFT",
176
    on_delete     => "SET NULL",
177
    on_update     => "RESTRICT",
178
  },
179
);
180
181
=head2 shipmentcost_budgetid
160
=head2 shipmentcost_budgetid
182
161
183
Type: belongs_to
162
Type: belongs_to
Lines 199-206 __PACKAGE__->belongs_to( Link Here
199
);
178
);
200
179
201
180
202
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-16 13:50:45
181
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
203
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mpdxTbkz/8WInG5Wp4q7Ug
182
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Vt50GepELpI7iE49C9dTJA
204
183
205
184
206
# You can replace this text with custom content, and it will be preserved on regeneration
185
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Aqorder.pm (-34 / +34 lines)
Lines 152-163 __PACKAGE__->table("aqorders"); Link Here
152
  is_nullable: 1
152
  is_nullable: 1
153
  size: [13,2]
153
  size: [13,2]
154
154
155
=head2 replacementprice
156
157
  data_type: 'decimal'
158
  is_nullable: 1
159
  size: [28,6]
160
161
=head2 rrp_tax_excluded
155
=head2 rrp_tax_excluded
162
156
163
  data_type: 'decimal'
157
  data_type: 'decimal'
Lines 230-241 __PACKAGE__->table("aqorders"); Link Here
230
  is_nullable: 1
224
  is_nullable: 1
231
  size: [6,4]
225
  size: [6,4]
232
226
233
=head2 budget_id
234
235
  data_type: 'integer'
236
  is_foreign_key: 1
237
  is_nullable: 0
238
239
=head2 budgetdate
227
=head2 budgetdate
240
228
241
  data_type: 'date'
229
  data_type: 'date'
Lines 254-259 __PACKAGE__->table("aqorders"); Link Here
254
  is_nullable: 1
242
  is_nullable: 1
255
  size: 80
243
  size: 80
256
244
245
=head2 uncertainprice
246
247
  data_type: 'tinyint'
248
  is_nullable: 1
249
250
=head2 budget_id
251
252
  data_type: 'integer'
253
  is_foreign_key: 1
254
  is_nullable: 0
255
257
=head2 sort1_authcat
256
=head2 sort1_authcat
258
257
259
  data_type: 'varchar'
258
  data_type: 'varchar'
Lines 266-276 __PACKAGE__->table("aqorders"); Link Here
266
  is_nullable: 1
265
  is_nullable: 1
267
  size: 10
266
  size: 10
268
267
269
=head2 uncertainprice
270
271
  data_type: 'tinyint'
272
  is_nullable: 1
273
274
=head2 claims_count
268
=head2 claims_count
275
269
276
  data_type: 'integer'
270
  data_type: 'integer'
Lines 283-294 __PACKAGE__->table("aqorders"); Link Here
283
  datetime_undef_if_invalid: 1
277
  datetime_undef_if_invalid: 1
284
  is_nullable: 1
278
  is_nullable: 1
285
279
286
=head2 subscriptionid
287
288
  data_type: 'integer'
289
  is_foreign_key: 1
290
  is_nullable: 1
291
292
=head2 parent_ordernumber
280
=head2 parent_ordernumber
293
281
294
  data_type: 'integer'
282
  data_type: 'integer'
Lines 301-306 __PACKAGE__->table("aqorders"); Link Here
301
  is_nullable: 1
289
  is_nullable: 1
302
  size: 16
290
  size: 16
303
291
292
=head2 subscriptionid
293
294
  data_type: 'integer'
295
  is_foreign_key: 1
296
  is_nullable: 1
297
304
=head2 line_item_id
298
=head2 line_item_id
305
299
306
  data_type: 'varchar'
300
  data_type: 'varchar'
Lines 324-329 __PACKAGE__->table("aqorders"); Link Here
324
  data_type: 'mediumtext'
318
  data_type: 'mediumtext'
325
  is_nullable: 1
319
  is_nullable: 1
326
320
321
=head2 replacementprice
322
323
  data_type: 'decimal'
324
  is_nullable: 1
325
  size: [28,6]
326
327
=cut
327
=cut
328
328
329
__PACKAGE__->add_columns(
329
__PACKAGE__->add_columns(
Lines 376-383 __PACKAGE__->add_columns( Link Here
376
  },
376
  },
377
  "rrp",
377
  "rrp",
378
  { data_type => "decimal", is_nullable => 1, size => [13, 2] },
378
  { data_type => "decimal", is_nullable => 1, size => [13, 2] },
379
  "replacementprice",
380
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
381
  "rrp_tax_excluded",
379
  "rrp_tax_excluded",
382
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
380
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
383
  "rrp_tax_included",
381
  "rrp_tax_included",
Lines 402-427 __PACKAGE__->add_columns( Link Here
402
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
400
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
403
  "discount",
401
  "discount",
404
  { data_type => "float", is_nullable => 1, size => [6, 4] },
402
  { data_type => "float", is_nullable => 1, size => [6, 4] },
405
  "budget_id",
406
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
407
  "budgetdate",
403
  "budgetdate",
408
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
404
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
409
  "sort1",
405
  "sort1",
410
  { data_type => "varchar", is_nullable => 1, size => 80 },
406
  { data_type => "varchar", is_nullable => 1, size => 80 },
411
  "sort2",
407
  "sort2",
412
  { data_type => "varchar", is_nullable => 1, size => 80 },
408
  { data_type => "varchar", is_nullable => 1, size => 80 },
409
  "uncertainprice",
410
  { data_type => "tinyint", is_nullable => 1 },
411
  "budget_id",
412
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
413
  "sort1_authcat",
413
  "sort1_authcat",
414
  { data_type => "varchar", is_nullable => 1, size => 10 },
414
  { data_type => "varchar", is_nullable => 1, size => 10 },
415
  "sort2_authcat",
415
  "sort2_authcat",
416
  { data_type => "varchar", is_nullable => 1, size => 10 },
416
  { data_type => "varchar", is_nullable => 1, size => 10 },
417
  "uncertainprice",
418
  { data_type => "tinyint", is_nullable => 1 },
419
  "claims_count",
417
  "claims_count",
420
  { data_type => "integer", default_value => 0, is_nullable => 1 },
418
  { data_type => "integer", default_value => 0, is_nullable => 1 },
421
  "claimed_date",
419
  "claimed_date",
422
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
420
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
423
  "subscriptionid",
424
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
425
  "parent_ordernumber",
421
  "parent_ordernumber",
426
  { data_type => "integer", is_nullable => 1 },
422
  { data_type => "integer", is_nullable => 1 },
427
  "orderstatus",
423
  "orderstatus",
Lines 431-436 __PACKAGE__->add_columns( Link Here
431
    is_nullable => 1,
427
    is_nullable => 1,
432
    size => 16,
428
    size => 16,
433
  },
429
  },
430
  "subscriptionid",
431
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
434
  "line_item_id",
432
  "line_item_id",
435
  { data_type => "varchar", is_nullable => 1, size => 35 },
433
  { data_type => "varchar", is_nullable => 1, size => 35 },
436
  "suppliers_reference_number",
434
  "suppliers_reference_number",
Lines 439-444 __PACKAGE__->add_columns( Link Here
439
  { data_type => "varchar", is_nullable => 1, size => 3 },
437
  { data_type => "varchar", is_nullable => 1, size => 3 },
440
  "suppliers_report",
438
  "suppliers_report",
441
  { data_type => "mediumtext", is_nullable => 1 },
439
  { data_type => "mediumtext", is_nullable => 1 },
440
  "replacementprice",
441
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
442
);
442
);
443
443
444
=head1 PRIMARY KEY
444
=head1 PRIMARY KEY
Lines 551-557 __PACKAGE__->belongs_to( Link Here
551
    is_deferrable => 1,
551
    is_deferrable => 1,
552
    join_type     => "LEFT",
552
    join_type     => "LEFT",
553
    on_delete     => "SET NULL",
553
    on_delete     => "SET NULL",
554
    on_update     => "CASCADE",
554
    on_update     => "SET NULL",
555
  },
555
  },
556
);
556
);
557
557
Lines 661-668 Composing rels: L</aqorder_users> -> borrowernumber Link Here
661
__PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber");
661
__PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber");
662
662
663
663
664
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-08-31 11:51:37
664
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
665
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GQEXetlivZm7buQohl8m4A
665
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:y7OfxpCVrDFw2JQU4SErew
666
666
667
sub koha_objects_class {
667
sub koha_objects_class {
668
    'Koha::Acquisition::Orders';
668
    'Koha::Acquisition::Orders';
(-)a/Koha/Schema/Result/AuthSubfieldStructure.pm (-5 / +4 lines)
Lines 121-128 __PACKAGE__->table("auth_subfield_structure"); Link Here
121
=head2 frameworkcode
121
=head2 frameworkcode
122
122
123
  data_type: 'varchar'
123
  data_type: 'varchar'
124
  default_value: (empty string)
124
  is_nullable: 1
125
  is_nullable: 0
126
  size: 10
125
  size: 10
127
126
128
=head2 defaultvalue
127
=head2 defaultvalue
Lines 170-176 __PACKAGE__->add_columns( Link Here
170
  "kohafield",
169
  "kohafield",
171
  { data_type => "varchar", default_value => "", is_nullable => 1, size => 45 },
170
  { data_type => "varchar", default_value => "", is_nullable => 1, size => 45 },
172
  "frameworkcode",
171
  "frameworkcode",
173
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
172
  { data_type => "varchar", is_nullable => 1, size => 10 },
174
  "defaultvalue",
173
  "defaultvalue",
175
  { data_type => "mediumtext", is_nullable => 1 },
174
  { data_type => "mediumtext", is_nullable => 1 },
176
);
175
);
Lines 209-216 __PACKAGE__->belongs_to( Link Here
209
);
208
);
210
209
211
210
212
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
211
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
213
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5Prv/DCQk32mTQaqtYhUuA
212
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:htwTatj58OlWarcF1/9pSA
214
213
215
214
216
# You can replace this text with custom content, and it will be preserved on regeneration
215
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/AuthorisedValue.pm (-2 / +17 lines)
Lines 129-137 __PACKAGE__->belongs_to( Link Here
129
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
129
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
130
);
130
);
131
131
132
=head2 illrequests
132
133
133
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-04-26 16:13:07
134
Type: has_many
134
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YwvGOd/jzk71ekWfO56xrw
135
136
Related object: L<Koha::Schema::Result::Illrequest>
137
138
=cut
139
140
__PACKAGE__->has_many(
141
  "illrequests",
142
  "Koha::Schema::Result::Illrequest",
143
  { "foreign.status_alias" => "self.id" },
144
  { cascade_copy => 0, cascade_delete => 0 },
145
);
146
147
148
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
149
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RKwmasD8ufV5zuXcklRE3A
135
150
136
151
137
# You can replace this text with custom code or comments, and it will be preserved on regeneration
152
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/AuthorisedValueCategory.pm (-4 / +3 lines)
Lines 26-32 __PACKAGE__->table("authorised_value_categories"); Link Here
26
=head2 category_name
26
=head2 category_name
27
27
28
  data_type: 'varchar'
28
  data_type: 'varchar'
29
  default_value: (empty string)
30
  is_nullable: 0
29
  is_nullable: 0
31
  size: 32
30
  size: 32
32
31
Lines 34-40 __PACKAGE__->table("authorised_value_categories"); Link Here
34
33
35
__PACKAGE__->add_columns(
34
__PACKAGE__->add_columns(
36
  "category_name",
35
  "category_name",
37
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 32 },
36
  { data_type => "varchar", is_nullable => 0, size => 32 },
38
);
37
);
39
38
40
=head1 PRIMARY KEY
39
=head1 PRIMARY KEY
Lines 97-104 __PACKAGE__->has_many( Link Here
97
);
96
);
98
97
99
98
100
# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-08-30 11:59:31
99
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
101
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6vToj9pUcIv8Jio38rNE4g
100
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mEZUVKQXHKTLVfXoeMHosw
102
101
103
102
104
# You can replace this text with custom code or comments, and it will be preserved on regeneration
103
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Biblio.pm (-2 / +27 lines)
Lines 242-247 __PACKAGE__->has_many( Link Here
242
  { cascade_copy => 0, cascade_delete => 0 },
242
  { cascade_copy => 0, cascade_delete => 0 },
243
);
243
);
244
244
245
=head2 oai_sets_biblios
246
247
Type: has_many
248
249
Related object: L<Koha::Schema::Result::OaiSetsBiblio>
250
251
=cut
252
253
__PACKAGE__->has_many(
254
  "oai_sets_biblios",
255
  "Koha::Schema::Result::OaiSetsBiblio",
256
  { "foreign.biblionumber" => "self.biblionumber" },
257
  { cascade_copy => 0, cascade_delete => 0 },
258
);
259
245
=head2 old_reserves
260
=head2 old_reserves
246
261
247
Type: has_many
262
Type: has_many
Lines 347-354 __PACKAGE__->has_many( Link Here
347
  { cascade_copy => 0, cascade_delete => 0 },
362
  { cascade_copy => 0, cascade_delete => 0 },
348
);
363
);
349
364
365
=head2 sets
366
367
Type: many_to_many
368
369
Composing rels: L</oai_sets_biblios> -> set
370
371
=cut
372
373
__PACKAGE__->many_to_many("sets", "oai_sets_biblios", "set");
374
350
375
351
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
376
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
352
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bUv00JjY09Hj2Zj4klqyxA
377
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:blPsfdnQ/MXZMBtIhnjKJg
353
378
354
1;
379
1;
(-)a/Koha/Schema/Result/Borrower.pm (-24 / +27 lines)
Lines 89-95 __PACKAGE__->table("borrowers"); Link Here
89
89
90
=head2 state
90
=head2 state
91
91
92
  data_type: 'mediumtext'
92
  data_type: 'longtext'
93
  is_nullable: 1
93
  is_nullable: 1
94
94
95
=head2 zipcode
95
=head2 zipcode
Lines 170-176 __PACKAGE__->table("borrowers"); Link Here
170
=head2 B_state
170
=head2 B_state
171
171
172
  accessor: 'b_state'
172
  accessor: 'b_state'
173
  data_type: 'mediumtext'
173
  data_type: 'longtext'
174
  is_nullable: 1
174
  is_nullable: 1
175
175
176
=head2 B_zipcode
176
=head2 B_zipcode
Lines 291-296 __PACKAGE__->table("borrowers"); Link Here
291
  is_nullable: 1
291
  is_nullable: 1
292
  size: 100
292
  size: 100
293
293
294
=head2 ethnicity
295
296
  data_type: 'varchar'
297
  is_nullable: 1
298
  size: 50
299
300
=head2 ethnotes
301
302
  data_type: 'varchar'
303
  is_nullable: 1
304
  size: 255
305
294
=head2 sex
306
=head2 sex
295
307
296
  data_type: 'varchar'
308
  data_type: 'varchar'
Lines 369-375 __PACKAGE__->table("borrowers"); Link Here
369
381
370
=head2 altcontactstate
382
=head2 altcontactstate
371
383
372
  data_type: 'mediumtext'
384
  data_type: 'longtext'
373
  is_nullable: 1
385
  is_nullable: 1
374
386
375
=head2 altcontactzipcode
387
=head2 altcontactzipcode
Lines 425-431 __PACKAGE__->table("borrowers"); Link Here
425
  data_type: 'timestamp'
437
  data_type: 'timestamp'
426
  datetime_undef_if_invalid: 1
438
  datetime_undef_if_invalid: 1
427
  default_value: current_timestamp
439
  default_value: current_timestamp
428
  is_nullable: 0
440
  is_nullable: 1
429
441
430
=head2 lastseen
442
=head2 lastseen
431
443
Lines 443-449 __PACKAGE__->table("borrowers"); Link Here
443
=head2 login_attempts
455
=head2 login_attempts
444
456
445
  data_type: 'integer'
457
  data_type: 'integer'
446
  default_value: 0
447
  is_nullable: 1
458
  is_nullable: 1
448
459
449
=head2 overdrive_auth_token
460
=head2 overdrive_auth_token
Lines 479-485 __PACKAGE__->add_columns( Link Here
479
  "city",
490
  "city",
480
  { data_type => "longtext", is_nullable => 1 },
491
  { data_type => "longtext", is_nullable => 1 },
481
  "state",
492
  "state",
482
  { data_type => "mediumtext", is_nullable => 1 },
493
  { data_type => "longtext", is_nullable => 1 },
483
  "zipcode",
494
  "zipcode",
484
  { data_type => "varchar", is_nullable => 1, size => 25 },
495
  { data_type => "varchar", is_nullable => 1, size => 25 },
485
  "country",
496
  "country",
Lines 522-528 __PACKAGE__->add_columns( Link Here
522
  "B_city",
533
  "B_city",
523
  { accessor => "b_city", data_type => "longtext", is_nullable => 1 },
534
  { accessor => "b_city", data_type => "longtext", is_nullable => 1 },
524
  "B_state",
535
  "B_state",
525
  { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 },
536
  { accessor => "b_state", data_type => "longtext", is_nullable => 1 },
526
  "B_zipcode",
537
  "B_zipcode",
527
  {
538
  {
528
    accessor => "b_zipcode",
539
    accessor => "b_zipcode",
Lines 580-585 __PACKAGE__->add_columns( Link Here
580
  { data_type => "longtext", is_nullable => 1 },
591
  { data_type => "longtext", is_nullable => 1 },
581
  "relationship",
592
  "relationship",
582
  { data_type => "varchar", is_nullable => 1, size => 100 },
593
  { data_type => "varchar", is_nullable => 1, size => 100 },
594
  "ethnicity",
595
  { data_type => "varchar", is_nullable => 1, size => 50 },
596
  "ethnotes",
597
  { data_type => "varchar", is_nullable => 1, size => 255 },
583
  "sex",
598
  "sex",
584
  { data_type => "varchar", is_nullable => 1, size => 1 },
599
  { data_type => "varchar", is_nullable => 1, size => 1 },
585
  "password",
600
  "password",
Lines 607-613 __PACKAGE__->add_columns( Link Here
607
  "altcontactaddress3",
622
  "altcontactaddress3",
608
  { data_type => "varchar", is_nullable => 1, size => 255 },
623
  { data_type => "varchar", is_nullable => 1, size => 255 },
609
  "altcontactstate",
624
  "altcontactstate",
610
  { data_type => "mediumtext", is_nullable => 1 },
625
  { data_type => "longtext", is_nullable => 1 },
611
  "altcontactzipcode",
626
  "altcontactzipcode",
612
  { data_type => "varchar", is_nullable => 1, size => 50 },
627
  { data_type => "varchar", is_nullable => 1, size => 50 },
613
  "altcontactcountry",
628
  "altcontactcountry",
Lines 634-640 __PACKAGE__->add_columns( Link Here
634
    data_type => "timestamp",
649
    data_type => "timestamp",
635
    datetime_undef_if_invalid => 1,
650
    datetime_undef_if_invalid => 1,
636
    default_value => \"current_timestamp",
651
    default_value => \"current_timestamp",
637
    is_nullable => 0,
652
    is_nullable => 1,
638
  },
653
  },
639
  "lastseen",
654
  "lastseen",
640
  {
655
  {
Lines 650-656 __PACKAGE__->add_columns( Link Here
650
    size => 25,
665
    size => 25,
651
  },
666
  },
652
  "login_attempts",
667
  "login_attempts",
653
  { data_type => "integer", default_value => 0, is_nullable => 1 },
668
  { data_type => "integer", is_nullable => 1 },
654
  "overdrive_auth_token",
669
  "overdrive_auth_token",
655
  { data_type => "mediumtext", is_nullable => 1 },
670
  { data_type => "mediumtext", is_nullable => 1 },
656
);
671
);
Lines 681-698 __PACKAGE__->set_primary_key("borrowernumber"); Link Here
681
696
682
__PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]);
697
__PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]);
683
698
684
=head2 C<userid>
685
686
=over 4
687
688
=item * L</userid>
689
690
=back
691
692
=cut
693
694
__PACKAGE__->add_unique_constraint("userid", ["userid"]);
695
696
=head1 RELATIONS
699
=head1 RELATIONS
697
700
698
=head2 accountlines
701
=head2 accountlines
Lines 1431-1438 Composing rels: L</aqorder_users> -> ordernumber Link Here
1431
__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1434
__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1432
1435
1433
1436
1434
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-27 13:16:48
1437
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
1435
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:c3Tb59Kku0Hh+tsVV5eCDg
1438
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kjQnCBqkdXvkJl4NeA+rgQ
1436
1439
1437
__PACKAGE__->belongs_to(
1440
__PACKAGE__->belongs_to(
1438
    "guarantor",
1441
    "guarantor",
(-)a/Koha/Schema/Result/BorrowerAttribute.pm (-2 / +10 lines)
Lines 48-53 __PACKAGE__->table("borrower_attributes"); Link Here
48
  is_nullable: 1
48
  is_nullable: 1
49
  size: 255
49
  size: 255
50
50
51
=head2 password
52
53
  data_type: 'varchar'
54
  is_nullable: 1
55
  size: 64
56
51
=cut
57
=cut
52
58
53
__PACKAGE__->add_columns(
59
__PACKAGE__->add_columns(
Lines 59-64 __PACKAGE__->add_columns( Link Here
59
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 10 },
65
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 10 },
60
  "attribute",
66
  "attribute",
61
  { data_type => "varchar", is_nullable => 1, size => 255 },
67
  { data_type => "varchar", is_nullable => 1, size => 255 },
68
  "password",
69
  { data_type => "varchar", is_nullable => 1, size => 64 },
62
);
70
);
63
71
64
=head1 PRIMARY KEY
72
=head1 PRIMARY KEY
Lines 106-113 __PACKAGE__->belongs_to( Link Here
106
);
114
);
107
115
108
116
109
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-12-08 04:41:27
117
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
110
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:EarETnedFsmRmAAJAUrKGg
118
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0mr7/SGK5wcxA3/hNok5Gg
111
119
112
120
113
# You can replace this text with custom content, and it will be preserved on regeneration
121
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/BorrowerAttributeType.pm (-3 / +32 lines)
Lines 59-64 __PACKAGE__->table("borrower_attribute_types"); Link Here
59
  default_value: 0
59
  default_value: 0
60
  is_nullable: 0
60
  is_nullable: 0
61
61
62
=head2 password_allowed
63
64
  data_type: 'tinyint'
65
  default_value: 0
66
  is_nullable: 0
67
62
=head2 staff_searchable
68
=head2 staff_searchable
63
69
64
  data_type: 'tinyint'
70
  data_type: 'tinyint'
Lines 80-85 __PACKAGE__->table("borrower_attribute_types"); Link Here
80
=head2 category_code
86
=head2 category_code
81
87
82
  data_type: 'varchar'
88
  data_type: 'varchar'
89
  is_foreign_key: 1
83
  is_nullable: 1
90
  is_nullable: 1
84
  size: 10
91
  size: 10
85
92
Lines 105-110 __PACKAGE__->add_columns( Link Here
105
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
112
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
106
  "opac_editable",
113
  "opac_editable",
107
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
114
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
115
  "password_allowed",
116
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
108
  "staff_searchable",
117
  "staff_searchable",
109
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
118
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
110
  "authorised_value_category",
119
  "authorised_value_category",
Lines 112-118 __PACKAGE__->add_columns( Link Here
112
  "display_checkout",
121
  "display_checkout",
113
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
122
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
114
  "category_code",
123
  "category_code",
115
  { data_type => "varchar", is_nullable => 1, size => 10 },
124
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
116
  "class",
125
  "class",
117
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
126
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
118
);
127
);
Lines 161-169 __PACKAGE__->has_many( Link Here
161
  { cascade_copy => 0, cascade_delete => 0 },
170
  { cascade_copy => 0, cascade_delete => 0 },
162
);
171
);
163
172
173
=head2 category_code
174
175
Type: belongs_to
176
177
Related object: L<Koha::Schema::Result::Category>
178
179
=cut
180
181
__PACKAGE__->belongs_to(
182
  "category_code",
183
  "Koha::Schema::Result::Category",
184
  { categorycode => "category_code" },
185
  {
186
    is_deferrable => 1,
187
    join_type     => "LEFT",
188
    on_delete     => "RESTRICT",
189
    on_update     => "RESTRICT",
190
  },
191
);
192
164
193
165
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-25 20:32:12
194
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
166
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gsPR8PuUUZHFUkr3MIbTpw
195
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:c2Iz8s/2wOnRUAeMdx8Dag
167
196
168
197
169
# You can replace this text with custom content, and it will be preserved on regeneration
198
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/BorrowerModification.pm (-2 / +18 lines)
Lines 301-306 __PACKAGE__->table("borrower_modifications"); Link Here
301
  is_nullable: 1
301
  is_nullable: 1
302
  size: 100
302
  size: 100
303
303
304
=head2 ethnicity
305
306
  data_type: 'varchar'
307
  is_nullable: 1
308
  size: 50
309
310
=head2 ethnotes
311
312
  data_type: 'varchar'
313
  is_nullable: 1
314
  size: 255
315
304
=head2 sex
316
=head2 sex
305
317
306
  data_type: 'varchar'
318
  data_type: 'varchar'
Lines 547-552 __PACKAGE__->add_columns( Link Here
547
  { data_type => "longtext", is_nullable => 1 },
559
  { data_type => "longtext", is_nullable => 1 },
548
  "relationship",
560
  "relationship",
549
  { data_type => "varchar", is_nullable => 1, size => 100 },
561
  { data_type => "varchar", is_nullable => 1, size => 100 },
562
  "ethnicity",
563
  { data_type => "varchar", is_nullable => 1, size => 50 },
564
  "ethnotes",
565
  { data_type => "varchar", is_nullable => 1, size => 255 },
550
  "sex",
566
  "sex",
551
  { data_type => "varchar", is_nullable => 1, size => 1 },
567
  { data_type => "varchar", is_nullable => 1, size => 1 },
552
  "password",
568
  "password",
Lines 610-617 __PACKAGE__->add_columns( Link Here
610
__PACKAGE__->set_primary_key("verification_token", "borrowernumber");
626
__PACKAGE__->set_primary_key("verification_token", "borrowernumber");
611
627
612
628
613
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-09-20 13:00:20
629
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
614
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qQ0BWngri+79YvK9S8zZPg
630
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ejtbPFBzRooWpYI6cFZoHg
615
631
616
632
617
# You can replace this text with custom content, and it will be preserved on regeneration
633
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Category.pm (-16 / +39 lines)
Lines 95-100 __PACKAGE__->table("categories"); Link Here
95
  default_value: 0
95
  default_value: 0
96
  is_nullable: 0
96
  is_nullable: 0
97
97
98
=head2 illlimit
99
100
  data_type: 'smallint'
101
  default_value: 0
102
  is_nullable: 1
103
98
=head2 category_type
104
=head2 category_type
99
105
100
  data_type: 'varchar'
106
  data_type: 'varchar'
Lines 102-114 __PACKAGE__->table("categories"); Link Here
102
  is_nullable: 0
108
  is_nullable: 0
103
  size: 1
109
  size: 1
104
110
105
=head2 BlockExpiredPatronOpacActions
106
107
  accessor: 'block_expired_patron_opac_actions'
108
  data_type: 'tinyint'
109
  default_value: -1
110
  is_nullable: 0
111
112
=head2 default_privacy
111
=head2 default_privacy
113
112
114
  data_type: 'enum'
113
  data_type: 'enum'
Lines 123-128 __PACKAGE__->table("categories"); Link Here
123
  is_nullable: 0
122
  is_nullable: 0
124
  size: 7
123
  size: 7
125
124
125
=head2 BlockExpiredPatronOpacActions
126
127
  accessor: 'block_expired_patron_opac_actions'
128
  data_type: 'tinyint'
129
  default_value: -1
130
  is_nullable: 0
131
126
=cut
132
=cut
127
133
128
__PACKAGE__->add_columns(
134
__PACKAGE__->add_columns(
Lines 152-166 __PACKAGE__->add_columns( Link Here
152
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
158
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
153
  "hidelostitems",
159
  "hidelostitems",
154
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
160
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
161
  "illlimit",
162
  { data_type => "smallint", default_value => 0, is_nullable => 1 },
155
  "category_type",
163
  "category_type",
156
  { data_type => "varchar", default_value => "A", is_nullable => 0, size => 1 },
164
  { data_type => "varchar", default_value => "A", is_nullable => 0, size => 1 },
157
  "BlockExpiredPatronOpacActions",
158
  {
159
    accessor      => "block_expired_patron_opac_actions",
160
    data_type     => "tinyint",
161
    default_value => -1,
162
    is_nullable   => 0,
163
  },
164
  "default_privacy",
165
  "default_privacy",
165
  {
166
  {
166
    data_type => "enum",
167
    data_type => "enum",
Lines 175-180 __PACKAGE__->add_columns( Link Here
175
    is_nullable => 0,
176
    is_nullable => 0,
176
    size => 7,
177
    size => 7,
177
  },
178
  },
179
  "BlockExpiredPatronOpacActions",
180
  {
181
    accessor      => "block_expired_patron_opac_actions",
182
    data_type     => "tinyint",
183
    default_value => -1,
184
    is_nullable   => 0,
185
  },
178
);
186
);
179
187
180
=head1 PRIMARY KEY
188
=head1 PRIMARY KEY
Lines 191-196 __PACKAGE__->set_primary_key("categorycode"); Link Here
191
199
192
=head1 RELATIONS
200
=head1 RELATIONS
193
201
202
=head2 borrower_attribute_types
203
204
Type: has_many
205
206
Related object: L<Koha::Schema::Result::BorrowerAttributeType>
207
208
=cut
209
210
__PACKAGE__->has_many(
211
  "borrower_attribute_types",
212
  "Koha::Schema::Result::BorrowerAttributeType",
213
  { "foreign.category_code" => "self.categorycode" },
214
  { cascade_copy => 0, cascade_delete => 0 },
215
);
216
194
=head2 borrower_message_preferences
217
=head2 borrower_message_preferences
195
218
196
Type: has_many
219
Type: has_many
Lines 282-289 __PACKAGE__->might_have( Link Here
282
);
305
);
283
306
284
307
285
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-05 14:29:17
308
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
286
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yvHcgnSv1RXNMXJixVtt0Q
309
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:L6F4lG7nQiXzCz5Eee0mtw
287
310
288
311
289
# You can replace this text with custom content, and it will be preserved on regeneration
312
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/City.pm (-8 / +8 lines)
Lines 42-58 __PACKAGE__->table("cities"); Link Here
42
  is_nullable: 1
42
  is_nullable: 1
43
  size: 100
43
  size: 100
44
44
45
=head2 city_country
45
=head2 city_zipcode
46
46
47
  data_type: 'varchar'
47
  data_type: 'varchar'
48
  is_nullable: 1
48
  is_nullable: 1
49
  size: 100
49
  size: 20
50
50
51
=head2 city_zipcode
51
=head2 city_country
52
52
53
  data_type: 'varchar'
53
  data_type: 'varchar'
54
  is_nullable: 1
54
  is_nullable: 1
55
  size: 20
55
  size: 100
56
56
57
=cut
57
=cut
58
58
Lines 63-72 __PACKAGE__->add_columns( Link Here
63
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },
63
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },
64
  "city_state",
64
  "city_state",
65
  { data_type => "varchar", is_nullable => 1, size => 100 },
65
  { data_type => "varchar", is_nullable => 1, size => 100 },
66
  "city_country",
67
  { data_type => "varchar", is_nullable => 1, size => 100 },
68
  "city_zipcode",
66
  "city_zipcode",
69
  { data_type => "varchar", is_nullable => 1, size => 20 },
67
  { data_type => "varchar", is_nullable => 1, size => 20 },
68
  "city_country",
69
  { data_type => "varchar", is_nullable => 1, size => 100 },
70
);
70
);
71
71
72
=head1 PRIMARY KEY
72
=head1 PRIMARY KEY
Lines 82-89 __PACKAGE__->add_columns( Link Here
82
__PACKAGE__->set_primary_key("cityid");
82
__PACKAGE__->set_primary_key("cityid");
83
83
84
84
85
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
85
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
86
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zEjfS65sp13yF7dH8/ojZQ
86
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aOIpsiZF15Qzurb4NNUZZQ
87
87
88
88
89
# You can replace this text with custom content, and it will be preserved on regeneration
89
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/DefaultCircRule.pm (-4 / +4 lines)
Lines 42-48 __PACKAGE__->table("default_circ_rules"); Link Here
42
42
43
=head2 holdallowed
43
=head2 holdallowed
44
44
45
  data_type: 'integer'
45
  data_type: 'tinyint'
46
  is_nullable: 1
46
  is_nullable: 1
47
47
48
=head2 hold_fulfillment_policy
48
=head2 hold_fulfillment_policy
Lines 73-79 __PACKAGE__->add_columns( Link Here
73
  "maxonsiteissueqty",
73
  "maxonsiteissueqty",
74
  { data_type => "integer", is_nullable => 1 },
74
  { data_type => "integer", is_nullable => 1 },
75
  "holdallowed",
75
  "holdallowed",
76
  { data_type => "integer", is_nullable => 1 },
76
  { data_type => "tinyint", is_nullable => 1 },
77
  "hold_fulfillment_policy",
77
  "hold_fulfillment_policy",
78
  {
78
  {
79
    data_type => "enum",
79
    data_type => "enum",
Lines 98-105 __PACKAGE__->add_columns( Link Here
98
__PACKAGE__->set_primary_key("singleton");
98
__PACKAGE__->set_primary_key("singleton");
99
99
100
100
101
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-04-29 10:32:00
101
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
102
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fqBrj0c9h9c0eBlC0kG51w
102
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ttOioXaCXJKF52QQcOUlOQ
103
103
104
104
105
# You can replace this text with custom content, and it will be preserved on regeneration
105
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Deletedbiblio.pm (-4 / +4 lines)
Lines 26-32 __PACKAGE__->table("deletedbiblio"); Link Here
26
=head2 biblionumber
26
=head2 biblionumber
27
27
28
  data_type: 'integer'
28
  data_type: 'integer'
29
  is_auto_increment: 1
29
  default_value: 0
30
  is_nullable: 0
30
  is_nullable: 0
31
31
32
=head2 frameworkcode
32
=head2 frameworkcode
Lines 93-99 __PACKAGE__->table("deletedbiblio"); Link Here
93
93
94
__PACKAGE__->add_columns(
94
__PACKAGE__->add_columns(
95
  "biblionumber",
95
  "biblionumber",
96
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
96
  { data_type => "integer", default_value => 0, is_nullable => 0 },
97
  "frameworkcode",
97
  "frameworkcode",
98
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 4 },
98
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 4 },
99
  "author",
99
  "author",
Lines 153-160 __PACKAGE__->has_many( Link Here
153
);
153
);
154
154
155
155
156
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
156
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
157
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dP0HOIp/+I93Y/u92TDI1g
157
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xbFngDcDw22QzSI9NgqvtQ
158
158
159
159
160
# You can replace this text with custom content, and it will be preserved on regeneration
160
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Deletedborrower.pm (-18 / +31 lines)
Lines 89-95 __PACKAGE__->table("deletedborrowers"); Link Here
89
89
90
=head2 state
90
=head2 state
91
91
92
  data_type: 'mediumtext'
92
  data_type: 'longtext'
93
  is_nullable: 1
93
  is_nullable: 1
94
94
95
=head2 zipcode
95
=head2 zipcode
Lines 170-176 __PACKAGE__->table("deletedborrowers"); Link Here
170
=head2 B_state
170
=head2 B_state
171
171
172
  accessor: 'b_state'
172
  accessor: 'b_state'
173
  data_type: 'mediumtext'
173
  data_type: 'longtext'
174
  is_nullable: 1
174
  is_nullable: 1
175
175
176
=head2 B_zipcode
176
=head2 B_zipcode
Lines 214-221 __PACKAGE__->table("deletedborrowers"); Link Here
214
=head2 categorycode
214
=head2 categorycode
215
215
216
  data_type: 'varchar'
216
  data_type: 'varchar'
217
  default_value: (empty string)
217
  is_nullable: 1
218
  is_nullable: 0
219
  size: 10
218
  size: 10
220
219
221
=head2 dateenrolled
220
=head2 dateenrolled
Lines 289-294 __PACKAGE__->table("deletedborrowers"); Link Here
289
  is_nullable: 1
288
  is_nullable: 1
290
  size: 100
289
  size: 100
291
290
291
=head2 ethnicity
292
293
  data_type: 'varchar'
294
  is_nullable: 1
295
  size: 50
296
297
=head2 ethnotes
298
299
  data_type: 'varchar'
300
  is_nullable: 1
301
  size: 255
302
292
=head2 sex
303
=head2 sex
293
304
294
  data_type: 'varchar'
305
  data_type: 'varchar'
Lines 367-373 __PACKAGE__->table("deletedborrowers"); Link Here
367
378
368
=head2 altcontactstate
379
=head2 altcontactstate
369
380
370
  data_type: 'mediumtext'
381
  data_type: 'longtext'
371
  is_nullable: 1
382
  is_nullable: 1
372
383
373
=head2 altcontactzipcode
384
=head2 altcontactzipcode
Lines 401-408 __PACKAGE__->table("deletedborrowers"); Link Here
401
=head2 privacy
412
=head2 privacy
402
413
403
  data_type: 'integer'
414
  data_type: 'integer'
404
  default_value: 1
415
  is_nullable: 1
405
  is_nullable: 0
406
416
407
=head2 privacy_guarantor_checkouts
417
=head2 privacy_guarantor_checkouts
408
418
Lines 422-428 __PACKAGE__->table("deletedborrowers"); Link Here
422
  data_type: 'timestamp'
432
  data_type: 'timestamp'
423
  datetime_undef_if_invalid: 1
433
  datetime_undef_if_invalid: 1
424
  default_value: current_timestamp
434
  default_value: current_timestamp
425
  is_nullable: 0
435
  is_nullable: 1
426
436
427
=head2 lastseen
437
=head2 lastseen
428
438
Lines 440-446 __PACKAGE__->table("deletedborrowers"); Link Here
440
=head2 login_attempts
450
=head2 login_attempts
441
451
442
  data_type: 'integer'
452
  data_type: 'integer'
443
  default_value: 0
444
  is_nullable: 1
453
  is_nullable: 1
445
454
446
=head2 overdrive_auth_token
455
=head2 overdrive_auth_token
Lines 476-482 __PACKAGE__->add_columns( Link Here
476
  "city",
485
  "city",
477
  { data_type => "longtext", is_nullable => 1 },
486
  { data_type => "longtext", is_nullable => 1 },
478
  "state",
487
  "state",
479
  { data_type => "mediumtext", is_nullable => 1 },
488
  { data_type => "longtext", is_nullable => 1 },
480
  "zipcode",
489
  "zipcode",
481
  { data_type => "varchar", is_nullable => 1, size => 25 },
490
  { data_type => "varchar", is_nullable => 1, size => 25 },
482
  "country",
491
  "country",
Lines 519-525 __PACKAGE__->add_columns( Link Here
519
  "B_city",
528
  "B_city",
520
  { accessor => "b_city", data_type => "longtext", is_nullable => 1 },
529
  { accessor => "b_city", data_type => "longtext", is_nullable => 1 },
521
  "B_state",
530
  "B_state",
522
  { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 },
531
  { accessor => "b_state", data_type => "longtext", is_nullable => 1 },
523
  "B_zipcode",
532
  "B_zipcode",
524
  {
533
  {
525
    accessor => "b_zipcode",
534
    accessor => "b_zipcode",
Lines 538-544 __PACKAGE__->add_columns( Link Here
538
  "branchcode",
547
  "branchcode",
539
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
548
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
540
  "categorycode",
549
  "categorycode",
541
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
550
  { data_type => "varchar", is_nullable => 1, size => 10 },
542
  "dateenrolled",
551
  "dateenrolled",
543
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
552
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
544
  "dateexpiry",
553
  "dateexpiry",
Lines 565-570 __PACKAGE__->add_columns( Link Here
565
  { data_type => "longtext", is_nullable => 1 },
574
  { data_type => "longtext", is_nullable => 1 },
566
  "relationship",
575
  "relationship",
567
  { data_type => "varchar", is_nullable => 1, size => 100 },
576
  { data_type => "varchar", is_nullable => 1, size => 100 },
577
  "ethnicity",
578
  { data_type => "varchar", is_nullable => 1, size => 50 },
579
  "ethnotes",
580
  { data_type => "varchar", is_nullable => 1, size => 255 },
568
  "sex",
581
  "sex",
569
  { data_type => "varchar", is_nullable => 1, size => 1 },
582
  { data_type => "varchar", is_nullable => 1, size => 1 },
570
  "password",
583
  "password",
Lines 592-598 __PACKAGE__->add_columns( Link Here
592
  "altcontactaddress3",
605
  "altcontactaddress3",
593
  { data_type => "varchar", is_nullable => 1, size => 255 },
606
  { data_type => "varchar", is_nullable => 1, size => 255 },
594
  "altcontactstate",
607
  "altcontactstate",
595
  { data_type => "mediumtext", is_nullable => 1 },
608
  { data_type => "longtext", is_nullable => 1 },
596
  "altcontactzipcode",
609
  "altcontactzipcode",
597
  { data_type => "varchar", is_nullable => 1, size => 50 },
610
  { data_type => "varchar", is_nullable => 1, size => 50 },
598
  "altcontactcountry",
611
  "altcontactcountry",
Lines 604-610 __PACKAGE__->add_columns( Link Here
604
  "sms_provider_id",
617
  "sms_provider_id",
605
  { data_type => "integer", is_nullable => 1 },
618
  { data_type => "integer", is_nullable => 1 },
606
  "privacy",
619
  "privacy",
607
  { data_type => "integer", default_value => 1, is_nullable => 0 },
620
  { data_type => "integer", is_nullable => 1 },
608
  "privacy_guarantor_checkouts",
621
  "privacy_guarantor_checkouts",
609
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
622
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
610
  "checkprevcheckout",
623
  "checkprevcheckout",
Lines 619-625 __PACKAGE__->add_columns( Link Here
619
    data_type => "timestamp",
632
    data_type => "timestamp",
620
    datetime_undef_if_invalid => 1,
633
    datetime_undef_if_invalid => 1,
621
    default_value => \"current_timestamp",
634
    default_value => \"current_timestamp",
622
    is_nullable => 0,
635
    is_nullable => 1,
623
  },
636
  },
624
  "lastseen",
637
  "lastseen",
625
  {
638
  {
Lines 635-648 __PACKAGE__->add_columns( Link Here
635
    size => 25,
648
    size => 25,
636
  },
649
  },
637
  "login_attempts",
650
  "login_attempts",
638
  { data_type => "integer", default_value => 0, is_nullable => 1 },
651
  { data_type => "integer", is_nullable => 1 },
639
  "overdrive_auth_token",
652
  "overdrive_auth_token",
640
  { data_type => "mediumtext", is_nullable => 1 },
653
  { data_type => "mediumtext", is_nullable => 1 },
641
);
654
);
642
655
643
656
644
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
657
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
645
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DNkNHNcv0lkMH6/seu89hg
658
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BEq3IZzmy8La8NnwPCbV1Q
646
659
647
660
648
# You can replace this text with custom code or comments, and it will be preserved on regeneration
661
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Deleteditem.pm (-2 / +18 lines)
Lines 276-281 __PACKAGE__->table("deleteditems"); Link Here
276
  is_nullable: 1
276
  is_nullable: 1
277
  size: 32
277
  size: 32
278
278
279
stores the inventory number of deleted items
280
279
=head2 new_status
281
=head2 new_status
280
282
281
  data_type: 'varchar'
283
  data_type: 'varchar'
Lines 406-414 __PACKAGE__->add_columns( Link Here
406
408
407
__PACKAGE__->set_primary_key("itemnumber");
409
__PACKAGE__->set_primary_key("itemnumber");
408
410
411
=head1 UNIQUE CONSTRAINTS
412
413
=head2 C<deleteditemsstocknumberidx>
414
415
=over 4
416
417
=item * L</stocknumber>
418
419
=back
420
421
=cut
422
423
__PACKAGE__->add_unique_constraint("deleteditemsstocknumberidx", ["stocknumber"]);
424
409
425
410
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-09-26 16:15:09
426
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
411
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:L7G0HG5gvgyhfpKb7LcUFw
427
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lvAfwRdG2uylRDO5dxJEdQ
412
428
413
429
414
# You can replace this text with custom content, and it will be preserved on regeneration
430
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/EdifactMessage.pm (-23 / +8 lines)
Lines 119-139 __PACKAGE__->set_primary_key("id"); Link Here
119
119
120
=head1 RELATIONS
120
=head1 RELATIONS
121
121
122
=head2 aqinvoices
123
124
Type: has_many
125
126
Related object: L<Koha::Schema::Result::Aqinvoice>
127
128
=cut
129
130
__PACKAGE__->has_many(
131
  "aqinvoices",
132
  "Koha::Schema::Result::Aqinvoice",
133
  { "foreign.message_id" => "self.id" },
134
  { cascade_copy => 0, cascade_delete => 0 },
135
);
136
137
=head2 basketno
122
=head2 basketno
138
123
139
Type: belongs_to
124
Type: belongs_to
Lines 149-156 __PACKAGE__->belongs_to( Link Here
149
  {
134
  {
150
    is_deferrable => 1,
135
    is_deferrable => 1,
151
    join_type     => "LEFT",
136
    join_type     => "LEFT",
152
    on_delete     => "CASCADE",
137
    on_delete     => "RESTRICT",
153
    on_update     => "CASCADE",
138
    on_update     => "RESTRICT",
154
  },
139
  },
155
);
140
);
156
141
Lines 169-176 __PACKAGE__->belongs_to( Link Here
169
  {
154
  {
170
    is_deferrable => 1,
155
    is_deferrable => 1,
171
    join_type     => "LEFT",
156
    join_type     => "LEFT",
172
    on_delete     => "CASCADE",
157
    on_delete     => "RESTRICT",
173
    on_update     => "CASCADE",
158
    on_update     => "RESTRICT",
174
  },
159
  },
175
);
160
);
176
161
Lines 189-202 __PACKAGE__->belongs_to( Link Here
189
  {
174
  {
190
    is_deferrable => 1,
175
    is_deferrable => 1,
191
    join_type     => "LEFT",
176
    join_type     => "LEFT",
192
    on_delete     => "CASCADE",
177
    on_delete     => "RESTRICT",
193
    on_update     => "CASCADE",
178
    on_update     => "RESTRICT",
194
  },
179
  },
195
);
180
);
196
181
197
182
198
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
183
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
199
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JHUEsQ+kXjGTRxxc2FFSjQ
184
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:f90XogVNxT1OZtN5s02KAQ
200
185
201
186
202
1;
187
1;
(-)a/Koha/Schema/Result/Ethnicity.pm (+66 lines)
Line 0 Link Here
1
use utf8;
2
package Koha::Schema::Result::Ethnicity;
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::Ethnicity
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<ethnicity>
19
20
=cut
21
22
__PACKAGE__->table("ethnicity");
23
24
=head1 ACCESSORS
25
26
=head2 code
27
28
  data_type: 'varchar'
29
  default_value: (empty string)
30
  is_nullable: 0
31
  size: 10
32
33
=head2 name
34
35
  data_type: 'varchar'
36
  is_nullable: 1
37
  size: 255
38
39
=cut
40
41
__PACKAGE__->add_columns(
42
  "code",
43
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
44
  "name",
45
  { data_type => "varchar", is_nullable => 1, size => 255 },
46
);
47
48
=head1 PRIMARY KEY
49
50
=over 4
51
52
=item * L</code>
53
54
=back
55
56
=cut
57
58
__PACKAGE__->set_primary_key("code");
59
60
61
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
62
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Qu8cssBwlX7MIpoFZ6Xvlg
63
64
65
# You can replace this text with custom code or comments, and it will be preserved on regeneration
66
1;
(-)a/Koha/Schema/Result/Housebound.pm (+122 lines)
Line 0 Link Here
1
use utf8;
2
package Koha::Schema::Result::Housebound;
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::Housebound
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<housebound>
19
20
=cut
21
22
__PACKAGE__->table("housebound");
23
24
=head1 ACCESSORS
25
26
=head2 hbnumber
27
28
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_nullable: 0
31
32
=head2 day
33
34
  data_type: 'mediumtext'
35
  is_nullable: 0
36
37
=head2 frequency
38
39
  data_type: 'mediumtext'
40
  is_nullable: 1
41
42
=head2 borrowernumber
43
44
  data_type: 'integer'
45
  is_nullable: 1
46
47
=head2 Itype_quant
48
49
  accessor: 'itype_quant'
50
  data_type: 'varchar'
51
  is_nullable: 1
52
  size: 10
53
54
=head2 Item_subject
55
56
  accessor: 'item_subject'
57
  data_type: 'mediumtext'
58
  is_nullable: 1
59
60
=head2 Item_authors
61
62
  accessor: 'item_authors'
63
  data_type: 'mediumtext'
64
  is_nullable: 1
65
66
=head2 referral
67
68
  data_type: 'mediumtext'
69
  is_nullable: 1
70
71
=head2 notes
72
73
  data_type: 'mediumtext'
74
  is_nullable: 1
75
76
=cut
77
78
__PACKAGE__->add_columns(
79
  "hbnumber",
80
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
81
  "day",
82
  { data_type => "mediumtext", is_nullable => 0 },
83
  "frequency",
84
  { data_type => "mediumtext", is_nullable => 1 },
85
  "borrowernumber",
86
  { data_type => "integer", is_nullable => 1 },
87
  "Itype_quant",
88
  {
89
    accessor => "itype_quant",
90
    data_type => "varchar",
91
    is_nullable => 1,
92
    size => 10,
93
  },
94
  "Item_subject",
95
  { accessor => "item_subject", data_type => "mediumtext", is_nullable => 1 },
96
  "Item_authors",
97
  { accessor => "item_authors", data_type => "mediumtext", is_nullable => 1 },
98
  "referral",
99
  { data_type => "mediumtext", is_nullable => 1 },
100
  "notes",
101
  { data_type => "mediumtext", is_nullable => 1 },
102
);
103
104
=head1 PRIMARY KEY
105
106
=over 4
107
108
=item * L</hbnumber>
109
110
=back
111
112
=cut
113
114
__PACKAGE__->set_primary_key("hbnumber");
115
116
117
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
118
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KfWOT6B9V4lGTxfWOE+QTQ
119
120
121
# You can replace this text with custom code or comments, and it will be preserved on regeneration
122
1;
(-)a/Koha/Schema/Result/HouseboundInstance.pm (+107 lines)
Line 0 Link Here
1
use utf8;
2
package Koha::Schema::Result::HouseboundInstance;
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::HouseboundInstance
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<housebound_instance>
19
20
=cut
21
22
__PACKAGE__->table("housebound_instance");
23
24
=head1 ACCESSORS
25
26
=head2 instanceid
27
28
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_nullable: 0
31
32
=head2 hbnumber
33
34
  data_type: 'integer'
35
  is_nullable: 0
36
37
=head2 dmy
38
39
  data_type: 'date'
40
  datetime_undef_if_invalid: 1
41
  is_nullable: 1
42
43
=head2 time
44
45
  data_type: 'mediumtext'
46
  is_nullable: 1
47
48
=head2 borrowernumber
49
50
  data_type: 'integer'
51
  is_nullable: 0
52
53
=head2 volunteer
54
55
  data_type: 'integer'
56
  is_nullable: 1
57
58
=head2 chooser
59
60
  data_type: 'integer'
61
  is_nullable: 1
62
63
=head2 deliverer
64
65
  data_type: 'integer'
66
  is_nullable: 1
67
68
=cut
69
70
__PACKAGE__->add_columns(
71
  "instanceid",
72
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
73
  "hbnumber",
74
  { data_type => "integer", is_nullable => 0 },
75
  "dmy",
76
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
77
  "time",
78
  { data_type => "mediumtext", is_nullable => 1 },
79
  "borrowernumber",
80
  { data_type => "integer", is_nullable => 0 },
81
  "volunteer",
82
  { data_type => "integer", is_nullable => 1 },
83
  "chooser",
84
  { data_type => "integer", is_nullable => 1 },
85
  "deliverer",
86
  { data_type => "integer", is_nullable => 1 },
87
);
88
89
=head1 PRIMARY KEY
90
91
=over 4
92
93
=item * L</instanceid>
94
95
=back
96
97
=cut
98
99
__PACKAGE__->set_primary_key("instanceid");
100
101
102
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
103
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Hi6YuuVAE9fKyyEi8DPhUA
104
105
106
# You can replace this text with custom code or comments, and it will be preserved on regeneration
107
1;
(-)a/Koha/Schema/Result/Illrequest.pm (-10 / +38 lines)
Lines 54-59 __PACKAGE__->table("illrequests"); Link Here
54
  is_nullable: 1
54
  is_nullable: 1
55
  size: 50
55
  size: 50
56
56
57
=head2 status_alias
58
59
  data_type: 'integer'
60
  is_foreign_key: 1
61
  is_nullable: 1
62
57
=head2 placed
63
=head2 placed
58
64
59
  data_type: 'date'
65
  data_type: 'date'
Lines 97-108 __PACKAGE__->table("illrequests"); Link Here
97
  is_nullable: 1
103
  is_nullable: 1
98
  size: 20
104
  size: 20
99
105
100
=head2 price_paid
101
102
  data_type: 'varchar'
103
  is_nullable: 1
104
  size: 20
105
106
=head2 notesopac
106
=head2 notesopac
107
107
108
  data_type: 'mediumtext'
108
  data_type: 'mediumtext'
Lines 125-130 __PACKAGE__->table("illrequests"); Link Here
125
  is_nullable: 1
125
  is_nullable: 1
126
  size: 20
126
  size: 20
127
127
128
=head2 price_paid
129
130
  data_type: 'varchar'
131
  is_nullable: 1
132
  size: 20
133
128
=cut
134
=cut
129
135
130
__PACKAGE__->add_columns(
136
__PACKAGE__->add_columns(
Lines 143-148 __PACKAGE__->add_columns( Link Here
143
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 50 },
149
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 50 },
144
  "status",
150
  "status",
145
  { data_type => "varchar", is_nullable => 1, size => 50 },
151
  { data_type => "varchar", is_nullable => 1, size => 50 },
152
  "status_alias",
153
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
146
  "placed",
154
  "placed",
147
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
155
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
148
  "replied",
156
  "replied",
Lines 162-169 __PACKAGE__->add_columns( Link Here
162
  { data_type => "varchar", is_nullable => 1, size => 500 },
170
  { data_type => "varchar", is_nullable => 1, size => 500 },
163
  "cost",
171
  "cost",
164
  { data_type => "varchar", is_nullable => 1, size => 20 },
172
  { data_type => "varchar", is_nullable => 1, size => 20 },
165
  "price_paid",
166
  { data_type => "varchar", is_nullable => 1, size => 20 },
167
  "notesopac",
173
  "notesopac",
168
  { data_type => "mediumtext", is_nullable => 1 },
174
  { data_type => "mediumtext", is_nullable => 1 },
169
  "notesstaff",
175
  "notesstaff",
Lines 172-177 __PACKAGE__->add_columns( Link Here
172
  { data_type => "varchar", is_nullable => 1, size => 50 },
178
  { data_type => "varchar", is_nullable => 1, size => 50 },
173
  "backend",
179
  "backend",
174
  { data_type => "varchar", is_nullable => 1, size => 20 },
180
  { data_type => "varchar", is_nullable => 1, size => 20 },
181
  "price_paid",
182
  { data_type => "varchar", is_nullable => 1, size => 20 },
175
);
183
);
176
184
177
=head1 PRIMARY KEY
185
=head1 PRIMARY KEY
Lines 253-261 __PACKAGE__->has_many( Link Here
253
  { cascade_copy => 0, cascade_delete => 0 },
261
  { cascade_copy => 0, cascade_delete => 0 },
254
);
262
);
255
263
264
=head2 status_alias
265
266
Type: belongs_to
267
268
Related object: L<Koha::Schema::Result::AuthorisedValue>
269
270
=cut
271
272
__PACKAGE__->belongs_to(
273
  "status_alias",
274
  "Koha::Schema::Result::AuthorisedValue",
275
  { id => "status_alias" },
276
  {
277
    is_deferrable => 1,
278
    join_type     => "LEFT",
279
    on_delete     => "SET NULL",
280
    on_update     => "CASCADE",
281
  },
282
);
283
256
284
257
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-27 13:16:48
285
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
258
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rv6QyhxEah2r/rDcz3aOOw
286
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kib9BcMRy/expyGSm9sMbQ
259
287
260
288
261
# You can replace this text with custom code or comments, and it will be preserved on regeneration
289
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/ImportBatch.pm (-13 / +13 lines)
Lines 99-111 __PACKAGE__->table("import_batches"); Link Here
99
  extra: {list => ["batch","z3950","webservice"]}
99
  extra: {list => ["batch","z3950","webservice"]}
100
  is_nullable: 0
100
  is_nullable: 0
101
101
102
=head2 record_type
103
104
  data_type: 'enum'
105
  default_value: 'biblio'
106
  extra: {list => ["biblio","auth","holdings"]}
107
  is_nullable: 0
108
109
=head2 file_name
102
=head2 file_name
110
103
111
  data_type: 'varchar'
104
  data_type: 'varchar'
Lines 117-122 __PACKAGE__->table("import_batches"); Link Here
117
  data_type: 'longtext'
110
  data_type: 'longtext'
118
  is_nullable: 1
111
  is_nullable: 1
119
112
113
=head2 record_type
114
115
  data_type: 'enum'
116
  default_value: 'biblio'
117
  extra: {list => ["biblio","auth","holdings"]}
118
  is_nullable: 0
119
120
=cut
120
=cut
121
121
122
__PACKAGE__->add_columns(
122
__PACKAGE__->add_columns(
Lines 192-197 __PACKAGE__->add_columns( Link Here
192
    extra => { list => ["batch", "z3950", "webservice"] },
192
    extra => { list => ["batch", "z3950", "webservice"] },
193
    is_nullable => 0,
193
    is_nullable => 0,
194
  },
194
  },
195
  "file_name",
196
  { data_type => "varchar", is_nullable => 1, size => 100 },
197
  "comments",
198
  { data_type => "longtext", is_nullable => 1 },
195
  "record_type",
199
  "record_type",
196
  {
200
  {
197
    data_type => "enum",
201
    data_type => "enum",
Lines 199-208 __PACKAGE__->add_columns( Link Here
199
    extra => { list => ["biblio", "auth", "holdings"] },
203
    extra => { list => ["biblio", "auth", "holdings"] },
200
    is_nullable => 0,
204
    is_nullable => 0,
201
  },
205
  },
202
  "file_name",
203
  { data_type => "varchar", is_nullable => 1, size => 100 },
204
  "comments",
205
  { data_type => "longtext", is_nullable => 1 },
206
);
206
);
207
207
208
=head1 PRIMARY KEY
208
=head1 PRIMARY KEY
Lines 235-242 __PACKAGE__->has_many( Link Here
235
);
235
);
236
236
237
237
238
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
238
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
239
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:41giNJCRD9WXC4IGO/1D3A
239
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QuFcB7fNnk3jCFKgi8m7fg
240
240
241
241
242
# You can replace this text with custom content, and it will be preserved on regeneration
242
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Issue.pm (-18 / +8 lines)
Lines 33-45 __PACKAGE__->table("issues"); Link Here
33
33
34
  data_type: 'integer'
34
  data_type: 'integer'
35
  is_foreign_key: 1
35
  is_foreign_key: 1
36
  is_nullable: 1
36
  is_nullable: 0
37
37
38
=head2 itemnumber
38
=head2 itemnumber
39
39
40
  data_type: 'integer'
40
  data_type: 'integer'
41
  is_foreign_key: 1
41
  is_foreign_key: 1
42
  is_nullable: 1
42
  is_nullable: 0
43
43
44
=head2 date_due
44
=head2 date_due
45
45
Lines 123-131 __PACKAGE__->add_columns( Link Here
123
  "issue_id",
123
  "issue_id",
124
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
124
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
125
  "borrowernumber",
125
  "borrowernumber",
126
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
126
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
127
  "itemnumber",
127
  "itemnumber",
128
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
128
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
129
  "date_due",
129
  "date_due",
130
  {
130
  {
131
    data_type => "datetime",
131
    data_type => "datetime",
Lines 219-230 __PACKAGE__->belongs_to( Link Here
219
  "borrowernumber",
219
  "borrowernumber",
220
  "Koha::Schema::Result::Borrower",
220
  "Koha::Schema::Result::Borrower",
221
  { borrowernumber => "borrowernumber" },
221
  { borrowernumber => "borrowernumber" },
222
  {
222
  { is_deferrable => 1, on_delete => "RESTRICT", on_update => "CASCADE" },
223
    is_deferrable => 1,
224
    join_type     => "LEFT",
225
    on_delete     => "RESTRICT",
226
    on_update     => "CASCADE",
227
  },
228
);
223
);
229
224
230
=head2 itemnumber
225
=head2 itemnumber
Lines 239-255 __PACKAGE__->belongs_to( Link Here
239
  "itemnumber",
234
  "itemnumber",
240
  "Koha::Schema::Result::Item",
235
  "Koha::Schema::Result::Item",
241
  { itemnumber => "itemnumber" },
236
  { itemnumber => "itemnumber" },
242
  {
237
  { is_deferrable => 1, on_delete => "RESTRICT", on_update => "CASCADE" },
243
    is_deferrable => 1,
244
    join_type     => "LEFT",
245
    on_delete     => "RESTRICT",
246
    on_update     => "CASCADE",
247
  },
248
);
238
);
249
239
250
240
251
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-23 13:51:40
241
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
252
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+mlcId4odhAFp3HHgV/+tg
242
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AauWRMNJsFZYKjUkeqtycg
253
243
254
__PACKAGE__->belongs_to(
244
__PACKAGE__->belongs_to(
255
    "borrower",
245
    "borrower",
(-)a/Koha/Schema/Result/Item.pm (-25 / +12 lines)
Lines 150-161 __PACKAGE__->table("items"); Link Here
150
  is_nullable: 1
150
  is_nullable: 1
151
  size: 255
151
  size: 255
152
152
153
=head2 coded_location_qualifier
154
155
  data_type: 'varchar'
156
  is_nullable: 1
157
  size: 10
158
159
=head2 issues
153
=head2 issues
160
154
161
  data_type: 'smallint'
155
  data_type: 'smallint'
Lines 280-291 __PACKAGE__->table("items"); Link Here
280
  is_nullable: 1
274
  is_nullable: 1
281
  size: 32
275
  size: 32
282
276
277
stores the inventory number
278
283
=head2 new_status
279
=head2 new_status
284
280
285
  data_type: 'varchar'
281
  data_type: 'varchar'
286
  is_nullable: 1
282
  is_nullable: 1
287
  size: 32
283
  size: 32
288
284
285
=head2 coded_location_qualifier
286
287
  data_type: 'varchar'
288
  is_nullable: 1
289
  size: 10
290
289
=cut
291
=cut
290
292
291
__PACKAGE__->add_columns(
293
__PACKAGE__->add_columns(
Lines 353-360 __PACKAGE__->add_columns( Link Here
353
  },
355
  },
354
  "itemcallnumber",
356
  "itemcallnumber",
355
  { data_type => "varchar", is_nullable => 1, size => 255 },
357
  { data_type => "varchar", is_nullable => 1, size => 255 },
356
  "coded_location_qualifier",
357
  { data_type => "varchar", is_nullable => 1, size => 10 },
358
  "issues",
358
  "issues",
359
  { data_type => "smallint", is_nullable => 1 },
359
  { data_type => "smallint", is_nullable => 1 },
360
  "renewals",
360
  "renewals",
Lines 406-411 __PACKAGE__->add_columns( Link Here
406
  { data_type => "varchar", is_nullable => 1, size => 32 },
406
  { data_type => "varchar", is_nullable => 1, size => 32 },
407
  "new_status",
407
  "new_status",
408
  { data_type => "varchar", is_nullable => 1, size => 32 },
408
  { data_type => "varchar", is_nullable => 1, size => 32 },
409
  "coded_location_qualifier",
410
  { data_type => "varchar", is_nullable => 1, size => 10 },
409
);
411
);
410
412
411
=head1 PRIMARY KEY
413
=head1 PRIMARY KEY
Lines 671-691 __PACKAGE__->has_many( Link Here
671
  { cascade_copy => 0, cascade_delete => 0 },
673
  { cascade_copy => 0, cascade_delete => 0 },
672
);
674
);
673
675
674
=head2 serialitem
675
676
Type: might_have
677
678
Related object: L<Koha::Schema::Result::Serialitem>
679
680
=cut
681
682
__PACKAGE__->might_have(
683
  "serialitem",
684
  "Koha::Schema::Result::Serialitem",
685
  { "foreign.itemnumber" => "self.itemnumber" },
686
  { cascade_copy => 0, cascade_delete => 0 },
687
);
688
689
=head2 stockrotationitem
676
=head2 stockrotationitem
690
677
691
Type: might_have
678
Type: might_have
Lines 702-709 __PACKAGE__->might_have( Link Here
702
);
689
);
703
690
704
691
705
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-09 15:50:42
692
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
706
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PQvA8qoxvTe4In5/oa5WIQ
693
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yCRbfTRcR9gxcdNqyOxNpg
707
694
708
__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
695
__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
709
696
(-)a/Koha/Schema/Result/Letter.pm (-3 / +3 lines)
Lines 152-163 __PACKAGE__->belongs_to( Link Here
152
  "message_transport_type",
152
  "message_transport_type",
153
  "Koha::Schema::Result::MessageTransportType",
153
  "Koha::Schema::Result::MessageTransportType",
154
  { message_transport_type => "message_transport_type" },
154
  { message_transport_type => "message_transport_type" },
155
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
155
  { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
156
);
156
);
157
157
158
158
159
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54
159
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
160
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fOuu1Fj8Uo3114QKS2qLkQ
160
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:XDq2o0wNUEkPuLtfPZiomA
161
161
162
162
163
# You can replace this text with custom content, and it will be preserved on regeneration
163
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/MarcModificationTemplateAction.pm (-4 / +4 lines)
Lines 44-50 __PACKAGE__->table("marc_modification_template_actions"); Link Here
44
44
45
  data_type: 'enum'
45
  data_type: 'enum'
46
  extra: {list => ["delete_field","add_field","update_field","move_field","copy_field","copy_and_replace_field"]}
46
  extra: {list => ["delete_field","add_field","update_field","move_field","copy_field","copy_and_replace_field"]}
47
  is_nullable: 0
47
  is_nullable: 1
48
48
49
=head2 field_number
49
=head2 field_number
50
50
Lines 161-167 __PACKAGE__->add_columns( Link Here
161
        "copy_and_replace_field",
161
        "copy_and_replace_field",
162
      ],
162
      ],
163
    },
163
    },
164
    is_nullable => 0,
164
    is_nullable => 1,
165
  },
165
  },
166
  "field_number",
166
  "field_number",
167
  { data_type => "smallint", default_value => 0, is_nullable => 0 },
167
  { data_type => "smallint", default_value => 0, is_nullable => 0 },
Lines 235-242 __PACKAGE__->belongs_to( Link Here
235
);
235
);
236
236
237
237
238
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-19 17:32:57
238
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
239
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dAUr9aGlNZleldYbjJHdmw
239
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:l5ezpD4DzfzsLV+WhOYpAQ
240
240
241
241
242
# You can replace this text with custom code or comments, and it will be preserved on regeneration
242
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/MessageAttribute.pm (-5 / +4 lines)
Lines 32-39 __PACKAGE__->table("message_attributes"); Link Here
32
=head2 message_name
32
=head2 message_name
33
33
34
  data_type: 'varchar'
34
  data_type: 'varchar'
35
  default_value: (empty string)
35
  is_nullable: 1
36
  is_nullable: 0
37
  size: 40
36
  size: 40
38
37
39
=head2 takes_days
38
=head2 takes_days
Lines 48-54 __PACKAGE__->add_columns( Link Here
48
  "message_attribute_id",
47
  "message_attribute_id",
49
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
48
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
50
  "message_name",
49
  "message_name",
51
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 40 },
50
  { data_type => "varchar", is_nullable => 1, size => 40 },
52
  "takes_days",
51
  "takes_days",
53
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
52
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
54
);
53
);
Lines 112-119 __PACKAGE__->has_many( Link Here
112
);
111
);
113
112
114
113
115
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
114
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
116
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:N033AvWwG2CDBDuTj2unqQ
115
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0UOXJDFio/WUDUbc67P1WQ
117
116
118
117
119
# You can replace this text with custom content, and it will be preserved on regeneration
118
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/NeedMergeAuthority.pm (-10 / +10 lines)
Lines 44-49 __PACKAGE__->table("need_merge_authorities"); Link Here
44
  data_type: 'mediumtext'
44
  data_type: 'mediumtext'
45
  is_nullable: 1
45
  is_nullable: 1
46
46
47
=head2 done
48
49
  data_type: 'tinyint'
50
  default_value: 0
51
  is_nullable: 1
52
47
=head2 timestamp
53
=head2 timestamp
48
54
49
  data_type: 'timestamp'
55
  data_type: 'timestamp'
Lines 51-62 __PACKAGE__->table("need_merge_authorities"); Link Here
51
  default_value: current_timestamp
57
  default_value: current_timestamp
52
  is_nullable: 0
58
  is_nullable: 0
53
59
54
=head2 done
55
56
  data_type: 'tinyint'
57
  default_value: 0
58
  is_nullable: 1
59
60
=cut
60
=cut
61
61
62
__PACKAGE__->add_columns(
62
__PACKAGE__->add_columns(
Lines 68-73 __PACKAGE__->add_columns( Link Here
68
  { data_type => "bigint", is_nullable => 1 },
68
  { data_type => "bigint", is_nullable => 1 },
69
  "reportxml",
69
  "reportxml",
70
  { data_type => "mediumtext", is_nullable => 1 },
70
  { data_type => "mediumtext", is_nullable => 1 },
71
  "done",
72
  { data_type => "tinyint", default_value => 0, is_nullable => 1 },
71
  "timestamp",
73
  "timestamp",
72
  {
74
  {
73
    data_type => "timestamp",
75
    data_type => "timestamp",
Lines 75-82 __PACKAGE__->add_columns( Link Here
75
    default_value => \"current_timestamp",
77
    default_value => \"current_timestamp",
76
    is_nullable => 0,
78
    is_nullable => 0,
77
  },
79
  },
78
  "done",
79
  { data_type => "tinyint", default_value => 0, is_nullable => 1 },
80
);
80
);
81
81
82
=head1 PRIMARY KEY
82
=head1 PRIMARY KEY
Lines 92-99 __PACKAGE__->add_columns( Link Here
92
__PACKAGE__->set_primary_key("id");
92
__PACKAGE__->set_primary_key("id");
93
93
94
94
95
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54
95
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
96
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7LzwIYvExKvNgr8/HDZlsg
96
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/QuLsg1gd9kWNnugkDmSBA
97
97
98
98
99
# You can replace this text with custom content, and it will be preserved on regeneration
99
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/OaiSet.pm (-2 / +12 lines)
Lines 125-133 __PACKAGE__->has_many( Link Here
125
  { cascade_copy => 0, cascade_delete => 0 },
125
  { cascade_copy => 0, cascade_delete => 0 },
126
);
126
);
127
127
128
=head2 biblionumbers
128
129
129
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-07-08 15:06:22
130
Type: many_to_many
130
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ju63fVMgLPbeFxeZJsQHRQ
131
132
Composing rels: L</oai_sets_biblios> -> biblionumber
133
134
=cut
135
136
__PACKAGE__->many_to_many("biblionumbers", "oai_sets_biblios", "biblionumber");
137
138
139
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
140
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7zp9hrwat3SmXgRedYcXgQ
131
141
132
142
133
# You can replace this text with custom content, and it will be preserved on regeneration
143
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/OaiSetsBiblio.pm (-3 / +19 lines)
Lines 26-31 __PACKAGE__->table("oai_sets_biblios"); Link Here
26
=head2 biblionumber
26
=head2 biblionumber
27
27
28
  data_type: 'integer'
28
  data_type: 'integer'
29
  is_foreign_key: 1
29
  is_nullable: 0
30
  is_nullable: 0
30
31
31
=head2 set_id
32
=head2 set_id
Lines 38-44 __PACKAGE__->table("oai_sets_biblios"); Link Here
38
39
39
__PACKAGE__->add_columns(
40
__PACKAGE__->add_columns(
40
  "biblionumber",
41
  "biblionumber",
41
  { data_type => "integer", is_nullable => 0 },
42
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
42
  "set_id",
43
  "set_id",
43
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
44
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
44
);
45
);
Lines 59-64 __PACKAGE__->set_primary_key("biblionumber", "set_id"); Link Here
59
60
60
=head1 RELATIONS
61
=head1 RELATIONS
61
62
63
=head2 biblionumber
64
65
Type: belongs_to
66
67
Related object: L<Koha::Schema::Result::Biblio>
68
69
=cut
70
71
__PACKAGE__->belongs_to(
72
  "biblionumber",
73
  "Koha::Schema::Result::Biblio",
74
  { biblionumber => "biblionumber" },
75
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
76
);
77
62
=head2 set
78
=head2 set
63
79
64
Type: belongs_to
80
Type: belongs_to
Lines 75-82 __PACKAGE__->belongs_to( Link Here
75
);
91
);
76
92
77
93
78
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-07-08 15:06:22
94
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
79
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oGVUyyyune8FVOj504xizw
95
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:X8R6Odd2qZpvrY09Z3LOhw
80
96
81
97
82
# You can replace this text with custom content, and it will be preserved on regeneration
98
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/OaiSetsMapping.pm (-16 / +2 lines)
Lines 41-53 __PACKAGE__->table("oai_sets_mappings"); Link Here
41
  is_nullable: 0
41
  is_nullable: 0
42
  size: 1
42
  size: 1
43
43
44
=head2 operator
45
46
  data_type: 'varchar'
47
  default_value: 'equal'
48
  is_nullable: 0
49
  size: 8
50
51
=head2 marcvalue
44
=head2 marcvalue
52
45
53
  data_type: 'varchar'
46
  data_type: 'varchar'
Lines 63-75 __PACKAGE__->add_columns( Link Here
63
  { data_type => "char", is_nullable => 0, size => 3 },
56
  { data_type => "char", is_nullable => 0, size => 3 },
64
  "marcsubfield",
57
  "marcsubfield",
65
  { data_type => "char", is_nullable => 0, size => 1 },
58
  { data_type => "char", is_nullable => 0, size => 1 },
66
  "operator",
67
  {
68
    data_type => "varchar",
69
    default_value => "equal",
70
    is_nullable => 0,
71
    size => 8,
72
  },
73
  "marcvalue",
59
  "marcvalue",
74
  { data_type => "varchar", is_nullable => 0, size => 80 },
60
  { data_type => "varchar", is_nullable => 0, size => 80 },
75
);
61
);
Lines 92-99 __PACKAGE__->belongs_to( Link Here
92
);
78
);
93
79
94
80
95
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
81
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
96
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:A2fchnI85JftSuruZ1CykQ
82
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ISJose/oSjtuVo3EXLzPxA
97
83
98
84
99
# You can replace this text with custom content, and it will be preserved on regeneration
85
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/OldReserve.pm (-4 / +4 lines)
Lines 283-296 __PACKAGE__->belongs_to( Link Here
283
  {
283
  {
284
    is_deferrable => 1,
284
    is_deferrable => 1,
285
    join_type     => "LEFT",
285
    join_type     => "LEFT",
286
    on_delete     => "SET NULL",
286
    on_delete     => "CASCADE",
287
    on_update     => "SET NULL",
287
    on_update     => "CASCADE",
288
  },
288
  },
289
);
289
);
290
290
291
291
292
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54
292
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
293
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ynb6NtiTN8ZZur2YCvxlNg
293
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VFAvF0fzXCBuzgK+hE3eHA
294
294
295
295
296
# You can replace this text with custom content, and it will be preserved on regeneration
296
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Patronimage.pm (-3 / +9 lines)
Lines 26-31 __PACKAGE__->table("patronimage"); Link Here
26
=head2 borrowernumber
26
=head2 borrowernumber
27
27
28
  data_type: 'integer'
28
  data_type: 'integer'
29
  default_value: 0
29
  is_foreign_key: 1
30
  is_foreign_key: 1
30
  is_nullable: 0
31
  is_nullable: 0
31
32
Lines 44-50 __PACKAGE__->table("patronimage"); Link Here
44
45
45
__PACKAGE__->add_columns(
46
__PACKAGE__->add_columns(
46
  "borrowernumber",
47
  "borrowernumber",
47
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
48
  {
49
    data_type      => "integer",
50
    default_value  => 0,
51
    is_foreign_key => 1,
52
    is_nullable    => 0,
53
  },
48
  "mimetype",
54
  "mimetype",
49
  { data_type => "varchar", is_nullable => 0, size => 15 },
55
  { data_type => "varchar", is_nullable => 0, size => 15 },
50
  "imagefile",
56
  "imagefile",
Lines 81-88 __PACKAGE__->belongs_to( Link Here
81
);
87
);
82
88
83
89
84
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
90
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
85
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uuRGyWlemwOH1PCkvhqxdQ
91
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FlZ4R0S51TTSASvOPzqmrg
86
92
87
93
88
# You can replace this text with custom content, and it will be preserved on regeneration
94
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Serialitem.pm (-19 / +3 lines)
Lines 26-32 __PACKAGE__->table("serialitems"); Link Here
26
=head2 itemnumber
26
=head2 itemnumber
27
27
28
  data_type: 'integer'
28
  data_type: 'integer'
29
  is_foreign_key: 1
30
  is_nullable: 0
29
  is_nullable: 0
31
30
32
=head2 serialid
31
=head2 serialid
Lines 39-45 __PACKAGE__->table("serialitems"); Link Here
39
38
40
__PACKAGE__->add_columns(
39
__PACKAGE__->add_columns(
41
  "itemnumber",
40
  "itemnumber",
42
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
41
  { data_type => "integer", is_nullable => 0 },
43
  "serialid",
42
  "serialid",
44
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
43
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
45
);
44
);
Lines 58-78 __PACKAGE__->set_primary_key("itemnumber"); Link Here
58
57
59
=head1 RELATIONS
58
=head1 RELATIONS
60
59
61
=head2 itemnumber
62
63
Type: belongs_to
64
65
Related object: L<Koha::Schema::Result::Item>
66
67
=cut
68
69
__PACKAGE__->belongs_to(
70
  "itemnumber",
71
  "Koha::Schema::Result::Item",
72
  { itemnumber => "itemnumber" },
73
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
74
);
75
76
=head2 serialid
60
=head2 serialid
77
61
78
Type: belongs_to
62
Type: belongs_to
Lines 89-96 __PACKAGE__->belongs_to( Link Here
89
);
73
);
90
74
91
75
92
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-04-13 13:53:21
76
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
93
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Z43jqmURevaJeui7l8ThlQ
77
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qAF0pJF5e8AJzxaZqlg13w
94
78
95
79
96
# You can replace this text with custom content, and it will be preserved on regeneration
80
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Session.pm (-4 / +4 lines)
Lines 32-38 __PACKAGE__->table("sessions"); Link Here
32
=head2 a_session
32
=head2 a_session
33
33
34
  data_type: 'longtext'
34
  data_type: 'longtext'
35
  is_nullable: 0
35
  is_nullable: 1
36
36
37
=cut
37
=cut
38
38
Lines 40-46 __PACKAGE__->add_columns( Link Here
40
  "id",
40
  "id",
41
  { data_type => "varchar", is_nullable => 0, size => 32 },
41
  { data_type => "varchar", is_nullable => 0, size => 32 },
42
  "a_session",
42
  "a_session",
43
  { data_type => "longtext", is_nullable => 0 },
43
  { data_type => "longtext", is_nullable => 1 },
44
);
44
);
45
45
46
=head1 PRIMARY KEY
46
=head1 PRIMARY KEY
Lines 56-63 __PACKAGE__->add_columns( Link Here
56
__PACKAGE__->set_primary_key("id");
56
__PACKAGE__->set_primary_key("id");
57
57
58
58
59
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54
59
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
60
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YyoQx5Kb6G7W0CVV96chpQ
60
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Y/66MvcHQG0Urlv4Q+7ItQ
61
61
62
62
63
# You can replace this text with custom content, and it will be preserved on regeneration
63
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Stockrotationrota.pm (-4 / +18 lines)
Lines 38-44 __PACKAGE__->table("stockrotationrotas"); Link Here
38
=head2 description
38
=head2 description
39
39
40
  data_type: 'text'
40
  data_type: 'text'
41
  is_nullable: 0
41
  is_nullable: 1
42
42
43
=head2 cyclical
43
=head2 cyclical
44
44
Lines 60-66 __PACKAGE__->add_columns( Link Here
60
  "title",
60
  "title",
61
  { data_type => "varchar", is_nullable => 0, size => 100 },
61
  { data_type => "varchar", is_nullable => 0, size => 100 },
62
  "description",
62
  "description",
63
  { data_type => "text", is_nullable => 0 },
63
  { data_type => "text", is_nullable => 1 },
64
  "cyclical",
64
  "cyclical",
65
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
65
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
66
  "active",
66
  "active",
Lines 79-84 __PACKAGE__->add_columns( Link Here
79
79
80
__PACKAGE__->set_primary_key("rota_id");
80
__PACKAGE__->set_primary_key("rota_id");
81
81
82
=head1 UNIQUE CONSTRAINTS
83
84
=head2 C<stockrotationrotas_title>
85
86
=over 4
87
88
=item * L</title>
89
90
=back
91
92
=cut
93
94
__PACKAGE__->add_unique_constraint("stockrotationrotas_title", ["title"]);
95
82
=head1 RELATIONS
96
=head1 RELATIONS
83
97
84
=head2 stockrotationstages
98
=head2 stockrotationstages
Lines 97-104 __PACKAGE__->has_many( Link Here
97
);
111
);
98
112
99
113
100
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-09 15:50:42
114
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
101
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lTIDZ+w+46Kniub5Tqpqlg
115
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HrZO2r+/Warg22jZTBH6YQ
102
116
103
__PACKAGE__->add_columns(
117
__PACKAGE__->add_columns(
104
  '+cyclical' => { is_boolean => 1 },
118
  '+cyclical' => { is_boolean => 1 },
(-)a/Koha/Schema/Result/Subscription.pm (-27 / +12 lines)
Lines 113-127 __PACKAGE__->table("subscription"); Link Here
113
  data_type: 'integer'
113
  data_type: 'integer'
114
  is_nullable: 1
114
  is_nullable: 1
115
115
116
=head2 innerloop1
116
=head2 lastvalue2
117
117
118
  data_type: 'integer'
118
  data_type: 'integer'
119
  default_value: 0
120
  is_nullable: 1
119
  is_nullable: 1
121
120
122
=head2 lastvalue2
121
=head2 innerloop1
123
122
124
  data_type: 'integer'
123
  data_type: 'integer'
124
  default_value: 0
125
  is_nullable: 1
125
  is_nullable: 1
126
126
127
=head2 innerloop2
127
=head2 innerloop2
Lines 130-144 __PACKAGE__->table("subscription"); Link Here
130
  default_value: 0
130
  default_value: 0
131
  is_nullable: 1
131
  is_nullable: 1
132
132
133
=head2 lastvalue3
133
=head2 innerloop3
134
134
135
  data_type: 'integer'
135
  data_type: 'integer'
136
  default_value: 0
136
  is_nullable: 1
137
  is_nullable: 1
137
138
138
=head2 innerloop3
139
=head2 lastvalue3
139
140
140
  data_type: 'integer'
141
  data_type: 'integer'
141
  default_value: 0
142
  is_nullable: 1
142
  is_nullable: 1
143
143
144
=head2 firstacquidate
144
=head2 firstacquidate
Lines 304-319 __PACKAGE__->add_columns( Link Here
304
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },
304
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },
305
  "lastvalue1",
305
  "lastvalue1",
306
  { data_type => "integer", is_nullable => 1 },
306
  { data_type => "integer", is_nullable => 1 },
307
  "innerloop1",
308
  { data_type => "integer", default_value => 0, is_nullable => 1 },
309
  "lastvalue2",
307
  "lastvalue2",
310
  { data_type => "integer", is_nullable => 1 },
308
  { data_type => "integer", is_nullable => 1 },
309
  "innerloop1",
310
  { data_type => "integer", default_value => 0, is_nullable => 1 },
311
  "innerloop2",
311
  "innerloop2",
312
  { data_type => "integer", default_value => 0, is_nullable => 1 },
312
  { data_type => "integer", default_value => 0, is_nullable => 1 },
313
  "lastvalue3",
314
  { data_type => "integer", is_nullable => 1 },
315
  "innerloop3",
313
  "innerloop3",
316
  { data_type => "integer", default_value => 0, is_nullable => 1 },
314
  { data_type => "integer", default_value => 0, is_nullable => 1 },
315
  "lastvalue3",
316
  { data_type => "integer", is_nullable => 1 },
317
  "firstacquidate",
317
  "firstacquidate",
318
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
318
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
319
  "manualhistory",
319
  "manualhistory",
Lines 429-452 __PACKAGE__->belongs_to( Link Here
429
  },
429
  },
430
);
430
);
431
431
432
=head2 subscriptionroutinglists
433
434
Type: has_many
435
436
Related object: L<Koha::Schema::Result::Subscriptionroutinglist>
437
438
=cut
439
440
__PACKAGE__->has_many(
441
  "subscriptionroutinglists",
442
  "Koha::Schema::Result::Subscriptionroutinglist",
443
  { "foreign.subscriptionid" => "self.subscriptionid" },
444
  { cascade_copy => 0, cascade_delete => 0 },
445
);
446
447
432
448
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54
433
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
449
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZRLfM/4h8VMLTgW7LkUYYA
434
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YEnhBEHShtX7EOGZ72E3tg
450
435
451
436
452
# You can replace this text with custom content, and it will be preserved on regeneration
437
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Subscriptionroutinglist.pm (-19 / +3 lines)
Lines 43-49 __PACKAGE__->table("subscriptionroutinglist"); Link Here
43
=head2 subscriptionid
43
=head2 subscriptionid
44
44
45
  data_type: 'integer'
45
  data_type: 'integer'
46
  is_foreign_key: 1
47
  is_nullable: 0
46
  is_nullable: 0
48
47
49
=cut
48
=cut
Lines 56-62 __PACKAGE__->add_columns( Link Here
56
  "ranking",
55
  "ranking",
57
  { data_type => "integer", is_nullable => 1 },
56
  { data_type => "integer", is_nullable => 1 },
58
  "subscriptionid",
57
  "subscriptionid",
59
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
58
  { data_type => "integer", is_nullable => 0 },
60
);
59
);
61
60
62
=head1 PRIMARY KEY
61
=head1 PRIMARY KEY
Lines 104-127 __PACKAGE__->belongs_to( Link Here
104
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
103
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
105
);
104
);
106
105
107
=head2 subscriptionid
108
109
Type: belongs_to
110
111
Related object: L<Koha::Schema::Result::Subscription>
112
113
=cut
114
115
__PACKAGE__->belongs_to(
116
  "subscriptionid",
117
  "Koha::Schema::Result::Subscription",
118
  { subscriptionid => "subscriptionid" },
119
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
120
);
121
122
106
123
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
107
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
124
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AK595c56vgTa7ZjwZjberw
108
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AWnpmHLU+knqkuZiPbiWxQ
125
109
126
110
127
# You can replace this text with custom content, and it will be preserved on regeneration
111
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Suggestion.pm (-48 / +48 lines)
Lines 35-79 __PACKAGE__->table("suggestions"); Link Here
35
  default_value: 0
35
  default_value: 0
36
  is_nullable: 0
36
  is_nullable: 0
37
37
38
=head2 suggesteddate
39
40
  data_type: 'date'
41
  datetime_undef_if_invalid: 1
42
  is_nullable: 0
43
44
=head2 managedby
38
=head2 managedby
45
39
46
  data_type: 'integer'
40
  data_type: 'integer'
47
  is_nullable: 1
41
  is_nullable: 1
48
42
49
=head2 manageddate
50
51
  data_type: 'date'
52
  datetime_undef_if_invalid: 1
53
  is_nullable: 1
54
55
=head2 acceptedby
56
57
  data_type: 'integer'
58
  is_nullable: 1
59
60
=head2 accepteddate
61
62
  data_type: 'date'
63
  datetime_undef_if_invalid: 1
64
  is_nullable: 1
65
66
=head2 rejectedby
67
68
  data_type: 'integer'
69
  is_nullable: 1
70
71
=head2 rejecteddate
72
73
  data_type: 'date'
74
  datetime_undef_if_invalid: 1
75
  is_nullable: 1
76
77
=head2 STATUS
43
=head2 STATUS
78
44
79
  accessor: 'status'
45
  accessor: 'status'
Lines 168-173 __PACKAGE__->table("suggestions"); Link Here
168
  is_nullable: 1
134
  is_nullable: 1
169
  size: 10
135
  size: 10
170
136
137
=head2 acceptedby
138
139
  data_type: 'integer'
140
  is_nullable: 1
141
142
=head2 accepteddate
143
144
  data_type: 'date'
145
  datetime_undef_if_invalid: 1
146
  is_nullable: 1
147
148
=head2 suggesteddate
149
150
  data_type: 'date'
151
  datetime_undef_if_invalid: 1
152
  is_nullable: 0
153
154
=head2 manageddate
155
156
  data_type: 'date'
157
  datetime_undef_if_invalid: 1
158
  is_nullable: 1
159
160
=head2 rejectedby
161
162
  data_type: 'integer'
163
  is_nullable: 1
164
165
=head2 rejecteddate
166
167
  data_type: 'date'
168
  datetime_undef_if_invalid: 1
169
  is_nullable: 1
170
171
=head2 collectiontitle
171
=head2 collectiontitle
172
172
173
  data_type: 'mediumtext'
173
  data_type: 'mediumtext'
Lines 209-228 __PACKAGE__->add_columns( Link Here
209
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
209
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
210
  "suggestedby",
210
  "suggestedby",
211
  { data_type => "integer", default_value => 0, is_nullable => 0 },
211
  { data_type => "integer", default_value => 0, is_nullable => 0 },
212
  "suggesteddate",
213
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 0 },
214
  "managedby",
212
  "managedby",
215
  { data_type => "integer", is_nullable => 1 },
213
  { data_type => "integer", is_nullable => 1 },
216
  "manageddate",
217
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
218
  "acceptedby",
219
  { data_type => "integer", is_nullable => 1 },
220
  "accepteddate",
221
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
222
  "rejectedby",
223
  { data_type => "integer", is_nullable => 1 },
224
  "rejecteddate",
225
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
226
  "STATUS",
214
  "STATUS",
227
  {
215
  {
228
    accessor => "status",
216
    accessor => "status",
Lines 266-271 __PACKAGE__->add_columns( Link Here
266
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
254
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
267
  "branchcode",
255
  "branchcode",
268
  { data_type => "varchar", is_nullable => 1, size => 10 },
256
  { data_type => "varchar", is_nullable => 1, size => 10 },
257
  "acceptedby",
258
  { data_type => "integer", is_nullable => 1 },
259
  "accepteddate",
260
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
261
  "suggesteddate",
262
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 0 },
263
  "manageddate",
264
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
265
  "rejectedby",
266
  { data_type => "integer", is_nullable => 1 },
267
  "rejecteddate",
268
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
269
  "collectiontitle",
269
  "collectiontitle",
270
  { data_type => "mediumtext", is_nullable => 1 },
270
  { data_type => "mediumtext", is_nullable => 1 },
271
  "itemtype",
271
  "itemtype",
Lines 315-322 __PACKAGE__->belongs_to( Link Here
315
);
315
);
316
316
317
317
318
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54
318
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
319
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dOt4/U4rLcXq+aACRwcpYw
319
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9ovjDSyWFUtxt4qShR1RiA
320
320
321
321
322
# You can replace this text with custom content, and it will be preserved on regeneration
322
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/VendorEdiAccount.pm (-5 / +3 lines)
Lines 133-139 __PACKAGE__->table("vendor_edi_accounts"); Link Here
133
=head2 plugin
133
=head2 plugin
134
134
135
  data_type: 'varchar'
135
  data_type: 'varchar'
136
  default_value: (empty string)
137
  is_nullable: 0
136
  is_nullable: 0
138
  size: 256
137
  size: 256
139
138
Lines 177-183 __PACKAGE__->add_columns( Link Here
177
  "shipment_budget",
176
  "shipment_budget",
178
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
177
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
179
  "plugin",
178
  "plugin",
180
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 256 },
179
  { data_type => "varchar", is_nullable => 0, size => 256 },
181
);
180
);
182
181
183
=head1 PRIMARY KEY
182
=head1 PRIMARY KEY
Lines 250-257 __PACKAGE__->belongs_to( Link Here
250
);
249
);
251
250
252
251
253
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54
252
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
254
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TtWuTpP4Ac6/+T6OPMSsRA
253
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QPYU9DYwSAyCFB99vrAMzA
255
254
256
255
257
# You can replace this text with custom code or comments, and it will be preserved on regeneration
256
# You can replace this text with custom code or comments, and it will be preserved on regeneration
258
- 

Return to bug 20581