@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_17216_1_add_table.sql | 9 +++++++++ installer/data/mysql/en/mandatory/auth_values.sql | 8 ++++++++ 2 files changed, 17 insertions(+) --- a/installer/data/mysql/atomicupdate/bug_17216_1_add_table.sql +++ a/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; --- a/installer/data/mysql/en/mandatory/auth_values.sql +++ a/installer/data/mysql/en/mandatory/auth_values.sql @@ -21,3 +21,11 @@ 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'); --