MySQL Create Table SQL
Table Structure: okayapi_feature：/tablelist/okayapi_feature.html
-- MySQL Table okayapi_feature
-- From: OkayAPI.com
CREATE TABLE `okayapi_feature` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(200) NOT NULL COMMENT '专题标题',
`description` varchar(255) NOT NULL COMMENT '专题描述',
`icon` varchar(255) NOT NULL COMMENT '专题图标',
`topic_count` int(11) NOT NULL DEFAULT '0' COMMENT '话题计数',
`css` text NOT NULL COMMENT '自定义CSS',
`seo_title` varchar(255) NOT NULL COMMENT 'SEO标题',
`enabled` tinyint(1) NOT NULL DEFAULT '0' COMMENT '开关，1天0关',
KEY `title` (`title`),
KEY `description` (`description`),
KEY `icon` (`icon`),
KEY `topic_count` (`topic_count`),
KEY `css` (`css`),
KEY `seo_title` (`seo_title`),
KEY `enabled` (`enabled`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '专题';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-7 of 7 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| title | varchar(200) | 是 | 专题标题 | |||
| description | varchar(255) | 是 | 专题描述 | |||
| icon | varchar(255) | 是 | 专题图标 | |||
| topic_count | int(11) | 0 | 否 | 话题计数 | 0 | |
| css | text | 是 | 自定义CSS | |||
| seo_title | varchar(255) | 是 | SEO标题 | |||
| enabled | tinyint(1) | 0 | 否 | 开关，1天0关 | 0 |
