1UP_SQL = """ 2ALTER TABLE afe_job_keyvals DROP FOREIGN KEY `afe_job_keyvals_ibfk_1`; 3""" 4 5# Before syncing down, you must cleanup the rows that do not meet 6# the foreign key constraint by: 7# 8# DELETE t1 FROM afe_job_keyvals t1 9# LEFT OUTER JOIN afe_jobs t2 10# ON (t1.job_id = t2.id) WHERE t2.id is NULL; 11# 12# Execute with care! 13 14DOWN_SQL = """ 15ALTER TABLE afe_job_keyvals 16ADD CONSTRAINT afe_job_keyvals_ibfk_1 FOREIGN KEY 17(`job_id`) REFERENCES `afe_jobs`(`id`) 18ON DELETE NO ACTION; 19""" 20