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

(-)a/installer/data/mysql/atomicupdate/bug_27944.perl (-2 / +2 lines)
Lines 5-10 if ( CheckVersion($DBversion) ) { Link Here
5
    $dbh->do(
5
    $dbh->do(
6
"ALTER TABLE `article_requests` MODIFY `status` enum('REQUESTED', 'PENDING','PROCESSING','COMPLETED','CANCELED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'REQUESTED'"
6
"ALTER TABLE `article_requests` MODIFY `status` enum('REQUESTED', 'PENDING','PROCESSING','COMPLETED','CANCELED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'REQUESTED'"
7
    );
7
    );
8
    $dbh->do(q|UPDATE article_requests SET status='REQUESTED' WHERE status='PENDING'|);
8
9
9
    $dbh->do(
10
    $dbh->do(
10
        q{
11
        q{
Lines 14-20 if ( CheckVersion($DBversion) ) { Link Here
14
        WHERE   `module` = 'circulation'
15
        WHERE   `module` = 'circulation'
15
                AND `code` = 'AR_PENDING'
16
                AND `code` = 'AR_PENDING'
16
    }
17
    }
17
    );
18
    ) if ( $dbh->selectrow_array('SELECT COUNT(*) FROM letter WHERE code=?', undef, 'AR_REQUESTED') )[0] == 0; # Check to make idempotent
18
19
19
    $dbh->do(
20
    $dbh->do(
20
        q{
21
        q{
21
- 

Return to bug 27944