新的建表命令
CREATE TABLE IF NOT EXISTS wp_weixin_custom_replies (
`id` bigint(20) NOT NULL auto_increment,
`keyword` varchar(255) NOT NULL,
`match` varchar(10) NOT NULL default 'full',
`reply` text NOT NULL,
`status` int(1) NOT NULL default '1',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
`type` varchar(10) NOT NULL default 'text',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS wp_weixin_messages (
`id` bigint(20) NOT NULL auto_increment,
`MsgId` bigint(64) NOT NULL,
`FromUserName` varchar(30) NOT NULL,
`MsgType` varchar(10) NOT NULL,
`CreateTime` int(10) NOT NULL,
`Content` longtext NOT NULL,
`Event` varchar(255) NOT NULL,
`EventKey` varchar(255) NOT NULL,
`Title` text NOT NULL,
`Url` varchar(255) NOT NULL,
`MediaId` text NOT NULL,
`Response` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;