flaxo/ghost

public

Source code of Ghost - On Ghost

it now supports push and pull50ad2a1a month ago133 lines · 6.3 KB

1	CREATE TABLE "account" (
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 "invitation" (
18	"id" text PRIMARY KEY
19	"organization_id" text NOT NULL
20	"email" text NOT NULL
21	"role" text,
22	"team_id" text,
23	"status" text DEFAULT
24	"expires_at" timestamp NOT NULL
25	"created_at" timestamp DEFAULT
26	"inviter_id" text NOT NULL
27	);
28	--> statement-breakpoint
29	CREATE TABLE "member" (
30	"id" text PRIMARY KEY
31	"organization_id" text NOT NULL
32	"user_id" text NOT NULL
33	"role" text DEFAULT
34	"created_at" timestamp NOT NULL
35	);
36	--> statement-breakpoint
37	CREATE TABLE "organization" (
38	"id" text PRIMARY KEY
39	"name" text NOT NULL
40	"slug" text NOT NULL
41	"logo" text,
42	"created_at" timestamp NOT NULL
43	"metadata" text,
44	CONSTRAINT "organization_slug_unique" UNIQUE
45	);
46	--> statement-breakpoint
47	CREATE TABLE "organization_role" (
48	"id" text PRIMARY KEY
49	"organization_id" text NOT NULL
50	"role" text NOT NULL
51	"permission" text NOT NULL
52	"created_at" timestamp DEFAULT
53	"updated_at" timestamp
54	);
55	--> statement-breakpoint
56	CREATE TABLE "session" (
57	"id" text PRIMARY KEY
58	"expires_at" timestamp NOT NULL
59	"token" text NOT NULL
60	"created_at" timestamp DEFAULT
61	"updated_at" timestamp NOT NULL
62	"ip_address" text,
63	"user_agent" text,
64	"user_id" text NOT NULL
65	"active_organization_id" text,
66	"active_team_id" text,
67	CONSTRAINT "session_token_unique" UNIQUE
68	);
69	--> statement-breakpoint
70	CREATE TABLE "team" (
71	"id" text PRIMARY KEY
72	"name" text NOT NULL
73	"member_count" integer DEFAULT
74	"organization_id" text NOT NULL
75	"created_at" timestamp NOT NULL
76	"updated_at" timestamp
77	);
78	--> statement-breakpoint
79	CREATE TABLE "team_member" (
80	"id" text PRIMARY KEY
81	"team_id" text NOT NULL
82	"user_id" text NOT NULL
83	"membership_key" text,
84	"created_at" timestamp,
85	CONSTRAINT "team_member_membership_key_unique" UNIQUE
86	);
87	--> statement-breakpoint
88	CREATE TABLE "user" (
89	"id" text PRIMARY KEY
90	"name" text NOT NULL
91	"email" text NOT NULL
92	"email_verified" boolean DEFAULT
93	"image" text,
94	"created_at" timestamp DEFAULT
95	"updated_at" timestamp DEFAULT
96	"username" text,
97	"display_username" text,
98	CONSTRAINT "user_email_unique" UNIQUE
99	CONSTRAINT "user_username_unique" UNIQUE
100	);
101	--> statement-breakpoint
102	CREATE TABLE "verification" (
103	"id" text PRIMARY KEY
104	"identifier" text NOT NULL
105	"value" text NOT NULL
106	"expires_at" timestamp NOT NULL
107	"created_at" timestamp DEFAULT
108	"updated_at" timestamp DEFAULT
109	);
110	--> statement-breakpoint
111	ALTER TABLE "account" ADD
112	ALTER TABLE "invitation" ADD
113	ALTER TABLE "invitation" ADD
114	ALTER TABLE "member" ADD
115	ALTER TABLE "member" ADD
116	ALTER TABLE "organization_role" ADD
117	ALTER TABLE "session" ADD
118	ALTER TABLE "team" ADD
119	ALTER TABLE "team_member" ADD
120	ALTER TABLE "team_member" ADD
121	CREATE INDEX "account_userId_idx" ON
122	CREATE INDEX "invitation_organizationId_idx" ON
123	CREATE INDEX "invitation_email_idx" ON
124	CREATE INDEX "member_organizationId_idx" ON
125	CREATE INDEX "member_userId_idx" ON
126	CREATE UNIQUE INDEX "organization_slug_uidx" ON
127	CREATE INDEX "organizationRole_organizationId_idx" ON
128	CREATE INDEX "organizationRole_role_idx" ON
129	CREATE INDEX "session_userId_idx" ON
130	CREATE INDEX "team_organizationId_idx" ON
131	CREATE INDEX "teamMember_teamId_idx" ON
132	CREATE INDEX "teamMember_userId_idx" ON
133	CREATE INDEX "verification_identifier_idx" ON