From 9423e990478024a9bb4e27896cc8a3e7a36ef339 Mon Sep 17 00:00:00 2001 From: Alex Sassmannshausen Date: Thu, 13 Oct 2016 11:57:06 +0200 Subject: [PATCH] Bug 5670: Add auth_val_cat to auth_val_cat.sql. * installer/data/mysql/atomicupdate/housebound_tables.sql: Insert HSBND_FREQ in authorised value categories. * installer/data/mysql/mandatory/auth_val_cat.sql: Add HSBND_FREQ. --- installer/data/mysql/atomicupdate/housebound_tables.sql | 7 +++++++ installer/data/mysql/mandatory/auth_val_cat.sql | 5 +++++ 2 files changed, 12 insertions(+) diff --git a/installer/data/mysql/atomicupdate/housebound_tables.sql b/installer/data/mysql/atomicupdate/housebound_tables.sql index 49c3237..e9e4151 100644 --- a/installer/data/mysql/atomicupdate/housebound_tables.sql +++ b/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'); diff --git a/installer/data/mysql/mandatory/auth_val_cat.sql b/installer/data/mysql/mandatory/auth_val_cat.sql index 5584a3d..09ce8c0 100644 --- a/installer/data/mysql/mandatory/auth_val_cat.sql +++ b/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'); -- 2.10.1