| # 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 TABLE tko_task_references ( |
| id integer AUTO_INCREMENT NOT NULL PRIMARY KEY, |
| reference_type enum('skylab', 'afe') NOT NULL, |
| tko_job_idx int(10) unsigned NOT NULL, |
| task_id varchar(20) DEFAULT NULL, |
| parent_task_id varchar(20) DEFAULT NULL, |
| CONSTRAINT tko_task_references_ibfk_1 FOREIGN KEY (tko_job_idx) REFERENCES tko_jobs (job_idx) ON DELETE CASCADE, |
| KEY reference_type_id (reference_type, id) |
| ) ENGINE=InnoDB; |
| """ |
| |
| DOWN_SQL = """ |
| DROP TABLE IF EXISTS tko_task_references; |
| """ |
