MySQL Create Table SQL
Table Structure: okayapi_log_show_history:/tablelist/okayapi_log_show_history.html
-- MySQL Table okayapi_log_show_history
-- From: OkayAPI.com
CREATE TABLE `okayapi_log_show_history` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`appname` varchar(232) NULL COMMENT '',
`env` varchar(32) NULL COMMENT '',
`hostname` varchar(232) NULL COMMENT '',
`ip` varchar(32) NULL COMMENT '',
`create_time` varchar(32) NULL COMMENT '',
`create_user` varchar(32) NULL COMMENT '',
`okayapi_log_show_history_query` text NULL COMMENT '',
KEY `appname` (`appname`),
KEY `env` (`env`),
KEY `hostname` (`hostname`),
KEY `ip` (`ip`),
KEY `create_time` (`create_time`),
KEY `create_user` (`create_user`),
KEY `okayapi_log_show_history_query` (`okayapi_log_show_history_query`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'k8s管理-显示历史';
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 |
---|---|---|---|---|---|---|
appname | varchar(232) | 是 | ||||
env | varchar(32) | 是 | ||||
hostname | varchar(232) | 是 | ||||
ip | varchar(32) | 是 | ||||
create_time | varchar(32) | 是 | ||||
create_user | varchar(32) | 是 | ||||
okayapi_log_show_history_query | text | 是 |