@@ -, +, @@ --- .../mysql/atomicupdate/Bug_21639_add_phone_transports.perl | 13 +++++++++++++ .../en/mandatory/sample_notices_message_transports.sql | 9 ++++++--- 2 files changed, 19 insertions(+), 3 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/Bug_21639_add_phone_transports.perl --- a/installer/data/mysql/atomicupdate/Bug_21639_add_phone_transports.perl +++ a/installer/data/mysql/atomicupdate/Bug_21639_add_phone_transports.perl @@ -0,0 +1,13 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do(q( + INSERT IGNORE INTO message_transports + (message_attribute_id,message_transport_type,is_digest,letter_module,letter_code) + VALUES + (2, 'phone', 0, 'circulation', 'PREDUE'), + (2, 'phone', 1, 'circulation', 'PREDUEDGST'), + (4, 'phone', 0, 'reserves', 'HOLD') + )); + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 21639 - Add phone transports by default)\n"; +} --- a/installer/data/mysql/en/mandatory/sample_notices_message_transports.sql +++ a/installer/data/mysql/en/mandatory/sample_notices_message_transports.sql @@ -3,14 +3,17 @@ insert into `message_transports` values (1, 'email', 0, 'circulation', 'DUE'), (1, 'email', 1, 'circulation', 'DUEDGST'), -(2, 'email', 0, 'circulation', 'PREDUE'), -(2, 'email', 1, 'circulation', 'PREDUEDGST'), -(4, 'email', 0, 'reserves', 'HOLD'), (1, 'sms', 0, 'circulation', 'DUE'), (1, 'sms', 1, 'circulation', 'DUEDGST'), +(2, 'email', 0, 'circulation', 'PREDUE'), +(2, 'email', 1, 'circulation', 'PREDUEDGST'), (2, 'sms', 0, 'circulation', 'PREDUE'), (2, 'sms', 1, 'circulation', 'PREDUEDGST'), +(2, 'phone', 0, 'circulation', 'PREDUE'), +(2, 'phone', 1, 'circulation', 'PREDUEDGST'), +(4, 'email', 0, 'reserves', 'HOLD'), (4, 'sms', 0, 'reserves', 'HOLD'), +(4, 'phone', 0, 'reserves', 'HOLD'), (5, 'email', 0, 'circulation', 'CHECKIN'), (5, 'sms', 0, 'circulation', 'CHECKIN'), (6, 'email', 0, 'circulation', 'CHECKOUT'), --