adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V5.10__AlterforWorkFlowDesignerTables.sql

   1 use catalogdb;
   2
   3 ALTER TABLE activity_spec_to_activity_spec_categories DROP FOREIGN KEY fk_activity_spec_to_activity_spec_categories__activity_spec_c1;
   4
   5 ALTER TABLE activity_spec_categories modify id INT(11) not null auto_increment;
   6
   7 ALTER TABLE activity_spec_to_activity_spec_categories ADD
   8  CONSTRAINT `fk_activity_spec_to_activity_spec_categories__activity_spec_c1`
   9     FOREIGN KEY (`ACTIVITY_SPEC_CATEGORIES_ID`)
  10     REFERENCES `activity_spec_categories` (`ID`)
  11     ON DELETE CASCADE
  12     ON UPDATE CASCADE;
  13
  14 ALTER TABLE activity_spec_to_activity_spec_categories modify id INT(11) not null auto_increment;