From d598b4b0d6f00a479b1e04a704216d2235ce0a12 Mon Sep 17 00:00:00 2001
From: ZengTao <2773468879@qq.com>
Date: 星期一, 04 十二月 2023 09:16:55 +0800
Subject: [PATCH] 更新数据库结构
---
springboot-vue3/src/main/resources/sql/canadames.sql | 59 ++++++++++++++++++++++++++++++++++-------------------------
1 files changed, 34 insertions(+), 25 deletions(-)
diff --git a/springboot-vue3/src/main/resources/sql/canadames.sql b/springboot-vue3/src/main/resources/sql/canadames.sql
index 6d0fcd2..186fbbf 100644
--- a/springboot-vue3/src/main/resources/sql/canadames.sql
+++ b/springboot-vue3/src/main/resources/sql/canadames.sql
@@ -11,7 +11,7 @@
Target Server Version : 80022
File Encoding : 65001
- Date: 30/11/2023 16:54:35
+ Date: 04/12/2023 09:16:20
*/
SET NAMES utf8mb4;
@@ -126,7 +126,7 @@
`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '鍒涘缓鏃堕棿',
`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '鏇存柊鏃堕棿',
PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 2 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 category
@@ -156,7 +156,7 @@
`last_product_count_date` date NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `device_id_idx`(`device_id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 47 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 46 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of device
@@ -187,7 +187,7 @@
`height` decimal(10, 2) NULL DEFAULT NULL,
`Conversionrate` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of glass
@@ -979,13 +979,14 @@
`frameheight` decimal(10, 4) NULL DEFAULT NULL,
`framelength_mm` decimal(10, 4) NULL DEFAULT NULL,
`frameheight_mm` decimal(10, 4) NULL DEFAULT NULL,
- `Flip` int NULL DEFAULT NULL
+ `Flip` int NULL DEFAULT NULL,
+ `position` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of north_glass_buffer1_frames
-- ----------------------------
-INSERT INTO `north_glass_buffer1_frames` VALUES ('219426', '210', '106', '123', 29.6250, 81.1875, 752.4750, 2062.1625, 1);
+INSERT INTO `north_glass_buffer1_frames` VALUES ('219426', '210', '106', '123', 29.6250, 81.1875, 752.4750, 2062.1625, 1, '1');
-- ----------------------------
-- Table structure for order_out
@@ -996,7 +997,7 @@
`order_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '璁㈠崟鍙�',
`state` int NULL DEFAULT NULL COMMENT '鐘舵��(0锛氭寜姝よ鍗曞彿鍑虹墖锛�1缁撴潫鍑虹墖)',
PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of order_out
@@ -1016,19 +1017,20 @@
`flip` int NULL DEFAULT NULL COMMENT '鏄惁缈荤墖',
`time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '鍒涘缓鏃堕棿',
`sequence` int NULL DEFAULT NULL COMMENT '搴忓垪',
+ `position` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '閾濇鎽嗘斁',
PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 36 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
+) ENGINE = InnoDB AUTO_INCREMENT = 102 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of out_slice
-- ----------------------------
-INSERT INTO `out_slice` VALUES (28, 'X12345610202GV', '123', 2145.0000, 900.0000, 3, 1, '2023-11-30 16:47:08', 2);
-INSERT INTO `out_slice` VALUES (29, 'X12345610302GV', '123', 1205.0000, 1640.0000, 3, 1, '2023-11-30 13:30:30', 3);
-INSERT INTO `out_slice` VALUES (31, 'X12345610402GV', '123', 2145.0000, 900.0000, 3, 1, '2023-11-30 16:47:08', 4);
-INSERT INTO `out_slice` VALUES (32, 'X12345610502GV', '123', 1205.0000, 1640.0000, 3, 1, '2023-11-30 16:47:08', 5);
-INSERT INTO `out_slice` VALUES (33, 'X12345610602GV', '123', 2145.0000, 900.0000, 3, 1, '2023-11-30 16:47:08', 6);
-INSERT INTO `out_slice` VALUES (34, 'X12345610702GV', '123', 1205.0000, 1640.0000, 3, 1, '2023-11-30 16:47:08', 8);
-INSERT INTO `out_slice` VALUES (36, 'X12345610202GV', '123', 2145.0000, 900.0000, 0, 1, NULL, NULL);
+INSERT INTO `out_slice` VALUES (95, 'X12345610402GV', '123', 1205.0000, 1640.0000, 0, 1, '2023-12-02 13:17:59', 3, '1');
+INSERT INTO `out_slice` VALUES (96, 'X12345610502GV', '123', 1205.0000, 1640.0000, 0, 1, '2023-12-02 13:17:59', 4, '1');
+INSERT INTO `out_slice` VALUES (97, 'X12345610602GV', '123', 1205.0000, 1640.0000, 0, 1, '2023-12-02 13:17:59', 5, '1');
+INSERT INTO `out_slice` VALUES (98, 'X12345610702GV', '333', 1205.0000, 1640.0000, 0, 1, '2023-12-02 13:17:59', 1, '1');
+INSERT INTO `out_slice` VALUES (99, 'X12345610802GV', '333', 1205.0000, 1640.0000, 0, 1, '2023-12-02 13:17:59', 2, '1');
+INSERT INTO `out_slice` VALUES (100, 'X12345610902GV', '456', 1205.0000, 1640.0000, 0, 1, '2023-12-02 13:17:59', 6, '1');
+INSERT INTO `out_slice` VALUES (101, 'X12345610102GV', '456', 1205.0000, 1640.0000, 0, 1, '2023-12-02 13:17:59', 7, '1');
-- ----------------------------
-- Table structure for permission
@@ -1094,7 +1096,7 @@
-- ----------------------------
-- Records of queue
-- ----------------------------
-INSERT INTO `queue` VALUES (1, 'X12345610402GV', '123456', '123', '104', 1205.0000, 1640.0000, 15.7480, 16.5354, 1, 1, '2023-11-29 16:34:01');
+INSERT INTO `queue` VALUES (1, 'X12345610702GV', '123456', '123', '107', 2000.0000, 4000.0000, 53.1496, 59.0551, 1, 0, '2023-12-04 08:53:18');
INSERT INTO `queue` VALUES (2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 0, '2023-11-29 13:07:14');
-- ----------------------------
@@ -1269,10 +1271,10 @@
-- ----------------------------
-- Records of storage_cage
-- ----------------------------
-INSERT INTO `storage_cage` VALUES (1, '', '', 1, 1, 2, 4895.0000, 0.0000, 15.7480, 15.7480, 15.7480, '123', '101', 1, 0);
-INSERT INTO `storage_cage` VALUES (2, 'X12345610202GV', '123456', 1, 1, 1, 4895.0000, 2145.0000, 900.0000, 15.7480, 14.7480, '123', '101', 1, 0);
-INSERT INTO `storage_cage` VALUES (3, 'X12345610402GV', '123456', 1, 2, 1, 1045.0000, 1205.0000, 500.0000, 15.7480, 15.7480, '123', '103', 2, 0);
-INSERT INTO `storage_cage` VALUES (4, NULL, NULL, 1, 2, 2, 1045.0000, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
+INSERT INTO `storage_cage` VALUES (1, NULL, NULL, 1, 1, 2, 750.0000, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
+INSERT INTO `storage_cage` VALUES (2, NULL, NULL, 1, 1, 1, 750.0000, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
+INSERT INTO `storage_cage` VALUES (3, NULL, NULL, 1, 2, 1, 2750.0000, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
+INSERT INTO `storage_cage` VALUES (4, NULL, NULL, 1, 2, 2, 2750.0000, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `storage_cage` VALUES (5, NULL, NULL, 1, 3, 1, 2750.0000, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `storage_cage` VALUES (6, NULL, NULL, 1, 3, 2, 2750.0000, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `storage_cage` VALUES (7, NULL, NULL, 1, 4, 1, 2750.0000, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
@@ -1705,7 +1707,7 @@
`cageno` int NULL DEFAULT NULL COMMENT '绗煎瓙鍙�',
PRIMARY KEY (`id`) USING BTREE,
INDEX `raw_package_id1`(`raw_package_id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 492 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 491 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of storage_rack
@@ -2145,7 +2147,7 @@
`finsh_time` datetime(0) NULL DEFAULT NULL COMMENT '浠诲姟缁撴潫鏃堕棿',
`glass_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 36 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 43 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of storage_task
@@ -2153,10 +2155,17 @@
INSERT INTO `storage_task` VALUES (29, 0, 1, 1000, 5, '2023-11-28 16:51:16', NULL, 'X12345610402GV');
INSERT INTO `storage_task` VALUES (30, 0, 1, 1000, 7, '2023-11-28 17:08:46', NULL, 'X12345610502GV');
INSERT INTO `storage_task` VALUES (31, 0, 1, 1000, 7, '2023-11-28 17:08:46', NULL, 'X12345610502GV');
-INSERT INTO `storage_task` VALUES (32, 0, 0, 1000, 9, '2023-11-29 08:19:09', NULL, 'X12345610702GV');
-INSERT INTO `storage_task` VALUES (33, 0, 0, 1000, 11, '2023-11-29 11:16:35', NULL, 'X12345610102GV');
+INSERT INTO `storage_task` VALUES (32, 0, 1, 1000, 9, '2023-12-02 13:58:29', NULL, 'X12345610702GV');
+INSERT INTO `storage_task` VALUES (33, 0, 1, 1000, 11, '2023-12-02 13:58:29', NULL, 'X12345610102GV');
INSERT INTO `storage_task` VALUES (34, 1, 0, 2, 1000, '2023-11-29 15:45:45', NULL, 'X12345610202GV');
-INSERT INTO `storage_task` VALUES (35, 0, 0, 1000, 4, '2023-11-29 16:34:01', NULL, 'X12345610402GV');
+INSERT INTO `storage_task` VALUES (35, 0, 1, 1000, 4, '2023-12-02 13:58:29', NULL, 'X12345610402GV');
+INSERT INTO `storage_task` VALUES (36, 0, 1, 1000, 43, '2023-12-02 14:35:29', NULL, 'X21942611102GV');
+INSERT INTO `storage_task` VALUES (37, 0, 1, 1000, 44, '2023-12-02 14:35:29', NULL, 'X21942611302GV');
+INSERT INTO `storage_task` VALUES (38, 0, 1, 1000, 45, '2023-12-02 14:35:29', NULL, 'X21942612003GV');
+INSERT INTO `storage_task` VALUES (39, 0, 0, 1000, 2, '2023-12-04 08:09:41', NULL, 'X21942612003GV');
+INSERT INTO `storage_task` VALUES (40, 0, 0, 1000, 2, '2023-12-04 08:11:43', NULL, 'X12345610702GV');
+INSERT INTO `storage_task` VALUES (41, 0, 0, 1000, 2, '2023-12-04 08:27:41', NULL, 'X12345610702GV');
+INSERT INTO `storage_task` VALUES (42, 0, 0, 1000, 2, '2023-12-04 08:52:33', NULL, 'X12345610702GV');
-- ----------------------------
-- Table structure for user
--
Gitblit v1.8.0