jieqi小说-发布

-- 数据库大全：jieqi小说-发布
-- 来源：YesApi.cn
CREATE TABLE `yesapi_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 '',
    `yesapi_jieqi_system_pposts_subject` varchar(80) NOT NULL COMMENT '',
    `posttext` mediumtext NOT NULL COMMENT '',
    `size` int(11) NOT NULL DEFAULT '0' COMMENT '',
    KEY `topicid` (`topicid`),
    KEY `ownerid` (`ownerid`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'jieqi小说-发布';

复制后，到数据库执行，即可创建此数据库表。