MySQL Create Table SQL
Table Structure: okayapi_seo_article:/tablelist/okayapi_seo_article.html
-- MySQL Table okayapi_seo_article
-- From: OkayAPI.com
CREATE TABLE `okayapi_seo_article` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(50) NOT NULL COMMENT '标题',
`cover` varchar(100) NOT NULL COMMENT '封面',
`seo_key` varchar(50) NOT NULL COMMENT 'seo关键字',
`seo_content` varchar(1000) NOT NULL COMMENT 'seo内容',
`cate_id` int(10) NOT NULL DEFAULT '0' COMMENT '分类id',
`description` char(140) NOT NULL COMMENT '描述',
`position` smallint(5) NOT NULL DEFAULT '0' COMMENT '推荐位',
`content` longtext NOT NULL COMMENT '文章内容',
`link` varchar(100) NOT NULL COMMENT '外链',
`author` varchar(40) NOT NULL COMMENT '作者',
`view` int(10) NOT NULL DEFAULT '0' COMMENT '浏览量',
`sort` int(10) NOT NULL DEFAULT '0' COMMENT '优先级',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
KEY `title` (`title`),
KEY `cover` (`cover`),
KEY `seo_key` (`seo_key`),
KEY `seo_content` (`seo_content`),
KEY `cate_id` (`cate_id`),
KEY `description` (`description`),
KEY `position` (`position`),
KEY `content` (`content`),
KEY `link` (`link`),
KEY `author` (`author`),
KEY `view` (`view`),
KEY `sort` (`sort`),
KEY `status` (`status`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '推广文章-seo';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-13 of 13 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
title | varchar(50) | 否 | 标题 | |||
cover | varchar(100) | 否 | 封面 | |||
seo_key | varchar(50) | 否 | seo关键字 | |||
seo_content | varchar(1000) | 否 | seo内容 | |||
cate_id | int(10) | 0 | 否 | 分类id | 0 | |
description | char(140) | 否 | 描述 | |||
position | smallint(5) | 0 | 否 | 推荐位 | 0 | |
content | longtext | 否 | 文章内容 | |||
link | varchar(100) | 否 | 外链 | |||
author | varchar(40) | 否 | 作者 | |||
view | int(10) | 0 | 否 | 浏览量 | 0 | |
sort | int(10) | 0 | 否 | 优先级 | 0 | |
status | tinyint(4) | 1 | 否 | 状态 | 1 |