Queries CREATE TABLE APDBReportEventCount (rowid INTEGER PRIMARY KEY, dayOfYear INTEGER NOT NULL, purpose INTEGER NOT NULL, event INTEGER NOT NULL, value TEXT NOT NULL, count INTEGER NOT NULL, environment TEXT NOT NULL, lastCountDate REAL NOT NULL) CREATE INDEX idx_eventCount_1 ON APDBReportEventCount (dayOfYear, purpose) CREATE INDEX idx_eventCount_2 ON APDBReportEventCount (dayOfYear, purpose, event) CREATE UNIQUE INDEX idx_eventCount_3 ON APDBReportEventCount (dayOfYear, purpose, event, value, environment) CREATE TABLE APDBEventBranch (eventId INTEGER NOT NULL, branch TEXT NOT NULL, FOREIGN KEY (eventId) REFERENCES APDBReportEventCount(rowid) ON DELETE CASCADE) CREATE UNIQUE INDEX idx_eventBranch ON APDBEventBranch (eventId, branch) CREATE TABLE APDBDeliveredReport (type TEXT NOT NULL, dayOfYear INTEGER NOT NULL, frequency INTEGER NOT NULL, reportDate REAL NOT NULL) CREATE INDEX idx_deliveredReport_type ON APDBDeliveredReport (type) CREATE TABLE ObservabilitySignalsStore (timestamp REAL NOT NULL, signal INTEGER NOT NULL, report INTEGER NOT NULL, param1, param2, param3) CREATE INDEX idx_timestamp_signal_report ON ObservabilitySignalsStore (timestamp, report) CREATE TABLE ObservabilityStateStore (key PRIMARY KEY, value) CREATE INDEX idx_key ON ObservabilityStateStore (key)