MySQL Create Table SQL
Table Structure: okayapi_srcms_blog：/tablelist/okayapi_srcms_blog.html
-- MySQL Table okayapi_srcms_blog
-- From: OkayAPI.com
CREATE TABLE `okayapi_srcms_blog` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL DEFAULT '暂无' COMMENT '博客标题',
`okayapi_srcms_blog_name` varchar(100) NOT NULL DEFAULT '默认分类' COMMENT '博客分类',
`content` text NOT NULL COMMENT '博客内容',
KEY `title` (`title`),
KEY `okayapi_srcms_blog_name` (`okayapi_srcms_blog_name`),
KEY `content` (`content`),
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-3 of 3 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| title | varchar(100) | 暂无 | 否 | 博客标题 | 暂无 | |
| okayapi_srcms_blog_name | varchar(100) | 默认分类 | 否 | 博客分类 | 默认分类 | |
| content | text | 否 | 博客内容 |
