DROP TABLE IF EXISTS `#@_report_table`;
CREATE TABLE `#@_report_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bugno` char(9) NOT NULL DEFAULT '',
  `comy` smallint(6) NOT NULL DEFAULT '9999',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `creator` int(11) NOT NULL DEFAULT '0',
  `pid` int(11) NOT NULL DEFAULT '0',
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `priority` tinyint(1) NOT NULL DEFAULT '0',
  `level` char(30) NOT NULL DEFAULT '',
  `hertz` char(20) NOT NULL DEFAULT '',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `os` char(50) NOT NULL DEFAULT '',
  `title` varchar(80) NOT NULL DEFAULT '',
  `addtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `uptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`),
  KEY `type` (`type`,`priority`,`status`),
  KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
23:48:53','2014-10-20 23:48:59');
