feat: here comes the money442302e7 months ago10 lines · 1.0 KB | 1 | ALTER TABLE "requirement_threads" RENAME TO "threads";--> statement-breakpoint |
| 2 | ALTER TABLE "thread_messages" DROP |
| 3 | --> statement-breakpoint |
| 4 | ALTER TABLE "threads" DROP |
| 5 | --> statement-breakpoint |
| 6 | ALTER TABLE "threads" DROP |
| 7 | --> statement-breakpoint |
| 8 | ALTER TABLE "thread_messages" ADD |
| 9 | ALTER TABLE "threads" ADD |
| 10 | ALTER TABLE "threads" ADD |
CONSTRAINT
"
thread_messages_thread_id_requirement_threads_id_fk
"
;
CONSTRAINT
"
requirement_threads_project_id_projects_id_fk
"
;
CONSTRAINT
"
requirement_threads_created_by_member_id_members_id_fk
"
;
CONSTRAINT
"
thread_messages_thread_id_threads_id_fk
"
FOREIGN KEY
(
"
thread_id
"
)
REFERENCES
"
public
"
.
"
threads
"
(
"
id
"
)
ON DELETE cascade
ON UPDATE
no
action
;
--
> statement-breakpoint
CONSTRAINT
"
threads_project_id_projects_id_fk
"
FOREIGN KEY
(
"
project_id
"
)
REFERENCES
"
public
"
.
"
projects
"
(
"
id
"
)
ON DELETE cascade
ON UPDATE
no
action
;
--
> statement-breakpoint
CONSTRAINT
"
threads_created_by_member_id_members_id_fk
"
FOREIGN KEY
(
"
created_by_member_id
"
)
REFERENCES
"
public
"
.
"
members
"
(
"
id
"
)
ON DELETE
set
null
ON UPDATE
no
action
;