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