phantomknight287/saturn

public

The operating system for your freelance business.

saturndrizzle0015_melodic_jack_flag.sql

update metadata, add keyboard shortcuts and update invite modal to show existing members of the org and force a base member rate80fbffd6 months ago12 lines · 507 B

1	CREATE TABLE "pending_member_rates" (
2	"id" text PRIMARY KEY
3	"invitation_id" text NOT NULL
4	"organization_id" text NOT NULL
5	"email" text NOT NULL
6	"hourly_rate" integer NOT NULL
7	"currency" text DEFAULT
8	"created_at" timestamp DEFAULT
9	CONSTRAINT "pending_member_rates_invitation_id_unique" UNIQUE
10	);
11	--> statement-breakpoint
12	CREATE INDEX "pending_member_rates_org_email_idx" ON

NOT NULL

,

'

USD

'

NOT NULL

,

now

()

NOT NULL

,

(

"

invitation_id

"

)

"

pending_member_rates

"

USING

btree (

"

organization_id

"

,

"

email

"

);