问答社区-问题

-- 数据库大全：问答社区-问题
-- 来源：YesApi.cn
CREATE TABLE `yesapi_whatsns_question` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `cid` smallint(5) NULL DEFAULT '0' COMMENT '',
    `cid1` smallint(5) NULL DEFAULT '0' COMMENT '',
    `cid2` smallint(5) NULL DEFAULT '0' COMMENT '',
    `cid3` smallint(5) NULL DEFAULT '0' COMMENT '',
    `price` smallint(6) NULL DEFAULT '0' COMMENT '',
    `author` char(15) NULL COMMENT '',
    `authorid` int(10) NULL DEFAULT '0' COMMENT '',
    `title` char(50) NULL COMMENT '',
    `description` text NULL COMMENT '',
    `supply` text NULL COMMENT '',
    `yesapi_whatsns_question_time` int(10) NULL DEFAULT '0' COMMENT '',
    `endtime` int(10) NULL DEFAULT '0' COMMENT '',
    `hidden` tinyint(1) NULL DEFAULT '0' COMMENT '',
    `answers` smallint(5) NULL DEFAULT '0' COMMENT '',
    `attentions` int(10) NULL DEFAULT '0' COMMENT '',
    `goods` mediumint(8) NULL DEFAULT '0' COMMENT '',
    `yesapi_whatsns_question_status` tinyint(1) NULL DEFAULT '1' COMMENT '',
    `ip` varchar(20) NULL COMMENT 'ip地址',
    `views` int(10) NULL DEFAULT '0' COMMENT '',
    `shangjin` double NULL DEFAULT '0' COMMENT '',
    `hasvoice` int(10) NULL DEFAULT '0' COMMENT '',
    `askuid` int(10) NULL DEFAULT '0' COMMENT '',
    `askcity` varchar(200) NULL COMMENT '',
    KEY `cid1` (`cid1`),
    KEY `cid2` (`cid2`),
    KEY `cid3` (`cid3`),
    KEY `price` (`price`),
    KEY `authorid` (`authorid`),
    KEY `yesapi_whatsns_question_time` (`yesapi_whatsns_question_time`),
    KEY `answers` (`answers`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '问答社区-问题';

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