系統日志表跨庫問題 · JeecgBoot 開發文檔

>[warning] 如果微服務模塊配置了獨立數據源，那么每個服務對應的數據庫也必須有`sys_log`這張表。腳本SQL ``` DROP TABLE IF EXISTS `sys_log`; CREATE TABLE `sys_log` ( `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `log_type` int(2) NULL DEFAULT NULL COMMENT '日志類型（1登錄日志，2操作日志）', `log_content` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志內容', `operate_type` int(2) NULL DEFAULT NULL COMMENT '操作類型', `userid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作用戶賬號', `username` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作用戶名稱', `ip` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'IP', `method` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '請求java方法', `request_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '請求路徑', `request_param` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '請求參數', `request_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '請求類型', `cost_time` bigint(20) NULL DEFAULT NULL COMMENT '耗時', `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '創建人', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '創建時間', `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新時間', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_sl_userid`(`userid`) USING BTREE, INDEX `idx_sl_log_type`(`log_type`) USING BTREE, INDEX `idx_sl_operate_type`(`operate_type`) USING BTREE, INDEX `idx_sl_create_time`(`create_time`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系統日志表' ROW_FORMAT = Dynamic; ```