Files
streamline/drizzle/0068_eddy_usage_owner.sql
2026-11-16 17:26:44 -08:00

5 lines
338 B
SQL

-- Product usage per account: the uploader's SSO email (lower case) on each new event, for the
-- administrator per-user view. Earlier events carry only budget_owner (sha256 of that email).
ALTER TABLE eddy_usage_events ADD COLUMN IF NOT EXISTS owner text;
CREATE INDEX IF NOT EXISTS eddy_usage_owner_at ON eddy_usage_events (owner, at);