okayapi_article_cate - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_article_cate：/tablelist/okayapi_article_cate.html


-- MySQL Table okayapi_article_cate
-- From: OkayAPI.com
CREATE TABLE `okayapi_article_cate` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(50) NOT NULL COMMENT '标题',
    `sort` int(5) NOT NULL DEFAULT '0' COMMENT '排序',
    `level` tinyint(1) NOT NULL DEFAULT '1' COMMENT '级别',
    `pid` int(50) NOT NULL DEFAULT '0' COMMENT '上级id',
    `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
    KEY `title` (`title`),
    KEY `sort` (`sort`),
    KEY `level` (`level`),
    KEY `pid` (`pid`),
    KEY `status` (`status`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '文章分类表';

After replication, you can go to the database to create the database table.