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

(-)a/installer/data/mysql/atomicupdate/bug_17355.perl (+12 lines)
Lines 8-13 if( CheckVersion( $DBversion ) ) { Link Here
8
        |);
8
        |);
9
    }
9
    }
10
10
11
    $dbh->do(q|
12
        UPDATE authorised_value_categories
13
        SET is_system = 1
14
        WHERE category_name IN ('LOC', 'LOST', 'WITHDRAWN', 'Bsort1', 'Bsort2', 'Asort1', 'Asort2', 'SUGGEST', 'DAMAGED', 'LOST', 'BOR_NOTES', 'CCODE', 'NOT_LOAN')
15
    |);
16
17
    $dbh->do(q|
18
        UPDATE authorised_value_categories
19
        SET is_system = 1
20
        WHERE category_name IN ('branches', 'itemtypes', 'cn_source')
21
    |);
22
11
    # Always end with this (adjust the bug info)
23
    # Always end with this (adjust the bug info)
12
    NewVersion( $DBversion, 17355, "Description");
24
    NewVersion( $DBversion, 17355, "Description");
13
}
25
}
(-)a/installer/data/mysql/mandatory/auth_val_cat.sql (-44 / +43 lines)
Lines 1-51 Link Here
1
INSERT IGNORE INTO authorised_value_categories( category_name )
1
INSERT IGNORE INTO authorised_value_categories( category_name, is_system )
2
    VALUES
2
    VALUES
3
    (''),
3
    ('', 1),
4
    ('Asort1'),
4
    ('Asort1', 1),
5
    ('Asort2'),
5
    ('Asort2', 1),
6
    ('Bsort1'),
6
    ('Bsort1', 1),
7
    ('Bsort2'),
7
    ('Bsort2', 1),
8
    ('SUGGEST'),
8
    ('SUGGEST', 0),
9
    ('SUGGEST_STATUS'),
9
    ('SUGGEST_STATUS', 0),
10
    ('SUGGEST_FORMAT'),
10
    ('SUGGEST_FORMAT', 0),
11
    ('DAMAGED'),
11
    ('DAMAGED', 1),
12
    ('LOST'),
12
    ('LOST', 1),
13
    ('REPORT_GROUP'),
13
    ('REPORT_GROUP', 0),
14
    ('REPORT_SUBGROUP'),
14
    ('REPORT_SUBGROUP', 0),
15
    ('DEPARTMENT'),
15
    ('DEPARTMENT', 0),
16
    ('TERM'),
16
    ('TERM', 0),
17
    ('ITEMTYPECAT'),
17
    ('ITEMTYPECAT', 0),
18
    ('PAYMENT_TYPE'),
18
    ('PAYMENT_TYPE', 0),
19
    ('PA_CLASS'),
19
    ('PA_CLASS', 0),
20
    ('ROADTYPE');
20
    ('ROADTYPE', 0);
21
21
22
INSERT IGNORE INTO authorised_value_categories( category_name )
22
INSERT IGNORE INTO authorised_value_categories( category_name, is_system )
23
    VALUES
23
    VALUES
24
    ('branches'),
24
    ('branches', 1),
25
    ('itemtypes'),
25
    ('itemtypes', 1),
26
    ('cn_source');
26
    ('cn_source', 1);
27
27
28
INSERT IGNORE INTO authorised_value_categories( category_name )
28
INSERT IGNORE INTO authorised_value_categories( category_name, is_system )
29
    VALUES
29
    VALUES
30
    ('WITHDRAWN'),
30
    ('WITHDRAWN', 1),
31
    ('RESTRICTED'),
31
    ('RESTRICTED', 0),
32
    ('NOT_LOAN'),
32
    ('NOT_LOAN', 1),
33
    ('CCODE'),
33
    ('CCODE', 1),
34
    ('LOC'),
34
    ('LOC', 1),
35
    ('BOR_NOTES'),
35
    ('BOR_NOTES', 1),
36
    ('OPAC_SUG'),
36
    ('OPAC_SUG', 0),
37
    ('SIP_MEDIA_TYPE'),
37
    ('SIP_MEDIA_TYPE', 0),
38
    ('ORDER_CANCELLATION_REASON'),
38
    ('ORDER_CANCELLATION_REASON', 0),
39
    ('RELTERMS'),
39
    ('RELTERMS', 0),
40
    ('YES_NO'),
40
    ('YES_NO', 0),
41
    ('LANG'),
41
    ('LANG', 0),
42
    ('HINGS_UT'),
42
    ('HINGS_UT', 0),
43
    ('HINGS_PF'),
43
    ('HINGS_PF', 0),
44
    ('HINGS_C'),
44
    ('HINGS_C', 0),
45
    ('HINGS_AS'),
45
    ('HINGS_AS', 0),
46
    ('HINGS_RD'),
46
    ('HINGS_RD', 0),
47
    ('STACK'),
47
    ('STACK', 0),
48
    ('CONTROL_NUM_SEQUENCE');
48
    ('CONTROL_NUM_SEQUENCE' ,0);
49
49
50
-- UNIMARC specific?
50
-- UNIMARC specific?
51
INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES
51
INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES
52
- 

Return to bug 17355