From 3167d838a6446283a8978cece82ea60071b65ca0 Mon Sep 17 00:00:00 2001
From: Admin <Admin@ADMIN>
Date: 星期四, 15 一月 2026 08:53:30 +0800
Subject: [PATCH] 最新

---
 项目代码/DB/jm_widesea_zlwms1-15.sql |  163 ++++++++++++++++++++++++++++++------------------------
 1 files changed, 90 insertions(+), 73 deletions(-)

diff --git "a/\351\241\271\347\233\256\344\273\243\347\240\201/DB/jm_widesea_zlwms.sql" "b/\351\241\271\347\233\256\344\273\243\347\240\201/DB/jm_widesea_zlwms1-15.sql"
similarity index 98%
rename from "\351\241\271\347\233\256\344\273\243\347\240\201/DB/jm_widesea_zlwms.sql"
rename to "\351\241\271\347\233\256\344\273\243\347\240\201/DB/jm_widesea_zlwms1-15.sql"
index b17e9c7..4ff89c7 100644
--- "a/\351\241\271\347\233\256\344\273\243\347\240\201/DB/jm_widesea_zlwms.sql"
+++ "b/\351\241\271\347\233\256\344\273\243\347\240\201/DB/jm_widesea_zlwms1-15.sql"
@@ -11,7 +11,7 @@
  Target Server Version : 80026
  File Encoding         : 65001
 
- Date: 14/01/2026 10:05:59
+ Date: 15/01/2026 08:52:20
 */
 
 SET NAMES utf8mb4;
