cfapi/scripts/constraints.sql at master · PatrickLaban/cfapi · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
alter table story
  drop constraint story_organization_name_fkey;

alter table story
  add constraint story_organization_name_fkey
  foreign key (organization_name) references organization(name) on delete cascade;

alter table project
  drop constraint project_organization_name_fkey ;

alter table project
  add constraint project_organization_name_fkey
  foreign key (organization_name) references organization(name) on delete cascade;

alter table event
  drop constraint event_organization_name_fkey;

alter table event
  add constraint event_organization_name_fkey
  foreign key (organization_name) references organization(name) on delete cascade;

alter table issue
  drop constraint issue_project_id_fkey ;

alter table issue
  add constraint issue_project_id_fkey
  foreign key (project_id) references project(id) on delete cascade;

alter table label
  drop constraint label_issue_id_fkey ;

alter table label
  add constraint label_issue_id_fkey
  foreign key (issue_id) references issue(id) on delete cascade;