/* 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;