Queries PRAGMA foreign_keys = OFF PRAGMA synchronous = OFF DROP TABLE IF EXISTS {TableName} PRAGMA foreign_keys = ON PRAGMA synchronous = NORMAL DELETE FROM APDBAdInstance DELETE FROM OdcaAttribution ALTER TABLE APDBAdInstance ADD COLUMN accountToken TEXT NOT NULL ALTER TABLE OdcaAttribution ADD COLUMN accountToken TEXT NOT NULL DROP INDEX IF EXISTS idx_adInstance_adamId CREATE INDEX idx_adInstance_handle_accountToken ON APDBAdInstance (handle, accountToken) CREATE INDEX idx_adInstance_adamId_accountToken ON APDBAdInstance (adamId, accountToken) CREATE INDEX idx_adInstance_accountToken ON APDBAdInstance (accountToken)