MySQL Create Table SQL
Table Structure: okayapi_zd_wiki_page_history：/tablelist/okayapi_zd_wiki_page_history.html
-- MySQL Table okayapi_zd_wiki_page_history
-- From: OkayAPI.com
CREATE TABLE `okayapi_zd_wiki_page_history` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`page_id` bigint(20) NOT NULL COMMENT '页面ID',
`content` mediumtext NOT NULL COMMENT '本次文章内容',
`create_user_id` bigint(20) NOT NULL COMMENT '创建人ID',
`create_user_name` varchar(20) NOT NULL COMMENT '创建人名字',
`del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除标记 0=正常 1=已删除',
KEY `page_id` (`page_id`),
KEY `content` (`content`),
KEY `create_user_id` (`create_user_id`),
KEY `create_user_name` (`create_user_name`),
KEY `del_flag` (`del_flag`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'WIKI-WIKI修改纪录';
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 |
|---|---|---|---|---|---|---|
| page_id | bigint(20) | 是 | 页面ID | Normal Index | ||
| content | mediumtext | 是 | 本次文章内容 | |||
| create_user_id | bigint(20) | 是 | 创建人ID | |||
| create_user_name | varchar(20) | 是 | 创建人名字 | |||
| del_flag | tinyint(4) | 0 | 否 | 删除标记 0=正常 1=已删除 | 0 |
