From f2bc4b93d1291c1f193b3a830418904eb6ef37ed Mon Sep 17 00:00:00 2001 From: zhuguifei <312353457@qq.com> Date: 星期一, 24 二月 2025 14:37:05 +0800 Subject: [PATCH] 更新数据库 --- eims/script/sql/eims-20250224.sql | 56 +++++++++++++++++--------------------------------------- 1 files changed, 17 insertions(+), 39 deletions(-) diff --git a/eims/script/sql/eims-20250224.sql b/eims/script/sql/eims-20250224.sql index 25d2497..0df4934 100644 --- a/eims/script/sql/eims-20250224.sql +++ b/eims/script/sql/eims-20250224.sql @@ -11,7 +11,7 @@ Target Server Version : 90001 (9.0.1) File Encoding : 65001 - Date: 24/02/2025 09:02:15 + Date: 24/02/2025 14:36:44 */ SET NAMES utf8mb4; @@ -4156,6 +4156,7 @@ `fault_picture` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '鏁呴殰鍥剧墖', `req_type` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '鎶ヤ慨绫诲瀷', `equ_id` bigint DEFAULT NULL COMMENT '璁惧id', + `fixture_id` bigint DEFAULT NULL COMMENT '宸ュ叿id', `repair_id` bigint DEFAULT NULL COMMENT '缁翠慨鍗昳d', `repair_dept` bigint DEFAULT NULL COMMENT '缁翠慨浜洪儴闂�', `repair_user` bigint DEFAULT NULL COMMENT '缁翠慨浜�', @@ -4175,17 +4176,17 @@ -- Records of eims_repair_req -- ---------------------------- BEGIN; -INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889193482098917378, 'WXD202502110001', '1', '2025-02-11 14:03:06', '2025-02-11 14:03:04', 100, 1, '鎬ヤ笉鎬�', '2', NULL, '3', NULL, NULL, NULL, NULL, '2', 103, 1, '2025-02-11 14:03:20', 1, '2025-02-11 14:03:20', NULL); -INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889199026704601089, 'WXD202502110002', '0', '2025-02-11 14:11:51', '2025-02-11 14:11:48', 100, 1, '1212', '1', NULL, '2', NULL, NULL, NULL, NULL, '2', 103, 1, '2025-02-11 14:25:22', 1, '2025-02-11 14:25:22', NULL); -INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889506260404666369, 'BXD202502120002', '0', '2025-02-12 10:46:03', '2025-02-12 10:46:00', 100, 1, '112', '1', NULL, '1', 1000, NULL, NULL, NULL, '1', 103, 1, '2025-02-12 10:46:12', 1, '2025-02-12 10:46:12', NULL); -INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889510345426092033, 'BXD202502120003', '1', '2025-02-12 11:02:07', '2025-02-12 11:02:05', 100, 1, '12', '1', NULL, '1', 1876204236438884354, NULL, NULL, NULL, '2', 103, 1, '2025-02-12 11:02:26', 1, '2025-02-12 11:02:26', NULL); -INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889510920993652738, 'BXD202502120004', '0', '2025-02-12 11:04:31', '2025-02-12 11:04:29', 100, 1, '122', '1', NULL, '2', NULL, NULL, NULL, NULL, '3', 103, 1, '2025-02-12 11:04:44', 1, '2025-02-12 11:04:44', NULL); -INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889511033325502466, 'BXD202502120005', '0', '2025-02-12 11:05:00', '2025-02-12 11:04:58', 100, 1, '122', '1', NULL, '1', 1878988394319949826, NULL, NULL, NULL, '1', 103, 1, '2025-02-12 11:05:10', 1, '2025-02-12 11:05:10', NULL); -INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889595038951645185, 'BXD202502120006', '0', '2025-02-12 16:38:45', '2025-02-12 16:38:43', 100, 1889581563890200577, '娉曞浗浼氬敖蹇�', '1', NULL, '1', 1000, NULL, NULL, NULL, '1', 100, 1889581563890200577, '2025-02-12 16:38:59', 1889581563890200577, '2025-02-12 16:38:59', NULL); -INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889595916202909698, 'BXD202502120007', '0', '2025-02-12 16:42:16', '2025-02-12 16:42:14', 100, 1889581563890200577, '1鏄殑鏄殑', '1', NULL, '2', NULL, NULL, NULL, NULL, '1', 100, 1889581563890200577, '2025-02-12 16:42:28', 1889581563890200577, '2025-02-12 16:42:28', NULL); -INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889596045999841281, 'BXD202502120008', '1', '2025-02-12 16:42:46', '2025-02-12 16:42:44', 100, 1889581563890200577, '1瑙勫垝灞�蹇箰瀹㈠璇�', '1', NULL, '1', 1876204236438884354, NULL, NULL, NULL, '1', 100, 1889581563890200577, '2025-02-12 16:42:59', 1889581563890200577, '2025-02-12 16:42:59', NULL); -INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889944971382734849, 'BXD202502130001', '0', '2025-02-13 15:49:15', '2025-02-13 15:49:13', 100, 1889581563890200577, 'fghjkl', '1', NULL, '1', 1889937933705527297, NULL, NULL, NULL, '1', 103, 1, '2025-02-13 15:49:29', 1, '2025-02-13 15:49:29', NULL); -INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1891772592350588929, 'BXD202502180001', '0', '2025-02-18 16:51:35', '2025-02-18 16:51:32', 103, 1891772104536256514, '鍙戠儹绠′細灏藉揩', '1', NULL, '1', 1890217827130769409, NULL, NULL, NULL, '1', 103, 1, '2025-02-18 16:51:48', 1, '2025-02-18 16:51:48', NULL); +INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `fixture_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889193482098917378, 'WXD202502110001', '1', '2025-02-11 14:03:06', '2025-02-11 14:03:04', 100, 1, '鎬ヤ笉鎬�', '2', NULL, '3', NULL, NULL, NULL, NULL, NULL, '2', 103, 1, '2025-02-11 14:03:20', 1, '2025-02-11 14:03:20', NULL); +INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `fixture_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889199026704601089, 'WXD202502110002', '0', '2025-02-11 14:11:51', '2025-02-11 14:11:48', 100, 1, '1212', '1', NULL, '2', NULL, NULL, NULL, NULL, NULL, '2', 103, 1, '2025-02-11 14:25:22', 1, '2025-02-11 14:25:22', NULL); +INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `fixture_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889506260404666369, 'BXD202502120002', '0', '2025-02-12 10:46:03', '2025-02-12 10:46:00', 100, 1, '112', '1', NULL, '1', 1000, NULL, NULL, NULL, NULL, '1', 103, 1, '2025-02-12 10:46:12', 1, '2025-02-12 10:46:12', NULL); +INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `fixture_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889510345426092033, 'BXD202502120003', '1', '2025-02-12 11:02:07', '2025-02-12 11:02:05', 100, 1, '12', '1', NULL, '1', 1876204236438884354, NULL, NULL, NULL, NULL, '2', 103, 1, '2025-02-12 11:02:26', 1, '2025-02-12 11:02:26', NULL); +INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `fixture_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889510920993652738, 'BXD202502120004', '0', '2025-02-12 11:04:31', '2025-02-12 11:04:29', 100, 1, '122', '1', NULL, '2', NULL, NULL, NULL, NULL, NULL, '3', 103, 1, '2025-02-12 11:04:44', 1, '2025-02-12 11:04:44', NULL); +INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `fixture_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889511033325502466, 'BXD202502120005', '0', '2025-02-12 11:05:00', '2025-02-12 11:04:58', 100, 1, '122', '1', NULL, '1', 1878988394319949826, NULL, NULL, NULL, NULL, '1', 103, 1, '2025-02-12 11:05:10', 1, '2025-02-12 11:05:10', NULL); +INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `fixture_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889595038951645185, 'BXD202502120006', '0', '2025-02-12 16:38:45', '2025-02-12 16:38:43', 100, 1889581563890200577, '娉曞浗浼氬敖蹇�', '1', NULL, '1', 1000, NULL, NULL, NULL, NULL, '1', 100, 1889581563890200577, '2025-02-12 16:38:59', 1889581563890200577, '2025-02-12 16:38:59', NULL); +INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `fixture_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889595916202909698, 'BXD202502120007', '0', '2025-02-12 16:42:16', '2025-02-12 16:42:14', 100, 1889581563890200577, '1鏄殑鏄殑', '1', NULL, '2', NULL, NULL, NULL, NULL, NULL, '1', 100, 1889581563890200577, '2025-02-12 16:42:28', 1889581563890200577, '2025-02-12 16:42:28', NULL); +INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `fixture_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889596045999841281, 'BXD202502120008', '1', '2025-02-12 16:42:46', '2025-02-12 16:42:44', 100, 1889581563890200577, '1瑙勫垝灞�蹇箰瀹㈠璇�', '1', NULL, '1', 1876204236438884354, NULL, NULL, NULL, NULL, '1', 100, 1889581563890200577, '2025-02-12 16:42:59', 1889581563890200577, '2025-02-12 16:42:59', NULL); +INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `fixture_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1889944971382734849, 'BXD202502130001', '0', '2025-02-13 15:49:15', '2025-02-13 15:49:13', 100, 1889581563890200577, 'fghjkl', '1', NULL, '1', 1889937933705527297, NULL, NULL, NULL, NULL, '1', 103, 1, '2025-02-13 15:49:29', 1, '2025-02-13 15:49:29', NULL); +INSERT INTO `eims_repair_req` (`id`, `code`, `status`, `occ_time`, `req_time`, `req_dept`, `req_user`, `req_desc`, `urgency_level`, `fault_picture`, `req_type`, `equ_id`, `fixture_id`, `repair_id`, `repair_dept`, `repair_user`, `fault_type`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1891772592350588929, 'BXD202502180001', '0', '2025-02-18 16:51:35', '2025-02-18 16:51:32', 103, 1891772104536256514, '鍙戠儹绠′細灏藉揩', '1', NULL, '1', 1890217827130769409, NULL, NULL, NULL, NULL, '1', 103, 1, '2025-02-18 16:51:48', 1, '2025-02-18 16:51:48', NULL); COMMIT; -- ---------------------------- @@ -6026,6 +6027,9 @@ INSERT INTO `sys_logininfor` (`info_id`, `tenant_id`, `user_name`, `client_key`, `device_type`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (1892451329178238977, '000000', 'admin', 'pc', 'pc', '0:0:0:0:0:0:0:1', '鍐呯綉IP', 'Chrome', 'OSX', '0', '鐧诲綍鎴愬姛', '2025-02-20 13:48:52'); INSERT INTO `sys_logininfor` (`info_id`, `tenant_id`, `user_name`, `client_key`, `device_type`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (1892738557552898050, '000000', 'admin', 'pc', 'pc', '0:0:0:0:0:0:0:1', '鍐呯綉IP', 'Chrome', 'OSX', '0', '鐧诲綍鎴愬姛', '2025-02-21 08:50:12'); INSERT INTO `sys_logininfor` (`info_id`, `tenant_id`, `user_name`, `client_key`, `device_type`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (1893826601552715778, '000000', 'admin', 'pc', 'pc', '0:0:0:0:0:0:0:1', '鍐呯綉IP', 'Chrome', 'OSX', '0', '鐧诲綍鎴愬姛', '2025-02-24 08:53:42'); +INSERT INTO `sys_logininfor` (`info_id`, `tenant_id`, `user_name`, `client_key`, `device_type`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (1893856470588203009, '000000', 'admin', 'pc', 'pc', '0:0:0:0:0:0:0:1', '鍐呯綉IP', 'Chrome', 'OSX', '0', '鐧诲綍鎴愬姛', '2025-02-24 10:52:23'); +INSERT INTO `sys_logininfor` (`info_id`, `tenant_id`, `user_name`, `client_key`, `device_type`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (1893867935617523714, '000000', 'admin', 'pc', 'pc', '0:0:0:0:0:0:0:1', '鍐呯綉IP', 'Chrome', 'OSX', '0', '鐧诲綍鎴愬姛', '2025-02-24 11:37:57'); +INSERT INTO `sys_logininfor` (`info_id`, `tenant_id`, `user_name`, `client_key`, `device_type`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (1893896786347302913, '000000', 'admin', 'pc', 'pc', '0:0:0:0:0:0:0:1', '鍐呯綉IP', 'Chrome', 'OSX', '0', '鐧诲綍鎴愬姛', '2025-02-24 13:32:35'); COMMIT; -- ---------------------------- @@ -7268,7 +7272,7 @@ -- Records of sys_user -- ---------------------------- BEGIN; -INSERT INTO `sys_user` (`user_id`, `tenant_id`, `dept_id`, `user_name`, `nick_name`, `user_type`, `email`, `phonenumber`, `sex`, `avatar`, `password`, `status`, `del_flag`, `login_ip`, `login_date`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, '000000', 103, 'admin', '鐤媯鐨勭嫯瀛怢i', 'sys_user', 'crazyLionLi@163.com', '15888888888', '1', NULL, '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '0:0:0:0:0:0:0:1', '2025-02-24 08:53:42', 103, 1, '2024-12-24 16:54:24', 1, '2025-02-24 08:53:42', '绠$悊鍛�'); +INSERT INTO `sys_user` (`user_id`, `tenant_id`, `dept_id`, `user_name`, `nick_name`, `user_type`, `email`, `phonenumber`, `sex`, `avatar`, `password`, `status`, `del_flag`, `login_ip`, `login_date`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, '000000', 103, 'admin', '鐤媯鐨勭嫯瀛怢i', 'sys_user', 'crazyLionLi@163.com', '15888888888', '1', NULL, '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '0:0:0:0:0:0:0:1', '2025-02-24 13:32:35', 103, 1, '2024-12-24 16:54:24', 1, '2025-02-24 13:32:35', '绠$悊鍛�'); INSERT INTO `sys_user` (`user_id`, `tenant_id`, `dept_id`, `user_name`, `nick_name`, `user_type`, `email`, `phonenumber`, `sex`, `avatar`, `password`, `status`, `del_flag`, `login_ip`, `login_date`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (3, '000000', 108, 'test', '鏈儴闂ㄥ強浠ヤ笅 瀵嗙爜666666', 'sys_user', '', '', '1', NULL, '$2a$10$b8yUzN0C71sbz.PhNOCgJe.Tu1yWC3RNrTyjSQ8p1W0.aaUXUJ.Ne', '0', '2', '0:0:0:0:0:0:0:1', '2024-12-25 18:54:12', 103, 1, '2024-12-24 16:54:24', 1, '2025-02-12 15:46:16', NULL); INSERT INTO `sys_user` (`user_id`, `tenant_id`, `dept_id`, `user_name`, `nick_name`, `user_type`, `email`, `phonenumber`, `sex`, `avatar`, `password`, `status`, `del_flag`, `login_ip`, `login_date`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (4, '000000', 102, 'test1', '浠呮湰浜� 瀵嗙爜666666', 'sys_user', '', '', '0', NULL, '$2a$10$b8yUzN0C71sbz.PhNOCgJe.Tu1yWC3RNrTyjSQ8p1W0.aaUXUJ.Ne', '0', '2', '127.0.0.1', '2024-12-24 16:54:24', 103, 1, '2024-12-24 16:54:24', 1, '2025-02-12 15:46:11', NULL); INSERT INTO `sys_user` (`user_id`, `tenant_id`, `dept_id`, `user_name`, `nick_name`, `user_type`, `email`, `phonenumber`, `sex`, `avatar`, `password`, `status`, `del_flag`, `login_ip`, `login_date`, `create_dept`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1888782469222465537, '000000', 101, 'zhuguifei', 'zhuguifei', 'sys_user', '', '', '0', NULL, '$2a$10$w8HBoQ6jd95Ig8WbHrgRyuOiKx4guC.sNcTd//VudfvJA9.R67M8O', '0', '2', '0:0:0:0:0:0:0:1', '2025-02-10 11:00:26', 103, 1, '2025-02-10 10:50:07', 1, '2025-02-12 15:46:13', NULL); @@ -7316,32 +7320,6 @@ INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES (1889581665270722561, 1889561934287433729); INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES (1889581724095836162, 1889562679283904514); INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES (1892105619105386498, 1889561357813903361); -COMMIT; - --- ---------------------------- --- Table structure for t --- ---------------------------- -DROP TABLE IF EXISTS `t`; -CREATE TABLE `t` ( - `id` int NOT NULL, - `code` int DEFAULT NULL, - `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, - `flag` int DEFAULT NULL, - `d1` double DEFAULT NULL, - `d2` double DEFAULT NULL, - `d3` double DEFAULT NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; - --- ---------------------------- --- Records of t --- ---------------------------- -BEGIN; -INSERT INTO `t` (`id`, `code`, `name`, `flag`, `d1`, `d2`, `d3`) VALUES (1, 2, '灏忛害', 1, 1, 2, 3); -INSERT INTO `t` (`id`, `code`, `name`, `flag`, `d1`, `d2`, `d3`) VALUES (2, 1, '澶х背', 1, 4, 5, 6); -INSERT INTO `t` (`id`, `code`, `name`, `flag`, `d1`, `d2`, `d3`) VALUES (3, 3, '绾㈣柉', 1, 7, 8, 9); -INSERT INTO `t` (`id`, `code`, `name`, `flag`, `d1`, `d2`, `d3`) VALUES (4, 1, '鍗楁柟', 0, 0.1, 0.2, 0.3); -INSERT INTO `t` (`id`, `code`, `name`, `flag`, `d1`, `d2`, `d3`) VALUES (5, 1, '鍖楁柟', 0, 0.4, 0.5, 0.6); COMMIT; -- ---------------------------- -- Gitblit v1.9.3