CREATE TABLE `third` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` int(10) unsigned DEFAULT '0' COMMENT '用户ID',
  `platform` varchar(30) DEFAULT '' COMMENT '第三方应用',
  `unionid` varchar(100) DEFAULT '' COMMENT '第三方UNIONID',
  `openid` varchar(100) DEFAULT '' COMMENT '第三方OPENID',
  `token` varchar(255) DEFAULT '' COMMENT 'token',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `用户id和openid` (`user_id`,`openid`) USING HASH,
  UNIQUE KEY `用户id和unionid` (`user_id`,`unionid`) USING HASH,
  KEY `用户id` (`user_id`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='第三方登录表';