From ef19f6705a5fcee0f0027b3a9d09fa2d027907a6 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 29 Aug 2016 15:15:10 +0100 Subject: [PATCH] Bug 17216: Add some other AV categories Found in installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql Signed-off-by: Owen Leonard Signed-off-by: Katrin Fischer Signed-off-by: Brendan Gallagher --- .../data/mysql/atomicupdate/bug_17216_1_add_table.sql | 9 +++++++++ installer/data/mysql/en/mandatory/auth_values.sql | 9 +++++++++ 2 files changed, 18 insertions(+) diff --git a/installer/data/mysql/atomicupdate/bug_17216_1_add_table.sql b/installer/data/mysql/atomicupdate/bug_17216_1_add_table.sql index 221a7e760c..cc5ac6ee5b 100644 --- a/installer/data/mysql/atomicupdate/bug_17216_1_add_table.sql +++ b/installer/data/mysql/atomicupdate/bug_17216_1_add_table.sql @@ -31,6 +31,15 @@ INSERT IGNORE INTO authorised_value_categories( category_name ) ('itemtypes'), ('cn_source'); +INSERT IGNORE INTO authorised_value_categories( category_name ) + VALUES + ('WITHDRAWN'), + ('RESTRICTED'), + ('NOT_LOAN'), + ('CCODE'), + ('LOC'), + ('STACK'); + -- Update the FK ALTER TABLE items_search_fields DROP FOREIGN KEY items_search_fields_authorised_values_category; diff --git a/installer/data/mysql/en/mandatory/auth_values.sql b/installer/data/mysql/en/mandatory/auth_values.sql index e0785f0bce..74b917d47c 100644 --- a/installer/data/mysql/en/mandatory/auth_values.sql +++ b/installer/data/mysql/en/mandatory/auth_values.sql @@ -20,3 +20,12 @@ INSERT IGNORE INTO authorised_value_categories( category_name ) ('branches'), ('itemtypes'), ('cn_source'); + +INSERT IGNORE INTO authorised_value_categories( category_name ) + VALUES + ('WITHDRAWN'), + ('RESTRICTED'), + ('NOT_LOAN'), + ('CCODE'), + ('LOC'), + ('STACK'); -- 2.20.1