/* Navicat Premium Data Transfer Source Server : 58.246.27.194--mysql Source Server Type : MySQL Source Server Version : 50636 Source Host : 58.246.27.194:6002 Source Schema : sxyd Target Server Type : MySQL Target Server Version : 50636 File Encoding : 65001 Date: 03/11/2021 21:22:12 */ 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 utf8 COLLATE utf8_general_ci NULL, `content2` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `pic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `publish` bit(1) NULL DEFAULT NULL, `remark` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_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 = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- 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 utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `code` longtext CHARACTER SET utf8 COLLATE utf8_general_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 = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- 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 = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- 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 utf8 COLLATE utf8_general_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 = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- 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 utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `bool` bit(1) NULL DEFAULT NULL, `color` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `date1` datetime(0) NULL DEFAULT NULL, `date_time` datetime(0) NULL DEFAULT NULL, `feature` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `history` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `input` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `month` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `number1` double NULL DEFAULT NULL, `slider` int(11) NULL DEFAULT NULL, `tags` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `week` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `week_input` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `year` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_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 = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- 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 utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_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 = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- 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 utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_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 = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- 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 utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `remark` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `table_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_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 = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- 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 utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `is_show` bit(1) NULL DEFAULT NULL, `link_class` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `not_null` bit(1) NULL DEFAULT NULL, `query` bit(1) NULL DEFAULT NULL, `show_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `sort` int(11) NULL DEFAULT NULL, `sortable` bit(1) NULL DEFAULT NULL, `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_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 = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- 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 utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `cron` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `handler` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `handler_param` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `notify_emails` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `remark` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_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 = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- 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 utf8 COLLATE utf8_general_ci NULL, `handler_param` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `result_info` longtext CHARACTER SET utf8 COLLATE utf8_general_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 = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- 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 utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `recipient` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `subject` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_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 = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- 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 utf8 COLLATE utf8_general_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 = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- 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 utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `device_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `login_time` datetime(0) NULL DEFAULT NULL, `region` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `system_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `token` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_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 = 86 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of e_upms_login_log -- ---------------------------- INSERT INTO `e_upms_login_log` VALUES (1, 'Chrome 9 95', 'Computer', '172.16.0.3', '2021-11-02 11:03:14', '0|0|0|内网IP|内网IP', 'Windows 8', 'Ont2QfvngeZI6Ljy', 1); INSERT INTO `e_upms_login_log` VALUES (2, 'Chrome 9 95', 'Computer', '172.16.0.3', '2021-11-02 11:11:54', '0|0|0|内网IP|内网IP', 'Windows 8', '82MrGdSXCVUZeS4T', 1); INSERT INTO `e_upms_login_log` VALUES (3, 'Chrome 9 95', 'Computer', '172.16.0.3', '2021-11-02 11:14:40', '0|0|0|内网IP|内网IP', 'Windows 8', 'o5tGW0ecuxqP8uiO', 1); INSERT INTO `e_upms_login_log` VALUES (4, 'Chrome 9 95', 'Computer', '172.16.0.3', '2021-11-02 11:29:22', '0|0|0|内网IP|内网IP', 'Windows 8', 'tyHo73ftWXCsipov', 1); INSERT INTO `e_upms_login_log` VALUES (5, 'Chrome 9 95', 'Computer', '172.16.0.3', '2021-11-02 11:43:21', '0|0|0|内网IP|内网IP', 'Windows 8', 'Pt8hIe4PhJhbPy8u', 1); INSERT INTO `e_upms_login_log` VALUES (6, 'Chrome 9 95', 'Computer', '172.16.0.3', '2021-11-02 11:48:17', '0|0|0|内网IP|内网IP', 'Windows 8', 'AGwu9SGKqsgx22Iq', 1); INSERT INTO `e_upms_login_log` VALUES (7, 'Chrome 9 95', 'Computer', '172.16.0.3', '2021-11-02 11:53:21', '0|0|0|内网IP|内网IP', 'Windows 8', 'DS005BKDiPKpKDnV', 1); INSERT INTO `e_upms_login_log` VALUES (8, 'Chrome 9 95', 'Computer', '172.16.0.3', '2021-11-02 12:00:49', '0|0|0|内网IP|内网IP', 'Windows 8', 'QD5AeYd0rNzuGIAb', 1); INSERT INTO `e_upms_login_log` VALUES (9, 'Chrome 9 95', 'Computer', '172.16.0.3', '2021-11-02 12:10:41', '0|0|0|内网IP|内网IP', 'Windows 8', '7dfBfnZin6g5Nnm0', 1); INSERT INTO `e_upms_login_log` VALUES (10, 'Chrome 9 95', 'Computer', '172.16.0.3', '2021-11-02 12:19:50', '0|0|0|内网IP|内网IP', 'Windows 8', 'mTuZcLuSZKIEBrYA', 1); INSERT INTO `e_upms_login_log` VALUES (11, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 12:59:47', '0|0|0|内网IP|内网IP', 'Windows 8', '6vdIVqvWDpjVXmc9', 1); INSERT INTO `e_upms_login_log` VALUES (12, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 13:29:42', '0|0|0|内网IP|内网IP', 'Windows 8', 'sFsPj4hVxibm3FvK', 1); INSERT INTO `e_upms_login_log` VALUES (13, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 13:31:05', '0|0|0|内网IP|内网IP', 'Windows 8', 'xKvnUU2hpBxPfB0O', 1); INSERT INTO `e_upms_login_log` VALUES (14, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 13:43:47', '0|0|0|内网IP|内网IP', 'Windows 8', 'YjPH0yy8cD8aO9HT', 1); INSERT INTO `e_upms_login_log` VALUES (15, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 13:50:30', '0|0|0|内网IP|内网IP', 'Windows 8', 'ePCGKMiIk6FiXVET', 1); INSERT INTO `e_upms_login_log` VALUES (16, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 13:55:24', '0|0|0|内网IP|内网IP', 'Windows 8', 'fMvNp0jQijpnbnoA', 1); INSERT INTO `e_upms_login_log` VALUES (17, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 14:34:56', '0|0|0|内网IP|内网IP', 'Windows 8', 'Ft1GtRW9g0ZnBJ5T', 1); INSERT INTO `e_upms_login_log` VALUES (18, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 14:39:45', '0|0|0|内网IP|内网IP', 'Windows 8', 'rhb6gDbaOYqUVM4c', 1); INSERT INTO `e_upms_login_log` VALUES (19, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 14:42:53', '0|0|0|内网IP|内网IP', 'Windows 8', 'z6Be2ViP8k03gbl5', 1); INSERT INTO `e_upms_login_log` VALUES (20, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 14:44:09', '0|0|0|内网IP|内网IP', 'Windows 8', 'c02Hf7qfIswtvQ82', 1); INSERT INTO `e_upms_login_log` VALUES (21, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 14:48:22', '0|0|0|内网IP|内网IP', 'Windows 8', 'LiFrqz25MGmzZCaG', 1); INSERT INTO `e_upms_login_log` VALUES (22, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 14:52:17', '0|0|0|内网IP|内网IP', 'Windows 8', 'BMgYJZSfkiHarVLI', 1); INSERT INTO `e_upms_login_log` VALUES (23, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 14:53:39', '0|0|0|内网IP|内网IP', 'Windows 8', 'hCIhAjaYuvrDcwn6', 1); INSERT INTO `e_upms_login_log` VALUES (24, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 14:56:33', '0|0|0|内网IP|内网IP', 'Windows 8', 'oUnhpX4qT7VzNgpn', 1); INSERT INTO `e_upms_login_log` VALUES (25, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 15:02:52', '0|0|0|内网IP|内网IP', 'Windows 8', 'D6s0FqI2s7ITb31M', 1); INSERT INTO `e_upms_login_log` VALUES (26, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 15:14:33', '0|0|0|内网IP|内网IP', 'Windows 8', 'slBuFf77q5IrhkaQ', 1); INSERT INTO `e_upms_login_log` VALUES (27, 'Chrome 9 95', 'Computer', '192.168.1.6', '2021-11-02 15:15:16', '0|0|0|内网IP|内网IP', 'Windows 10', 'eRjvDQWlVcjkfZbR', 1); INSERT INTO `e_upms_login_log` VALUES (28, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 19:13:03', '0|0|0|内网IP|内网IP', 'Windows 8', 'fHCfVc7ispW2rjNZ', 1); INSERT INTO `e_upms_login_log` VALUES (29, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 19:26:55', '0|0|0|内网IP|内网IP', 'Windows 8', 'zCdY5A5S2r1P1Dth', 1); INSERT INTO `e_upms_login_log` VALUES (30, 'Chrome 9 95', 'Computer', '192.168.1.6', '2021-11-02 19:27:42', '0|0|0|内网IP|内网IP', 'Windows 10', 'Ju5vVcj9Eh4EGuOv', 1); INSERT INTO `e_upms_login_log` VALUES (31, 'Chrome 9 95', 'Computer', '192.168.1.6', '2021-11-02 19:31:43', '0|0|0|内网IP|内网IP', 'Windows 10', 'wPQ6qmpoPHM0WJ8y', 1); INSERT INTO `e_upms_login_log` VALUES (32, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 19:35:26', '0|0|0|内网IP|内网IP', 'Windows 8', 'nx5rpUYFiSUv7Yft', 1); INSERT INTO `e_upms_login_log` VALUES (33, 'Chrome 9 95', 'Computer', '192.168.1.6', '2021-11-02 19:40:04', '0|0|0|内网IP|内网IP', 'Windows 10', 'xDBLx9tHfb9lSEaR', 1); INSERT INTO `e_upms_login_log` VALUES (34, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 19:42:31', '0|0|0|内网IP|内网IP', 'Windows 8', 'PyEPbSQbn6s9zNiS', 1); INSERT INTO `e_upms_login_log` VALUES (35, 'Chrome 9 95', 'Computer', '192.168.1.6', '2021-11-02 19:50:32', '0|0|0|内网IP|内网IP', 'Windows 10', 'z8WCW9ENwk9132Yu', 1); INSERT INTO `e_upms_login_log` VALUES (36, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 19:56:44', '0|0|0|内网IP|内网IP', 'Windows 8', 'g5RpJ90Jz2FL3ils', 1); INSERT INTO `e_upms_login_log` VALUES (37, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 20:01:28', '0|0|0|内网IP|内网IP', 'Windows 8', 'zc1QOM75ImCYiEr3', 1); INSERT INTO `e_upms_login_log` VALUES (38, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 20:12:33', '0|0|0|内网IP|内网IP', 'Windows 8', 'S7OdlWIXfTIhRt9j', 1); INSERT INTO `e_upms_login_log` VALUES (39, 'Chrome 9 95', 'Computer', '192.168.1.6', '2021-11-02 20:14:57', '0|0|0|内网IP|内网IP', 'Windows 10', 'eROxVGjGbRYUjjUO', 1); INSERT INTO `e_upms_login_log` VALUES (40, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 20:16:06', '0|0|0|内网IP|内网IP', 'Windows 8', 'LaU1KuLnrFKGRkA4', 1); INSERT INTO `e_upms_login_log` VALUES (41, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 20:47:14', '0|0|0|内网IP|内网IP', 'Windows 8', 'gENMGRwUkaHoxi3K', 1); INSERT INTO `e_upms_login_log` VALUES (42, 'Chrome 9 95', 'Computer', '192.168.1.6', '2021-11-02 20:49:24', '0|0|0|内网IP|内网IP', 'Windows 10', 'boVhzyAKczaUDAVS', 1); INSERT INTO `e_upms_login_log` VALUES (43, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 20:54:29', '0|0|0|内网IP|内网IP', 'Windows 8', 'g80IYyJIB9CZiemD', 1); INSERT INTO `e_upms_login_log` VALUES (44, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 20:56:05', '0|0|0|内网IP|内网IP', 'Windows 8', 'nLExU1cX5x1AmpUO', 1); INSERT INTO `e_upms_login_log` VALUES (45, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 20:59:55', '0|0|0|内网IP|内网IP', 'Windows 8', 'vzRR0yYTm6bMGv4Q', 1); INSERT INTO `e_upms_login_log` VALUES (46, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 21:03:03', '0|0|0|内网IP|内网IP', 'Windows 8', '2wQ2xv2lbQIvsovL', 1); INSERT INTO `e_upms_login_log` VALUES (47, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 21:04:19', '0|0|0|内网IP|内网IP', 'Windows 8', 'lskRLdtSLMdWERBi', 1); INSERT INTO `e_upms_login_log` VALUES (48, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 21:04:47', '0|0|0|内网IP|内网IP', 'Windows 8', 'SqisgZkrz4Vdn9ce', 1); INSERT INTO `e_upms_login_log` VALUES (49, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 21:05:54', '0|0|0|内网IP|内网IP', 'Windows 8', 'mtPn05q7nNt2Hkg3', 1); INSERT INTO `e_upms_login_log` VALUES (50, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 21:10:17', '0|0|0|内网IP|内网IP', 'Windows 8', 'G83xbORSq9z7F8Yv', 1); INSERT INTO `e_upms_login_log` VALUES (51, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 21:13:48', '0|0|0|内网IP|内网IP', 'Windows 8', 'l8ZdjgWkbfElYHyf', 1); INSERT INTO `e_upms_login_log` VALUES (52, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 21:16:45', '0|0|0|内网IP|内网IP', 'Windows 8', 'zvNaZrsSOhoqPYrq', 1); INSERT INTO `e_upms_login_log` VALUES (53, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 21:17:56', '0|0|0|内网IP|内网IP', 'Windows 8', 'r4qW3IM6GqRJT1mq', 1); INSERT INTO `e_upms_login_log` VALUES (54, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 21:18:20', '0|0|0|内网IP|内网IP', 'Windows 8', 'bNamcbLEUfsnB2a1', 1); INSERT INTO `e_upms_login_log` VALUES (55, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 21:47:17', '0|0|0|内网IP|内网IP', 'Windows 8', 'blArevLiGNUST7eh', 1); INSERT INTO `e_upms_login_log` VALUES (56, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 21:51:15', '0|0|0|内网IP|内网IP', 'Windows 8', 'RkivdjFJ9NsXtSZl', 1); INSERT INTO `e_upms_login_log` VALUES (57, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 21:53:38', '0|0|0|内网IP|内网IP', 'Windows 8', 'dzyAEwldNf0T9sYd', 1); INSERT INTO `e_upms_login_log` VALUES (58, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 21:55:00', '0|0|0|内网IP|内网IP', 'Windows 8', 'RNazel0GnKkn6s6c', 1); INSERT INTO `e_upms_login_log` VALUES (59, 'Chrome 9 95', 'Computer', '114.88.160.245', '2021-11-02 22:03:12', '中国|0|上海|上海市|电信', 'Windows 8', 'mX8CTaUzuB4ioe2y', 1); INSERT INTO `e_upms_login_log` VALUES (60, 'Chrome 9 95', 'Computer', '114.88.160.245', '2021-11-02 22:09:16', '中国|0|上海|上海市|电信', 'Windows 8', 'PgINhiztQEyJK9mU', 3); INSERT INTO `e_upms_login_log` VALUES (61, 'Chrome 9 95', 'Computer', '114.88.160.245', '2021-11-02 22:10:05', '中国|0|上海|上海市|电信', 'Windows 8', 'KHed2x7PX3sFztR6', 2); INSERT INTO `e_upms_login_log` VALUES (62, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 22:17:41', '0|0|0|内网IP|内网IP', 'Windows 8', 'KCb28r4F30TI02i6', 1); INSERT INTO `e_upms_login_log` VALUES (63, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 22:22:15', '0|0|0|内网IP|内网IP', 'Windows 8', 'Le1kqIXUrc9XDLDb', 2); INSERT INTO `e_upms_login_log` VALUES (64, 'Chrome 9 95', 'Computer', '114.88.160.245', '2021-11-02 22:27:43', '中国|0|上海|上海市|电信', 'Windows 10', 'RBNZ7D1VFHDmlwUF', 2); INSERT INTO `e_upms_login_log` VALUES (65, 'Chrome 9 95', 'Computer', '114.88.160.245', '2021-11-02 22:28:28', '中国|0|上海|上海市|电信', 'Windows 10', 'DknjPaPdXsTIJNmi', 2); INSERT INTO `e_upms_login_log` VALUES (66, 'Chrome 9 95', 'Computer', '114.88.160.245', '2021-11-02 22:29:40', '中国|0|上海|上海市|电信', 'Windows 10', 'P4cnj94kCnLukDaG', 3); INSERT INTO `e_upms_login_log` VALUES (67, 'Chrome 9 95', 'Computer', '114.88.160.245', '2021-11-02 22:30:32', '中国|0|上海|上海市|电信', 'Windows 8', 'OZ0ef1Gt7XcDnHkn', 2); INSERT INTO `e_upms_login_log` VALUES (68, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 22:31:56', '0|0|0|内网IP|内网IP', 'Windows 8', 'UCuB3GekDd3dB9My', 2); INSERT INTO `e_upms_login_log` VALUES (69, 'Chrome 9 95', 'Computer', '114.88.160.245', '2021-11-02 22:35:29', '中国|0|上海|上海市|电信', 'Windows 8', 'CtJf9j1NpG4US5DU', 2); INSERT INTO `e_upms_login_log` VALUES (70, 'Chrome 9 94', 'Computer', '172.26.78.12', '2021-11-02 22:36:15', '0|0|0|内网IP|内网IP', 'Windows 7', 'AqJZtanRXJZfZnme', 2); INSERT INTO `e_upms_login_log` VALUES (71, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 22:38:43', '0|0|0|内网IP|内网IP', 'Windows 8', '6ec1ISSTJfYVzdTk', 2); INSERT INTO `e_upms_login_log` VALUES (72, 'Chrome 9 94', 'Computer', '172.26.78.12', '2021-11-02 22:41:32', '0|0|0|内网IP|内网IP', 'Windows 7', 'mCYYLJFOYP6Bc3Zm', 2); INSERT INTO `e_upms_login_log` VALUES (73, 'Chrome 9 95', 'Computer', '114.88.160.245', '2021-11-02 22:42:27', '中国|0|上海|上海市|电信', 'Windows 8', 'VIO0tkzS09TvHJXw', 1); INSERT INTO `e_upms_login_log` VALUES (74, 'Chrome 9 95', 'Computer', '114.88.160.245', '2021-11-02 22:44:32', '中国|0|上海|上海市|电信', 'Windows 8', 'YALPPAen48bNpXm1', 2); INSERT INTO `e_upms_login_log` VALUES (75, 'Chrome 9 95', 'Computer', '114.88.160.245', '2021-11-02 22:49:21', '中国|0|上海|上海市|电信', 'Windows 8', 'vcaxB8DG55wWjldw', 2); INSERT INTO `e_upms_login_log` VALUES (76, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 22:51:55', '0|0|0|内网IP|内网IP', 'Windows 8', 'bTNW05FdctHBHspH', 2); INSERT INTO `e_upms_login_log` VALUES (77, 'Chrome 9 95', 'Computer', '192.168.1.2', '2021-11-02 22:53:19', '0|0|0|内网IP|内网IP', 'Windows 8', 'GtjVR9QsFLLhand8', 2); INSERT INTO `e_upms_login_log` VALUES (78, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-02 22:54:52', '0|0|0|内网IP|内网IP', 'Windows 8', 'EpGPMifctPdrjzqQ', 2); INSERT INTO `e_upms_login_log` VALUES (79, 'Chrome Mobile 88', 'Mobile', '192.168.1.2', '2021-11-02 23:03:10', '0|0|0|内网IP|内网IP', 'Android 1.x', 'x8hZPFhFIeHF6hZK', 2); INSERT INTO `e_upms_login_log` VALUES (80, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-03 21:09:28', '0|0|0|内网IP|内网IP', 'Windows 8', 'ewjCFgVU7BEM0483', 2); INSERT INTO `e_upms_login_log` VALUES (81, 'Firefox 9 93', 'Computer', '192.168.10.1', '2021-11-03 21:10:34', '0|0|0|内网IP|内网IP', 'Windows 10', '9uYGNcqui1pJrabN', 2); INSERT INTO `e_upms_login_log` VALUES (82, 'Firefox 9 93', 'Computer', '192.168.1.2', '2021-11-03 21:11:15', '0|0|0|内网IP|内网IP', 'Windows 10', 'iwrGgSTXR98YhuaU', 2); INSERT INTO `e_upms_login_log` VALUES (83, 'Chrome 9 95', 'Computer', '192.168.10.1', '2021-11-03 21:16:49', '0|0|0|内网IP|内网IP', 'Windows 8', '6x8zYJh8vuedv67i', 2); INSERT INTO `e_upms_login_log` VALUES (84, 'Firefox 9 93', 'Computer', '192.168.10.1', '2021-11-03 21:17:45', '0|0|0|内网IP|内网IP', 'Windows 10', 'WXW3UPOxkXMBYQan', 2); INSERT INTO `e_upms_login_log` VALUES (85, 'Firefox 9 93', 'Computer', '192.168.1.2', '2021-11-03 21:18:31', '0|0|0|内网IP|内网IP', 'Windows 10', 'BeiB0f7RlCGNp12p', 2); -- ---------------------------- -- 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 utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `param` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `power_off` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `sort` int(11) NULL DEFAULT NULL, `status` int(11) NULL DEFAULT NULL, `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_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 = 37 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of e_upms_menu -- ---------------------------- INSERT INTO `e_upms_menu` VALUES (1, NULL, '2021-11-02 11:12:35', '$manager', 'fa fa-cogs', '系统管理', NULL, NULL, 10, 1, NULL, NULL, NULL, 1, NULL); INSERT INTO `e_upms_menu` VALUES (2, NULL, NULL, 'EruptMenu', 'fa fa-list-ul', '菜单维护', NULL, NULL, 10, 1, 'tree', 'EruptMenu', NULL, NULL, 1); INSERT INTO `e_upms_menu` VALUES (3, NULL, NULL, 'EruptRole', NULL, '角色维护', NULL, NULL, 20, 1, 'table', 'EruptRole', NULL, NULL, 1); INSERT INTO `e_upms_menu` VALUES (4, NULL, NULL, 'EruptOrg', 'fa fa-users', '组织维护', NULL, NULL, 30, 1, 'tree', 'EruptOrg', NULL, NULL, 1); INSERT INTO `e_upms_menu` VALUES (5, NULL, NULL, 'EruptPost', 'fa fa-id-card', '岗位维护', NULL, NULL, 35, 1, 'table', 'EruptPost', NULL, NULL, 1); INSERT INTO `e_upms_menu` VALUES (6, NULL, NULL, 'EruptUser', 'fa fa-user', '用户维护', NULL, NULL, 40, 1, 'table', 'EruptUser', NULL, NULL, 1); INSERT INTO `e_upms_menu` VALUES (7, NULL, NULL, 'EruptDict', NULL, '字典维护', NULL, NULL, 50, 1, 'table', 'EruptDict', NULL, NULL, 1); INSERT INTO `e_upms_menu` VALUES (8, NULL, NULL, 'EruptDictItem', NULL, '字典项', NULL, NULL, 10, 2, 'table', 'EruptDictItem', NULL, NULL, 7); INSERT INTO `e_upms_menu` VALUES (9, NULL, NULL, 'EruptLoginLog', NULL, '登录日志', NULL, NULL, 60, 1, 'table', 'EruptLoginLog', NULL, NULL, 1); INSERT INTO `e_upms_menu` VALUES (10, NULL, NULL, 'EruptOperateLog', NULL, '操作日志', NULL, NULL, 70, 1, 'table', 'EruptOperateLog', NULL, NULL, 1); INSERT INTO `e_upms_menu` VALUES (11, NULL, '2021-11-02 11:12:25', '$job', 'fa fa-cubes', '任务管理', NULL, NULL, 40, 1, NULL, NULL, NULL, 1, NULL); INSERT INTO `e_upms_menu` VALUES (12, NULL, NULL, 'EruptJob', 'fa fa-tasks', '任务维护', NULL, NULL, 0, 1, 'table', 'EruptJob', NULL, NULL, 11); INSERT INTO `e_upms_menu` VALUES (13, NULL, NULL, 'EruptJobLog', 'fa fa-file-text', '任务日志', NULL, NULL, 10, 1, 'table', 'EruptJobLog', NULL, NULL, 11); INSERT INTO `e_upms_menu` VALUES (14, NULL, NULL, 'EruptMail', 'fa fa-envelope-o', '发送邮件', NULL, NULL, 20, 1, 'table', 'EruptMail', NULL, NULL, 11); INSERT INTO `e_upms_menu` VALUES (15, NULL, '2021-11-02 11:12:17', '$generator', 'fa fa-code', '代码生成', NULL, NULL, 50, 1, NULL, NULL, NULL, 1, NULL); INSERT INTO `e_upms_menu` VALUES (16, NULL, NULL, 'GeneratorClass', NULL, '生成Erupt代码', NULL, NULL, 0, 1, 'table', 'GeneratorClass', NULL, NULL, 15); INSERT INTO `e_upms_menu` VALUES (17, NULL, '2021-11-02 11:12:31', 'monitor', 'fa fa-bullseye', '系统监控', NULL, NULL, 20, 1, NULL, NULL, NULL, 1, NULL); INSERT INTO `e_upms_menu` VALUES (18, NULL, NULL, 'server.html', NULL, '服务监控', NULL, NULL, 10, 1, 'tpl', 'server.html', NULL, NULL, 17); INSERT INTO `e_upms_menu` VALUES (19, NULL, NULL, 'redis.html', NULL, '缓存监控', NULL, NULL, 20, 1, 'tpl', 'redis.html', NULL, NULL, 17); INSERT INTO `e_upms_menu` VALUES (20, NULL, NULL, 'EruptOnline', NULL, '在线用户', NULL, NULL, 30, 1, 'table', 'EruptOnline', NULL, NULL, 17); INSERT INTO `e_upms_menu` VALUES (21, NULL, NULL, 'magic-api', 'fa fa-cube', '接口配置', NULL, NULL, 80, 1, 'tpl', 'magic-api.ftl', NULL, NULL, NULL); INSERT INTO `e_upms_menu` VALUES (22, NULL, NULL, 'magic-api-view', NULL, '查看详情', NULL, NULL, 90, 2, 'button', 'ERUPT_MAGIC_VIEW', NULL, NULL, 21); INSERT INTO `e_upms_menu` VALUES (23, NULL, NULL, 'magic-api-save', NULL, '保存', NULL, NULL, 100, 2, 'button', 'ERUPT_MAGIC_SAVE', NULL, NULL, 21); INSERT INTO `e_upms_menu` VALUES (24, NULL, NULL, 'magic-api-delete', NULL, '删除', NULL, NULL, 110, 2, 'button', 'ERUPT_MAGIC_DELETE', NULL, NULL, 21); INSERT INTO `e_upms_menu` VALUES (25, NULL, NULL, 'magic-api-upload', NULL, '上传', NULL, NULL, 120, 2, 'button', 'ERUPT_MAGIC_UPLOAD', NULL, NULL, 21); INSERT INTO `e_upms_menu` VALUES (26, NULL, NULL, 'magic-api-download', NULL, '导出', NULL, NULL, 130, 2, 'button', 'ERUPT_MAGIC_DOWNLOAD', NULL, NULL, 21); INSERT INTO `e_upms_menu` VALUES (27, NULL, NULL, 'magic-api-datasource_view', NULL, '数据源查看详情', NULL, NULL, 140, 2, 'button', 'ERUPT_MAGIC_DATASOURCE_VIEW', NULL, NULL, 21); INSERT INTO `e_upms_menu` VALUES (28, NULL, NULL, 'magic-api-datasource_save', NULL, '数据源保存', NULL, NULL, 150, 2, 'button', 'ERUPT_MAGIC_DATASOURCE_SAVE', NULL, NULL, 21); INSERT INTO `e_upms_menu` VALUES (29, NULL, NULL, 'magic-api-datasource_delete', NULL, '数据源删除', NULL, NULL, 160, 2, 'button', 'ERUPT_MAGIC_DATASOURCE_DELETE', NULL, NULL, 21); INSERT INTO `e_upms_menu` VALUES (30, '2021-11-02 11:13:06', NULL, 'dt_check', NULL, '数据检查', NULL, NULL, 0, 1, NULL, NULL, 1, NULL, NULL); INSERT INTO `e_upms_menu` VALUES (31, '2021-11-02 11:13:58', '2021-11-02 11:15:27', 'taxi_dt_check', 'fa fa-check', 'taxi上报检查', NULL, NULL, 10, 1, 'table', 'TaxiRealtimedata', 1, 1, 30); INSERT INTO `e_upms_menu` VALUES (32, '2021-11-02 22:19:07', '2021-11-02 22:43:26', 'PM25Btn', NULL, 'PM25核对', NULL, NULL, 10, 1, 'button', 'PM25Btn', 1, 1, 31); INSERT INTO `e_upms_menu` VALUES (33, '2021-11-02 22:19:44', '2021-11-02 22:43:36', 'NO2Btn', NULL, 'NO2核对', NULL, NULL, 20, 1, 'button', 'NO2Btn', 1, 1, 31); INSERT INTO `e_upms_menu` VALUES (34, '2021-11-02 22:20:12', '2021-11-02 22:43:44', 'NOBtn', NULL, 'NO核对', NULL, NULL, 30, 1, 'button', 'NOBtn', 1, 1, 31); INSERT INTO `e_upms_menu` VALUES (35, '2021-11-02 22:20:36', '2021-11-02 22:43:54', 'COBtn', NULL, 'CO核对', NULL, NULL, 40, 1, 'button', 'COBtn', 1, 1, 31); INSERT INTO `e_upms_menu` VALUES (36, '2021-11-02 22:21:07', '2021-11-02 22:44:03', 'FlagBtn', NULL, 'Flag核对', NULL, NULL, 50, 1, 'button', 'FlagBtn', 1, 1, 31); -- ---------------------------- -- 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 utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `create_time` datetime(0) NULL DEFAULT NULL, `error_info` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `region` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `req_addr` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `req_method` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `req_param` longtext CHARACTER SET utf8 COLLATE utf8_general_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 = 52 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of e_upms_operate_log -- ---------------------------- INSERT INTO `e_upms_operate_log` VALUES (1, '修改 | 菜单配置', '2021-11-02 11:12:17', NULL, '172.16.0.3', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/EruptMenu', 'PUT', '{\"code\":\"$generator\",\"name\":\"代码生成\",\"status\":\"1\",\"sort\":50,\"icon\":\"fa fa-code\",\"id\":15}', b'1', 213, 1); INSERT INTO `e_upms_operate_log` VALUES (2, '修改 | 菜单配置', '2021-11-02 11:12:25', NULL, '172.16.0.3', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/EruptMenu', 'PUT', '{\"code\":\"$job\",\"name\":\"任务管理\",\"status\":\"1\",\"sort\":40,\"icon\":\"fa fa-cubes\",\"id\":11}', b'1', 184, 1); INSERT INTO `e_upms_operate_log` VALUES (3, '修改 | 菜单配置', '2021-11-02 11:12:31', NULL, '172.16.0.3', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/EruptMenu', 'PUT', '{\"code\":\"monitor\",\"name\":\"系统监控\",\"status\":\"1\",\"sort\":20,\"icon\":\"fa fa-bullseye\",\"id\":17}', b'1', 169, 1); INSERT INTO `e_upms_operate_log` VALUES (4, '修改 | 菜单配置', '2021-11-02 11:12:35', NULL, '172.16.0.3', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/EruptMenu', 'PUT', '{\"code\":\"$manager\",\"name\":\"系统管理\",\"status\":\"1\",\"sort\":10,\"icon\":\"fa fa-cogs\",\"id\":1}', b'1', 160, 1); INSERT INTO `e_upms_operate_log` VALUES (5, '新增 | 菜单配置', '2021-11-02 11:13:06', NULL, '172.16.0.3', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/EruptMenu', 'POST', '{\"code\":\"dt_check\",\"name\":\"数据检查\",\"status\":\"1\",\"sort\":0}', b'1', 128, 1); INSERT INTO `e_upms_operate_log` VALUES (6, '新增 | 菜单配置', '2021-11-02 11:13:58', NULL, '172.16.0.3', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/EruptMenu', 'POST', '{\"code\":\"taxi_dt_check\",\"name\":\"taxi上报检查\",\"status\":\"1\",\"type\":\"table\",\"value\":\"TaxiRealtimedata\",\"sort\":10,\"icon\":\"fa fa check\",\"parentMenu\":{\"id\":30,\"name\":\"数据检查\"}}', b'1', 123, 1); INSERT INTO `e_upms_operate_log` VALUES (7, '修改 | 菜单配置', '2021-11-02 11:14:07', NULL, '172.16.0.3', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/EruptMenu', 'PUT', '{\"code\":\"taxi_dt_check\",\"name\":\"taxi上报检查\",\"status\":\"1\",\"type\":\"table\",\"value\":\"TaxiRealtimedata\",\"sort\":10,\"icon\":\"fa fa-check\",\"parentMenu\":{\"id\":30,\"name\":\"数据检查\"},\"id\":31}', b'1', 150, 1); INSERT INTO `e_upms_operate_log` VALUES (8, '新增 | 用户角色', '2021-11-02 11:14:28', NULL, '172.16.0.3', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/EruptRole', 'POST', '{\"status\":true,\"menus\":[],\"users\":[]}', b'1', 59, 1); INSERT INTO `e_upms_operate_log` VALUES (9, '修改 | 菜单配置', '2021-11-02 11:15:27', NULL, '172.16.0.3', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/EruptMenu', 'PUT', '{\"code\":\"taxi_dt_check\",\"name\":\"taxi上报检查\",\"status\":\"1\",\"type\":\"table\",\"value\":\"TaxiRealtimedata\",\"sort\":10,\"icon\":\"fa fa-check\",\"parentMenu\":{\"id\":30,\"name\":\"数据检查\"},\"id\":31}', b'1', 187, 1); INSERT INTO `e_upms_operate_log` VALUES (10, 'TaxiRealtimedata | 多行操作', '2021-11-02 13:44:17', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/TaxiRealtimedata/operator/MULTI', 'POST', '{\"ids\":[\"883\",\"7474143\",\"7474142\",\"7474141\",\"7474140\",\"7474139\",\"7474138\",\"7470289\",\"7470288\",\"7470287\"],\"param\":null}', b'1', 125, 1); INSERT INTO `e_upms_operate_log` VALUES (11, 'TaxiRealtimedata | 单行操作', '2021-11-02 13:44:48', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/TaxiRealtimedata/operator/SINGLE', 'POST', '{\"ids\":[\"7474142\"],\"param\":null}', b'1', 23, 1); INSERT INTO `e_upms_operate_log` VALUES (12, 'TaxiRealtimedata | 单行操作', '2021-11-02 13:46:32', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/TaxiRealtimedata/operator/SINGLE', 'POST', '{\"ids\":[\"7474142\"],\"param\":null}', b'1', 43985, 1); INSERT INTO `e_upms_operate_log` VALUES (13, 'TaxiRealtimedata | 多行操作', '2021-11-02 13:47:23', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/TaxiRealtimedata/operator/MULTI', 'POST', '{\"ids\":[\"883\",\"7474143\",\"7474142\",\"7474141\",\"7474140\",\"7474139\",\"7474138\",\"7470289\",\"7470288\",\"7470287\"],\"param\":null}', b'1', 36694, 1); INSERT INTO `e_upms_operate_log` VALUES (14, 'TaxiRealtimedata | 多行操作', '2021-11-02 13:48:39', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/TaxiRealtimedata/operator/MULTI', 'POST', '{\"ids\":[\"883\",\"7474143\",\"7474142\",\"7474141\",\"7474140\",\"7474139\",\"7474138\",\"7470289\",\"7470288\",\"7470287\"],\"param\":null}', b'1', 58739, 1); INSERT INTO `e_upms_operate_log` VALUES (15, 'TaxiRealtimedata | 检查标记', '2021-11-02 14:39:17', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/TaxiRealtimedata/operator/MULTI', 'POST', '{\"ids\":[\"883\",\"7474143\",\"7474142\",\"7474141\",\"7474140\",\"7474139\",\"7474138\",\"7470289\",\"7470288\",\"7470287\"],\"param\":null}', b'1', 238271, 1); INSERT INTO `e_upms_operate_log` VALUES (16, 'TaxiRealtimedata | 检查标记', '2021-11-02 14:40:34', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/TaxiRealtimedata/operator/MULTI', 'POST', '{\"ids\":[\"883\",\"7474143\",\"7474142\",\"7474141\",\"7474140\",\"7474139\",\"7474138\",\"7470289\",\"7470288\",\"7470287\"],\"param\":null}', b'1', 22472, 1); INSERT INTO `e_upms_operate_log` VALUES (17, 'TaxiRealtimedata | 检查标记', '2021-11-02 14:43:17', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/TaxiRealtimedata/operator/MULTI', 'POST', '{\"ids\":[\"883\",\"7474143\",\"7474142\",\"7474141\",\"7474140\",\"7474139\",\"7474138\",\"7470289\",\"7470288\",\"7470287\"],\"param\":null}', b'1', 7438, 1); INSERT INTO `e_upms_operate_log` VALUES (18, 'TaxiRealtimedata | 检查标记', '2021-11-02 14:45:02', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/TaxiRealtimedata/operator/MULTI', 'POST', '{\"ids\":[\"883\",\"7474143\",\"7474142\",\"7474141\",\"7474140\",\"7474139\",\"7474138\",\"7470289\",\"7470288\",\"7470287\"],\"param\":null}', b'1', 21193, 1); INSERT INTO `e_upms_operate_log` VALUES (19, 'TaxiRealtimedata | 检查标记', '2021-11-02 14:49:09', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/TaxiRealtimedata/operator/1313620983', 'POST', '{\"ids\":[\"883\",\"7474143\",\"7474142\",\"7474141\",\"7474140\",\"7474139\",\"7474138\",\"7470289\",\"7470288\",\"7470287\"],\"param\":null}', b'1', 21428, 1); INSERT INTO `e_upms_operate_log` VALUES (20, 'TaxiRealtimedata | 检查标记', '2021-11-02 14:52:45', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/TaxiRealtimedata/operator/274081351', 'POST', '{\"ids\":[\"883\",\"7474143\",\"7474142\",\"7474141\",\"7474140\",\"7474139\",\"7474138\",\"7470289\",\"7470288\",\"7470287\"],\"param\":null}', b'1', 12960, 1); INSERT INTO `e_upms_operate_log` VALUES (21, 'TaxiRealtimedata | 检查标记', '2021-11-02 14:54:30', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/TaxiRealtimedata/operator/-235039779', 'POST', '{\"ids\":[\"883\",\"7474143\",\"7474142\",\"7474141\",\"7474140\",\"7474139\",\"7474138\",\"7470289\",\"7470288\",\"7470287\"],\"param\":null}', b'1', 20240, 1); INSERT INTO `e_upms_operate_log` VALUES (22, 'TaxiRealtimedata | 检查标记', '2021-11-02 14:57:13', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/TaxiRealtimedata/operator/-32961623', 'POST', '{\"ids\":[\"883\",\"7474143\",\"7474142\",\"7474141\",\"7474140\",\"7474139\",\"7474138\",\"7470289\",\"7470288\",\"7470287\"],\"param\":null}', b'1', 22322, 1); INSERT INTO `e_upms_operate_log` VALUES (23, 'TaxiRealtimedata | 标记N', '2021-11-02 19:13:22', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/TaxiRealtimedata/operator/-1509905354', 'POST', '{\"ids\":[\"883\",\"7474143\",\"7474142\",\"7474141\",\"7474140\",\"7474139\",\"7474138\",\"7470289\",\"7470288\",\"7470287\"],\"param\":null}', b'1', 342, 1); INSERT INTO `e_upms_operate_log` VALUES (24, '修改 | TaxiRealtimedata', '2021-11-02 19:15:05', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/TaxiRealtimedata', 'PUT', '{\"posttime\":\"2021-07-26 14:52:57\",\"MN\":\"TX271\",\"PM25\":2,\"PM10\":2,\"NO2\":84,\"no2flag\":\"D\",\"O3\":0,\"NO\":3,\"CO\":0,\"NOX\":\"89\",\"Flag\":\"N\",\"gid_100\":\"121.233_31.373\",\"LON\":121.233154,\"LAT\":31.373387,\"SPEED\":5,\"LON_BAIDU\":121.24414076573507,\"LAT_BAIDU\":31.377286446623064,\"TEMPERATURE\":29.3,\"HUMIDITY\":81,\"VOLTAGE\":12.3,\"id\":7474142}', b'1', 43, 1); INSERT INTO `e_upms_operate_log` VALUES (25, '修改 | TaxiRealtimedata', '2021-11-02 19:15:16', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/TaxiRealtimedata', 'PUT', '{\"posttime\":\"2021-07-26 14:52:57\",\"MN\":\"TX271\",\"PM25\":2,\"PM10\":2,\"NO2\":84,\"no2flag\":\"D\",\"O3\":0,\"NO\":3,\"CO\":0,\"NOX\":\"89\",\"TSP\":0,\"Flag\":\"N\",\"gid_100\":\"121.233_31.373\",\"LON\":121.233154,\"LAT\":31.373387,\"SPEED\":5,\"LON_BAIDU\":121.24414076573507,\"LAT_BAIDU\":31.377286446623064,\"TEMPERATURE\":29.3,\"HUMIDITY\":81,\"VOLTAGE\":12.3,\"id\":7474142}', b'1', 34, 1); INSERT INTO `e_upms_operate_log` VALUES (26, '修改 | TaxiRealtimedata', '2021-11-02 19:15:24', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/TaxiRealtimedata', 'PUT', '{\"posttime\":\"2021-07-26 14:52:57\",\"MN\":\"TX271\",\"PM25\":2,\"PM10\":2,\"NO2\":84,\"no2flag\":\"D\",\"O3\":0,\"NO\":3,\"CO\":0,\"NOX\":\"89\",\"TSP\":0,\"Flag\":\"N\",\"TVOC\":0,\"gid_100\":\"121.233_31.373\",\"LON\":121.233154,\"LAT\":31.373387,\"SPEED\":5,\"LON_BAIDU\":121.24414076573507,\"LAT_BAIDU\":31.377286446623064,\"TEMPERATURE\":29.3,\"HUMIDITY\":81,\"VOLTAGE\":12.3,\"id\":7474142}', b'1', 35, 1); INSERT INTO `e_upms_operate_log` VALUES (27, 'TaxiRealtimedata | 标记D', '2021-11-02 19:16:01', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/TaxiRealtimedata/operator/234929062', 'POST', '{\"ids\":[\"883\",\"7474143\",\"7474142\",\"7474141\",\"7474140\",\"7474139\",\"7474138\",\"7470289\",\"7470288\",\"7470287\",\"7470286\",\"7470285\",\"7470284\",\"7470283\",\"7470282\",\"7470281\",\"7470280\",\"7470279\",\"7469754\",\"7470278\",\"7469753\",\"7470277\",\"7469752\",\"7470276\",\"7469751\",\"7470275\",\"7469750\",\"7470274\",\"7469749\",\"7470273\"],\"param\":null}', b'1', 5974, 1); INSERT INTO `e_upms_operate_log` VALUES (28, 'TaxiRealtimedata | NO2标记N', '2021-11-02 19:49:56', 'java.lang.NullPointerException\r\n at com.example.demo.handler.OperationHandler2Impl.exec(OperationHandler2Impl.java:31)\r\n at com.example.demo.handler.OperationHandler2Impl.exec(OperationHandler2Impl.java:19)\r\n at xyz.erupt.core.controller.EruptDataController.execEruptOperator(EruptDataController.java:134)\r\n at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.base/java.lang.reflect.Method.invoke(Method.java:566)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:197)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:141)\r\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:894)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)\r\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\r\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1060)\r\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:962)\r\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)\r\n at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)\r\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at xyz.erupt.security.interceptor.HttpServletRequestFilter.doFilter(HttpServletRequestFilter.java:43)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.ssssssss.magicapi.config.MagicCorsFilter.doFilter(MagicCorsFilter.java:42)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)\r\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)\r\n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)\r\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)\r\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)\r\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)\r\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)\r\n at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)\r\n at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)\r\n at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:887)\r\n at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1684)\r\n at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\r\n at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)\r\n at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\r\n at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)\r\n at java.base/java.lang.Thread.run(Thread.java:834)\r\n', '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/TaxiRealtimedata/operator/-910358413', 'POST', '{\"ids\":[\"3434382\",\"3434383\",\"3434384\",\"3434385\",\"3434386\",\"3434387\",\"3434388\",\"3015424\",\"2164224\",\"2819584\"],\"param\":null}', b'0', 335399, 1); INSERT INTO `e_upms_operate_log` VALUES (29, 'TaxiRealtimedata | CO标记N', '2021-11-02 19:56:14', 'java.lang.NullPointerException\r\n at com.example.demo.handler.OperationHandler2Impl.exec(OperationHandler2Impl.java:31)\r\n at com.example.demo.handler.OperationHandler2Impl.exec(OperationHandler2Impl.java:19)\r\n at xyz.erupt.core.controller.EruptDataController.execEruptOperator(EruptDataController.java:134)\r\n at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.base/java.lang.reflect.Method.invoke(Method.java:566)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:197)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:141)\r\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:894)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)\r\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\r\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1060)\r\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:962)\r\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)\r\n at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)\r\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at xyz.erupt.security.interceptor.HttpServletRequestFilter.doFilter(HttpServletRequestFilter.java:43)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.ssssssss.magicapi.config.MagicCorsFilter.doFilter(MagicCorsFilter.java:42)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)\r\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)\r\n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)\r\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)\r\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)\r\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)\r\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)\r\n at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)\r\n at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)\r\n at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:887)\r\n at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1684)\r\n at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\r\n at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)\r\n at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\r\n at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)\r\n at java.base/java.lang.Thread.run(Thread.java:834)\r\n', '192.168.1.6', '0|0|0|内网IP|内网IP', 'http://192.168.1.2:8099/erupt-api/data/TaxiRealtimedata/operator/CO', 'POST', '{\"ids\":[\"883\",\"7474143\",\"7474142\",\"7474141\",\"7474140\",\"7474139\",\"7474138\",\"7470289\",\"7470288\",\"7470287\"],\"param\":null}', b'0', 319227, 1); INSERT INTO `e_upms_operate_log` VALUES (30, 'TaxiRealtimedata | CO标记N', '2021-11-02 19:58:51', 'java.lang.NullPointerException\r\n at com.example.demo.handler.OperationHandlerImpl.exec(OperationHandlerImpl.java:35)\r\n at com.example.demo.handler.OperationHandlerImpl.exec(OperationHandlerImpl.java:22)\r\n at xyz.erupt.core.controller.EruptDataController.execEruptOperator(EruptDataController.java:134)\r\n at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.base/java.lang.reflect.Method.invoke(Method.java:566)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:197)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:141)\r\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:894)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)\r\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\r\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1060)\r\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:962)\r\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)\r\n at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)\r\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at xyz.erupt.security.interceptor.HttpServletRequestFilter.doFilter(HttpServletRequestFilter.java:43)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.ssssssss.magicapi.config.MagicCorsFilter.doFilter(MagicCorsFilter.java:42)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)\r\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)\r\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)\r\n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)\r\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)\r\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)\r\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)\r\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)\r\n at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)\r\n at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)\r\n at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:887)\r\n at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1684)\r\n at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\r\n at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)\r\n at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\r\n at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)\r\n at java.base/java.lang.Thread.run(Thread.java:834)\r\n', '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/TaxiRealtimedata/operator/CO', 'POST', '{\"ids\":[\"883\",\"7474143\",\"7474142\",\"7474141\",\"7474140\",\"7474139\",\"7474138\",\"7470289\",\"7470288\",\"7470287\"],\"param\":null}', b'0', 106749, 1); INSERT INTO `e_upms_operate_log` VALUES (31, 'TaxiRealtimedata | PM25标记N', '2021-11-02 20:11:52', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/TaxiRealtimedata/operator/PM25', 'POST', '{\"ids\":[\"883\",\"7474143\",\"7474142\",\"7474141\",\"7474140\",\"7474139\",\"7474138\",\"7470289\",\"7470288\",\"7470287\"],\"param\":null}', b'1', 590310, 1); INSERT INTO `e_upms_operate_log` VALUES (32, 'TaxiRealtimedata | PM25标记N', '2021-11-02 20:13:21', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/TaxiRealtimedata/operator/PM25', 'POST', '{\"ids\":[\"883\",\"7474143\",\"7474142\",\"7474141\",\"7474140\",\"7474139\",\"7474138\",\"7470289\",\"7470288\",\"7470287\"],\"param\":null}', b'1', 23860, 1); INSERT INTO `e_upms_operate_log` VALUES (33, '新增 | 用户角色', '2021-11-02 22:04:27', NULL, '114.88.160.245', '中国|0|上海|上海市|电信', 'http://47.92.93.8:8099/erupt-api/data/modify/EruptRole', 'POST', '{\"code\":\"admin\",\"name\":\"管理员\",\"status\":true,\"menus\":[{\"id\":\"30\"},{\"id\":\"1\"},{\"id\":\"2\"},{\"id\":\"3\"},{\"id\":\"4\"},{\"id\":\"5\"},{\"id\":\"6\"},{\"id\":\"7\"},{\"id\":\"9\"},{\"id\":\"10\"},{\"id\":\"17\"},{\"id\":\"18\"},{\"id\":\"19\"},{\"id\":\"20\"},{\"id\":\"11\"},{\"id\":\"12\"},{\"id\":\"13\"},{\"id\":\"14\"},{\"id\":\"31\"}],\"users\":[]}', b'1', 3665, 1); INSERT INTO `e_upms_operate_log` VALUES (34, '新增 | 组织维护', '2021-11-02 22:04:54', NULL, '114.88.160.245', '中国|0|上海|上海市|电信', 'http://47.92.93.8:8099/erupt-api/data/modify/EruptOrg', 'POST', '{\"code\":\"sxyd\",\"name\":\"sxyd\",\"sort\":1}', b'1', 185, 1); INSERT INTO `e_upms_operate_log` VALUES (35, '新增 | 组织维护', '2021-11-02 22:05:13', NULL, '114.88.160.245', '中国|0|上海|上海市|电信', 'http://47.92.93.8:8099/erupt-api/data/modify/EruptOrg', 'POST', '{\"code\":\"jsk\",\"name\":\"技术科\",\"parentOrg\":{\"id\":1,\"name\":\"sxyd\"},\"sort\":1}', b'1', 208, 1); INSERT INTO `e_upms_operate_log` VALUES (36, '新增 | 组织维护', '2021-11-02 22:05:45', NULL, '114.88.160.245', '中国|0|上海|上海市|电信', 'http://47.92.93.8:8099/erupt-api/data/modify/EruptOrg', 'POST', '{\"code\":\"jcz\",\"name\":\"监测组\",\"parentOrg\":{\"id\":1,\"name\":\"sxyd\"},\"sort\":2}', b'1', 182, 1); INSERT INTO `e_upms_operate_log` VALUES (37, '新增 | 用户', '2021-11-02 22:06:42', NULL, '114.88.160.245', '中国|0|上海|上海市|电信', 'http://47.92.93.8:8099/erupt-api/data/modify/EruptUser', 'POST', '{\"account\":\"admin\",\"name\":\"管理员\",\"status\":true,\"eruptOrg\":{\"id\":\"2\",\"name\":\"技术科\"},\"passwordA\":\"789%qwer\",\"passwordB\":\"789%qwer\",\"isMd5\":true,\"roles\":[{\"id\":1}]}', b'1', 269, 1); INSERT INTO `e_upms_operate_log` VALUES (38, '新增 | 用户角色', '2021-11-02 22:07:48', NULL, '114.88.160.245', '中国|0|上海|上海市|电信', 'http://47.92.93.8:8099/erupt-api/data/modify/EruptRole', 'POST', '{\"code\":\"zhiban\",\"name\":\"值班\",\"status\":true,\"menus\":[{\"id\":\"30\"},{\"id\":\"31\"}],\"users\":[]}', b'1', 240, 1); INSERT INTO `e_upms_operate_log` VALUES (39, '新增 | 用户', '2021-11-02 22:08:43', NULL, '114.88.160.245', '中国|0|上海|上海市|电信', 'http://47.92.93.8:8099/erupt-api/data/modify/EruptUser', 'POST', '{\"account\":\"zhiban1\",\"name\":\"值班1\",\"status\":true,\"eruptOrg\":{\"id\":\"3\",\"name\":\"监测组\"},\"passwordA\":\"789%qwer\",\"passwordB\":\"789%qwer\",\"isMd5\":true,\"roles\":[{\"id\":2}]}', b'1', 211, 1); INSERT INTO `e_upms_operate_log` VALUES (40, '新增 | 菜单配置', '2021-11-02 22:19:07', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/EruptMenu', 'POST', '{\"code\":\"PM25Btn\",\"name\":\"PM25核对\",\"status\":\"1\",\"type\":\"button\",\"value\":\"PM25Btn\",\"sort\":170,\"parentMenu\":{\"id\":31,\"name\":\"taxi上报检查\"}}', b'1', 157, 1); INSERT INTO `e_upms_operate_log` VALUES (41, '新增 | 菜单配置', '2021-11-02 22:19:44', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/EruptMenu', 'POST', '{\"code\":\"NO2Btn\",\"name\":\"NO2核对\",\"status\":\"1\",\"type\":\"button\",\"value\":\"NO2Btn\",\"sort\":180,\"parentMenu\":{\"id\":31,\"name\":\"taxi上报检查\"}}', b'1', 71, 1); INSERT INTO `e_upms_operate_log` VALUES (42, '新增 | 菜单配置', '2021-11-02 22:20:12', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/EruptMenu', 'POST', '{\"code\":\"NOBtn\",\"name\":\"NO核对\",\"status\":\"1\",\"type\":\"button\",\"value\":\"NOBtn\",\"sort\":190,\"parentMenu\":{\"id\":31,\"name\":\"taxi上报检查\"}}', b'1', 72, 1); INSERT INTO `e_upms_operate_log` VALUES (43, '新增 | 菜单配置', '2021-11-02 22:20:36', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/EruptMenu', 'POST', '{\"code\":\"COBtn\",\"name\":\"CO核对\",\"status\":\"1\",\"type\":\"button\",\"value\":\"COBtn\",\"sort\":200,\"parentMenu\":{\"id\":31,\"name\":\"taxi上报检查\"}}', b'1', 66, 1); INSERT INTO `e_upms_operate_log` VALUES (44, '新增 | 菜单配置', '2021-11-02 22:21:07', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/EruptMenu', 'POST', '{\"code\":\"FlagBtn\",\"name\":\"Flag核对\",\"status\":\"1\",\"type\":\"button\",\"value\":\"FlagBtn\",\"sort\":210,\"parentMenu\":{\"id\":31,\"name\":\"taxi上报检查\"}}', b'1', 61, 1); INSERT INTO `e_upms_operate_log` VALUES (45, '修改 | 用户角色', '2021-11-02 22:21:32', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/EruptRole', 'PUT', '{\"code\":\"admin\",\"name\":\"管理员\",\"status\":true,\"menus\":[{\"id\":\"30\"},{\"id\":\"31\"},{\"id\":\"32\"},{\"id\":\"33\"},{\"id\":\"34\"},{\"id\":\"35\"},{\"id\":\"1\"},{\"id\":\"2\"},{\"id\":\"3\"},{\"id\":\"4\"},{\"id\":\"5\"},{\"id\":\"6\"},{\"id\":\"7\"},{\"id\":\"9\"},{\"id\":\"10\"},{\"id\":\"17\"},{\"id\":\"18\"},{\"id\":\"19\"},{\"id\":\"20\"},{\"id\":\"11\"},{\"id\":\"12\"},{\"id\":\"13\"},{\"id\":\"14\"},{\"id\":\"36\"}],\"users\":[{\"id\":2}],\"id\":1}', b'1', 526, 1); INSERT INTO `e_upms_operate_log` VALUES (46, '修改 | 用户角色', '2021-11-02 22:21:50', NULL, '192.168.10.1', '0|0|0|内网IP|内网IP', 'http://localhost:8099/erupt-api/data/modify/EruptRole', 'PUT', '{\"code\":\"zhiban\",\"name\":\"值班\",\"status\":true,\"menus\":[{\"id\":\"30\"},{\"id\":\"31\"},{\"id\":\"32\"},{\"id\":\"33\"},{\"id\":\"34\"},{\"id\":\"35\"},{\"id\":\"36\"}],\"users\":[{\"id\":3}],\"id\":2}', b'1', 191, 1); INSERT INTO `e_upms_operate_log` VALUES (47, '修改 | 菜单配置', '2021-11-02 22:43:26', NULL, '114.88.160.245', '中国|0|上海|上海市|电信', 'http://47.92.93.8:8099/erupt-api/data/modify/EruptMenu', 'PUT', '{\"code\":\"PM25Btn\",\"name\":\"PM25核对\",\"status\":\"1\",\"type\":\"button\",\"value\":\"PM25Btn\",\"sort\":10,\"parentMenu\":{\"id\":31,\"name\":\"taxi上报检查\"},\"id\":32}', b'1', 493, 1); INSERT INTO `e_upms_operate_log` VALUES (48, '修改 | 菜单配置', '2021-11-02 22:43:36', NULL, '114.88.160.245', '中国|0|上海|上海市|电信', 'http://47.92.93.8:8099/erupt-api/data/modify/EruptMenu', 'PUT', '{\"code\":\"NO2Btn\",\"name\":\"NO2核对\",\"status\":\"1\",\"type\":\"button\",\"value\":\"NO2Btn\",\"sort\":20,\"parentMenu\":{\"id\":31,\"name\":\"taxi上报检查\"},\"id\":33}', b'1', 424, 1); INSERT INTO `e_upms_operate_log` VALUES (49, '修改 | 菜单配置', '2021-11-02 22:43:44', NULL, '114.88.160.245', '中国|0|上海|上海市|电信', 'http://47.92.93.8:8099/erupt-api/data/modify/EruptMenu', 'PUT', '{\"code\":\"NOBtn\",\"name\":\"NO核对\",\"status\":\"1\",\"type\":\"button\",\"value\":\"NOBtn\",\"sort\":30,\"parentMenu\":{\"id\":31,\"name\":\"taxi上报检查\"},\"id\":34}', b'1', 446, 1); INSERT INTO `e_upms_operate_log` VALUES (50, '修改 | 菜单配置', '2021-11-02 22:43:54', NULL, '114.88.160.245', '中国|0|上海|上海市|电信', 'http://47.92.93.8:8099/erupt-api/data/modify/EruptMenu', 'PUT', '{\"code\":\"COBtn\",\"name\":\"CO核对\",\"status\":\"1\",\"type\":\"button\",\"value\":\"COBtn\",\"sort\":40,\"parentMenu\":{\"id\":31,\"name\":\"taxi上报检查\"},\"id\":35}', b'1', 424, 1); INSERT INTO `e_upms_operate_log` VALUES (51, '修改 | 菜单配置', '2021-11-02 22:44:03', NULL, '114.88.160.245', '中国|0|上海|上海市|电信', 'http://47.92.93.8:8099/erupt-api/data/modify/EruptMenu', 'PUT', '{\"code\":\"FlagBtn\",\"name\":\"Flag核对\",\"status\":\"1\",\"type\":\"button\",\"value\":\"FlagBtn\",\"sort\":50,\"parentMenu\":{\"id\":31,\"name\":\"taxi上报检查\"},\"id\":36}', b'1', 422, 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 utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_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 = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of e_upms_org -- ---------------------------- INSERT INTO `e_upms_org` VALUES (1, 'sxyd', 'sxyd', 1, NULL); INSERT INTO `e_upms_org` VALUES (2, 'jsk', '技术科', 1, 1); INSERT INTO `e_upms_org` VALUES (3, 'jcz', '监测组', 2, 1); -- ---------------------------- -- 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 utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_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 = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- 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 utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `power_off` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_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 = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of e_upms_role -- ---------------------------- INSERT INTO `e_upms_role` VALUES (1, 'admin', '管理员', NULL, b'1'); INSERT INTO `e_upms_role` VALUES (2, 'zhiban', '值班', NULL, b'1'); -- ---------------------------- -- 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 = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of e_upms_role_menu -- ---------------------------- INSERT INTO `e_upms_role_menu` VALUES (1, 1); INSERT INTO `e_upms_role_menu` VALUES (1, 2); INSERT INTO `e_upms_role_menu` VALUES (1, 3); INSERT INTO `e_upms_role_menu` VALUES (1, 4); INSERT INTO `e_upms_role_menu` VALUES (1, 5); INSERT INTO `e_upms_role_menu` VALUES (1, 6); INSERT INTO `e_upms_role_menu` VALUES (1, 7); INSERT INTO `e_upms_role_menu` VALUES (1, 9); INSERT INTO `e_upms_role_menu` VALUES (1, 10); INSERT INTO `e_upms_role_menu` VALUES (1, 11); INSERT INTO `e_upms_role_menu` VALUES (1, 12); INSERT INTO `e_upms_role_menu` VALUES (1, 13); INSERT INTO `e_upms_role_menu` VALUES (1, 14); INSERT INTO `e_upms_role_menu` VALUES (1, 17); INSERT INTO `e_upms_role_menu` VALUES (1, 18); INSERT INTO `e_upms_role_menu` VALUES (1, 19); INSERT INTO `e_upms_role_menu` VALUES (1, 20); INSERT INTO `e_upms_role_menu` VALUES (1, 30); INSERT INTO `e_upms_role_menu` VALUES (2, 30); INSERT INTO `e_upms_role_menu` VALUES (1, 31); INSERT INTO `e_upms_role_menu` VALUES (2, 31); INSERT INTO `e_upms_role_menu` VALUES (1, 32); INSERT INTO `e_upms_role_menu` VALUES (2, 32); INSERT INTO `e_upms_role_menu` VALUES (1, 33); INSERT INTO `e_upms_role_menu` VALUES (2, 33); INSERT INTO `e_upms_role_menu` VALUES (1, 34); INSERT INTO `e_upms_role_menu` VALUES (2, 34); INSERT INTO `e_upms_role_menu` VALUES (1, 35); INSERT INTO `e_upms_role_menu` VALUES (2, 35); INSERT INTO `e_upms_role_menu` VALUES (1, 36); INSERT INTO `e_upms_role_menu` VALUES (2, 36); -- ---------------------------- -- 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 utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `is_admin` bit(1) NULL DEFAULT NULL, `is_md5` bit(1) NULL DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `remark` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `status` bit(1) NULL DEFAULT NULL, `white_ip` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_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 = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of e_upms_user -- ---------------------------- INSERT INTO `e_upms_user` VALUES (1, '2021-11-02 11:03:04', NULL, 'erupt', NULL, b'1', b'1', 'erupt', '610d44f73b7709169e8e06ca4ac5af8e', NULL, NULL, b'1', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `e_upms_user` VALUES (2, '2021-11-02 22:06:42', NULL, 'admin', NULL, b'0', b'1', '管理员', 'cf326eab71f8cd878a892dd164068209', NULL, NULL, b'1', NULL, 1, NULL, NULL, 2, NULL); INSERT INTO `e_upms_user` VALUES (3, '2021-11-02 22:08:43', NULL, 'zhiban1', NULL, b'0', b'1', '值班1', 'cf326eab71f8cd878a892dd164068209', NULL, NULL, b'1', NULL, 1, NULL, NULL, 3, 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 = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of e_upms_user_role -- ---------------------------- INSERT INTO `e_upms_user_role` VALUES (2, 1); INSERT INTO `e_upms_user_role` VALUES (3, 2); SET FOREIGN_KEY_CHECKS = 1;