Bug 21639: Add phone transports to new and existing installs
authorNick Clemens <nick@bywatersolutions.com>
Wed, 24 Oct 2018 01:33:42 +0000 (01:33 +0000)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Tue, 6 Nov 2018 13:26:30 +0000 (13:26 +0000)
commitcd1a13edf7d018262c3896d4429b55df19d8c614
tree951c4a734ea1a7d5f23a9141684513fb7bb1d8c9
parentcb7db6fcd45d956d28596d86de312ee5502333a6
Bug 21639: Add phone transports to new and existing installs

To test:
1 - Confirm if you do or do not have 'phone' transports defined in the
message_transports table
2 - Apply patch
3 - Run updatedatabase
4 - If you didn't have them you should now
5 - Run updatedatabase again, confirm it doesn't error
6 - sudo koha-mysql kohadev
7 - DELETE from message_transports WHERE message_transport_type =
'phone'
8 - Run updatedatabase again
9 - Confirm the message transports table is restored
10 - Drop your DB (or reset_all in kohadevbox)
11 - Ensure the table is fully populated including phone notices

Signed-off-by: Mark Tompsett <mtompset@hotmail.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
(cherry picked from commit 71fdba0ff014017287ca7b1f524850fadad81af1)
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
installer/data/mysql/atomicupdate/Bug_21639_add_phone_transports.perl [new file with mode: 0644]
installer/data/mysql/en/mandatory/sample_notices_message_transports.sql