MySQL Create Table SQL
Table Structure: okayapi_jieqi_system_online:/tablelist/okayapi_jieqi_system_online.html
-- MySQL Table okayapi_jieqi_system_online
-- From: OkayAPI.com
CREATE TABLE `okayapi_jieqi_system_online` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`siteid` smallint(6) NOT NULL DEFAULT '0' COMMENT '',
`sid` varchar(32) NOT NULL COMMENT '',
`uname` varchar(30) NOT NULL COMMENT '',
`okayapi_jieqi_system_online_name` varchar(30) NOT NULL COMMENT '',
`pass` varchar(32) NOT NULL COMMENT '',
`email` varchar(60) NOT NULL COMMENT '',
`groupid` tinyint(3) NOT NULL DEFAULT '0' COMMENT '',
`logintime` int(11) NOT NULL DEFAULT '0' COMMENT '',
`updatetime` int(11) NOT NULL DEFAULT '0' COMMENT '',
`operate` varchar(100) NOT NULL COMMENT '',
`ip` varchar(25) NOT NULL COMMENT '',
`browser` varchar(50) NOT NULL COMMENT '',
`os` varchar(50) NOT NULL COMMENT '',
`location` varchar(100) NOT NULL COMMENT '',
`state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
`flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
KEY `siteid` (`siteid`),
KEY `sid` (`sid`),
KEY `uname` (`uname`),
KEY `okayapi_jieqi_system_online_name` (`okayapi_jieqi_system_online_name`),
KEY `pass` (`pass`),
KEY `email` (`email`),
KEY `groupid` (`groupid`),
KEY `logintime` (`logintime`),
KEY `updatetime` (`updatetime`),
KEY `operate` (`operate`),
KEY `ip` (`ip`),
KEY `browser` (`browser`),
KEY `os` (`os`),
KEY `location` (`location`),
KEY `state` (`state`),
KEY `flag` (`flag`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'jieqi小说-在线';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-16 of 16 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
siteid | smallint(6) | 0 | 否 | 0 | ||
sid | varchar(32) | 否 | Normal Index | |||
uname | varchar(30) | 否 | ||||
okayapi_jieqi_system_online_name | varchar(30) | 否 | ||||
pass | varchar(32) | 否 | ||||
varchar(60) | 否 | |||||
groupid | tinyint(3) | 0 | 否 | Normal Index | 0 | |
logintime | int(11) | 0 | 否 | 0 | ||
updatetime | int(11) | 0 | 否 | Normal Index | 0 | |
operate | varchar(100) | 否 | ||||
ip | varchar(25) | 否 | ||||
browser | varchar(50) | 否 | ||||
os | varchar(50) | 否 | ||||
location | varchar(100) | 否 | ||||
state | tinyint(1) | 0 | 否 | 0 | ||
flag | tinyint(1) | 0 | 否 | 0 |