From 44524f6a9618baeabf8d1c2785230d1c87ec5484 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. Signed-off-by: Claire Gravely Signed-off-by: Kyle M Hall --- 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 49c3237ff6..e9e4151d3d 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 5584a3d280..09ce8c05f4 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.39.2