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

(-)a/Koha/Schema/Result/Currency.pm (-25 / +2 lines)
Lines 60-71 __PACKAGE__->table("currency"); Link Here
60
  data_type: 'tinyint'
60
  data_type: 'tinyint'
61
  is_nullable: 1
61
  is_nullable: 1
62
62
63
=head2 archived
64
65
  data_type: 'tinyint'
66
  default_value: 0
67
  is_nullable: 1
68
69
=cut
63
=cut
70
64
71
__PACKAGE__->add_columns(
65
__PACKAGE__->add_columns(
Lines 86-93 __PACKAGE__->add_columns( Link Here
86
  { data_type => "float", is_nullable => 1, size => [15, 5] },
80
  { data_type => "float", is_nullable => 1, size => [15, 5] },
87
  "active",
81
  "active",
88
  { data_type => "tinyint", is_nullable => 1 },
82
  { data_type => "tinyint", is_nullable => 1 },
89
  "archived",
90
  { data_type => "tinyint", default_value => 0, is_nullable => 1 },
91
);
83
);
92
84
93
=head1 PRIMARY KEY
85
=head1 PRIMARY KEY
Lines 134-157 __PACKAGE__->has_many( Link Here
134
  { cascade_copy => 0, cascade_delete => 0 },
126
  { cascade_copy => 0, cascade_delete => 0 },
135
);
127
);
136
128
137
=head2 aqorders
138
139
Type: has_many
140
141
Related object: L<Koha::Schema::Result::Aqorder>
142
143
=cut
144
145
__PACKAGE__->has_many(
146
  "aqorders",
147
  "Koha::Schema::Result::Aqorder",
148
  { "foreign.currency" => "self.currency" },
149
  { cascade_copy => 0, cascade_delete => 0 },
150
);
151
152
129
153
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-12-17 10:57:24
130
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-03-04 19:32:39
154
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:B9JY/pDkp8icT7m0xDDKAA
131
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:o9IAcoQ0uxMdl0zZ0M0agw
155
132
156
133
157
# You can replace this text with custom content, and it will be preserved on regeneration
134
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Deletedborrower.pm (-6 / +6 lines)
Lines 293-299 __PACKAGE__->table("deletedborrowers"); Link Here
293
293
294
  data_type: 'varchar'
294
  data_type: 'varchar'
295
  is_nullable: 1
295
  is_nullable: 1
296
  size: 30
296
  size: 60
297
297
298
=head2 flags
298
=head2 flags
299
299
Lines 304-310 __PACKAGE__->table("deletedborrowers"); Link Here
304
304
305
  data_type: 'varchar'
305
  data_type: 'varchar'
306
  is_nullable: 1
306
  is_nullable: 1
307
  size: 30
307
  size: 75
308
308
309
=head2 opacnote
309
=head2 opacnote
310
310
Lines 522-532 __PACKAGE__->add_columns( Link Here
522
  "sex",
522
  "sex",
523
  { data_type => "varchar", is_nullable => 1, size => 1 },
523
  { data_type => "varchar", is_nullable => 1, size => 1 },
524
  "password",
524
  "password",
525
  { data_type => "varchar", is_nullable => 1, size => 30 },
525
  { data_type => "varchar", is_nullable => 1, size => 60 },
526
  "flags",
526
  "flags",
527
  { data_type => "integer", is_nullable => 1 },
527
  { data_type => "integer", is_nullable => 1 },
528
  "userid",
528
  "userid",
529
  { data_type => "varchar", is_nullable => 1, size => 30 },
529
  { data_type => "varchar", is_nullable => 1, size => 75 },
530
  "opacnote",
530
  "opacnote",
531
  { data_type => "mediumtext", is_nullable => 1 },
531
  { data_type => "mediumtext", is_nullable => 1 },
532
  "contactnote",
532
  "contactnote",
Lines 564-571 __PACKAGE__->add_columns( Link Here
564
);
564
);
565
565
566
566
567
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-02-14 12:46:14
567
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-03-04 19:32:39
568
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UvGAnZ1qOwgtmLpbG8ukow
568
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UqTaMlpDnOWlhfQyF5EjHA
569
569
570
570
571
# You can replace this text with custom code or comments, and it will be preserved on regeneration
571
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Deleteditem.pm (-2 / +11 lines)
Lines 270-275 __PACKAGE__->table("deleteditems"); Link Here
270
  is_nullable: 1
270
  is_nullable: 1
271
  size: 32
271
  size: 32
272
272
273
=head2 new
274
275
  accessor: undef
276
  data_type: 'varchar'
277
  is_nullable: 1
278
  size: 32
