CREATE INDEX "analytics_jobs_site_idx" ON "analytics_jobs" USING btree ("site_id");--> statement-breakpoint
CREATE INDEX "backlinks_site_idx" ON "backlinks" USING btree ("site_id");--> statement-breakpoint
CREATE INDEX "content_items_site_idx" ON "content_items" USING btree ("site_id");--> statement-breakpoint
CREATE INDEX "content_items_primary_kw_idx" ON "content_items" USING btree ("primary_keyword_id");--> statement-breakpoint
CREATE INDEX "content_keywords_keyword_idx" ON "content_keywords" USING btree ("keyword_id");--> statement-breakpoint
CREATE INDEX "keyword_shortlist_keyword_idx" ON "keyword_shortlist" USING btree ("keyword_id");--> statement-breakpoint
CREATE INDEX "keywords_site_idx" ON "keywords" USING btree ("site_id");--> statement-breakpoint
CREATE INDEX "link_sources_global_idx" ON "link_sources" USING btree ("id") WHERE "global";