From 78cc285f739d97d117dd2199649715529c40a199 Mon Sep 17 00:00:00 2001 From: yangys <y_ys79@sina.com> Date: 星期三, 04 六月 2025 15:03:13 +0800 Subject: [PATCH] 修改nacos配置 --- doc/sql/mdm/mdm.all.create.sql | 31 ++++++++++++++++++++----------- 1 files changed, 20 insertions(+), 11 deletions(-) diff --git a/doc/sql/mdm/mdm.all.create.sql b/doc/sql/mdm/mdm.all.create.sql index a0ac7b1..fb6d791 100644 --- a/doc/sql/mdm/mdm.all.create.sql +++ b/doc/sql/mdm/mdm.all.create.sql @@ -1,8 +1,8 @@ CREATE TABLE `mdm_machine_group` ( `id` bigint NOT NULL COMMENT '涓婚敭', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '绉熸埛ID', - `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '鏈哄簥缁勫悕绉�', - `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '鏈哄簥缁勭紪鍙�', + `name` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '鏈哄簥缁勫悕绉�', + `code` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '鏈哄簥缁勭紪鍙�', `create_user` bigint DEFAULT NULL COMMENT '鍒涘缓浜�', `create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓閮ㄩ棬', `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', @@ -11,26 +11,35 @@ `status` int DEFAULT '1' COMMENT '鐘舵��', `is_deleted` int DEFAULT '0' COMMENT '鏄惁宸插垹闄�', PRIMARY KEY (`id`) USING BTREE -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='鏈哄簥缁�'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鏈哄簥缁�'; CREATE TABLE `mdm_machine` ( `id` bigint NOT NULL, `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�', `code` varchar(100) NOT NULL COMMENT '鏈哄簥缂栧彿', - `name` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT '鏈哄簥鍚嶇О', - `avatar` varchar(1000) DEFAULT NULL COMMENT '鍥剧墖鍦板潃', - `machine_group_id` bigint DEFAULT NULL COMMENT '鎵�灞炴満搴婄粍ID', - `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��', + `name` varchar(100) NOT NULL COMMENT '鏈哄簥鎻忚堪/鍨嬪彿', + `avatar` varchar(400) DEFAULT NULL COMMENT '鍥剧墖鍦板潃', + `machine_group_id` bigint NOT NULL COMMENT '鎵�灞炴満搴婄粍ID', + `machine_spec` varchar(20) DEFAULT NULL COMMENT '鏈哄櫒瑙勬牸:01杞﹀簥/02閾ｅ簥,鍦ㄤ笟鍔″瓧鍏搁厤缃紙key=machine_spec锛�', + `operator` varchar(100) COMMENT '鎿嶄綔鍛橈紝鏂囨湰褰曞叆', + `owner_dept` bigint DEFAULT NULL COMMENT '鎵�灞炲崟浣�/缁勭粐', + `manufacturer` varchar(100) COMMENT '鐢熶骇鍟�', + `polling_hours` int(11) COMMENT '妫�鏌ョ▼搴忓洖浼犵殑杞鏃堕棿锛堝皬鏃讹級', + `control_system` varchar(20) DEFAULT NULL COMMENT '鎺у埗绯荤粺锛堝鍙戦偅绉戯級锛屽湪涓氬姟瀛楀吀閰嶇疆(key=machine_controll_system)锛屼娇鐢ㄨ嫳鏂囧瓧姣�', + `prog_send_dir` varchar(100) COMMENT '绋嬪簭涓嬪彂鐩綍', + `prog_receive_dir` varchar(100) COMMENT '绋嬪簭鍥炰紶鐩綍', + `remark` varchar(200) COMMENT '澶囨敞', + `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵�侊紝1锛氬惎鐢紱0绂佺敤', `create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅', `is_deleted` int DEFAULT NULL, `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', `create_user` bigint DEFAULT NULL COMMENT '鍒涘缓浜�', `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿', - `update_user` bigint DEFAULT NULL COMMENT '鏇存柊浜�' + `update_user` bigint DEFAULT NULL COMMENT '鏇存柊浜�', PRIMARY KEY (`id`) USING BTREE, - UNIQUE KEY `uniqueCodeIndex` (`code`,`is_deleted`) USING BTREE, -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='鏈哄簥'; + UNIQUE KEY `uniqueCodeIndex` (`code`,`is_deleted`) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='鏈哄簥'; CREATE TABLE `mdm_nc_program` ( @@ -50,7 +59,7 @@ `update_user` bigint DEFAULT NULL COMMENT '鏇存柊浜�' PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uniqueCodeIndex` (`code`,`is_deleted`) USING BTREE, -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='鏁版帶绋嬪簭'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='鏁版帶绋嬪簭'; CREATE TABLE `mdm_task_receive` ( -- Gitblit v1.9.3