CREATE TABLE "credential_authorities" (
	"connection_id" text PRIMARY KEY NOT NULL,
	"credential_reference_id" text NOT NULL,
	"owner_id" text NOT NULL,
	"pending_owner_id" text,
	"generation" integer NOT NULL,
	"status" text NOT NULL,
	"revision" integer DEFAULT 1 NOT NULL,
	"created_at" timestamp with time zone DEFAULT now() NOT NULL
);
--> statement-breakpoint
ALTER TABLE "attempts" ADD COLUMN "selection_provenance" jsonb NOT NULL;--> statement-breakpoint
ALTER TABLE "attempts" ADD COLUMN "provider_reference" jsonb;--> statement-breakpoint
ALTER TABLE "change_sets" ADD COLUMN "candidate_manifest" jsonb NOT NULL;