/*
|
Navicat Premium Data Transfer
|
|
Source Server : 223.167.111.168
|
Source Server Type : MySQL
|
Source Server Version : 80011
|
Source Host : 223.167.111.168:10026
|
Source Schema : sxyd
|
|
Target Server Type : MySQL
|
Target Server Version : 80011
|
File Encoding : 65001
|
|
Date: 02/11/2021 10:59:09
|
*/
|
|
SET NAMES utf8mb4;
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
-- ----------------------------
|
-- Table structure for e_article
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_article`;
|
CREATE TABLE `e_article` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`create_time` datetime(0) NULL DEFAULT NULL,
|
`update_time` datetime(0) NULL DEFAULT NULL,
|
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
|
`content2` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
|
`pic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`publish` bit(1) NULL DEFAULT NULL,
|
`remark` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
|
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`top` bit(1) NULL DEFAULT NULL,
|
`create_user_id` bigint(20) NULL DEFAULT NULL,
|
`update_user_id` bigint(20) NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `FKcum2jlycp3v1gcwq6hnwg60fy`(`create_user_id`) USING BTREE,
|
INDEX `FKlnnemu59ye1mel1cgyjeo8d0u`(`update_user_id`) USING BTREE,
|
CONSTRAINT `FKcum2jlycp3v1gcwq6hnwg60fy` FOREIGN KEY (`create_user_id`) REFERENCES `e_upms_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
CONSTRAINT `FKlnnemu59ye1mel1cgyjeo8d0u` FOREIGN KEY (`update_user_id`) REFERENCES `e_upms_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for e_complex
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_complex`;
|
CREATE TABLE `e_complex` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`choice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`code` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
|
`from_dict` bigint(20) NULL DEFAULT NULL,
|
`article_id` bigint(20) NULL DEFAULT NULL,
|
`tree_id` bigint(20) NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `FK39yyua5ls0827vj55avx9ovga`(`article_id`) USING BTREE,
|
INDEX `FK8d3ubsvsnp6ket5342d5ucgjv`(`tree_id`) USING BTREE,
|
CONSTRAINT `FK39yyua5ls0827vj55avx9ovga` FOREIGN KEY (`article_id`) REFERENCES `e_article` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
CONSTRAINT `FK8d3ubsvsnp6ket5342d5ucgjv` FOREIGN KEY (`tree_id`) REFERENCES `e_tree` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for e_complex_article
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_complex_article`;
|
CREATE TABLE `e_complex_article` (
|
`complex_id` bigint(20) NOT NULL,
|
`article_id` bigint(20) NOT NULL,
|
PRIMARY KEY (`complex_id`, `article_id`) USING BTREE,
|
INDEX `FKd1c9k4k90e9s43c65i6b5m863`(`article_id`) USING BTREE,
|
CONSTRAINT `FKd1c9k4k90e9s43c65i6b5m863` FOREIGN KEY (`article_id`) REFERENCES `e_article` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
CONSTRAINT `FKtnabfvmqdwk4gui1uhodmwcdp` FOREIGN KEY (`complex_id`) REFERENCES `e_complex` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for e_complex_tab
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_complex_tab`;
|
CREATE TABLE `e_complex_tab` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`input` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`number` float NULL DEFAULT NULL,
|
`complex_id` bigint(20) NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `FKc9nkxvn8i9lgq7didhl8x2ejw`(`complex_id`) USING BTREE,
|
CONSTRAINT `FKc9nkxvn8i9lgq7didhl8x2ejw` FOREIGN KEY (`complex_id`) REFERENCES `e_complex` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for e_component
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_component`;
|
CREATE TABLE `e_component` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`auto_complete` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`bool` bit(1) NULL DEFAULT NULL,
|
`color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`date1` datetime(0) NULL DEFAULT NULL,
|
`date_time` datetime(0) NULL DEFAULT NULL,
|
`feature` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`history` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`input` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`month` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`number1` double NULL DEFAULT NULL,
|
`slider` int(11) NULL DEFAULT NULL,
|
`tags` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`week` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`week_input` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`year` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`article_id` bigint(20) NULL DEFAULT NULL,
|
`tree_id` bigint(20) NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `FK1d4nrqmv9or0xk0g2ink7wkh9`(`article_id`) USING BTREE,
|
INDEX `FKo5kd3b6n4349j7b4wuij4sepu`(`tree_id`) USING BTREE,
|
CONSTRAINT `FK1d4nrqmv9or0xk0g2ink7wkh9` FOREIGN KEY (`article_id`) REFERENCES `e_article` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
CONSTRAINT `FKo5kd3b6n4349j7b4wuij4sepu` FOREIGN KEY (`tree_id`) REFERENCES `e_tree` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for e_dict
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_dict`;
|
CREATE TABLE `e_dict` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`create_time` datetime(0) NULL DEFAULT NULL,
|
`update_time` datetime(0) NULL DEFAULT NULL,
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`create_user_id` bigint(20) NULL DEFAULT NULL,
|
`update_user_id` bigint(20) NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE INDEX `UKf5wwh5osfukkeebw7h2yb4kmp`(`code`) USING BTREE,
|
INDEX `FKi8lurtplfsktg01y6uevop5yp`(`create_user_id`) USING BTREE,
|
INDEX `FKhxpr89ae0g4rd9xpfgcdjf0sa`(`update_user_id`) USING BTREE,
|
CONSTRAINT `FKhxpr89ae0g4rd9xpfgcdjf0sa` FOREIGN KEY (`update_user_id`) REFERENCES `e_upms_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
CONSTRAINT `FKi8lurtplfsktg01y6uevop5yp` FOREIGN KEY (`create_user_id`) REFERENCES `e_upms_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for e_dict_item
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_dict_item`;
|
CREATE TABLE `e_dict_item` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`create_time` datetime(0) NULL DEFAULT NULL,
|
`update_time` datetime(0) NULL DEFAULT NULL,
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`sort` int(11) NULL DEFAULT NULL,
|
`create_user_id` bigint(20) NULL DEFAULT NULL,
|
`update_user_id` bigint(20) NULL DEFAULT NULL,
|
`erupt_dict_id` bigint(20) NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE INDEX `UKl0kiq8otpn3fvtlvarebt8xkh`(`code`, `erupt_dict_id`) USING BTREE,
|
INDEX `FKij9x8hwy16dra7d49h483lu2u`(`create_user_id`) USING BTREE,
|
INDEX `FKmlg0pjfxwih4i6r0g0iilh1lu`(`update_user_id`) USING BTREE,
|
INDEX `FKrrbi2dt94rjd8sjt830m3w0a`(`erupt_dict_id`) USING BTREE,
|
CONSTRAINT `FKij9x8hwy16dra7d49h483lu2u` FOREIGN KEY (`create_user_id`) REFERENCES `e_upms_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
CONSTRAINT `FKmlg0pjfxwih4i6r0g0iilh1lu` FOREIGN KEY (`update_user_id`) REFERENCES `e_upms_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
CONSTRAINT `FKrrbi2dt94rjd8sjt830m3w0a` FOREIGN KEY (`erupt_dict_id`) REFERENCES `e_dict` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for e_generator_class
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_generator_class`;
|
CREATE TABLE `e_generator_class` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`create_time` datetime(0) NULL DEFAULT NULL,
|
`update_time` datetime(0) NULL DEFAULT NULL,
|
`class_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`remark` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`table_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`create_user_id` bigint(20) NULL DEFAULT NULL,
|
`update_user_id` bigint(20) NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `FKbnmtsmoprxey1uh6hwa7kl15b`(`create_user_id`) USING BTREE,
|
INDEX `FKl47n6nt0w2ulphuhmwht6jdlw`(`update_user_id`) USING BTREE,
|
CONSTRAINT `FKbnmtsmoprxey1uh6hwa7kl15b` FOREIGN KEY (`create_user_id`) REFERENCES `e_upms_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
CONSTRAINT `FKl47n6nt0w2ulphuhmwht6jdlw` FOREIGN KEY (`update_user_id`) REFERENCES `e_upms_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of e_generator_class
|
-- ----------------------------
|
INSERT INTO `e_generator_class` VALUES (1, '2021-11-01 16:44:48', '2021-11-01 17:07:42', 'TaxiRealtimedata', '车载指标', '车载指标', 'taxi_realtimedata', 1, 1);
|
|
-- ----------------------------
|
-- Table structure for e_generator_field
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_generator_field`;
|
CREATE TABLE `e_generator_field` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`field_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`is_show` bit(1) NULL DEFAULT NULL,
|
`link_class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`not_null` bit(1) NULL DEFAULT NULL,
|
`query` bit(1) NULL DEFAULT NULL,
|
`show_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`sort` int(11) NULL DEFAULT NULL,
|
`sortable` bit(1) NULL DEFAULT NULL,
|
`type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`class_id` bigint(20) NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `FKslwo9qwwfbgif9mbbhg072s4i`(`class_id`) USING BTREE,
|
CONSTRAINT `FKslwo9qwwfbgif9mbbhg072s4i` FOREIGN KEY (`class_id`) REFERENCES `e_generator_class` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of e_generator_field
|
-- ----------------------------
|
INSERT INTO `e_generator_field` VALUES (1, 'PostTime', b'1', NULL, b'1', b'1', 'PostTime', 1, b'1', 'DATE_TIME', 1);
|
INSERT INTO `e_generator_field` VALUES (2, 'MN', b'1', NULL, b'1', b'1', 'MN', 2, b'1', 'INPUT', 1);
|
INSERT INTO `e_generator_field` VALUES (3, 'LON', b'0', NULL, b'0', b'0', '经度', 35, b'1', 'NUMBER', 1);
|
INSERT INTO `e_generator_field` VALUES (4, 'LAT', b'0', NULL, b'0', b'0', '纬度', 36, b'1', 'NUMBER', 1);
|
INSERT INTO `e_generator_field` VALUES (5, 'SPEED', b'0', NULL, b'0', b'0', '速度', 34, b'1', 'NUMBER', 1);
|
INSERT INTO `e_generator_field` VALUES (6, 'PM25', b'1', NULL, b'1', b'1', 'PM25', 3, b'1', 'NUMBER', 1);
|
INSERT INTO `e_generator_field` VALUES (7, 'PM10', b'1', NULL, b'1', b'1', 'PM10', 5, b'1', 'NUMBER', 1);
|
INSERT INTO `e_generator_field` VALUES (8, 'NO2', b'1', NULL, b'1', b'1', 'NO2', 6, b'1', 'NUMBER', 1);
|
INSERT INTO `e_generator_field` VALUES (9, 'O3', b'1', NULL, b'1', b'1', 'O3', 8, b'1', 'NUMBER', 1);
|
INSERT INTO `e_generator_field` VALUES (10, 'TSP', b'1', NULL, b'1', b'1', 'TSP', 9, b'1', 'NUMBER', 1);
|
INSERT INTO `e_generator_field` VALUES (11, 'NO', b'1', NULL, b'1', b'1', 'NO', 10, b'1', 'NUMBER', 1);
|
INSERT INTO `e_generator_field` VALUES (12, 'NOX', b'1', NULL, b'1', b'1', 'NOX', 12, b'1', 'NUMBER', 1);
|
INSERT INTO `e_generator_field` VALUES (13, 'CO', b'1', NULL, b'1', b'1', 'CO', 13, b'1', 'NUMBER', 1);
|
INSERT INTO `e_generator_field` VALUES (14, 'TVOC', b'1', NULL, b'1', b'1', 'TVOC', 14, b'1', 'NUMBER', 1);
|
INSERT INTO `e_generator_field` VALUES (15, 'NO2_ACT', b'0', NULL, b'0', b'1', 'NO2_ACT', 15, b'1', 'NUMBER', 1);
|
INSERT INTO `e_generator_field` VALUES (16, 'NO2Flag', b'1', NULL, b'1', b'1', 'NO2Flag', 7, b'1', 'INPUT', 1);
|
INSERT INTO `e_generator_field` VALUES (17, 'NOFlag', b'1', NULL, b'1', b'1', 'NOFlag', 11, b'1', 'INPUT', 1);
|
INSERT INTO `e_generator_field` VALUES (18, 'COFlag', b'1', NULL, b'1', b'1', 'COFlag', 14, b'1', 'INPUT', 1);
|
INSERT INTO `e_generator_field` VALUES (19, 'DustFlag', b'1', NULL, b'1', b'1', 'DustFlag', 4, b'1', 'INPUT', 1);
|
INSERT INTO `e_generator_field` VALUES (20, 'NO2_REF', b'1', NULL, b'1', b'0', 'NO2_REF', 16, b'1', 'NUMBER', 1);
|
INSERT INTO `e_generator_field` VALUES (21, 'NO_ACT', b'0', NULL, b'0', b'0', 'NO_ACT', 17, b'1', 'NUMBER', 1);
|
INSERT INTO `e_generator_field` VALUES (22, 'NO_REF', b'0', NULL, b'0', b'0', 'NO_REF', 18, b'1', 'NUMBER', 1);
|
INSERT INTO `e_generator_field` VALUES (23, 'CO_ACT', b'0', NULL, b'0', b'0', 'CO_ACT', 19, b'1', 'NUMBER', 1);
|
INSERT INTO `e_generator_field` VALUES (24, 'CO_REF', b'0', NULL, b'0', b'0', 'CO_REF', 20, b'1', 'NUMBER', 1);
|
INSERT INTO `e_generator_field` VALUES (25, 'LON_BAIDU', b'0', NULL, b'0', b'0', '百度经度', 37, b'1', 'NUMBER', 1);
|
INSERT INTO `e_generator_field` VALUES (26, 'LAT_BAIDU', b'0', NULL, b'0', b'0', '百度纬度', 38, b'1', 'NUMBER', 1);
|
|
-- ----------------------------
|
-- Table structure for e_job
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_job`;
|
CREATE TABLE `e_job` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`create_time` datetime(0) NULL DEFAULT NULL,
|
`update_time` datetime(0) NULL DEFAULT NULL,
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`cron` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`handler_param` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`notify_emails` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`remark` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`status` bit(1) NULL DEFAULT NULL,
|
`create_user_id` bigint(20) NULL DEFAULT NULL,
|
`update_user_id` bigint(20) NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE INDEX `UK1fu1amroa8n5mma3q9tey7bu9`(`code`) USING BTREE,
|
INDEX `FKnxi59dgiyw7h3u65x8ywb8muh`(`create_user_id`) USING BTREE,
|
INDEX `FKex9ag5th9lcfd5npbykqvsy4h`(`update_user_id`) USING BTREE,
|
CONSTRAINT `FKex9ag5th9lcfd5npbykqvsy4h` FOREIGN KEY (`update_user_id`) REFERENCES `e_upms_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
CONSTRAINT `FKnxi59dgiyw7h3u65x8ywb8muh` FOREIGN KEY (`create_user_id`) REFERENCES `e_upms_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for e_job_log
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_job_log`;
|
CREATE TABLE `e_job_log` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`end_time` datetime(0) NULL DEFAULT NULL,
|
`error_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
|
`handler_param` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`result_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
|
`start_time` datetime(0) NULL DEFAULT NULL,
|
`status` bit(1) NULL DEFAULT NULL,
|
`job_id` bigint(20) NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `FKcpe22rpge2e4mmuva8l9dtmx0`(`job_id`) USING BTREE,
|
CONSTRAINT `FKcpe22rpge2e4mmuva8l9dtmx0` FOREIGN KEY (`job_id`) REFERENCES `e_job` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for e_job_mail
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_job_mail`;
|
CREATE TABLE `e_job_mail` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`create_time` datetime(0) NULL DEFAULT NULL,
|
`update_time` datetime(0) NULL DEFAULT NULL,
|
`cc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
|
`recipient` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`create_user_id` bigint(20) NULL DEFAULT NULL,
|
`update_user_id` bigint(20) NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `FK4s3qcpi4yo5jfvkoqbcu9r9s4`(`create_user_id`) USING BTREE,
|
INDEX `FKir84uifi8bw52ucl5i1uxm1v6`(`update_user_id`) USING BTREE,
|
CONSTRAINT `FK4s3qcpi4yo5jfvkoqbcu9r9s4` FOREIGN KEY (`create_user_id`) REFERENCES `e_upms_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
CONSTRAINT `FKir84uifi8bw52ucl5i1uxm1v6` FOREIGN KEY (`update_user_id`) REFERENCES `e_upms_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for e_tree
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_tree`;
|
CREATE TABLE `e_tree` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`sort` int(11) NULL DEFAULT NULL,
|
`parent_id` bigint(20) NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `FK5gnxkk1as7r9mm9h53hlx43ei`(`parent_id`) USING BTREE,
|
CONSTRAINT `FK5gnxkk1as7r9mm9h53hlx43ei` FOREIGN KEY (`parent_id`) REFERENCES `e_tree` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for e_upms_login_log
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_upms_login_log`;
|
CREATE TABLE `e_upms_login_log` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`browser` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`device_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`login_time` datetime(0) NULL DEFAULT NULL,
|
`region` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`system_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`erupt_user_id` bigint(20) NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `FKjqnr9oel32kajm6bpvqwomv6m`(`erupt_user_id`) USING BTREE,
|
CONSTRAINT `FKjqnr9oel32kajm6bpvqwomv6m` FOREIGN KEY (`erupt_user_id`) REFERENCES `e_upms_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of e_upms_login_log
|
-- ----------------------------
|
INSERT INTO `e_upms_login_log` VALUES (1, 'Chrome 9 94', 'Computer', '192.168.10.1', '2021-11-01 12:39:55', '0|0|0|内网IP|内网IP', 'Windows 8', '8f7PKdcwigzataDi', 1);
|
INSERT INTO `e_upms_login_log` VALUES (2, 'Chrome 9 94', 'Computer', '192.168.10.1', '2021-11-01 13:15:14', '0|0|0|内网IP|内网IP', 'Windows 8', 'X1jQaOFHjfAVpyHt', 1);
|
INSERT INTO `e_upms_login_log` VALUES (3, 'Chrome 9 94', 'Computer', '192.168.10.1', '2021-11-01 13:15:36', '0|0|0|内网IP|内网IP', 'Windows 8', '2ny5yutnRruYtzI3', 1);
|
INSERT INTO `e_upms_login_log` VALUES (4, 'Chrome 9 94', 'Computer', '192.168.10.1', '2021-11-01 14:59:58', '0|0|0|内网IP|内网IP', 'Windows 8', 'cChQCpCVT6mYphcE', 1);
|
INSERT INTO `e_upms_login_log` VALUES (5, 'Chrome 9 94', 'Computer', '192.168.10.1', '2021-11-01 16:43:27', '0|0|0|内网IP|内网IP', 'Windows 8', 'XEw1CpB8CbDnAseD', 1);
|
INSERT INTO `e_upms_login_log` VALUES (6, 'Chrome 9 94', 'Computer', '192.168.10.1', '2021-11-01 22:47:18', '0|0|0|内网IP|内网IP', 'Windows 8', 'QkD07x5BTkU6799L', 1);
|
INSERT INTO `e_upms_login_log` VALUES (7, 'Chrome 9 94', 'Computer', '192.168.10.1', '2021-11-01 22:54:26', '0|0|0|内网IP|内网IP', 'Windows 8', 'CiB9s3Qzpsk3XqkH', 1);
|
|
-- ----------------------------
|
-- Table structure for e_upms_menu
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_upms_menu`;
|
CREATE TABLE `e_upms_menu` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`create_time` datetime(0) NULL DEFAULT NULL,
|
`update_time` datetime(0) NULL DEFAULT NULL,
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`param` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`power_off` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`sort` int(11) NULL DEFAULT NULL,
|
`status` int(11) NULL DEFAULT NULL,
|
`type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`create_user_id` bigint(20) NULL DEFAULT NULL,
|
`update_user_id` bigint(20) NULL DEFAULT NULL,
|
`parent_menu_id` bigint(20) NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE INDEX `UK95xpkppt33d2bka0g2d7rgwqt`(`code`) USING BTREE,
|
INDEX `FK4p5siq6l1rf9y47bosayghcsv`(`create_user_id`) USING BTREE,
|
INDEX `FKtm66wffkyyluinneyva8kd2bc`(`update_user_id`) USING BTREE,
|
INDEX `FK5mkgea183mm02v7ic1pdwxy5s`(`parent_menu_id`) USING BTREE,
|
CONSTRAINT `FK4p5siq6l1rf9y47bosayghcsv` FOREIGN KEY (`create_user_id`) REFERENCES `e_upms_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
CONSTRAINT `FK5mkgea183mm02v7ic1pdwxy5s` FOREIGN KEY (`parent_menu_id`) REFERENCES `e_upms_menu` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
CONSTRAINT `FKtm66wffkyyluinneyva8kd2bc` FOREIGN KEY (`update_user_id`) REFERENCES `e_upms_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of e_upms_menu
|
-- ----------------------------
|
INSERT INTO `e_upms_menu` VALUES (1, NULL, NULL, '$generator', 'fa fa-code', '代码生成', NULL, NULL, 40, 1, NULL, NULL, NULL, NULL, NULL);
|
INSERT INTO `e_upms_menu` VALUES (2, NULL, NULL, 'GeneratorClass', NULL, '生成Erupt代码', NULL, NULL, 0, 1, 'table', 'GeneratorClass', NULL, NULL, 1);
|
INSERT INTO `e_upms_menu` VALUES (3, NULL, NULL, '$job', 'fa fa-cubes', '任务管理', NULL, NULL, 30, 1, NULL, NULL, NULL, NULL, NULL);
|
INSERT INTO `e_upms_menu` VALUES (4, NULL, NULL, 'EruptJob', 'fa fa-tasks', '任务维护', NULL, NULL, 0, 1, 'table', 'EruptJob', NULL, NULL, 3);
|
INSERT INTO `e_upms_menu` VALUES (5, NULL, NULL, 'EruptJobLog', 'fa fa-file-text', '任务日志', NULL, NULL, 10, 1, 'table', 'EruptJobLog', NULL, NULL, 3);
|
INSERT INTO `e_upms_menu` VALUES (6, NULL, NULL, 'EruptMail', 'fa fa-envelope-o', '发送邮件', NULL, NULL, 20, 1, 'table', 'EruptMail', NULL, NULL, 3);
|
INSERT INTO `e_upms_menu` VALUES (7, NULL, NULL, 'magic-api', 'fa fa-cube', '接口配置', NULL, NULL, 80, 1, 'tpl', 'magic-api.ftl', NULL, NULL, NULL);
|
INSERT INTO `e_upms_menu` VALUES (8, NULL, NULL, 'magic-api-view', NULL, '查看详情', NULL, NULL, 90, 2, 'button', 'ERUPT_MAGIC_VIEW', NULL, NULL, 7);
|
INSERT INTO `e_upms_menu` VALUES (9, NULL, NULL, 'magic-api-save', NULL, '保存', NULL, NULL, 100, 2, 'button', 'ERUPT_MAGIC_SAVE', NULL, NULL, 7);
|
INSERT INTO `e_upms_menu` VALUES (10, NULL, NULL, 'magic-api-delete', NULL, '删除', NULL, NULL, 110, 2, 'button', 'ERUPT_MAGIC_DELETE', NULL, NULL, 7);
|
INSERT INTO `e_upms_menu` VALUES (11, NULL, NULL, 'magic-api-upload', NULL, '上传', NULL, NULL, 120, 2, 'button', 'ERUPT_MAGIC_UPLOAD', NULL, NULL, 7);
|
INSERT INTO `e_upms_menu` VALUES (12, NULL, NULL, 'magic-api-download', NULL, '导出', NULL, NULL, 130, 2, 'button', 'ERUPT_MAGIC_DOWNLOAD', NULL, NULL, 7);
|
INSERT INTO `e_upms_menu` VALUES (13, NULL, NULL, 'magic-api-datasource_view', NULL, '数据源查看详情', NULL, NULL, 140, 2, 'button', 'ERUPT_MAGIC_DATASOURCE_VIEW', NULL, NULL, 7);
|
INSERT INTO `e_upms_menu` VALUES (14, NULL, NULL, 'magic-api-datasource_save', NULL, '数据源保存', NULL, NULL, 150, 2, 'button', 'ERUPT_MAGIC_DATASOURCE_SAVE', NULL, NULL, 7);
|
INSERT INTO `e_upms_menu` VALUES (15, NULL, NULL, 'magic-api-datasource_delete', NULL, '数据源删除', NULL, NULL, 160, 2, 'button', 'ERUPT_MAGIC_DATASOURCE_DELETE', NULL, NULL, 7);
|
INSERT INTO `e_upms_menu` VALUES (16, NULL, NULL, 'monitor', 'fa fa-bullseye', '系统监控', NULL, NULL, 10, 1, NULL, NULL, NULL, NULL, NULL);
|
INSERT INTO `e_upms_menu` VALUES (17, NULL, NULL, 'server.html', NULL, '服务监控', NULL, NULL, 10, 1, 'tpl', 'server.html', NULL, NULL, 16);
|
INSERT INTO `e_upms_menu` VALUES (18, NULL, NULL, 'redis.html', NULL, '缓存监控', NULL, NULL, 20, 1, 'tpl', 'redis.html', NULL, NULL, 16);
|
INSERT INTO `e_upms_menu` VALUES (19, NULL, NULL, 'EruptOnline', NULL, '在线用户', NULL, NULL, 30, 1, 'table', 'EruptOnline', NULL, NULL, 16);
|
INSERT INTO `e_upms_menu` VALUES (20, NULL, NULL, '$manager', 'fa fa-cogs', '系统管理', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL, NULL);
|
INSERT INTO `e_upms_menu` VALUES (21, NULL, NULL, 'EruptMenu', 'fa fa-list-ul', '菜单维护', NULL, NULL, 10, 1, 'tree', 'EruptMenu', NULL, NULL, 20);
|
INSERT INTO `e_upms_menu` VALUES (22, NULL, NULL, 'EruptRole', NULL, '角色维护', NULL, NULL, 20, 1, 'table', 'EruptRole', NULL, NULL, 20);
|
INSERT INTO `e_upms_menu` VALUES (23, NULL, NULL, 'EruptOrg', 'fa fa-users', '组织维护', NULL, NULL, 30, 1, 'tree', 'EruptOrg', NULL, NULL, 20);
|
INSERT INTO `e_upms_menu` VALUES (24, NULL, NULL, 'EruptPost', 'fa fa-id-card', '岗位维护', NULL, NULL, 35, 1, 'table', 'EruptPost', NULL, NULL, 20);
|
INSERT INTO `e_upms_menu` VALUES (25, NULL, NULL, 'EruptUser', 'fa fa-user', '用户维护', NULL, NULL, 40, 1, 'table', 'EruptUser', NULL, NULL, 20);
|
INSERT INTO `e_upms_menu` VALUES (26, NULL, NULL, 'EruptDict', NULL, '字典维护', NULL, NULL, 50, 1, 'table', 'EruptDict', NULL, NULL, 20);
|
INSERT INTO `e_upms_menu` VALUES (27, NULL, NULL, 'EruptDictItem', NULL, '字典项', NULL, NULL, 10, 2, 'table', 'EruptDictItem', NULL, NULL, 26);
|
INSERT INTO `e_upms_menu` VALUES (28, NULL, NULL, 'EruptLoginLog', NULL, '登录日志', NULL, NULL, 60, 1, 'table', 'EruptLoginLog', NULL, NULL, 20);
|
INSERT INTO `e_upms_menu` VALUES (29, NULL, NULL, 'EruptOperateLog', NULL, '操作日志', NULL, NULL, 70, 1, 'table', 'EruptOperateLog', NULL, NULL, 20);
|
INSERT INTO `e_upms_menu` VALUES (30, '2021-11-01 22:51:52', '2021-11-01 22:53:47', 'sxyd_dtcheck', 'fa fa-list', '数据核查', NULL, NULL, 10, 1, NULL, NULL, 1, 1, NULL);
|
INSERT INTO `e_upms_menu` VALUES (31, '2021-11-01 22:53:13', NULL, 'taxidt_check', 'fa fa-taxi', 'taxi指标', NULL, NULL, 10, 1, 'table', 'TaxiRealtimedata', 1, NULL, 30);
|
|
-- ----------------------------
|
-- Table structure for e_upms_operate_log
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_upms_operate_log`;
|
CREATE TABLE `e_upms_operate_log` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`api_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`create_time` datetime(0) NULL DEFAULT NULL,
|
`error_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
|
`ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`region` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`req_addr` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`req_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`req_param` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
|
`status` bit(1) NULL DEFAULT NULL,
|
`total_time` int(11) NULL DEFAULT NULL,
|
`erupt_user_id` bigint(20) NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `FK27xepkxthq9snq3yk6k7iad33`(`erupt_user_id`) USING BTREE,
|
CONSTRAINT `FK27xepkxthq9snq3yk6k7iad33` FOREIGN KEY (`erupt_user_id`) REFERENCES `e_upms_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of e_upms_operate_log
|
-- ----------------------------
|
INSERT INTO `e_upms_operate_log` VALUES (1, '新增 | 生成Erupt代码', '2021-11-01 16:44:48', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/GeneratorClass', 'POST', '{\"name\":\"车载指标\",\"className\":\"TaxiRealtimedata\",\"tableName\":\"taxi_realtimedata\",\"remark\":\"车载指标\",\"fields\":[]}', b'1', 1904, 1);
|
INSERT INTO `e_upms_operate_log` VALUES (2, '修改 | 生成Erupt代码', '2021-11-01 17:07:42', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/GeneratorClass', 'PUT', '{\"name\":\"车载指标\",\"className\":\"TaxiRealtimedata\",\"tableName\":\"taxi_realtimedata\",\"remark\":\"车载指标\",\"fields\":[{\"fieldName\":\"PostTime\",\"showName\":\"PostTime\",\"sort\":1,\"type\":\"DATE_TIME\",\"query\":true,\"sortable\":true,\"notNull\":true,\"isShow\":true,\"id\":-78},{\"fieldName\":\"MN\",\"showName\":\"MN\",\"sort\":2,\"type\":\"INPUT\",\"query\":true,\"sortable\":true,\"notNull\":true,\"isShow\":true,\"id\":-607},{\"fieldName\":\"LON\",\"showName\":\"经度\",\"sort\":35,\"type\":\"NUMBER\",\"query\":false,\"sortable\":true,\"notNull\":false,\"isShow\":false,\"id\":-453},{\"fieldName\":\"LAT\",\"showName\":\"纬度\",\"sort\":36,\"type\":\"NUMBER\",\"query\":false,\"sortable\":true,\"notNull\":false,\"isShow\":false,\"id\":-5},{\"fieldName\":\"SPEED\",\"showName\":\"速度\",\"sort\":34,\"type\":\"NUMBER\",\"query\":false,\"sortable\":true,\"notNull\":false,\"isShow\":false,\"id\":-41},{\"fieldName\":\"PM25\",\"showName\":\"PM25\",\"sort\":3,\"type\":\"NUMBER\",\"query\":true,\"sortable\":true,\"notNull\":true,\"isShow\":true,\"id\":-481},{\"fieldName\":\"PM10\",\"showName\":\"PM10\",\"sort\":5,\"type\":\"NUMBER\",\"query\":true,\"sortable\":true,\"notNull\":true,\"isShow\":true,\"id\":-169},{\"fieldName\":\"NO2\",\"showName\":\"NO2\",\"sort\":6,\"type\":\"NUMBER\",\"query\":true,\"sortable\":true,\"notNull\":true,\"isShow\":true,\"id\":-624},{\"fieldName\":\"O3\",\"showName\":\"O3\",\"sort\":8,\"type\":\"NUMBER\",\"query\":true,\"sortable\":true,\"notNull\":true,\"isShow\":true,\"id\":-85},{\"fieldName\":\"TSP\",\"showName\":\"TSP\",\"sort\":9,\"type\":\"NUMBER\",\"query\":true,\"sortable\":true,\"notNull\":true,\"isShow\":true,\"id\":-189},{\"fieldName\":\"NO\",\"showName\":\"NO\",\"sort\":10,\"type\":\"NUMBER\",\"query\":true,\"sortable\":true,\"notNull\":true,\"isShow\":true,\"id\":-820},{\"fieldName\":\"NOX\",\"showName\":\"NOX\",\"sort\":12,\"type\":\"NUMBER\",\"query\":true,\"sortable\":true,\"notNull\":true,\"isShow\":true,\"id\":-765},{\"fieldName\":\"CO\",\"showName\":\"CO\",\"sort\":13,\"type\":\"NUMBER\",\"query\":true,\"sortable\":true,\"notNull\":true,\"isShow\":true,\"id\":-669},{\"fieldName\":\"TVOC\",\"showName\":\"TVOC\",\"sort\":14,\"type\":\"NUMBER\",\"query\":true,\"sortable\":true,\"notNull\":true,\"isShow\":true,\"id\":-629},{\"fieldName\":\"NO2_ACT\",\"showName\":\"NO2_ACT\",\"sort\":15,\"type\":\"NUMBER\",\"query\":true,\"sortable\":true,\"notNull\":false,\"isShow\":false,\"id\":-977},{\"fieldName\":\"NO2Flag\",\"showName\":\"NO2Flag\",\"sort\":7,\"type\":\"INPUT\",\"query\":true,\"sortable\":true,\"notNull\":true,\"isShow\":true,\"id\":-341},{\"fieldName\":\"NOFlag\",\"showName\":\"NOFlag\",\"sort\":11,\"type\":\"INPUT\",\"query\":true,\"sortable\":true,\"notNull\":true,\"isShow\":true,\"id\":-775},{\"fieldName\":\"COFlag\",\"showName\":\"COFlag\",\"sort\":14,\"type\":\"INPUT\",\"query\":true,\"sortable\":true,\"notNull\":true,\"isShow\":true,\"id\":-27},{\"fieldName\":\"DustFlag\",\"showName\":\"DustFlag\",\"sort\":4,\"type\":\"INPUT\",\"query\":true,\"sortable\":true,\"notNull\":true,\"isShow\":true,\"id\":-278},{\"fieldName\":\"NO2_REF\",\"showName\":\"NO2_REF\",\"sort\":16,\"type\":\"NUMBER\",\"query\":false,\"sortable\":true,\"notNull\":true,\"isShow\":true,\"id\":-817},{\"fieldName\":\"NO_ACT\",\"showName\":\"NO_ACT\",\"sort\":17,\"type\":\"NUMBER\",\"query\":false,\"sortable\":true,\"notNull\":false,\"isShow\":false,\"id\":-904},{\"fieldName\":\"NO_REF\",\"showName\":\"NO_REF\",\"sort\":18,\"type\":\"NUMBER\",\"query\":false,\"sortable\":true,\"notNull\":false,\"isShow\":false,\"id\":-528},{\"fieldName\":\"CO_ACT\",\"showName\":\"CO_ACT\",\"sort\":19,\"type\":\"NUMBER\",\"query\":false,\"sortable\":true,\"notNull\":false,\"isShow\":false,\"id\":-310},{\"fieldName\":\"CO_REF\",\"showName\":\"CO_REF\",\"sort\":20,\"type\":\"NUMBER\",\"query\":false,\"sortable\":true,\"notNull\":false,\"isShow\":false,\"id\":-186},{\"fieldName\":\"LON_BAIDU\",\"showName\":\"百度经度\",\"sort\":37,\"type\":\"NUMBER\",\"query\":false,\"sortable\":true,\"notNull\":false,\"isShow\":false,\"id\":-917},{\"fieldName\":\"LAT_BAIDU\",\"showName\":\"百度纬度\",\"sort\":38,\"type\":\"NUMBER\",\"query\":false,\"sortable\":true,\"notNull\":false,\"isShow\":false,\"id\":-703}],\"id\":1}', b'1', 661, 1);
|
INSERT INTO `e_upms_operate_log` VALUES (3, '新增 | 菜单配置', '2021-11-01 22:51:52', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/EruptMenu', 'POST', '{\"code\":\"sxyd_dtcheck\",\"name\":\"数据核查\",\"status\":\"1\",\"type\":\"table\",\"value\":\"TaxiRealtimedata\",\"sort\":10,\"icon\":\"fa fa-list\"}', b'1', 2179, 1);
|
INSERT INTO `e_upms_operate_log` VALUES (4, '新增 | 菜单配置', '2021-11-01 22:53:13', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/EruptMenu', 'POST', '{\"code\":\"taxidt_check\",\"name\":\"taxi指标\",\"status\":\"1\",\"type\":\"table\",\"value\":\"TaxiRealtimedata\",\"sort\":10,\"icon\":\"fa fa-taxi\",\"parentMenu\":{\"id\":30,\"name\":\"数据核查\"}}', b'1', 195, 1);
|
INSERT INTO `e_upms_operate_log` VALUES (5, '修改 | 菜单配置', '2021-11-01 22:53:48', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/EruptMenu', 'PUT', '{\"code\":\"sxyd_dtcheck\",\"name\":\"数据核查\",\"status\":\"1\",\"sort\":10,\"icon\":\"fa fa-list\",\"id\":30}', b'1', 188, 1);
|
|
-- ----------------------------
|
-- Table structure for e_upms_org
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_upms_org`;
|
CREATE TABLE `e_upms_org` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`sort` int(11) NULL DEFAULT NULL,
|
`parent_org_id` bigint(20) NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `FKtj7222kjnkt7pv9kfn9g8ck4h`(`parent_org_id`) USING BTREE,
|
CONSTRAINT `FKtj7222kjnkt7pv9kfn9g8ck4h` FOREIGN KEY (`parent_org_id`) REFERENCES `e_upms_org` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for e_upms_post
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_upms_post`;
|
CREATE TABLE `e_upms_post` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`weight` int(11) NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE INDEX `UKltq5h3n5cyyk5nxtjhg9lhidg`(`code`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for e_upms_role
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_upms_role`;
|
CREATE TABLE `e_upms_role` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`power_off` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`status` bit(1) NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE INDEX `UKjgxkp7mr4183tcwosrbqpsl3a`(`code`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for e_upms_role_menu
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_upms_role_menu`;
|
CREATE TABLE `e_upms_role_menu` (
|
`role_id` bigint(20) NOT NULL,
|
`menu_id` bigint(20) NOT NULL,
|
PRIMARY KEY (`role_id`, `menu_id`) USING BTREE,
|
INDEX `FKr6bl403chgwjnb6jk0uqqd9x8`(`menu_id`) USING BTREE,
|
CONSTRAINT `FKgsdnakqsme4htxkiapwmf6tbi` FOREIGN KEY (`role_id`) REFERENCES `e_upms_role` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
CONSTRAINT `FKr6bl403chgwjnb6jk0uqqd9x8` FOREIGN KEY (`menu_id`) REFERENCES `e_upms_menu` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for e_upms_user
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_upms_user`;
|
CREATE TABLE `e_upms_user` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`create_time` datetime(0) NULL DEFAULT NULL,
|
`update_time` datetime(0) NULL DEFAULT NULL,
|
`account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`is_admin` bit(1) NULL DEFAULT NULL,
|
`is_md5` bit(1) NULL DEFAULT NULL,
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`remark` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`status` bit(1) NULL DEFAULT NULL,
|
`white_ip` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`create_user_id` bigint(20) NULL DEFAULT NULL,
|
`update_user_id` bigint(20) NULL DEFAULT NULL,
|
`erupt_menu_id` bigint(20) NULL DEFAULT NULL,
|
`erupt_org_id` bigint(20) NULL DEFAULT NULL,
|
`erupt_post_id` bigint(20) NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE INDEX `UK812t22yn0295dkkvx5gjgahax`(`account`) USING BTREE,
|
INDEX `FKdvwfw4x66ahh1tavd69cnx4i0`(`create_user_id`) USING BTREE,
|
INDEX `FKct3f9stm4eti10401f7rbh5ey`(`update_user_id`) USING BTREE,
|
INDEX `FKga0jd7sahnn1tv14mq4dy5kba`(`erupt_menu_id`) USING BTREE,
|
INDEX `FK1re8jv3614mkk2wfxscvgvmnm`(`erupt_org_id`) USING BTREE,
|
INDEX `FK53cice19aydjcuykpv847ocdv`(`erupt_post_id`) USING BTREE,
|
CONSTRAINT `FK1re8jv3614mkk2wfxscvgvmnm` FOREIGN KEY (`erupt_org_id`) REFERENCES `e_upms_org` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
CONSTRAINT `FK53cice19aydjcuykpv847ocdv` FOREIGN KEY (`erupt_post_id`) REFERENCES `e_upms_post` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
CONSTRAINT `FKct3f9stm4eti10401f7rbh5ey` FOREIGN KEY (`update_user_id`) REFERENCES `e_upms_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
CONSTRAINT `FKdvwfw4x66ahh1tavd69cnx4i0` FOREIGN KEY (`create_user_id`) REFERENCES `e_upms_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
CONSTRAINT `FKga0jd7sahnn1tv14mq4dy5kba` FOREIGN KEY (`erupt_menu_id`) REFERENCES `e_upms_menu` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of e_upms_user
|
-- ----------------------------
|
INSERT INTO `e_upms_user` VALUES (1, '2021-11-01 10:28:58', NULL, 'erupt', NULL, b'1', b'1', 'erupt', '610d44f73b7709169e8e06ca4ac5af8e', NULL, NULL, b'1', NULL, NULL, NULL, NULL, NULL, NULL);
|
|
-- ----------------------------
|
-- Table structure for e_upms_user_role
|
-- ----------------------------
|
DROP TABLE IF EXISTS `e_upms_user_role`;
|
CREATE TABLE `e_upms_user_role` (
|
`user_id` bigint(20) NOT NULL,
|
`role_id` bigint(20) NOT NULL,
|
PRIMARY KEY (`role_id`, `user_id`) USING BTREE,
|
INDEX `FKes2ylim5w3ej690ss84sb956x`(`user_id`) USING BTREE,
|
CONSTRAINT `FK3h4lekfh26f5f8b7by3ejges6` FOREIGN KEY (`role_id`) REFERENCES `e_upms_role` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
CONSTRAINT `FKes2ylim5w3ej690ss84sb956x` FOREIGN KEY (`user_id`) REFERENCES `e_upms_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
