+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
siteidsmallint(6)00
sidvarchar(32)Normal Index
unamevarchar(30)
okayapi_jieqi_system_online_namevarchar(30)
passvarchar(32)
emailvarchar(60)
groupidtinyint(3)0Normal Index0
logintimeint(11)00
updatetimeint(11)0Normal Index0
operatevarchar(100)
ipvarchar(25)
browservarchar(50)
osvarchar(50)
locationvarchar(100)
statetinyint(1)00
flagtinyint(1)00

Guess You Like

MySQL Table Design okayapi_xwx_author

MySQL Table Design okayapi_xwx_banner

MySQL Table Design okayapi_xwx_book

MySQL Table Design okayapi_xwx_category

MySQL Table Design okayapi_xwx_chapter

MySQL Table Design okayapi_xwx_tag

MySQL Table Design okayapi_xwx_admin

MySQL Table Design okayapi_xwx_friendship_link

MySQL Table Design okayapi_jieqi_system_adminmenu

MySQL Table Design okayapi_jieqi_system_blockconfigs

MySQL Table Design okayapi_jieqi_system_blocks

MySQL Table Design okayapi_jieqi_system_configs

MySQL Table Design okayapi_jieqi_system_defaultmenu

MySQL Table Design okayapi_jieqi_system_friends

MySQL Table Design okayapi_jieqi_system_groups

MySQL Table Design okayapi_jieqi_system_honors

MySQL Table Design okayapi_jieqi_system_logs

MySQL Table Design okayapi_jieqi_system_mainmenu

MySQL Table Design okayapi_jieqi_system_mblock

MySQL Table Design okayapi_jieqi_system_message

TOP ↑