MySQL Create Table SQL
Table Structure: okayapi_jieqi_system_ptopics:/tablelist/okayapi_jieqi_system_ptopics.html
-- MySQL Table okayapi_jieqi_system_ptopics
-- From: OkayAPI.com
CREATE TABLE `okayapi_jieqi_system_ptopics` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`siteid` smallint(6) NOT NULL DEFAULT '0' COMMENT '',
`ownerid` int(11) NOT NULL DEFAULT '0' COMMENT '',
`title` varchar(80) NOT NULL COMMENT '',
`posterid` int(11) NOT NULL DEFAULT '0' COMMENT '',
`poster` varchar(30) NOT NULL COMMENT '',
`posttime` int(11) NOT NULL DEFAULT '0' COMMENT '',
`replierid` int(10) NOT NULL DEFAULT '0' COMMENT '',
`replier` varchar(30) NOT NULL COMMENT '',
`replytime` int(11) NOT NULL DEFAULT '0' COMMENT '',
`views` mediumint(8) NOT NULL DEFAULT '0' COMMENT '',
`replies` mediumint(8) NOT NULL DEFAULT '0' COMMENT '',
`islock` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
`istop` int(11) NOT NULL DEFAULT '0' COMMENT '',
`isgood` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
`rate` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
`attachment` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
`needperm` int(10) NOT NULL DEFAULT '0' COMMENT '',
`needscore` int(10) NOT NULL DEFAULT '0' COMMENT '',
`needexp` int(10) NOT NULL DEFAULT '0' COMMENT '',
`needprice` int(10) NOT NULL DEFAULT '0' COMMENT '',
`sortid` tinyint(3) NOT NULL DEFAULT '0' COMMENT '',
`iconid` tinyint(3) NOT NULL DEFAULT '0' COMMENT '',
`typeid` tinyint(3) NOT NULL DEFAULT '0' COMMENT '',
`lastinfo` varchar(255) NOT NULL COMMENT '',
`linkurl` varchar(100) NOT NULL COMMENT '',
`size` int(11) NOT NULL DEFAULT '0' COMMENT '',
KEY `siteid` (`siteid`),
KEY `ownerid` (`ownerid`),
KEY `title` (`title`),
KEY `posterid` (`posterid`),
KEY `poster` (`poster`),
KEY `posttime` (`posttime`),
KEY `replierid` (`replierid`),
KEY `replier` (`replier`),
KEY `replytime` (`replytime`),
KEY `views` (`views`),
KEY `replies` (`replies`),
KEY `islock` (`islock`),
KEY `istop` (`istop`),
KEY `isgood` (`isgood`),
KEY `rate` (`rate`),
KEY `attachment` (`attachment`),
KEY `needperm` (`needperm`),
KEY `needscore` (`needscore`),
KEY `needexp` (`needexp`),
KEY `needprice` (`needprice`),
KEY `sortid` (`sortid`),
KEY `iconid` (`iconid`),
KEY `typeid` (`typeid`),
KEY `lastinfo` (`lastinfo`),
KEY `linkurl` (`linkurl`),
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-26 of 26 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
siteid | smallint(6) | 0 | 否 | 0 | ||
ownerid | int(11) | 0 | 否 | Normal Index | 0 | |
title | varchar(80) | 否 | ||||
posterid | int(11) | 0 | 否 | Normal Index | 0 | |
poster | varchar(30) | 否 | ||||
posttime | int(11) | 0 | 否 | 0 | ||
replierid | int(10) | 0 | 否 | 0 | ||
replier | varchar(30) | 否 | ||||
replytime | int(11) | 0 | 否 | 0 | ||
views | mediumint(8) | 0 | 否 | 0 | ||
replies | mediumint(8) | 0 | 否 | 0 | ||
islock | tinyint(1) | 0 | 否 | 0 | ||
istop | int(11) | 0 | 否 | 0 | ||
isgood | tinyint(1) | 0 | 否 | 0 | ||
rate | tinyint(1) | 0 | 否 | 0 | ||
attachment | tinyint(1) | 0 | 否 | 0 | ||
needperm | int(10) | 0 | 否 | 0 | ||
needscore | int(10) | 0 | 否 | 0 | ||
needexp | int(10) | 0 | 否 | 0 | ||
needprice | int(10) | 0 | 否 | 0 | ||
sortid | tinyint(3) | 0 | 否 | 0 | ||
iconid | tinyint(3) | 0 | 否 | 0 | ||
typeid | tinyint(3) | 0 | 否 | 0 | ||
lastinfo | varchar(255) | 否 | ||||
linkurl | varchar(100) | 否 | ||||
size | int(11) | 0 | 否 | 0 |