Blame · Line-by-line history

`0075_org_secrets.sql`

Each line is annotated with the commit that last touched it. Click any SHA to jump to that commit and see the surrounding change.

0075_org_secrets.sqlBlame14 lines · 1 contributor

05ab9b1Claude	1	-- Org-level secrets: apply to all repos in an org (or a selected subset)
	2	CREATE TABLE "org_secrets" (
	3	"id" UUID PRIMARY KEY DEFAULT gen_random_uuid(),
	4	"org_id" UUID NOT NULL REFERENCES "organizations"("id") ON DELETE CASCADE,
	5	"name" TEXT NOT NULL,
	6	"encrypted_value" TEXT NOT NULL,
	7	"iv" TEXT NOT NULL,
	8	"key_hint" TEXT, -- last 4 chars of plaintext for display
	9	"created_by" UUID REFERENCES "users"("id") ON DELETE SET NULL,
	10	"created_at" TIMESTAMPTZ NOT NULL DEFAULT now(),
	11	"updated_at" TIMESTAMPTZ NOT NULL DEFAULT now(),
	12	CONSTRAINT "org_secrets_org_name_uq" UNIQUE ("org_id", "name")
	13	);
	14	CREATE INDEX "org_secrets_org_idx" ON "org_secrets"("org_id");