OpenSim-Test/OpenSim/Data/MySQL/Resources/UpgradeRegionsTableToVersion3.sql

DROP PROCEDURE IF EXISTS upgraderegions3;

create procedure upgraderegions3()
BEGIN
DECLARE db_name varchar(64);
select database() into db_name;
IF ((select count(*) from information_schema.columns where table_name='regions' and column_name='owner_uuid' and table_schema=db_name) > 0)
THEN
    ALTER TABLE `regions`, COMMENT='Rev. 3';
ELSE
    ALTER TABLE `regions`
        ADD COLUMN `owner_uuid` varchar(36) default '00000000-0000-0000-0000-000000000000' not null after serverRemotingPort, COMMENT='Rev. 3';
END IF;
END; 

call upgraderegions3();