# - #4 : the developer version. The 4th number is the database subversion.
# used by developers when the database changes. updatedatabase take care of the changes itself
# and is automatically called by Auth.pm when needed.
-$VERSION = "19.12.00.030";
+$VERSION = "19.12.00.031";
sub version {
return $VERSION;
data_type: 'timestamp'
datetime_undef_if_invalid: 1
- default_value: current_timestamp
- is_nullable: 0
+ is_nullable: 1
=head2 updated_on
data_type: 'timestamp'
datetime_undef_if_invalid: 1
- is_nullable: 1
+ default_value: current_timestamp
+ is_nullable: 0
=cut
{
data_type => "timestamp",
datetime_undef_if_invalid => 1,
- default_value => \"current_timestamp",
- is_nullable => 0,
+ is_nullable => 1,
},
"updated_on",
{
data_type => "timestamp",
datetime_undef_if_invalid => 1,
- is_nullable => 1,
+ default_value => \"current_timestamp",
+ is_nullable => 0,
},
);
);
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BOBB3vld8wY75u45YldoEg
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-02 09:44:27
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Dhz1mVI7Z/6ibqaBZkPvUA
# You can replace this text with custom code or comments, and it will be preserved on regeneration
+++ /dev/null
-$DBversion = 'XXX'; # will be replaced by the RM
-if( CheckVersion( $DBversion ) ) {
- $dbh->do( q|
-ALTER TABLE article_requests MODIFY COLUMN created_on timestamp NULL, MODIFY COLUMN updated_on timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
- |);
- SetVersion( $DBversion );
- print "Upgrade to $DBversion done (Bug 22273: Column article_requests.created_on should not be updated)\n";
-}
print "Upgrade to $DBversion done (Bug 22880: Move contents of opacheader preference to Koha news system)\n";
}
+$DBversion = '19.12.00.031';
+if( CheckVersion( $DBversion ) ) {
+ $dbh->do( q|
+ALTER TABLE article_requests MODIFY COLUMN created_on timestamp NULL, MODIFY COLUMN updated_on timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
+ |);
+ SetVersion( $DBversion );
+ print "Upgrade to $DBversion done (Bug 22273: Column article_requests.created_on should not be updated)\n";
+}
+
# SEE bug 13068
# if there is anything in the atomicupdate, read and execute it.
my $update_dir = C4::Context->config('intranetdir') . '/installer/data/mysql/atomicupdate/';