Home | History | Annotate | Download | only in migrations
      1 UP_SQL = """
      2 ALTER TABLE tko_tests
      3 DROP FOREIGN KEY `invalidates_test_idx_fk`,
      4 ADD CONSTRAINT `invalidates_test_idx_fk_1`
      5 FOREIGN KEY (`invalidates_test_idx`)
      6 REFERENCES `tko_tests`(`test_idx`) ON DELETE CASCADE;
      7 """
      8 
      9 DOWN_SQL = """
     10 ALTER TABLE tko_tests
     11 DROP FOREIGN KEY `invalidates_test_idx_fk_1`,
     12 ADD CONSTRAINT `invalidates_test_idx_fk`
     13 FOREIGN KEY (`invalidates_test_idx`)
     14 REFERENCES `tko_tests`(`test_idx`) ON DELETE NO ACTION;
     15 """
     16