From 2eb34034dfbba16a49e071855bc95253779fd80a Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Wed, 7 Aug 2013 14:24:23 +0200 Subject: [PATCH] Bug 10572: (follow-up) DBrev to ensure presence of phone transport type Test plan: Run the updatestructure step of web installer. Check if you have a phone message_transport_type. Signed-off-by: Marcel de Rooy Signed-off-by: Kyle M Hall Signed-off-by: Galen Charlton --- installer/data/mysql/updatedatabase.pl | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 3386ea06ea..6b124177a9 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -7636,6 +7636,17 @@ if ( CheckVersion($DBversion) ) { SetVersion($DBversion); } +$DBversion = "3.13.00.XXX"; +if ( CheckVersion($DBversion) ) { + #add phone if it is not there already (explains the ignore option) + $dbh->do(" +INSERT IGNORE INTO message_transport_types (message_transport_type) values ('phone'); + "); + print "Upgrade to $DBversion done (Bug 10572: Add phone to message_transport_types table for new installs)\n"; + SetVersion($DBversion); +} + + =head1 FUNCTIONS =head2 TableExists($table) -- 2.39.5