MySQL Create Table SQL
Table Structure: okayapi_lvyou_jee_article:/tablelist/okayapi_lvyou_jee_article.html
-- MySQL Table okayapi_lvyou_jee_article
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_article` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`publish_id` int(11) NOT NULL COMMENT '',
`cid` int(11) NOT NULL COMMENT '',
`title` varchar(255) NOT NULL COMMENT '',
`pic` varchar(200) NOT NULL COMMENT '',
`okayapi_lvyou_jee_article_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
`link` varchar(255) NOT NULL COMMENT '',
`okayapi_lvyou_jee_article_source` varchar(100) NOT NULL DEFAULT '本站' COMMENT '',
`source_url` varchar(255) NOT NULL DEFAULT '#' COMMENT '',
`content` text NOT NULL COMMENT '',
`hits` int(11) NOT NULL DEFAULT '0' COMMENT '',
`sort` int(11) NOT NULL DEFAULT '0' COMMENT '',
`okayapi_lvyou_jee_article_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
KEY `publish_id` (`publish_id`),
KEY `cid` (`cid`),
KEY `title` (`title`),
KEY `pic` (`pic`),
KEY `okayapi_lvyou_jee_article_type` (`okayapi_lvyou_jee_article_type`),
KEY `link` (`link`),
KEY `okayapi_lvyou_jee_article_source` (`okayapi_lvyou_jee_article_source`),
KEY `source_url` (`source_url`),
KEY `content` (`content`),
KEY `hits` (`hits`),
KEY `sort` (`sort`),
KEY `okayapi_lvyou_jee_article_status` (`okayapi_lvyou_jee_article_status`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'lvyou旅游-文章管理';
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 |
---|---|---|---|---|---|---|
publish_id | int(11) | 否 | ||||
cid | int(11) | 否 | ||||
title | varchar(255) | 否 | ||||
pic | varchar(200) | 是 | ||||
okayapi_lvyou_jee_article_type | tinyint(1) | 1 | 否 | 1 | ||
link | varchar(255) | 是 | ||||
okayapi_lvyou_jee_article_source | varchar(100) | 本站 | 否 | 本站 | ||
source_url | varchar(255) | # | 否 | # | ||
content | text | 是 | ||||
hits | int(11) | 0 | 否 | 0 | ||
sort | int(11) | 0 | 否 | 0 | ||
okayapi_lvyou_jee_article_status | tinyint(1) | 1 | 否 | 1 |