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 (-3 / +2 lines)
Lines 2-9 $DBversion = 'XXX'; Link Here
2
if( CheckVersion( $DBversion ) ) {
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q{
3
    $dbh->do(q{
4
        INSERT INTO circulation_rules (branchcode, categorycode, itemtype, rule_name, rule_value)
4
        INSERT INTO circulation_rules (branchcode, categorycode, itemtype, rule_name, rule_value)
5
        SELECT NULL, NULL, NULL, 'holds_pickup_period', ''
5
        SELECT u.* FROM (SELECT NULL as branchcode, NULL as categorycode, NULL as itemtype, 'holds_pickup_period' as rule_name, '' as rule_value) u
6
        WHERE NOT EXISTS ( SELECT rule_name FROM circulation_rules where rule_name = 'holds_pickup_period' )
6
        WHERE NOT EXISTS ( SELECT rule_name FROM circulation_rules where rule_name = 'holds_pickup_period' );
7
    });
7
    });
8
8
9
    NewVersion( $DBversion, 8367, "Add holds_pickup_period circulation rule" );
9
    NewVersion( $DBversion, 8367, "Add holds_pickup_period circulation rule" );
10
- 

Return to bug 8367