Closed hirokiterashima closed 4 years ago
alter table `wise_database`.`tags` add column `runId` bigint null after `name`;
create table workgroups_related_to_tags ( workgroups_fk bigint not null, tags_fk integer not null, constraint workgroups_related_to_tagsTagFK foreign key (tags_fk) references tags (id), constraint workgroups_related_to_tagsWorkgroupFK foreign key (workgroups_fk) references workgroups (id), primary key (workgroups_fk, tags_fk) );
2. Test that everything works as before
create table workgroups_related_to_tags ( workgroups_fk bigint not null, tags_fk integer not null, constraint workgroups_related_to_tagsTagFK foreign key (tags_fk) references tags (id), constraint workgroups_related_to_tagsWorkgroupFK foreign key (workgroups_fk) references workgroups (id), primary key (workgroups_fk, tags_fk) );