0025_platform_settings.sql13 lines · main

1	-- 0025_platform_settings — dashboard-controllable platform flags.
2	-- Single key/value JSONB store an admin can flip without a container
3	-- restart. Today the only key is `openSignups`; the table is sized for
4	-- a handful of flags total.
5
6	CREATE TABLE IF NOT EXISTS "platform_settings" (
7	"key" text PRIMARY KEY NOT NULL,
8	"value" jsonb NOT NULL,
9	"updated_at" timestamp with time zone DEFAULT now() NOT NULL,
10	"updated_by" text,
11	CONSTRAINT "platform_settings_updated_by_fk"
12	FOREIGN KEY ("updated_by") REFERENCES "users"("id") ON DELETE SET NULL
13	);