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

11 lines
858 B
SQL

-- Product usage schema 2: the Mac an event came from (sha256(IOPlatformUUID)[:16], the value every Eddy request
-- already sends as X-Eddy-Machine), how it was derived, the Mac app build, closed props (enums, flags, bounded
-- numbers, version strings) and whether it was uploaded without a sign-in (owner NULL, budget per device).
-- Additive: schema 1 rows keep NULLs and anonymous = false.
ALTER TABLE eddy_usage_events ADD COLUMN IF NOT EXISTS device text;
ALTER TABLE eddy_usage_events ADD COLUMN IF NOT EXISTS device_source text;
ALTER TABLE eddy_usage_events ADD COLUMN IF NOT EXISTS app_version text;
ALTER TABLE eddy_usage_events ADD COLUMN IF NOT EXISTS props jsonb;
ALTER TABLE eddy_usage_events ADD COLUMN IF NOT EXISTS anonymous boolean NOT NULL DEFAULT false;
CREATE INDEX IF NOT EXISTS eddy_usage_device_at ON eddy_usage_events (device, at);