CREATE TABLE "backlink_outreach" (
	"backlink_id" text PRIMARY KEY NOT NULL,
	"contact" text,
	"channel" text,
	"attempts" integer DEFAULT 0 NOT NULL,
	"last_contact_at" timestamp with time zone,
	"notes" text,
	"updated_at" timestamp with time zone DEFAULT now() NOT NULL
);
--> statement-breakpoint
ALTER TABLE "backlinks" ADD COLUMN "toxic" boolean DEFAULT false NOT NULL;--> statement-breakpoint
ALTER TABLE "backlinks" ADD COLUMN "disavow" boolean DEFAULT false NOT NULL;--> statement-breakpoint
ALTER TABLE "backlink_outreach" ADD CONSTRAINT "backlink_outreach_backlink_id_backlinks_id_fk" FOREIGN KEY ("backlink_id") REFERENCES "public"."backlinks"("id") ON DELETE cascade ON UPDATE no action;