abb-manage/db/设备调拨SQL.sql

ALTER TABLE `qykh_sb_cqdw`.`t_fill_project_quantity`
    ADD COLUMN `parent_id` varchar(64) NULL COMMENT '父类ID' AFTER `id`,
    ADD COLUMN `code` varchar(255) NULL COMMENT '标识' AFTER `parent_id`;

ALTER TABLE `qykh_sb_cqdw`.`t_fill_project_quantity`
    ADD COLUMN `site_unit` smallint(2) NULL DEFAULT NULL COMMENT '位置单位' AFTER `update_time`,
    ADD COLUMN `price` decimal(20, 2) NULL DEFAULT NULL COMMENT '单价' AFTER `site_unit`,
    ADD COLUMN `total_price` decimal(20, 2) NULL DEFAULT NULL COMMENT '总价' AFTER `price`;

ALTER TABLE `qykh_sb_cqdw`.`t_sb_run_fill`
    ADD COLUMN `fill_date` date NULL COMMENT '填报时间' AFTER `dept_id`;

ALTER TABLE `qykh_sb_cqdw`.`t_sb_inspection_fill`
    ADD COLUMN `fill_date` date NULL COMMENT '填报时间' AFTER `dept_id`;