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

(-)a/installer/data/mysql/atomicupdate/housebound_tables.sql (+7 lines)
Lines 52-56 INSERT IGNORE INTO systempreferences Link Here
52
       ('HouseboundModule',0,'',
52
       ('HouseboundModule',0,'',
53
       'If ON, enable housebound module functionality.','YesNo');
53
       'If ON, enable housebound module functionality.','YesNo');
54
54
55
-- Install in new authorised value category table
56
57
INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES
58
    ('HSBND_FREQ');
59
60
-- Then add mandatory authorised values
61
55
INSERT IGNORE INTO authorised_values (category, authorised_value, lib) VALUES
62
INSERT IGNORE INTO authorised_values (category, authorised_value, lib) VALUES
56
       ('HSBND_FREQ','EW','Every week');
63
       ('HSBND_FREQ','EW','Every week');
(-)a/installer/data/mysql/mandatory/auth_val_cat.sql (-1 / +5 lines)
Lines 49-51 INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES Link Here
49
    ('CAND'),
49
    ('CAND'),
50
    ('COUNTRY'),
50
    ('COUNTRY'),
51
    ('qualif');
51
    ('qualif');
52
- 
52
53
-- For Housebound
54
55
INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES
56
    ('HSBND_FREQ');

Return to bug 5670