MySQL Create Table SQL
Table Structure: okayapi_srcms_notes：/tablelist/okayapi_srcms_notes.html
-- MySQL Table okayapi_srcms_notes
-- From: OkayAPI.com
CREATE TABLE `okayapi_srcms_notes` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL COMMENT '特殊页面标题',
`content` varchar(255) NOT NULL COMMENT '特殊页面内容',
`author` varchar(255) NOT NULL COMMENT '页面作者',
`okayapi_srcms_notes_time` varchar(255) NOT NULL COMMENT '页面创建时间',
`okayapi_srcms_notes_name` varchar(255) NOT NULL COMMENT '页面别名',
KEY `title` (`title`),
KEY `content` (`content`),
KEY `author` (`author`),
KEY `okayapi_srcms_notes_time` (`okayapi_srcms_notes_time`),
KEY `okayapi_srcms_notes_name` (`okayapi_srcms_notes_name`),
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 |
|---|---|---|---|---|---|---|
| title | varchar(255) | 否 | 特殊页面标题 | |||
| content | varchar(255) | 否 | 特殊页面内容 | |||
| author | varchar(255) | 否 | 页面作者 | |||
| okayapi_srcms_notes_time | varchar(255) | 否 | 页面创建时间 | |||
| okayapi_srcms_notes_name | varchar(255) | 否 | 页面别名 |
