Files
llmgw/internal/store/migrations/postgres/0047_preset_state.sql
Ilker ManapandClaude Opus 5.5 f42af27da5 The leader adds the picture and 3D presets a node fits, unless told not to
A customer's portal had no Images or 3D pages: nobody had written a
definition for either, on a cluster whose V100 runs both. The leading
control plane now adds flux-schnell and triposr, on demand, once a node
has a card that fits one, the cluster installs ComfyUI, and the catalog
makes nothing of that kind. presets.auto (a live setting, on by default)
turns it off; a preset somebody removes is recorded as declined and not
added back until added again by hand. Each addition is in the audit log.

GET /api/v1/presets says how each preset stands, the ComfyUI the cluster
installs, and why one is not added; POST /api/v1/presets/{name} adds one
(setting engines.comfyui where there is none); PUT /api/v1/presets/auto
switches it.

Co-Authored-By: Claude Opus 5.5 (1M context) <noreply@anthropic.com>
2026-10-13 20:48:40 +02:00

13 lines
532 B
SQL

-- Ported from the SQLite migration of the same number.
-- The models that come with llmgw, as they stand in this cluster: who added
-- one and when ("auto" for the leader), and whether somebody removed it
-- since, so that the leader does not add it back by itself.
CREATE TABLE preset_state (
name TEXT PRIMARY KEY,
added_by TEXT NOT NULL DEFAULT '',
added_at BIGINT NOT NULL DEFAULT 0,
declined BIGINT NOT NULL DEFAULT 0,
declined_by TEXT NOT NULL DEFAULT '',
declined_at BIGINT NOT NULL DEFAULT 0
);