+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
siteidsmallint(6)00
topicidint(10)0Normal Index0
istopictinyint(1)00
replypidint(10)00
owneridint(11)0Normal Index0
posteridint(11)00
postervarchar(30)
posttimeint(11)00
posteripvarchar(25)
editoridint(10)00
editorvarchar(30)
edittimeint(10)00
editoripvarchar(25)
editnotevarchar(250)
iconidtinyint(3)00
attachmenttext
okayapi_jieqi_system_pposts_subjectvarchar(80)
posttextmediumtext
sizeint(11)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_message

TOP ↑