MySQL Create Table SQL
Table Structure: okayapi_shopxo_s_user:/tablelist/okayapi_shopxo_s_user.html
-- MySQL Table okayapi_shopxo_s_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_shopxo_s_user` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`alipay_openid` char(60) NOT NULL COMMENT '支付宝openid',
`weixin_openid` char(60) NOT NULL COMMENT '微信openid',
`weixin_web_openid` char(60) NOT NULL COMMENT '微信web用户openid',
`baidu_openid` char(60) NOT NULL COMMENT '百度openid',
`okayapi_shopxo_s_user_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态(0正常, 1禁止发言, 2禁止登录)',
`salt` char(32) NOT NULL COMMENT '配合密码加密串',
`pwd` char(32) NOT NULL COMMENT '登录密码',
`token` char(60) NOT NULL COMMENT 'token',
`username` char(60) NOT NULL COMMENT '用户名',
`nickname` char(60) NOT NULL COMMENT '用户昵称',
`mobile` char(11) NOT NULL COMMENT '手机号码',
`email` char(60) NOT NULL COMMENT '电子邮箱(最大长度60个字符)',
`gender` tinyint(1) NOT NULL DEFAULT '0' COMMENT '性别(0保密,1女,2男)',
`avatar` char(255) NOT NULL COMMENT '用户头像地址',
`province` char(60) NOT NULL COMMENT '所在省',
`city` char(60) NOT NULL COMMENT '所在市',
`birthday` int(11) NOT NULL DEFAULT '0' COMMENT '生日',
`address` char(150) NOT NULL COMMENT '详细地址',
`integral` int(10) NOT NULL DEFAULT '0' COMMENT '积分',
`locking_integral` int(10) NOT NULL DEFAULT '0' COMMENT '锁定积分',
`referrer` int(11) NOT NULL DEFAULT '0' COMMENT '推荐人用户id',
`is_delete_time` int(11) NOT NULL DEFAULT '0' COMMENT '是否已删除(0否, 大于0删除时间)',
`upd_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
KEY `alipay_openid` (`alipay_openid`),
KEY `weixin_openid` (`weixin_openid`),
KEY `weixin_web_openid` (`weixin_web_openid`),
KEY `baidu_openid` (`baidu_openid`),
KEY `okayapi_shopxo_s_user_status` (`okayapi_shopxo_s_user_status`),
KEY `salt` (`salt`),
KEY `pwd` (`pwd`),
KEY `token` (`token`),
KEY `username` (`username`),
KEY `nickname` (`nickname`),
KEY `mobile` (`mobile`),
KEY `email` (`email`),
KEY `gender` (`gender`),
KEY `avatar` (`avatar`),
KEY `province` (`province`),
KEY `city` (`city`),
KEY `birthday` (`birthday`),
KEY `address` (`address`),
KEY `integral` (`integral`),
KEY `locking_integral` (`locking_integral`),
KEY `referrer` (`referrer`),
KEY `is_delete_time` (`is_delete_time`),
KEY `upd_time` (`upd_time`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'ShopXO商城-用户';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-23 of 23 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
alipay_openid | char(60) | 否 | 支付宝openid | Normal Index | ||
weixin_openid | char(60) | 否 | 微信openid | Normal Index | ||
weixin_web_openid | char(60) | 否 | 微信web用户openid | |||
baidu_openid | char(60) | 否 | 百度openid | Normal Index | ||
okayapi_shopxo_s_user_status | tinyint(1) | 0 | 否 | 状态(0正常, 1禁止发言, 2禁止登录) | 0 | |
salt | char(32) | 否 | 配合密码加密串 | |||
pwd | char(32) | 否 | 登录密码 | |||
token | char(60) | 否 | token | Normal Index | ||
username | char(60) | 否 | 用户名 | Normal Index | ||
nickname | char(60) | 否 | 用户昵称 | |||
mobile | char(11) | 否 | 手机号码 | Normal Index | ||
char(60) | 否 | 电子邮箱(最大长度60个字符) | ||||
gender | tinyint(1) | 0 | 否 | 性别(0保密,1女,2男) | 0 | |
avatar | char(255) | 否 | 用户头像地址 | |||
province | char(60) | 否 | 所在省 | |||
city | char(60) | 否 | 所在市 | |||
birthday | int(11) | 0 | 否 | 生日 | 0 | |
address | char(150) | 否 | 详细地址 | |||
integral | int(10) | 0 | 否 | 积分 | 0 | |
locking_integral | int(10) | 0 | 否 | 锁定积分 | 0 | |
referrer | int(11) | 0 | 否 | 推荐人用户id | 0 | |
is_delete_time | int(11) | 0 | 否 | 是否已删除(0否, 大于0删除时间) | 0 | |
upd_time | int(11) | 0 | 否 | 更新时间 | 0 |