ALTER TABLE `smart_assess`.`ass_project`
ADD INDEX `index_agency_id`(`agency_id`) USING BTREE;

ALTER TABLE `smart_assess`.`ass_audit`
ADD INDEX `index_project_id`(`project_id`) USING BTREE;

ALTER TABLE `smart_assess`.`ass_conclusion`
ADD INDEX `index_project_id`(`project_id`) USING BTREE;

ALTER TABLE `smart_assess`.`ass_contract`
ADD INDEX `index_project_id`(`project_id`) USING BTREE;

ALTER TABLE `smart_assess`.`ass_estimate_plan`
    ADD INDEX `index_project_id`(`project_id`) USING BTREE;

ALTER TABLE `smart_assess`.`ass_estimate_task`
    ADD INDEX `index_project_id`(`project_id`) USING BTREE;

ALTER TABLE `smart_assess`.`ass_filing_apply`
    ADD INDEX `index_project_id`(`project_id`) USING BTREE;

ALTER TABLE `smart_assess`.`ass_investigation`
    ADD INDEX `index_project_id`(`project_id`) USING BTREE;

ALTER TABLE `smart_assess`.`ass_process_audit`
    ADD INDEX `index_project_id`(`project_id`) USING BTREE;

ALTER TABLE `smart_assess`.`ass_project_material`
    ADD INDEX `index_project_id`(`project_id`) USING BTREE;

ALTER TABLE `smart_assess`.`ass_project_supplement`
    ADD INDEX `index_agency_id`(`agency_id`) USING BTREE;

ALTER TABLE `smart_assess`.`ass_project_supplement_file`
    ADD INDEX `index_project_id`(`project_id`) USING BTREE;

ALTER TABLE `smart_assess`.`ass_recitification`
    ADD INDEX `index_project_id`(`project_id`) USING BTREE;

ALTER TABLE `smart_assess`.`ass_risk_estimate`
    ADD INDEX `index_project_id`(`project_id`) USING BTREE;

ALTER TABLE `smart_assess`.`ass_work_notification`
    ADD INDEX `index_project_id`(`project_id`) USING BTREE;