1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
| -- liquibase formatted sql
|
| -- changeset zt:20250407001
| -- preconditions onFail:CONTINUE onError:CONTINUE
| -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'sys_config' ;
| CREATE TABLE `sys_config` (
| `id` int NOT NULL AUTO_INCREMENT,
| `parent_id` int NULL DEFAULT NULL COMMENT '父配置id',
| `config_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '配置名',
| `config_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '配置代码',
| `config_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '配置值',
| `is_enable` 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 = 61 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
| -- rollback DROP TABLE big_storage_cage;
|
|
| -- changeset zt:20250407001
| -- preconditions onFail:CONTINUE onError:CONTINUE
| -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM sys_config;
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (1, 1, '钢化炉数阈值', 'cache_threshold', '11', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:29');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (2, 1, '磨边参数换算率', 'cache_ratio', '10', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:26');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (3, 1, '卧理最大长边', 'cache_cacheWidth', '3600', 0, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (4, 1, '卧理最大短边', 'cache_cacheHeight', '3000', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (5, 1, '磨边二线最大长边', 'cache_max_firstLength', '3500', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (6, 1, '磨边二线最大短边', 'cache_max_secondLength', '2500', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (7, 1, '磨边一线最大长边', 'cache_min_one_firstLength', '460', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (8, 1, '磨边一线最大短边', 'cache_min_one,secondLength', '390', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (9, 1, '磨边二线最大长边', 'cache_min_two_firstLength', '300', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (10, 1, '磨边二线最大短边', 'cache_min_two_secondLength', '300', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (11, 1, '卧理玻璃间隙', 'cache_glassGap', '2500', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (12, 1, '卧理格子宽度', 'cache_cellLength', '2500', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (13, 1, '排序方式', 'cache_sequence_order', 'FALSE', 1, '2025-04-07 09:20:04', '2025-04-08 13:43:18');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (14, 2, '排序方式', 'cache_sequence_order', 'TRUE', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (15, 2, '一炉玻璃占用格子数', 'vertical_mincount', '30', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (16, 2, '大车宽度', 'vertical_carWidth', '6200', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (17, 2, '格子宽度', 'vertical_slotWidth', '6200', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (18, 2, '进片车最大玻璃数', 'vertical_inCarSize', '5', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (19, 2, '出片车最大玻璃数', 'vertical_outCarSize', '6', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (20, 2, '玻璃间隙', 'vertical_glassGap', '250', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (21, 2, '钢化炉长度', 'vertical_xMaxSize', '2800', 0, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (22, 2, '格子最大高度', 'vertical_slotMaxHeight', '2500', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (23, 2, '格子最大厚度', 'vertical_slotMaxthickness', '12', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (24, 2, '钢出目标位置', 'vertical_temperingOutTargetPosition', '930', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (25, 2, '人工下片目标位置', 'vertical_artificialOutTargetPosition', '931', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (26, 3, '排序方式', 'hollow_sequence,order', 'TRUE', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (27, 3, '一炉玻璃占用格子数', 'hollow_mincount', '30', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (28, 3, '大车宽度', 'hollow_carWidth', '6200', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (29, 3, '格子宽度', 'hollow_slotWidth', '6200', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (30, 3, '进片车最大玻璃数', 'hollow_inCarSize', '5', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (31, 3, '出片车最大玻璃数', 'hollow_outCarSize', '6', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (32, 3, '玻璃间隙', 'hollow_glassGap', '250', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (33, 3, '钢化炉长度', 'hollow_xMaxSize', '2800', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (34, 3, '钢出目标位置', 'hollow_temperingOutTargetPosition', '930', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (35, 3, '人工下片目标位置', 'hollow_artificialOutTargetPosition', '931', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (36, 3, '格子最大高度', 'hollow_slotMaxHeight', '2500', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (37, 3, '格子最大厚度', 'hollow_slotMaxthickness', '12', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (38, 4, '钢化炉长度', 'tempering_width', '2800', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
| INSERT INTO `north_glass_mes`.`sys_config` (`id`, `parent_id`, `config_name`, `config_code`, `config_value`, `is_enable`, `create_time`, `update_time`) VALUES (39, 4, '钢化炉宽度', 'tempering_height', '5000', 1, '2025-04-07 09:20:04', '2025-04-08 13:42:00');
|
|
