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