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

(-)a/installer/data/mysql/atomicupdate/bug_17216_1_add_table.sql (+9 lines)
Lines 31-36 INSERT IGNORE INTO authorised_value_categories( category_name ) Link Here
31
    ('itemtypes'),
31
    ('itemtypes'),
32
    ('cn_source');
32
    ('cn_source');
33
33
34
INSERT IGNORE INTO authorised_value_categories( category_name )
35
    VALUES
36
    ('WITHDRAWN'),
37
    ('RESTRICTED'),
38
    ('NOT_LOAN'),
39
    ('CCODE'),
40
    ('LOC'),
41
    ('STACK');
42
34
-- Update the FK
43
-- Update the FK
35
ALTER TABLE items_search_fields
44
ALTER TABLE items_search_fields
36
    DROP FOREIGN KEY items_search_fields_authorised_values_category;
45
    DROP FOREIGN KEY items_search_fields_authorised_values_category;
(-)a/installer/data/mysql/en/mandatory/auth_values.sql (-1 / +8 lines)
Lines 21-23 INSERT IGNORE INTO authorised_value_categories( category_name ) Link Here
21
    ('itemtypes'),
21
    ('itemtypes'),
22
    ('cn_source');
22
    ('cn_source');
23
23
24
- 
24
INSERT IGNORE INTO authorised_value_categories( category_name )
25
    VALUES
26
    ('WITHDRAWN'),
27
    ('RESTRICTED'),
28
    ('NOT_LOAN'),
29
    ('CCODE'),
30
    ('LOC'),
31
    ('STACK');

Return to bug 17216