表構造:サードパーティログインユーザー
1158 ワード
CREATE TABLE `__PREFIX__third` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT ' ID',
`platform` varchar(30) NOT NULL DEFAULT '' COMMENT ' ',
`openid` varchar(50) NOT NULL DEFAULT '' COMMENT ' ID',
`openname` varchar(50) NOT NULL DEFAULT '' COMMENT ' ',
`access_token` varchar(255) NOT NULL DEFAULT '' COMMENT 'AccessToken',
`refresh_token` varchar(255) NOT NULL DEFAULT 'RefreshToken',
`expires_in` int(10) unsigned NOT NULL DEFAULT '0' COMMENT ' ',
`create_time` int(10) unsigned DEFAULT NULL COMMENT ' ',
`update_time` int(10) unsigned DEFAULT NULL COMMENT ' ',
`login_time` int(10) unsigned DEFAULT NULL COMMENT ' ',
`expire_time` int(10) unsigned DEFAULT NULL COMMENT ' ',
PRIMARY KEY (`id`),
UNIQUE KEY `platform` (`platform`,`openid`),
KEY `user_id` (`user_id`,`platform`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT=' ';