From fc1de5cc0797f1c1da887073e93ed65c01dda37a Mon Sep 17 00:00:00 2001 From: Martin Renvoize 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. --- .../mysql/mandatory/sample_notices_message_attributes.sql | 4 +++- .../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.20.1