MySQL Create Table SQL
Table Structure: okayapi_shopxo_s_brand:/tablelist/okayapi_shopxo_s_brand.html
-- MySQL Table okayapi_shopxo_s_brand
-- From: OkayAPI.com
CREATE TABLE `okayapi_shopxo_s_brand` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`brand_category_id` int(11) NOT NULL DEFAULT '0' COMMENT '品牌分类id',
`logo` char(255) NOT NULL COMMENT 'logo图标',
`okayapi_shopxo_s_brand_name` char(30) NOT NULL COMMENT '名称',
`website_url` char(255) NOT NULL COMMENT '官网地址',
`is_enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否启用(0否,1是)',
`sort` tinyint(3) NOT NULL DEFAULT '0' COMMENT '顺序',
`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 `brand_category_id` (`brand_category_id`),
KEY `logo` (`logo`),
KEY `okayapi_shopxo_s_brand_name` (`okayapi_shopxo_s_brand_name`),
KEY `website_url` (`website_url`),
KEY `is_enable` (`is_enable`),
KEY `sort` (`sort`),
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-10 of 10 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
brand_category_id | int(11) | 0 | 是 | 品牌分类id | 0 | |
logo | char(255) | 否 | logo图标 | |||
okayapi_shopxo_s_brand_name | char(30) | 否 | 名称 | |||
website_url | char(255) | 否 | 官网地址 | |||
is_enable | tinyint(1) | 1 | 否 | 是否启用(0否,1是) | Normal Index | 1 |
sort | tinyint(3) | 0 | 否 | 顺序 | 0 | |
seo_title | char(100) | 否 | SEO标题 | |||
seo_keywords | char(130) | 否 | SEO关键字 | |||
seo_desc | char(230) | 否 | SEO描述 | |||
upd_time | int(11) | 0 | 否 | 更新时间 | 0 |