CREATE TABLE `app_log_growth_trend` (
`id` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`app` varchar(255) NOT NULL,
`env` varchar(50) NOT NULL,
`level` varchar(10) NOT NULL,
`statistic_time` datetime NOT NULL,
`log_count` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `app_log_total_growth_trend` (
`id` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`statistic_time` datetime NOT NULL,
`log_count` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `app_log_level_statistic` (
`id` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`app` varchar(255) NOT NULL,
`env` varchar(50) NOT NULL,
`level` varchar(10) NOT NULL,
`statistic_time` datetime NOT NULL,
`log_count` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `app_env_instance` (
`id` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`app` varchar(255) NOT NULL,
`env` varchar(50) NOT NULL,
`ip` varchar(50) NOT NULL,
`port` varchar(5) NOT NULL,
`hostname` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `app_log_statistic` (
`id` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`app_log_statistic_counter_id` bigint(20) NOT NULL,
`app` varchar(255) NOT NULL,
`env` varchar(50) NOT NULL,
`statistic_time` datetime NOT NULL,
`log_count` bigint(20) NOT NULL DEFAULT '0',
`slow_request_count` bigint(20) NOT NULL DEFAULT '0',
`error_count` bigint(20) NOT NULL DEFAULT '0',
`warn_count` bigint(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `app_log_statistic_counter` (
`id` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`statistic_time` datetime NOT NULL,
`statistic_status` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `system_config` (
`id` bigint(20) NOT NULL COMMENT '主键',
`create_time` datetime NOT NULL COMMENT '创建时间',
`key_code` varchar(50) NOT NULL COMMENT 'key 编码',
`key_name` varchar(50) DEFAULT NULL COMMENT 'key 名称',
`key_value` varchar(255) NOT NULL COMMENT 'key 值',
`enabled` int(11) NOT NULL DEFAULT '1' COMMENT '是否启用',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO `system_config` (`id`, `create_time`, `key_code`, `key_name`, `key_value`, `enabled`) VALUES (1, '2025-07-19 23:56:06', 'app_log_storage_days', '应用日志存储天数', '3', 1);
CREATE TABLE `users` (
`id` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`account` varchar(100) NOT NULL,
`pwd` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `token_info` (
`id` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`subject` varchar(100) NOT NULL,
`token` varchar(255) NOT NULL,
`expire_time` datetime NOT NULL,
`expire_timestamp` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `license` (
`id` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`content` text NOT NULL,
`remark` text DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `request_monitor_statistic` (
`id` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`statistic_date` int(11) NOT NULL,
`app` varchar(255) NOT NULL,
`env` varchar(50) NOT NULL,
`uri` varchar(255) NOT NULL,
`executeCount` int(11) DEFAULT NULL,
`rtAvg` float DEFAULT NULL,
`rtMax` int(11) DEFAULT NULL,
`rtMin` int(11) DEFAULT NULL,
`slow_count` int(11) DEFAULT 0,
`slow_avg` float DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `request_mapping` (
`id` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`app` varchar(255) NOT NULL,
`env` varchar(50) NOT NULL,
`ip` varchar(50) NOT NULL,
`port` varchar(5) NOT NULL,
`hostname` varchar(255) NOT NULL,
`uri` varchar(255) DEFAULT NULL,
`method` varchar(10) DEFAULT NULL,
`handler_method` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
ALTER TABLE app_env_instance ADD online INT NULL;
ALTER TABLE app_env_instance ADD last_heartbeat DATETIME NULL;
ALTER TABLE request_monitor_statistic ADD req_method varchar(10) NULL;
CREATE TABLE `app_env` (
`id` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`app` varchar(255) NOT NULL,
`env` varchar(50) NOT NULL,
`gene` varchar(20) NOT NULL,
`signature` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `sys_lock` (
`id` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`lock_name` varchar(100) NOT NULL,
`status` INT NOT NULL,
`last_heartbeat` datetime DEFAULT NULL,
`holder` varchar(255) DEFAULT NULL,
`holder_id` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;