MySQL Create Table SQL
Table Structure: okayapi_srcms_post:/tablelist/okayapi_srcms_post.html
-- MySQL Table okayapi_srcms_post
-- From: OkayAPI.com
CREATE TABLE `okayapi_srcms_post` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`okayapi_srcms_post_session` varchar(255) NOT NULL COMMENT '',
`title` varchar(255) NOT NULL COMMENT '',
`content` text NOT NULL COMMENT '',
`advise` varchar(255) NOT NULL COMMENT '',
`okayapi_srcms_post_time` varchar(11) NOT NULL DEFAULT '0' COMMENT '',
`okayapi_srcms_post_day` tinyint(1) NOT NULL DEFAULT '0' COMMENT '修补期限',
`cate_id` int(11) NOT NULL COMMENT '',
`user_id` int(11) NOT NULL COMMENT '',
`rank` tinyint(1) NOT NULL DEFAULT '1' COMMENT '漏洞等级',
`bounty` varchar(255) NOT NULL DEFAULT '0' COMMENT '漏洞报告奖励',
`okayapi_srcms_post_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1:审核中,2:已忽略,3:已确认,4:已修复',
`visible` int(2) NOT NULL DEFAULT '0' COMMENT '',
KEY `okayapi_srcms_post_session` (`okayapi_srcms_post_session`),
KEY `title` (`title`),
KEY `content` (`content`),
KEY `advise` (`advise`),
KEY `okayapi_srcms_post_time` (`okayapi_srcms_post_time`),
KEY `okayapi_srcms_post_day` (`okayapi_srcms_post_day`),
KEY `cate_id` (`cate_id`),
KEY `user_id` (`user_id`),
KEY `rank` (`rank`),
KEY `bounty` (`bounty`),
KEY `okayapi_srcms_post_type` (`okayapi_srcms_post_type`),
KEY `visible` (`visible`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'SRCMS-投递';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-12 of 12 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
okayapi_srcms_post_session | varchar(255) | 否 | ||||
title | varchar(255) | 是 | ||||
content | text | 是 | ||||
advise | varchar(255) | 否 | ||||
okayapi_srcms_post_time | varchar(11) | 0 | 是 | 0 | ||
okayapi_srcms_post_day | tinyint(1) | 0 | 否 | 修补期限 | 0 | |
cate_id | int(11) | 是 | ||||
user_id | int(11) | 是 | ||||
rank | tinyint(1) | 1 | 否 | 漏洞等级 | 1 | |
bounty | varchar(255) | 0 | 否 | 漏洞报告奖励 | 0 | |
okayapi_srcms_post_type | tinyint(1) | 1 | 是 | 1:审核中,2:已忽略,3:已确认,4:已修复 | 1 | |
visible | int(2) | 0 | 否 | 0 |