Blame · Line-by-line history

`0055_system_config.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.

0055_system_config.sqlBlame19 lines · 1 contributor

509c376Claude	1	-- /admin/integrations — DB-stored platform integration secrets.
	2	--
	3	-- Replaces the SSH-into-the-box workflow for runtime-changeable keys
	4	-- (ANTHROPIC_API_KEY, RESEND_API_KEY, GITHUB_TOKEN, etc.). The boot
	5	-- hook in src/index.ts loads every row into process.env BEFORE any
	6	-- module reads it, so existing synchronous `config.X` getters keep
	7	-- working unchanged.
	8	--
	9	-- Strictly additive: nothing else reads or writes this table.
	10
	11	CREATE TABLE IF NOT EXISTS system_config (
	12	key text PRIMARY KEY,
	13	value text NOT NULL DEFAULT '',
	14	updated_at timestamptz NOT NULL DEFAULT now(),
	15	updated_by_user_id uuid REFERENCES users(id) ON DELETE SET NULL
	16	);
	17
	18	CREATE INDEX IF NOT EXISTS idx_system_config_updated_at
	19	ON system_config (updated_at DESC);