USE `utilities`;
CREATE TABLE IF NOT EXISTS `log_messages` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `type` int(11) NOT NULL DEFAULT '0',
  `type_desc` varchar(50) DEFAULT NULL,
  `environment` varchar(50) DEFAULT NULL,
  `class_name` varchar(100) NOT NULL DEFAULT '',
  `reference` varchar(200) NOT NULL DEFAULT '',
  `message` text,
  `enc_data` text,
  `enc_post_values` text,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `LogType` (`type`),
  KEY `ClassName` (`class_name`),
  KEY `Reference` (`reference`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;
