From 6a9c3217cb20f26b6276a15d4da437a7d546ed3b Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Wed, 7 Aug 2013 14:24:23 +0200 Subject: [PATCH] Bug 10572: Followup: dbrev for phone message_transport_type Content-Type: text/plain; charset=utf-8 Test plan: Run the updatestructure step of web installer. Check if you have a phone message_transport_type. Signed-off-by: Marcel de Rooy --- installer/data/mysql/updatedatabase.pl | 11 +++++++++++ 1 files changed, 11 insertions(+), 0 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 74aeb3e..d36956f 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -7067,6 +7067,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) -- 1.7.7.6