ADD_FOREIGN_KEYS = """
ALTER TABLE tko_job_keyvals DROP FOREIGN KEY tko_job_keyvals_ibfk_1;
ALTER TABLE tko_job_keyvals ADD CONSTRAINT tko_job_keyvals_ibfk_1
    FOREIGN KEY (job_id) REFERENCES tko_jobs (job_idx) ON DELETE CASCADE;
"""

DROP_FOREIGN_KEYS = """
ALTER TABLE tko_job_keyvals DROP FOREIGN KEY tko_job_keyvals_ibfk_1;
ALTER TABLE tko_job_keyvals ADD CONSTRAINT tko_job_keyvals_ibfk_1
    FOREIGN KEY (job_id) REFERENCES tko_jobs (job_idx);
"""

def migrate_up(mgr):
    mgr.execute_script(ADD_FOREIGN_KEYS)

def migrate_down(mgr):
    mgr.execute_script(DROP_FOREIGN_KEYS)