Attachment #147225 for bug #33051

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




use Modern::Perl;

return {
    bug_number  => "31948",
    description => "Add timestamp to tmp_holdsqueue table",
    up => sub {
        my ($args) = @_;
        my ($dbh, $out) = @$args{qw(dbh out)};

        unless ( column_exists( 'tmp_holdsqueue', 'timestamp' ) ) {
            $dbh->do(q{
                ALTER TABLE `tmp_holdsqueue`
                    ADD `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP AFTER item_level_request
            });
        }
    },
};
- 

Return to bug 33051

Lines 1-12 Link Here

(-)a/installer/data/mysql/db_revs/220600075.pl (-3 / +7 lines)
1	use Modern::Perl;	1	use Modern::Perl;
2		2
3	return {	3	return {
4	bug_number => "31948",	4	bug_number => "31948",
5	description => "Add timestamp to tmp_holdsqueue table",	5	description => "Add timestamp to tmp_holdsqueue table",
6	up => sub {	6	up => sub {
7	my ($args) = @_;	7	my ($args) = @_;
8	my ($dbh, $out) = @$args{qw(dbh out)};	8	my ($dbh, $out) = @$args{qw(dbh out)};
9		9
10	$dbh->do(q{ALTER TABLE `tmp_holdsqueue` ADD `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP AFTER item_level_request});	10	unless ( column_exists( 'tmp_holdsqueue', 'timestamp' ) ) {
		11	$dbh->do(q{
		12	ALTER TABLE `tmp_holdsqueue`
		13	ADD `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP AFTER item_level_request
		14	});
		15	}
11	},	16	},
12	};	17	};
13	-