mysql sns表,问答社区-分类 - 数据库设计 - 数据库表结构 - 果创云

-- 数据库大全：问答社区-分类

-- 来源：YesApi.cn

CREATE TABLE `yesapi_whatsns_category` (

`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

`yesapi_whatsns_category_name` char(30) NULL COMMENT '',

`dir` char(30) NULL COMMENT '',

`pid` smallint(5) NULL DEFAULT '0' COMMENT '',

`grade` tinyint(1) NULL DEFAULT '0' COMMENT '',

`displayorder` tinyint(3) NULL DEFAULT '0' COMMENT '',

`questions` int(10) NULL DEFAULT '0' COMMENT '',

`alias` varchar(200) NULL COMMENT '',

`miaosu` varchar(500) NULL COMMENT '',

`followers` int(10) NULL DEFAULT '0' COMMENT '',

`image` varchar(200) NULL COMMENT '',

`template` varchar(200) NULL COMMENT '',

`articletemplate` varchar(200) NULL DEFAULT 'topicone' COMMENT '',

`onlybackground` int(2) NULL DEFAULT '0' COMMENT '',

`isshowindex` int(10) NULL DEFAULT '1' COMMENT '',

`isusearticle` int(10) NULL DEFAULT '1' COMMENT '',

`isuseask` int(10) NULL DEFAULT '1' COMMENT '',

`iscourse` int(10) NULL DEFAULT '0' COMMENT '',

KEY `pid` (`pid`),

KEY `grade` (`grade`),

KEY `questions` (`questions`),

KEY `followers` (`followers`),

KEY `onlybackground` (`onlybackground`),

KEY `isshowindex` (`isshowindex`),

KEY `isusearticle` (`isusearticle`),

KEY `isuseask` (`isuseask`),

KEY `iscourse` (`iscourse`),

PRIMARY KEY (`id`)

) ENGINE=InnoDB COMMENT '问答社区-分类';