@@ -, +, @@ categories - 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. --- 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 --- a/installer/data/mysql/atomicupdate/bug21144_roadtype.sql +++ a/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 --- a/installer/data/mysql/mandatory/auth_val_cat.sql +++ a/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 --