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

(-)a/installer/data/mysql/atomicupdate/bug_xxxxx_AV_cat_table.sql (-1 / +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;
37
- 

Return to bug 17216