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

(-)a/Koha/Schema/Result/Virtualshelve.pm (-6 / +4 lines)
Lines 63-71 __PACKAGE__->table("virtualshelves"); Link Here
63
63
64
=head2 created_on
64
=head2 created_on
65
65
66
  data_type: 'timestamp'
66
  data_type: 'datetime'
67
  datetime_undef_if_invalid: 1
67
  datetime_undef_if_invalid: 1
68
  default_value: '0000-00-00 00:00:00'
69
  is_nullable: 0
68
  is_nullable: 0
70
69
71
=head2 allow_add
70
=head2 allow_add
Lines 113-121 __PACKAGE__->add_columns( Link Here
113
  },
112
  },
114
  "created_on",
113
  "created_on",
115
  {
114
  {
116
    data_type => "timestamp",
115
    data_type => "datetime",
117
    datetime_undef_if_invalid => 1,
116
    datetime_undef_if_invalid => 1,
118
    default_value => "0000-00-00 00:00:00",
119
    is_nullable => 0,
117
    is_nullable => 0,
120
  },
118
  },
121
  "allow_add",
119
  "allow_add",
Lines 191-198 __PACKAGE__->has_many( Link Here
191
);
189
);
192
190
193
191
194
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-11-05 10:39:28
192
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-08-02 04:25:22
195
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:O3y89+0IUoePtcIHAqR+oA
193
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FoBdYVoFQA19R1PMWqykYA
196
194
197
195
198
# You can replace this text with custom content, and it will be preserved on regeneration
196
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/installer/data/mysql/updatedatabase.pl (-3 / +2 lines)
Lines 12789-12798 if ( CheckVersion($DBversion) ) { Link Here
12789
$DBversion = '16.06.00.012';
12789
$DBversion = '16.06.00.012';
12790
if ( CheckVersion($DBversion) ) {
12790
if ( CheckVersion($DBversion) ) {
12791
    $dbh->do(q{
12791
    $dbh->do(q{
12792
        ALTER TABLE virtualshelves MODIFY COLUMN created_on DATETIME not NULL;
12792
        ALTER IGNORE TABLE virtualshelves MODIFY COLUMN created_on DATETIME not NULL;
12793
    });
12793
    });
12794
12794
12795
    print "Upgrade to $DBversion done (Bug 16573 - Web installer fails to load structure and sample data on MySQL 5.7)\n";
12795
    print "Upgrade to $DBversion done (Bug 16573: Web installer fails to load structure and sample data on MySQL 5.7)\n";
12796
    SetVersion($DBversion);
12796
    SetVersion($DBversion);
12797
}
12797
}
12798
12798
12799
- 

Return to bug 16573