DROP INDEX "mcp_api_keys_hash_idx";--> statement-breakpoint
CREATE UNIQUE INDEX "mcp_api_keys_hash_uidx" ON "mcp_api_keys" USING btree ("key_hash");--> statement-breakpoint
CREATE UNIQUE INDEX "sites_gsc_property_uidx" ON "sites" USING btree ("gsc_property") WHERE "sites"."gsc_property" IS NOT NULL;--> statement-breakpoint
ALTER TABLE "domain_backlinks" ADD CONSTRAINT "domain_backlinks_authority_range" CHECK ("domain_backlinks"."authority" IS NULL OR "domain_backlinks"."authority" BETWEEN 0 AND 100);--> statement-breakpoint
ALTER TABLE "domain_ratings" ADD CONSTRAINT "domain_ratings_dr_range" CHECK ("domain_ratings"."dr" BETWEEN 0 AND 100);--> statement-breakpoint
ALTER TABLE "link_sources" ADD CONSTRAINT "link_sources_da_range" CHECK ("link_sources"."da" IS NULL OR "link_sources"."da" BETWEEN 0 AND 100);--> statement-breakpoint
ALTER TABLE "site_audits" ADD CONSTRAINT "site_audits_score_range" CHECK ("site_audits"."score" BETWEEN 0 AND 100);