leaflet.pub / leaflet
a tool for shared writing and social publishing
fork atom
leaflet / supabase / migrations / 20250522033859_update_leaflets_in_pubs_on_doc_delete.sql
at feature/footnotes 3 lines 379 B view raw
awarm.space add migration to set leaflets_in_publications.doc to null on delete
4d2ade95
1alter table "public"."leaflets_in_publications" drop constraint "leaflets_in_publications_doc_fkey"; 2alter table "public"."leaflets_in_publications" add constraint "leaflets_in_publications_doc_fkey" FOREIGN KEY (doc) REFERENCES documents(uri) ON DELETE SET NULL not valid; 3alter table "public"."leaflets_in_publications" validate constraint "leaflets_in_publications_doc_fkey";