USE `utilities`;
CREATE TABLE `message_shown` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `domain` varchar(50) NOT NULL,
  `userhash` varchar(50) NOT NULL,
  `mess_id` int(11) unsigned NOT NULL,
  `date_shown` date NOT NULL,
  PRIMARY KEY (`id`),
  KEY `domain` (`domain`),
  KEY `userhash` (`userhash`),
  KEY `date_shown` (`date_shown`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8;
