| UP_SQL = """ | |
| ALTER TABLE afe_job_keyvals DROP FOREIGN KEY `afe_job_keyvals_ibfk_1`; | |
| """ | |
| # Before syncing down, you must cleanup the rows that do not meet | |
| # the foreign key constraint by: | |
| # | |
| # DELETE t1 FROM afe_job_keyvals t1 | |
| # LEFT OUTER JOIN afe_jobs t2 | |
| # ON (t1.job_id = t2.id) WHERE t2.id is NULL; | |
| # | |
| # Execute with care! | |
| DOWN_SQL = """ | |
| ALTER TABLE afe_job_keyvals | |
| ADD CONSTRAINT afe_job_keyvals_ibfk_1 FOREIGN KEY | |
| (`job_id`) REFERENCES `afe_jobs`(`id`) | |
| ON DELETE NO ACTION; | |
| """ |