@@ -76,7 +76,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '瀹℃壒娴佺▼琛�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '瀹℃壒娴佺▼琛�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_approvalflow
@@ -98,7 +98,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '瀹℃壒鑺傜偣琛�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '瀹℃壒鑺傜偣琛�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_approvalnode
@@ -123,7 +123,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '瀹℃壒浠诲姟琛�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '瀹℃壒浠诲姟琛�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_approvaltask
@@ -155,7 +155,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`CheckOrderId`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '璐ㄦ鍗�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '璐ㄦ鍗�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_checkorder
@@ -177,7 +177,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '妫�楠岀粨鏋�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '妫�楠岀粨鏋�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_checkorderresult
@@ -202,7 +202,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '缂栫爜鐢熸垚瑙勫垯閰嶇疆' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '缂栫爜鐢熸垚瑙勫垯閰嶇疆' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_coderuleconfig
@@ -223,7 +223,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '瀹㈡埛淇℃伅' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '瀹㈡埛淇℃伅' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_customerinfo
@@ -248,7 +248,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍏ュ簱鍗�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍏ュ簱鍗�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_inboundorder
@@ -276,7 +276,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍏ュ簱鍗曞巻鍙�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍏ュ簱鍗曞巻鍙�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_inboundorder_hty
@@ -304,7 +304,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍏ュ簱鍗曟槑缁�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍏ュ簱鍗曟槑缁�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_inboundorderdetail
@@ -335,7 +335,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍏ュ簱鍗曟槑缁�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍏ュ簱鍗曟槑缁�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_inboundorderdetail_hty
@@ -364,7 +364,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '璐т綅淇℃伅' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 9498 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '璐т綅淇℃伅' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_locationinfo
@@ -5022,7 +5022,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '璐т綅鐘舵�佸彉鍔ㄨ褰�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '璐т綅鐘舵�佸彉鍔ㄨ褰�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_locationstatuschangerecord
@@ -5046,7 +5046,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鐗╂枡鐮佷俊鎭�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鐗╂枡鐮佷俊鎭�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_materielcodeinfo
@@ -5081,7 +5081,7 @@
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE,
   UNIQUE INDEX `unique_materielinfo_materielcode`(`MaterielCode`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鐗╂枡淇℃伅' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鐗╂枡淇℃伅' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_materielinfo
@@ -5113,7 +5113,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_mesoutboundorder
@@ -5133,7 +5133,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鑺傜偣璺宠浆琛�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鑺傜偣璺宠浆琛�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_nodetransition
@@ -5159,7 +5159,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍑哄簱鍗�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍑哄簱鍗�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_outboundorder
@@ -5188,7 +5188,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍑哄簱鍗�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍑哄簱鍗�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_outboundorder_hty
@@ -5216,7 +5216,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍑哄簱鍗曟槑缁�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍑哄簱鍗曟槑缁�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_outboundorderdetail
@@ -5247,7 +5247,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍑哄簱鍗曟槑缁�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍑哄簱鍗曟槑缁�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_outboundorderdetail_hty
@@ -5279,7 +5279,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍑哄簱璇︽儏' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍑哄簱璇︽儏' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_outstocklockinfo
@@ -5303,7 +5303,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鎵樼洏缂栧彿淇℃伅' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鎵樼洏缂栧彿淇℃伅' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_palletcodeinfo
@@ -5331,7 +5331,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鎵樼洏绫诲瀷' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鎵樼洏绫诲瀷' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_pallettypeinfo
@@ -5355,7 +5355,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '閲囪喘鍗�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '閲囪喘鍗�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_purchaseorder
@@ -5380,7 +5380,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '閲囪喘鍗曟槑缁�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '閲囪喘鍗曟槑缁�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_purchaseorderdetail
@@ -5407,7 +5407,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`ReceiveOrderId`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鏀惰揣鍗�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鏀惰揣鍗�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_receiveorder
@@ -5437,7 +5437,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鏀惰揣鍗曟槑缁�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鏀惰揣鍗曟槑缁�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_receiveorderdetail
@@ -5448,18 +5448,18 @@
 -- ----------------------------
 DROP TABLE IF EXISTS `dt_roadwayinfo`;
 CREATE TABLE `dt_roadwayinfo`  (
-  `Id` int(0) NOT NULL COMMENT '涓婚敭',
-  `RoadwayNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '宸烽亾缂栧彿',
-  `AreaId` int(0) NOT NULL COMMENT '浠撳簱涓婚敭',
-  `EnableStatus` int(0) NOT NULL COMMENT '绂佺敤鐘舵��',
-  `DeviceNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '璁惧缂栧彿',
-  `InStationCode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '鍏ュ簱绔欏彴缂栧彿',
-  `InSCStationCode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '鍫嗗灈鏈哄叆搴撶珯鍙扮紪鍙�',
-  `OutStationCode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '鍑哄簱绔欏彴缂栧彿',
-  `OutSCStationCode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '鍫嗗灈鏈哄嚭搴撶珯鍙扮紪鍙�',
+  `Id` int(0) NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
+  `RoadwayNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宸烽亾缂栧彿',
+  `AreaId` int(0) NULL DEFAULT NULL COMMENT '浠撳簱涓婚敭',
+  `EnableStatus` int(0) NULL DEFAULT NULL COMMENT '绂佺敤鐘舵��',
+  `DeviceNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '璁惧缂栧彿',
+  `InStationCode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鍏ュ簱绔欏彴缂栧彿',
+  `InSCStationCode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鍫嗗灈鏈哄叆搴撶珯鍙扮紪鍙�',
+  `OutStationCode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鍑哄簱绔欏彴缂栧彿',
+  `OutSCStationCode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鍫嗗灈鏈哄嚭搴撶珯鍙扮紪鍙�',
   `Remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '澶囨敞',
-  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '鍒涘缓鑰�',
-  `CreateDate` datetime(0) NOT NULL COMMENT '鍒涘缓鏃堕棿',
+  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鍒涘缓鑰�',
+  `CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
@@ -5468,12 +5468,29 @@
 -- ----------------------------
 -- Records of dt_roadwayinfo
 -- ----------------------------
-INSERT INTO `dt_roadwayinfo` VALUES (1, '1', 2, 0, 'SC01', '杈撻�佺嚎鍏ュ簱缂栧彿', 'YMYL00103700220', '杈撻�佺嚎鍑哄簱绔欏彴', 'YMYL00103700320', NULL, '1', '2026-01-12 17:13:58', '1', '2026-01-12 17:14:03');
-INSERT INTO `dt_roadwayinfo` VALUES (2, '2', 2, 0, 'SC02', '杈撻�佺嚎鍏ュ簱缂栧彿', 'YMYL00103700620', '杈撻�佺嚎鍑哄簱绔欏彴', 'YMYL00103700720', NULL, '1', '2026-01-12 17:15:15', NULL, NULL);
-INSERT INTO `dt_roadwayinfo` VALUES (5, '3', 2, 0, 'SC03', '杈撻�佺嚎鍏ュ簱缂栧彿', 'YMCP00104500306', '杈撻�佺嚎鍑哄簱绔欏彴', 'YMCP00104500206', NULL, '1', '2026-01-12 17:15:41', NULL, NULL);
-INSERT INTO `dt_roadwayinfo` VALUES (6, '4', 2, 0, 'SC04', '杈撻�佺嚎鍏ュ簱缂栧彿', 'YMCP00104500706', '杈撻�佺嚎鍑哄簱绔欏彴', 'YMCP00104500606', NULL, '1', '2026-01-12 17:15:58', NULL, NULL);
-INSERT INTO `dt_roadwayinfo` VALUES (7, '5', 2, 0, 'SC05', '杈撻�佺嚎鍏ュ簱缂栧彿', 'YMCP00104501006', '杈撻�佺嚎鍑哄簱绔欏彴', 'YMCP00104500906', NULL, '1', '2026-01-12 17:16:12', NULL, NULL);
-INSERT INTO `dt_roadwayinfo` VALUES (8, '6', 2, 0, 'SC06', '杈撻�佺嚎鍏ュ簱缂栧彿', '鍫嗗灈鏈哄叆搴撶珯鍙扮紪鍙�', '杈撻�佺嚎鍑哄簱绔欏彴', '鍫嗗灈鏈哄嚭搴撶珯鍙扮紪鍙�', NULL, '1', '2026-01-12 17:16:30', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (1, '1', 1, 0, 'SC01', '1108', 'YMYL00103700220', '1105', 'YMYL00103700320', NULL, '1', '2026-01-12 17:13:58', '1', '2026-01-12 17:14:03');
+INSERT INTO `dt_roadwayinfo` VALUES (2, '2', 1, 0, 'SC02', '1112', 'YMYL00103700620', '1109', 'YMYL00103700720', NULL, '1', '2026-01-12 17:15:15', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (5, '3', 2, 0, 'SC03', '1211', 'YMCP00104500306', '1210', 'YMCP00104500206', NULL, '1', '2026-01-12 17:15:41', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (6, '4', 2, 0, 'SC04', '1213', 'YMCP00104500706', '1212', 'YMCP00104500606', NULL, '1', '2026-01-12 17:15:58', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (7, '5', 2, 0, 'SC05', '1215', 'YMCP00104501006', '1214', 'YMCP00104500906', NULL, '1', '2026-01-12 17:16:12', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (8, '鎴愬搧鍏ュ簱鍙�', 2, 0, 'PLC', '1202', NULL, NULL, NULL, '鎴愬搧鍏ュ簱鍙�', '1', '2026-01-14 10:22:39', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (9, '浜х嚎鎴愬搧鍏ュ簱鍙�', 2, 0, 'PLC', '1205', NULL, NULL, NULL, '浜х嚎鎴愬搧鍏ュ簱鍙�', '1', '2026-01-14 10:24:41', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (10, '鍑哄簱鍙ｅ嚭搴撳彛', 2, 0, 'PLC', '1201', NULL, NULL, NULL, '鎴愬搧鍑哄簱鍙�', '1', '2026-01-14 10:25:12', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (11, '鍑哄簱鍙ｅ嚭搴撳彛', 2, 0, 'PLC', '1203', NULL, NULL, NULL, '鎴愬搧鍑哄簱鍙�', '1', '2026-01-14 10:25:50', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (12, '浜х嚎鎴愬搧鍑哄簱鍙�', 2, 0, 'PLC', '1204', NULL, NULL, NULL, '浜х嚎鎴愬搧鍑哄簱鍙�', '1', '2026-01-14 10:26:42', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (13, '鍘熸潗鏂欏嚭鍏ュ簱鍙�', 1, 0, 'PLC', '1101', NULL, '1101', NULL, '鍘熸潗鏂欏嚭鍏ュ簱鍙�', '1', '2026-01-14 10:33:18', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (14, '鍘熸潗鏂欏嚭鍏ュ簱鍙�', 1, 0, 'PLC', '1103', NULL, '1103', NULL, '鍘熸潗鏂欏嚭鍏ュ簱鍙�', '1', '2026-01-14 10:35:53', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (15, '浜х嚎鍑哄叆搴撳彛', 1, 0, 'PLC', '1113', NULL, '1113', NULL, '浜х嚎鍑哄叆搴撳彛', '1', '2026-01-14 10:35:55', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (16, '浜х嚎鍑哄叆搴撳彛', 1, 0, 'PLC', '1114', NULL, '1114', NULL, '浜х嚎鍑哄叆搴撳彛', '1', '2026-01-14 10:35:55', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (17, '浜х嚎鍑哄叆搴撳彛', 1, 0, 'PLC', '1115', NULL, '1115', NULL, '浜х嚎鍑哄叆搴撳彛', '1', '2026-01-14 10:35:55', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (18, '浜х嚎鍑哄叆搴撳彛', 1, 0, 'PLC', '1116', NULL, '1116', NULL, '浜х嚎鍑哄叆搴撳彛', '1', '2026-01-14 10:35:55', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (19, '浜х嚎鍑哄叆搴撳彛', 1, 0, 'PLC', '1117', NULL, '1117', NULL, '浜х嚎鍑哄叆搴撳彛', '1', '2026-01-14 10:35:55', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (20, '浜х嚎鍑哄叆搴撳彛', 1, 0, 'PLC', '1118', NULL, '1118', NULL, '浜х嚎鍑哄叆搴撳彛', '1', '2026-01-14 10:35:55', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (21, '浜х嚎鍑哄叆搴撳彛', 1, 0, 'PLC', '1119', NULL, '1119', NULL, '浜х嚎鍑哄叆搴撳彛', '1', '2026-01-14 10:35:55', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (22, '浜х嚎鍑哄叆搴撳彛', 1, 0, 'PLC', '1120', NULL, '1120', NULL, '浜х嚎鍑哄叆搴撳彛', '1', '2026-01-14 10:35:55', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (23, '浜х嚎鍑哄叆搴撳彛', 1, 0, 'PLC', '1121', NULL, '1121', NULL, '浜х嚎鍑哄叆搴撳彛', '1', '2026-01-14 10:35:55', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (24, '浜х嚎鍑哄叆搴撳彛', 1, 0, 'PLC', '1122', NULL, '1122', NULL, '浜х嚎鍑哄叆搴撳彛', '1', '2026-01-14 10:35:55', NULL, NULL);
+INSERT INTO `dt_roadwayinfo` VALUES (25, '寮傚父鍑哄簱鍙�', 1, 0, 'PLC', '1123', NULL, '1123', NULL, '寮傚父鍑哄簱鍙�', '1', '2026-01-14 10:35:55', NULL, NULL);
 
 -- ----------------------------
 -- Table structure for dt_stockinfo
@@ -5481,9 +5498,9 @@
 DROP TABLE IF EXISTS `dt_stockinfo`;
 CREATE TABLE `dt_stockinfo`  (
   `Id` int(0) NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
-  `PalletCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '鎵樼洏缂栧彿',
-  `PalletType` int(0) NOT NULL COMMENT '鎵樼洏绫诲瀷',
-  `LocationCode` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '璐т綅缂栧彿',
+  `PalletCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '鎵樼洏缂栧彿',
+  `PalletType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '鎵樼洏绫诲瀷',
+  `LocationCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '璐т綅缂栧彿',
   `WarehouseId` int(0) NOT NULL COMMENT '浠撳簱涓婚敭',
   `StockStatus` int(0) NOT NULL COMMENT '搴撳瓨鐘舵��',
   `Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '澶囨敞',
@@ -5492,7 +5509,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '搴撳瓨淇℃伅' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '搴撳瓨淇℃伅' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_stockinfo
@@ -5518,7 +5535,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '搴撳瓨淇℃伅' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '搴撳瓨淇℃伅' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_stockinfo_hty
@@ -5549,7 +5566,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '搴撳瓨淇℃伅鏄庣粏' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '搴撳瓨淇℃伅鏄庣粏' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_stockinfodetail
@@ -5583,7 +5600,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '搴撳瓨淇℃伅鏄庣粏鍘嗗彶' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '搴撳瓨淇℃伅鏄庣粏鍘嗗彶' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_stockinfodetail_hty
@@ -5613,7 +5630,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '搴撳瓨鍙樺姩淇℃伅璁板綍' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '搴撳瓨鍙樺姩淇℃伅璁板綍' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_stockquantitychangerecord
@@ -5640,7 +5657,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '渚涘簲鍟嗕俊鎭�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '渚涘簲鍟嗕俊鎭�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_supplierinfo
@@ -5654,16 +5671,16 @@
   `TaskId` int(0) NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
   `TaskNum` int(0) NOT NULL COMMENT '浠诲姟鍙�',
   `PalletCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '鎵樼洏缂栧彿',
-  `PalletType` int(0) NOT NULL COMMENT '鎵樼洏绫诲瀷',
+  `PalletType` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '鎵樼洏绫诲瀷',
   `Roadway` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '宸烽亾鍙�',
   `TaskType` int(0) NOT NULL COMMENT '浠诲姟绫诲瀷',
   `TaskStatus` int(0) NOT NULL COMMENT '浠诲姟鐘舵��',
   `SourceAddress` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '璧峰鍦板潃',
-  `TargetAddress` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '鐩爣鍦板潃',
+  `TargetAddress` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐩爣鍦板潃',
   `CurrentAddress` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '褰撳墠浣嶇疆',
   `NextAddress` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '涓嬩竴鍦板潃',
   `WarehouseId` int(0) NOT NULL COMMENT '浠撳簱涓婚敭',
-  `OrderNo` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鍗曟嵁缂栧彿',
+  `OrderNo` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鍗曟嵁缂栧彿',
   `Grade` int(0) NOT NULL COMMENT '浼樺厛绾�',
   `Dispatchertime` datetime(0) NULL DEFAULT NULL COMMENT '浠诲姟涓嬪彂鏃堕棿',
   `Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '澶囨敞',
@@ -5673,7 +5690,7 @@
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`TaskId`) USING BTREE,
   UNIQUE INDEX `unique_task_taskNum`(`TaskNum`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '浠诲姟淇℃伅' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '浠诲姟淇℃伅' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_task
@@ -5708,7 +5725,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`TaskId`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '浠诲姟淇℃伅鍘嗗彶' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '浠诲姟淇℃伅鍘嗗彶' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_task_hty
@@ -5731,7 +5748,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍛樺伐淇℃伅' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鍛樺伐淇℃伅' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_userinfo
@@ -5745,7 +5762,7 @@
   `WarehouseId` int(0) NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
   `WarehouseCode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '浠撳簱缂栧彿',
   `WarehouseName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '浠撳簱鍚嶇О',
-  `WarehouseType` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '浠撳簱绫诲瀷',
+  `WarehouseType` int(0) NOT NULL COMMENT '浠撳簱绫诲瀷',
   `WarehouseStatus` int(0) NOT NULL COMMENT '浠撳簱鐘舵��',
   `WarehouseDes` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '浠撳簱鎻忚堪',
   `Remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '澶囨敞',
@@ -5754,13 +5771,13 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`WarehouseId`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '浠撳簱淇℃伅' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '浠撳簱淇℃伅' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of dt_warehouse
 -- ----------------------------
-INSERT INTO `dt_warehouse` VALUES (1, 'YL001', '鍘熸潗鏂欎粨搴�', '1', 0, '1', '1', '1', '2026-01-14 09:36:56', NULL, NULL);
-INSERT INTO `dt_warehouse` VALUES (2, 'CP001', '鎴愬搧浠�', '2', 0, '1', '1', '1', '2026-01-14 09:37:22', NULL, NULL);
+INSERT INTO `dt_warehouse` VALUES (1, 'YL001', '鍘熸潗鏂欎粨搴�', 1, 0, '1', '1', '1', '2026-01-14 09:36:56', NULL, NULL);
+INSERT INTO `dt_warehouse` VALUES (2, 'CP001', '鎴愬搧浠�', 2, 0, '1', '1', '1', '2026-01-14 09:37:22', NULL, NULL);
 
 -- ----------------------------
 -- Table structure for sys_dictionary
@@ -5781,7 +5798,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`DicId`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '瀛楀吀鏁版嵁' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 82 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '瀛楀吀鏁版嵁' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of sys_dictionary
@@ -5821,7 +5838,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`DicListId`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '瀛楀吀鏄庣粏' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 460 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '瀛楀吀鏄庣粏' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of sys_dictionarylist
@@ -5884,7 +5901,7 @@
   `UserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐢ㄦ埛鍚嶇О',
   `UserId` int(0) NULL DEFAULT NULL COMMENT '鐢ㄦ埛涓婚敭',
   PRIMARY KEY (`Id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鎺ュ彛鏃ュ織' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鎺ュ彛鏃ュ織' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of sys_log
@@ -5911,7 +5928,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`MenuId`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鑿滃崟閰嶇疆' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 59 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鑿滃崟閰嶇疆' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of sys_menu
@@ -5974,7 +5991,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`RoleId`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '瑙掕壊琛�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '瑙掕壊琛�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of sys_role
@@ -5996,7 +6013,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`AuthId`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '瑙掕壊韬唤楠岃瘉绠＄悊' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 159 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '瑙掕壊韬唤楠岃瘉绠＄悊' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of sys_roleauth
@@ -6034,7 +6051,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`TenantId`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '绉熸埛' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '绉熸埛' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of sys_tenant
@@ -6068,7 +6085,7 @@
   `Modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '淇敼浜�',
   `ModifyDate` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃ユ湡',
   PRIMARY KEY (`UserId`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鐢ㄦ埛琛�' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鐢ㄦ埛琛�' ROW_FORMAT = Dynamic;
 
 -- ----------------------------
 -- Records of sys_user

--
Gitblit v1.9.3