10 lines
589 B
SQL
10 lines
589 B
SQL
CREATE TABLE IF NOT EXISTS eddy_usage_events (
|
|
id text PRIMARY KEY, at bigint NOT NULL, received_at bigint NOT NULL,
|
|
installation text NOT NULL, name text NOT NULL, action text NOT NULL,
|
|
source text NOT NULL, release text NOT NULL, macos_major text NOT NULL,
|
|
outcome text, duration_ms bigint, queue_ms bigint, session text, operation text
|
|
);
|
|
CREATE INDEX IF NOT EXISTS eddy_usage_at ON eddy_usage_events (at);
|
|
CREATE INDEX IF NOT EXISTS eddy_usage_release_at ON eddy_usage_events (release, at);
|
|
CREATE INDEX IF NOT EXISTS eddy_usage_received_at ON eddy_usage_events (received_at);
|