From c0ebc472aad96ffacf9177b2293e9dcf9918de3d 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 --- installer/data/mysql/atomicupdate/bug21144_roadtype.sql | 3 +++ installer/data/mysql/mandatory/auth_val_cat.sql | 3 ++- 2 files changed, 5 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 0000000..c162be9 --- /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 e42fa8c..6fff954 100644 --- a/installer/data/mysql/mandatory/auth_val_cat.sql +++ b/installer/data/mysql/mandatory/auth_val_cat.sql @@ -15,7 +15,8 @@ INSERT IGNORE INTO authorised_value_categories( category_name ) ('DEPARTMENT'), ('TERM'), ('ITEMTYPECAT'), - ('PAYMENT_TYPE'); + ('PAYMENT_TYPE'), + ('ROADTYPE'); INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES -- 2.1.4