View | Details | Raw Unified | Return to bug 4858
Collapse All | Expand All

(-)a/installer/data/mysql/mandatory/sample_notices_message_transports.sql (-1 / +16 lines)
Lines 7-12 values Link Here
7
(1, 'sms',   1, 'circulation', 'DUEDGST'),
7
(1, 'sms',   1, 'circulation', 'DUEDGST'),
8
(1, 'phone', 0, 'circulation', 'DUE'),
8
(1, 'phone', 0, 'circulation', 'DUE'),
9
(1, 'phone', 1, 'circulation', 'DUEDGST'),
9
(1, 'phone', 1, 'circulation', 'DUEDGST'),
10
(1, 'print', 0, 'circulation', 'DUE'),
11
(1, 'print', 1, 'circulation', 'DUEDGST'),
10
(2, 'email', 0, 'circulation', 'PREDUE'),
12
(2, 'email', 0, 'circulation', 'PREDUE'),
11
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
13
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
12
(2, 'sms',   0, 'circulation', 'PREDUE'),
14
(2, 'sms',   0, 'circulation', 'PREDUE'),
Lines 15-20 values Link Here
15
(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
17
(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
16
(2, 'itiva', 0, 'circulation', 'PREDUE'),
18
(2, 'itiva', 0, 'circulation', 'PREDUE'),
17
(2, 'itiva', 1, 'circulation', 'PREDUEDGST'),
19
(2, 'itiva', 1, 'circulation', 'PREDUEDGST'),
20
(2, 'print', 0, 'circulation', 'PREDUE'),
21
(2, 'print', 1, 'circulation', 'PREDUEDGST'),
18
(4, 'email', 0, 'reserves',    'HOLD'),
22
(4, 'email', 0, 'reserves',    'HOLD'),
19
(4, 'sms',   0, 'reserves',    'HOLD'),
23
(4, 'sms',   0, 'reserves',    'HOLD'),
20
(4, 'phone', 0, 'reserves',    'HOLD'),
24
(4, 'phone', 0, 'reserves',    'HOLD'),
Lines 22-58 values Link Here
22
(4, 'email', 1, 'reserves',    'HOLDDGST'),
26
(4, 'email', 1, 'reserves',    'HOLDDGST'),
23
(4, 'sms',   1, 'reserves',    'HOLDDGST'),
27
(4, 'sms',   1, 'reserves',    'HOLDDGST'),
24
(4, 'phone', 1, 'reserves',    'HOLDDGST'),
28
(4, 'phone', 1, 'reserves',    'HOLDDGST'),
29
(4, 'print', 0, 'reserves', 'HOLD'),
30
(4, 'print', 1, 'reserves', 'HOLDDGST'),
25
(5, 'email', 0, 'circulation', 'CHECKIN'),
31
(5, 'email', 0, 'circulation', 'CHECKIN'),
26
(5, 'sms',   0, 'circulation', 'CHECKIN'),
32
(5, 'sms',   0, 'circulation', 'CHECKIN'),
27
(5, 'phone', 0, 'circulation', 'CHECKIN'),
33
(5, 'phone', 0, 'circulation', 'CHECKIN'),
34
(5, 'print', 0, 'circulation', 'CHECKIN'),
28
(6, 'email', 0, 'circulation', 'CHECKOUT'),
35
(6, 'email', 0, 'circulation', 'CHECKOUT'),
29
(6, 'sms',   0, 'circulation', 'CHECKOUT'),
36
(6, 'sms',   0, 'circulation', 'CHECKOUT'),
30
(6, 'phone', 0, 'circulation', 'CHECKOUT'),
37
(6, 'phone', 0, 'circulation', 'CHECKOUT'),
38
(6, 'print', 0, 'circulation', 'CHECKOUT'),
31
(7, 'email', 0, 'ill', 'ILL_PICKUP_READY'),
39
(7, 'email', 0, 'ill', 'ILL_PICKUP_READY'),
32
(7, 'sms',   0, 'ill', 'ILL_PICKUP_READY'),
40
(7, 'sms',   0, 'ill', 'ILL_PICKUP_READY'),
33
(7, 'phone', 0, 'ill', 'ILL_PICKUP_READY'),
41
(7, 'phone', 0, 'ill', 'ILL_PICKUP_READY'),
42
(7, 'print', 0, 'ill', 'ILL_PICKUP_READY'),
34
(8, 'email', 0, 'ill', 'ILL_REQUEST_UNAVAIL'),
43
(8, 'email', 0, 'ill', 'ILL_REQUEST_UNAVAIL'),
35
(8, 'sms',   0, 'ill', 'ILL_REQUEST_UNAVAIL'),
44
(8, 'sms',   0, 'ill', 'ILL_REQUEST_UNAVAIL'),
36
(8, 'phone', 0, 'ill', 'ILL_REQUEST_UNAVAIL'),
45
(8, 'phone', 0, 'ill', 'ILL_REQUEST_UNAVAIL'),
46
(8, 'print', 0, 'ill', 'ILL_REQUEST_UNAVAIL'),
37
(9, 'email', 0, 'circulation', 'AUTO_RENEWALS'),
47
(9, 'email', 0, 'circulation', 'AUTO_RENEWALS'),
38
(9, 'sms',   0, 'circulation', 'AUTO_RENEWALS'),
48
(9, 'sms',   0, 'circulation', 'AUTO_RENEWALS'),
39
(9, 'phone', 0, 'circulation', 'AUTO_RENEWALS'),
49
(9, 'phone', 0, 'circulation', 'AUTO_RENEWALS'),
40
(9, 'email', 1, 'circulation', 'AUTO_RENEWALS_DGST'),
50
(9, 'email', 1, 'circulation', 'AUTO_RENEWALS_DGST'),
41
(9, 'sms',   1, 'circulation', 'AUTO_RENEWALS_DGST'),
51
(9, 'sms',   1, 'circulation', 'AUTO_RENEWALS_DGST'),
42
(9, 'phone', 1, 'circulation', 'AUTO_RENEWALS_DGST'),
52
(9, 'phone', 1, 'circulation', 'AUTO_RENEWALS_DGST'),
53
(9, 'print', 0, 'circulation', 'AUTO_RENEWALS'),
54
(9, 'print', 1, 'circulation', 'AUTO_RENEWALS_DGST'),
43
(10, 'email', 0, 'circulation', 'HOLD_REMINDER'),
55
(10, 'email', 0, 'circulation', 'HOLD_REMINDER'),
44
(10, 'sms',   0, 'circulation', 'HOLD_REMINDER'),
56
(10, 'sms',   0, 'circulation', 'HOLD_REMINDER'),
45
(10, 'phone', 0, 'circulation', 'HOLD_REMINDER'),
57
(10, 'phone', 0, 'circulation', 'HOLD_REMINDER'),
46
(10, 'itiva', 0, 'circulation', 'HOLD_REMINDER'),
58
(10, 'itiva', 0, 'circulation', 'HOLD_REMINDER'),
59
(10, 'print', 0, 'circulation', 'HOLD_REMINDER'),
47
(11, 'email', 0, 'ill', 'ILL_REQUEST_UPDATE'),
60
(11, 'email', 0, 'ill', 'ILL_REQUEST_UPDATE'),
48
(11, 'sms',   0, 'ill', 'ILL_REQUEST_UPDATE'),
61
(11, 'sms',   0, 'ill', 'ILL_REQUEST_UPDATE'),
49
(11, 'phone', 0, 'ill', 'ILL_REQUEST_UPDATE'),
62
(11, 'phone', 0, 'ill', 'ILL_REQUEST_UPDATE'),
63
(11, 'print', 0, 'ill', 'ILL_REQUEST_UPDATE'),
50
(12, "email", 0, "circulation", "PICKUP_RECALLED_ITEM"),
64
(12, "email", 0, "circulation", "PICKUP_RECALLED_ITEM"),
51
(12, "sms",   0, "circulation", "PICKUP_RECALLED_ITEM"),
65
(12, "sms",   0, "circulation", "PICKUP_RECALLED_ITEM"),
52
(12, "phone",   0, "circulation", "PICKUP_RECALLED_ITEM"),
66
(12, "phone",   0, "circulation", "PICKUP_RECALLED_ITEM"),
67
(12, 'print', 0, 'circulation', 'PICKUP_RECALLED_ITEM'),
53
(13, "email", 0, "circulation", "RETURN_RECALLED_ITEM"),
68
(13, "email", 0, "circulation", "RETURN_RECALLED_ITEM"),
54
(13, "sms",   0, "circulation", "RETURN_RECALLED_ITEM"),
69
(13, "sms",   0, "circulation", "RETURN_RECALLED_ITEM"),
55
(13, "phone",   0, "circulation", "RETURN_RECALLED_ITEM"),
70
(13, "phone",   0, "circulation", "RETURN_RECALLED_ITEM"),
71
(13, 'print', 0, 'circulation', 'RETURN_RECALLED_ITEM');
56
(14, "email", 0, "members", "MEMBERSHIP_EXPIRY"),
72
(14, "email", 0, "members", "MEMBERSHIP_EXPIRY"),
57
(14, "sms",   0, "members", "MEMBERSHIP_EXPIRY"),
73
(14, "sms",   0, "members", "MEMBERSHIP_EXPIRY"),
58
(14, "phone",   0, "members", "MEMBERSHIP_EXPIRY");
74
(14, "phone",   0, "members", "MEMBERSHIP_EXPIRY");
59
- 

Return to bug 4858