Bugzilla – Attachment 77457 Details for
Bug 21144
ROADTYPE missing from authorised value categories list
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 21144: Add ROADTYPE to default authorised values categories
Bug-21144-Add-ROADTYPE-to-default-authorised-value.patch (text/plain), 1.83 KB, created by
Owen Leonard
on 2018-08-02 18:15:51 UTC
(
hide
)
Description:
Bug 21144: Add ROADTYPE to default authorised values categories
Filename:
MIME Type:
Creator:
Owen Leonard
Created:
2018-08-02 18:15:51 UTC
Size:
1.83 KB
patch
obsolete
>From c0ebc472aad96ffacf9177b2293e9dcf9918de3d Mon Sep 17 00:00:00 2001 >From: Katrin Fischer <katrin.fischer.83@web.de> >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 <oleonard@myacpl.org> >--- > 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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 21144
:
77420
|
77421
|
77457
|
77841