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

(-)a/installer/data/mysql/atomicupdate/bug_8367-add_holds_pickup_period_circrule.perl (-2 / +5 lines)
Lines 1-6 Link Here
1
$DBversion = 'XXX';
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q{INSERT IGNORE INTO circulation_rules (branchcode, categorycode, itemtype, rule_name, rule_value) VALUES (NULL, NULL, NULL, 'holds_pickup_period', NULL) });
3
    $dbh->do(q{
4
        INSERT INTO circulation_rules (branchcode, categorycode, itemtype, rule_name, rule_value)
5
        SELECT NULL, NULL, NULL, 'holds_pickup_period', ''
6
        WHERE NOT EXISTS ( SELECT rule_name FROM circulation_rules where rule_name = 'holds_pickup_period' )
7
    });
4
8
5
    NewVersion( $DBversion, 8367, "Add holds_pickup_period circulation rule" );
9
    NewVersion( $DBversion, 8367, "Add holds_pickup_period circulation rule" );
6
}
10
}
7
- 

Return to bug 8367