MySQL Create Table SQL
Table Structure: okayapi_jieqi_system_friends:/tablelist/okayapi_jieqi_system_friends.html
-- MySQL Table okayapi_jieqi_system_friends
-- From: OkayAPI.com
CREATE TABLE `okayapi_jieqi_system_friends` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`adddate` int(11) NOT NULL DEFAULT '0' COMMENT '',
`myid` int(11) NOT NULL DEFAULT '0' COMMENT '',
`myname` varchar(30) NOT NULL COMMENT '',
`yourid` int(11) NOT NULL DEFAULT '0' COMMENT '',
`yourname` varchar(30) NOT NULL COMMENT '',
`teamid` int(11) NOT NULL DEFAULT '0' COMMENT '',
`team` varchar(50) NOT NULL COMMENT '',
`fset` text NOT NULL COMMENT '',
`state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
`flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
KEY `adddate` (`adddate`),
KEY `myid` (`myid`),
KEY `myname` (`myname`),
KEY `yourid` (`yourid`),
KEY `yourname` (`yourname`),
KEY `teamid` (`teamid`),
KEY `team` (`team`),
KEY `fset` (`fset`),
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-10 of 10 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
adddate | int(11) | 0 | 否 | 0 | ||
myid | int(11) | 0 | 否 | 0 | ||
myname | varchar(30) | 否 | ||||
yourid | int(11) | 0 | 否 | 0 | ||
yourname | varchar(30) | 否 | ||||
teamid | int(11) | 0 | 否 | Normal Index | 0 | |
team | varchar(50) | 否 | ||||
fset | text | 否 | ||||
state | tinyint(1) | 0 | 否 | 0 | ||
flag | tinyint(1) | 0 | 否 | 0 |