leaflet.pub
a tool for shared writing and social publishing
awarm.space
1create table "public"."bsky_follows" (
2 "identity" text not null,
3 "follows" text not null
4);
5
6alter table "public"."bsky_follows" enable row level security;
7
8CREATE UNIQUE INDEX bsky_follows_pkey ON public.bsky_follows USING btree (identity, follows);
9
10CREATE INDEX facts_reference_idx ON public.facts USING btree (((data ->> 'value'::text))) WHERE (((data ->> 'type'::text) = 'reference'::text) OR ((data ->> 'type'::text) = 'ordered-reference'::text));
11
12alter table "public"."bsky_follows" add constraint "bsky_follows_pkey" PRIMARY KEY using index "bsky_follows_pkey";
13
14alter table "public"."bsky_follows" add constraint "bsky_follows_follows_fkey" FOREIGN KEY (follows) REFERENCES identities(atp_did) ON DELETE CASCADE not valid;
15
16alter table "public"."bsky_follows" validate constraint "bsky_follows_follows_fkey";
17
18alter table "public"."bsky_follows" add constraint "bsky_follows_identity_fkey" FOREIGN KEY (identity) REFERENCES identities(atp_did) ON DELETE CASCADE not valid;
19
20alter table "public"."bsky_follows" validate constraint "bsky_follows_identity_fkey";
21
22grant delete on table "public"."bsky_follows" to "anon";
23
24grant insert on table "public"."bsky_follows" to "anon";
25
26grant references on table "public"."bsky_follows" to "anon";
27
28grant select on table "public"."bsky_follows" to "anon";
29
30grant trigger on table "public"."bsky_follows" to "anon";
31
32grant truncate on table "public"."bsky_follows" to "anon";
33
34grant update on table "public"."bsky_follows" to "anon";
35
36grant delete on table "public"."bsky_follows" to "authenticated";
37
38grant insert on table "public"."bsky_follows" to "authenticated";
39
40grant references on table "public"."bsky_follows" to "authenticated";
41
42grant select on table "public"."bsky_follows" to "authenticated";
43
44grant trigger on table "public"."bsky_follows" to "authenticated";
45
46grant truncate on table "public"."bsky_follows" to "authenticated";
47
48grant update on table "public"."bsky_follows" to "authenticated";
49
50grant delete on table "public"."bsky_follows" to "service_role";
51
52grant insert on table "public"."bsky_follows" to "service_role";
53
54grant references on table "public"."bsky_follows" to "service_role";
55
56grant select on table "public"."bsky_follows" to "service_role";
57
58grant trigger on table "public"."bsky_follows" to "service_role";
59
60grant truncate on table "public"."bsky_follows" to "service_role";
61
62grant update on table "public"."bsky_follows" to "service_role";