Attachment 111891 Details for Bug 22818 – Bug 22818: (QA follow-up) Add mandatory data at install time

[patch] Bug 22818: (QA follow-up) Add mandatory data at install time

Bug-22818-QA-follow-up-Add-mandatory-data-at-insta.patch (text/plain), 1.94 KB, created by Andrew Isherwood on 2020-10-16 14:36:35 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Andrew Isherwood

Created: 2020-10-16 14:36:35 UTC

Size: 1.94 KB

patch

obsolete

>From 29c38c51a8cb868522f68e48bd732eacb19f7f3a 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.
>---
> .../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

Actions: View | Diff | Splinter Review

Attachments on bug 22818: 89831 | 89832 | 89833 | 89834 | 89835 | 90063 | 90064 | 90065 | 90066 | 90067 | 90715 | 90716 | 90717 | 90718 | 90719 | 92898 | 92899 | 92900 | 92901 | 92902 | 100234 | 100235 | 100236 | 100237 | 100238 | 103268 | 103269 | 103270 | 103271 | 103272 | 106424 | 106425 | 106426 | 106427 | 106428 | 106675 | 106676 | 106677 | 106678 | 106679 | 106680 | 106681 | 106691 | 106693 | 106694 | 106704 | 106705 | 106706 | 106707 | 106708 | 106709 | 106710 | 106711 | 106712 | 106713 | 110196 | 110197 | 110198 | 110199 | 110201 | 110202 | 110203 | 110204 | 110205 | 110206 | 110207 | 110208 | 111837 | 111838 | 111839 | 111840 | 111841 | 111842 | 111843 | 111844 | 111845 | 111846 | 111847 | 111848 | 111874 | 111880 | 111881 | 111883 | 111884 | 111885 | 111886 | 111887 | 111888 | 111889 | 111890 | 111891 | 111892 | 111893 | 111897 | 111899 | 111900 | 111901 | 111902 | 111903 | 111904 | 111905 | 111906 | 111907 | 111908 | 111909 | 111910 | 111911 | 111912 | 111913 | 113398 | 113399 | 113400 | 113401 | 113402 | 113403 | 113404 | 113405 | 113406 | 113407 | 113408 | 113409 | 113410 | 113411 | 113412 | 113413 | 113463 | 113464 | 113465 | 113466 | 113467 | 113468 | 113469 | 113470 | 113471 | 113472 | 113473 | 113474 | 113475 | 113476 | 113477 | 113478 | 113479 | 113522 | 113549 | 113584