leaflet.pub
a tool for shared writing and social publishing
awarm.space
1create table "public"."email_auth_tokens" (
2 "id" uuid not null default gen_random_uuid(),
3 "created_at" timestamp with time zone not null default now(),
4 "confirmed" boolean not null default false,
5 "email" text not null,
6 "confirmation_code" text not null,
7 "identity" uuid
8);
9
10alter table "public"."email_auth_tokens" enable row level security;
11
12alter table "public"."identities" add column "email" text;
13
14CREATE UNIQUE INDEX email_auth_tokens_pkey ON public.email_auth_tokens USING btree (id);
15
16alter table "public"."email_auth_tokens" add constraint "email_auth_tokens_pkey" PRIMARY KEY using index "email_auth_tokens_pkey";
17
18alter table "public"."email_auth_tokens" add constraint "email_auth_tokens_identity_fkey" FOREIGN KEY (identity) REFERENCES identities(id) ON UPDATE CASCADE ON DELETE CASCADE not valid;
19
20alter table "public"."email_auth_tokens" validate constraint "email_auth_tokens_identity_fkey";
21
22grant delete on table "public"."email_auth_tokens" to "anon";
23
24grant insert on table "public"."email_auth_tokens" to "anon";
25
26grant references on table "public"."email_auth_tokens" to "anon";
27
28grant select on table "public"."email_auth_tokens" to "anon";
29
30grant trigger on table "public"."email_auth_tokens" to "anon";
31
32grant truncate on table "public"."email_auth_tokens" to "anon";
33
34grant update on table "public"."email_auth_tokens" to "anon";
35
36grant delete on table "public"."email_auth_tokens" to "authenticated";
37
38grant insert on table "public"."email_auth_tokens" to "authenticated";
39
40grant references on table "public"."email_auth_tokens" to "authenticated";
41
42grant select on table "public"."email_auth_tokens" to "authenticated";
43
44grant trigger on table "public"."email_auth_tokens" to "authenticated";
45
46grant truncate on table "public"."email_auth_tokens" to "authenticated";
47
48grant update on table "public"."email_auth_tokens" to "authenticated";
49
50grant delete on table "public"."email_auth_tokens" to "service_role";
51
52grant insert on table "public"."email_auth_tokens" to "service_role";
53
54grant references on table "public"."email_auth_tokens" to "service_role";
55
56grant select on table "public"."email_auth_tokens" to "service_role";
57
58grant trigger on table "public"."email_auth_tokens" to "service_role";
59
60grant truncate on table "public"."email_auth_tokens" to "service_role";
61
62grant update on table "public"."email_auth_tokens" to "service_role";