ajamesphillips.com / leaflet
forked from leaflet.pub/leaflet
a tool for shared writing and social publishing
0
fork

Configure Feed

Select the types of activity you want to include in your feed.

leaflet / supabase / migrations / 20250610025321_add_cascades_to_leaflets_in_publications.sql
at update/delete-leaflets 13 lines 902 B view raw
awarm.space add migration
e8a53ca0
1alter table "public"."publication_subscriptions" alter column "uri" set not null; 2 3alter table "public"."leaflets_in_publications" drop constraint "leaflets_in_publications_leaflet_fkey"; 4 5alter table "public"."leaflets_in_publications" drop constraint "leaflets_in_publications_publication_fkey"; 6 7alter table "public"."leaflets_in_publications" add constraint "leaflets_in_publications_leaflet_fkey" FOREIGN KEY (leaflet) REFERENCES permission_tokens(id) ON DELETE CASCADE not valid; 8 9alter table "public"."leaflets_in_publications" validate constraint "leaflets_in_publications_leaflet_fkey"; 10 11alter table "public"."leaflets_in_publications" add constraint "leaflets_in_publications_publication_fkey" FOREIGN KEY (publication) REFERENCES publications(uri) ON DELETE CASCADE not valid; 12 13alter table "public"."leaflets_in_publications" validate constraint "leaflets_in_publications_publication_fkey";