db_wechat_init.sql 1.3 KB

1234567891011121314151617181920212223
  1. CREATE TABLE `we_third` (
  2. `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  3. `user_id` int(10) unsigned DEFAULT '0' COMMENT '会员ID',
  4. `platform` varchar(30) DEFAULT '' COMMENT '第三方应用',
  5. `apptype` varchar(50) DEFAULT '' COMMENT '应用类型',
  6. `appid` varchar(100) DEFAULT NULL COMMENT '应用标识',
  7. `unionid` varchar(100) DEFAULT '' COMMENT '第三方UNIONID',
  8. `openid` varchar(100) DEFAULT '' COMMENT '第三方OPENID',
  9. `openname` varchar(100) DEFAULT '' COMMENT '第三方会员昵称',
  10. `sex` varchar(1) DEFAULT NULL COMMENT '性别',
  11. `headimgurl` varchar(255) DEFAULT NULL COMMENT '头像',
  12. `access_token` varchar(255) DEFAULT '' COMMENT 'AccessToken',
  13. `refresh_token` varchar(255) DEFAULT 'RefreshToken',
  14. `expires_in` int(10) unsigned DEFAULT '0' COMMENT '有效期',
  15. `createtime` int(10) unsigned DEFAULT NULL COMMENT '创建时间',
  16. `updatetime` int(10) unsigned DEFAULT NULL COMMENT '更新时间',
  17. `logintime` int(10) unsigned DEFAULT NULL COMMENT '登录时间',
  18. `expiretime` int(10) unsigned DEFAULT NULL COMMENT '过期时间',
  19. PRIMARY KEY (`id`),
  20. UNIQUE KEY `platform` (`platform`,`openid`),
  21. KEY `user_id` (`user_id`,`platform`),
  22. KEY `unionid` (`platform`,`unionid`)
  23. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='第三方登录表';