# 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;
|
"""
|
