MySQL Create Table SQL
Table Structure: okayapi_cloud_oper_log:/tablelist/okayapi_cloud_oper_log.html
-- MySQL Table okayapi_cloud_oper_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_cloud_oper_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`okayapi_cloud_oper_log_time` varchar(32) NULL COMMENT '操作时间',
`okayapi_cloud_oper_log_user` varchar(32) NULL COMMENT '操作用户',
`messages` text NULL COMMENT '操作信息',
`cluster` varchar(200) NULL COMMENT '在哪个集群操作的',
`ip` varchar(32) NULL COMMENT '操作IP地址',
KEY `okayapi_cloud_oper_log_time` (`okayapi_cloud_oper_log_time`),
KEY `okayapi_cloud_oper_log_user` (`okayapi_cloud_oper_log_user`),
KEY `messages` (`messages`),
KEY `cluster` (`cluster`),
KEY `ip` (`ip`),
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-5 of 5 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
okayapi_cloud_oper_log_time | varchar(32) | 是 | 操作时间 | |||
okayapi_cloud_oper_log_user | varchar(32) | 是 | 操作用户 | |||
messages | text | 是 | 操作信息 | |||
cluster | varchar(200) | 是 | 在哪个集群操作的 | |||
ip | varchar(32) | 是 | 操作IP地址 |