phantomknight287/saturn

public

The operating system for your freelance business.

feat: here comes the money442302e7 months ago143 lines · 6.4 KB

1	CREATE TABLE "accounts" (
2	"id" text PRIMARY KEY
3	"account_id" text NOT NULL
4	"provider_id" text NOT NULL
5	"user_id" text NOT NULL
6	"access_token" text,
7	"refresh_token" text,
8	"id_token" text,
9	"access_token_expires_at" timestamp,
10	"refresh_token_expires_at" timestamp,
11	"scope" text,
12	"password" text,
13	"created_at" timestamp DEFAULT
14	"updated_at" timestamp NOT NULL
15	);
16	--> statement-breakpoint
17	CREATE TABLE "apikeys" (
18	"id" text PRIMARY KEY
19	"config_id" text DEFAULT
20	"name" text,
21	"start" text,
22	"reference_id" text NOT NULL
23	"prefix" text,
24	"key" text NOT NULL
25	"refill_interval" integer,
26	"refill_amount" integer,
27	"last_refill_at" timestamp,
28	"enabled" boolean DEFAULT
29	"rate_limit_enabled" boolean DEFAULT
30	"rate_limit_time_window" integer DEFAULT
31	"rate_limit_max" integer DEFAULT
32	"request_count" integer DEFAULT
33	"remaining" integer,
34	"last_request" timestamp,
35	"expires_at" timestamp,
36	"created_at" timestamp NOT NULL
37	"updated_at" timestamp NOT NULL
38	"permissions" text,
39	"metadata" text
40	);
41	--> statement-breakpoint
42	CREATE TABLE "invitations" (
43	"id" text PRIMARY KEY
44	"organization_id" text NOT NULL
45	"email" text NOT NULL
46	"role" text,
47	"team_id" text,
48	"status" text DEFAULT
49	"expires_at" timestamp NOT NULL
50	"created_at" timestamp DEFAULT
51	"inviter_id" text NOT NULL
52	);
53	--> statement-breakpoint
54	CREATE TABLE "members" (
55	"id" text PRIMARY KEY
56	"organization_id" text NOT NULL
57	"user_id" text NOT NULL
58	"role" text DEFAULT
59	"created_at" timestamp NOT NULL
60	);
61	--> statement-breakpoint
62	CREATE TABLE "organizations" (
63	"id" text PRIMARY KEY
64	"name" text NOT NULL
65	"slug" text NOT NULL
66	"logo" text,
67	"created_at" timestamp NOT NULL
68	"metadata" text,
69	CONSTRAINT "organizations_slug_unique" UNIQUE
70	);
71	--> statement-breakpoint
72	CREATE TABLE "sessions" (
73	"id" text PRIMARY KEY
74	"expires_at" timestamp NOT NULL
75	"token" text NOT NULL
76	"created_at" timestamp DEFAULT
77	"updated_at" timestamp NOT NULL
78	"ip_address" text,
79	"user_agent" text,
80	"user_id" text NOT NULL
81	"active_organization_id" text,
82	"active_team_id" text,
83	CONSTRAINT "sessions_token_unique" UNIQUE
84	);
85	--> statement-breakpoint
86	CREATE TABLE "team_members" (
87	"id" text PRIMARY KEY
88	"team_id" text NOT NULL
89	"user_id" text NOT NULL
90	"created_at" timestamp
91	);
92	--> statement-breakpoint
93	CREATE TABLE "teams" (
94	"id" text PRIMARY KEY
95	"name" text NOT NULL
96	"organization_id" text NOT NULL
97	"created_at" timestamp NOT NULL
98	"updated_at" timestamp
99	);
100	--> statement-breakpoint
101	CREATE TABLE "users" (
102	"id" text PRIMARY KEY
103	"name" text NOT NULL
104	"email" text NOT NULL
105	"email_verified" boolean DEFAULT
106	"image" text,
107	"created_at" timestamp DEFAULT
108	"updated_at" timestamp DEFAULT
109	CONSTRAINT "users_email_unique" UNIQUE
110	);
111	--> statement-breakpoint
112	CREATE TABLE "verifications" (
113	"id" text PRIMARY KEY
114	"identifier" text NOT NULL
115	"value" text NOT NULL
116	"expires_at" timestamp NOT NULL
117	"created_at" timestamp DEFAULT
118	"updated_at" timestamp DEFAULT
119	);
120	--> statement-breakpoint
121	ALTER TABLE "accounts" ADD
122	ALTER TABLE "invitations" ADD
123	ALTER TABLE "invitations" ADD
124	ALTER TABLE "members" ADD
125	ALTER TABLE "members" ADD
126	ALTER TABLE "sessions" ADD
127	ALTER TABLE "team_members" ADD
128	ALTER TABLE "team_members" ADD
129	ALTER TABLE "teams" ADD
130	CREATE INDEX "accounts_userId_idx" ON
131	CREATE INDEX "apikeys_configId_idx" ON
132	CREATE INDEX "apikeys_referenceId_idx" ON
133	CREATE INDEX "apikeys_key_idx" ON
134	CREATE INDEX "invitations_organizationId_idx" ON
135	CREATE INDEX "invitations_email_idx" ON
136	CREATE INDEX "members_organizationId_idx" ON
137	CREATE INDEX "members_userId_idx" ON
138	CREATE UNIQUE INDEX "organizations_slug_uidx" ON
139	CREATE INDEX "sessions_userId_idx" ON
140	CREATE INDEX "teamMembers_teamId_idx" ON
141	CREATE INDEX "teamMembers_userId_idx" ON
142	CREATE INDEX "teams_organizationId_idx" ON
143	CREATE INDEX "verifications_identifier_idx" ON