-- liquibase formatted sql
|
|
-- changeset zsh:20241107001
|
-- preconditions onFail:CONTINUE onError:CONTINUE
|
-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'edg_storage_device_one_task' and table_schema = 'hangzhoumes';
|
CREATE TABLE edg_storage_device_one_task
|
(
|
task_running int 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 '磨边前玻璃id',
|
in_place int DEFAULT 0 COMMENT '就位信号',
|
current_cell int DEFAULT '0' COMMENT '当前层号',
|
start_cell int DEFAULT '0' COMMENT '层号',
|
end_cell int DEFAULT NULL COMMENT '预留层号',
|
task_state int DEFAULT NULL COMMENT '任务状态 0默认空任务 1执行中 2结束任务',
|
task_type int DEFAULT NULL COMMENT '任务类型',
|
create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间'
|
);
|
-- rollback DROP TABLE edg_storage_device_one_task;
|
|
|
-- changeset zsh:20241107002
|
-- 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 (task_running, glass_id, in_place, glass_id_in, glass_id_out, current_cell,
|
start_cell,
|
end_cell, task_state, task_type)
|
VALUES (0, NULL, 0, NULL, NULL, 1, 0, NULL, 0, NULL, 0, 0, 0, 0);
|
|
|
-- changeset zsh:20241107003
|
-- preconditions onFail:CONTINUE onError:CONTINUE
|
-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'edg_storage_device_two_task' and table_schema = 'hangzhoumes';
|
CREATE TABLE edg_storage_device_two_task
|
(
|
task_running int 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 '磨边前玻璃id',
|
in_place int DEFAULT 0 COMMENT '就位信号',
|
current_cell int DEFAULT '0' COMMENT '当前层号',
|
start_cell int DEFAULT '0' COMMENT '层号',
|
end_cell int DEFAULT NULL COMMENT '预留层号',
|
task_state int DEFAULT NULL COMMENT '任务状态 0默认空任务 1执行中 2结束任务',
|
task_type int DEFAULT NULL COMMENT '任务类型',
|
create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间'
|
);
|
-- rollback DROP TABLE edg_storage_device_two_task;
|
|
-- changeset zsh:20241107004
|
-- 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 (task_running, glass_id, in_place, glass_id_in, glass_id_out, current_cell,
|
start_cell,
|
end_cell, task_state, task_type)
|
VALUES (0, NULL, 0, NULL, NULL, 1, 0, NULL, 0, NULL, 0, 0, 0, 0);
|
|
|
|
-- changeset zsh:20241107005
|
-- preconditions onFail:CONTINUE onError:CONTINUE
|
-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'edg_storage_device_task_history' and table_schema = 'hangzhoumes';
|
CREATE TABLE edg_storage_device_task_history
|
(
|
id bigint NOT NULL AUTO_INCREMENT COMMENT '工程表id',
|
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 '磨边前玻璃id',
|
in_place int DEFAULT 0 COMMENT '就位信号',
|
current_cell int DEFAULT '0' COMMENT '当前层号',
|
start_cell int DEFAULT '0' COMMENT '层号',
|
end_cell int DEFAULT NULL COMMENT '预留层号',
|
task_state int DEFAULT NULL COMMENT '任务状态 0默认空任务 1执行中 2结束任务',
|
task_type int 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
|
);
|
-- rollback DROP TABLE edg_storage_device_task_history;
|
|
-- changeset zsh:20241107006
|
-- preconditions onFail:CONTINUE onError:CONTINUE
|
-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'edg_glass_task_queue_info' and table_schema = 'hangzhoumes';
|
CREATE TABLE edg_glass_task_queue_info
|
(
|
glass_id varchar(20) DEFAULT NULL COMMENT '磨边前玻璃id',
|
width int DEFAULT NULL COMMENT '宽',
|
height int DEFAULT NULL COMMENT '高',
|
thickness int DEFAULT NULL COMMENT '厚',
|
state int DEFAULT NULL COMMENT '状态',
|
line int DEFAULT NULL COMMENT '线路',
|
create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间'
|
);
|
-- rollback DROP TABLE edg_glass_task_queue_info;
|
|
-- changeset zsh:20241107007
|
-- preconditions onFail:CONTINUE onError:CONTINUE
|
-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'load_glass_device_one_task' and table_schema = 'hangzhoumes';
|
CREATE TABLE load_glass_device_one_task
|
(
|
task_running int DEFAULT '0' COMMENT '任务请求 0无任务 1上片',
|
raw_glass_width int DEFAULT '0' COMMENT '原片宽',
|
raw_glass_height int DEFAULT '0' COMMENT '原片高',
|
slot int DEFAULT '0' COMMENT '上片位编号',
|
inkage_state int DEFAULT '0' COMMENT '联机状态',
|
task_state int 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 DEFAULT '0' COMMENT '上片总数量',
|
finish_count int DEFAULT '0' COMMENT '已完成数量',
|
damage_count int DEFAULT '0' COMMENT '破损数量'
|
);
|
-- rollback DROP TABLE load_glass_device_one_task;
|
|
-- changeset zsh:20241107008
|
-- 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 (task_running, raw_glass_width, raw_glass_height, slot, inkage_state, task_state,
|
total_count, finish_count, damage_count)
|
VALUES (0, 0, 0, 0, 0, 0, 0, 0, 0);
|
|
-- changeset zsh:20241107009
|
-- preconditions onFail:CONTINUE onError:CONTINUE
|
-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'load_glass_device_two_task' and table_schema = 'hangzhoumes';
|
CREATE TABLE load_glass_device_two_task
|
(
|
task_running int DEFAULT '0' COMMENT '任务请求 0无任务 1上片',
|
raw_glass_width int DEFAULT '0' COMMENT '原片宽',
|
raw_glass_height int DEFAULT '0' COMMENT '原片高',
|
slot int DEFAULT '0' COMMENT '上片位编号',
|
inkage_state int DEFAULT '0' COMMENT '联机状态',
|
task_state int 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 DEFAULT '0' COMMENT '上片总数量',
|
finish_count int DEFAULT '0' COMMENT '已完成数量',
|
damage_count int DEFAULT '0' COMMENT '破损数量'
|
);
|
-- rollback DROP TABLE load_glass_device_two_task;
|
|
-- changeset zsh:20241107010
|
-- 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 (task_running, raw_glass_width, raw_glass_height, slot, inkage_state, task_state,
|
total_count, finish_count, damage_count)
|
VALUES (0, 0, 0, 0, 0, 0, 0, 0, 0);
|
|
|
-- changeset zsh:20241107011
|
-- preconditions onFail:CONTINUE onError:CONTINUE
|
-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'load_glass_device_task_history' and table_schema = 'hangzhoumes';
|
CREATE TABLE load_glass_device_task_history
|
(
|
id bigint NOT NULL AUTO_INCREMENT COMMENT '历史任务id',
|
task_running int DEFAULT '0' COMMENT '任务请求 0无任务 1上片',
|
raw_glass_width int DEFAULT '0' COMMENT '原片宽',
|
raw_glass_height int DEFAULT '0' COMMENT '原片高',
|
station int DEFAULT '0' COMMENT '上片设备编号',
|
slot int DEFAULT '0' COMMENT '上片位编号',
|
inkage_state int DEFAULT '0' COMMENT '联机状态',
|
task_state int 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 DEFAULT '0' COMMENT '上片总数量',
|
finish_count int DEFAULT '0' COMMENT '已完成数量',
|
damage_count int DEFAULT '0' COMMENT '破损数量',
|
PRIMARY KEY (id) USING BTREE
|
);
|
-- rollback DROP TABLE load_glass_device_task_history;
|
|
-- changeset zsh:20241112001
|
-- preconditions onFail:CONTINUE onError:CONTINUE
|
-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'big_storage_cage_history_task' and table_schema = 'hangzhoumes';
|
CREATE TABLE big_storage_cage_history_task
|
(
|
id int NOT NULL AUTO_INCREMENT,
|
glass_id varchar(32) DEFAULT NULL COMMENT '玻璃id',
|
start_slot int DEFAULT '0' COMMENT '起始格子',
|
target_slot int DEFAULT '0' COMMENT '目标格子',
|
task_state int DEFAULT NULL COMMENT '任务状态 ',
|
glass_count int DEFAULT NULL COMMENT '玻璃数量',
|
task_type int 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)
|
);
|
-- rollback DROP TABLE big_storage_cage_history_task;
|
|
-- changeset zsh:20241112002
|
-- 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' and table_schema = 'hangzhoumes';
|
CREATE TABLE big_storage_cage_in_one_task
|
(
|
glass_id varchar(32) DEFAULT NULL COMMENT '玻璃id',
|
start_slot int DEFAULT '0' COMMENT '起始格子',
|
target_slot int DEFAULT '0' COMMENT '目标格子',
|
task_state int DEFAULT NULL COMMENT '任务状态 '
|
)
|
-- rollback DROP TABLE big_storage_cage_in_one_task;
|
|
-- changeset zsh:20241112003
|
-- 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(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_in_one_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_in_one_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_in_one_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_in_one_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_in_one_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
|
|
-- changeset zsh:20241112004
|
-- 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' and table_schema = 'hangzhoumes';
|
CREATE TABLE big_storage_cage_in_two_task
|
(
|
glass_id VARCHAR(32) COMMENT '玻璃id',
|
start_slot INT DEFAULT '0' COMMENT '起始格子',
|
target_slot INT DEFAULT '0' COMMENT '目标格子',
|
task_state INT DEFAULT NULL COMMENT '任务状态 '
|
);
|
-- rollback DROP TABLE big_storage_cage_in_two_task;
|
|
-- changeset zsh:20241112005
|
-- 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(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_in_two_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_in_two_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_in_two_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_in_two_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_in_two_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
|
-- changeset zsh:20241113001
|
-- 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' and table_schema = 'hangzhoumes';
|
CREATE TABLE big_storage_cage_out_one_task
|
(
|
glass_id varchar(32) DEFAULT NULL COMMENT '玻璃id',
|
start_slot int DEFAULT '0' COMMENT '起始格子',
|
target_slot int DEFAULT '0' COMMENT '目标格子',
|
task_state int DEFAULT NULL COMMENT '任务状态 '
|
)
|
-- rollback DROP TABLE big_storage_cage_out_one_task;
|
|
-- changeset zsh:20241113002
|
-- 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(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_out_one_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_out_one_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_out_one_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_out_one_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_out_one_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
|
|
-- changeset zsh:20241113003
|
-- 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' and table_schema = 'hangzhoumes';
|
CREATE TABLE big_storage_cage_out_two_task
|
(
|
glass_id VARCHAR(32) COMMENT '玻璃id',
|
start_slot INT DEFAULT '0' COMMENT '起始格子',
|
target_slot INT DEFAULT '0' COMMENT '目标格子',
|
task_state INT DEFAULT NULL COMMENT '任务状态 '
|
);
|
-- rollback DROP TABLE big_storage_cage_out_two_task;
|
-- changeset zsh:20241113004
|
-- 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(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_out_two_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_out_two_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_out_two_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_out_two_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
INSERT INTO big_storage_cage_out_two_task(glass_id, start_slot, target_slot, task_state)
|
VALUES (NULL, 0, 0, 0);
|
