From 740ce5b98b5cdafd528e80281c61ce70fd5b5dc9 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Mon, 29 Aug 2016 15:15:10 +0100
Subject: [PATCH] [PASSED QA] 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 <oleonard@myacpl.org>

Signed-off-by: Katrin Fischer  <katrin.fischer@bsz-bw.de>
---
 installer/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 221a7e7..cc5ac6e 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 e0785f0..74b917d 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.7.4