MySQL Create Table SQL
Table Structure: okayapi_shopxo_s_article:/tablelist/okayapi_shopxo_s_article.html
-- MySQL Table okayapi_shopxo_s_article
-- From: OkayAPI.com
CREATE TABLE `okayapi_shopxo_s_article` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` char(60) NOT NULL COMMENT '标题',
`article_category_id` int(11) NOT NULL DEFAULT '0' COMMENT '文章分类',
`title_color` char(7) NOT NULL COMMENT '标题颜色',
`jump_url` char(255) NOT NULL COMMENT '跳转url地址',
`is_enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否启用(0否,1是)',
`content` text NOT NULL COMMENT '内容',
`image` text NOT NULL COMMENT '图片数据(一维数组json)',
`image_count` tinyint(3) NOT NULL DEFAULT '0' COMMENT '文章图片数量',
`access_count` int(11) NOT NULL DEFAULT '0' COMMENT '访问次数',
`is_home_recommended` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否首页推荐(0否, 1是)',
`seo_title` char(100) NOT NULL COMMENT 'SEO标题',
`seo_keywords` char(130) NOT NULL COMMENT 'SEO关键字',
`seo_desc` char(230) NOT NULL COMMENT 'SEO描述',
`upd_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
KEY `title` (`title`),
KEY `article_category_id` (`article_category_id`),
KEY `title_color` (`title_color`),
KEY `jump_url` (`jump_url`),
KEY `is_enable` (`is_enable`),
KEY `content` (`content`),
KEY `image` (`image`),
KEY `image_count` (`image_count`),
KEY `access_count` (`access_count`),
KEY `is_home_recommended` (`is_home_recommended`),
KEY `seo_title` (`seo_title`),
KEY `seo_keywords` (`seo_keywords`),
KEY `seo_desc` (`seo_desc`),
KEY `upd_time` (`upd_time`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'ShopXO商城-文章';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-14 of 14 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
title | char(60) | 否 | 标题 | Normal Index | ||
article_category_id | int(11) | 0 | 否 | 文章分类 | Normal Index | 0 |
title_color | char(7) | 否 | 标题颜色 | |||
jump_url | char(255) | 否 | 跳转url地址 | |||
is_enable | tinyint(1) | 1 | 否 | 是否启用(0否,1是) | Normal Index | 1 |
content | text | 是 | 内容 | |||
image | text | 是 | 图片数据(一维数组json) | |||
image_count | tinyint(3) | 0 | 否 | 文章图片数量 | Normal Index | 0 |
access_count | int(11) | 0 | 否 | 访问次数 | Normal Index | 0 |
is_home_recommended | tinyint(2) | 0 | 否 | 是否首页推荐(0否, 1是) | 0 | |
seo_title | char(100) | 否 | SEO标题 | |||
seo_keywords | char(130) | 否 | SEO关键字 | |||
seo_desc | char(230) | 否 | SEO描述 | |||
upd_time | int(11) | 0 | 否 | 更新时间 | 0 |