Attachment #99302 for bug #19036

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




    };
}

=head3 store

Specific store method to generate credit number before saving

=cut

sub store {
    my ($self) = @_;

    my $AutoCreditNumber = C4::Context->preference('AutoCreditNumber');
    if ($AutoCreditNumber && !$self->in_storage && $self->is_credit && !$self->credit_number) {
        my $rs = Koha::Database->new->schema->resultset($self->_type);

        if ($AutoCreditNumber eq 'incremental') {
            my $max = $rs->search({
                credit_number => { -regexp => '^[0-9]+$' }
            }, {
                select => \'CAST(credit_number AS UNSIGNED)',
                as => ['credit_number'],
            })->get_column('credit_number')->max;
            $max //= 0;
            $self->credit_number($max + 1);
        } elsif ($AutoCreditNumber eq 'annual') {
            my $now = DateTime->now;
            my $prefix = sprintf('%d-', $now->year);
            my $max = $rs->search({
                -and => [
                    credit_number => { -regexp => '[0-9]{4}$' },
                    credit_number => { -like => "$prefix%" },
                ],
            })->get_column('credit_number')->max;
            $max //= $prefix . '0000';
            my $incr = substr($max, length $prefix);
            $self->credit_number(sprintf('%s%04d', $prefix, $incr + 1));
        } elsif ($AutoCreditNumber eq 'branchyyyymmincr') {
            my $userenv = C4::Context->userenv;
            if ($userenv) {
                my $branch = $userenv->{branch};
                my $now = DateTime->now;
                my $prefix = sprintf('%s%d%02d', $branch, $now->year, $now->month);
                my $pattern = $prefix;
                $pattern =~ s/([\?%_])/\\$1/g;
                my $max = $rs->search({
                    -and => [
                        credit_number => { -regexp => '[0-9]{4}$' },
                        credit_number => { -like => "$pattern%" },
                    ],
                })->get_column('credit_number')->max;
                $max //= $prefix . '0000';
                my $incr = substr($max, length $prefix);
                $self->credit_number(sprintf('%s%04d', $prefix, $incr + 1));
            }
        }
    }

    return $self->SUPER::store();
}

=head2 Internal methods

=cut

Lines 47-52 __PACKAGE__->table("account_credit_types"); Link Here

(-)a/Koha/Schema/Result/AccountCreditType.pm (-2 / +10 lines)
47	default_value: 0	47	default_value: 0
48	is_nullable: 0	48	is_nullable: 0
49		49
		50	=head2 archived
		51
		52	data_type: 'tinyint'
		53	default_value: 0
		54	is_nullable: 0
		55
50	=cut	56	=cut
51		57
52	__PACKAGE__->add_columns(	58	__PACKAGE__->add_columns(
Lines 58-63 __PACKAGE__->add_columns( Link Here
58	{ data_type => "tinyint", default_value => 1, is_nullable => 0 },	64	{ data_type => "tinyint", default_value => 1, is_nullable => 0 },
59	"is_system",	65	"is_system",
60	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },	66	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
		67	"archived",
		68	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
61	);	69	);
62		70
63	=head1 PRIMARY KEY	71	=head1 PRIMARY KEY
Lines 105-112 __PACKAGE__->has_many( Link Here
105	);	113	);
106		114
107		115
108	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-14 09:59:52	116	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
109	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Uycu/23b681kWHNX+/gNiw	117	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9tQSTkjAGqGikbWnbBhlgw
110		118
111	__PACKAGE__->add_columns(	119	__PACKAGE__->add_columns(
112	'+is_system' => { is_boolean => 1 }	120	'+is_system' => { is_boolean => 1 }





  data_type: 'tinyint'
  default_value: 0
  is_nullable: 1

=head2 default_amount


  "can_be_invoiced",
  { data_type => "tinyint", default_value => 1, is_nullable => 0 },
  "can_be_sold",
  { data_type => "tinyint", default_value => 0, is_nullable => 1 },
  "default_amount",
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
  "is_system",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qZfg9L2ysl2pJUiaBLwUFg

__PACKAGE__->add_columns(
    '+is_system' => { is_boolean => 1 }





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=cut

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
);

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mfS1B79dpfPc8VGdjT1+YA

sub koha_object_class {
    'Koha::Account::Offset';

Lines 77-82 __PACKAGE__->table("accountlines"); Link Here

(-)a/Koha/Schema/Result/Accountline.pm (-4 / +14 lines)
77	is_nullable: 1	77	is_nullable: 1
78	size: 80	78	size: 80
79		79
		80	=head2 credit_number
		81
		82	data_type: 'varchar'
		83	is_nullable: 1
		84	size: 20
		85
		86	autogenerated number for credits
		87
80	=head2 status	88	=head2 status
81		89
82	data_type: 'varchar'	90	data_type: 'varchar'
Lines 99-105 __PACKAGE__->table("accountlines"); Link Here
99		107
100	data_type: 'timestamp'	108	data_type: 'timestamp'
101	datetime_undef_if_invalid: 1	109	datetime_undef_if_invalid: 1
102	default_value: current_timestamp	110	default_value: 'current_timestamp()'
103	is_nullable: 0	111	is_nullable: 0
104		112
105	=head2 note	113	=head2 note
Lines 153-158 __PACKAGE__->add_columns( Link Here
153	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 80 },	161	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 80 },
154	"debit_type_code",	162	"debit_type_code",
155	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 80 },	163	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 80 },
		164	"credit_number",
		165	{ data_type => "varchar", is_nullable => 1, size => 20 },
