由于没有做升级数据库动作导致这种情况,全新安装不会有这个问题,如果是升级安装可以在数据库下运行以下语句:
- CREATE TABLE IF NOT EXISTS pre_mobile_wechat_resource (
- `id` int(10) unsigned NOT NULL auto_increment,
- `name` varchar(255) NOT NULL default '',
- `dateline` int(10) unsigned NOT NULL,
- `type` tinyint(1) NOT NULL DEFAULT 0,
- `data` text NOT NULL,
- PRIMARY KEY (`id`),
- KEY `type` (`type`)
- ) ENGINE=MYISAM;
- CREATE TABLE IF NOT EXISTS pre_mobile_wechat_masssend (
- `id` int(10) unsigned NOT NULL auto_increment,
- `type` char(5) NOT NULL,
- `name` varchar(255) NOT NULL,
- `resource_id` int(10) unsigned NOT NULL,
- `group_id` int(10) unsigned NOT NULL,
- `text` text,
- `media_id` char(64) DEFAULT '',
- `created_at` int(10) unsigned NOT NULL,
- `sent_at` int(10) unsigned,
- `msg_id` int(10) unsigned,
- `res_status` varchar(50),
- `res_totalcount` int(10),
- `res_filtercount` int(10),
- `res_sentcount` int(10),
- `res_errorcount` int(10),
- `res_finish_at` int(10),
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM;
复制代码 |