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 ;
|