From 9fee5ac6fde75ad9ed0252e0b870d6800756f66e Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Thu, 2 Aug 2018 02:19:42 +0200 Subject: [PATCH] Bug 21144: Add ROADTYPE to default authorised values categories The ROADTYPE category was missing from the default list of authorised value categories available. To test: - Verify ROADTYPE is not listed as authorised value category - Apply patch and run database update - Verify ROADTYPE is now listed - Add an entry, for example: AV = Avenue - Add or edit a patron, verify a pull down with your entry shows on the form. Signed-off-by: Owen Leonard Signed-off-by: Jonathan Druart Signed-off-by: Nick Clemens (cherry picked from commit 266d7b5fa844b512cf68f4b08d6c07474c2ccc42) Signed-off-by: Martin Renvoize (cherry picked from commit 6c099d4360060829a230eeb243333182346d3d59) Signed-off-by: Fridolin Somers --- installer/data/mysql/atomicupdate/bug21144_roadtype.sql | 3 +++ installer/data/mysql/mandatory/auth_val_cat.sql | 4 +++- 2 files changed, 6 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug21144_roadtype.sql diff --git a/installer/data/mysql/atomicupdate/bug21144_roadtype.sql b/installer/data/mysql/atomicupdate/bug21144_roadtype.sql new file mode 100644 index 0000000000..c162be977c --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug21144_roadtype.sql @@ -0,0 +1,3 @@ +INSERT IGNORE INTO authorised_value_categories (category_name) VALUES ('ROADTYPE'); + +--Bug 21144: Add ROADTYPE to default authorised values categories diff --git a/installer/data/mysql/mandatory/auth_val_cat.sql b/installer/data/mysql/mandatory/auth_val_cat.sql index 09ce8c05f4..98b15c08b6 100644 --- a/installer/data/mysql/mandatory/auth_val_cat.sql +++ b/installer/data/mysql/mandatory/auth_val_cat.sql @@ -14,7 +14,9 @@ INSERT IGNORE INTO authorised_value_categories( category_name ) ('REPORT_SUBGROUP'), ('DEPARTMENT'), ('TERM'), - ('ITEMTYPECAT'); + ('ITEMTYPECAT'), + ('ROADTYPE'); + INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES ('branches'), -- 2.39.5