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

(-)a/installer/data/mysql/atomicupdate/bug_21730.perl (+9 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    # you can use $dbh here like:
4
5
    $dbh->do( "INSERT IGNORE INTO authorised_value_categories (category_name) VALUES ('AV_CLASS');");
6
7
    SetVersion( $DBversion );
8
    print "Upgrade to $DBversion done (Bug 21730: Add new authorised value category AV_CLASS)\n";
9
}
(-)a/installer/data/mysql/mandatory/auth_val_cat.sql (-1 / +1 lines)
Lines 16-21 INSERT IGNORE INTO authorised_value_categories( category_name ) Link Here
16
    ('TERM'),
16
    ('TERM'),
17
    ('ITEMTYPECAT'),
17
    ('ITEMTYPECAT'),
18
    ('PAYMENT_TYPE'),
18
    ('PAYMENT_TYPE'),
19
    ('AV_CLASS'),
19
    ('ROADTYPE');
20
    ('ROADTYPE');
20
21
21
INSERT IGNORE INTO authorised_value_categories( category_name )
22
INSERT IGNORE INTO authorised_value_categories( category_name )
22
- 

Return to bug 21730