Ghost
New
phantomknight287
/
saturn
public
The operating system for your freelance business.
Star
0
Fork
0
Code
Issues
0
Pull requests
0
c21e3a1
1
branch
Go to file
t
Code
saturn
drizzle
0034_perfect_risque.sql
Staging (#68)
90eccbb
4 months ago
4 lines · 499 B
1
ALTER
TABLE
"
custom_fields
"
DROP
CONSTRAINT
"
custom_fields_project_id_projects_id_fk
"
;
2
--
> statement-breakpoint
3
ALTER
TABLE
"
projects
"
ADD
4
ALTER
TABLE
"
custom_fields
"
ADD
CONSTRAINT
"
projects_id_organization_id_unique
"
UNIQUE
(
"
id
"
,
"
organization_id
"
);
--
> statement-breakpoint
CONSTRAINT
"
custom_fields_project_id_organization_id_projects_id_organization_id_fk
"
FOREIGN KEY
(
"
project_id
"
,
"
organization_id
"
)
REFERENCES
"
public
"
.
"
projects
"
(
"
id
"
,
"
organization_id
"
)
ON DELETE cascade
ON UPDATE
no
action
;