8 lines
490 B
SQL
8 lines
490 B
SQL
-- Allow lease delete/update without being blocked by messages.
|
|
-- Run if you still see: violates foreign key constraint "messages_lease_id_leases_id_fk"
|
|
-- Usage: psql "<your connection string>" -f scripts/fix-messages-lease-fk.sql
|
|
|
|
ALTER TABLE "messages" DROP CONSTRAINT IF EXISTS "messages_lease_id_leases_id_fk";
|
|
ALTER TABLE "messages" ADD CONSTRAINT "messages_lease_id_leases_id_fk"
|
|
FOREIGN KEY ("lease_id") REFERENCES "public"."leases"("id") ON DELETE SET NULL ON UPDATE NO ACTION;
|