leaflet.pub
a tool for shared writing and social publishing
awarm.space
1create table "public"."publication_domains" (
2 "publication" text not null,
3 "domain" text not null,
4 "created_at" timestamp with time zone not null default now()
5);
6alter table "public"."publication_domains" enable row level security;
7CREATE UNIQUE INDEX publication_domains_pkey ON public.publication_domains USING btree (publication, domain);
8alter table "public"."publication_domains" add constraint "publication_domains_pkey" PRIMARY KEY using index "publication_domains_pkey";
9alter table "public"."publication_domains" add constraint "publication_domains_domain_fkey" FOREIGN KEY (domain) REFERENCES custom_domains(domain) ON DELETE CASCADE not valid;
10alter table "public"."publication_domains" validate constraint "publication_domains_domain_fkey";
11alter table "public"."publication_domains" add constraint "publication_domains_publication_fkey" FOREIGN KEY (publication) REFERENCES publications(uri) ON DELETE CASCADE not valid;
12alter table "public"."publication_domains" validate constraint "publication_domains_publication_fkey";
13grant delete on table "public"."publication_domains" to "anon";
14grant insert on table "public"."publication_domains" to "anon";
15grant references on table "public"."publication_domains" to "anon";
16grant select on table "public"."publication_domains" to "anon";
17grant trigger on table "public"."publication_domains" to "anon";
18grant truncate on table "public"."publication_domains" to "anon";
19grant update on table "public"."publication_domains" to "anon";
20grant delete on table "public"."publication_domains" to "authenticated";
21grant insert on table "public"."publication_domains" to "authenticated";
22grant references on table "public"."publication_domains" to "authenticated";
23grant select on table "public"."publication_domains" to "authenticated";
24grant trigger on table "public"."publication_domains" to "authenticated";
25grant truncate on table "public"."publication_domains" to "authenticated";
26grant update on table "public"."publication_domains" to "authenticated";
27grant delete on table "public"."publication_domains" to "service_role";
28grant insert on table "public"."publication_domains" to "service_role";
29grant references on table "public"."publication_domains" to "service_role";
30grant select on table "public"."publication_domains" to "service_role";
31grant trigger on table "public"."publication_domains" to "service_role";
32grant truncate on table "public"."publication_domains" to "service_role";
33grant update on table "public"."publication_domains" to "service_role";