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

(-)a/installer/data/mysql/atomicupdate/bug_24239-add_date_due_to_illrequests.pl (-7 / +9 lines)
Lines 1-15 Link Here
1
use Modern::Perl;
1
use Modern::Perl;
2
2
3
return {
3
return {
4
    bug_number => "24239",
4
    bug_number  => "24239",
5
    description => "Add due_date to illrequests",
5
    description => "Add due_date to illrequests",
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
        # Do you stuffs here
9
10
        $dbh->do(q{
10
        unless ( column_exists( 'illrequests', 'due_date' ) ) {
11
            ALTER TABLE `illrequests`
11
            $dbh->do(q{
12
            ADD `due_date` datetime DEFAULT NULL AFTER `biblio_id`
12
                ALTER TABLE `illrequests`
13
        });
13
                    ADD COLUMN `due_date` datetime DEFAULT NULL COMMENT 'Custom date due specified by backend, leave NULL for default date_due calculation'
14
                    AFTER `biblio_id`
15
            });
16
        }
14
    },
17
    },
15
};
18
};
16
- 

Return to bug 24239