## 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); ```