156	"status",	166	"status",
157	{ data_type => "varchar", is_nullable => 1, size => 16 },	167	{ data_type => "varchar", is_nullable => 1, size => 16 },
158	"payment_type",	168	"payment_type",
Lines 163-169 __PACKAGE__->add_columns( Link Here
163	{	173	{
164	data_type => "timestamp",	174	data_type => "timestamp",
165	datetime_undef_if_invalid => 1,	175	datetime_undef_if_invalid => 1,
166	default_value => \"current_timestamp",	176	default_value => "current_timestamp()",
167	is_nullable => 0,	177	is_nullable => 0,
168	},	178	},
169	"note",	179	"note",
Lines 363-370 __PACKAGE__->belongs_to( Link Here
363	);	373	);
364		374
365		375
366	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-24 16:33:42	376	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
367	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:q4Ahb8xIxAsjT/aF9yjrdQ	377	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uFM5Kclu6Vw6ui+1A/RXsQ
368		378
369	sub koha_objects_class {	379	sub koha_objects_class {
370	'Koha::Account::Lines';	380	'Koha::Account::Lines';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 user

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "user",

__PACKAGE__->set_primary_key("action_id");


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TmMQtaJ4596Tj8mYKvZffA


# You can replace this text with custom code or comments, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 budget_period_id

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "budget_period_id",

__PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber");


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:wbXfOXiR6q7jVleJyzsLWQ


sub koha_object_class {





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=cut

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
);

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:V0/9Hi5Uc9L2AnWcdzDn4g

sub koha_object_class {
    'Koha::Acquisition::Invoice::Adjustment';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 rrp

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "rrp",

__PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber");


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xXgooImZVlFvUzSJXHPWhQ

__PACKAGE__->belongs_to(
  "basket",





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=cut

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
);

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FLVvGzsei1T0NsB5+ubnXw


# You can replace this text with custom content, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=cut

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
);

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FqlytCU3bCmEDqWkOm2uuw


# You can replace this text with custom code or comments, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 updated_on

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "updated_on",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DZfgssb5lWBwXAQD4yFX2g


# You can replace this text with custom code or comments, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 origincode

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "origincode",

__PACKAGE__->set_primary_key("authid");


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:78YWjMUi8plOllaNMWzmuw

sub koha_object_class {
    'Koha::Authority';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 datecreated

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "datecreated",

  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 items_bundle

Type: might_have

Related object: L<Koha::Schema::Result::ItemsBundle>

=cut

__PACKAGE__->might_have(
  "items_bundle",
  "Koha::Schema::Result::ItemsBundle",
  { "foreign.biblionumber" => "self.biblionumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 old_reserves

Type: has_many

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:swuobxQgc+thlB/K+3QZeA


__PACKAGE__->has_one(





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=cut

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
);

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5mMqx4y01pZfu8YrNvXDTQ

sub koha_object_class {
    'Koha::Biblio::Metadata';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 illus

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "illus",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Anhy+pvrQlPufkbe5qsJsQ

__PACKAGE__->belongs_to( biblio => "Koha::Schema::Result::Biblio", "biblionumber" );






  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 lastseen

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "lastseen",

  },
);

=head2 subscriptionroutings

Type: has_many

Related object: L<Koha::Schema::Result::Subscriptionrouting>

=cut

__PACKAGE__->has_many(
  "subscriptionroutings",
  "Koha::Schema::Result::Subscriptionrouting",
  { "foreign.borrowernumber" => "self.borrowernumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9Ekh2ybmnaY+m5FxB7U6mQ

__PACKAGE__->add_columns(
    '+anonymized'    => { is_boolean => 1 },





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 updated

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "updated",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tOAoFYn0a6MZgtvoFS15xQ


# You can replace this text with custom code or comments, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=cut

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
);

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CRCwGgDaSvO7nc4Nkyb3Cw


# You can replace this text with custom content, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 verification_token

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "verification_token",

__PACKAGE__->set_primary_key("verification_token", "borrowernumber");


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kwyyiaDxYxdTaYEdcEX8yg

sub koha_object_class {
    'Koha::Patron::Modification';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=cut

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
);

__PACKAGE__->set_primary_key("borrowernumber");


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rQvacObXzIDRx+cnDgX6uA


# You can replace this text with custom code or comments, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 date_updated

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "date_updated",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:q0tsXoANaJ0laHSyzhvWBg


# You can replace this text with custom content, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 date_canceled

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "date_canceled",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BGc4RqbBSCR6uniY1/ra4Q

sub koha_object_class {
    'Koha::Club::Enrollment';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=cut

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
);

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ccFlKbTvIRs4u01E8qqnRg

sub koha_objects_class {
    'Koha::Club::Holds';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 date_updated

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "date_updated",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YUzYhnCe19rp6VL0cJZQvA

sub koha_object_class {
    'Koha::Club::Template';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=cut

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
);

__PACKAGE__->many_to_many("borrowernumbers", "course_instructors", "borrowernumber");


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yeukLUSqlLJNVHxKDC7HOQ


# You can replace this text with custom content, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=cut

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
);

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VcUbKGA6rEwIg4cRse4fEg


# You can replace this text with custom content, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=cut

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
);

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ocHPOi2tze1PQCzzw9qY5w


# You can replace this text with custom content, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 branch_code

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "branch_code",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:g3vD+wvEsI0GBWyvSMEFqg


# You can replace this text with custom content, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 rate

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "rate",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YaSxkG7ZGqegVkIif7NDjQ


sub koha_object_class {





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 datecreated

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "datecreated",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9Xm2vadUVskBiHj/Ex84Sg

sub koha_objects_class {
    'Koha::Old::Biblios';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=cut

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
);

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nIqHgwWZQKbGDIGTwNcR9w


# You can replace this text with custom code or comments, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 illus

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "illus",

__PACKAGE__->set_primary_key("biblioitemnumber");


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:A8v0vpPFLetnTSuMAb6SYA

sub koha_objects_class {
    'Koha::Old::Biblioitems';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 lastseen

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "lastseen",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4FJOURzbg7/amSUXECLJsQ

sub koha_objects_class {
    'Koha::Old::Patrons';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 location

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "location",

__PACKAGE__->set_primary_key("itemnumber");


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:d5Keiv9fRJlOT27yRtMX2w

sub koha_objects_class {
    'Koha::Old::Items';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=cut

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
);

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:taV0nPCmNLIflefOr5YMKQ


# You can replace this text with custom code or comments, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 completed

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "completed",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:drrFZCJQY+kKFxek3IBvUQ


# You can replace this text with custom code or comments, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 overlay_action

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "overlay_action",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GmVg9yizOZg8hY8RKoKtEQ


# You can replace this text with custom content, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 import_date

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "import_date",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jKLkfH2mLNE5UpMT/ZnbEA


# You can replace this text with custom content, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 issuedate

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "issuedate",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Uu7Hv8HiASn3H6me2YHx1A

__PACKAGE__->add_columns(
    '+auto_renew'      => { is_boolean => 1 },





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 location

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "location",

  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 items_bundle_item

Type: might_have

Related object: L<Koha::Schema::Result::ItemsBundleItem>

=cut

__PACKAGE__->might_have(
  "items_bundle_item",
  "Koha::Schema::Result::ItemsBundleItem",
  { "foreign.itemnumber" => "self.itemnumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 items_last_borrower

Type: might_have

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2OAwCv4uG2OqDkHGrMQlbw

__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );






  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=cut

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
);

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uKe825x+YA0n7O8HxdC0BA


# You can replace this text with custom code or comments, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=cut

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
);

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cgoo1VFsYRC2VPqVu613NQ

sub koha_object_class {
    'Koha::Library::Group';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 manager_id

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "manager_id",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Czgoljvkzbs8ta0hXTxqMA

sub koha_object_class {
    'Koha::Patron::Message';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 to_address

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "to_address",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0L+d9pWy9VZz2uwJsQNB7Q

sub koha_object_class {
    'Koha::Notice::Message';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=cut

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
);

__PACKAGE__->set_primary_key("file_id");


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QPuF+Cb4BVGp2rqB18JWnw


# You can replace this text with custom code or comments, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 done

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "done",

__PACKAGE__->set_primary_key("id");


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:m8L0rNMzZk0cLGj2LFEDwA

sub koha_object_class {
    'Koha::Authority::MergeRequest';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 issuedate

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "issuedate",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aRRi1sRKr7IguXs8IvIoDw

__PACKAGE__->add_columns(
    '+auto_renew'      => { is_boolean => 1 },





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 itemnumber

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "itemnumber",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:I4D3WJSvd7KTyWF+9M4D4w

sub koha_object_class {
    'Koha::Old::Hold';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 expirationdate

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "expirationdate",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gkBxrFM46U1oEQDXahQxMA

sub koha_object_class {
    'Koha::NewsItem';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 action

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "action",

__PACKAGE__->set_primary_key("operationid");


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kd5wVqCpZO7PRNMlAvSeJw


# You can replace this text with custom content, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=cut

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
);

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:01Smg8hro7ZNrATvWSxsVQ


# You can replace this text with custom content, and it will be preserved on regeneration

Lines 32-37 __PACKAGE__->table("repeatable_holidays"); Link Here

(-)a/Koha/Schema/Result/RepeatableHoliday.pm (-3 / +10 lines)
32	=head2 branchcode	32	=head2 branchcode
33		33
34	data_type: 'varchar'	34	data_type: 'varchar'
		35	default_value: (empty string)
35	is_foreign_key: 1	36	is_foreign_key: 1
36	is_nullable: 0	37	is_nullable: 0
37	size: 10	38	size: 10
Lines 69-75 __PACKAGE__->add_columns( Link Here
69	"id",	70	"id",
70	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },	71	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
71	"branchcode",	72	"branchcode",
72	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 10 },	73	{
		74	data_type => "varchar",
		75	default_value => "",
		76	is_foreign_key => 1,
		77	is_nullable => 0,
		78	size => 10,
		79	},
73	"weekday",	80	"weekday",
74	{ data_type => "smallint", is_nullable => 1 },	81	{ data_type => "smallint", is_nullable => 1 },
75	"day",	82	"day",
Lines 112-119 __PACKAGE__->belongs_to( Link Here
112	);	119	);
113		120
114		121
115	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-20 13:57:27	122	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
116	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bBw2WEvzF5sX+AOteNsPPQ	123	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:wiRQ/s8GNyqViiJmG3HMRQ
117		124
118		125
119	# You can replace this text with custom content, and it will be preserved on regeneration	126	# You can replace this text with custom content, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 itemnumber

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "itemnumber",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jZhq1NVVcesKshzQvWopuw

__PACKAGE__->belongs_to(
  "item",





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=cut

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
);

__PACKAGE__->set_primary_key("id");


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VMVGSV8eY1KTpJVv0Nm5lA


# You can replace this text with custom content, and it will be preserved on regeneration





=head1 ACCESSORS

=head2 search

  data_type: 'tinyint'
  default_value: 1
  is_nullable: 0

=head2 search_marc_map_id

  data_type: 'integer'


true/false creates special sort handling, null doesn't

=head2 search

  data_type: 'tinyint'
  default_value: 1
  is_nullable: 0

=cut

__PACKAGE__->add_columns(
  "search",
  { data_type => "tinyint", default_value => 1, is_nullable => 0 },
  "search_marc_map_id",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
  "search_field_id",

  { data_type => "tinyint", default_value => 0, is_nullable => 1 },
  "sort",
  { data_type => "tinyint", is_nullable => 1 },
  "search",
  { data_type => "tinyint", default_value => 1, is_nullable => 0 },
);

=head1 PRIMARY KEY

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:NH2gQdc4p5gyGwbKuXIlkQ


# You can replace this text with custom code or comments, and it will be preserved on regeneration




  default_value: 0
  is_nullable: 1

=head2 routingnotes

  data_type: 'mediumtext'
  is_nullable: 1

=cut

__PACKAGE__->add_columns(

  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "claims_count",
  { data_type => "integer", default_value => 0, is_nullable => 1 },
  "routingnotes",
  { data_type => "mediumtext", is_nullable => 1 },
);

=head1 PRIMARY KEY

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:p5Ds0c7eiE3KTmFDHVMxqQ


# You can replace this text with custom code or comments, and it will be preserved on regeneration

Lines 32-37 __PACKAGE__->table("special_holidays"); Link Here

(-)a/Koha/Schema/Result/SpecialHoliday.pm (-3 / +10 lines)
32	=head2 branchcode	32	=head2 branchcode
33		33
34	data_type: 'varchar'	34	data_type: 'varchar'
		35	default_value: (empty string)
35	is_foreign_key: 1	36	is_foreign_key: 1
36	is_nullable: 0	37	is_nullable: 0
37	size: 10	38	size: 10
Lines 78-84 __PACKAGE__->add_columns( Link Here
78	"id",	79	"id",
79	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },	80	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
80	"branchcode",	81	"branchcode",
81	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 10 },	82	{
		83	data_type => "varchar",
		84	default_value => "",
		85	is_foreign_key => 1,
		86	is_nullable => 0,
		87	size => 10,
		88	},
82	"day",	89	"day",
83	{ data_type => "smallint", default_value => 0, is_nullable => 0 },	90	{ data_type => "smallint", default_value => 0, is_nullable => 0 },
84	"month",	91	"month",
Lines 123-130 __PACKAGE__->belongs_to( Link Here
123	);	130	);
124		131
125		132
126	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-20 13:57:27	133	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
127	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cj8Oveni0l6kAR/azmw4SA	134	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M1IWe2I5Gam4ItJoHeNntA
128		135
129		136
130	# You can replace this text with custom content, and it will be preserved on regeneration	137	# You can replace this text with custom content, and it will be preserved on regeneration





=head1 ACCESSORS

=head2 routinglistid

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

=head2 subscriptionid

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

=head2 title

  data_type: 'varchar'
  is_nullable: 0
  size: 256

=head2 notes

  data_type: 'text'
  is_nullable: 1
  is_nullable: 0

=cut

__PACKAGE__->add_columns(
  "routinglistid",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "borrowernumber",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
  "ranking",
  { data_type => "integer", is_nullable => 1 },
  "subscriptionid",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
  "title",
  { data_type => "varchar", is_nullable => 0, size => 256 },
  "notes",
  { data_type => "text", is_nullable => 1 },
);

=head1 PRIMARY KEY

=over 4

=item * L</routinglistid>

=back

=cut

__PACKAGE__->set_primary_key("routinglistid");

=head1 UNIQUE CONSTRAINTS

=head2 C<subscriptionid>

=over 4

=item * L</subscriptionid>

=item * L</borrowernumber>

=back

=cut

__PACKAGE__->add_unique_constraint("subscriptionid", ["subscriptionid", "borrowernumber"]);

=head1 RELATIONS

=head2 subscriptionid

Type: belongs_to

Related object: L<Koha::Schema::Result::Subscription>

=cut

__PACKAGE__->belongs_to(
  "subscriptionid",
  "Koha::Schema::Result::Subscription",
  { subscriptionid => "subscriptionid" },
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "RESTRICT" },
);

=head2 subscriptionroutings

Type: has_many

Related object: L<Koha::Schema::Result::Subscriptionrouting>

=cut

__PACKAGE__->has_many(
  "subscriptionroutings",
  "Koha::Schema::Result::Subscriptionrouting",
  { "foreign.routinglistid" => "self.routinglistid" },
  { cascade_copy => 0, cascade_delete => 0 },
);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ybxwm+MNY+0Z8txgjjIahw

sub koha_object_class {
    'Koha::Subscription::Routinglist';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 volumedesc

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "volumedesc",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jonzJsbNRJnB1hso6kIqUQ

__PACKAGE__->belongs_to(
  "suggester",





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 uploadcategorycode

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "uploadcategorycode",

__PACKAGE__->set_primary_key("id");


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dUELzltCRxC2Nfwy0MVpCw


# You can replace this text with custom code or comments, and it will be preserved on regeneration





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 borrowernumber

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "borrowernumber",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:20iSu9w0DCT2jgIOUpybyg

#TODO See BZ 14544: Should be resolved by db revision
__PACKAGE__->set_primary_key("shelfnumber","biblionumber");





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=head2 created_on

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
  "created_on",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:59Elqv1XBtx7Sf9TI+yEDA

sub koha_object_class {
    'Koha::Virtualshelf';





  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: 'current_timestamp()'
  is_nullable: 0

=cut

  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => "current_timestamp()",
    is_nullable => 0,
  },
);

__PACKAGE__->set_primary_key("id");


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:n+gwp4O5CrNj25L/ZA/65g


# You can replace this text with custom content, and it will be preserved on regeneration

Lines 516-521 modules: Link Here

(-)a/admin/columns_settings.yml (+3 lines)
516	account-fines:	516	account-fines:
517	-	517	-
518	columnname: date	518	columnname: date
		519	-
		520	columnname: credit_number
		521	is_hidden: 1
519	-	522	-
520	columnname: account_type	523	columnname: account_type
521	-	524	-

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug-19036.perl (+11 lines)
	1	$DBversion = 'XXX';
	2	if (CheckVersion($DBversion)) {
	3	unless (column_exists('accountlines', 'credit_number')) {
	4	$dbh->do('ALTER TABLE accountlines ADD COLUMN credit_number VARCHAR(20) NULL DEFAULT NULL COMMENT "autogenerated number for credits" AFTER debit_type_code');
	5	}
	6
	7	$dbh->do('INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type) VALUES(?, ?, ?, ?, ?)', undef, 'AutoCreditNumber', '', '', 'Automatically generate a number for account credits', 'Choice');
	8
	9	SetVersion($DBversion);
	10	print "Upgrade to $DBversion done (Bug 19036 - Add column accountlines.credit_number)\n";
	11	}

Lines 2654-2659 CREATE TABLE `accountlines` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
2654	`description` LONGTEXT,	2654	`description` LONGTEXT,
2655	`credit_type_code` varchar(80) default NULL,	2655	`credit_type_code` varchar(80) default NULL,
2656	`debit_type_code` varchar(80) default NULL,	2656	`debit_type_code` varchar(80) default NULL,
		2657	`credit_number` varchar(20) NULL DEFAULT NULL COMMENT 'autogenerated number for credits',
2657	`status` varchar(16) default NULL,	2658	`status` varchar(16) default NULL,
2658	`payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE	2659	`payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE
2659	`amountoutstanding` decimal(28,6) default NULL,	2660	`amountoutstanding` decimal(28,6) default NULL,

Lines 67-72 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/sysprefs.sql (+1 lines)
67	('AuthoritySeparator','--','10','Used to separate a list of authorities in a display. Usually --','free'),	67	('AuthoritySeparator','--','10','Used to separate a list of authorities in a display. Usually --','free'),
68	('autoBarcode','OFF','incremental\|annual\|hbyymmincr\|EAN13\|OFF','Used to autogenerate a barcode: incremental will be of the form 1, 2, 3; annual of the form 2007-0001, 2007-0002; hbyymmincr of the form HB08010001 where HB=Home Branch','Choice'),	68	('autoBarcode','OFF','incremental\|annual\|hbyymmincr\|EAN13\|OFF','Used to autogenerate a barcode: incremental will be of the form 1, 2, 3; annual of the form 2007-0001, 2007-0002; hbyymmincr of the form HB08010001 where HB=Home Branch','Choice'),
69	('AutoCreateAuthorities','0',NULL,'Automatically create authorities that do not exist when cataloging records.','YesNo'),	69	('AutoCreateAuthorities','0',NULL,'Automatically create authorities that do not exist when cataloging records.','YesNo'),
		70	('AutoCreditNumber', '', '', 'Automatically generate a number for account credits', 'Choice'),
70	('AutoEmailOpacUser','0',NULL,'Sends notification emails containing new account details to patrons - when account is created.','YesNo'),	71	('AutoEmailOpacUser','0',NULL,'Sends notification emails containing new account details to patrons - when account is created.','YesNo'),
71	('AutoEmailPrimaryAddress','OFF','email\|emailpro\|B_email\|cardnumber\|OFF','Defines the default email address where \'Account Details\' emails are sent.','Choice'),	72	('AutoEmailPrimaryAddress','OFF','email\|emailpro\|B_email\|cardnumber\|OFF','Defines the default email address where \'Account Details\' emails are sent.','Choice'),
72	('AutoShareWithMana','subscription','','defines datas automatically shared with mana','multiple'),	73	('AutoShareWithMana','subscription','','defines datas automatically shared with mana','multiple'),

Lines 27-29 Accounting: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/accounting.pref (+7 lines)
27	yes: "Enable"	27	yes: "Enable"
28	no: "Disable"	28	no: "Disable"
29	- " the point of sale feature to allow anonymous transactions with the accounting system. (Requires UseCashRegisters)"	29	- " the point of sale feature to allow anonymous transactions with the accounting system. (Requires UseCashRegisters)"
		30	-
		31	- pref: AutoCreditNumber
		32	choices:
		33	'': 'Do not automatically generate credit numbers'
		34	annual: 'Automatically generate credit numbers in the form <year>-0001'
		35	branchyyyymmincr: 'Automatically generate credit numbers in the form <branchcode>yyyymm0001'
		36	incremental: 'Automatically generate credit numbers in the form 1, 2, 3'




    <thead>
      <tr>
          <th class="title-string">Date</th>
          <th>Credit number</th>
          <th>Account type</th>
          <th>Description of charges</th>
          <th>Barcode</th>


   <tr>
   <td><span title="[% account.date | html %]">[% account.date |$KohaDates %]</span></td>
        <td>[% account.credit_number | html %]</td>
        <td>[% PROCESS account_type_description account=account %]</td>
      <td>
        [%- IF account.payment_type %][% AuthorisedValues.GetByCode('PAYMENT_TYPE', account.payment_type) | html %][% END %]

  [% END %]
<tfoot>
  <tr>
    <td colspan="10">Total due</td>
    [% IF ( totalcredit ) %]
        <td class="credit" style="text-align: right;">[% total | $Price %]</td>
    [% ELSE %]





use Modern::Perl;

use Test::More tests => 12;
use Test::MockModule;
use Test::Exception;



    $schema->storage->txn_rollback;
};

subtest 'Koha::Account::pay() generates credit number' => sub {
    plan tests => 34;

    $schema->storage->txn_begin;

    Koha::Account::Lines->delete();

    my $patron  = $builder->build_object( { class => 'Koha::Patrons' } );
    my $library = $builder->build_object( { class => 'Koha::Libraries' } );
    my $account = $patron->account;

    my $context = Test::MockModule->new('C4::Context');
    $context->mock( 'userenv', { branch => $library->id } );

    my $now = DateTime->now;
    my $year = $now->year;
    my $month = $now->month;
    my ($accountlines_id, $accountline);

    t::lib::Mocks::mock_preference('AutoCreditNumber', '');
    $accountlines_id = $account->pay({ amount => '1.00', library_id => $library->id });
    $accountline = Koha::Account::Lines->find($accountlines_id);
    is($accountline->credit_number, undef, 'No credit number is generated when syspref is off');

    t::lib::Mocks::mock_preference('AutoCreditNumber', 'incremental');
    for my $i (1..11) {
        $accountlines_id = $account->pay({ amount => '1.00', library_id => $library->id });
        $accountline = Koha::Account::Lines->find($accountlines_id);
        is($accountline->credit_number, $i);
    }

    t::lib::Mocks::mock_preference('AutoCreditNumber', 'annual');
    for my $i (1..11) {
        $accountlines_id = $account->pay({ amount => '1.00', library_id => $library->id });
        $accountline = Koha::Account::Lines->find($accountlines_id);
        is($accountline->credit_number, sprintf('%s-%04d', $year, $i));
    }

    t::lib::Mocks::mock_preference('AutoCreditNumber', 'branchyyyymmincr');
    for my $i (1..11) {
        $accountlines_id = $account->pay({ amount => '1.00', library_id => $library->id });
        $accountline = Koha::Account::Lines->find($accountlines_id);
        is($accountline->credit_number, sprintf('%s%d%02d%04d', $library->id, $year, $month, $i));
    }

    $schema->storage->txn_rollback;
};

Return to bug 19036

Lines 762-767 sub to_api_mapping { Link Here

(-)a/Koha/Account/Line.pm (+58 lines)
762	};	762	};
763	}	763	}
764		764
		765	=head3 store
		766
		767	Specific store method to generate credit number before saving
		768
		769	=cut
		770
		771	sub store {
		772	my ($self) = @_;
		773
		774	my $AutoCreditNumber = C4::Context->preference('AutoCreditNumber');
		775	if ($AutoCreditNumber && !$self->in_storage && $self->is_credit && !$self->credit_number) {
		776	my $rs = Koha::Database->new->schema->resultset($self->_type);
		777
		778	if ($AutoCreditNumber eq 'incremental') {
		779	my $max = $rs->search({
		780	credit_number => { -regexp => '^[0-9]+$' }
		781	}, {
		782	select => \'CAST(credit_number AS UNSIGNED)',
		783	as => ['credit_number'],
		784	})->get_column('credit_number')->max;
		785	$max //= 0;
		786	$self->credit_number($max + 1);
		787	} elsif ($AutoCreditNumber eq 'annual') {
		788	my $now = DateTime->now;
		789	my $prefix = sprintf('%d-', $now->year);
		790	my $max = $rs->search({
		791	-and => [
		792	credit_number => { -regexp => '[0-9]{4}$' },
		793	credit_number => { -like => "$prefix%" },
		794	],
		795	})->get_column('credit_number')->max;
		796	$max //= $prefix . '0000';
		797	my $incr = substr($max, length $prefix);
		798	$self->credit_number(sprintf('%s%04d', $prefix, $incr + 1));
		799	} elsif ($AutoCreditNumber eq 'branchyyyymmincr') {
		800	my $userenv = C4::Context->userenv;
		801	if ($userenv) {
		802	my $branch = $userenv->{branch};
		803	my $now = DateTime->now;
		804	my $prefix = sprintf('%s%d%02d', $branch, $now->year, $now->month);
		805	my $pattern = $prefix;
		806	$pattern =~ s/([\?%_])/\\$1/g;
		807	my $max = $rs->search({
		808	-and => [
		809	credit_number => { -regexp => '[0-9]{4}$' },
		810	credit_number => { -like => "$pattern%" },
		811	],
		812	})->get_column('credit_number')->max;
		813	$max //= $prefix . '0000';
		814	my $incr = substr($max, length $prefix);
		815	$self->credit_number(sprintf('%s%04d', $prefix, $incr + 1));
		816	}
		817	}
		818	}
		819
		820	return $self->SUPER::store();
		821	}
		822
765	=head2 Internal methods	823	=head2 Internal methods
766		824
767	=cut	825	=cut

Lines 95-101 __PACKAGE__->table("biblio"); Link Here

(-)a/Koha/Schema/Result/Biblio.pm (-4 / +19 lines)
95		95
96	data_type: 'timestamp'	96	data_type: 'timestamp'
97	datetime_undef_if_invalid: 1	97	datetime_undef_if_invalid: 1
98	default_value: current_timestamp	98	default_value: 'current_timestamp()'
99	is_nullable: 0	99	is_nullable: 0
100		100
101	=head2 datecreated	101	=head2 datecreated
Lines 142-148 __PACKAGE__->add_columns( Link Here
142	{	142	{
143	data_type => "timestamp",	143	data_type => "timestamp",
144	datetime_undef_if_invalid => 1,	144	datetime_undef_if_invalid => 1,
145	default_value => \"current_timestamp",	145	default_value => "current_timestamp()",
146	is_nullable => 0,	146	is_nullable => 0,
147	},	147	},
148	"datecreated",	148	"datecreated",
Lines 285-290 __PACKAGE__->has_many( Link Here
285	{ cascade_copy => 0, cascade_delete => 0 },	285	{ cascade_copy => 0, cascade_delete => 0 },
286	);	286	);
287		287
		288	=head2 items_bundle
		289
		290	Type: might_have
		291
		292	Related object: L<Koha::Schema::Result::ItemsBundle>
		293
		294	=cut
		295
		296	__PACKAGE__->might_have(
		297	"items_bundle",
		298	"Koha::Schema::Result::ItemsBundle",
		299	{ "foreign.biblionumber" => "self.biblionumber" },
		300	{ cascade_copy => 0, cascade_delete => 0 },
		301	);
		302
288	=head2 old_reserves	303	=head2 old_reserves
289		304
290	Type: has_many	305	Type: has_many
Lines 406-413 __PACKAGE__->has_many( Link Here
406	);	421	);
407		422
408		423
409	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-01 07:08:47	424	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
410	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:otCex8qzJmZyc+JXpKNdpQ	425	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:swuobxQgc+thlB/K+3QZeA
411		426
412		427
413	__PACKAGE__->has_one(	428	__PACKAGE__->has_one(

Lines 425-431 __PACKAGE__->table("borrowers"); Link Here

(-)a/Koha/Schema/Result/Borrower.pm (-8 / +8 lines)
425		425
426	data_type: 'timestamp'	426	data_type: 'timestamp'
427	datetime_undef_if_invalid: 1	427	datetime_undef_if_invalid: 1
428	default_value: current_timestamp	428	default_value: 'current_timestamp()'
429	is_nullable: 0	429	is_nullable: 0
430		430
431	=head2 lastseen	431	=head2 lastseen
Lines 640-646 __PACKAGE__->add_columns( Link Here
640	{	640	{
641	data_type => "timestamp",	641	data_type => "timestamp",
642	datetime_undef_if_invalid => 1,	642	datetime_undef_if_invalid => 1,
643	default_value => \"current_timestamp",	643	default_value => "current_timestamp()",
644	is_nullable => 0,	644	is_nullable => 0,
645	},	645	},
646	"lastseen",	646	"lastseen",
Lines 1429-1445 __PACKAGE__->belongs_to( Link Here
1429	},	1429	},
1430	);	1430	);
1431		1431
1432	=head2 subscriptionroutinglists	1432	=head2 subscriptionroutings
1433		1433
1434	Type: has_many	1434	Type: has_many
1435		1435
1436	Related object: L<Koha::Schema::Result::Subscriptionroutinglist>	1436	Related object: L<Koha::Schema::Result::Subscriptionrouting>
1437		1437
1438	=cut	1438	=cut
1439		1439
1440	__PACKAGE__->has_many(	1440	__PACKAGE__->has_many(
1441	"subscriptionroutinglists",	1441	"subscriptionroutings",
1442	"Koha::Schema::Result::Subscriptionroutinglist",	1442	"Koha::Schema::Result::Subscriptionrouting",
1443	{ "foreign.borrowernumber" => "self.borrowernumber" },	1443	{ "foreign.borrowernumber" => "self.borrowernumber" },
1444	{ cascade_copy => 0, cascade_delete => 0 },	1444	{ cascade_copy => 0, cascade_delete => 0 },
1445	);	1445	);
Lines 1635-1642 Composing rels: L</aqorder_users> -> ordernumber Link Here
1635	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");	1635	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1636		1636
1637		1637
1638	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-10 14:31:00	1638	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
1639	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GjJLIOViIFRm185Yjl9vYA	1639	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9Ekh2ybmnaY+m5FxB7U6mQ
1640		1640
1641	__PACKAGE__->add_columns(	1641	__PACKAGE__->add_columns(
1642	'+anonymized' => { is_boolean => 1 },	1642	'+anonymized' => { is_boolean => 1 },

Lines 422-428 __PACKAGE__->table("deletedborrowers"); Link Here

(-)a/Koha/Schema/Result/Deletedborrower.pm (-4 / +4 lines)
422		422
423	data_type: 'timestamp'	423	data_type: 'timestamp'
424	datetime_undef_if_invalid: 1	424	datetime_undef_if_invalid: 1
425	default_value: current_timestamp	425	default_value: 'current_timestamp()'
426	is_nullable: 0	426	is_nullable: 0
427		427
428	=head2 lastseen	428	=head2 lastseen
Lines 625-631 __PACKAGE__->add_columns( Link Here
625	{	625	{
626	data_type => "timestamp",	626	data_type => "timestamp",
627	datetime_undef_if_invalid => 1,	627	datetime_undef_if_invalid => 1,
628	default_value => \"current_timestamp",	628	default_value => "current_timestamp()",
629	is_nullable => 0,	629	is_nullable => 0,
630	},	630	},
631	"lastseen",	631	"lastseen",
Lines 650-657 __PACKAGE__->add_columns( Link Here
650	);	650	);
651		651
652		652
653	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-05-22 04:33:29	653	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
654	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zK1jC6Wawwj8B2ch9KFByw	654	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4FJOURzbg7/amSUXECLJsQ
655		655
656	sub koha_objects_class {	656	sub koha_objects_class {
657	'Koha::Old::Patrons';	657	'Koha::Old::Patrons';

Lines 45-51 __PACKAGE__->table("account_debit_types"); Link Here

(-)a/Koha/Schema/Result/AccountDebitType.pm (-4 / +4 lines)
45		45
46	data_type: 'tinyint'	46	data_type: 'tinyint'
47	default_value: 0	47	default_value: 0
48	is_nullable: 0	48	is_nullable: 1
49		49
50	=head2 default_amount	50	=head2 default_amount
51		51
Lines 75-81 __PACKAGE__->add_columns( Link Here
75	"can_be_invoiced",	75	"can_be_invoiced",
76	{ data_type => "tinyint", default_value => 1, is_nullable => 0 },	76	{ data_type => "tinyint", default_value => 1, is_nullable => 0 },
77	"can_be_sold",	77	"can_be_sold",
78	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },	78	{ data_type => "tinyint", default_value => 0, is_nullable => 1 },
79	"default_amount",	79	"default_amount",
80	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },	80	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
81	"is_system",	81	"is_system",
Lines 129-136 __PACKAGE__->has_many( Link Here
129	);	129	);
130		130
131		131
132	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-17 12:22:04	132	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
133	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8FIMJZ+JAmqa+Dx7oymBjw	133	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qZfg9L2ysl2pJUiaBLwUFg
134		134
135	__PACKAGE__->add_columns(	135	__PACKAGE__->add_columns(
136	'+is_system' => { is_boolean => 1 }	136	'+is_system' => { is_boolean => 1 }

Lines 58-64 __PACKAGE__->table("account_offsets"); Link Here

(-)a/Koha/Schema/Result/AccountOffset.pm (-4 / +4 lines)
58		58
59	data_type: 'timestamp'	59	data_type: 'timestamp'
60	datetime_undef_if_invalid: 1	60	datetime_undef_if_invalid: 1
61	default_value: current_timestamp	61	default_value: 'current_timestamp()'
62	is_nullable: 0	62	is_nullable: 0
63		63
64	=cut	64	=cut
Lines 78-84 __PACKAGE__->add_columns( Link Here
78	{	78	{
79	data_type => "timestamp",	79	data_type => "timestamp",
80	datetime_undef_if_invalid => 1,	80	datetime_undef_if_invalid => 1,
81	default_value => \"current_timestamp",	81	default_value => "current_timestamp()",
82	is_nullable => 0,	82	is_nullable => 0,
83	},	83	},
84	);	84	);
Lines 153-160 __PACKAGE__->belongs_to( Link Here
153	);	153	);
154		154
155		155
156	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-20 16:27:04	156	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
157	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tPPrIug2c7PbDO7LCxCJAA	157	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mfS1B79dpfPc8VGdjT1+YA
158		158
159	sub koha_object_class {	159	sub koha_object_class {
160	'Koha::Account::Offset';	160	'Koha::Account::Offset';

Lines 33-39 __PACKAGE__->table("action_logs"); Link Here

(-)a/Koha/Schema/Result/ActionLog.pm (-4 / +4 lines)
33		33
34	data_type: 'timestamp'	34	data_type: 'timestamp'
35	datetime_undef_if_invalid: 1	35	datetime_undef_if_invalid: 1
36	default_value: current_timestamp	36	default_value: 'current_timestamp()'
37	is_nullable: 0	37	is_nullable: 0
38		38
39	=head2 user	39	=head2 user
Lines 77-83 __PACKAGE__->add_columns( Link Here
77	{	77	{
78	data_type => "timestamp",	78	data_type => "timestamp",
79	datetime_undef_if_invalid => 1,	79	datetime_undef_if_invalid => 1,
80	default_value => \"current_timestamp",	80	default_value => "current_timestamp()",
81	is_nullable => 0,	81	is_nullable => 0,
82	},	82	},
83	"user",	83	"user",
Lines 107-114 __PACKAGE__->add_columns( Link Here
107	__PACKAGE__->set_primary_key("action_id");	107	__PACKAGE__->set_primary_key("action_id");
108		108
109		109
110	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	110	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
111	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VVXBchLYkj+S+lLhl7bKgw	111	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TmMQtaJ4596Tj8mYKvZffA
112		112
113		113
114	# You can replace this text with custom code or comments, and it will be preserved on regeneration	114	# You can replace this text with custom code or comments, and it will be preserved on regeneration

Lines 82-88 __PACKAGE__->table("aqbudgets"); Link Here

(-)a/Koha/Schema/Result/Aqbudget.pm (-4 / +4 lines)
82		82
83	data_type: 'timestamp'	83	data_type: 'timestamp'
84	datetime_undef_if_invalid: 1	84	datetime_undef_if_invalid: 1
85	default_value: current_timestamp	85	default_value: 'current_timestamp()'
86	is_nullable: 0	86	is_nullable: 0
87		87
88	=head2 budget_period_id	88	=head2 budget_period_id
Lines 153-159 __PACKAGE__->add_columns( Link Here
153	{	153	{
154	data_type => "timestamp",	154	data_type => "timestamp",
155	datetime_undef_if_invalid => 1,	155	datetime_undef_if_invalid => 1,
156	default_value => \"current_timestamp",	156	default_value => "current_timestamp()",
157	is_nullable => 0,	157	is_nullable => 0,
158	},	158	},
159	"budget_period_id",	159	"budget_period_id",
Lines 298-305 Composing rels: L</aqbudgetborrowers> -> borrowernumber Link Here
298	__PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber");	298	__PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber");
299		299
300		300
301	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-16 13:50:45	301	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
302	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zB7ox8a4KdDGq5fsbQfLGQ	302	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:wbXfOXiR6q7jVleJyzsLWQ
303		303
304		304
305	sub koha_object_class {	305	sub koha_object_class {

Lines 68-74 __PACKAGE__->table("aqinvoice_adjustments"); Link Here

(-)a/Koha/Schema/Result/AqinvoiceAdjustment.pm (-4 / +4 lines)
68		68
69	data_type: 'timestamp'	69	data_type: 'timestamp'
70	datetime_undef_if_invalid: 1	70	datetime_undef_if_invalid: 1
71	default_value: current_timestamp	71	default_value: 'current_timestamp()'
72	is_nullable: 0	72	is_nullable: 0
73		73
74	=cut	74	=cut
Lines 92-98 __PACKAGE__->add_columns( Link Here
92	{	92	{
93	data_type => "timestamp",	93	data_type => "timestamp",
94	datetime_undef_if_invalid => 1,	94	datetime_undef_if_invalid => 1,
95	default_value => \"current_timestamp",	95	default_value => "current_timestamp()",
96	is_nullable => 0,	96	is_nullable => 0,
97	},	97	},
98	);	98	);
Lines 147-154 __PACKAGE__->belongs_to( Link Here
147	);	147	);
148		148
149		149
150	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-19 17:32:57	150	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
151	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jl0qxkZWVs2D1pi3kaRjpg	151	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:V0/9Hi5Uc9L2AnWcdzDn4g
152		152
153	sub koha_object_class {	153	sub koha_object_class {
154	'Koha::Acquisition::Invoice::Adjustment';	154	'Koha::Acquisition::Invoice::Adjustment';

Lines 143-149 __PACKAGE__->table("aqorders"); Link Here

(-)a/Koha/Schema/Result/Aqorder.pm (-4 / +4 lines)
143		143
144	data_type: 'timestamp'	144	data_type: 'timestamp'
145	datetime_undef_if_invalid: 1	145	datetime_undef_if_invalid: 1
146	default_value: current_timestamp	146	default_value: 'current_timestamp()'
147	is_nullable: 0	147	is_nullable: 0
148		148
149	=head2 rrp	149	=head2 rrp
Lines 371-377 __PACKAGE__->add_columns( Link Here
371	{	371	{
372	data_type => "timestamp",	372	data_type => "timestamp",
373	datetime_undef_if_invalid => 1,	373	datetime_undef_if_invalid => 1,
374	default_value => \"current_timestamp",	374	default_value => "current_timestamp()",
375	is_nullable => 0,	375	is_nullable => 0,
376	},	376	},
377	"rrp",	377	"rrp",
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.07049 @ 2020-02-20 10:01:41
665	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GQEXetlivZm7buQohl8m4A	665	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xXgooImZVlFvUzSJXHPWhQ
666		666
667	__PACKAGE__->belongs_to(	667	__PACKAGE__->belongs_to(
668	"basket",	668	"basket",

Lines 38-44 __PACKAGE__->table("aqorders_items"); Link Here

(-)a/Koha/Schema/Result/AqordersItem.pm (-4 / +4 lines)
38		38
39	data_type: 'timestamp'	39	data_type: 'timestamp'
40	datetime_undef_if_invalid: 1	40	datetime_undef_if_invalid: 1
41	default_value: current_timestamp	41	default_value: 'current_timestamp()'
42	is_nullable: 0	42	is_nullable: 0
43		43
44	=cut	44	=cut
Lines 52-58 __PACKAGE__->add_columns( Link Here
52	{	52	{
53	data_type => "timestamp",	53	data_type => "timestamp",
54	datetime_undef_if_invalid => 1,	54	datetime_undef_if_invalid => 1,
55	default_value => \"current_timestamp",	55	default_value => "current_timestamp()",
56	is_nullable => 0,	56	is_nullable => 0,
57	},	57	},
58	);	58	);
Lines 87-94 __PACKAGE__->belongs_to( Link Here
87	);	87	);
88		88
89		89
90	# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21	90	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
91	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hvDuLTY3idYc1ujykNDrPQ	91	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FLVvGzsei1T0NsB5+ubnXw
92		92
93		93
94	# 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

Lines 39-45 __PACKAGE__->table("aqorders_transfers"); Link Here

(-)a/Koha/Schema/Result/AqordersTransfer.pm (-4 / +4 lines)
39		39
40	data_type: 'timestamp'	40	data_type: 'timestamp'
41	datetime_undef_if_invalid: 1	41	datetime_undef_if_invalid: 1
42	default_value: current_timestamp	42	default_value: 'current_timestamp()'
43	is_nullable: 0	43	is_nullable: 0
44		44
45	=cut	45	=cut
Lines 53-59 __PACKAGE__->add_columns( Link Here
53	{	53	{
54	data_type => "timestamp",	54	data_type => "timestamp",
55	datetime_undef_if_invalid => 1,	55	datetime_undef_if_invalid => 1,
56	default_value => \"current_timestamp",	56	default_value => "current_timestamp()",
57	is_nullable => 0,	57	is_nullable => 0,
58	},	58	},
59	);	59	);
Lines 127-134 __PACKAGE__->belongs_to( Link Here
127	);	127	);
128		128
129		129
130	# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55	130	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
131	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Z6+vESlzZKjZloNvrEHpxA	131	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FqlytCU3bCmEDqWkOm2uuw
132		132
133		133
134	# You can replace this text with custom code or comments, and it will be preserved on regeneration	134	# You can replace this text with custom code or comments, and it will be preserved on regeneration

Lines 110-116 __PACKAGE__->table("article_requests"); Link Here

(-)a/Koha/Schema/Result/ArticleRequest.pm (-4 / +4 lines)
110		110
111	data_type: 'timestamp'	111	data_type: 'timestamp'
112	datetime_undef_if_invalid: 1	112	datetime_undef_if_invalid: 1
113	default_value: current_timestamp	113	default_value: 'current_timestamp()'
114	is_nullable: 0	114	is_nullable: 0
115		115
116	=head2 updated_on	116	=head2 updated_on
Lines 161-167 __PACKAGE__->add_columns( Link Here
161	{	161	{
162	data_type => "timestamp",	162	data_type => "timestamp",
163	datetime_undef_if_invalid => 1,	163	datetime_undef_if_invalid => 1,
164	default_value => \"current_timestamp",	164	default_value => "current_timestamp()",
165	is_nullable => 0,	165	is_nullable => 0,
166	},	166	},
167	"updated_on",	167	"updated_on",
Lines 257-264 __PACKAGE__->belongs_to( Link Here
257	);	257	);
258		258
259		259
260	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	260	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
261	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BOBB3vld8wY75u45YldoEg	261	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DZfgssb5lWBwXAQD4yFX2g
262		262
263		263
264	# You can replace this text with custom code or comments, and it will be preserved on regeneration	264	# You can replace this text with custom code or comments, and it will be preserved on regeneration

Lines 47-53 __PACKAGE__->table("auth_header"); Link Here

(-)a/Koha/Schema/Result/AuthHeader.pm (-4 / +4 lines)
47		47
48	data_type: 'timestamp'	48	data_type: 'timestamp'
49	datetime_undef_if_invalid: 1	49	datetime_undef_if_invalid: 1
50	default_value: current_timestamp	50	default_value: 'current_timestamp()'
51	is_nullable: 0	51	is_nullable: 0
52		52
53	=head2 origincode	53	=head2 origincode
Lines 94-100 __PACKAGE__->add_columns( Link Here
94	{	94	{
95	data_type => "timestamp",	95	data_type => "timestamp",
96	datetime_undef_if_invalid => 1,	96	datetime_undef_if_invalid => 1,
97	default_value => \"current_timestamp",	97	default_value => "current_timestamp()",
98	is_nullable => 0,	98	is_nullable => 0,
99	},	99	},
100	"origincode",	100	"origincode",
Lines 122-129 __PACKAGE__->add_columns( Link Here
122	__PACKAGE__->set_primary_key("authid");	122	__PACKAGE__->set_primary_key("authid");
123		123
124		124
125	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	125	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
126	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kHEdfMFYFtn3sQ20qsdFyg	126	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:78YWjMUi8plOllaNMWzmuw
127		127
128	sub koha_object_class {	128	sub koha_object_class {
129	'Koha::Authority';	129	'Koha::Authority';

Lines 56-62 __PACKAGE__->table("biblio_metadata"); Link Here

(-)a/Koha/Schema/Result/BiblioMetadata.pm (-4 / +4 lines)
56		56
57	data_type: 'timestamp'	57	data_type: 'timestamp'
58	datetime_undef_if_invalid: 1	58	datetime_undef_if_invalid: 1
59	default_value: current_timestamp	59	default_value: 'current_timestamp()'
60	is_nullable: 0	60	is_nullable: 0
61		61
62	=cut	62	=cut
Lines 76-82 __PACKAGE__->add_columns( Link Here
76	{	76	{
77	data_type => "timestamp",	77	data_type => "timestamp",
78	datetime_undef_if_invalid => 1,	78	datetime_undef_if_invalid => 1,
79	default_value => \"current_timestamp",	79	default_value => "current_timestamp()",
80	is_nullable => 0,	80	is_nullable => 0,
81	},	81	},
82	);	82	);
Lines 132-139 __PACKAGE__->belongs_to( Link Here
132	);	132	);
133		133
134		134
135	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-01-30 11:34:16	135	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
136	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FJk/YOw8Y/QRmmPPL3G5qQ	136	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5mMqx4y01pZfu8YrNvXDTQ
137		137
138	sub koha_object_class {	138	sub koha_object_class {
139	'Koha::Biblio::Metadata';	139	'Koha::Biblio::Metadata';

Lines 118-124 __PACKAGE__->table("biblioitems"); Link Here

(-)a/Koha/Schema/Result/Biblioitem.pm (-4 / +4 lines)
118		118
119	data_type: 'timestamp'	119	data_type: 'timestamp'
120	datetime_undef_if_invalid: 1	120	datetime_undef_if_invalid: 1
121	default_value: current_timestamp	121	default_value: 'current_timestamp()'
122	is_nullable: 0	122	is_nullable: 0
123		123
124	=head2 illus	124	=head2 illus
Lines 248-254 __PACKAGE__->add_columns( Link Here
248	{	248	{
249	data_type => "timestamp",	249	data_type => "timestamp",
250	datetime_undef_if_invalid => 1,	250	datetime_undef_if_invalid => 1,
251	default_value => \"current_timestamp",	251	default_value => "current_timestamp()",
252	is_nullable => 0,	252	is_nullable => 0,
253	},	253	},
254	"illus",	254	"illus",
Lines 326-333 __PACKAGE__->has_many( Link Here
326	);	326	);
327		327
328		328
329	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	329	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
330	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ogVRTKNaUQSI3BE2xC2lww	330	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Anhy+pvrQlPufkbe5qsJsQ
331		331
332	__PACKAGE__->belongs_to( biblio => "Koha::Schema::Result::Biblio", "biblionumber" );	332	__PACKAGE__->belongs_to( biblio => "Koha::Schema::Result::Biblio", "biblionumber" );
333		333

Lines 62-68 __PACKAGE__->table("borrower_debarments"); Link Here

(-)a/Koha/Schema/Result/BorrowerDebarment.pm (-4 / +4 lines)
62		62
63	data_type: 'timestamp'	63	data_type: 'timestamp'
64	datetime_undef_if_invalid: 1	64	datetime_undef_if_invalid: 1
65	default_value: current_timestamp	65	default_value: 'current_timestamp()'
66	is_nullable: 0	66	is_nullable: 0
67		67
68	=head2 updated	68	=head2 updated
Lines 95-101 __PACKAGE__->add_columns( Link Here
95	{	95	{
96	data_type => "timestamp",	96	data_type => "timestamp",
97	datetime_undef_if_invalid => 1,	97	datetime_undef_if_invalid => 1,
98	default_value => \"current_timestamp",	98	default_value => "current_timestamp()",
99	is_nullable => 0,	99	is_nullable => 0,
100	},	100	},
101	"updated",	101	"updated",
Lines 136-143 __PACKAGE__->belongs_to( Link Here
136	);	136	);
137		137
138		138
139	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	139	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
140	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:J9J1ReRLqhVasOQXvde2Uw	140	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tOAoFYn0a6MZgtvoFS15xQ
141		141
142		142
143	# You can replace this text with custom code or comments, and it will be preserved on regeneration	143	# You can replace this text with custom code or comments, and it will be preserved on regeneration

Lines 62-68 __PACKAGE__->table("borrower_files"); Link Here

(-)a/Koha/Schema/Result/BorrowerFile.pm (-4 / +4 lines)
62		62
63	data_type: 'timestamp'	63	data_type: 'timestamp'
64	datetime_undef_if_invalid: 1	64	datetime_undef_if_invalid: 1
65	default_value: current_timestamp	65	default_value: 'current_timestamp()'
66	is_nullable: 0	66	is_nullable: 0
67		67
68	=cut	68	=cut
Lines 84-90 __PACKAGE__->add_columns( Link Here
84	{	84	{
85	data_type => "timestamp",	85	data_type => "timestamp",
86	datetime_undef_if_invalid => 1,	86	datetime_undef_if_invalid => 1,
87	default_value => \"current_timestamp",	87	default_value => "current_timestamp()",
88	is_nullable => 0,	88	is_nullable => 0,
89	},	89	},
90	);	90	);
Lines 119-126 __PACKAGE__->belongs_to( Link Here
119	);	119	);
120		120
121		121
122	# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21	122	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
123	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sbkf7bvdO4CgmiBLgIwYQg	123	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CRCwGgDaSvO7nc4Nkyb3Cw
124		124
125		125
126	# You can replace this text with custom content, and it will be preserved on regeneration	126	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 27-33 __PACKAGE__->table("borrower_modifications"); Link Here

(-)a/Koha/Schema/Result/BorrowerModification.pm (-4 / +4 lines)
27		27
28	data_type: 'timestamp'	28	data_type: 'timestamp'
29	datetime_undef_if_invalid: 1	29	datetime_undef_if_invalid: 1
30	default_value: current_timestamp	30	default_value: 'current_timestamp()'
31	is_nullable: 0	31	is_nullable: 0
32		32
33	=head2 verification_token	33	=head2 verification_token
Lines 428-434 __PACKAGE__->add_columns( Link Here
428	{	428	{
429	data_type => "timestamp",	429	data_type => "timestamp",
430	datetime_undef_if_invalid => 1,	430	datetime_undef_if_invalid => 1,
431	default_value => \"current_timestamp",	431	default_value => "current_timestamp()",
432	is_nullable => 0,	432	is_nullable => 0,
433	},	433	},
434	"verification_token",	434	"verification_token",
Lines 610-617 __PACKAGE__->add_columns( Link Here
610	__PACKAGE__->set_primary_key("verification_token", "borrowernumber");	610	__PACKAGE__->set_primary_key("verification_token", "borrowernumber");
611		611
612		612
613	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-07-22 16:54:42	613	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
614	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jkZUTN+mGIdp8ySV0BYNTw	614	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kwyyiaDxYxdTaYEdcEX8yg
615		615
616	sub koha_object_class {	616	sub koha_object_class {
617	'Koha::Patron::Modification';	617	'Koha::Patron::Modification';

Lines 38-44 __PACKAGE__->table("borrower_password_recovery"); Link Here

(-)a/Koha/Schema/Result/BorrowerPasswordRecovery.pm (-4 / +4 lines)
38		38
39	data_type: 'timestamp'	39	data_type: 'timestamp'
40	datetime_undef_if_invalid: 1	40	datetime_undef_if_invalid: 1
41	default_value: current_timestamp	41	default_value: 'current_timestamp()'
42	is_nullable: 0	42	is_nullable: 0
43		43
44	=cut	44	=cut
Lines 52-58 __PACKAGE__->add_columns( Link Here
52	{	52	{
53	data_type => "timestamp",	53	data_type => "timestamp",
54	datetime_undef_if_invalid => 1,	54	datetime_undef_if_invalid => 1,
55	default_value => \"current_timestamp",	55	default_value => "current_timestamp()",
56	is_nullable => 0,	56	is_nullable => 0,
57	},	57	},
58	);	58	);
Lines 70-77 __PACKAGE__->add_columns( Link Here
70	__PACKAGE__->set_primary_key("borrowernumber");	70	__PACKAGE__->set_primary_key("borrowernumber");
71		71
72		72
73	# Created by DBIx::Class::Schema::Loader v0.07025 @ 2016-01-22 10:16:52	73	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
74	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:c4ehAGqOD6YHpGg85BX8YQ	74	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rQvacObXzIDRx+cnDgX6uA
75		75
76		76
77	# You can replace this text with custom code or comments, and it will be preserved on regeneration	77	# You can replace this text with custom code or comments, and it will be preserved on regeneration

Lines 68-74 __PACKAGE__->table("clubs"); Link Here

(-)a/Koha/Schema/Result/Club.pm (-4 / +4 lines)
68		68
69	data_type: 'timestamp'	69	data_type: 'timestamp'
70	datetime_undef_if_invalid: 1	70	datetime_undef_if_invalid: 1
71	default_value: current_timestamp	71	default_value: 'current_timestamp()'
72	is_nullable: 0	72	is_nullable: 0
73		73
74	=head2 date_updated	74	=head2 date_updated
Lines 98-104 __PACKAGE__->add_columns( Link Here
98	{	98	{
99	data_type => "timestamp",	99	data_type => "timestamp",
100	datetime_undef_if_invalid => 1,	100	datetime_undef_if_invalid => 1,
101	default_value => \"current_timestamp",	101	default_value => "current_timestamp()",
102	is_nullable => 0,	102	is_nullable => 0,
103	},	103	},
104	"date_updated",	104	"date_updated",
Lines 204-211 __PACKAGE__->belongs_to( Link Here
204	);	204	);
205		205
206		206
207	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-01 07:08:47	207	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
208	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WbB7PSSU4xaszsKe9Eacqw	208	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:q0tsXoANaJ0laHSyzhvWBg
209		209
210		210
211	# You can replace this text with custom content, and it will be preserved on regeneration	211	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 45-51 __PACKAGE__->table("club_enrollments"); Link Here

(-)a/Koha/Schema/Result/ClubEnrollment.pm (-4 / +4 lines)
45		45
46	data_type: 'timestamp'	46	data_type: 'timestamp'
47	datetime_undef_if_invalid: 1	47	datetime_undef_if_invalid: 1
48	default_value: current_timestamp	48	default_value: 'current_timestamp()'
49	is_nullable: 0	49	is_nullable: 0
50		50
51	=head2 date_canceled	51	=head2 date_canceled
Lines 86-92 __PACKAGE__->add_columns( Link Here
86	{	86	{
87	data_type => "timestamp",	87	data_type => "timestamp",
88	datetime_undef_if_invalid => 1,	88	datetime_undef_if_invalid => 1,
89	default_value => \"current_timestamp",	89	default_value => "current_timestamp()",
90	is_nullable => 0,	90	is_nullable => 0,
91	},	91	},
92	"date_canceled",	92	"date_canceled",
Lines 191-198 __PACKAGE__->has_many( Link Here
191	);	191	);
192		192
193		193
194	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-12 17:59:47	194	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
195	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ih/HQM4KIRDZ0ESXVR9FwA	195	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BGc4RqbBSCR6uniY1/ra4Q
196		196
197	sub koha_object_class {	197	sub koha_object_class {
198	'Koha::Club::Enrollment';	198	'Koha::Club::Enrollment';

Lines 51-57 __PACKAGE__->table("club_holds"); Link Here

(-)a/Koha/Schema/Result/ClubHold.pm (-4 / +4 lines)
51		51
52	data_type: 'timestamp'	52	data_type: 'timestamp'
53	datetime_undef_if_invalid: 1	53	datetime_undef_if_invalid: 1
54	default_value: current_timestamp	54	default_value: 'current_timestamp()'
55	is_nullable: 0	55	is_nullable: 0
56		56
57	=cut	57	=cut
Lines 69-75 __PACKAGE__->add_columns( Link Here
69	{	69	{
70	data_type => "timestamp",	70	data_type => "timestamp",
71	datetime_undef_if_invalid => 1,	71	datetime_undef_if_invalid => 1,
72	default_value => \"current_timestamp",	72	default_value => "current_timestamp()",
73	is_nullable => 0,	73	is_nullable => 0,
74	},	74	},
75	);	75	);
Lines 154-161 __PACKAGE__->belongs_to( Link Here
154	);	154	);
155		155
156		156
157	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-01 07:08:47	157	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
158	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FYGXVx1P2R+dGbeP1xshPA	158	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ccFlKbTvIRs4u01E8qqnRg
159		159
160	sub koha_objects_class {	160	sub koha_objects_class {
161	'Koha::Club::Holds';	161	'Koha::Club::Holds';

Lines 62-68 __PACKAGE__->table("club_templates"); Link Here

(-)a/Koha/Schema/Result/ClubTemplate.pm (-4 / +4 lines)
62		62
63	data_type: 'timestamp'	63	data_type: 'timestamp'
64	datetime_undef_if_invalid: 1	64	datetime_undef_if_invalid: 1
65	default_value: current_timestamp	65	default_value: 'current_timestamp()'
66	is_nullable: 0	66	is_nullable: 0
67		67
68	=head2 date_updated	68	=head2 date_updated
Lines 96-102 __PACKAGE__->add_columns( Link Here
96	{	96	{
97	data_type => "timestamp",	97	data_type => "timestamp",
98	datetime_undef_if_invalid => 1,	98	datetime_undef_if_invalid => 1,
99	default_value => \"current_timestamp",	99	default_value => "current_timestamp()",
100	is_nullable => 0,	100	is_nullable => 0,
101	},	101	},
102	"date_updated",	102	"date_updated",
Lines 189-196 __PACKAGE__->has_many( Link Here
189	);	189	);
190		190
191		191
192	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	192	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
193	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1UuejI9kkTb9eeNKvSLAQQ	193	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YUzYhnCe19rp6VL0cJZQvA
194		194
195	sub koha_object_class {	195	sub koha_object_class {
196	'Koha::Club::Template';	196	'Koha::Club::Template';

Lines 86-92 __PACKAGE__->table("courses"); Link Here

(-)a/Koha/Schema/Result/Course.pm (-4 / +4 lines)
86		86
87	data_type: 'timestamp'	87	data_type: 'timestamp'
88	datetime_undef_if_invalid: 1	88	datetime_undef_if_invalid: 1
89	default_value: current_timestamp	89	default_value: 'current_timestamp()'
90	is_nullable: 0	90	is_nullable: 0
91		91
92	=cut	92	=cut
Lines 121-127 __PACKAGE__->add_columns( Link Here
121	{	121	{
122	data_type => "timestamp",	122	data_type => "timestamp",
123	datetime_undef_if_invalid => 1,	123	datetime_undef_if_invalid => 1,
124	default_value => \"current_timestamp",	124	default_value => "current_timestamp()",
125	is_nullable => 0,	125	is_nullable => 0,
126	},	126	},
127	);	127	);
Lines 181-188 Composing rels: L</course_instructors> -> borrowernumber Link Here
181	__PACKAGE__->many_to_many("borrowernumbers", "course_instructors", "borrowernumber");	181	__PACKAGE__->many_to_many("borrowernumbers", "course_instructors", "borrowernumber");
182		182
183		183
184	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	184	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
185	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:o0EBOuJCHxH5IG/PgsJfxg	185	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yeukLUSqlLJNVHxKDC7HOQ
186		186
187		187
188	# You can replace this text with custom content, and it will be preserved on regeneration	188	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 71-77 __PACKAGE__->table("course_items"); Link Here

(-)a/Koha/Schema/Result/CourseItem.pm (-4 / +4 lines)
71		71
72	data_type: 'timestamp'	72	data_type: 'timestamp'
73	datetime_undef_if_invalid: 1	73	datetime_undef_if_invalid: 1
74	default_value: current_timestamp	74	default_value: 'current_timestamp()'
75	is_nullable: 0	75	is_nullable: 0
76		76
77	=cut	77	=cut
Lines 100-106 __PACKAGE__->add_columns( Link Here
100	{	100	{
101	data_type => "timestamp",	101	data_type => "timestamp",
102	datetime_undef_if_invalid => 1,	102	datetime_undef_if_invalid => 1,
103	default_value => \"current_timestamp",	103	default_value => "current_timestamp()",
104	is_nullable => 0,	104	is_nullable => 0,
105	},	105	},
106	);	106	);
Lines 184-191 __PACKAGE__->belongs_to( Link Here
184	);	184	);
185		185
186		186
187	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-09-26 16:15:09	187	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
188	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0hBp2R7AMxgHLLZcG/676w	188	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VcUbKGA6rEwIg4cRse4fEg
189		189
190		190
191	# You can replace this text with custom content, and it will be preserved on regeneration	191	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 55-61 __PACKAGE__->table("course_reserves"); Link Here

(-)a/Koha/Schema/Result/CourseReserve.pm (-4 / +4 lines)
55		55
56	data_type: 'timestamp'	56	data_type: 'timestamp'
57	datetime_undef_if_invalid: 1	57	datetime_undef_if_invalid: 1
58	default_value: current_timestamp	58	default_value: 'current_timestamp()'
59	is_nullable: 0	59	is_nullable: 0
60		60
61	=cut	61	=cut
Lines 75-81 __PACKAGE__->add_columns( Link Here
75	{	75	{
76	data_type => "timestamp",	76	data_type => "timestamp",
77	datetime_undef_if_invalid => 1,	77	datetime_undef_if_invalid => 1,
78	default_value => \"current_timestamp",	78	default_value => "current_timestamp()",
79	is_nullable => 0,	79	is_nullable => 0,
80	},	80	},
81	);	81	);
Lines 141-148 __PACKAGE__->belongs_to( Link Here
141	);	141	);
142		142
143		143
144	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	144	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
145	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8SDdUrbxKuAwp6rgn85RmA	145	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ocHPOi2tze1PQCzzw9qY5w
146		146
147		147
148	# You can replace this text with custom content, and it will be preserved on regeneration	148	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 56-62 __PACKAGE__->table("creator_batches"); Link Here

(-)a/Koha/Schema/Result/CreatorBatch.pm (-4 / +4 lines)
56		56
57	data_type: 'timestamp'	57	data_type: 'timestamp'
58	datetime_undef_if_invalid: 1	58	datetime_undef_if_invalid: 1
59	default_value: current_timestamp	59	default_value: 'current_timestamp()'
60	is_nullable: 0	60	is_nullable: 0
61		61
62	=head2 branch_code	62	=head2 branch_code
Lines 91-97 __PACKAGE__->add_columns( Link Here
91	{	91	{
92	data_type => "timestamp",	92	data_type => "timestamp",
93	datetime_undef_if_invalid => 1,	93	datetime_undef_if_invalid => 1,
94	default_value => \"current_timestamp",	94	default_value => "current_timestamp()",
95	is_nullable => 0,	95	is_nullable => 0,
96	},	96	},
97	"branch_code",	97	"branch_code",
Lines 181-188 __PACKAGE__->belongs_to( Link Here
181	);	181	);
182		182
183		183
184	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-24 17:34:29	184	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
185	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5SOMkaJ6IxGtnqtPVFpNtg	185	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:g3vD+wvEsI0GBWyvSMEFqg
186		186
187		187
188	# You can replace this text with custom content, and it will be preserved on regeneration	188	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 46-52 __PACKAGE__->table("currency"); Link Here

(-)a/Koha/Schema/Result/Currency.pm (-4 / +4 lines)
46		46
47	data_type: 'timestamp'	47	data_type: 'timestamp'
48	datetime_undef_if_invalid: 1	48	datetime_undef_if_invalid: 1
49	default_value: current_timestamp	49	default_value: 'current_timestamp()'
50	is_nullable: 0	50	is_nullable: 0
51		51
52	=head2 rate	52	=head2 rate
Lines 85-91 __PACKAGE__->add_columns( Link Here
85	{	85	{
86	data_type => "timestamp",	86	data_type => "timestamp",
87	datetime_undef_if_invalid => 1,	87	datetime_undef_if_invalid => 1,
88	default_value => \"current_timestamp",	88	default_value => "current_timestamp()",
89	is_nullable => 0,	89	is_nullable => 0,
90	},	90	},
91	"rate",	91	"rate",
Lines 158-165 __PACKAGE__->has_many( Link Here
158	);	158	);
159		159
160		160
161	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-01 14:23:58	161	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
162	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PnJEcCgrM1Edf99phWFdyQ	162	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YaSxkG7ZGqegVkIif7NDjQ
163		163
164		164
165	sub koha_object_class {	165	sub koha_object_class {

Lines 95-101 __PACKAGE__->table("deletedbiblio"); Link Here

(-)a/Koha/Schema/Result/Deletedbiblio.pm (-4 / +4 lines)
95		95
96	data_type: 'timestamp'	96	data_type: 'timestamp'
97	datetime_undef_if_invalid: 1	97	datetime_undef_if_invalid: 1
98	default_value: current_timestamp	98	default_value: 'current_timestamp()'
99	is_nullable: 0	99	is_nullable: 0
100		100
101	=head2 datecreated	101	=head2 datecreated
Lines 142-148 __PACKAGE__->add_columns( Link Here
142	{	142	{
143	data_type => "timestamp",	143	data_type => "timestamp",
144	datetime_undef_if_invalid => 1,	144	datetime_undef_if_invalid => 1,
145	default_value => \"current_timestamp",	145	default_value => "current_timestamp()",
146	is_nullable => 0,	146	is_nullable => 0,
147	},	147	},
148	"datecreated",	148	"datecreated",
Lines 181-188 __PACKAGE__->has_many( Link Here
181	);	181	);
182		182
183		183
184	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-08-05 13:53:34	184	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
185	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FQaznWmkfR2Ge5NG8lDmSw	185	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9Xm2vadUVskBiHj/Ex84Sg
186		186
187	sub koha_objects_class {	187	sub koha_objects_class {
188	'Koha::Old::Biblios';	188	'Koha::Old::Biblios';

Lines 56-62 __PACKAGE__->table("deletedbiblio_metadata"); Link Here

(-)a/Koha/Schema/Result/DeletedbiblioMetadata.pm (-4 / +4 lines)
56		56
57	data_type: 'timestamp'	57	data_type: 'timestamp'
58	datetime_undef_if_invalid: 1	58	datetime_undef_if_invalid: 1
59	default_value: current_timestamp	59	default_value: 'current_timestamp()'
60	is_nullable: 0	60	is_nullable: 0
61		61
62	=cut	62	=cut
Lines 76-82 __PACKAGE__->add_columns( Link Here
76	{	76	{
77	data_type => "timestamp",	77	data_type => "timestamp",
78	datetime_undef_if_invalid => 1,	78	datetime_undef_if_invalid => 1,
79	default_value => \"current_timestamp",	79	default_value => "current_timestamp()",
80	is_nullable => 0,	80	is_nullable => 0,
81	},	81	},
82	);	82	);
Lines 132-139 __PACKAGE__->belongs_to( Link Here
132	);	132	);
133		133
134		134
135	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-01-30 11:34:16	135	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
136	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JCOh+FSSTgPlC8lMJOdOOA	136	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nIqHgwWZQKbGDIGTwNcR9w
137		137
138		138
139	# You can replace this text with custom code or comments, and it will be preserved on regeneration	139	# You can replace this text with custom code or comments, and it will be preserved on regeneration

Lines 117-123 __PACKAGE__->table("deletedbiblioitems"); Link Here

(-)a/Koha/Schema/Result/Deletedbiblioitem.pm (-4 / +4 lines)
117		117
118	data_type: 'timestamp'	118	data_type: 'timestamp'
119	datetime_undef_if_invalid: 1	119	datetime_undef_if_invalid: 1
120	default_value: current_timestamp	120	default_value: 'current_timestamp()'
121	is_nullable: 0	121	is_nullable: 0
122		122
123	=head2 illus	123	=head2 illus
Lines 242-248 __PACKAGE__->add_columns( Link Here
242	{	242	{
243	data_type => "timestamp",	243	data_type => "timestamp",
244	datetime_undef_if_invalid => 1,	244	datetime_undef_if_invalid => 1,
245	default_value => \"current_timestamp",	245	default_value => "current_timestamp()",
246	is_nullable => 0,	246	is_nullable => 0,
247	},	247	},
248	"illus",	248	"illus",
Lines 288-295 __PACKAGE__->add_columns( Link Here
288	__PACKAGE__->set_primary_key("biblioitemnumber");	288	__PACKAGE__->set_primary_key("biblioitemnumber");
289		289
290		290
291	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	291	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
292	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QLYBa1Ea8Jau2Wy6U+wyQw	292	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:A8v0vpPFLetnTSuMAb6SYA
293		293
294	sub koha_objects_class {	294	sub koha_objects_class {
295	'Koha::Old::Biblioitems';	295	'Koha::Old::Biblioitems';

Lines 198-204 __PACKAGE__->table("deleteditems"); Link Here

(-)a/Koha/Schema/Result/Deleteditem.pm (-4 / +4 lines)
198		198
199	data_type: 'timestamp'	199	data_type: 'timestamp'
200	datetime_undef_if_invalid: 1	200	datetime_undef_if_invalid: 1
201	default_value: current_timestamp	201	default_value: 'current_timestamp()'
202	is_nullable: 0	202	is_nullable: 0
203		203
204	=head2 location	204	=head2 location
Lines 360-366 __PACKAGE__->add_columns( Link Here
360	{	360	{
361	data_type => "timestamp",	361	data_type => "timestamp",
362	datetime_undef_if_invalid => 1,	362	datetime_undef_if_invalid => 1,
363	default_value => \"current_timestamp",	363	default_value => "current_timestamp()",
364	is_nullable => 0,	364	is_nullable => 0,
365	},	365	},
366	"location",	366	"location",
Lines 406-413 __PACKAGE__->add_columns( Link Here
406	__PACKAGE__->set_primary_key("itemnumber");	406	__PACKAGE__->set_primary_key("itemnumber");
407		407
408		408
409	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-02-17 10:42:24	409	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
410	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1+z3OHx5OpOcP82k8vyAaA	410	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:d5Keiv9fRJlOT27yRtMX2w
411		411
412	sub koha_objects_class {	412	sub koha_objects_class {
413	'Koha::Old::Items';	413	'Koha::Old::Items';

Lines 51-57 __PACKAGE__->table("illcomments"); Link Here

(-)a/Koha/Schema/Result/Illcomment.pm (-4 / +4 lines)
51		51
52	data_type: 'timestamp'	52	data_type: 'timestamp'
53	datetime_undef_if_invalid: 1	53	datetime_undef_if_invalid: 1
54	default_value: current_timestamp	54	default_value: 'current_timestamp()'
55	is_nullable: 0	55	is_nullable: 0
56		56
57	=cut	57	=cut
Lines 74-80 __PACKAGE__->add_columns( Link Here
74	{	74	{
75	data_type => "timestamp",	75	data_type => "timestamp",
76	datetime_undef_if_invalid => 1,	76	datetime_undef_if_invalid => 1,
77	default_value => \"current_timestamp",	77	default_value => "current_timestamp()",
78	is_nullable => 0,	78	is_nullable => 0,
79	},	79	},
80	);	80	);
Lines 129-136 __PACKAGE__->belongs_to( Link Here
129	);	129	);
130		130
131		131
132	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-26 19:57:17	132	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-20 10:01:41
133	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JJC9ohn0V61+WzMppDKUJw	133	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:taV0nPCmNLIflefOr5YMKQ
134		134
135		135
136	# You can replace this text with custom code or comments, and it will be preserved on regeneration	136	# You can replace this text with custom code or comments, and it will be preserved on regeneration