+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_jieqi_system_message:/tablelist/okayapi_jieqi_system_message.html


-- MySQL Table okayapi_jieqi_system_message
-- From: OkayAPI.com
CREATE TABLE `okayapi_jieqi_system_message` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `siteid` smallint(6) NOT NULL DEFAULT '0' COMMENT '',
    `postdate` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `fromid` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `fromname` varchar(30) NOT NULL COMMENT '',
    `toid` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `toname` varchar(30) NOT NULL COMMENT '',
    `title` varchar(100) NOT NULL COMMENT '',
    `content` mediumtext NOT NULL COMMENT '',
    `messagetype` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `isread` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `fromdel` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `todel` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `enablebbcode` tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
    `enablehtml` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `enablesmilies` tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
    `attachsig` tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
    `attachment` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    KEY `siteid` (`siteid`),
    KEY `postdate` (`postdate`),
    KEY `fromid` (`fromid`),
    KEY `fromname` (`fromname`),
    KEY `toid` (`toid`),
    KEY `toname` (`toname`),
    KEY `title` (`title`),
    KEY `content` (`content`),
    KEY `messagetype` (`messagetype`),
    KEY `isread` (`isread`),
    KEY `fromdel` (`fromdel`),
    KEY `todel` (`todel`),
    KEY `enablebbcode` (`enablebbcode`),
    KEY `enablehtml` (`enablehtml`),
    KEY `enablesmilies` (`enablesmilies`),
    KEY `attachsig` (`attachsig`),
    KEY `attachment` (`attachment`),
    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-17 of 17 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
siteidsmallint(6)00
postdateint(11)00
fromidint(11)0Normal Index0
fromnamevarchar(30)
toidint(11)0Normal Index0
tonamevarchar(30)
titlevarchar(100)
contentmediumtext
messagetypetinyint(1)00
isreadtinyint(1)00
fromdeltinyint(1)00
todeltinyint(1)00
enablebbcodetinyint(1)11
enablehtmltinyint(1)00
enablesmiliestinyint(1)11
attachsigtinyint(1)11
attachmenttinyint(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_modules

TOP ↑