+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
adddateint(11)00
myidint(11)00
mynamevarchar(30)
youridint(11)00
yournamevarchar(30)
teamidint(11)0Normal Index0
teamvarchar(50)
fsettext
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_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

MySQL Table Design okayapi_jieqi_system_modules

TOP ↑