-- -------------------------------------------------------
-- Creating um_service and um_start tables
-- -------------------------------------------------------
CREATE TABLE IF NOT EXISTS `um_service` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `system` varchar(8) NOT NULL,
  `client` char(3) NOT NULL,
  `service` varchar(20) NOT NULL DEFAULT '',
  `description` varchar(36) NOT NULL DEFAULT '',
  `nonexistent` char(1) NOT NULL DEFAULT '',
  `um_delete` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sys_cli_tcode` (`system`,`client`,`service`),
  KEY `um_del` (`um_delete`)
);

CREATE TABLE IF NOT EXISTS `um_start` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `system` varchar(8) NOT NULL,
  `client` char(3) NOT NULL,
  `start` varchar(20) NOT NULL DEFAULT '',
  `description` varchar(36) NOT NULL DEFAULT '',
  `nonexistent` char(1) NOT NULL DEFAULT '',
  `um_delete` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sys_cli_tcode` (`system`,`client`,`start`),
  KEY `um_del` (`um_delete`)
);