UP_SQL = """ | |
ALTER TABLE tko_tests | |
DROP FOREIGN KEY `invalidates_test_idx_fk`, | |
ADD CONSTRAINT `invalidates_test_idx_fk_1` | |
FOREIGN KEY (`invalidates_test_idx`) | |
REFERENCES `tko_tests`(`test_idx`) ON DELETE CASCADE; | |
""" | |
DOWN_SQL = """ | |
ALTER TABLE tko_tests | |
DROP FOREIGN KEY `invalidates_test_idx_fk_1`, | |
ADD CONSTRAINT `invalidates_test_idx_fk` | |
FOREIGN KEY (`invalidates_test_idx`) | |
REFERENCES `tko_tests`(`test_idx`) ON DELETE NO ACTION; | |
""" |