+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
okayapi_srcms_post_sessionvarchar(255)
titlevarchar(255)
contenttext
advisevarchar(255)
okayapi_srcms_post_timevarchar(11)00
okayapi_srcms_post_daytinyint(1)0修补期限0
cate_idint(11)
user_idint(11)
ranktinyint(1)1漏洞等级1
bountyvarchar(255)0漏洞报告奖励0
okayapi_srcms_post_typetinyint(1)11:审核中,2:已忽略,3:已确认,4:已修复1
visibleint(2)00

Guess You Like

MySQL Table Design okayapi_srcms_blog

MySQL Table Design okayapi_srcms_category

MySQL Table Design okayapi_srcms_comment

MySQL Table Design okayapi_srcms_hall

MySQL Table Design okayapi_srcms_info

MySQL Table Design okayapi_srcms_links

MySQL Table Design okayapi_srcms_manager

MySQL Table Design okayapi_srcms_member

MySQL Table Design okayapi_srcms_notes

MySQL Table Design okayapi_srcms_order

MySQL Table Design okayapi_srcms_page

MySQL Table Design okayapi_srcms_record

MySQL Table Design okayapi_srcms_setting

TOP ↑