From 6876084ffc4a01c1eca6a609dec8c176efc59aae Mon Sep 17 00:00:00 2001
From: zhang <zc857179121@qq.com>
Date: 星期四, 22 一月 2026 15:16:45 +0800
Subject: [PATCH] 1
---
zy-acs-cv/src/main/resources/wcs.sql | 116 ++++++++++++++++++++++++++++++---------------------------
1 files changed, 61 insertions(+), 55 deletions(-)
diff --git a/zy-acs-cv/src/main/resources/wcs.sql b/zy-acs-cv/src/main/resources/wcs.sql
index 580fef0..69ad83c 100644
--- a/zy-acs-cv/src/main/resources/wcs.sql
+++ b/zy-acs-cv/src/main/resources/wcs.sql
@@ -15,34 +15,36 @@
*/
SET NAMES utf8mb4;
-SET FOREIGN_KEY_CHECKS = 0;
+SET
+FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for cv_devp
-- ----------------------------
DROP TABLE IF EXISTS `cv_devp`;
-CREATE TABLE `cv_devp` (
- `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
- `dev_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '缂栧彿',
- `dec_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鍚嶇О(*)',
- `in_enable` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鍙叆',
- `out_enable` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鍙嚭',
- `autoing` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鑷姩',
- `loading` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鏈夌墿',
- `canining` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鑳藉叆',
- `canouting` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鑳藉嚭',
- `wrk_no` int(11) NULL DEFAULT NULL COMMENT '宸ヤ綔鍙�',
- `barcode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鏉＄爜',
- `loc_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '搴撲綅绫诲瀷',
- `status` int(1) NOT NULL DEFAULT 1 COMMENT '鐘舵�亄1:姝ｅ父,0:鍐荤粨}',
- `deleted` int(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎{1:鏄�,0:鍚',
- `tenant_id` bigint(20) NULL DEFAULT NULL COMMENT '绉熸埛[sys_tenant]',
- `create_by` bigint(20) NULL DEFAULT NULL COMMENT '娣诲姞浜哄憳[sys_user]',
- `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '娣诲姞鏃堕棿',
- `update_by` bigint(20) NULL DEFAULT NULL COMMENT '淇敼浜哄憳[sys_user]',
- `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
- `memo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '澶囨敞',
- PRIMARY KEY (`id`) USING BTREE
+CREATE TABLE `cv_devp`
+(
+ `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
+ `dev_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '缂栧彿',
+ `dec_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鍚嶇О(*)',
+ `in_enable` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鍙叆',
+ `out_enable` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鍙嚭',
+ `autoing` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鑷姩',
+ `loading` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鏈夌墿',
+ `canining` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鑳藉叆',
+ `canouting` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鑳藉嚭',
+ `wrk_no` int(11) NULL DEFAULT NULL COMMENT '宸ヤ綔鍙�',
+ `barcode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鏉＄爜',
+ `loc_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '搴撲綅绫诲瀷',
+ `status` int(1) NOT NULL DEFAULT 1 COMMENT '鐘舵�亄1:姝ｅ父,0:鍐荤粨}',
+ `deleted` int(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎{1:鏄�,0:鍚',
+ `tenant_id` bigint(20) NULL DEFAULT NULL COMMENT '绉熸埛[sys_tenant]',
+ `create_by` bigint(20) NULL DEFAULT NULL COMMENT '娣诲姞浜哄憳[sys_user]',
+ `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '娣诲姞鏃堕棿',
+ `update_by` bigint(20) NULL DEFAULT NULL COMMENT '淇敼浜哄憳[sys_user]',
+ `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
+ `memo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '澶囨敞',
+ PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
@@ -53,21 +55,22 @@
-- Table structure for cv_job
-- ----------------------------
DROP TABLE IF EXISTS `cv_job`;
-CREATE TABLE `cv_job` (
- `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
- `seq_num` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '缂栧彿',
- `work_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '鍚嶇О(*)',
- `job_sts` int(11) NULL DEFAULT 1 COMMENT '浠诲姟鐘舵��',
- `status` int(1) NOT NULL DEFAULT 1 COMMENT '鐘舵�亄1:姝ｅ父,0:鍐荤粨}',
- `deleted` int(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎{1:鏄�,0:鍚',
- `tenant_id` bigint(20) NULL DEFAULT NULL COMMENT '绉熸埛[sys_tenant]',
- `create_by` bigint(20) NULL DEFAULT NULL COMMENT '娣诲姞浜哄憳[sys_user]',
- `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '娣诲姞鏃堕棿',
- `update_by` bigint(20) NULL DEFAULT NULL COMMENT '淇敼浜哄憳[sys_user]',
- `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
- `memo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '澶囨敞',
- PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `uq_cv_job_seq_num`(`seq_num`) USING BTREE
+CREATE TABLE `cv_job`
+(
+ `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
+ `seq_num` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '缂栧彿',
+ `work_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '鍚嶇О(*)',
+ `job_sts` int(11) NULL DEFAULT 1 COMMENT '浠诲姟鐘舵��',
+ `status` int(1) NOT NULL DEFAULT 1 COMMENT '鐘舵�亄1:姝ｅ父,0:鍐荤粨}',
+ `deleted` int(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎{1:鏄�,0:鍚',
+ `tenant_id` bigint(20) NULL DEFAULT NULL COMMENT '绉熸埛[sys_tenant]',
+ `create_by` bigint(20) NULL DEFAULT NULL COMMENT '娣诲姞浜哄憳[sys_user]',
+ `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '娣诲姞鏃堕棿',
+ `update_by` bigint(20) NULL DEFAULT NULL COMMENT '淇敼浜哄憳[sys_user]',
+ `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
+ `memo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '澶囨敞',
+ PRIMARY KEY (`id`) USING BTREE,
+ UNIQUE INDEX `uq_cv_job_seq_num`(`seq_num`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
@@ -78,26 +81,29 @@
-- Table structure for cv_work_lastno
-- ----------------------------
DROP TABLE IF EXISTS `cv_work_lastno`;
-CREATE TABLE `cv_work_lastno` (
- `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
- `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '缂栧彿',
- `wrk_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '褰撳墠宸ヤ綔鍙�',
- `s_no` int(11) NULL DEFAULT NULL COMMENT '璧峰宸ヤ綔鍙�',
- `e_no` int(11) NULL DEFAULT NULL COMMENT '缁撴潫宸ヤ綔鍙�',
- `status` int(1) NOT NULL DEFAULT 1 COMMENT '鐘舵�亄1:姝ｅ父,0:鍐荤粨}',
- `deleted` int(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎{1:鏄�,0:鍚',
- `tenant_id` bigint(20) NULL DEFAULT NULL COMMENT '绉熸埛[sys_tenant]',
- `create_by` bigint(20) NULL DEFAULT NULL COMMENT '娣诲姞浜哄憳[sys_user]',
- `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '娣诲姞鏃堕棿',
- `update_by` bigint(20) NULL DEFAULT NULL COMMENT '淇敼浜哄憳[sys_user]',
- `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
- `memo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '澶囨敞',
- PRIMARY KEY (`id`) USING BTREE
+CREATE TABLE `cv_work_lastno`
+(
+ `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
+ `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '缂栧彿',
+ `wrk_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '褰撳墠宸ヤ綔鍙�',
+ `s_no` int(11) NULL DEFAULT NULL COMMENT '璧峰宸ヤ綔鍙�',
+ `e_no` int(11) NULL DEFAULT NULL COMMENT '缁撴潫宸ヤ綔鍙�',
+ `status` int(1) NOT NULL DEFAULT 1 COMMENT '鐘舵�亄1:姝ｅ父,0:鍐荤粨}',
+ `deleted` int(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎{1:鏄�,0:鍚',
+ `tenant_id` bigint(20) NULL DEFAULT NULL COMMENT '绉熸埛[sys_tenant]',
+ `create_by` bigint(20) NULL DEFAULT NULL COMMENT '娣诲姞浜哄憳[sys_user]',
+ `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '娣诲姞鏃堕棿',
+ `update_by` bigint(20) NULL DEFAULT NULL COMMENT '淇敼浜哄憳[sys_user]',
+ `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
+ `memo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '澶囨敞',
+ PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of cv_work_lastno
-- ----------------------------
-INSERT INTO `cv_work_lastno` VALUES (1, '1', '1', 1, 9990, 1, 0, NULL, NULL, '2026-01-20 08:15:11', NULL, '2026-01-20 08:15:11', NULL);
+INSERT INTO `cv_work_lastno`
+VALUES (1, '1', '1', 1, 9990, 1, 0, NULL, NULL, '2026-01-20 08:15:11', NULL, '2026-01-20 08:15:11', NULL);
-SET FOREIGN_KEY_CHECKS = 1;
+SET
+FOREIGN_KEY_CHECKS = 1;
--
Gitblit v1.9.1