Queries DROP TABLE IF EXISTS APDBAdSignalTrack DROP TABLE IF EXISTS APDBTriggerSignal DROP TABLE IF EXISTS APDBExperimentationReport CREATE TABLE IF NOT EXISTS APDBAdSignalTrack (rowid INTEGER PRIMARY KEY, triggerRowId INTEGER NOT NULL, handle TEXT NOT NULL, source INTEGER DEFAULT NULL, adFormatType INTEGER DEFAULT NULL, slot INTEGER DEFAULT NULL, opportunity INTEGER DEFAULT 0, impression INTEGER DEFAULT 0, click INTEGER DEFAULT 0, conversion INTEGER DEFAULT 0, updateTimestamp REAL NOT NULL, FOREIGN KEY (triggerRowId) REFERENCES APDBTrigger(rowid)) CREATE INDEX idx_AdSignalTrack_triggerRowId ON APDBAdSignalTrack (triggerRowId) CREATE TABLE IF NOT EXISTS APDBExperimentationReport (rowid INTEGER PRIMARY KEY, triggerRowId INTERGER NOT NULL, source INTEGER NOT NULL, adFormatType INTEGER NOT NULL, slot INTEGER DEFAULT NULL, day INTEGER NOT NULL, opportunityCount INTEGER DEFAULT 0, impressionCount INTEGER DEFAULT 0, clickCount INTEGER DEFAULT 0, conversionCount INTEGER DEFAULT 0, FOREIGN KEY (triggerRowId) REFERENCES APDBTrigger(rowid) ON DELETE CASCADE) CREATE INDEX idx_ExperimentationReport_AdFormat_day ON APDBExperimentationReport (triggerRowId, source, adFormatType, day) WHERE slot IS NULL CREATE INDEX idx_ExperimentationReport_AdFormat_day_slot ON APDBExperimentationReport (triggerRowId, source, adFormatType, day, slot) WHERE slot IS NOT NULL CREATE INDEX idx_ExperimentationReport_day_source ON APDBExperimentationReport (day, source)