max / balanced_breakfast

438 B · 15 lines History Blame Raw

1	-- Feature: Busser state
2	-- Create busser_state table for key-value state storage
3	CREATE TABLE IF NOT EXISTS busser_state (
4	id TEXT PRIMARY KEY,
5	busser_id TEXT NOT NULL,
6	key TEXT NOT NULL,
7	value TEXT NOT NULL,
8	created_at TEXT NOT NULL DEFAULT (datetime('now')),
9	updated_at TEXT NOT NULL DEFAULT (datetime('now')),
10
11	UNIQUE(busser_id, key)
12	);
13
14	CREATE INDEX idx_busser_state_busser_id ON busser_state(busser_id);
15