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

(-)a/installer/data/mysql/atomicupdate/bug_31212_dbrev.pl (-1 / +17 lines)
Line 0 Link Here
0
- 
1
use Modern::Perl;
2
3
return {
4
    bug_number => "31212",
5
    description => "Update items.datelastseen and deleteditems.datelastseen to datetime data format",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        $dbh->do(q{
10
            ALTER TABLE `items` MODIFY COLUMN `datelastseen` DATETIME DEFAULT NULL
11
        });
12
        $dbh->do(q{
13
            ALTER TABLE `deleteditems` MODIFY COLUMN `datelastseen` DATETIME DEFAULT NULL
14
        });
15
        say $out "items and deleteditems table updated";
16
    },
17
};

Return to bug 31212