## wx_user (微信用户、公众号管理) |字段|类型|Null|默认|注释| | -- | -- | -- | -- | -- | |id auto_increment|int(11) |否| |表自增id| |uid|int(11)|||用户ID| |wxname|varchar(60)|||公众号名称| |aeskey|varchar(256)|||EncodingAESKey(消息加解密密钥)| |encode|tinyint(1)||0|encode加密，0未加密，1加密| |appid|varchar(50)|||appid| |appsecret|varchar(50)|||appsecret| |wxid|varchar(20)|||公众号原始ID| |weixin|char(20)|||微信号| |headerpic|char(255)|||头像地址| |token|char(255)|||token| |w_token|varchar(150)|||微信对接token| |create_time|varchar(13)|||create_time| |updatetime|varchar(13)|||updatetime| |tplcontentid|varchar(2)|||内容模版ID| |share_ticket|varchar(150)|||分享ticket| |share_dated|char(15)|||share_dated| |authorizer_access_token|varchar(200)|||authorizer_access_token| |authorizer_refresh_token|varchar(200)|||authorizer_refresh_token| |authorizer_expires|char(10)|||authorizer_expires| |type|tinyint(1)||0|类型| |web_access_token|varchar(200)|||网页授权token| |web_refresh_token|varchar(200)|||web_refresh_token| |web_expires|char(10)|||过期时间| |qr|varchar(200)|||qr| |menu_config|text|||菜单| |wait_access|tinyint(1)||0|微信接入状态,0待接入1已接入| 相关的SQL语句如下： ``` CREATE TABLE IF NOT EXISTS `new_wx_user` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '表id', `uid` int(11) NOT NULL COMMENT 'uid', `wxname` varchar(60) NOT NULL COMMENT '公众号名称', `aeskey` varchar(256) NOT NULL DEFAULT '' COMMENT 'aeskey', `encode` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'encode', `appid` varchar(50) NOT NULL DEFAULT '' COMMENT 'appid', `appsecret` varchar(50) NOT NULL DEFAULT '' COMMENT 'appsecret', `wxid` varchar(20) NOT NULL COMMENT '公众号原始ID', `weixin` char(20) NOT NULL COMMENT '微信号', `headerpic` char(255) NOT NULL COMMENT '头像地址', `token` char(255) NOT NULL COMMENT 'token', `w_token` varchar(150) NOT NULL DEFAULT '' COMMENT '微信对接token', `create_time` varchar(13) NOT NULL COMMENT 'create_time', `updatetime` varchar(13) NOT NULL COMMENT 'updatetime', `tplcontentid` varchar(2) NOT NULL COMMENT '内容模版ID', `share_ticket` varchar(150) NOT NULL COMMENT '分享ticket', `share_dated` char(15) NOT NULL COMMENT 'share_dated', `authorizer_access_token` varchar(200) NOT NULL COMMENT 'authorizer_access_token', `authorizer_refresh_token` varchar(200) NOT NULL COMMENT 'authorizer_refresh_token', `authorizer_expires` char(10) NOT NULL COMMENT 'authorizer_expires', `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '类型', `web_access_token` varchar(200) NOT NULL COMMENT ' 网页授权token', `web_refresh_token` varchar(200) NOT NULL COMMENT 'web_refresh_token', `web_expires` char(10) NOT NULL COMMENT '过期时间', `qr` varchar(200) NOT NULL COMMENT 'qr', `menu_config` text COMMENT '菜单', `wait_access` tinyint(1) DEFAULT '0' COMMENT '微信接入状态,0待接入1已接入', PRIMARY KEY (`id`), KEY `uid` (`uid`) USING BTREE, KEY `uid_2` (`uid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='微信公共帐号' AUTO_INCREMENT=26 ; ``` 示例数据： ``` INSERT INTO `new_wx_user` (`id`, `uid`, `wxname`, `aeskey`, `encode`, `appid`, `appsecret`, `wxid`, `weixin`, `headerpic`, `token`, `w_token`, `create_time`, `updatetime`, `tplcontentid`, `share_ticket`, `share_dated`, `authorizer_access_token`, `authorizer_refresh_token`, `authorizer_expires`, `type`, `web_access_token`, `web_refresh_token`, `web_expires`, `qr`, `menu_config`, `wait_access`) VALUES (25, 0, '搜豹公司', '', 0, 'wxe7', '5352dc2', 'gh_b6', 'wyp5', '/Public/upload/weixin/2016/05-09/573016497ba11.jpg', 'eesops1462769263', 'so', '', '', '', '', '', '', '', '', 4, '', '', '1470973727', '/Public/upload/weixin/2016/05-09/573016665a893.jpg', NULL, 1); ```