SQL_Fix

DROP PROCEDURE IF EXISTS `schema_change`;

DELIMITER $$

CREATE PROCEDURE `schema_change`() 

BEGIN
    -- BEGIN changes for sip-proxy
    -- Add columns to store database connection parameters in sipProxyGroup

    IF NOT EXISTS (
                   SELECT * 
                     FROM `INFORMATION_SCHEMA`.`columns` 
                    WHERE `table_schema` = SCHEMA() 
                      AND `table_name` = 'sipProxyGroup' 
                      AND `column_name` = 'databaseHostname'
                  )  THEN
                    ALTER TABLE `voiceaxis`.`sipProxyGroup`
                      ADD COLUMN `databaseHostname` VARCHAR(255) NOT NULL AFTER `sipPort`,
                      ADD COLUMN `databasePort` INT(11) UNSIGNED NOT NULL DEFAULT 3306 AFTER `databaseHostname`,
                      ADD COLUMN `databaseUsername` VARCHAR(255) NOT NULL AFTER `databasePort`,
                      ADD COLUMN `databasePassword` VARCHAR(255) NOT NULL AFTER `databaseUsername`,
                      ADD COLUMN `databaseName` VARCHAR(255) NOT NULL AFTER `databasePassword`;
    END IF;

END $$

DELIMITER ;