From b7bbb981103d865be75a16b95d188326015b8aa6 Mon Sep 17 00:00:00 2001 From: zhoushihao <zsh19950802@163.com> Date: 星期五, 06 六月 2025 13:54:28 +0800 Subject: [PATCH] 1、系统配置表新增钢化/中空间隙配置 2、钢化/中空新增厚度选择，按照厚度自动匹配对应的间隙，完成进入格子的片数的要求 --- hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/mesChangelogInit.sql | 3409 ++++++++++++++++++++++++++++++++++++----------------------- 1 files changed, 2,097 insertions(+), 1,312 deletions(-) diff --git a/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/mesChangelogInit.sql b/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/mesChangelogInit.sql index e08a245..18a8368 100644 --- a/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/mesChangelogInit.sql +++ b/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/mesChangelogInit.sql @@ -3,761 +3,1062 @@ -- changeset zsh:20241206001 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'big_storage_cage' ; -CREATE TABLE big_storage_cage ( - id bigint NOT NULL COMMENT '澶х悊鐗囩琛╥d', - device_id int NULL DEFAULT NULL COMMENT '璁惧id', - slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', - min_thickness int NULL DEFAULT NULL COMMENT '鏈�灏忓帤搴�', - max_thickness int NULL DEFAULT NULL COMMENT '鏈�澶у帤搴�', - enable_state int NULL DEFAULT NULL COMMENT '鍚敤鐘舵��', - remain_width int NULL DEFAULT NULL COMMENT '鍓╀綑瀹藉害', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB ; +CREATE TABLE big_storage_cage +( + id bigint NOT NULL COMMENT '澶х悊鐗囩琛╥d', + device_id int NULL DEFAULT NULL COMMENT '璁惧id', + slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', + min_thickness int NULL DEFAULT NULL COMMENT '鏈�灏忓帤搴�', + max_thickness int NULL DEFAULT NULL COMMENT '鏈�澶у帤搴�', + enable_state int NULL DEFAULT NULL COMMENT '鍚敤鐘舵��', + remain_width int NULL DEFAULT NULL COMMENT '鍓╀綑瀹藉害', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB; -- rollback DROP TABLE big_storage_cage; -- changeset zsh:20241206002 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM big_storage_cage; -INSERT INTO big_storage_cage VALUES (1, 1, 1, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (2, 1, 2, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (3, 1, 3, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (4, 1, 4, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (5, 1, 5, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (6, 1, 6, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (7, 1, 7, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (8, 1, 8, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (9, 1, 9, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (10, 1, 10, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (11, 1, 11, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (12, 1, 12, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (13, 1, 13, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (14, 1, 14, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (15, 1, 15, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (16, 1, 16, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (17, 1, 17, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (18, 1, 18, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (19, 1, 19, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (20, 1, 20, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (21, 1, 21, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (22, 1, 22, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (23, 1, 23, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (24, 1, 24, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (25, 1, 25, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (26, 1, 26, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (27, 1, 27, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (28, 1, 28, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (29, 1, 29, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (30, 1, 30, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (31, 1, 31, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (32, 1, 32, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (33, 1, 33, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (34, 1, 34, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (35, 1, 35, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (36, 1, 36, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (37, 1, 37, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (38, 1, 38, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (39, 1, 39, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (40, 1, 40, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (41, 1, 41, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (42, 1, 42, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (43, 1, 43, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (44, 1, 44, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (45, 1, 45, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (46, 1, 46, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (47, 1, 47, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (48, 1, 48, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (49, 1, 49, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (50, 1, 50, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (51, 1, 51, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (52, 1, 52, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (53, 1, 53, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (54, 1, 54, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (55, 1, 55, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (56, 2, 56, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (57, 2, 57, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (58, 2, 58, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (59, 2, 59, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (60, 2, 60, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (61, 2, 61, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (62, 2, 62, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (63, 2, 63, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (64, 2, 64, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (65, 2, 65, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (66, 2, 66, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (67, 2, 67, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (68, 2, 68, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (69, 2, 69, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (70, 2, 70, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (71, 2, 71, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (72, 2, 72, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (73, 2, 73, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (74, 2, 74, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (75, 2, 75, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (76, 2, 76, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (77, 2, 77, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (78, 2, 78, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (79, 2, 79, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (80, 2, 80, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (81, 2, 81, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (82, 2, 82, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (83, 2, 83, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (84, 2, 84, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (85, 2, 85, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (86, 2, 86, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (87, 2, 87, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (88, 2, 88, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (89, 2, 89, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (90, 2, 90, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (91, 2, 91, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (92, 2, 92, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (93, 2, 93, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (94, 2, 94, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (95, 2, 95, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (96, 2, 96, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (97, 2, 97, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (98, 2, 98, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (99, 2, 99, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (100, 2, 100, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (101, 2, 101, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (102, 2, 102, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (103, 2, 103, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (104, 2, 104, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (105, 2, 105, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (106, 2, 106, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (107, 2, 107, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (108, 2, 108, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (109, 2, 109, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (110, 2, 110, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (111, 3, 111, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (112, 3, 112, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (113, 3, 113, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (114, 3, 114, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (115, 3, 115, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (116, 3, 116, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (117, 3, 117, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (118, 3, 118, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (119, 3, 119, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (120, 3, 120, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (121, 3, 121, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (122, 3, 122, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (123, 3, 123, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (124, 3, 124, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (125, 3, 125, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (126, 3, 126, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (127, 3, 127, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (128, 3, 128, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (129, 3, 129, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (130, 3, 130, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (131, 3, 131, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (132, 3, 132, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (133, 3, 133, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (134, 3, 134, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (135, 3, 135, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (136, 3, 136, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (137, 3, 137, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (138, 3, 138, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (139, 3, 139, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (140, 3, 140, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (141, 3, 141, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (142, 3, 142, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (143, 3, 143, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (144, 3, 144, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (145, 3, 145, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (146, 3, 146, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (147, 3, 147, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (148, 3, 148, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (149, 3, 149, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (150, 3, 150, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (151, 3, 151, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (152, 3, 152, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (153, 3, 153, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (154, 3, 154, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (155, 3, 155, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (156, 3, 156, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (157, 3, 157, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (158, 3, 158, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (159, 3, 159, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (160, 3, 160, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (161, 3, 161, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (162, 3, 162, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (163, 3, 163, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (164, 3, 164, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (165, 3, 165, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (166, 4, 166, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (167, 4, 167, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (168, 4, 168, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (169, 4, 169, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (170, 4, 170, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (171, 4, 171, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (172, 4, 172, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (173, 4, 173, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (174, 4, 174, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (175, 4, 175, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (176, 4, 176, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (177, 4, 177, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (178, 4, 178, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (179, 4, 179, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (180, 4, 180, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (181, 4, 181, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (182, 4, 182, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (183, 4, 183, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (184, 4, 184, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (185, 4, 185, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (186, 4, 186, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (187, 4, 187, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (188, 4, 188, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (189, 4, 189, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (190, 4, 190, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (191, 4, 191, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (192, 4, 192, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (193, 4, 193, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (194, 4, 194, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (195, 4, 195, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (196, 4, 196, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (197, 4, 197, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (198, 4, 198, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (199, 4, 199, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (200, 4, 200, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (201, 4, 201, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (202, 4, 202, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (203, 4, 203, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (204, 4, 204, 4, 6, 1, 6200); -INSERT INTO big_storage_cage VALUES (205, 4, 205, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (1, 1, 1, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (2, 1, 2, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (3, 1, 3, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (4, 1, 4, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (5, 1, 5, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (6, 1, 6, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (7, 1, 7, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (8, 1, 8, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (9, 1, 9, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (10, 1, 10, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (11, 1, 11, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (12, 1, 12, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (13, 1, 13, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (14, 1, 14, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (15, 1, 15, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (16, 1, 16, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (17, 1, 17, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (18, 1, 18, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (19, 1, 19, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (20, 1, 20, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (21, 1, 21, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (22, 1, 22, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (23, 1, 23, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (24, 1, 24, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (25, 1, 25, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (26, 1, 26, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (27, 1, 27, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (28, 1, 28, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (29, 1, 29, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (30, 1, 30, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (31, 1, 31, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (32, 1, 32, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (33, 1, 33, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (34, 1, 34, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (35, 1, 35, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (36, 1, 36, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (37, 1, 37, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (38, 1, 38, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (39, 1, 39, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (40, 1, 40, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (41, 1, 41, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (42, 1, 42, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (43, 1, 43, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (44, 1, 44, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (45, 1, 45, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (46, 1, 46, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (47, 1, 47, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (48, 1, 48, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (49, 1, 49, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (50, 1, 50, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (51, 1, 51, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (52, 1, 52, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (53, 1, 53, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (54, 1, 54, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (55, 1, 55, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (56, 2, 56, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (57, 2, 57, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (58, 2, 58, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (59, 2, 59, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (60, 2, 60, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (61, 2, 61, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (62, 2, 62, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (63, 2, 63, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (64, 2, 64, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (65, 2, 65, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (66, 2, 66, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (67, 2, 67, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (68, 2, 68, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (69, 2, 69, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (70, 2, 70, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (71, 2, 71, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (72, 2, 72, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (73, 2, 73, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (74, 2, 74, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (75, 2, 75, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (76, 2, 76, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (77, 2, 77, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (78, 2, 78, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (79, 2, 79, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (80, 2, 80, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (81, 2, 81, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (82, 2, 82, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (83, 2, 83, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (84, 2, 84, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (85, 2, 85, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (86, 2, 86, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (87, 2, 87, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (88, 2, 88, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (89, 2, 89, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (90, 2, 90, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (91, 2, 91, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (92, 2, 92, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (93, 2, 93, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (94, 2, 94, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (95, 2, 95, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (96, 2, 96, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (97, 2, 97, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (98, 2, 98, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (99, 2, 99, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (100, 2, 100, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (101, 2, 101, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (102, 2, 102, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (103, 2, 103, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (104, 2, 104, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (105, 2, 105, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (106, 2, 106, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (107, 2, 107, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (108, 2, 108, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (109, 2, 109, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (110, 2, 110, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (111, 3, 111, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (112, 3, 112, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (113, 3, 113, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (114, 3, 114, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (115, 3, 115, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (116, 3, 116, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (117, 3, 117, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (118, 3, 118, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (119, 3, 119, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (120, 3, 120, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (121, 3, 121, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (122, 3, 122, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (123, 3, 123, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (124, 3, 124, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (125, 3, 125, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (126, 3, 126, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (127, 3, 127, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (128, 3, 128, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (129, 3, 129, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (130, 3, 130, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (131, 3, 131, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (132, 3, 132, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (133, 3, 133, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (134, 3, 134, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (135, 3, 135, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (136, 3, 136, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (137, 3, 137, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (138, 3, 138, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (139, 3, 139, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (140, 3, 140, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (141, 3, 141, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (142, 3, 142, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (143, 3, 143, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (144, 3, 144, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (145, 3, 145, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (146, 3, 146, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (147, 3, 147, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (148, 3, 148, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (149, 3, 149, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (150, 3, 150, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (151, 3, 151, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (152, 3, 152, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (153, 3, 153, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (154, 3, 154, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (155, 3, 155, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (156, 3, 156, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (157, 3, 157, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (158, 3, 158, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (159, 3, 159, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (160, 3, 160, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (161, 3, 161, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (162, 3, 162, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (163, 3, 163, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (164, 3, 164, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (165, 3, 165, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (166, 4, 166, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (167, 4, 167, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (168, 4, 168, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (169, 4, 169, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (170, 4, 170, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (171, 4, 171, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (172, 4, 172, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (173, 4, 173, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (174, 4, 174, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (175, 4, 175, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (176, 4, 176, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (177, 4, 177, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (178, 4, 178, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (179, 4, 179, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (180, 4, 180, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (181, 4, 181, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (182, 4, 182, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (183, 4, 183, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (184, 4, 184, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (185, 4, 185, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (186, 4, 186, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (187, 4, 187, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (188, 4, 188, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (189, 4, 189, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (190, 4, 190, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (191, 4, 191, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (192, 4, 192, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (193, 4, 193, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (194, 4, 194, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (195, 4, 195, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (196, 4, 196, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (197, 4, 197, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (198, 4, 198, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (199, 4, 199, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (200, 4, 200, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (201, 4, 201, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (202, 4, 202, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (203, 4, 203, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (204, 4, 204, 4, 6, 1, 6200); +INSERT INTO big_storage_cage +VALUES (205, 4, 205, 4, 6, 1, 6200); -- changeset zsh:20241206003 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'big_storage_cage_details'; -CREATE TABLE big_storage_cage_details ( - id bigint NOT NULL AUTO_INCREMENT COMMENT '澶х悊鐗囩璇︽儏琛╥d', - device_id int NULL DEFAULT NULL COMMENT '璁惧id', - slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', - glass_id varchar(20) DEFAULT NULL COMMENT '鐜荤拑id', - sequence int NULL DEFAULT NULL COMMENT '灏忕墖鍦ㄦ牸鍐呯殑椤哄簭', - flow_card_id varchar(20) DEFAULT NULL COMMENT '娴佺▼鍗″彿', - glass_type int NULL DEFAULT NULL COMMENT '鐜荤拑绫诲瀷', - width double NULL DEFAULT NULL COMMENT '瀹�', - height double NULL DEFAULT NULL COMMENT '楂�', - thickness double NULL DEFAULT NULL COMMENT '鍘氬害', - tempering_layout_id int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘id', - tempering_feed_sequence int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘鐗囧簭', - x_coordinate int NULL DEFAULT NULL COMMENT 'x鍧愭爣', - y_coordinate int NULL DEFAULT NULL COMMENT 'y鍧愭爣', - state int NULL DEFAULT NULL COMMENT '鐘舵��', - gap int NULL DEFAULT NULL COMMENT '鐜荤拑闂撮殭', - engineer_id varchar(50) NULL DEFAULT NULL, - layer int NULL DEFAULT NULL COMMENT '灞傚彿', - create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1; +CREATE TABLE big_storage_cage_details +( + id bigint NOT NULL AUTO_INCREMENT COMMENT '澶х悊鐗囩璇︽儏琛╥d', + device_id int NULL DEFAULT NULL COMMENT '璁惧id', + slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', + glass_id varchar(20) DEFAULT NULL COMMENT '鐜荤拑id', + sequence int NULL DEFAULT NULL COMMENT '灏忕墖鍦ㄦ牸鍐呯殑椤哄簭', + flow_card_id varchar(20) DEFAULT NULL COMMENT '娴佺▼鍗″彿', + glass_type int NULL DEFAULT NULL COMMENT '鐜荤拑绫诲瀷', + width double NULL DEFAULT NULL COMMENT '瀹�', + height double NULL DEFAULT NULL COMMENT '楂�', + thickness double NULL DEFAULT NULL COMMENT '鍘氬害', + tempering_layout_id int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘id', + tempering_feed_sequence int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘鐗囧簭', + x_coordinate int NULL DEFAULT NULL COMMENT 'x鍧愭爣', + y_coordinate int NULL DEFAULT NULL COMMENT 'y鍧愭爣', + state int NULL DEFAULT NULL COMMENT '鐘舵��', + gap int NULL DEFAULT NULL COMMENT '鐜荤拑闂撮殭', + engineer_id varchar(50) NULL DEFAULT NULL, + layer int NULL DEFAULT NULL COMMENT '灞傚彿', + create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE big_storage_cage_details; -- changeset zsh:20241206004 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'big_storage_cage_history_task'; -CREATE TABLE big_storage_cage_history_task ( - id bigint NOT NULL AUTO_INCREMENT, - glass_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐜荤拑id', - start_slot int NULL DEFAULT 0 COMMENT '璧峰鏍煎瓙', - target_slot int NULL DEFAULT 0 COMMENT '鐩爣鏍煎瓙', - task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� ', - glass_count int NULL DEFAULT NULL COMMENT '鐜荤拑鏁伴噺', - task_type int NULL DEFAULT NULL COMMENT '浠诲姟绫诲瀷', - create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE big_storage_cage_history_task +( + id bigint NOT NULL AUTO_INCREMENT, + glass_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐜荤拑id', + start_slot int NULL DEFAULT 0 COMMENT '璧峰鏍煎瓙', + target_slot int NULL DEFAULT 0 COMMENT '鐩爣鏍煎瓙', + task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� ', + glass_count int NULL DEFAULT NULL COMMENT '鐜荤拑鏁伴噺', + task_type int NULL DEFAULT NULL COMMENT '浠诲姟绫诲瀷', + create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE big_storage_cage_history_task; -- changeset zsh:20241206005 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'big_storage_cage_in_one_task'; -CREATE TABLE big_storage_cage_in_one_task ( - task_running int NULL DEFAULT 0 COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1鍚姩浠诲姟 2 纭瀹屾垚', - glass_id varchar(32) DEFAULT NULL COMMENT '鐜荤拑id', - start_slot int NULL DEFAULT 0 COMMENT '璧峰鏍煎瓙', - target_slot int NULL DEFAULT 0 COMMENT '鐩爣鏍煎瓙', - task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� ' -) ENGINE = InnoDB ; +CREATE TABLE big_storage_cage_in_one_task +( + task_running int NULL DEFAULT 0 COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1鍚姩浠诲姟 2 纭瀹屾垚', + glass_id varchar(32) DEFAULT NULL COMMENT '鐜荤拑id', + start_slot int NULL DEFAULT 0 COMMENT '璧峰鏍煎瓙', + target_slot int NULL DEFAULT 0 COMMENT '鐩爣鏍煎瓙', + task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� ' +) ENGINE = InnoDB; -- rollback DROP TABLE big_storage_cage_in_one_task; -- changeset zsh:20241206006 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM big_storage_cage_in_one_task; -INSERT INTO big_storage_cage_in_one_task VALUES (0, '', 0, 0, 0); -INSERT INTO big_storage_cage_in_one_task VALUES (0, '', 0, 0, 0); -INSERT INTO big_storage_cage_in_one_task VALUES (0, '', 0, 0, 0); -INSERT INTO big_storage_cage_in_one_task VALUES (0, '', 0, 0, 0); -INSERT INTO big_storage_cage_in_one_task VALUES (0, '', 0, 0, 0); -INSERT INTO big_storage_cage_in_one_task VALUES (0, '', 0, 0, 0); +INSERT INTO big_storage_cage_in_one_task +VALUES (0, '', 0, 0, 0); +INSERT INTO big_storage_cage_in_one_task +VALUES (0, '', 0, 0, 0); +INSERT INTO big_storage_cage_in_one_task +VALUES (0, '', 0, 0, 0); +INSERT INTO big_storage_cage_in_one_task +VALUES (0, '', 0, 0, 0); +INSERT INTO big_storage_cage_in_one_task +VALUES (0, '', 0, 0, 0); +INSERT INTO big_storage_cage_in_one_task +VALUES (0, '', 0, 0, 0); -- changeset zsh:20241206007 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'big_storage_cage_in_two_task'; -CREATE TABLE big_storage_cage_in_two_task ( - task_running int NULL DEFAULT 0 COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1鍚姩浠诲姟 2 纭瀹屾垚', - glass_id varchar(32) DEFAULT NULL COMMENT '鐜荤拑id', - start_slot int NULL DEFAULT 0 COMMENT '璧峰鏍煎瓙', - target_slot int NULL DEFAULT 0 COMMENT '鐩爣鏍煎瓙', - task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� ' -) ENGINE = InnoDB ; +CREATE TABLE big_storage_cage_in_two_task +( + task_running int NULL DEFAULT 0 COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1鍚姩浠诲姟 2 纭瀹屾垚', + glass_id varchar(32) DEFAULT NULL COMMENT '鐜荤拑id', + start_slot int NULL DEFAULT 0 COMMENT '璧峰鏍煎瓙', + target_slot int NULL DEFAULT 0 COMMENT '鐩爣鏍煎瓙', + task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� ' +) ENGINE = InnoDB; -- rollback DROP TABLE big_storage_cage_in_two_task; -- changeset zsh:20241206008 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM big_storage_cage_in_two_task; -INSERT INTO big_storage_cage_in_two_task VALUES (0, NULL, 0, 0, 0); -INSERT INTO big_storage_cage_in_two_task VALUES (0, NULL, 0, 0, 0); -INSERT INTO big_storage_cage_in_two_task VALUES (0, NULL, 0, 0, 0); -INSERT INTO big_storage_cage_in_two_task VALUES (0, NULL, 0, 0, 0); -INSERT INTO big_storage_cage_in_two_task VALUES (0, NULL, 0, 0, 0); -INSERT INTO big_storage_cage_in_two_task VALUES (0, NULL, 0, 0, 0); +INSERT INTO big_storage_cage_in_two_task +VALUES (0, NULL, 0, 0, 0); +INSERT INTO big_storage_cage_in_two_task +VALUES (0, NULL, 0, 0, 0); +INSERT INTO big_storage_cage_in_two_task +VALUES (0, NULL, 0, 0, 0); +INSERT INTO big_storage_cage_in_two_task +VALUES (0, NULL, 0, 0, 0); +INSERT INTO big_storage_cage_in_two_task +VALUES (0, NULL, 0, 0, 0); +INSERT INTO big_storage_cage_in_two_task +VALUES (0, NULL, 0, 0, 0); -- changeset zsh:20241206009 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'big_storage_cage_out_one_task'; -CREATE TABLE big_storage_cage_out_one_task ( - glass_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐜荤拑id', - start_slot int NULL DEFAULT 0 COMMENT '璧峰鏍煎瓙', - target_slot int NULL DEFAULT 0 COMMENT '鐩爣鏍煎瓙', - task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� ' -) ENGINE = InnoDB ; +CREATE TABLE big_storage_cage_out_one_task +( + glass_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐜荤拑id', + start_slot int NULL DEFAULT 0 COMMENT '璧峰鏍煎瓙', + target_slot int NULL DEFAULT 0 COMMENT '鐩爣鏍煎瓙', + task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� ' +) ENGINE = InnoDB; -- rollback DROP TABLE big_storage_cage_out_one_task; -- changeset zsh:20241206010 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM big_storage_cage_out_one_task; -INSERT INTO big_storage_cage_out_one_task VALUES (NULL, 0, 0, 0); -INSERT INTO big_storage_cage_out_one_task VALUES (NULL, 0, 0, 0); -INSERT INTO big_storage_cage_out_one_task VALUES (NULL, 0, 0, 0); -INSERT INTO big_storage_cage_out_one_task VALUES (NULL, 0, 0, 0); -INSERT INTO big_storage_cage_out_one_task VALUES (NULL, 0, 0, 0); -INSERT INTO big_storage_cage_out_one_task VALUES (NULL, 0, 0, 0); +INSERT INTO big_storage_cage_out_one_task +VALUES (NULL, 0, 0, 0); +INSERT INTO big_storage_cage_out_one_task +VALUES (NULL, 0, 0, 0); +INSERT INTO big_storage_cage_out_one_task +VALUES (NULL, 0, 0, 0); +INSERT INTO big_storage_cage_out_one_task +VALUES (NULL, 0, 0, 0); +INSERT INTO big_storage_cage_out_one_task +VALUES (NULL, 0, 0, 0); +INSERT INTO big_storage_cage_out_one_task +VALUES (NULL, 0, 0, 0); -- changeset zsh:20241206011 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'big_storage_cage_out_two_task'; -CREATE TABLE big_storage_cage_out_two_task ( - glass_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐜荤拑id', - start_slot int NULL DEFAULT 0 COMMENT '璧峰鏍煎瓙', - target_slot int NULL DEFAULT 0 COMMENT '鐩爣鏍煎瓙', - task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� ' -) ENGINE = InnoDB ; +CREATE TABLE big_storage_cage_out_two_task +( + glass_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐜荤拑id', + start_slot int NULL DEFAULT 0 COMMENT '璧峰鏍煎瓙', + target_slot int NULL DEFAULT 0 COMMENT '鐩爣鏍煎瓙', + task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� ' +) ENGINE = InnoDB; -- rollback DROP TABLE big_storage_cage_out_two_task; -- changeset zsh:20241206012 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM big_storage_cage_out_two_task; -INSERT INTO big_storage_cage_out_two_task VALUES (NULL, 0, 0, 0); -INSERT INTO big_storage_cage_out_two_task VALUES (NULL, 0, 0, 0); -INSERT INTO big_storage_cage_out_two_task VALUES (NULL, 0, 0, 0); -INSERT INTO big_storage_cage_out_two_task VALUES (NULL, 0, 0, 0); -INSERT INTO big_storage_cage_out_two_task VALUES (NULL, 0, 0, 0); -INSERT INTO big_storage_cage_out_two_task VALUES (NULL, 0, 0, 0); +INSERT INTO big_storage_cage_out_two_task +VALUES (NULL, 0, 0, 0); +INSERT INTO big_storage_cage_out_two_task +VALUES (NULL, 0, 0, 0); +INSERT INTO big_storage_cage_out_two_task +VALUES (NULL, 0, 0, 0); +INSERT INTO big_storage_cage_out_two_task +VALUES (NULL, 0, 0, 0); +INSERT INTO big_storage_cage_out_two_task +VALUES (NULL, 0, 0, 0); +INSERT INTO big_storage_cage_out_two_task +VALUES (NULL, 0, 0, 0); -- changeset zsh:20241206013 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'big_storage_glass_info'; -CREATE TABLE big_storage_glass_info ( - id bigint NOT NULL AUTO_INCREMENT COMMENT '澶х悊鐗囩淇℃伅琛╥d', - glass_id varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐜荤拑id', - flow_card_id varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '娴佺▼鍗″彿', - glass_type int NULL DEFAULT NULL COMMENT '鐜荤拑绫诲瀷', - width double NULL DEFAULT NULL COMMENT '瀹�', - height double NULL DEFAULT NULL COMMENT '楂�', - thickness double NULL DEFAULT NULL COMMENT '鍘氬害', - tempering_layout_id int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘id', - tempering_feed_sequence int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘鐗囧簭', - x_coordinate int NULL DEFAULT NULL COMMENT 'x鍧愭爣', - y_coordinate int NULL DEFAULT NULL COMMENT 'y鍧愭爣', - engineer_id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, - layer int NULL DEFAULT NULL COMMENT '灞傚彿', - virtual_slot int NULL DEFAULT NULL COMMENT '铏氭嫙鏍煎瓙鍙�', - slot_sequence int NULL DEFAULT NULL COMMENT '鏍煎瓙娆″簭', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1; +CREATE TABLE big_storage_glass_info +( + id bigint NOT NULL AUTO_INCREMENT COMMENT '澶х悊鐗囩淇℃伅琛╥d', + glass_id varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐜荤拑id', + flow_card_id varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '娴佺▼鍗″彿', + glass_type int NULL DEFAULT NULL COMMENT '鐜荤拑绫诲瀷', + width double NULL DEFAULT NULL COMMENT '瀹�', + height double NULL DEFAULT NULL COMMENT '楂�', + thickness double NULL DEFAULT NULL COMMENT '鍘氬害', + tempering_layout_id int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘id', + tempering_feed_sequence int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘鐗囧簭', + x_coordinate int NULL DEFAULT NULL COMMENT 'x鍧愭爣', + y_coordinate int NULL DEFAULT NULL COMMENT 'y鍧愭爣', + engineer_id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, + layer int NULL DEFAULT NULL COMMENT '灞傚彿', + virtual_slot int NULL DEFAULT NULL COMMENT '铏氭嫙鏍煎瓙鍙�', + slot_sequence int NULL DEFAULT NULL COMMENT '鏍煎瓙娆″簭', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE big_storage_glass_info; -- changeset zsh:20241206014 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'big_storage_glass_relation_info'; -CREATE TABLE big_storage_glass_relation_info ( - id bigint NOT NULL AUTO_INCREMENT COMMENT '閽㈠寲鐜荤拑鍏崇郴琛╥d', - engineer_id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, - glass_id varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐜荤拑id', - tempering_layout_id int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘id', - tempering_feed_sequence int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘鐗囧簭', - virtual_slot int NULL DEFAULT NULL COMMENT '铏氭嫙鏍煎瓙', - slot_sequence int NULL DEFAULT NULL COMMENT '鏍煎瓙鍐呮搴�', - slot int NULL DEFAULT NULL COMMENT '瀹為檯鏍煎瓙鍙�', - device_id int NULL DEFAULT NULL COMMENT '瀹為檯绗煎瓙鍙�', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE big_storage_glass_relation_info +( + id bigint NOT NULL AUTO_INCREMENT COMMENT '閽㈠寲鐜荤拑鍏崇郴琛╥d', + engineer_id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, + glass_id varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐜荤拑id', + tempering_layout_id int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘id', + tempering_feed_sequence int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘鐗囧簭', + virtual_slot int NULL DEFAULT NULL COMMENT '铏氭嫙鏍煎瓙', + slot_sequence int NULL DEFAULT NULL COMMENT '鏍煎瓙鍐呮搴�', + slot int NULL DEFAULT NULL COMMENT '瀹為檯鏍煎瓙鍙�', + device_id int NULL DEFAULT NULL COMMENT '瀹為檯绗煎瓙鍙�', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE big_storage_glass_relation_info; -- changeset zsh:20241206015 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'damage'; -CREATE TABLE damage ( - id bigint NOT NULL AUTO_INCREMENT, - line int NULL DEFAULT NULL COMMENT '绾胯矾', - working_procedure varchar(20) DEFAULT NULL COMMENT '宸ュ簭', - glass_id varchar(30) DEFAULT NULL COMMENT '鐜荤拑id', - engineer_id varchar(20) DEFAULT NULL COMMENT '宸ョ▼鍙�', - tempering_layout_id int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘id', - damage_time datetime NULL DEFAULT NULL COMMENT '鐢熶骇鏃堕棿', - remark varchar(255) DEFAULT NULL COMMENT '澶囨敞', - type int NULL DEFAULT NULL COMMENT '绫诲瀷锛�1锛氭姤宸� 2锛氱牬鎹� 3锛氭嬁璧�', - status int NULL DEFAULT NULL COMMENT '鐘舵�侊細1锛氭湭鎶ュ伐 2:寰呮姤宸� 3锛氬凡鎶ュ伐', - process_id varchar(20) DEFAULT NULL COMMENT '娴佺▼鍗�', - order_number int NULL DEFAULT NULL COMMENT '搴忓彿', - technology_number int NULL DEFAULT NULL COMMENT '宸ヨ壓纭搴忓彿', - breakage_type varchar(255) DEFAULT NULL COMMENT '鐮存崯绫诲瀷', - breakage_reason varchar(255) DEFAULT NULL COMMENT '鐮存崯鍘熷洜', - responsible_process varchar(255) DEFAULT NULL COMMENT '璐ｄ换宸ュ簭', - responsible_personnel varchar(255) DEFAULT NULL COMMENT '璐ｄ换浜哄憳', - responsible_team varchar(255) DEFAULT NULL COMMENT '璐ｄ换鐝粍', - responsible_equipment varchar(255) DEFAULT NULL COMMENT '璐ｄ换璁惧', - teams_groups_name varchar(255) DEFAULT NULL COMMENT '鎶ュ伐鐝粍鍚嶇О', - device_name varchar(255) DEFAULT NULL COMMENT '鎶ュ伐璁惧鍚嶇О', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE damage +( + id bigint NOT NULL AUTO_INCREMENT, + line int NULL DEFAULT NULL COMMENT '绾胯矾', + working_procedure varchar(20) DEFAULT NULL COMMENT '宸ュ簭', + glass_id varchar(30) DEFAULT NULL COMMENT '鐜荤拑id', + engineer_id varchar(20) DEFAULT NULL COMMENT '宸ョ▼鍙�', + tempering_layout_id int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘id', + damage_time datetime NULL DEFAULT NULL COMMENT '鐢熶骇鏃堕棿', + remark varchar(255) DEFAULT NULL COMMENT '澶囨敞', + type int NULL DEFAULT NULL COMMENT '绫诲瀷锛�1锛氭姤宸� 2锛氱牬鎹� 3锛氭嬁璧�', + status int NULL DEFAULT NULL COMMENT '鐘舵�侊細1锛氭湭鎶ュ伐 2:寰呮姤宸� 3锛氬凡鎶ュ伐', + process_id varchar(20) DEFAULT NULL COMMENT '娴佺▼鍗�', + order_number int NULL DEFAULT NULL COMMENT '搴忓彿', + technology_number int NULL DEFAULT NULL COMMENT '宸ヨ壓纭搴忓彿', + breakage_type varchar(255) DEFAULT NULL COMMENT '鐮存崯绫诲瀷', + breakage_reason varchar(255) DEFAULT NULL COMMENT '鐮存崯鍘熷洜', + responsible_process varchar(255) DEFAULT NULL COMMENT '璐ｄ换宸ュ簭', + responsible_personnel varchar(255) DEFAULT NULL COMMENT '璐ｄ换浜哄憳', + responsible_team varchar(255) DEFAULT NULL COMMENT '璐ｄ换鐝粍', + responsible_equipment varchar(255) DEFAULT NULL COMMENT '璐ｄ换璁惧', + teams_groups_name varchar(255) DEFAULT NULL COMMENT '鎶ュ伐鐝粍鍚嶇О', + device_name varchar(255) DEFAULT NULL COMMENT '鎶ュ伐璁惧鍚嶇О', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE damage; -- changeset zsh:20241206016 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'down_glass_info'; -CREATE TABLE down_glass_info ( - id bigint NOT NULL AUTO_INCREMENT COMMENT '涓嬬墖鐜荤拑淇℃伅琛╥d', - work_station_id int NULL DEFAULT NULL COMMENT '宸ヤ綅id', - engineer_id varchar(20) DEFAULT NULL COMMENT '宸ョ▼id', - flow_card_id varchar(20) DEFAULT NULL COMMENT '娴佺▼鍗″彿', - layer int NULL DEFAULT NULL, - sequence int NULL DEFAULT NULL COMMENT '椤哄簭', - width double NULL DEFAULT NULL COMMENT '瀹�', - height double NULL DEFAULT NULL COMMENT '楂�', - filmsid varchar(20) DEFAULT NULL COMMENT '鑶滅郴', - thickness double NULL DEFAULT NULL COMMENT '鍘氬害', - glass_id varchar(50) DEFAULT NULL COMMENT '鐜荤拑id', - gmt_create timestamp NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', - combine int NULL DEFAULT NULL, - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE down_glass_info +( + id bigint NOT NULL AUTO_INCREMENT COMMENT '涓嬬墖鐜荤拑淇℃伅琛╥d', + work_station_id int NULL DEFAULT NULL COMMENT '宸ヤ綅id', + engineer_id varchar(20) DEFAULT NULL COMMENT '宸ョ▼id', + flow_card_id varchar(20) DEFAULT NULL COMMENT '娴佺▼鍗″彿', + layer int NULL DEFAULT NULL, + sequence int NULL DEFAULT NULL COMMENT '椤哄簭', + width double NULL DEFAULT NULL COMMENT '瀹�', + height double NULL DEFAULT NULL COMMENT '楂�', + filmsid varchar(20) DEFAULT NULL COMMENT '鑶滅郴', + thickness double NULL DEFAULT NULL COMMENT '鍘氬害', + glass_id varchar(50) DEFAULT NULL COMMENT '鐜荤拑id', + gmt_create timestamp NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', + combine int NULL DEFAULT NULL, + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE down_glass_info; -- changeset zsh:20241206017 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'down_storage_cage'; -CREATE TABLE down_storage_cage ( - id int NOT NULL AUTO_INCREMENT COMMENT '涓嬬墖鍓嶇悊鐗囩琛╥d', - device_id int NULL DEFAULT NULL COMMENT '璁惧id', - slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', - enable_state int NULL DEFAULT NULL COMMENT '鍚敤鐘舵��', - remain_width int NULL DEFAULT NULL COMMENT '鍓╀綑', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE down_storage_cage +( + id int NOT NULL AUTO_INCREMENT COMMENT '涓嬬墖鍓嶇悊鐗囩琛╥d', + device_id int NULL DEFAULT NULL COMMENT '璁惧id', + slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', + enable_state int NULL DEFAULT NULL COMMENT '鍚敤鐘舵��', + remain_width int NULL DEFAULT NULL COMMENT '鍓╀綑', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE down_storage_cage; -- changeset zsh:20241206018 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM down_storage_cage; -INSERT INTO down_storage_cage VALUES (1, 1, 1, 1, 5000); -INSERT INTO down_storage_cage VALUES (2, 1, 2, 1, 5000); -INSERT INTO down_storage_cage VALUES (3, 1, 3, 1, 5000); -INSERT INTO down_storage_cage VALUES (4, 1, 4, 1, 5000); -INSERT INTO down_storage_cage VALUES (5, 1, 5, 1, 5000); -INSERT INTO down_storage_cage VALUES (6, 1, 6, 1, 5000); -INSERT INTO down_storage_cage VALUES (7, 1, 7, 1, 5000); -INSERT INTO down_storage_cage VALUES (8, 1, 8, 1, 5000); -INSERT INTO down_storage_cage VALUES (9, 1, 9, 1, 5000); +INSERT INTO down_storage_cage +VALUES (1, 1, 1, 1, 5000); +INSERT INTO down_storage_cage +VALUES (2, 1, 2, 1, 5000); +INSERT INTO down_storage_cage +VALUES (3, 1, 3, 1, 5000); +INSERT INTO down_storage_cage +VALUES (4, 1, 4, 1, 5000); +INSERT INTO down_storage_cage +VALUES (5, 1, 5, 1, 5000); +INSERT INTO down_storage_cage +VALUES (6, 1, 6, 1, 5000); +INSERT INTO down_storage_cage +VALUES (7, 1, 7, 1, 5000); +INSERT INTO down_storage_cage +VALUES (8, 1, 8, 1, 5000); +INSERT INTO down_storage_cage +VALUES (9, 1, 9, 1, 5000); -- changeset zsh:20241206019 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'down_storage_cage_details'; -CREATE TABLE down_storage_cage_details ( - id bigint NOT NULL AUTO_INCREMENT COMMENT '涓嬬墖鍓嶇悊鐗囩鏄庣粏琛╥d', - glass_id varchar(50) DEFAULT NULL COMMENT '鐜荤拑id', - device_id int NULL DEFAULT NULL COMMENT '璁惧id', - slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', - sequence int NULL DEFAULT NULL COMMENT '灏忕墖鍦ㄦ牸鍐呯殑椤哄簭', - filmsid varchar(20) DEFAULT NULL COMMENT '鑶滅郴id', - flow_card_id varchar(20) DEFAULT NULL COMMENT '娴佺▼鍗″彿', - glass_type int NULL DEFAULT NULL COMMENT '鐜荤拑绫诲瀷', - width double NULL DEFAULT NULL COMMENT '瀹�', - height double NULL DEFAULT NULL COMMENT '楂�', - thickness double NULL DEFAULT NULL COMMENT '鍘氬害', - tempering_layout_id int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘id', - tempering_feed_sequence int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘鐗囧簭', - state int NULL DEFAULT NULL COMMENT '鐘舵��', - gap int NULL DEFAULT NULL COMMENT '鐜荤拑闂撮殭', - total_layer int NULL DEFAULT NULL, - layer int NULL DEFAULT NULL, - engineer_id varchar(20) DEFAULT NULL COMMENT '宸ョ▼鍙�', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE down_storage_cage_details +( + id bigint NOT NULL AUTO_INCREMENT COMMENT '涓嬬墖鍓嶇悊鐗囩鏄庣粏琛╥d', + glass_id varchar(50) DEFAULT NULL COMMENT '鐜荤拑id', + device_id int NULL DEFAULT NULL COMMENT '璁惧id', + slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', + sequence int NULL DEFAULT NULL COMMENT '灏忕墖鍦ㄦ牸鍐呯殑椤哄簭', + filmsid varchar(20) DEFAULT NULL COMMENT '鑶滅郴id', + flow_card_id varchar(20) DEFAULT NULL COMMENT '娴佺▼鍗″彿', + glass_type int NULL DEFAULT NULL COMMENT '鐜荤拑绫诲瀷', + width double NULL DEFAULT NULL COMMENT '瀹�', + height double NULL DEFAULT NULL COMMENT '楂�', + thickness double NULL DEFAULT NULL COMMENT '鍘氬害', + tempering_layout_id int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘id', + tempering_feed_sequence int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘鐗囧簭', + state int NULL DEFAULT NULL COMMENT '鐘舵��', + gap int NULL DEFAULT NULL COMMENT '鐜荤拑闂撮殭', + total_layer int NULL DEFAULT NULL, + layer int NULL DEFAULT NULL, + engineer_id varchar(20) DEFAULT NULL COMMENT '宸ョ▼鍙�', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE down_storage_cage_details; -- changeset zsh:20241206020 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'down_workstation'; -CREATE TABLE down_workstation ( - id bigint NOT NULL AUTO_INCREMENT COMMENT '涓嬬墖宸ヤ綅琛╥d', - workstation_id int NULL DEFAULT NULL COMMENT '宸ヤ綅id', - total_quantity int NULL DEFAULT NULL COMMENT '鎬绘暟閲�', - racks_number int NULL DEFAULT 0 COMMENT '宸茶惤鏋舵暟閲�', - other_number int NULL DEFAULT 0 COMMENT '鍏朵粬澶勭悊鐜荤拑鏁伴噺', - flow_card_id varchar(20) DEFAULT NULL COMMENT '娴佺▼鍗″彿', - layer int NULL DEFAULT NULL COMMENT '灞傛暟', - device_id int NULL DEFAULT NULL COMMENT '璁惧id', - enable_state int NULL DEFAULT NULL COMMENT '鍚敤鐘舵��', - work_state int NULL DEFAULT NULL COMMENT '宸ヤ綔鐘舵��', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB ; +CREATE TABLE down_workstation +( + id bigint NOT NULL AUTO_INCREMENT COMMENT '涓嬬墖宸ヤ綅琛╥d', + workstation_id int NULL DEFAULT NULL COMMENT '宸ヤ綅id', + total_quantity int NULL DEFAULT NULL COMMENT '鎬绘暟閲�', + racks_number int NULL DEFAULT 0 COMMENT '宸茶惤鏋舵暟閲�', + other_number int NULL DEFAULT 0 COMMENT '鍏朵粬澶勭悊鐜荤拑鏁伴噺', + flow_card_id varchar(20) DEFAULT NULL COMMENT '娴佺▼鍗″彿', + layer int NULL DEFAULT NULL COMMENT '灞傛暟', + device_id int NULL DEFAULT NULL COMMENT '璁惧id', + enable_state int NULL DEFAULT NULL COMMENT '鍚敤鐘舵��', + work_state int NULL DEFAULT NULL COMMENT '宸ヤ綔鐘舵��', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB; -- rollback DROP TABLE down_workstation; -- changeset zsh:20241206021 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM down_workstation; -INSERT INTO down_workstation VALUES (1, 1, 0, 0, 0, '', NULL, 2, 1, 1); -INSERT INTO down_workstation VALUES (2, 2, 0, 0, 0, '', NULL, 2, 1, 1); -INSERT INTO down_workstation VALUES (3, 3, 0, 0, 0, '', NULL, 2, 1, 1); -INSERT INTO down_workstation VALUES (4, 4, 0, 0, 0, '', NULL, 2, 1, 1); -INSERT INTO down_workstation VALUES (5, 5, 0, 0, 0, '', NULL, 2, 1, 1); -INSERT INTO down_workstation VALUES (6, 6, 0, 0, 0, '', NULL, 2, 1, 1); +INSERT INTO down_workstation +VALUES (1, 1, 0, 0, 0, '', NULL, 2, 1, 1); +INSERT INTO down_workstation +VALUES (2, 2, 0, 0, 0, '', NULL, 2, 1, 1); +INSERT INTO down_workstation +VALUES (3, 3, 0, 0, 0, '', NULL, 2, 1, 1); +INSERT INTO down_workstation +VALUES (4, 4, 0, 0, 0, '', NULL, 2, 1, 1); +INSERT INTO down_workstation +VALUES (5, 5, 0, 0, 0, '', NULL, 2, 1, 1); +INSERT INTO down_workstation +VALUES (6, 6, 0, 0, 0, '', NULL, 2, 1, 1); -- changeset zsh:20241206022 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'edg_glass_task_queue_info'; -CREATE TABLE edg_glass_task_queue_info ( - glass_id varchar(20) DEFAULT NULL COMMENT '纾ㄨ竟鍓嶇幓鐠僫d', - width int NULL DEFAULT NULL COMMENT '瀹�', - height int NULL DEFAULT NULL COMMENT '楂�', - thickness int NULL DEFAULT NULL COMMENT '鍘�', - state int NULL DEFAULT NULL COMMENT '鐘舵��', - line int NULL DEFAULT NULL COMMENT '绾胯矾', - create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿' -) ENGINE = InnoDB ; +CREATE TABLE edg_glass_task_queue_info +( + glass_id varchar(20) DEFAULT NULL COMMENT '纾ㄨ竟鍓嶇幓鐠僫d', + width int NULL DEFAULT NULL COMMENT '瀹�', + height int NULL DEFAULT NULL COMMENT '楂�', + thickness int NULL DEFAULT NULL COMMENT '鍘�', + state int NULL DEFAULT NULL COMMENT '鐘舵��', + line int NULL DEFAULT NULL COMMENT '绾胯矾', + create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿' +) ENGINE = InnoDB; -- rollback DROP TABLE edg_glass_task_queue_info; -- changeset zsh:20241206023 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'edg_glass_task_queue_info'; -CREATE TABLE edg_storage_cage ( - id int NOT NULL COMMENT '纾ㄨ竟鍓嶇悊鐗囩琛╥d', - device_id int NULL DEFAULT NULL COMMENT '璁惧id', - slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', - enable_state int NULL DEFAULT NULL COMMENT '鍚敤鐘舵��', - remain_width int NULL DEFAULT NULL COMMENT '鍓╀綑', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB ; +CREATE TABLE edg_storage_cage +( + id int NOT NULL COMMENT '纾ㄨ竟鍓嶇悊鐗囩琛╥d', + device_id int NULL DEFAULT NULL COMMENT '璁惧id', + slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', + enable_state int NULL DEFAULT NULL COMMENT '鍚敤鐘舵��', + remain_width int NULL DEFAULT NULL COMMENT '鍓╀綑', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB; -- rollback DROP TABLE edg_glass_task_queue_info; -- changeset zsh:20241206024 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM edg_storage_cage; -INSERT INTO edg_storage_cage VALUES (1, 1, 1, 1, 2500); -INSERT INTO edg_storage_cage VALUES (2, 1, 2, 1, 2500); -INSERT INTO edg_storage_cage VALUES (3, 1, 3, 1, 2500); -INSERT INTO edg_storage_cage VALUES (4, 1, 4, 1, 2500); -INSERT INTO edg_storage_cage VALUES (5, 1, 5, 1, 2500); -INSERT INTO edg_storage_cage VALUES (6, 1, 6, 1, 2500); -INSERT INTO edg_storage_cage VALUES (7, 1, 7, 1, 2500); -INSERT INTO edg_storage_cage VALUES (8, 1, 8, 1, 2500); -INSERT INTO edg_storage_cage VALUES (9, 1, 9, 1, 2500); -INSERT INTO edg_storage_cage VALUES (10, 2, 1, 1, 2500); -INSERT INTO edg_storage_cage VALUES (11, 2, 2, 1, 2500); -INSERT INTO edg_storage_cage VALUES (12, 2, 3, 1, 2500); -INSERT INTO edg_storage_cage VALUES (13, 2, 4, 1, 2500); -INSERT INTO edg_storage_cage VALUES (14, 2, 5, 1, 2500); -INSERT INTO edg_storage_cage VALUES (15, 2, 6, 1, 2500); -INSERT INTO edg_storage_cage VALUES (16, 2, 7, 1, 2500); -INSERT INTO edg_storage_cage VALUES (17, 2, 8, 1, 2500); -INSERT INTO edg_storage_cage VALUES (18, 2, 9, 1, 2500); +INSERT INTO edg_storage_cage +VALUES (1, 1, 1, 1, 2500); +INSERT INTO edg_storage_cage +VALUES (2, 1, 2, 1, 2500); +INSERT INTO edg_storage_cage +VALUES (3, 1, 3, 1, 2500); +INSERT INTO edg_storage_cage +VALUES (4, 1, 4, 1, 2500); +INSERT INTO edg_storage_cage +VALUES (5, 1, 5, 1, 2500); +INSERT INTO edg_storage_cage +VALUES (6, 1, 6, 1, 2500); +INSERT INTO edg_storage_cage +VALUES (7, 1, 7, 1, 2500); +INSERT INTO edg_storage_cage +VALUES (8, 1, 8, 1, 2500); +INSERT INTO edg_storage_cage +VALUES (9, 1, 9, 1, 2500); +INSERT INTO edg_storage_cage +VALUES (10, 2, 1, 1, 2500); +INSERT INTO edg_storage_cage +VALUES (11, 2, 2, 1, 2500); +INSERT INTO edg_storage_cage +VALUES (12, 2, 3, 1, 2500); +INSERT INTO edg_storage_cage +VALUES (13, 2, 4, 1, 2500); +INSERT INTO edg_storage_cage +VALUES (14, 2, 5, 1, 2500); +INSERT INTO edg_storage_cage +VALUES (15, 2, 6, 1, 2500); +INSERT INTO edg_storage_cage +VALUES (16, 2, 7, 1, 2500); +INSERT INTO edg_storage_cage +VALUES (17, 2, 8, 1, 2500); +INSERT INTO edg_storage_cage +VALUES (18, 2, 9, 1, 2500); -- changeset zsh:20241206025 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'edg_storage_cage_details'; -CREATE TABLE edg_storage_cage_details ( - id bigint NOT NULL AUTO_INCREMENT COMMENT '纾ㄨ竟鍓嶇悊鐗囩璇︽儏琛╥d', - device_id int NULL DEFAULT NULL COMMENT '璁惧id', - engineer_id varchar(32) DEFAULT NULL COMMENT '宸ョ▼鍙�', - slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', - glass_id varchar(255) DEFAULT NULL COMMENT '鐜荤拑id', - sequence int NULL DEFAULT NULL COMMENT '灏忕墖鍦ㄦ牸鍐呯殑椤哄簭', - flow_card_id varchar(20) DEFAULT NULL COMMENT '娴佺▼鍗″彿', - glass_type int NULL DEFAULT NULL COMMENT '鐜荤拑绫诲瀷', - width double NULL DEFAULT NULL COMMENT '瀹�', - height double NULL DEFAULT NULL COMMENT '楂�', - thickness double NULL DEFAULT NULL COMMENT '鍘氬害', - edg_width double NULL DEFAULT NULL COMMENT '纾ㄥ墠瀹�', - edg_height double NULL DEFAULT NULL COMMENT '纾ㄥ墠楂�', - tempering_layout_id int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘id', - tempering_feed_sequence int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘鐗囧簭', - pattern_sequence int NULL DEFAULT NULL COMMENT '鍘熺墖椤哄簭', - state int NULL DEFAULT NULL COMMENT '鐘舵�� 锛堟湭璇嗗埆0 璇嗗埆鍚庢垚鍔熺姸鎬�100锛�110杩涚（杈规満 120鍑虹（杈规満 璇嗗埆锛氱牬鎹�201,鎷胯蛋200 纾ㄨ竟:鐮存崯301,鎷胯蛋300锛�', - gap int NULL DEFAULT NULL COMMENT '鐜荤拑闂撮殭', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE edg_storage_cage_details +( + id bigint NOT NULL AUTO_INCREMENT COMMENT '纾ㄨ竟鍓嶇悊鐗囩璇︽儏琛╥d', + device_id int NULL DEFAULT NULL COMMENT '璁惧id', + engineer_id varchar(32) DEFAULT NULL COMMENT '宸ョ▼鍙�', + slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', + glass_id varchar(255) DEFAULT NULL COMMENT '鐜荤拑id', + sequence int NULL DEFAULT NULL COMMENT '灏忕墖鍦ㄦ牸鍐呯殑椤哄簭', + flow_card_id varchar(20) DEFAULT NULL COMMENT '娴佺▼鍗″彿', + glass_type int NULL DEFAULT NULL COMMENT '鐜荤拑绫诲瀷', + width double NULL DEFAULT NULL COMMENT '瀹�', + height double NULL DEFAULT NULL COMMENT '楂�', + thickness double NULL DEFAULT NULL COMMENT '鍘氬害', + edg_width double NULL DEFAULT NULL COMMENT '纾ㄥ墠瀹�', + edg_height double NULL DEFAULT NULL COMMENT '纾ㄥ墠楂�', + tempering_layout_id int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘id', + tempering_feed_sequence int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘鐗囧簭', + pattern_sequence int NULL DEFAULT NULL COMMENT '鍘熺墖椤哄簭', + state int NULL DEFAULT NULL COMMENT '鐘舵�� 锛堟湭璇嗗埆0 璇嗗埆鍚庢垚鍔熺姸鎬�100锛�110杩涚（杈规満 120鍑虹（杈规満 璇嗗埆锛氱牬鎹�201,鎷胯蛋200 纾ㄨ竟:鐮存崯301,鎷胯蛋300锛�', + gap int NULL DEFAULT NULL COMMENT '鐜荤拑闂撮殭', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE edg_storage_cage_details; -- changeset zsh:20241206026 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'edg_storage_device_one_task'; -CREATE TABLE edg_storage_device_one_task ( - task_running int NULL DEFAULT NULL COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1杩涚墖 2鍑虹墖 3鐩撮��', - glass_id_in varchar(20) DEFAULT NULL COMMENT '杩涚墖鐜荤拑id', - glass_id_out varchar(20) DEFAULT NULL COMMENT '鍑虹墖鐜荤拑id', - glass_id varchar(20) DEFAULT NULL COMMENT '纾ㄨ竟鍓嶇幓鐠僫d', - current_cell int NULL DEFAULT 0 COMMENT '褰撳墠灞傚彿', - start_cell int NULL DEFAULT 0 COMMENT '灞傚彿', - end_cell int NULL DEFAULT NULL COMMENT '棰勭暀灞傚彿', - task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0榛樿绌轰换鍔� 1鎵ц涓� 2缁撴潫浠诲姟', - task_type int NULL DEFAULT NULL COMMENT '浠诲姟绫诲瀷', - create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - in_place int NULL DEFAULT NULL COMMENT '鏄惁鍒颁綅' -) ENGINE = InnoDB ; +CREATE TABLE edg_storage_device_one_task +( + task_running int NULL DEFAULT NULL COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1杩涚墖 2鍑虹墖 3鐩撮��', + glass_id_in varchar(20) DEFAULT NULL COMMENT '杩涚墖鐜荤拑id', + glass_id_out varchar(20) DEFAULT NULL COMMENT '鍑虹墖鐜荤拑id', + glass_id varchar(20) DEFAULT NULL COMMENT '纾ㄨ竟鍓嶇幓鐠僫d', + current_cell int NULL DEFAULT 0 COMMENT '褰撳墠灞傚彿', + start_cell int NULL DEFAULT 0 COMMENT '灞傚彿', + end_cell int NULL DEFAULT NULL COMMENT '棰勭暀灞傚彿', + task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0榛樿绌轰换鍔� 1鎵ц涓� 2缁撴潫浠诲姟', + task_type int NULL DEFAULT NULL COMMENT '浠诲姟绫诲瀷', + create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + in_place int NULL DEFAULT NULL COMMENT '鏄惁鍒颁綅' +) ENGINE = InnoDB; -- rollback DROP TABLE edg_storage_device_one_task; -- changeset zsh:20241206027 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM edg_storage_device_one_task; -INSERT INTO edg_storage_device_one_task VALUES (0, NULL, NULL, '', 1, 0, NULL, 2, NULL, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); +INSERT INTO edg_storage_device_one_task +VALUES (0, NULL, NULL, '', 1, 0, NULL, 2, NULL, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); -- changeset zsh:20241206028 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'edg_storage_device_task_history'; -CREATE TABLE edg_storage_device_task_history ( - id bigint NOT NULL AUTO_INCREMENT COMMENT '宸ョ▼琛╥d', - glass_id_in varchar(20) DEFAULT NULL COMMENT '杩涚墖鐜荤拑id', - glass_id_out varchar(20) DEFAULT NULL COMMENT '鍑虹墖鐜荤拑id', - current_cell int NULL DEFAULT 0 COMMENT '褰撳墠灞傚彿', - start_cell int NULL DEFAULT 0 COMMENT '灞傚彿', - end_cell int NULL DEFAULT NULL COMMENT '棰勭暀灞傚彿', - task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0榛樿绌轰换鍔� 1鎵ц涓� 2缁撴潫浠诲姟', - task_type int NULL DEFAULT NULL COMMENT '浠诲姟绫诲瀷', - create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - device_id int NULL DEFAULT NULL COMMENT '璁惧id', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE edg_storage_device_task_history +( + id bigint NOT NULL AUTO_INCREMENT COMMENT '宸ョ▼琛╥d', + glass_id_in varchar(20) DEFAULT NULL COMMENT '杩涚墖鐜荤拑id', + glass_id_out varchar(20) DEFAULT NULL COMMENT '鍑虹墖鐜荤拑id', + current_cell int NULL DEFAULT 0 COMMENT '褰撳墠灞傚彿', + start_cell int NULL DEFAULT 0 COMMENT '灞傚彿', + end_cell int NULL DEFAULT NULL COMMENT '棰勭暀灞傚彿', + task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0榛樿绌轰换鍔� 1鎵ц涓� 2缁撴潫浠诲姟', + task_type int NULL DEFAULT NULL COMMENT '浠诲姟绫诲瀷', + create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + device_id int NULL DEFAULT NULL COMMENT '璁惧id', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE edg_storage_device_task_history; -- changeset zsh:20241206029 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'edg_storage_device_two_task'; -CREATE TABLE edg_storage_device_two_task ( - task_running int NULL DEFAULT NULL COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1杩涚墖 2鍑虹墖 3鐩撮��', - glass_id_in varchar(20) DEFAULT NULL COMMENT '杩涚墖鐜荤拑id', - glass_id_out varchar(20) DEFAULT NULL COMMENT '鍑虹墖鐜荤拑id', - glass_id varchar(20) DEFAULT NULL COMMENT '纾ㄨ竟鍓嶇幓鐠僫d', - current_cell int NULL DEFAULT 0 COMMENT '褰撳墠灞傚彿', - start_cell int NULL DEFAULT 0 COMMENT '灞傚彿', - end_cell int NULL DEFAULT NULL COMMENT '棰勭暀灞傚彿', - task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0榛樿绌轰换鍔� 1鎵ц涓� 2缁撴潫浠诲姟', - task_type int NULL DEFAULT NULL COMMENT '浠诲姟绫诲瀷', - create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - in_place int NULL DEFAULT NULL COMMENT '鏄惁鍒颁綅' -) ENGINE = InnoDB ; +CREATE TABLE edg_storage_device_two_task +( + task_running int NULL DEFAULT NULL COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1杩涚墖 2鍑虹墖 3鐩撮��', + glass_id_in varchar(20) DEFAULT NULL COMMENT '杩涚墖鐜荤拑id', + glass_id_out varchar(20) DEFAULT NULL COMMENT '鍑虹墖鐜荤拑id', + glass_id varchar(20) DEFAULT NULL COMMENT '纾ㄨ竟鍓嶇幓鐠僫d', + current_cell int NULL DEFAULT 0 COMMENT '褰撳墠灞傚彿', + start_cell int NULL DEFAULT 0 COMMENT '灞傚彿', + end_cell int NULL DEFAULT NULL COMMENT '棰勭暀灞傚彿', + task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0榛樿绌轰换鍔� 1鎵ц涓� 2缁撴潫浠诲姟', + task_type int NULL DEFAULT NULL COMMENT '浠诲姟绫诲瀷', + create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + in_place int NULL DEFAULT NULL COMMENT '鏄惁鍒颁綅' +) ENGINE = InnoDB; -- rollback DROP TABLE edg_storage_device_two_task; -- changeset zsh:20241206030 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM edg_storage_device_two_task; -INSERT INTO edg_storage_device_two_task VALUES (0, NULL, NULL, '', 1, 0, NULL, 2, NULL, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); +INSERT INTO edg_storage_device_two_task +VALUES (0, NULL, NULL, '', 1, 0, NULL, 2, NULL, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); -- changeset zsh:20241206031 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'engineering'; -CREATE TABLE engineering ( - id bigint NOT NULL AUTO_INCREMENT COMMENT '宸ョ▼琛╥d', - engineer_id varchar(20) DEFAULT NULL COMMENT '宸ョ▼鍙�', - engineer_name varchar(255) DEFAULT NULL COMMENT '宸ョ▼鍚嶇О', - avg_availability varchar(20) DEFAULT NULL COMMENT '骞冲潎鍒╃敤鐜�', - valid_availability varchar(20) DEFAULT NULL COMMENT '鏈夋晥鍒╃敤鐜�', - last_availability varchar(20) DEFAULT NULL COMMENT '灏剧墖鍒╃敤鐜�', - state int NULL DEFAULT NULL COMMENT '鐘舵��', - glass_total int NULL DEFAULT NULL COMMENT '灏忕墖鎬绘暟', - glass_total_area double NULL DEFAULT NULL COMMENT '灏忕墖鎬婚潰绉�', - plan_pattern_total int NULL DEFAULT NULL COMMENT '璁″垝鍘熺墖鎬绘暟', - plan_pattern_total_area double NULL DEFAULT NULL COMMENT '璁″垝鍘熺墖鎬婚潰绉�', - reality_pattern_total int NULL DEFAULT NULL COMMENT '瀹為檯鍘熺墖鎬绘暟', - reality_pattern_total_area double NULL DEFAULT NULL COMMENT '瀹為檯鍘熺墖鎬婚潰绉�', - films_id varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鑶滅郴id', - notes varchar(255) DEFAULT NULL COMMENT '澶囨敞', - film_remove int NULL DEFAULT NULL, - station_cell int NULL DEFAULT NULL, - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE engineering +( + id bigint NOT NULL AUTO_INCREMENT COMMENT '宸ョ▼琛╥d', + engineer_id varchar(20) DEFAULT NULL COMMENT '宸ョ▼鍙�', + engineer_name varchar(255) DEFAULT NULL COMMENT '宸ョ▼鍚嶇О', + avg_availability varchar(20) DEFAULT NULL COMMENT '骞冲潎鍒╃敤鐜�', + valid_availability varchar(20) DEFAULT NULL COMMENT '鏈夋晥鍒╃敤鐜�', + last_availability varchar(20) DEFAULT NULL COMMENT '灏剧墖鍒╃敤鐜�', + state int NULL DEFAULT NULL COMMENT '鐘舵��', + glass_total int NULL DEFAULT NULL COMMENT '灏忕墖鎬绘暟', + glass_total_area double NULL DEFAULT NULL COMMENT '灏忕墖鎬婚潰绉�', + plan_pattern_total int NULL DEFAULT NULL COMMENT '璁″垝鍘熺墖鎬绘暟', + plan_pattern_total_area double NULL DEFAULT NULL COMMENT '璁″垝鍘熺墖鎬婚潰绉�', + reality_pattern_total int NULL DEFAULT NULL COMMENT '瀹為檯鍘熺墖鎬绘暟', + reality_pattern_total_area double NULL DEFAULT NULL COMMENT '瀹為檯鍘熺墖鎬婚潰绉�', + films_id varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鑶滅郴id', + notes varchar(255) DEFAULT NULL COMMENT '澶囨敞', + film_remove int NULL DEFAULT NULL, + station_cell int NULL DEFAULT NULL, + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE engineering; -- changeset zsh:20241206032 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'glass_films'; -CREATE TABLE glass_films ( - id int NOT NULL AUTO_INCREMENT COMMENT '鑶滅郴琛╥d', - films_id int NULL DEFAULT NULL COMMENT '鑶滅郴id', - films_name varchar(255) DEFAULT NULL COMMENT '鑶滅郴', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE glass_films +( + id int NOT NULL AUTO_INCREMENT COMMENT '鑶滅郴琛╥d', + films_id int NULL DEFAULT NULL COMMENT '鑶滅郴id', + films_name varchar(255) DEFAULT NULL COMMENT '鑶滅郴', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE glass_films; -- changeset zsh:20241206033 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'glass_info'; -CREATE TABLE glass_info ( - id bigint NOT NULL AUTO_INCREMENT COMMENT '鐜荤拑淇℃伅琛╥d', - flow_card_id varchar(50) DEFAULT NULL COMMENT '娴佺▼鍗�', - glass_type int NULL DEFAULT NULL COMMENT '娴佺▼鍗＄幓鐠冪被鍨�', - width double NULL DEFAULT NULL COMMENT '瀹�', - height double NULL DEFAULT NULL COMMENT '楂�', - thickness double NULL DEFAULT NULL COMMENT '鍘氬害', - filmsid varchar(20) DEFAULT NULL COMMENT '鑶滅郴', - total_layer int NULL DEFAULT NULL COMMENT '鎬诲眰鏁�', - layer int NULL DEFAULT NULL COMMENT '灞傛暟', - edg_width double NULL DEFAULT NULL COMMENT '纾ㄥ墠瀹�', - edg_height double NULL DEFAULT NULL COMMENT '纾ㄥ墠楂�', - ismultiple int NULL DEFAULT NULL COMMENT '鏄惁閰嶇墖', - max_width double NULL DEFAULT NULL COMMENT '閰嶇墖鏈�澶у', - max_height double NULL DEFAULT NULL COMMENT '閰嶇墖鏈�澶ч珮', - ishorizontal int NULL DEFAULT NULL COMMENT '閽㈠寲鏄惁鎺ュ彈妯斁', - pattern_sequence int NULL DEFAULT NULL COMMENT '鍘熺墖椤哄簭', - tempering_layout_id int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘id', - tempering_feed_sequence int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘鐗囧簭', - x_coordinate int NULL DEFAULT NULL COMMENT 'x鍧愭爣', - y_coordinate int NULL DEFAULT NULL COMMENT 'y鍧愭爣', - angle int NULL DEFAULT NULL COMMENT '鏃嬭浆瑙掑害锛堥�嗘椂閽堬級', - engineer_id varchar(20) DEFAULT NULL COMMENT '宸ョ▼鍙�', - rule_id int NULL DEFAULT NULL COMMENT '鐢熶骇瑙勫垯id', - glass_id varchar(50) DEFAULT NULL COMMENT '鐜荤拑ID', - combine int NULL DEFAULT NULL, - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE glass_info +( + id bigint NOT NULL AUTO_INCREMENT COMMENT '鐜荤拑淇℃伅琛╥d', + flow_card_id varchar(50) DEFAULT NULL COMMENT '娴佺▼鍗�', + glass_type int NULL DEFAULT NULL COMMENT '娴佺▼鍗＄幓鐠冪被鍨�', + width double NULL DEFAULT NULL COMMENT '瀹�', + height double NULL DEFAULT NULL COMMENT '楂�', + thickness double NULL DEFAULT NULL COMMENT '鍘氬害', + filmsid varchar(20) DEFAULT NULL COMMENT '鑶滅郴', + total_layer int NULL DEFAULT NULL COMMENT '鎬诲眰鏁�', + layer int NULL DEFAULT NULL COMMENT '灞傛暟', + edg_width double NULL DEFAULT NULL COMMENT '纾ㄥ墠瀹�', + edg_height double NULL DEFAULT NULL COMMENT '纾ㄥ墠楂�', + ismultiple int NULL DEFAULT NULL COMMENT '鏄惁閰嶇墖', + max_width double NULL DEFAULT NULL COMMENT '閰嶇墖鏈�澶у', + max_height double NULL DEFAULT NULL COMMENT '閰嶇墖鏈�澶ч珮', + ishorizontal int NULL DEFAULT NULL COMMENT '閽㈠寲鏄惁鎺ュ彈妯斁', + pattern_sequence int NULL DEFAULT NULL COMMENT '鍘熺墖椤哄簭', + tempering_layout_id int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘id', + tempering_feed_sequence int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘鐗囧簭', + x_coordinate int NULL DEFAULT NULL COMMENT 'x鍧愭爣', + y_coordinate int NULL DEFAULT NULL COMMENT 'y鍧愭爣', + angle int NULL DEFAULT NULL COMMENT '鏃嬭浆瑙掑害锛堥�嗘椂閽堬級', + engineer_id varchar(20) DEFAULT NULL COMMENT '宸ョ▼鍙�', + rule_id int NULL DEFAULT NULL COMMENT '鐢熶骇瑙勫垯id', + glass_id varchar(50) DEFAULT NULL COMMENT '鐜荤拑ID', + combine int NULL DEFAULT NULL, + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE glass_info; -- changeset zsh:20241206034 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'hollow_big_storage_cage'; -CREATE TABLE hollow_big_storage_cage ( - id bigint NOT NULL COMMENT '澶х悊鐗囩琛╥d', - device_id int NULL DEFAULT NULL COMMENT '璁惧id', - slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', - min_thickness int NULL DEFAULT NULL COMMENT '鏈�灏忓帤搴�', - max_thickness int NULL DEFAULT NULL COMMENT '鏈�澶у帤搴�', - enable_state int NULL DEFAULT NULL COMMENT '鍚敤鐘舵��', - remain_width int NULL DEFAULT NULL COMMENT '鍓╀綑瀹藉害', - PRIMARY KEY (id) USING BTREE +CREATE TABLE hollow_big_storage_cage +( + id bigint NOT NULL COMMENT '澶х悊鐗囩琛╥d', + device_id int NULL DEFAULT NULL COMMENT '璁惧id', + slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', + min_thickness int NULL DEFAULT NULL COMMENT '鏈�灏忓帤搴�', + max_thickness int NULL DEFAULT NULL COMMENT '鏈�澶у帤搴�', + enable_state int NULL DEFAULT NULL COMMENT '鍚敤鐘舵��', + remain_width int NULL DEFAULT NULL COMMENT '鍓╀綑瀹藉害', + PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB; -- rollback DROP TABLE hollow_big_storage_cage; @@ -765,898 +1066,1382 @@ -- changeset zsh:20241206035 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM hollow_big_storage_cage; -INSERT INTO hollow_big_storage_cage VALUES (1, 1, 1, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (2, 1, 2, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (3, 1, 3, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (4, 1, 4, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (5, 1, 5, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (6, 1, 6, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (7, 1, 7, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (8, 1, 8, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (9, 1, 9, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (10, 1, 10, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (11, 1, 11, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (12, 1, 12, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (13, 1, 13, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (14, 1, 14, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (15, 1, 15, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (16, 1, 16, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (17, 1, 17, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (18, 1, 18, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (19, 1, 19, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (20, 1, 20, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (21, 1, 21, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (22, 1, 22, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (23, 1, 23, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (24, 1, 24, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (25, 1, 25, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (26, 1, 26, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (27, 1, 27, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (28, 1, 28, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (29, 1, 29, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (30, 1, 30, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (31, 1, 31, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (32, 1, 32, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (33, 1, 33, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (34, 1, 34, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (35, 1, 35, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (36, 1, 36, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (37, 1, 37, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (38, 1, 38, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (39, 1, 39, 4, 6, 0, 6200); -INSERT INTO hollow_big_storage_cage VALUES (40, 1, 40, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (41, 2, 41, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (42, 2, 42, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (43, 2, 43, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (44, 2, 44, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (45, 2, 45, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (46, 2, 46, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (47, 2, 47, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (48, 2, 48, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (49, 2, 49, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (50, 2, 50, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (51, 2, 51, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (52, 2, 52, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (53, 2, 53, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (54, 2, 54, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (55, 2, 55, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (56, 2, 56, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (57, 2, 57, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (58, 2, 58, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (59, 2, 59, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (60, 2, 60, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (61, 2, 61, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (62, 2, 62, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (63, 2, 63, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (64, 2, 64, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (65, 2, 65, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (66, 2, 66, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (67, 2, 67, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (68, 2, 68, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (69, 2, 69, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (70, 2, 70, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (71, 2, 71, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (72, 2, 72, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (73, 2, 73, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (74, 2, 74, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (75, 2, 75, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (76, 2, 76, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (77, 2, 77, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (78, 2, 78, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (79, 2, 79, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (80, 2, 80, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (81, 2, 81, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (82, 2, 82, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (83, 2, 83, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (84, 2, 84, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (85, 2, 85, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (86, 2, 86, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (87, 2, 87, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (88, 2, 88, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (89, 2, 89, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (90, 2, 90, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (91, 2, 91, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (92, 2, 92, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (93, 2, 93, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (94, 2, 94, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (95, 2, 95, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (96, 3, 96, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (97, 3, 97, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (98, 3, 98, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (99, 3, 99, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (100, 3, 100, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (101, 3, 101, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (102, 3, 102, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (103, 3, 103, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (104, 3, 104, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (105, 3, 105, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (106, 3, 106, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (107, 3, 107, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (108, 3, 108, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (109, 3, 109, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (110, 3, 110, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (111, 3, 111, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (112, 3, 112, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (113, 3, 113, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (114, 3, 114, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (115, 3, 115, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (116, 3, 116, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (117, 3, 117, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (118, 3, 118, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (119, 3, 119, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (120, 3, 120, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (121, 3, 121, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (122, 3, 122, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (123, 3, 123, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (124, 3, 124, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (125, 3, 125, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (126, 3, 126, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (127, 3, 127, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (128, 3, 128, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (129, 3, 129, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (130, 3, 130, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (131, 3, 131, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (132, 3, 132, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (133, 3, 133, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (134, 3, 134, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (135, 3, 135, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (136, 3, 136, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (137, 3, 137, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (138, 3, 138, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (139, 3, 139, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (140, 3, 140, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (141, 3, 141, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (142, 3, 142, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (143, 3, 143, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (144, 3, 144, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (145, 3, 145, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (146, 3, 146, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (147, 3, 147, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (148, 3, 148, 4, 6, 0, 6200); -INSERT INTO hollow_big_storage_cage VALUES (149, 3, 149, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (150, 3, 150, 4, 6, 0, 6200); -INSERT INTO hollow_big_storage_cage VALUES (151, 4, 151, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (152, 4, 152, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (153, 4, 153, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (154, 4, 154, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (155, 4, 155, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (156, 4, 156, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (157, 4, 157, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (158, 4, 158, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (159, 4, 159, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (160, 4, 160, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (161, 4, 161, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (162, 4, 162, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (163, 4, 163, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (164, 4, 164, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (165, 4, 165, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (166, 4, 166, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (167, 4, 167, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (168, 4, 168, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (169, 4, 169, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (170, 4, 170, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (171, 4, 171, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (172, 4, 172, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (173, 4, 173, 4, 6, 0, 6200); -INSERT INTO hollow_big_storage_cage VALUES (174, 4, 174, 4, 6, 0, 6200); -INSERT INTO hollow_big_storage_cage VALUES (175, 4, 175, 4, 6, 0, 6200); -INSERT INTO hollow_big_storage_cage VALUES (176, 4, 176, 4, 6, 0, 6200); -INSERT INTO hollow_big_storage_cage VALUES (177, 4, 177, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (178, 4, 178, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (179, 4, 179, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (180, 4, 180, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (181, 4, 181, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (182, 4, 182, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (183, 4, 183, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (184, 4, 184, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (185, 4, 185, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (186, 4, 186, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (187, 4, 187, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (188, 4, 188, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (189, 4, 189, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (190, 4, 190, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (191, 4, 191, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (192, 4, 192, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (193, 4, 193, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (194, 4, 194, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (195, 4, 195, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (196, 4, 196, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (197, 4, 197, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (198, 4, 198, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (199, 4, 199, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (200, 4, 200, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (201, 4, 201, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (202, 4, 202, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (203, 4, 203, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (204, 4, 204, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (205, 4, 205, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (206, 5, 206, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (207, 5, 207, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (208, 5, 208, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (209, 5, 209, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (210, 5, 210, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (211, 5, 211, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (212, 5, 212, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (213, 5, 213, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (214, 5, 214, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (215, 5, 215, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (216, 5, 216, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (217, 5, 217, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (218, 5, 218, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (219, 5, 219, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (220, 5, 220, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (221, 5, 221, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (222, 5, 222, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (223, 5, 223, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (224, 5, 224, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (225, 5, 225, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (226, 5, 226, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (227, 5, 227, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (228, 5, 228, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (229, 5, 229, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (230, 5, 230, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (231, 5, 231, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (232, 5, 232, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (233, 5, 233, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (234, 5, 234, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (235, 5, 235, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (236, 5, 236, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (237, 5, 237, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (238, 5, 238, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (239, 5, 239, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (240, 5, 240, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (241, 5, 241, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (242, 5, 242, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (243, 5, 243, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (244, 5, 244, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (245, 5, 245, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (246, 5, 246, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (247, 5, 247, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (248, 5, 248, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (249, 5, 249, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (250, 5, 250, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (251, 5, 251, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (252, 5, 252, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (253, 5, 253, 4, 6, 1, 6200); -INSERT INTO hollow_big_storage_cage VALUES (254, 5, 254, 4, 6, 0, 6200); -INSERT INTO hollow_big_storage_cage VALUES (255, 5, 255, 4, 6, 0, 6200); -INSERT INTO hollow_big_storage_cage VALUES (256, 5, 256, 4, 6, 0, 6200); -INSERT INTO hollow_big_storage_cage VALUES (257, 5, 257, 4, 6, 0, 6200); -INSERT INTO hollow_big_storage_cage VALUES (258, 5, 258, 4, 6, 0, 6200); -INSERT INTO hollow_big_storage_cage VALUES (259, 5, 259, 4, 6, 0, 6200); -INSERT INTO hollow_big_storage_cage VALUES (260, 5, 260, 4, 6, 0, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (1, 1, 1, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (2, 1, 2, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (3, 1, 3, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (4, 1, 4, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (5, 1, 5, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (6, 1, 6, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (7, 1, 7, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (8, 1, 8, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (9, 1, 9, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (10, 1, 10, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (11, 1, 11, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (12, 1, 12, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (13, 1, 13, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (14, 1, 14, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (15, 1, 15, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (16, 1, 16, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (17, 1, 17, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (18, 1, 18, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (19, 1, 19, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (20, 1, 20, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (21, 1, 21, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (22, 1, 22, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (23, 1, 23, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (24, 1, 24, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (25, 1, 25, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (26, 1, 26, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (27, 1, 27, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (28, 1, 28, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (29, 1, 29, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (30, 1, 30, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (31, 1, 31, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (32, 1, 32, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (33, 1, 33, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (34, 1, 34, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (35, 1, 35, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (36, 1, 36, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (37, 1, 37, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (38, 1, 38, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (39, 1, 39, 4, 6, 0, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (40, 1, 40, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (41, 2, 41, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (42, 2, 42, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (43, 2, 43, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (44, 2, 44, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (45, 2, 45, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (46, 2, 46, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (47, 2, 47, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (48, 2, 48, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (49, 2, 49, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (50, 2, 50, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (51, 2, 51, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (52, 2, 52, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (53, 2, 53, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (54, 2, 54, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (55, 2, 55, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (56, 2, 56, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (57, 2, 57, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (58, 2, 58, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (59, 2, 59, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (60, 2, 60, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (61, 2, 61, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (62, 2, 62, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (63, 2, 63, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (64, 2, 64, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (65, 2, 65, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (66, 2, 66, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (67, 2, 67, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (68, 2, 68, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (69, 2, 69, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (70, 2, 70, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (71, 2, 71, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (72, 2, 72, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (73, 2, 73, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (74, 2, 74, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (75, 2, 75, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (76, 2, 76, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (77, 2, 77, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (78, 2, 78, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (79, 2, 79, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (80, 2, 80, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (81, 2, 81, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (82, 2, 82, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (83, 2, 83, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (84, 2, 84, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (85, 2, 85, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (86, 2, 86, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (87, 2, 87, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (88, 2, 88, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (89, 2, 89, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (90, 2, 90, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (91, 2, 91, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (92, 2, 92, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (93, 2, 93, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (94, 2, 94, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (95, 2, 95, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (96, 3, 96, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (97, 3, 97, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (98, 3, 98, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (99, 3, 99, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (100, 3, 100, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (101, 3, 101, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (102, 3, 102, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (103, 3, 103, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (104, 3, 104, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (105, 3, 105, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (106, 3, 106, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (107, 3, 107, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (108, 3, 108, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (109, 3, 109, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (110, 3, 110, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (111, 3, 111, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (112, 3, 112, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (113, 3, 113, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (114, 3, 114, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (115, 3, 115, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (116, 3, 116, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (117, 3, 117, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (118, 3, 118, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (119, 3, 119, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (120, 3, 120, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (121, 3, 121, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (122, 3, 122, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (123, 3, 123, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (124, 3, 124, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (125, 3, 125, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (126, 3, 126, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (127, 3, 127, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (128, 3, 128, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (129, 3, 129, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (130, 3, 130, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (131, 3, 131, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (132, 3, 132, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (133, 3, 133, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (134, 3, 134, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (135, 3, 135, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (136, 3, 136, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (137, 3, 137, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (138, 3, 138, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (139, 3, 139, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (140, 3, 140, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (141, 3, 141, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (142, 3, 142, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (143, 3, 143, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (144, 3, 144, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (145, 3, 145, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (146, 3, 146, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (147, 3, 147, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (148, 3, 148, 4, 6, 0, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (149, 3, 149, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (150, 3, 150, 4, 6, 0, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (151, 4, 151, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (152, 4, 152, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (153, 4, 153, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (154, 4, 154, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (155, 4, 155, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (156, 4, 156, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (157, 4, 157, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (158, 4, 158, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (159, 4, 159, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (160, 4, 160, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (161, 4, 161, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (162, 4, 162, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (163, 4, 163, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (164, 4, 164, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (165, 4, 165, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (166, 4, 166, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (167, 4, 167, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (168, 4, 168, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (169, 4, 169, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (170, 4, 170, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (171, 4, 171, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (172, 4, 172, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (173, 4, 173, 4, 6, 0, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (174, 4, 174, 4, 6, 0, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (175, 4, 175, 4, 6, 0, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (176, 4, 176, 4, 6, 0, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (177, 4, 177, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (178, 4, 178, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (179, 4, 179, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (180, 4, 180, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (181, 4, 181, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (182, 4, 182, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (183, 4, 183, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (184, 4, 184, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (185, 4, 185, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (186, 4, 186, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (187, 4, 187, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (188, 4, 188, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (189, 4, 189, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (190, 4, 190, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (191, 4, 191, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (192, 4, 192, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (193, 4, 193, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (194, 4, 194, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (195, 4, 195, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (196, 4, 196, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (197, 4, 197, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (198, 4, 198, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (199, 4, 199, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (200, 4, 200, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (201, 4, 201, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (202, 4, 202, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (203, 4, 203, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (204, 4, 204, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (205, 4, 205, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (206, 5, 206, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (207, 5, 207, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (208, 5, 208, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (209, 5, 209, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (210, 5, 210, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (211, 5, 211, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (212, 5, 212, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (213, 5, 213, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (214, 5, 214, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (215, 5, 215, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (216, 5, 216, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (217, 5, 217, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (218, 5, 218, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (219, 5, 219, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (220, 5, 220, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (221, 5, 221, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (222, 5, 222, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (223, 5, 223, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (224, 5, 224, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (225, 5, 225, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (226, 5, 226, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (227, 5, 227, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (228, 5, 228, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (229, 5, 229, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (230, 5, 230, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (231, 5, 231, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (232, 5, 232, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (233, 5, 233, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (234, 5, 234, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (235, 5, 235, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (236, 5, 236, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (237, 5, 237, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (238, 5, 238, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (239, 5, 239, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (240, 5, 240, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (241, 5, 241, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (242, 5, 242, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (243, 5, 243, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (244, 5, 244, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (245, 5, 245, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (246, 5, 246, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (247, 5, 247, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (248, 5, 248, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (249, 5, 249, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (250, 5, 250, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (251, 5, 251, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (252, 5, 252, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (253, 5, 253, 4, 6, 1, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (254, 5, 254, 4, 6, 0, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (255, 5, 255, 4, 6, 0, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (256, 5, 256, 4, 6, 0, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (257, 5, 257, 4, 6, 0, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (258, 5, 258, 4, 6, 0, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (259, 5, 259, 4, 6, 0, 6200); +INSERT INTO hollow_big_storage_cage +VALUES (260, 5, 260, 4, 6, 0, 6200); -- changeset zsh:20241206036 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'hollow_big_storage_cage_details'; -CREATE TABLE hollow_big_storage_cage_details ( - id bigint NOT NULL AUTO_INCREMENT COMMENT '澶х悊鐗囩璇︽儏琛╥d', - device_id int NULL DEFAULT NULL COMMENT '璁惧id', - virtual_slot int NULL DEFAULT NULL COMMENT '铏氭嫙鏍呮牸鍙�', - slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', - glass_id varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐜荤拑id', - sequence int NULL DEFAULT NULL COMMENT '灏忕墖鍦ㄦ牸鍐呯殑椤哄簭', - flow_card_id varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '娴佺▼鍗″彿', - glass_type int NULL DEFAULT NULL COMMENT '鐜荤拑绫诲瀷', - width double NULL DEFAULT NULL COMMENT '瀹�', - height double NULL DEFAULT NULL COMMENT '楂�', - thickness double NULL DEFAULT NULL COMMENT '鍘氬害', - tempering_layout_id int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘id', - tempering_feed_sequence int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘鐗囧簭', - state int NULL DEFAULT NULL COMMENT '鐘舵��', - gap int NULL DEFAULT NULL COMMENT '鐜荤拑闂撮殭', - engineer_id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, - total_layer int NULL DEFAULT NULL COMMENT '鎬诲眰鍙�', - layer int NULL DEFAULT NULL COMMENT '灞傚彿', - create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - hollow_sequence int NULL DEFAULT NULL COMMENT '涓┖椤哄簭', - films_id varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鑶滅郴', - is_pair int NULL DEFAULT NULL, - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE hollow_big_storage_cage_details +( + id bigint NOT NULL AUTO_INCREMENT COMMENT '澶х悊鐗囩璇︽儏琛╥d', + device_id int NULL DEFAULT NULL COMMENT '璁惧id', + virtual_slot int NULL DEFAULT NULL COMMENT '铏氭嫙鏍呮牸鍙�', + slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', + glass_id varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐜荤拑id', + sequence int NULL DEFAULT NULL COMMENT '灏忕墖鍦ㄦ牸鍐呯殑椤哄簭', + flow_card_id varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '娴佺▼鍗″彿', + glass_type int NULL DEFAULT NULL COMMENT '鐜荤拑绫诲瀷', + width double NULL DEFAULT NULL COMMENT '瀹�', + height double NULL DEFAULT NULL COMMENT '楂�', + thickness double NULL DEFAULT NULL COMMENT '鍘氬害', + tempering_layout_id int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘id', + tempering_feed_sequence int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘鐗囧簭', + state int NULL DEFAULT NULL COMMENT '鐘舵��', + gap int NULL DEFAULT NULL COMMENT '鐜荤拑闂撮殭', + engineer_id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, + total_layer int NULL DEFAULT NULL COMMENT '鎬诲眰鍙�', + layer int NULL DEFAULT NULL COMMENT '灞傚彿', + create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + hollow_sequence int NULL DEFAULT NULL COMMENT '涓┖椤哄簭', + films_id varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鑶滅郴', + is_pair int NULL DEFAULT NULL, + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE hollow_big_storage_cage_details; -- changeset zsh:20241206037 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'hollow_big_storage_cage_history_task'; -CREATE TABLE hollow_big_storage_cage_history_task ( - id bigint NOT NULL AUTO_INCREMENT, - glass_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐜荤拑id', - start_slot int NULL DEFAULT 0 COMMENT '璧峰鏍煎瓙', - target_slot int NULL DEFAULT 0 COMMENT '鐩爣鏍煎瓙', - task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� ', - glass_count int NULL DEFAULT NULL COMMENT '鐜荤拑鏁伴噺', - task_type int NULL DEFAULT NULL COMMENT '浠诲姟绫诲瀷', - create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE hollow_big_storage_cage_history_task +( + id bigint NOT NULL AUTO_INCREMENT, + glass_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐜荤拑id', + start_slot int NULL DEFAULT 0 COMMENT '璧峰鏍煎瓙', + target_slot int NULL DEFAULT 0 COMMENT '鐩爣鏍煎瓙', + task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� ', + glass_count int NULL DEFAULT NULL COMMENT '鐜荤拑鏁伴噺', + task_type int NULL DEFAULT NULL COMMENT '浠诲姟绫诲瀷', + create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE hollow_big_storage_cage_history_task; -- changeset zsh:20241206038 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'hollow_glass_out_relation_info'; -CREATE TABLE hollow_glass_out_relation_info ( - id bigint NOT NULL AUTO_INCREMENT COMMENT '涓┖鐜荤拑鍏崇郴琛╥d', - flow_card_id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '娴佺▼鍗�', - total_layer int NULL DEFAULT NULL COMMENT '鎬诲眰鏁�', - cell int NULL DEFAULT NULL COMMENT '璺嚎', - state int NULL DEFAULT NULL COMMENT '鐘舵��0鏂板 1鎵ц涓� 2鏆傚仠 3缁撴潫', - total_pair_quantity int NULL DEFAULT NULL, - create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - pair_quantity int NULL DEFAULT NULL COMMENT '宸查厤瀵规暟閲�', - is_force int NULL DEFAULT NULL COMMENT '鏄惁寮哄埗', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE hollow_glass_out_relation_info +( + id bigint NOT NULL AUTO_INCREMENT COMMENT '涓┖鐜荤拑鍏崇郴琛╥d', + flow_card_id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '娴佺▼鍗�', + total_layer int NULL DEFAULT NULL COMMENT '鎬诲眰鏁�', + cell int NULL DEFAULT NULL COMMENT '璺嚎', + state int NULL DEFAULT NULL COMMENT '鐘舵��0鏂板 1鎵ц涓� 2鏆傚仠 3缁撴潫', + total_pair_quantity int NULL DEFAULT NULL, + create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + pair_quantity int NULL DEFAULT NULL COMMENT '宸查厤瀵规暟閲�', + is_force int NULL DEFAULT NULL COMMENT '鏄惁寮哄埗', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE hollow_glass_out_relation_info; -- changeset zsh:20241206039 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'hollow_glass_queue_info'; -CREATE TABLE hollow_glass_queue_info ( - id bigint NOT NULL AUTO_INCREMENT COMMENT '澶х悊鐗囩璇︽儏琛╥d', - device_id int NULL DEFAULT NULL COMMENT '璁惧id', - virtual_slot int NULL DEFAULT NULL COMMENT '铏氭嫙鏍呮牸鍙�', - slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', - glass_id varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐜荤拑id', - sequence int NULL DEFAULT NULL COMMENT '灏忕墖鍦ㄦ牸鍐呯殑椤哄簭', - flow_card_id varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '娴佺▼鍗″彿', - glass_type int NULL DEFAULT NULL COMMENT '鐜荤拑绫诲瀷', - width double NULL DEFAULT NULL COMMENT '瀹�', - height double NULL DEFAULT NULL COMMENT '楂�', - thickness double NULL DEFAULT NULL COMMENT '鍘氬害', - tempering_layout_id int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘id', - tempering_feed_sequence int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘鐗囧簭', - state int NULL DEFAULT NULL COMMENT '鐘舵��', - gap int NULL DEFAULT NULL COMMENT '鐜荤拑闂撮殭', - engineer_id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, - total_layer int NULL DEFAULT NULL COMMENT '鎬诲眰鍙�', - layer int NULL DEFAULT NULL COMMENT '灞傚彿', - create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - hollow_sequence int NULL DEFAULT NULL COMMENT '涓┖椤哄簭', - cell int NULL DEFAULT NULL COMMENT '绾胯矾', - is_pair int NULL DEFAULT NULL COMMENT '鏄惁閰嶅', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE hollow_glass_queue_info +( + id bigint NOT NULL AUTO_INCREMENT COMMENT '澶х悊鐗囩璇︽儏琛╥d', + device_id int NULL DEFAULT NULL COMMENT '璁惧id', + virtual_slot int NULL DEFAULT NULL COMMENT '铏氭嫙鏍呮牸鍙�', + slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', + glass_id varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐜荤拑id', + sequence int NULL DEFAULT NULL COMMENT '灏忕墖鍦ㄦ牸鍐呯殑椤哄簭', + flow_card_id varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '娴佺▼鍗″彿', + glass_type int NULL DEFAULT NULL COMMENT '鐜荤拑绫诲瀷', + width double NULL DEFAULT NULL COMMENT '瀹�', + height double NULL DEFAULT NULL COMMENT '楂�', + thickness double NULL DEFAULT NULL COMMENT '鍘氬害', + tempering_layout_id int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘id', + tempering_feed_sequence int NULL DEFAULT NULL COMMENT '閽㈠寲鐗堝浘鐗囧簭', + state int NULL DEFAULT NULL COMMENT '鐘舵��', + gap int NULL DEFAULT NULL COMMENT '鐜荤拑闂撮殭', + engineer_id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, + total_layer int NULL DEFAULT NULL COMMENT '鎬诲眰鍙�', + layer int NULL DEFAULT NULL COMMENT '灞傚彿', + create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + hollow_sequence int NULL DEFAULT NULL COMMENT '涓┖椤哄簭', + cell int NULL DEFAULT NULL COMMENT '绾胯矾', + is_pair int NULL DEFAULT NULL COMMENT '鏄惁閰嶅', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE hollow_glass_queue_info; -- changeset zsh:20241206040 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'hollow_glass_relation_info'; -CREATE TABLE hollow_glass_relation_info ( - id bigint NOT NULL AUTO_INCREMENT COMMENT '涓┖鐜荤拑鍏崇郴琛╥d', - engineer_id varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宸ョ▼鍙穒nit', - tempering_layout_id int NULL DEFAULT NULL COMMENT '鐐夊彿', - tempering_feed_sequence int NULL DEFAULT NULL COMMENT '鐗堝浘搴忓彿', - glass_id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐜荤拑ID', - flow_card_id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '娴佺▼鍗nit', - width double NULL DEFAULT NULL COMMENT '瀹絠nit', - height double NULL DEFAULT NULL COMMENT '楂榠nit', - total_layer int NULL DEFAULT NULL COMMENT '鎬诲眰鏁癷nit', - layer int NULL DEFAULT NULL COMMENT '灞傛暟init', - virtual_slot int NULL DEFAULT NULL COMMENT '缁勫彿init', - slot_sequence int NULL DEFAULT NULL COMMENT '缁勫簭init', - hollow_sequence int NULL DEFAULT NULL COMMENT '鍑虹墖鎬诲簭init', - order_sort int NULL DEFAULT NULL COMMENT '璁㈠崟搴忓彿init', - films_id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鑶滅郴', - thickness double NULL DEFAULT NULL COMMENT '鍘氬害', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE hollow_glass_relation_info +( + id bigint NOT NULL AUTO_INCREMENT COMMENT '涓┖鐜荤拑鍏崇郴琛╥d', + engineer_id varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宸ョ▼鍙穒nit', + tempering_layout_id int NULL DEFAULT NULL COMMENT '鐐夊彿', + tempering_feed_sequence int NULL DEFAULT NULL COMMENT '鐗堝浘搴忓彿', + glass_id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鐜荤拑ID', + flow_card_id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '娴佺▼鍗nit', + width double NULL DEFAULT NULL COMMENT '瀹絠nit', + height double NULL DEFAULT NULL COMMENT '楂榠nit', + total_layer int NULL DEFAULT NULL COMMENT '鎬诲眰鏁癷nit', + layer int NULL DEFAULT NULL COMMENT '灞傛暟init', + virtual_slot int NULL DEFAULT NULL COMMENT '缁勫彿init', + slot_sequence int NULL DEFAULT NULL COMMENT '缁勫簭init', + hollow_sequence int NULL DEFAULT NULL COMMENT '鍑虹墖鎬诲簭init', + order_sort int NULL DEFAULT NULL COMMENT '璁㈠崟搴忓彿init', + films_id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鑶滅郴', + thickness double NULL DEFAULT NULL COMMENT '鍘氬害', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE hollow_glass_relation_info; -- changeset zsh:20241206041 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'load_glass_device_one_task'; -CREATE TABLE load_glass_device_one_task ( - task_running int NULL DEFAULT 0 COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1涓婄墖', - raw_glass_width int NULL DEFAULT 0 COMMENT '鍘熺墖瀹�', - raw_glass_height int NULL DEFAULT 0 COMMENT '鍘熺墖楂�', - slot int NULL DEFAULT 0 COMMENT '涓婄墖浣嶇紪鍙�', - task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0榛樿绌轰换鍔� 1鎵ц涓� 2缁撴潫浠诲姟', - create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - total_count int NULL DEFAULT 0 COMMENT '涓婄墖鎬绘暟閲�', - finish_count int NULL DEFAULT 0 COMMENT '宸插畬鎴愭暟閲�', - damage_count int NULL DEFAULT 0 COMMENT '鐮存崯鏁伴噺', - inkage_state int NULL DEFAULT NULL COMMENT '鑱旀満鐘舵��' -) ENGINE = InnoDB ; +CREATE TABLE load_glass_device_one_task +( + task_running int NULL DEFAULT 0 COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1涓婄墖', + raw_glass_width int NULL DEFAULT 0 COMMENT '鍘熺墖瀹�', + raw_glass_height int NULL DEFAULT 0 COMMENT '鍘熺墖楂�', + slot int NULL DEFAULT 0 COMMENT '涓婄墖浣嶇紪鍙�', + task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0榛樿绌轰换鍔� 1鎵ц涓� 2缁撴潫浠诲姟', + create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + total_count int NULL DEFAULT 0 COMMENT '涓婄墖鎬绘暟閲�', + finish_count int NULL DEFAULT 0 COMMENT '宸插畬鎴愭暟閲�', + damage_count int NULL DEFAULT 0 COMMENT '鐮存崯鏁伴噺', + inkage_state int NULL DEFAULT NULL COMMENT '鑱旀満鐘舵��' +) ENGINE = InnoDB; -- rollback DROP TABLE load_glass_device_one_task; -- changeset zsh:20241206042 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM load_glass_device_one_task; -INSERT INTO load_glass_device_one_task VALUES (0, 0, 0, 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 0, 0, 0); +INSERT INTO load_glass_device_one_task +VALUES (0, 0, 0, 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 0, 0, 0); -- changeset zsh:20241206043 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'load_glass_device_task_history'; -CREATE TABLE load_glass_device_task_history ( - id bigint NOT NULL AUTO_INCREMENT COMMENT '鍘嗗彶浠诲姟id', - task_running int NULL DEFAULT 0 COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1涓婄墖', - raw_glass_width int NULL DEFAULT 0 COMMENT '鍘熺墖瀹�', - raw_glass_height int NULL DEFAULT 0 COMMENT '鍘熺墖楂�', - station int NULL DEFAULT 0 COMMENT '涓婄墖璁惧缂栧彿', - slot int NULL DEFAULT 0 COMMENT '涓婄墖浣嶇紪鍙�', - task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0榛樿绌轰换鍔� 1鎵ц涓� 2缁撴潫浠诲姟', - create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - total_count int NULL DEFAULT 0 COMMENT '涓婄墖鎬绘暟閲�', - finish_count int NULL DEFAULT 0 COMMENT '宸插畬鎴愭暟閲�', - damage_count int NULL DEFAULT 0 COMMENT '鐮存崯鏁伴噺', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE load_glass_device_task_history +( + id bigint NOT NULL AUTO_INCREMENT COMMENT '鍘嗗彶浠诲姟id', + task_running int NULL DEFAULT 0 COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1涓婄墖', + raw_glass_width int NULL DEFAULT 0 COMMENT '鍘熺墖瀹�', + raw_glass_height int NULL DEFAULT 0 COMMENT '鍘熺墖楂�', + station int NULL DEFAULT 0 COMMENT '涓婄墖璁惧缂栧彿', + slot int NULL DEFAULT 0 COMMENT '涓婄墖浣嶇紪鍙�', + task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0榛樿绌轰换鍔� 1鎵ц涓� 2缁撴潫浠诲姟', + create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + total_count int NULL DEFAULT 0 COMMENT '涓婄墖鎬绘暟閲�', + finish_count int NULL DEFAULT 0 COMMENT '宸插畬鎴愭暟閲�', + damage_count int NULL DEFAULT 0 COMMENT '鐮存崯鏁伴噺', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE load_glass_device_task_history; -- changeset zsh:20241206044 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'load_glass_device_two_task'; -CREATE TABLE load_glass_device_two_task ( - task_running int NULL DEFAULT 0 COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1涓婄墖', - raw_glass_width int NULL DEFAULT 0 COMMENT '鍘熺墖瀹�', - raw_glass_height int NULL DEFAULT 0 COMMENT '鍘熺墖楂�', - slot int NULL DEFAULT 0 COMMENT '涓婄墖浣嶇紪鍙�', - inkage_state int NULL DEFAULT NULL COMMENT '鑱旀満鐘舵��', - task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0榛樿绌轰换鍔� 1鎵ц涓� 2缁撴潫浠诲姟', - create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - total_count int NULL DEFAULT 0 COMMENT '涓婄墖鎬绘暟閲�', - finish_count int NULL DEFAULT 0 COMMENT '宸插畬鎴愭暟閲�', - damage_count int NULL DEFAULT 0 COMMENT '鐮存崯鏁伴噺' -) ENGINE = InnoDB ; +CREATE TABLE load_glass_device_two_task +( + task_running int NULL DEFAULT 0 COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1涓婄墖', + raw_glass_width int NULL DEFAULT 0 COMMENT '鍘熺墖瀹�', + raw_glass_height int NULL DEFAULT 0 COMMENT '鍘熺墖楂�', + slot int NULL DEFAULT 0 COMMENT '涓婄墖浣嶇紪鍙�', + inkage_state int NULL DEFAULT NULL COMMENT '鑱旀満鐘舵��', + task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0榛樿绌轰换鍔� 1鎵ц涓� 2缁撴潫浠诲姟', + create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + total_count int NULL DEFAULT 0 COMMENT '涓婄墖鎬绘暟閲�', + finish_count int NULL DEFAULT 0 COMMENT '宸插畬鎴愭暟閲�', + damage_count int NULL DEFAULT 0 COMMENT '鐮存崯鏁伴噺' +) ENGINE = InnoDB; -- rollback DROP TABLE load_glass_device_two_task; -- changeset zsh:20241206045 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM load_glass_device_two_task; -INSERT INTO load_glass_device_two_task VALUES (0, 0, 0, 0, 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 9, 0); +INSERT INTO load_glass_device_two_task +VALUES (0, 0, 0, 0, 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 9, 0); -- changeset zsh:20241206046 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'raw_glass_storage_details'; -CREATE TABLE raw_glass_storage_details ( - id bigint NOT NULL AUTO_INCREMENT, - device_id int NULL DEFAULT NULL COMMENT '璁惧id', - slot int NULL DEFAULT NULL COMMENT '鏍煎瓙id', - pattern_width double(8, 2) NULL DEFAULT NULL COMMENT '鍘熺墖瀹�', - pattern_height double(8, 2) NULL DEFAULT NULL COMMENT '鍘熺墖楂�', - pattern_thickness double(8, 2) NULL DEFAULT NULL COMMENT '鍘熺墖鍘氬害', - films_id varchar(64) DEFAULT NULL COMMENT '鑶滅郴', - create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - remain_quantity int NULL DEFAULT NULL COMMENT '鍓╀綑鏁伴噺', - state int NULL DEFAULT NULL COMMENT '鐘舵��', - shelf int NULL DEFAULT NULL COMMENT '鏋跺瓙鍙�', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE raw_glass_storage_details +( + id bigint NOT NULL AUTO_INCREMENT, + device_id int NULL DEFAULT NULL COMMENT '璁惧id', + slot int NULL DEFAULT NULL COMMENT '鏍煎瓙id', + pattern_width double(8, 2) NULL DEFAULT NULL COMMENT '鍘熺墖瀹�', + pattern_height double(8, 2) NULL DEFAULT NULL COMMENT '鍘熺墖楂�', + pattern_thickness double(8, 2) NULL DEFAULT NULL COMMENT '鍘熺墖鍘氬害', + films_id varchar(64) DEFAULT NULL COMMENT '鑶滅郴', + create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + remain_quantity int NULL DEFAULT NULL COMMENT '鍓╀綑鏁伴噺', + state int NULL DEFAULT NULL COMMENT '鐘舵��', + shelf int NULL DEFAULT NULL COMMENT '鏋跺瓙鍙�', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE raw_glass_storage_details; -- changeset zsh:20241206047 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'raw_glass_storage_station'; -CREATE TABLE raw_glass_storage_station ( - id bigint NOT NULL, - device_id int NULL DEFAULT NULL COMMENT '璁惧id', - slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', - enable_state int NULL DEFAULT NULL COMMENT '鍚敤鏍囪', - shelf int NULL DEFAULT NULL COMMENT '鏋跺瓙鍙�' -) ENGINE = InnoDB ; +CREATE TABLE raw_glass_storage_station +( + id bigint NOT NULL, + device_id int NULL DEFAULT NULL COMMENT '璁惧id', + slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�', + enable_state int NULL DEFAULT NULL COMMENT '鍚敤鏍囪', + shelf int NULL DEFAULT NULL COMMENT '鏋跺瓙鍙�' +) ENGINE = InnoDB; -- rollback DROP TABLE raw_glass_storage_station; -- changeset zsh:20241206048 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM raw_glass_storage_station; -INSERT INTO raw_glass_storage_station VALUES (1, 1, 1, 1, 1); -INSERT INTO raw_glass_storage_station VALUES (2, 1, 2, 1, 2); -INSERT INTO raw_glass_storage_station VALUES (3, 1, 3, 1, 3); -INSERT INTO raw_glass_storage_station VALUES (4, 2, 4, 1, 4); -INSERT INTO raw_glass_storage_station VALUES (5, 2, 5, 1, 5); -INSERT INTO raw_glass_storage_station VALUES (6, 2, 6, 1, 6); -INSERT INTO raw_glass_storage_station VALUES (7, 2, 7, 1, 7); -INSERT INTO raw_glass_storage_station VALUES (8, 2, 8, 1, 8); -INSERT INTO raw_glass_storage_station VALUES (9, 2, 9, 1, 9); -INSERT INTO raw_glass_storage_station VALUES (10, 2, 10, 1, 10); -INSERT INTO raw_glass_storage_station VALUES (11, 2, 11, 1, 11); -INSERT INTO raw_glass_storage_station VALUES (12, 3, 12, 1, 12); -INSERT INTO raw_glass_storage_station VALUES (13, 3, 13, 1, 13); -INSERT INTO raw_glass_storage_station VALUES (14, 3, 14, 1, 14); -INSERT INTO raw_glass_storage_station VALUES (15, 3, 15, 1, 15); -INSERT INTO raw_glass_storage_station VALUES (16, 3, 16, 1, 16); -INSERT INTO raw_glass_storage_station VALUES (17, 3, 17, 1, 17); -INSERT INTO raw_glass_storage_station VALUES (18, 3, 18, 1, 18); -INSERT INTO raw_glass_storage_station VALUES (19, 3, 19, 1, 19); -INSERT INTO raw_glass_storage_station VALUES (20, 3, 20, 1, 20); -INSERT INTO raw_glass_storage_station VALUES (21, 3, 21, 1, 21); -INSERT INTO raw_glass_storage_station VALUES (22, 3, 22, 1, 22); -INSERT INTO raw_glass_storage_station VALUES (23, 3, 23, 1, 23); -INSERT INTO raw_glass_storage_station VALUES (24, 3, 24, 1, 24); -INSERT INTO raw_glass_storage_station VALUES (25, 3, 25, 1, 25); -INSERT INTO raw_glass_storage_station VALUES (26, 4, 98, 1, NULL); -INSERT INTO raw_glass_storage_station VALUES (27, 4, 99, 1, NULL); -INSERT INTO raw_glass_storage_station VALUES (28, 5, 101, 1, NULL); -INSERT INTO raw_glass_storage_station VALUES (29, 5, 102, 1, NULL); -INSERT INTO raw_glass_storage_station VALUES (30, 6, 103, 1, NULL); -INSERT INTO raw_glass_storage_station VALUES (31, 6, 104, 1, NULL); +INSERT INTO raw_glass_storage_station +VALUES (1, 1, 1, 1, 1); +INSERT INTO raw_glass_storage_station +VALUES (2, 1, 2, 1, 2); +INSERT INTO raw_glass_storage_station +VALUES (3, 1, 3, 1, 3); +INSERT INTO raw_glass_storage_station +VALUES (4, 2, 4, 1, 4); +INSERT INTO raw_glass_storage_station +VALUES (5, 2, 5, 1, 5); +INSERT INTO raw_glass_storage_station +VALUES (6, 2, 6, 1, 6); +INSERT INTO raw_glass_storage_station +VALUES (7, 2, 7, 1, 7); +INSERT INTO raw_glass_storage_station +VALUES (8, 2, 8, 1, 8); +INSERT INTO raw_glass_storage_station +VALUES (9, 2, 9, 1, 9); +INSERT INTO raw_glass_storage_station +VALUES (10, 2, 10, 1, 10); +INSERT INTO raw_glass_storage_station +VALUES (11, 2, 11, 1, 11); +INSERT INTO raw_glass_storage_station +VALUES (12, 3, 12, 1, 12); +INSERT INTO raw_glass_storage_station +VALUES (13, 3, 13, 1, 13); +INSERT INTO raw_glass_storage_station +VALUES (14, 3, 14, 1, 14); +INSERT INTO raw_glass_storage_station +VALUES (15, 3, 15, 1, 15); +INSERT INTO raw_glass_storage_station +VALUES (16, 3, 16, 1, 16); +INSERT INTO raw_glass_storage_station +VALUES (17, 3, 17, 1, 17); +INSERT INTO raw_glass_storage_station +VALUES (18, 3, 18, 1, 18); +INSERT INTO raw_glass_storage_station +VALUES (19, 3, 19, 1, 19); +INSERT INTO raw_glass_storage_station +VALUES (20, 3, 20, 1, 20); +INSERT INTO raw_glass_storage_station +VALUES (21, 3, 21, 1, 21); +INSERT INTO raw_glass_storage_station +VALUES (22, 3, 22, 1, 22); +INSERT INTO raw_glass_storage_station +VALUES (23, 3, 23, 1, 23); +INSERT INTO raw_glass_storage_station +VALUES (24, 3, 24, 1, 24); +INSERT INTO raw_glass_storage_station +VALUES (25, 3, 25, 1, 25); +INSERT INTO raw_glass_storage_station +VALUES (26, 4, 98, 1, NULL); +INSERT INTO raw_glass_storage_station +VALUES (27, 4, 99, 1, NULL); +INSERT INTO raw_glass_storage_station +VALUES (28, 5, 101, 1, NULL); +INSERT INTO raw_glass_storage_station +VALUES (29, 5, 102, 1, NULL); +INSERT INTO raw_glass_storage_station +VALUES (30, 6, 103, 1, NULL); +INSERT INTO raw_glass_storage_station +VALUES (31, 6, 104, 1, NULL); -- changeset zsh:20241206049 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'raw_glass_storage_task'; -CREATE TABLE raw_glass_storage_task ( - id bigint NOT NULL AUTO_INCREMENT, - start_slot int NULL DEFAULT NULL COMMENT '璧峰鏍煎瓙', - end_slot int NULL DEFAULT NULL COMMENT '鐩爣鏍煎瓙', - pattern_quantity int NULL DEFAULT NULL COMMENT '鍘熺墖鏁伴噺', - task_type int NULL DEFAULT NULL COMMENT '浠诲姟绫诲瀷', - task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵��', - shelf int NULL DEFAULT NULL COMMENT '鏋跺瓙鍙�', - create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE raw_glass_storage_task +( + id bigint NOT NULL AUTO_INCREMENT, + start_slot int NULL DEFAULT NULL COMMENT '璧峰鏍煎瓙', + end_slot int NULL DEFAULT NULL COMMENT '鐩爣鏍煎瓙', + pattern_quantity int NULL DEFAULT NULL COMMENT '鍘熺墖鏁伴噺', + task_type int NULL DEFAULT NULL COMMENT '浠诲姟绫诲瀷', + task_state int NULL DEFAULT NULL COMMENT '浠诲姟鐘舵��', + shelf int NULL DEFAULT NULL COMMENT '鏋跺瓙鍙�', + create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE raw_glass_storage_task; -- changeset zsh:20241206050 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'sys_dict_data'; -CREATE TABLE sys_dict_data ( - dict_id int NOT NULL AUTO_INCREMENT, - dict_sort int NOT NULL, - dict_label varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, - dict_value varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, - dict_type varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, - dict_type_value varchar(32) DEFAULT NULL, - state char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '1', - description varchar(32) DEFAULT NULL, - create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - deleted char(1) DEFAULT '0', - PRIMARY KEY (dict_id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE sys_dict_data +( + dict_id int NOT NULL AUTO_INCREMENT, + dict_sort int NOT NULL, + dict_label varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + dict_value varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + dict_type varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + dict_type_value varchar(32) DEFAULT NULL, + state char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '1', + description varchar(32) DEFAULT NULL, + create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + deleted char(1) DEFAULT '0', + PRIMARY KEY (dict_id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE sys_dict_data; -- changeset zsh:20241206051 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM sys_dict_data; -INSERT INTO sys_dict_data VALUES (1, 1, '鐧界幓', 'clearGlass', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (2, 2, '瓒呯櫧', 'ultraClear', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (3, 3, '鏉ユ枡鐧界幓', 'incomingClearGlass', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (4, 4, '娆у窞鑼�', 'europeTeaColor', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (5, 5, '姘存櫠鐏�', 'cristalGrey', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (6, 6, '鐏扮幓', 'grayGlass', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (7, 7, '鐏伴晙鑶�', 'grayCoating', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (8, 8, '纾ㄧ爞', 'frosted', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (9, 9, '绂忕壒钃�', 'fordBlue', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (10, 10, '绂忕壒钃濋晙鑶�', 'fordBlueCoating', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (11, 11, '钃濇槦鐏�', 'blueAstralGrey', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (12, 12, '钃濈幓', 'blueGlass', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (13, 13, '瓒呯櫧闀胯櫣', 'ultraClearChanghong', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (14, 14, '閲戞櫠鐏�', 'jinjinGrey', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (15, 15, '閲戞櫠鐏拌尪', 'jinjinTeaGrey', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (16, 16, '闀�鑶�', 'coatingFilm', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (17, 17, '闀胯櫣', 'clearGlassChanghong', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (18, 18, '闃冲厜鑶�', 'solorControl', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (19, 19, '楂樺弽搴曢��', 'arGlass', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (20, 20, '楂樼櫧', 'arClear', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (21, 21, '榛戠幓', 'blackGlass', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (22, 22, '鐜夌爞', 'emery', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (23, 23, '瓒呯櫧纾ㄧ爞', 'ultraClearFrosted', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (24, 24, '閲戣尪鐜�', 'goldenTea', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (25, 25, '钃濈伆闀�鑶�', 'blueGraycoatingFilm', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (26, 26, '鍗曢」閫忚', 'onePoint', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (27, 27, '瓒呯櫧闀�鑶�', 'ultraClearCoatingFilm', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (28, 1, 'F缁�', 'fGreen', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (29, 2, 'F缁縧owe', 'fGreenLowe', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (30, 3, 'F缁块晙鑶�', 'fGreenCoating', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (31, 4, 'Low-e', 'lowe', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (32, 5, 'super52', 'super52', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (33, 6, '涓幓鍦ㄧ嚎', 'zgOnlineGlass', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (34, 7, '鍖楃幓60绂荤嚎lowe', 'ng60OfflineLowe', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (35, 8, '鍗楃幓鍦ㄧ嚎lowe', 'csgOnlineLowe', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (36, 9, '鍙扮幓81A', 'tg81a', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (37, 10, '鍙扮幓lowe70', 'tgLowe70', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (38, 11, '鍙扮幓LOWE78', 'tgLowe78', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (39, 12, '娌冲寳閲戠憺lowe80', 'hbJinruiLowe80', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (40, 13, '绂忕壒钃漧owe', 'fordBlueLowe', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (41, 14, '绂忚幈鐗笷XB60', 'flatFxb60', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (42, 15, '绂忚幈鐗筶owe60', 'flatLowe60', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (43, 16, '绂忚幈鐗筶owe70', 'flatLowe70', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (44, 17, '绂忚幈鐗筶owe80', 'flatLowe80', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (45, 18, '鑰�鐨湪绾縇OWE', 'sypOnlineLowe', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (46, 19, '瓒呯櫧Lowe', 'ultraClearLowe', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (47, 1, '鍙岄摱lowe', 'doubleSilverLowe', '鍙岄摱', '2', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_data VALUES (48, 2, '瓒呯櫧鍙岄摱Lowe', 'ultraDoubleSilverLowe', '鍙岄摱', '2', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (1, 1, '鐧界幓', 'clearGlass', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (2, 2, '瓒呯櫧', 'ultraClear', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (3, 3, '鏉ユ枡鐧界幓', 'incomingClearGlass', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (4, 4, '娆у窞鑼�', 'europeTeaColor', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (5, 5, '姘存櫠鐏�', 'cristalGrey', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (6, 6, '鐏扮幓', 'grayGlass', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (7, 7, '鐏伴晙鑶�', 'grayCoating', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (8, 8, '纾ㄧ爞', 'frosted', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (9, 9, '绂忕壒钃�', 'fordBlue', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (10, 10, '绂忕壒钃濋晙鑶�', 'fordBlueCoating', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (11, 11, '钃濇槦鐏�', 'blueAstralGrey', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (12, 12, '钃濈幓', 'blueGlass', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (13, 13, '瓒呯櫧闀胯櫣', 'ultraClearChanghong', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (14, 14, '閲戞櫠鐏�', 'jinjinGrey', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (15, 15, '閲戞櫠鐏拌尪', 'jinjinTeaGrey', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (16, 16, '闀�鑶�', 'coatingFilm', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (17, 17, '闀胯櫣', 'clearGlassChanghong', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (18, 18, '闃冲厜鑶�', 'solorControl', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (19, 19, '楂樺弽搴曢��', 'arGlass', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (20, 20, '楂樼櫧', 'arClear', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (21, 21, '榛戠幓', 'blackGlass', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (22, 22, '鐜夌爞', 'emery', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (23, 23, '瓒呯櫧纾ㄧ爞', 'ultraClearFrosted', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (24, 24, '閲戣尪鐜�', 'goldenTea', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (25, 25, '钃濈伆闀�鑶�', 'blueGraycoatingFilm', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (26, 26, '鍗曢」閫忚', 'onePoint', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (27, 27, '瓒呯櫧闀�鑶�', 'ultraClearCoatingFilm', '鐧界幓', '0', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (28, 1, 'F缁�', 'fGreen', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (29, 2, 'F缁縧owe', 'fGreenLowe', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (30, 3, 'F缁块晙鑶�', 'fGreenCoating', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (31, 4, 'Low-e', 'lowe', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (32, 5, 'super52', 'super52', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (33, 6, '涓幓鍦ㄧ嚎', 'zgOnlineGlass', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (34, 7, '鍖楃幓60绂荤嚎lowe', 'ng60OfflineLowe', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (35, 8, '鍗楃幓鍦ㄧ嚎lowe', 'csgOnlineLowe', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (36, 9, '鍙扮幓81A', 'tg81a', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (37, 10, '鍙扮幓lowe70', 'tgLowe70', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (38, 11, '鍙扮幓LOWE78', 'tgLowe78', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (39, 12, '娌冲寳閲戠憺lowe80', 'hbJinruiLowe80', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (40, 13, '绂忕壒钃漧owe', 'fordBlueLowe', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (41, 14, '绂忚幈鐗笷XB60', 'flatFxb60', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (42, 15, '绂忚幈鐗筶owe60', 'flatLowe60', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (43, 16, '绂忚幈鐗筶owe70', 'flatLowe70', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (44, 17, '绂忚幈鐗筶owe80', 'flatLowe80', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (45, 18, '鑰�鐨湪绾縇OWE', 'sypOnlineLowe', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (46, 19, '瓒呯櫧Lowe', 'ultraClearLowe', '鍗曢摱', '1', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (47, 1, '鍙岄摱lowe', 'doubleSilverLowe', '鍙岄摱', '2', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_data +VALUES (48, 2, '瓒呯櫧鍙岄摱Lowe', 'ultraDoubleSilverLowe', '鍙岄摱', '2', '1', '1', '2024-09-18 15:18:49', '0'); -- changeset zsh:20241206052 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'sys_dict_type'; -CREATE TABLE sys_dict_type ( - dict_id int NOT NULL AUTO_INCREMENT, - dict_name varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, - dict_type varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, - state char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '1', - description varchar(32) DEFAULT NULL, - create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - deleted char(1) DEFAULT '0', - PRIMARY KEY (dict_id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE sys_dict_type +( + dict_id int NOT NULL AUTO_INCREMENT, + dict_name varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + dict_type varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + state char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '1', + description varchar(32) DEFAULT NULL, + create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + deleted char(1) DEFAULT '0', + PRIMARY KEY (dict_id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE sys_dict_type; -- changeset zsh:20241206053 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM sys_dict_type; -INSERT INTO sys_dict_type VALUES (1, '鐧界幓', 'clearGlass', '1', '0', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_type VALUES (2, '鍗曢摱', 'silver', '1', '1', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_type VALUES (3, '鍙岄摱', 'doubleSilver', '1', '2', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_type VALUES (4, '涓夐摱', 'thirdSilver', '1', '3', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_type VALUES (5, '瓒呯櫧', 'ultraClear', '1', '4', '2024-09-18 15:18:49', '0'); -INSERT INTO sys_dict_type VALUES (6, '鐑弽灏�', 'heatReflect', '1', '5', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_type +VALUES (1, '鐧界幓', 'clearGlass', '1', '0', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_type +VALUES (2, '鍗曢摱', 'silver', '1', '1', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_type +VALUES (3, '鍙岄摱', 'doubleSilver', '1', '2', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_type +VALUES (4, '涓夐摱', 'thirdSilver', '1', '3', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_type +VALUES (5, '瓒呯櫧', 'ultraClear', '1', '4', '2024-09-18 15:18:49', '0'); +INSERT INTO sys_dict_type +VALUES (6, '鐑弽灏�', 'heatReflect', '1', '5', '2024-09-18 15:18:49', '0'); -- changeset zsh:20241206054 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'sys_error'; -CREATE TABLE sys_error ( - id int NOT NULL AUTO_INCREMENT, - func varchar(255) DEFAULT NULL COMMENT '鏂规硶鍚�', - error text COMMENT '閿欒淇℃伅', - create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE sys_error +( + id int NOT NULL AUTO_INCREMENT, + func varchar(255) DEFAULT NULL COMMENT '鏂规硶鍚�', + error text COMMENT '閿欒淇℃伅', + create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE sys_error; -- changeset zsh:20241206055 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'sys_menu'; -CREATE TABLE sys_menu ( - id int NOT NULL AUTO_INCREMENT COMMENT '鑷id', - parent_id int NULL DEFAULT NULL COMMENT '鐖秈d', - menu_name varchar(255) DEFAULT NULL COMMENT '妯″潡鍚嶇О', - icon varchar(255) DEFAULT NULL, - url varchar(255) DEFAULT NULL COMMENT '鍦板潃', - language_type varchar(10) DEFAULT NULL COMMENT '璇█绫诲瀷', - status int NULL DEFAULT NULL COMMENT '鐘舵��', - list_sort varchar(255) DEFAULT NULL COMMENT '鎺掑簭', - create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - perms varchar(255) DEFAULT NULL, - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE sys_menu +( + id int NOT NULL AUTO_INCREMENT COMMENT '鑷id', + parent_id int NULL DEFAULT NULL COMMENT '鐖秈d', + menu_name varchar(255) DEFAULT NULL COMMENT '妯″潡鍚嶇О', + icon varchar(255) DEFAULT NULL, + url varchar(255) DEFAULT NULL COMMENT '鍦板潃', + language_type varchar(10) DEFAULT NULL COMMENT '璇█绫诲瀷', + status int NULL DEFAULT NULL COMMENT '鐘舵��', + list_sort varchar(255) DEFAULT NULL COMMENT '鎺掑簭', + create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + perms varchar(255) DEFAULT NULL, + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE sys_menu; -- changeset zsh:20241206056 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM sys_menu; -INSERT INTO sys_menu VALUES (1, 0, '涓婄墖鏈�', '/', '/', '/', 1, '1', '2024-03-01 10:35:15', 'spj'); -INSERT INTO sys_menu VALUES (2, 0, '鎺扮墖/璇嗗埆', '/', '/', '/', 1, '2', '2024-03-01 10:35:08', 'bp'); -INSERT INTO sys_menu VALUES (3, 0, '鍗у紡缂撳瓨', '/', '/', '/', 1, '3', '2023-10-24 15:05:31', 'wshc'); -INSERT INTO sys_menu VALUES (4, 0, '纾ㄨ竟锛堝喎鍔犲伐锛�', '/', '/', '/', 1, '4', '2024-03-01 09:48:20', 'mb'); -INSERT INTO sys_menu VALUES (5, 0, '澶х悊鐗囩', '/', '/', '/', 1, '5', '2024-03-08 08:59:50', 'dlpl'); -INSERT INTO sys_menu VALUES (6, 0, '閽㈠寲', '/', '/', '/', 1, '6', '2024-03-13 10:26:25', 'gh'); -INSERT INTO sys_menu VALUES (7, 0, '涓嬬墖鍙�', '/', '/', '/', 1, '7', '2024-03-18 14:48:13', 'xp'); -INSERT INTO sys_menu VALUES (8, 0, '绯荤粺绠＄悊', '/', '/', '/', 1, '8', '2024-03-29 08:55:35', 'xt'); -INSERT INTO sys_menu VALUES (9, 1, '涓婄墖鏈�', '/', '/Returns/returns', '/', 1, '1', '2024-03-01 10:35:15', 'spj:spj'); -INSERT INTO sys_menu VALUES (10, 2, '鎺扮墖/璇嗗埆', '/', '/identify/identify', '/', 1, '1', '2024-03-01 10:35:08', 'bp:bp'); -INSERT INTO sys_menu VALUES (11, 3, '纾ㄨ竟鍓嶅崸寮忕紦瀛�', '/', '/Caching/cachingbefore', '/', 1, '1', '2023-10-24 15:05:31', 'wshc:wshc'); -INSERT INTO sys_menu VALUES (12, 4, '1绾跨（杈�(鍐峰姞宸�)', '/', '/stockBasicData/stockBasicData', '/', 1, '1', '2024-03-01 09:48:20', 'mb:1xmb'); -INSERT INTO sys_menu VALUES (13, 5, '澶х悊鐗囩', '/', '/slicecage/slicecage', '/', 1, '1', '2024-03-08 08:59:50', 'dlpl:dlpl'); -INSERT INTO sys_menu VALUES (14, 6, '閽㈠寲鍓�', '/', '/PurchaseReturn/purchaseReturn', '/', 1, '1', '2024-03-13 10:26:25', 'gh:ghq'); -INSERT INTO sys_menu VALUES (15, 7, '涓嬬墖鍙�', '/', '/UnLoadGlass/loadmachinerack', '/', 1, '1', '2024-03-18 14:48:13', 'xp:xp1'); -INSERT INTO sys_menu VALUES (17, 8, '鐢ㄦ埛绠＄悊', '/', '/user/userlist', '/', 1, '1', '2024-03-29 08:55:35', 'xt:yh'); -INSERT INTO sys_menu VALUES (18, 8, '鏉冮檺绠＄悊', '/', '/user/permissions', '/', 1, '2', '2024-03-29 16:45:07', 'xt:qx'); -INSERT INTO sys_menu VALUES (19, 8, '瑙掕壊绠＄悊', '/', '/user/rolelist', '/', 1, '3', '2024-03-29 16:45:07', 'xt:js'); -INSERT INTO sys_menu VALUES (20, 6, '閽㈠寲鍚�', '/', '/PurchaseReturn/purchaseStorage', '/', 1, '2', '2024-04-16 09:39:54', 'gh:ghh'); -INSERT INTO sys_menu VALUES (25, 3, '涓嬬墖鍗у紡缂撳瓨', '/', '/Caching/cachingun', '/', 1, '2', '2024-04-25 14:35:36', 'wshc:wshc1'); -INSERT INTO sys_menu VALUES (26, 4, '2绾跨（杈�(鍐峰姞宸�)', '/', '/StockBasicData/stockBasicDatatwo', '/', 1, '2', '2024-05-20 10:38:40', 'mb:2xmb'); -INSERT INTO sys_menu VALUES (27, 0, '浠撳偍涓績', '/', '/', '/', 1, '9', '2024-05-24 11:39:13', 'cczx'); -INSERT INTO sys_menu VALUES (28, 27, '鍘熺墖浠撳偍', '/', '/GlassStorage/rawfilmstorage', '/', 1, '1', '2024-05-24 11:44:21', NULL); -INSERT INTO sys_menu VALUES (29, 10, 'xaiozhan', '/', '/', '/', 1, '1', '2024-05-27 09:41:37', NULL); -INSERT INTO sys_menu VALUES (35, 0, '澶у睆', '/', '/', '/', 1, '1', '2024-07-03 09:46:31', NULL); -INSERT INTO sys_menu VALUES (54, 8, 'ceshi', '/', '/', '/', 1, '4', '2024-07-03 14:09:46', NULL); -INSERT INTO sys_menu VALUES (55, 8, 'ce', '/', '/', '/', 1, '5', '2024-07-03 14:11:33', NULL); -INSERT INTO sys_menu VALUES (57, 0, '鍙鍖栫郴缁�', '/', '/', '/', 1, '10', '2024-07-09 16:17:57', 'dpxs'); -INSERT INTO sys_menu VALUES (59, 57, '鍙鍖栫郴缁�', NULL, '/largescreen/largescreen', NULL, NULL, '1', '2024-07-09 16:43:26', NULL); -INSERT INTO sys_menu VALUES (60, 0, '鎶ュ伐绠＄悊', '/', '/', '/', 1, '11', '2024-07-15 14:51:02', 'bggl'); -INSERT INTO sys_menu VALUES (62, 60, '鎶ュ伐绠＄悊', NULL, '/ReportWork/reportWork', NULL, NULL, '1', '2024-07-15 16:18:39', NULL); -INSERT INTO sys_menu VALUES (63, 61, '鏂欐灦绠＄悊', '/', '/GlassStorage/MaterialRackManagement', '/', 1, '2', '2024-09-13 08:31:04', NULL); -INSERT INTO sys_menu VALUES (66, 1, '涓婄墖1绾�', '/', '/Returns/upreturns', '/', 1, '2', '2024-10-10 15:17:22', NULL); -INSERT INTO sys_menu VALUES (69, 1, '涓婄墖2绾�', NULL, '/Returns/upreturns2', NULL, 1, '3', '2024-10-31 08:30:43', NULL); +INSERT INTO sys_menu +VALUES (1, 0, '涓婄墖鏈�', '/', '/', '/', 1, '1', '2024-03-01 10:35:15', 'spj'); +INSERT INTO sys_menu +VALUES (2, 0, '鎺扮墖/璇嗗埆', '/', '/', '/', 1, '2', '2024-03-01 10:35:08', 'bp'); +INSERT INTO sys_menu +VALUES (3, 0, '鍗у紡缂撳瓨', '/', '/', '/', 1, '3', '2023-10-24 15:05:31', 'wshc'); +INSERT INTO sys_menu +VALUES (4, 0, '纾ㄨ竟锛堝喎鍔犲伐锛�', '/', '/', '/', 1, '4', '2024-03-01 09:48:20', 'mb'); +INSERT INTO sys_menu +VALUES (5, 0, '澶х悊鐗囩', '/', '/', '/', 1, '5', '2024-03-08 08:59:50', 'dlpl'); +INSERT INTO sys_menu +VALUES (6, 0, '閽㈠寲', '/', '/', '/', 1, '6', '2024-03-13 10:26:25', 'gh'); +INSERT INTO sys_menu +VALUES (7, 0, '涓嬬墖鍙�', '/', '/', '/', 1, '7', '2024-03-18 14:48:13', 'xp'); +INSERT INTO sys_menu +VALUES (8, 0, '绯荤粺绠＄悊', '/', '/', '/', 1, '8', '2024-03-29 08:55:35', 'xt'); +INSERT INTO sys_menu +VALUES (9, 1, '涓婄墖鏈�', '/', '/Returns/returns', '/', 1, '1', '2024-03-01 10:35:15', 'spj:spj'); +INSERT INTO sys_menu +VALUES (10, 2, '鎺扮墖/璇嗗埆', '/', '/identify/identify', '/', 1, '1', '2024-03-01 10:35:08', 'bp:bp'); +INSERT INTO sys_menu +VALUES (11, 3, '纾ㄨ竟鍓嶅崸寮忕紦瀛�', '/', '/Caching/cachingbefore', '/', 1, '1', '2023-10-24 15:05:31', 'wshc:wshc'); +INSERT INTO sys_menu +VALUES (12, 4, '1绾跨（杈�(鍐峰姞宸�)', '/', '/stockBasicData/stockBasicData', '/', 1, '1', '2024-03-01 09:48:20', 'mb:1xmb'); +INSERT INTO sys_menu +VALUES (13, 5, '澶х悊鐗囩', '/', '/slicecage/slicecage', '/', 1, '1', '2024-03-08 08:59:50', 'dlpl:dlpl'); +INSERT INTO sys_menu +VALUES (14, 6, '閽㈠寲鍓�', '/', '/PurchaseReturn/purchaseReturn', '/', 1, '1', '2024-03-13 10:26:25', 'gh:ghq'); +INSERT INTO sys_menu +VALUES (15, 7, '涓嬬墖鍙�', '/', '/UnLoadGlass/loadmachinerack', '/', 1, '1', '2024-03-18 14:48:13', 'xp:xp1'); +INSERT INTO sys_menu +VALUES (17, 8, '鐢ㄦ埛绠＄悊', '/', '/user/userlist', '/', 1, '1', '2024-03-29 08:55:35', 'xt:yh'); +INSERT INTO sys_menu +VALUES (18, 8, '鏉冮檺绠＄悊', '/', '/user/permissions', '/', 1, '2', '2024-03-29 16:45:07', 'xt:qx'); +INSERT INTO sys_menu +VALUES (19, 8, '瑙掕壊绠＄悊', '/', '/user/rolelist', '/', 1, '3', '2024-03-29 16:45:07', 'xt:js'); +INSERT INTO sys_menu +VALUES (20, 6, '閽㈠寲鍚�', '/', '/PurchaseReturn/purchaseStorage', '/', 1, '2', '2024-04-16 09:39:54', 'gh:ghh'); +INSERT INTO sys_menu +VALUES (25, 3, '涓嬬墖鍗у紡缂撳瓨', '/', '/Caching/cachingun', '/', 1, '2', '2024-04-25 14:35:36', 'wshc:wshc1'); +INSERT INTO sys_menu +VALUES (26, 4, '2绾跨（杈�(鍐峰姞宸�)', '/', '/StockBasicData/stockBasicDatatwo', '/', 1, '2', '2024-05-20 10:38:40', 'mb:2xmb'); +INSERT INTO sys_menu +VALUES (27, 0, '浠撳偍涓績', '/', '/', '/', 1, '9', '2024-05-24 11:39:13', 'cczx'); +INSERT INTO sys_menu +VALUES (28, 27, '鍘熺墖浠撳偍', '/', '/GlassStorage/rawfilmstorage', '/', 1, '1', '2024-05-24 11:44:21', NULL); +INSERT INTO sys_menu +VALUES (29, 10, 'xaiozhan', '/', '/', '/', 1, '1', '2024-05-27 09:41:37', NULL); +INSERT INTO sys_menu +VALUES (35, 0, '澶у睆', '/', '/', '/', 1, '1', '2024-07-03 09:46:31', NULL); +INSERT INTO sys_menu +VALUES (54, 8, 'ceshi', '/', '/', '/', 1, '4', '2024-07-03 14:09:46', NULL); +INSERT INTO sys_menu +VALUES (55, 8, 'ce', '/', '/', '/', 1, '5', '2024-07-03 14:11:33', NULL); +INSERT INTO sys_menu +VALUES (57, 0, '鍙鍖栫郴缁�', '/', '/', '/', 1, '10', '2024-07-09 16:17:57', 'dpxs'); +INSERT INTO sys_menu +VALUES (59, 57, '鍙鍖栫郴缁�', NULL, '/largescreen/largescreen', NULL, NULL, '1', '2024-07-09 16:43:26', NULL); +INSERT INTO sys_menu +VALUES (60, 0, '鎶ュ伐绠＄悊', '/', '/', '/', 1, '11', '2024-07-15 14:51:02', 'bggl'); +INSERT INTO sys_menu +VALUES (62, 60, '鎶ュ伐绠＄悊', NULL, '/ReportWork/reportWork', NULL, NULL, '1', '2024-07-15 16:18:39', NULL); +INSERT INTO sys_menu +VALUES (63, 61, '鏂欐灦绠＄悊', '/', '/GlassStorage/MaterialRackManagement', '/', 1, '2', '2024-09-13 08:31:04', NULL); +INSERT INTO sys_menu +VALUES (66, 1, '涓婄墖1绾�', '/', '/Returns/upreturns', '/', 1, '2', '2024-10-10 15:17:22', NULL); +INSERT INTO sys_menu +VALUES (69, 1, '涓婄墖2绾�', NULL, '/Returns/upreturns2', NULL, 1, '3', '2024-10-31 08:30:43', NULL); -- changeset zsh:20241206057 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'sys_role'; -CREATE TABLE sys_role ( - id bigint NOT NULL AUTO_INCREMENT, - name varchar(128) DEFAULT NULL, - role_key varchar(100) DEFAULT NULL COMMENT '瑙掕壊鏉冮檺瀛楃涓�', - status char(1) DEFAULT '0' COMMENT '瑙掕壊鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', - del_flag int NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囧織', - remark varchar(500) DEFAULT NULL COMMENT '澶囨敞', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 COMMENT = '瑙掕壊琛�'; +CREATE TABLE sys_role +( + id bigint NOT NULL AUTO_INCREMENT, + name varchar(128) DEFAULT NULL, + role_key varchar(100) DEFAULT NULL COMMENT '瑙掕壊鏉冮檺瀛楃涓�', + status char(1) DEFAULT '0' COMMENT '瑙掕壊鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', + del_flag int NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囧織', + remark varchar(500) DEFAULT NULL COMMENT '澶囨敞', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1 COMMENT = '瑙掕壊琛�'; -- rollback DROP TABLE sys_role; -- changeset zsh:20241206058 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM sys_role; -INSERT INTO sys_role VALUES (1, '娴嬭瘯', 'test', '0', 0, NULL); -INSERT INTO sys_role VALUES (2, '绠＄悊鍛�', 'admin', '0', 0, NULL); +INSERT INTO sys_role +VALUES (1, '娴嬭瘯', 'test', '0', 0, NULL); +INSERT INTO sys_role +VALUES (2, '绠＄悊鍛�', 'admin', '0', 0, NULL); -- changeset zsh:20241206059 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'sys_role_menu'; -CREATE TABLE sys_role_menu ( - role_id bigint NOT NULL AUTO_INCREMENT COMMENT '瑙掕壊ID', - menu_id bigint NOT NULL DEFAULT 0 COMMENT '鑿滃崟id', - PRIMARY KEY (role_id, menu_id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE sys_role_menu +( + role_id bigint NOT NULL AUTO_INCREMENT COMMENT '瑙掕壊ID', + menu_id bigint NOT NULL DEFAULT 0 COMMENT '鑿滃崟id', + PRIMARY KEY (role_id, menu_id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE sys_role_menu; -- changeset zsh:20241206060 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM sys_role_menu; -INSERT INTO sys_role_menu VALUES (1, 1); -INSERT INTO sys_role_menu VALUES (1, 2); -INSERT INTO sys_role_menu VALUES (1, 3); -INSERT INTO sys_role_menu VALUES (1, 4); -INSERT INTO sys_role_menu VALUES (1, 5); -INSERT INTO sys_role_menu VALUES (1, 6); -INSERT INTO sys_role_menu VALUES (1, 7); -INSERT INTO sys_role_menu VALUES (1, 8); -INSERT INTO sys_role_menu VALUES (1, 9); -INSERT INTO sys_role_menu VALUES (1, 10); -INSERT INTO sys_role_menu VALUES (1, 11); -INSERT INTO sys_role_menu VALUES (1, 12); -INSERT INTO sys_role_menu VALUES (1, 13); -INSERT INTO sys_role_menu VALUES (1, 14); -INSERT INTO sys_role_menu VALUES (1, 15); -INSERT INTO sys_role_menu VALUES (1, 17); -INSERT INTO sys_role_menu VALUES (1, 18); -INSERT INTO sys_role_menu VALUES (1, 19); -INSERT INTO sys_role_menu VALUES (1, 20); -INSERT INTO sys_role_menu VALUES (1, 21); -INSERT INTO sys_role_menu VALUES (1, 25); -INSERT INTO sys_role_menu VALUES (1, 26); -INSERT INTO sys_role_menu VALUES (1, 27); -INSERT INTO sys_role_menu VALUES (1, 28); -INSERT INTO sys_role_menu VALUES (1, 57); -INSERT INTO sys_role_menu VALUES (1, 59); -INSERT INTO sys_role_menu VALUES (1, 60); -INSERT INTO sys_role_menu VALUES (1, 61); -INSERT INTO sys_role_menu VALUES (1, 62); -INSERT INTO sys_role_menu VALUES (1, 63); -INSERT INTO sys_role_menu VALUES (1, 65); -INSERT INTO sys_role_menu VALUES (1, 66); -INSERT INTO sys_role_menu VALUES (1, 69); +INSERT INTO sys_role_menu +VALUES (1, 1); +INSERT INTO sys_role_menu +VALUES (1, 2); +INSERT INTO sys_role_menu +VALUES (1, 3); +INSERT INTO sys_role_menu +VALUES (1, 4); +INSERT INTO sys_role_menu +VALUES (1, 5); +INSERT INTO sys_role_menu +VALUES (1, 6); +INSERT INTO sys_role_menu +VALUES (1, 7); +INSERT INTO sys_role_menu +VALUES (1, 8); +INSERT INTO sys_role_menu +VALUES (1, 9); +INSERT INTO sys_role_menu +VALUES (1, 10); +INSERT INTO sys_role_menu +VALUES (1, 11); +INSERT INTO sys_role_menu +VALUES (1, 12); +INSERT INTO sys_role_menu +VALUES (1, 13); +INSERT INTO sys_role_menu +VALUES (1, 14); +INSERT INTO sys_role_menu +VALUES (1, 15); +INSERT INTO sys_role_menu +VALUES (1, 17); +INSERT INTO sys_role_menu +VALUES (1, 18); +INSERT INTO sys_role_menu +VALUES (1, 19); +INSERT INTO sys_role_menu +VALUES (1, 20); +INSERT INTO sys_role_menu +VALUES (1, 21); +INSERT INTO sys_role_menu +VALUES (1, 25); +INSERT INTO sys_role_menu +VALUES (1, 26); +INSERT INTO sys_role_menu +VALUES (1, 27); +INSERT INTO sys_role_menu +VALUES (1, 28); +INSERT INTO sys_role_menu +VALUES (1, 57); +INSERT INTO sys_role_menu +VALUES (1, 59); +INSERT INTO sys_role_menu +VALUES (1, 60); +INSERT INTO sys_role_menu +VALUES (1, 61); +INSERT INTO sys_role_menu +VALUES (1, 62); +INSERT INTO sys_role_menu +VALUES (1, 63); +INSERT INTO sys_role_menu +VALUES (1, 65); +INSERT INTO sys_role_menu +VALUES (1, 66); +INSERT INTO sys_role_menu +VALUES (1, 69); -- changeset zsh:20241206061 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'sys_user'; -CREATE TABLE sys_user ( - id bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭', - user_name varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'NULL' COMMENT '鐢ㄦ埛鍚�', - nick_name varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'NULL' COMMENT '鏄电О', - password varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'NULL' COMMENT '瀵嗙爜', - status char(1) DEFAULT '0' COMMENT '璐﹀彿鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', - avatar varchar(128) DEFAULT NULL COMMENT '澶村儚', - user_type char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '1' COMMENT '鐢ㄦ埛绫诲瀷锛�0绠＄悊鍛橈紝1鏅�氱敤鎴凤級', - del_flag int NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囧織', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 COMMENT = '鐢ㄦ埛琛�'; +CREATE TABLE sys_user +( + id bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭', + user_name varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'NULL' COMMENT '鐢ㄦ埛鍚�', + nick_name varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'NULL' COMMENT '鏄电О', + password varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'NULL' COMMENT '瀵嗙爜', + status char(1) DEFAULT '0' COMMENT '璐﹀彿鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', + avatar varchar(128) DEFAULT NULL COMMENT '澶村儚', + user_type char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '1' COMMENT '鐢ㄦ埛绫诲瀷锛�0绠＄悊鍛橈紝1鏅�氱敤鎴凤級', + del_flag int NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囧織', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1 COMMENT = '鐢ㄦ埛琛�'; -- rollback DROP TABLE sys_user; -- changeset zsh:20241206062 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM sys_user; -INSERT INTO sys_user VALUES (1, 'admin', 'admin', '$2a$10$mFKyOBNO8hdNafPR18hjeuiDvG2zpIS6IgIRiWHk1b.IjIWNkj.l2', '0', NULL, '1', 0); +INSERT INTO sys_user +VALUES (1, 'admin', 'admin', '$2a$10$mFKyOBNO8hdNafPR18hjeuiDvG2zpIS6IgIRiWHk1b.IjIWNkj.l2', '0', NULL, '1', 0); -- changeset zsh:20241206063 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'sys_user_role'; -CREATE TABLE sys_user_role ( - user_id bigint NOT NULL AUTO_INCREMENT COMMENT '鐢ㄦ埛id', - role_id bigint NOT NULL DEFAULT 0 COMMENT '瑙掕壊id', - PRIMARY KEY (user_id, role_id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE sys_user_role +( + user_id bigint NOT NULL AUTO_INCREMENT COMMENT '鐢ㄦ埛id', + role_id bigint NOT NULL DEFAULT 0 COMMENT '瑙掕壊id', + PRIMARY KEY (user_id, role_id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE sys_user_role; -- changeset zsh:20241206064 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'task_cache'; -CREATE TABLE task_cache ( - ID varchar(255) NOT NULL COMMENT 'ID缂栧彿', - start_cell varchar(255) DEFAULT NULL COMMENT '璧峰', - end_cell varchar(255) DEFAULT NULL COMMENT '鐩爣', - task_type varchar(255) DEFAULT NULL COMMENT '浠诲姟绫诲瀷 1:杩� 2锛氬嚭', - task_status varchar(255) DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0 鏈紑濮� 1宸插畬鎴�', - PRIMARY KEY (ID) USING BTREE -) ENGINE = InnoDB ; +CREATE TABLE task_cache +( + ID varchar(255) NOT NULL COMMENT 'ID缂栧彿', + start_cell varchar(255) DEFAULT NULL COMMENT '璧峰', + end_cell varchar(255) DEFAULT NULL COMMENT '鐩爣', + task_type varchar(255) DEFAULT NULL COMMENT '浠诲姟绫诲瀷 1:杩� 2锛氬嚭', + task_status varchar(255) DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0 鏈紑濮� 1宸插畬鎴�', + PRIMARY KEY (ID) USING BTREE +) ENGINE = InnoDB; -- rollback DROP TABLE task_cache; -- changeset zsh:20241206065 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tempering_record'; -CREATE TABLE tempering_record ( - engineer_id varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '宸ョ▼id', - tempering_layout_id int NOT NULL COMMENT '閽㈠寲鐗堝浘', - glass_type int NULL DEFAULT NULL COMMENT '鐜荤拑鏉愯川(鑶滅郴0.鐧界幓1.鍗曢摱2.鍙岄摱3涓夐摱 4.瓒呯櫧5.鐑弽灏�)', - tempering_type int NULL DEFAULT NULL COMMENT '閽㈠寲绫诲瀷锛�1.鍏ㄩ挗:2.鍗婇挗锛�', - thickness double NULL DEFAULT NULL COMMENT '鍘氬害锛堝帤搴�*10)', - loading_rate double NULL DEFAULT NULL COMMENT '瑁呰浇鐜�', - area_difference double NULL DEFAULT NULL COMMENT '闈㈢Н宸�', - production_time varchar(64) DEFAULT NULL COMMENT '鐢熶骇鑰楁椂', - heat_energy varchar(64) DEFAULT NULL COMMENT '鍔犵儹鑳借��', - cool_energy varchar(64) DEFAULT NULL COMMENT '鍐峰嵈鑳借��', - state int NULL DEFAULT NULL COMMENT '鏄惁瀹屾垚(plc鑾峰彇闈�1锛氬弬鏁颁笉瀛樺湪锛�2銆佸尮閰嶅畬鎴愶紱3銆佸尮閰嶈秴鏃讹級', - PRIMARY KEY (tempering_layout_id, engineer_id) USING BTREE -) ENGINE = InnoDB ; +CREATE TABLE tempering_record +( + engineer_id varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '宸ョ▼id', + tempering_layout_id int NOT NULL COMMENT '閽㈠寲鐗堝浘', + glass_type int NULL DEFAULT NULL COMMENT '鐜荤拑鏉愯川(鑶滅郴0.鐧界幓1.鍗曢摱2.鍙岄摱3涓夐摱 4.瓒呯櫧5.鐑弽灏�)', + tempering_type int NULL DEFAULT NULL COMMENT '閽㈠寲绫诲瀷锛�1.鍏ㄩ挗:2.鍗婇挗锛�', + thickness double NULL DEFAULT NULL COMMENT '鍘氬害锛堝帤搴�*10)', + loading_rate double NULL DEFAULT NULL COMMENT '瑁呰浇鐜�', + area_difference double NULL DEFAULT NULL COMMENT '闈㈢Н宸�', + production_time varchar(64) DEFAULT NULL COMMENT '鐢熶骇鑰楁椂', + heat_energy varchar(64) DEFAULT NULL COMMENT '鍔犵儹鑳借��', + cool_energy varchar(64) DEFAULT NULL COMMENT '鍐峰嵈鑳借��', + state int NULL DEFAULT NULL COMMENT '鏄惁瀹屾垚(plc鑾峰彇闈�1锛氬弬鏁颁笉瀛樺湪锛�2銆佸尮閰嶅畬鎴愶紱3銆佸尮閰嶈秴鏃讹級', + PRIMARY KEY (tempering_layout_id, engineer_id) USING BTREE +) ENGINE = InnoDB; -- rollback DROP TABLE tempering_record; -- changeset zsh:20241206066 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'up_patten_usage'; -CREATE TABLE up_patten_usage ( - id bigint NOT NULL AUTO_INCREMENT COMMENT '鍘熺墖浣跨敤鎯呭喌琛╥d', - engineering_id varchar(50) DEFAULT NULL COMMENT '宸ョ▼鍙�', - films_id varchar(50) DEFAULT NULL COMMENT '鑶滅郴id', - width double NULL DEFAULT NULL COMMENT '瀹�', - height double NULL DEFAULT NULL COMMENT '楂�', - thickness double NULL DEFAULT NULL COMMENT '鍘氬害', - layout_sequence int NULL DEFAULT NULL COMMENT '鍘熺墖鐗堝浘鐗囧簭', - state int NULL DEFAULT NULL COMMENT '鐘舵��', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 1 ; +CREATE TABLE up_patten_usage +( + id bigint NOT NULL AUTO_INCREMENT COMMENT '鍘熺墖浣跨敤鎯呭喌琛╥d', + engineering_id varchar(50) DEFAULT NULL COMMENT '宸ョ▼鍙�', + films_id varchar(50) DEFAULT NULL COMMENT '鑶滅郴id', + width double NULL DEFAULT NULL COMMENT '瀹�', + height double NULL DEFAULT NULL COMMENT '楂�', + thickness double NULL DEFAULT NULL COMMENT '鍘氬害', + layout_sequence int NULL DEFAULT NULL COMMENT '鍘熺墖鐗堝浘鐗囧簭', + state int NULL DEFAULT NULL COMMENT '鐘舵��', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 1; -- rollback DROP TABLE up_patten_usage; -- changeset zsh:20241206067 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'up_workstation'; -CREATE TABLE up_workstation ( - id int NOT NULL COMMENT '涓婄墖宸ヤ綅琛╥d', - workstation_id int NULL DEFAULT NULL COMMENT '宸ヤ綅鍙�', - device_id int NULL DEFAULT NULL COMMENT '璁惧id', - enable_state int NULL DEFAULT NULL COMMENT '鍚敤鐘舵��', - work_state int NULL DEFAULT NULL COMMENT '宸ヤ綔鐘舵��', - pattern_width double NULL DEFAULT NULL COMMENT '鍘熺墖瀹�', - pattern_height double(255, 0) NULL DEFAULT NULL COMMENT '鍘熺墖楂�', - pattern_thickness double(255, 0) NULL DEFAULT NULL COMMENT '鍘熺墖鍘氬害', - films_id varchar(20) DEFAULT NULL COMMENT '鑶滅郴', - number int NULL DEFAULT NULL COMMENT '鏁伴噺', - PRIMARY KEY (id) USING BTREE +CREATE TABLE up_workstation +( + id int NOT NULL COMMENT '涓婄墖宸ヤ綅琛╥d', + workstation_id int NULL DEFAULT NULL COMMENT '宸ヤ綅鍙�', + device_id int NULL DEFAULT NULL COMMENT '璁惧id', + enable_state int NULL DEFAULT NULL COMMENT '鍚敤鐘舵��', + work_state int NULL DEFAULT NULL COMMENT '宸ヤ綔鐘舵��', + pattern_width double NULL DEFAULT NULL COMMENT '鍘熺墖瀹�', + pattern_height double(255, 0) NULL DEFAULT NULL COMMENT '鍘熺墖楂�', + pattern_thickness double(255, 0) NULL DEFAULT NULL COMMENT '鍘熺墖鍘氬害', + films_id varchar(20) DEFAULT NULL COMMENT '鑶滅郴', + number int NULL DEFAULT NULL COMMENT '鏁伴噺', + PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB; -- rollback DROP TABLE up_workstation; -- changeset zsh:20241206068 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM up_workstation; -INSERT INTO up_workstation VALUES (1, 1, 0, 1, 0, 0, 0, 0, '', 0); -INSERT INTO up_workstation VALUES (2, 2, 0, 1, 0, 0, 0, 0, '', 0); -INSERT INTO up_workstation VALUES (3, 3, 0, 1, 0, 0, 0, 0, '', 0); -INSERT INTO up_workstation VALUES (4, 4, 0, 1, 0, 0, 0, 0, '', 0); +INSERT INTO up_workstation +VALUES (1, 1, 0, 1, 0, 0, 0, 0, '', 0); +INSERT INTO up_workstation +VALUES (2, 2, 0, 1, 0, 0, 0, 0, '', 0); +INSERT INTO up_workstation +VALUES (3, 3, 0, 1, 0, 0, 0, 0, '', 0); +INSERT INTO up_workstation +VALUES (4, 4, 0, 1, 0, 0, 0, 0, '', 0); -- changeset zsh:20241206069 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'work_assignment'; -CREATE TABLE work_assignment ( - id int NOT NULL AUTO_INCREMENT, - line int NULL DEFAULT NULL COMMENT '绾胯矾', - work_processes varchar(255) DEFAULT NULL COMMENT '宸ュ簭', - teams_groups_name varchar(255) DEFAULT NULL COMMENT '鐝粍鍚嶇О', - device_name varchar(255) DEFAULT NULL COMMENT '璁惧鍚嶇О', - PRIMARY KEY (id) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 4 ; +CREATE TABLE work_assignment +( + id int NOT NULL AUTO_INCREMENT, + line int NULL DEFAULT NULL COMMENT '绾胯矾', + work_processes varchar(255) DEFAULT NULL COMMENT '宸ュ簭', + teams_groups_name varchar(255) DEFAULT NULL COMMENT '鐝粍鍚嶇О', + device_name varchar(255) DEFAULT NULL COMMENT '璁惧鍚嶇О', + PRIMARY KEY (id) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 4; -- rollback DROP TABLE work_assignment; -- changeset zsh:20241206070 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM work_assignment; -INSERT INTO work_assignment VALUES (1, 40001, '閽㈠寲', '1鐝�', '閽㈠寲鐐�'); -INSERT INTO work_assignment VALUES (2, 2002, '鍐峰姞宸�', 'test', '鍗ц浆绔�'); -INSERT INTO work_assignment VALUES (3, 3001, '鍐峰姞宸�', 'test', '澶х悊鐗囧嚭鐗囪溅'); +INSERT INTO work_assignment +VALUES (1, 40001, '閽㈠寲', '1鐝�', '閽㈠寲鐐�'); +INSERT INTO work_assignment +VALUES (2, 2002, '鍐峰姞宸�', 'test', '鍗ц浆绔�'); +INSERT INTO work_assignment +VALUES (3, 3001, '鍐峰姞宸�', 'test', '澶х悊鐗囧嚭鐗囪溅'); + + +-- changeset zsh:20241206070 +-- preconditions onFail:CONTINUE onError:CONTINUE +-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM sys_config where id in (35,36,37,38,39,40); +INSERT INTO sys_config (id, parent_id, config_name, config_code, config_value, is_enable) +VALUES (35, 2, '閽㈠寲鍓嶇幓鐠�8mm闂撮殧', 'mes.verticalGlassGap_8', '6200', 1); +INSERT INTO sys_config (id, parent_id, config_name, config_code, config_value, is_enable) +VALUES (36, 2, '閽㈠寲鍓嶇幓鐠�10mm闂撮殧', 'mes.verticalGlassGap_10', '6200', 1); +INSERT INTO sys_config (id, parent_id, config_name, config_code, config_value, is_enable) +VALUES (37, 2, '閽㈠寲鍓嶇幓鐠�12mm闂撮殧', 'mes.verticalGlassGap_12', '6200', 1); +INSERT INTO sys_config (id, parent_id, config_name, config_code, config_value, is_enable) +VALUES (38, 3, '涓┖鐜荤拑8mm闂撮殧', 'mes.hollowGlassGap_8', '6200', 1); +INSERT INTO sys_config (id, parent_id, config_name, config_code, config_value, is_enable) +VALUES (39, 3, '涓┖鐜荤拑10mm闂撮殧', 'mes.hollowGlassGap_10', '6200', 1); +INSERT INTO sys_config (id, parent_id, config_name, config_code, config_value, is_enable) +VALUES (40, 3, '涓┖鐜荤拑12mm闂撮殧', 'mes.hollowGlassGap_12', '6200', 1); + -- Gitblit v1.8.0