ALTER TABLE "keywords" ADD CONSTRAINT "keywords_site_id_sites_id_fk" FOREIGN KEY ("site_id") REFERENCES "public"."sites"("id") ON DELETE cascade;--> statement-breakpoint
ALTER TABLE "content_items" DROP CONSTRAINT "content_items_primary_keyword_id_site_id_keywords_id_site_id_fk";--> statement-breakpoint
ALTER TABLE "content_items" ADD CONSTRAINT "content_items_primary_keyword_id_site_id_keywords_id_site_id_fk" FOREIGN KEY ("primary_keyword_id","site_id") REFERENCES "public"."keywords"("id","site_id") ON DELETE SET NULL ("primary_keyword_id");