From bad969e058368490346907faa25baa7d73ea6bc1 Mon Sep 17 00:00:00 2001
From: Junjie <540245094@qq.com>
Date: 星期二, 20 八月 2024 16:13:49 +0800
Subject: [PATCH] #任务增加缓存队列
---
zy-asrs-wcs/src/main/resources/sql/任务缓存队列/wcs_task_cache.sql | 39 +++++++++++++++++++++++++++++++++++++++
1 files changed, 39 insertions(+), 0 deletions(-)
diff --git "a/zy-asrs-wcs/src/main/resources/sql/\344\273\273\345\212\241\347\274\223\345\255\230\351\230\237\345\210\227/wcs_task_cache.sql" "b/zy-asrs-wcs/src/main/resources/sql/\344\273\273\345\212\241\347\274\223\345\255\230\351\230\237\345\210\227/wcs_task_cache.sql"
new file mode 100644
index 0000000..fe35a59
--- /dev/null
+++ "b/zy-asrs-wcs/src/main/resources/sql/\344\273\273\345\212\241\347\274\223\345\255\230\351\230\237\345\210\227/wcs_task_cache.sql"
@@ -0,0 +1,39 @@
+/*
+ Navicat Premium Data Transfer
+
+ Source Server : 127.0.0.1_mysql
+ Source Server Type : MySQL
+ Source Server Version : 50730
+ Source Host : 127.0.0.1:3306
+ Source Schema : asrs
+
+ Target Server Type : MySQL
+ Target Server Version : 50730
+ File Encoding : 65001
+
+ Date: 20/08/2024 16:13:05
+*/
+
+SET NAMES utf8mb4;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- ----------------------------
+-- Table structure for wcs_task_cache
+-- ----------------------------
+DROP TABLE IF EXISTS `wcs_task_cache`;
+CREATE TABLE `wcs_task_cache` (
+ `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
+ `task_type` int(11) NULL DEFAULT NULL COMMENT '浠诲姟绫诲瀷{1:鍏ュ簱,2:鍑哄簱}',
+ `task_param` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '浠诲姟鍙傛暟',
+ `host_id` bigint(20) NULL DEFAULT NULL COMMENT '鎵�灞炴満鏋刐sys_host]',
+ `status` int(11) NULL DEFAULT 1 COMMENT '鐘舵�亄1:姝ｅ父,0:绂佺敤}',
+ `deleted` int(11) NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎{1:鏄�,0:鍚',
+ `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '娣诲姞鏃堕棿',
+ `create_by` bigint(20) NULL DEFAULT NULL COMMENT '娣诲姞浜哄憳[sys_user]',
+ `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '淇敼鏃堕棿',
+ `update_by` bigint(20) NULL DEFAULT NULL COMMENT '淇敼浜哄憳[sys_user]',
+ `memo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '澶囨敞',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
+
+SET FOREIGN_KEY_CHECKS = 1;
--
Gitblit v1.9.1