MySQL Create Table SQL
Table Structure: okayapi_dberp_operlog：/tablelist/okayapi_dberp_operlog.html
-- MySQL Table okayapi_dberp_operlog
-- From: OkayAPI.com
CREATE TABLE `okayapi_dberp_operlog` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`log_oper_user` varchar(100) NULL COMMENT '',
`log_oper_user_group` varchar(100) NULL COMMENT '',
`log_time` int(10) NULL COMMENT '',
`log_ip` varchar(50) NULL COMMENT '',
`log_body` varchar(2000) NULL COMMENT '',
KEY `log_oper_user` (`log_oper_user`),
KEY `log_oper_user_group` (`log_oper_user_group`),
KEY `log_time` (`log_time`),
KEY `log_ip` (`log_ip`),
KEY `log_body` (`log_body`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'DBErp进销存-操作记录';
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 |
|---|---|---|---|---|---|---|
| log_oper_user | varchar(100) | 否 | ||||
| log_oper_user_group | varchar(100) | 否 | ||||
| log_time | int(10) | 否 | ||||
| log_ip | varchar(50) | 否 | ||||
| log_body | varchar(2000) | 是 |
