| # task_id can be NULL because tko_jobs.afe_job_id, which it replaces, can be | |
| # NULL. Same for parent_task_id. | |
| UP_SQL = """ | |
| CREATE INDEX reference_type_task_id ON tko_task_references (reference_type, task_id); | |
| CREATE INDEX reference_type_parent_task_id ON tko_task_references (reference_type, parent_task_id); | |
| """ | |
| DOWN_SQL = """ | |
| DROP INDEX reference_type_task_id ON tko_task_references; | |
| DROP INDEX reference_parent_type_task_id ON tko_task_references; | |
| """ |