| CREATE TABLE IF NOT EXISTS `dotgo_path` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `parent` int(8) NOT NULL DEFAULT '0',
  `keyword` varchar(128) NOT NULL DEFAULT '',
  `responseType` char(3) NOT NULL DEFAULT 'msg',
  `content` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `parent` (`parent`,`id`),
  KEY `keyword` (`keyword`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;
 |