MySQL Create Table SQL
Table Structure: okayapi_jieqi_system_pposts:/tablelist/okayapi_jieqi_system_pposts.html
-- MySQL Table okayapi_jieqi_system_pposts
-- From: OkayAPI.com
CREATE TABLE `okayapi_jieqi_system_pposts` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`siteid` smallint(6) NOT NULL DEFAULT '0' COMMENT '',
`topicid` int(10) NOT NULL DEFAULT '0' COMMENT '',
`istopic` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
`replypid` int(10) NOT NULL DEFAULT '0' COMMENT '',
`ownerid` int(11) NOT NULL DEFAULT '0' COMMENT '',
`posterid` int(11) NOT NULL DEFAULT '0' COMMENT '',
`poster` varchar(30) NOT NULL COMMENT '',
`posttime` int(11) NOT NULL DEFAULT '0' COMMENT '',
`posterip` varchar(25) NOT NULL COMMENT '',
`editorid` int(10) NOT NULL DEFAULT '0' COMMENT '',
`editor` varchar(30) NOT NULL COMMENT '',
`edittime` int(10) NOT NULL DEFAULT '0' COMMENT '',
`editorip` varchar(25) NOT NULL COMMENT '',
`editnote` varchar(250) NOT NULL COMMENT '',
`iconid` tinyint(3) NOT NULL DEFAULT '0' COMMENT '',
`attachment` text NOT NULL COMMENT '',
`okayapi_jieqi_system_pposts_subject` varchar(80) NOT NULL COMMENT '',
`posttext` mediumtext NOT NULL COMMENT '',
`size` int(11) NOT NULL DEFAULT '0' COMMENT '',
KEY `siteid` (`siteid`),
KEY `topicid` (`topicid`),
KEY `istopic` (`istopic`),
KEY `replypid` (`replypid`),
KEY `ownerid` (`ownerid`),
KEY `posterid` (`posterid`),
KEY `poster` (`poster`),
KEY `posttime` (`posttime`),
KEY `posterip` (`posterip`),
KEY `editorid` (`editorid`),
KEY `editor` (`editor`),
KEY `edittime` (`edittime`),
KEY `editorip` (`editorip`),
KEY `editnote` (`editnote`),
KEY `iconid` (`iconid`),
KEY `attachment` (`attachment`),
KEY `okayapi_jieqi_system_pposts_subject` (`okayapi_jieqi_system_pposts_subject`),
KEY `posttext` (`posttext`),
KEY `size` (`size`),
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-19 of 19 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
siteid | smallint(6) | 0 | 否 | 0 | ||
topicid | int(10) | 0 | 否 | Normal Index | 0 | |
istopic | tinyint(1) | 0 | 否 | 0 | ||
replypid | int(10) | 0 | 否 | 0 | ||
ownerid | int(11) | 0 | 否 | Normal Index | 0 | |
posterid | int(11) | 0 | 否 | 0 | ||
poster | varchar(30) | 否 | ||||
posttime | int(11) | 0 | 否 | 0 | ||
posterip | varchar(25) | 否 | ||||
editorid | int(10) | 0 | 否 | 0 | ||
editor | varchar(30) | 否 | ||||
edittime | int(10) | 0 | 否 | 0 | ||
editorip | varchar(25) | 否 | ||||
editnote | varchar(250) | 否 | ||||
iconid | tinyint(3) | 0 | 否 | 0 | ||
attachment | text | 否 | ||||
okayapi_jieqi_system_pposts_subject | varchar(80) | 否 | ||||
posttext | mediumtext | 否 | ||||
size | int(11) | 0 | 否 | 0 |