YiWuProject.git

			@@ -9,17 +9,14 @@
			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 '更新时间',
			width int DEFAULT NULL COMMENT '宽',
			height int DEFAULT NULL COMMENT '高',
			thickness int DEFAULT NULL COMMENT '厚',
			film_remove int DEFAULT NULL COMMENT '是否除膜'
			update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间'
			);
			-- rollback DROP TABLE edg_storage_device_one_task;

			@@ -27,9 +24,10 @@
			-- 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, glass_id_in, glass_id_out, current_cell, start_cell,
			end_cell, task_state, task_type, width, height, thickness, film_remove)
			VALUES (0, NULL, NULL, NULL, 1, 0, NULL, 0, NULL, 0, 0, 0, 0);
			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
			@@ -41,26 +39,24 @@
			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 '更新时间',
			width int DEFAULT NULL COMMENT '宽',
			height int DEFAULT NULL COMMENT '高',
			thickness int DEFAULT NULL COMMENT '厚',
			film_remove int DEFAULT NULL 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, glass_id_in, glass_id_out, current_cell, start_cell,
			end_cell, task_state, task_type, width, height, thickness, film_remove)
			VALUES (0, NULL, NULL, NULL, 1, 0, NULL, 0, NULL, 0, 0, 0, 0);
			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);



			@@ -72,6 +68,8 @@
			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 '预留层号',
			@@ -108,6 +106,7 @@
			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 '更新时间',
			@@ -120,9 +119,9 @@
			-- 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, task_state, total_count,
			finish_count, damage_count)
			VALUES (0, 0, 0, 0, 0, 0, 0, 0);
			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
			@@ -133,6 +132,7 @@
			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 '更新时间',
			@@ -145,9 +145,9 @@
			-- 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, task_state, total_count,
			finish_count, damage_count)
			VALUES (0, 0, 0, 0, 0, 0, 0, 0);
			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
			@@ -161,6 +161,7 @@
			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 '更新时间',