Queries DROP TABLE IF EXISTS TimeSpent CREATE TABLE IF NOT EXISTS AggregatedTimeSpent (lineIdentifier, durationInSeconds, eventTimestamp, clientIdentifier) CREATE UNIQUE INDEX IF NOT EXISTS idx_identifier_timestamp ON AggregatedTimeSpent (lineIdentifier, eventTimestamp, clientIdentifier) CREATE INDEX IF NOT EXISTS idx_timestamp ON AggregatedTimeSpent (eventTimestamp)