text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : ck
  Source Server Version : 50720
  Source Host           : localhost:3306
  Source Database       : usthe
  
  Target Server Type    : MYSQL
  Target Server Version : 50720
  File Encoding         : 65001
  
  Date: 2019-06-19 16:51:21
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for sys_operation_log
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_operation_log`;
  CREATE TABLE `sys_operation_log` (
    `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户操作日志主键',
    `LOG_NAME` varchar(255) DEFAULT NULL COMMENT '日志名称',
    `USER_ID` varchar(30) DEFAULT NULL COMMENT '用户id',
    `API` varchar(255) DEFAULT NULL COMMENT 'api名称',
    `METHOD` varchar(255) DEFAULT NULL COMMENT '方法名称',
    `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
    `SUCCEED` tinyint(4) DEFAULT NULL COMMENT '是否执行成功(0失败1成功)',
    `MESSAGE` varchar(255) DEFAULT NULL COMMENT '具体消息备注',
    PRIMARY KEY (`ID`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='操作日志';
  
  -- ----------------------------
  -- Records of sys_operation_log
  -- ----------------------------
  INSERT INTO `sys_operation_log` VALUES ('17', '业务操作日志', 'tom', '/resource/menus', 'GET', '2018-04-22 16:05:05', '1', null);
  INSERT INTO `sys_operation_log` VALUES ('18', '业务操作日志', 'tom', '/resource/menus', 'GET', '2018-04-22 16:05:09', '1', null);
  INSERT INTO `sys_operation_log` VALUES ('19', '业务操作日志', 'tom', '/resource/api/-1/1/10', 'GET', '2018-04-22 16:08:15', '1', null);
  