MySQL Create Table SQL
Table Structure: okayapi_qq_login:/tablelist/okayapi_qq_login.html
-- MySQL Table okayapi_qq_login
-- From: OkayAPI.com
CREATE TABLE `okayapi_qq_login` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`nickname` varchar(100) NULL COMMENT '昵称',
`figureurl` varchar(255) NULL COMMENT '头像',
`gender` varchar(8) NULL COMMENT '性别',
`openid` varchar(128) NULL COMMENT 'qq的openid',
`access_token` varchar(64) NULL COMMENT 'token',
`refresh_token` varchar(64) NULL COMMENT 'refresh_token,有效期长',
`expires_time` int(10) NULL COMMENT '过期时间',
KEY `nickname` (`nickname`),
KEY `figureurl` (`figureurl`),
KEY `gender` (`gender`),
KEY `openid` (`openid`),
KEY `access_token` (`access_token`),
KEY `refresh_token` (`refresh_token`),
KEY `expires_time` (`expires_time`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'QQ联登用户表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-7 of 7 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
nickname | varchar(100) | 是 | 昵称 | |||
figureurl | varchar(255) | 是 | 头像 | |||
gender | varchar(8) | 是 | 性别 | |||
openid | varchar(128) | 是 | qq的openid | Normal Index | ||
access_token | varchar(64) | 是 | token | Normal Index | ||
refresh_token | varchar(64) | 是 | refresh_token,有效期长 | |||
expires_time | int(10) | 是 | 过期时间 |