@@ -, +, @@ HSBND_FREQ in authorised value categories. --- installer/data/mysql/atomicupdate/housebound_tables.sql | 7 +++++++ installer/data/mysql/mandatory/auth_val_cat.sql | 5 +++++ 2 files changed, 12 insertions(+) --- a/installer/data/mysql/atomicupdate/housebound_tables.sql +++ a/installer/data/mysql/atomicupdate/housebound_tables.sql @@ -52,5 +52,12 @@ INSERT IGNORE INTO systempreferences ('HouseboundModule',0,'', 'If ON, enable housebound module functionality.','YesNo'); +-- Install in new authorised value category table + +INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES + ('HSBND_FREQ'); + +-- Then add mandatory authorised values + INSERT IGNORE INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week'); --- a/installer/data/mysql/mandatory/auth_val_cat.sql +++ a/installer/data/mysql/mandatory/auth_val_cat.sql @@ -49,3 +49,8 @@ INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES ('CAND'), ('COUNTRY'), ('qualif'); + +-- For Housebound + +INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES + ('HSBND_FREQ'); --