+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
nicknamevarchar(100)昵称
figureurlvarchar(255)头像
gendervarchar(8)性别
openidvarchar(128)qq的openidNormal Index
access_tokenvarchar(64)tokenNormal Index
refresh_tokenvarchar(64)refresh_token,有效期长
expires_timeint(10)过期时间

Guess You Like

MySQL Table Design okayapi_mobile

MySQL Table Design okayapi_qq

MySQL Table Design okayapi_rank

MySQL Table Design okayapi_moment

MySQL Table Design okayapi_user

MySQL Table Design okayapi_friend

MySQL Table Design okayapi_lend_book

MySQL Table Design okayapi_charter_car_info

MySQL Table Design okayapi_charter_car_book

TOP ↑