MySQL Create Table SQL
Table Structure: okayapi_srcms_category：/tablelist/okayapi_srcms_category.html
-- MySQL Table okayapi_srcms_category
-- From: OkayAPI.com
CREATE TABLE `okayapi_srcms_category` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(11) NULL COMMENT '父分类ID',
`okayapi_srcms_category_name` varchar(20) NULL COMMENT '分类别名',
`title` varchar(100) NULL COMMENT '分类标题',
`keywords` varchar(255) NULL COMMENT '分类关键词',
`description` varchar(255) NULL COMMENT '分类描述',
KEY `pid` (`pid`),
KEY `okayapi_srcms_category_name` (`okayapi_srcms_category_name`),
KEY `title` (`title`),
KEY `keywords` (`keywords`),
KEY `description` (`description`),
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-5 of 5 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| pid | int(11) | 是 | 父分类ID | |||
| okayapi_srcms_category_name | varchar(20) | 是 | 分类别名 | |||
| title | varchar(100) | 是 | 分类标题 | |||
| keywords | varchar(255) | 是 | 分类关键词 | |||
| description | varchar(255) | 是 | 分类描述 |
