phantomknight287/saturn · drizzle/0029_sweet_wind_dancer.sql at a61330c0160e2ec075ca7dba8b410f431c00da4e

CREATE TYPE "public"."invoice_recipient" AS ENUM('member', 'client');--> statement-breakpoint

ALTER TABLE "invoice_recipients" RENAME COLUMN "client_member_id" TO "member_id";--> statement-breakpoint

ALTER TABLE "invoice_recipients" DROP CONSTRAINT "invoice_recipients_client_member_id_invoice_id_unique";--> statement-breakpoint

4

ALTER TABLE "invoice_recipients" DROP CONSTRAINT "invoice_recipients_client_member_id_members_id_fk";

5

--> statement-breakpoint

6

ALTER TABLE "invoices" ADD COLUMN "recipient" "invoice_recipient" DEFAULT 'client' NOT NULL;--> statement-breakpoint

7

ALTER TABLE "invoice_recipients" ADD CONSTRAINT "invoice_recipients_member_id_members_id_fk" FOREIGN KEY ("member_id") REFERENCES "public"."members"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint

8

ALTER TABLE "invoice_recipients" ADD CONSTRAINT "invoice_recipients_member_id_invoice_id_unique" UNIQUE("member_id","invoice_id");