-- ------------------------------------------
-- Addtions to um_start and um_service tables
-- ------------------------------------------
ALTER TABLE `um_start` 
ADD COLUMN `obj_type` VARCHAR(45) NULL DEFAULT NULL AFTER `description`,
ADD COLUMN `obj_id` VARCHAR(45) NULL DEFAULT NULL AFTER `obj_type`;

ALTER TABLE `um_service` 
ADD COLUMN `obj_type` VARCHAR(45) NULL DEFAULT NULL AFTER `description`;

CREATE TABLE IF NOT EXISTS `temp_start` (
  `guiid` char(32) NOT NULL DEFAULT '',
  `start` varchar(20) NOT NULL DEFAULT '',
  `description` varchar(36) NOT NULL DEFAULT '',
  PRIMARY KEY (`guiid`,`start`)
);

CREATE TABLE IF NOT EXISTS `temp_service` (
  `guiid` char(32) NOT NULL DEFAULT '',
  `service` varchar(20) NOT NULL DEFAULT '',
  `description` varchar(36) NOT NULL DEFAULT '',
  PRIMARY KEY (`guiid`,`service`)
);
