Queries PRAGMA foreign_keys = OFF PRAGMA synchronous = OFF DROP TABLE IF EXISTS {TableName} DROP TABLE IF EXISTS APDBAdInstance DROP TABLE IF EXISTS APDBAdSignalTrack PRAGMA foreign_keys = ON PRAGMA synchronous = NORMAL CREATE TABLE IF NOT EXISTS APDBAdInstance (impressionId TEXT PRIMARY KEY, campaign TEXT DEFAULT NULL, adGroup TEXT DEFAULT NULL, ad TEXT DEFAULT NULL, creative TEXT DEFAULT NULL, bundleId TEXT DEFAULT NULL, searchTermId TEXT DEFAULT NULL, adamId TEXT DEFAULT NULL, adType INTEGER DEFAULT NULL, adFormatType INTEGER DEFAULT NULL, containerType INTEGER DEFAULT NULL, relayData BLOB DEFAULT NULL, adMetadata TEXT DEFAULT NULL, propertiesJSON TEXT DEFAULT NULL, brand TEXT DEFAULT NULL, advertiserCategory TEXT DEFAULT NULL, accountToken TEXT NOT NULL) CREATE INDEX IF NOT EXISTS idx_adInstance_adamId ON APDBAdInstance (adamId) CREATE TABLE IF NOT EXISTS APDBEvent (impressionId TEXT NOT NULL, timestamp REAL NOT NULL, purpose INTEGER DEFAULT NULL, event INTEGER NOT NULL, source INTEGER DEFAULT NULL, unknownSource TEXT DEFAULT NULL, handleSet INTEGER DEFAULT NULL, eventOrder INTEGER DEFAULT NULL, trace TEXT DEFAULT NULL, branchString TEXT DEFAULT NULL, environmentString TEXT DEFAULT NULL, propertiesJSON TEXT DEFAULT NULL, internalPropertiesData BLOB DEFAULT NULL, FOREIGN KEY (impressionId) REFERENCES APDBAdInstance(impressionId) ON DELETE CASCADE) CREATE INDEX IF NOT EXISTS idx_event ON APDBEvent (impressionId, purpose, event, timestamp ASC) CREATE INDEX IF NOT EXISTS idx_event_timestamp ON APDBEvent (timestamp) CREATE TABLE IF NOT EXISTS APDBAdSignalTrack (rowid INTEGER PRIMARY KEY, triggerRowId INTEGER NOT NULL, impressionId 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 IF NOT EXISTS idx_AdSignalTrack_triggerRowId ON APDBAdSignalTrack (triggerRowId)