ALTER TABLE `device_maintenance`
|
ADD COLUMN `area_id` bigint DEFAULT NULL COMMENT '设备区域id' AFTER `device_ledger_id`;
|
|
ALTER TABLE `device_repair`
|
ADD COLUMN `area_id` bigint DEFAULT NULL COMMENT '设备区域id' AFTER `device_ledger_id`;
|
|
ALTER TABLE `inspection_task`
|
ADD COLUMN `area_id` bigint DEFAULT NULL COMMENT '设备区域id' AFTER `task_id`;
|
|
ALTER TABLE `timing_task`
|
ADD COLUMN `area_id` bigint DEFAULT NULL COMMENT '设备区域id' AFTER `task_id`;
|
|
ALTER TABLE `maintenance_task`
|
ADD COLUMN `area_id` bigint DEFAULT NULL COMMENT '设备区域id' AFTER `task_id`;
|
