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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
siteid | smallint(6) | 0 | 否 | 0 | ||
postdate | int(11) | 0 | 否 | 0 | ||
fromid | int(11) | 0 | 否 | Normal Index | 0 | |
fromname | varchar(30) | 否 | ||||
toid | int(11) | 0 | 否 | Normal Index | 0 | |
toname | varchar(30) | 否 | ||||
title | varchar(100) | 否 | ||||
content | mediumtext | 否 | ||||
messagetype | tinyint(1) | 0 | 否 | 0 | ||
isread | tinyint(1) | 0 | 否 | 0 | ||
fromdel | tinyint(1) | 0 | 否 | 0 | ||
todel | tinyint(1) | 0 | 否 | 0 | ||
enablebbcode | tinyint(1) | 1 | 否 | 1 | ||
enablehtml | tinyint(1) | 0 | 否 | 0 | ||
enablesmilies | tinyint(1) | 1 | 否 | 1 | ||
attachsig | tinyint(1) | 1 | 否 | 1 | ||
attachment | tinyint(1) | 0 | 否 | 0 |