Allow creation of member invoices (#38)1650f665 months ago8 lines · 922 B | 1 | CREATE TYPE "public"."invoice_recipient" AS ENUM('member', 'client');--> statement-breakpoint |
| 2 | ALTER TABLE "invoice_recipients" RENAME COLUMN "client_member_id |
| 3 | ALTER TABLE "invoice_recipients" DROP |
| 4 | ALTER TABLE "invoice_recipients" DROP |
| 5 | --> statement-breakpoint |
| 6 | ALTER TABLE "invoices" ADD COLUMN |
| 7 | ALTER TABLE "invoice_recipients" ADD |
| 8 | ALTER TABLE "invoice_recipients" ADD |
"
TO
"
member_id
"
;
--
> statement-breakpoint
CONSTRAINT
"
invoice_recipients_client_member_id_invoice_id_unique
"
;
--
> statement-breakpoint
CONSTRAINT
"
invoice_recipients_client_member_id_members_id_fk
"
;
"
recipient
"
"
invoice_recipient
"
DEFAULT
'
client
'
NOT NULL
;
--
> statement-breakpoint
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
CONSTRAINT
"
invoice_recipients_member_id_invoice_id_unique
"
UNIQUE
(
"
member_id
"
,
"
invoice_id
"
);