-- ------------------------------------------------
-- Role/tcode range table
-- Created 20131121
-- ------------------------------------------------

CREATE TABLE IF NOT EXISTS `um_role_tcode_range` (
  `role_id` int(11) NOT NULL,
  `low` varchar(40) NOT NULL,
  `high` varchar(40),
  `system` varchar(8) DEFAULT NULL,
  `client` char(3) DEFAULT NULL,
  `um_delete` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`role_id`,`low`,`high`),
  KEY `sys_cli_del` (`system`,`client`,`um_delete`)
);
