-- ------------------------------------------------
-- UM Dashboard: User's profiles
-- Created 20120831
-- ------------------------------------------------

CREATE TABLE IF NOT EXISTS `um_profile` (
  `system` varchar(8) NOT NULL,
  `client` char(3) NOT NULL,
  `type` char(1) DEFAULT NULL,
  `profile` varchar(12) NOT NULL DEFAULT '',
  `description` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`system`,`client`,`profile`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `um_user_profile` (
  `system` varchar(8) NOT NULL,
  `client` char(3) NOT NULL,
  `user` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `profile` varchar(12) NOT NULL DEFAULT '',
  PRIMARY KEY (`system`,`client`,`user`,`profile`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
