Shane MaynardandClaude Fable 5
e62b9601a2
Test and deploy / test-and-deploy (push) Successful in 59s
- user_gear table (migration 008) + GET/PUT /api/gear (brewer keys validated against the taxonomy, grinders deduped/trimmed) - /gear page: silhouette multi-select for owned brewers (autosaves) and a grinder list; nav gains Brewing → Equipment - Brews page: with gear configured, the picker shows only owned brewers (plus the edited brew's method) with a show-all toggle; grinder field suggests your grinders; empty-gear state links to /gear - Included in full backups, per-user export, and the OpenAPI spec Co-Authored-By: Claude Fable 5 <[email protected]>
9 lines
394 B
SQL
9 lines
394 B
SQL
-- Additive only. Per-user owned equipment: which brewers the Brews page should offer
|
|
-- (subset of the shared brew-method keys) and the user's grinders (free-text names).
|
|
CREATE TABLE user_gear (
|
|
user_id uuid PRIMARY KEY REFERENCES users(id) ON DELETE CASCADE,
|
|
brewers jsonb NOT NULL DEFAULT '[]',
|
|
grinders jsonb NOT NULL DEFAULT '[]',
|
|
updated_at timestamptz NOT NULL DEFAULT now()
|
|
);
|