From 8aa736cb77e01ea808046571069c4b8847ceb381 Mon Sep 17 00:00:00 2001
From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Date: Wed, 16 Sep 2020 14:57:36 +0100
Subject: [PATCH] Bug 22818: (QA follow-up) Add mandatory data at install time

This patch adds the data from the update script into the mandatory sql
files such that it is also populated at install time.

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
---
 .../data/mysql/mandatory/sample_notices_message_attributes.sql    | 4 +++-
 .../data/mysql/mandatory/sample_notices_message_transports.sql    | 8 +++++++-
 2 files changed, 10 insertions(+), 2 deletions(-)

diff --git a/installer/data/mysql/mandatory/sample_notices_message_attributes.sql b/installer/data/mysql/mandatory/sample_notices_message_attributes.sql
index a7a6032cc7..2b6f9a4e26 100644
--- a/installer/data/mysql/mandatory/sample_notices_message_attributes.sql
+++ b/installer/data/mysql/mandatory/sample_notices_message_attributes.sql
@@ -5,5 +5,7 @@ values
 (2, 'Advance_Notice', 1),
 (4, 'Hold_Filled', 0),
 (5, 'Item_Check_in', 0),
-(6, 'Item_Checkout', 0);
+(6, 'Item_Checkout', 0),
+(7, 'Ill_ready', 0),
+(8, 'Ill_unavailable', 0);
 
diff --git a/installer/data/mysql/mandatory/sample_notices_message_transports.sql b/installer/data/mysql/mandatory/sample_notices_message_transports.sql
index 5954bafc7b..a70c9f3465 100644
--- a/installer/data/mysql/mandatory/sample_notices_message_transports.sql
+++ b/installer/data/mysql/mandatory/sample_notices_message_transports.sql
@@ -17,4 +17,10 @@ values
 (5, 'email', 0, 'circulation', 'CHECKIN'),
 (5, 'sms',   0, 'circulation', 'CHECKIN'),
 (6, 'email', 0, 'circulation', 'CHECKOUT'),
-(6, 'sms',   0, 'circulation', 'CHECKOUT');
+(6, 'sms',   0, 'circulation', 'CHECKOUT'),
+(7, 'email', 0, 'ill', 'ILL_PICKUP_READY'),
+(7, 'sms',   0, 'ill', 'ILL_PICKUP_READY'),
+(7, 'phone', 0, 'ill', 'ILL_PICKUP_READY'),
+(8, 'email', 0, 'ill', 'ILL_REQUEST_UNAVAIL'),
+(8, 'sms',   0, 'ill', 'ILL_REQUEST_UNAVAIL'),
+(8, 'phone', 0, 'ill', 'ILL_REQUEST_UNAVAIL');
-- 
2.11.0