MySQL Create Table SQL
Table Structure: okayapi_logs：/tablelist/okayapi_logs.html
-- MySQL Table okayapi_logs
-- From: OkayAPI.com
CREATE TABLE `okayapi_logs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`logs_id` int(10) NULL COMMENT '日志编号',
`logs_operator` varchar(50) NULL COMMENT '操作者的账号id',
`logs_ip` varchar(100) NULL COMMENT '操作人的ip地址',
`logs_time` datetime NULL DEFAULT '2100-01-01 00:00:00' COMMENT '操作的时间',
`logs_desc` varchar(2048) NULL COMMENT '操作的描述',
KEY `logs_id` (`logs_id`),
KEY `logs_operator` (`logs_operator`),
KEY `logs_ip` (`logs_ip`),
KEY `logs_time` (`logs_time`),
KEY `logs_desc` (`logs_desc`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '日志';
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 |
|---|---|---|---|---|---|---|
| logs_id | int(10) | 是 | 日志编号 | |||
| logs_operator | varchar(50) | 是 | 操作者的账号id | |||
| logs_ip | varchar(100) | 是 | 操作人的ip地址 | |||
| logs_time | datetime | 2100-01-01 00:00:00 | 是 | 操作的时间 | 2100-01-01 00:00:00 | |
| logs_desc | varchar(2048) | 是 | 操作的描述 |