279
273
=cut
280
=cut
274
281
275
__PACKAGE__->add_columns(
282
__PACKAGE__->add_columns(
Lines 372-377 __PACKAGE__->add_columns( Link Here
372
  { data_type => "varchar", is_nullable => 1, size => 32 },
379
  { data_type => "varchar", is_nullable => 1, size => 32 },
373
  "stocknumber",
380
  "stocknumber",
374
  { data_type => "varchar", is_nullable => 1, size => 32 },
381
  { data_type => "varchar", is_nullable => 1, size => 32 },
382
  "new",
383
  { accessor => undef, data_type => "varchar", is_nullable => 1, size => 32 },
375
);
384
);
376
385
377
=head1 PRIMARY KEY
386
=head1 PRIMARY KEY
Lines 387-394 __PACKAGE__->add_columns( Link Here
387
__PACKAGE__->set_primary_key("itemnumber");
396
__PACKAGE__->set_primary_key("itemnumber");
388
397
389
398
390
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-04-23 12:42:12
399
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-03-04 19:32:39
391
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+aDMnEj1EvLQTQPAEl1ocg
400
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uu6dMCUUlDOkveF9SYkKew
392
401
393
402
394
# You can replace this text with custom content, and it will be preserved on regeneration
403
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Item.pm (-2 / +11 lines)
Lines 273-278 __PACKAGE__->table("items"); Link Here
273
  is_nullable: 1
273
  is_nullable: 1
274
  size: 32
274
  size: 32
275
275
276
=head2 new
277
278
  accessor: undef
279
  data_type: 'varchar'
280
  is_nullable: 1
281
  size: 32
282
276
=cut
283
=cut
277
284
278
__PACKAGE__->add_columns(
285
__PACKAGE__->add_columns(
Lines 380-385 __PACKAGE__->add_columns( Link Here
380
  { data_type => "varchar", is_nullable => 1, size => 32 },
387
  { data_type => "varchar", is_nullable => 1, size => 32 },
381
  "stocknumber",
388
  "stocknumber",
382
  { data_type => "varchar", is_nullable => 1, size => 32 },
389
  { data_type => "varchar", is_nullable => 1, size => 32 },
390
  "new",
391
  { accessor => undef, data_type => "varchar", is_nullable => 1, size => 32 },
383
);
392
);
384
393
385
=head1 PRIMARY KEY
394
=head1 PRIMARY KEY
Lines 631-638 __PACKAGE__->might_have( Link Here
631
);
640
);
632
641
633
642
634
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-01-06 12:00:28
643
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-03-04 19:32:39
635
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3M6BvB4ATsBXgQCkFKuI3A
644
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rhW0Ddhh2hLoV//7nonLCA
636
645
637
__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
646
__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
638
647
(-)a/Koha/Schema/Result/TagAll.pm (-5 / +10 lines)
Lines 33-39 __PACKAGE__->table("tags_all"); 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: 0
36
  is_nullable: 1
37
37
38
=head2 biblionumber
38
=head2 biblionumber
39
39
Lines 64-70 __PACKAGE__->add_columns( Link Here
64
  "tag_id",
64
  "tag_id",
65
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
65
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
66
  "borrowernumber",
66
  "borrowernumber",
67
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
67
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
68
  "biblionumber",
68
  "biblionumber",
69
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
69
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
70
  "term",
70
  "term",
Lines 120-131 __PACKAGE__->belongs_to( Link Here
120
  "borrowernumber",
120
  "borrowernumber",
121
  "Koha::Schema::Result::Borrower",
121
  "Koha::Schema::Result::Borrower",
122
  { borrowernumber => "borrowernumber" },
122
  { borrowernumber => "borrowernumber" },
123
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
123
  {
124
    is_deferrable => 1,
125
    join_type     => "LEFT",
126
    on_delete     => "SET NULL",
127
    on_update     => "CASCADE",
128
  },
124
);
129
);
125
130
126
131
127
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
132
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-03-04 19:32:39
128
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xhJn9d2lS8crFWog28ENnw
133
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gyjzwAoUL27c/7NqM8+RaA
129
134
130
135
131
# You can replace this text with custom content, and it will be preserved on regeneration
136
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/TagsApproval.pm (-4 / +3 lines)
Lines 101-107 __PACKAGE__->belongs_to( Link Here
101
  {
101
  {
102
    is_deferrable => 1,
102
    is_deferrable => 1,
103
    join_type     => "LEFT",
103
    join_type     => "LEFT",
104
    on_delete     => "CASCADE",
104
    on_delete     => "SET NULL",
105
    on_update     => "CASCADE",
105
    on_update     => "CASCADE",
106
  },
106
  },
107
);
107
);
Lines 122-129 __PACKAGE__->has_many( Link Here
122
);
122
);
123
123
124
124
125
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
125
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-03-04 19:32:39
126
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TcnMQQTB5F8hjyLoJ7VBHQ
126
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:V6O4TG3vfkRovbGgNP3HmA
127
127
128
128
129
# You can replace this text with custom content, and it will be preserved on regeneration
129
# You can replace this text with custom content, and it will be preserved on regeneration
130
- 

Return to bug 15084