Dropping root privileges to mobile (501)
[1mEntities Schema:[0m 44

CREATE TABLE integrityCheck (inconsequential STRING)
CREATE TABLE entity (id INTEGER PRIMARY KEY AUTOINCREMENT,entityKey TEXT NOT NULL,entityType INTEGER NOT NULL,author TEXT,content TEXT,contentRangeOfInterest TEXT,title TEXT COLLATE NOCASE,timeRangeStart REAL,timeRangeEnd REAL,floatingRange INTEGER,timeRangeStartUTCOffsetSeconds INTEGER,timeRangeEndUTCOffsetSeconds INTEGER,creationTimestamp REAL,updateTimestamp REAL,indexTimestamp REAL,lastSeenTimestamp REAL,tags TEXT,structuredData BLOB,quality REAL,locations BLOB,masterEntityId INTEGER DEFAULT -1,groupId INTEGER DEFAULT -1,state INTEGER DEFAULT 0,contentHash TEXT,downloadState INTEGER DEFAULT 0, contentHashBlob BLOB, pendingGeocode BOOLEAN DEFAULT false, harvestedOnBuild TEXT)
CREATE VIRTUAL TABLE entity_fts USING fts4(tokenize=ab_cf_tokenizer language="nl-NL" collator="nl_NL@collation=search", id INTEGER PRIMARY KEY AUTOINCREMENT, entityId INTEGER, messagingTerms TEXT COLLATE NOCASE, ftsTerms TEXT COLLATE NOCASE)
CREATE TABLE 'entity_fts_content'(docid INTEGER PRIMARY KEY, 'c0id', 'c1entityId', 'c2messagingTerms', 'c3ftsTerms')
CREATE TABLE 'entity_fts_segments'(blockid INTEGER PRIMARY KEY, block BLOB)
CREATE TABLE 'entity_fts_segdir'(level INTEGER,idx INTEGER,start_block INTEGER,leaves_end_block INTEGER,end_block INTEGER,root BLOB,PRIMARY KEY(level, idx))
CREATE TABLE 'entity_fts_docsize'(docid INTEGER PRIMARY KEY, size BLOB)
CREATE TABLE 'entity_fts_stat'(id INTEGER PRIMARY KEY, value BLOB)
CREATE TABLE entityTags (tag TEXT,entityKey TEXT,entityType INTEGER,parentKey TEXT,duplicateKeyHash TEXT NOT NULL, duplicateKeyHashBlob BLOB)
CREATE TABLE confirmedFieldValues (entityId INTEGER PRIMARY KEY,fieldValues BLOB,maybeChanged BOOLEAN)
CREATE TABLE entityParentage (id INTEGER PRIMARY KEY AUTOINCREMENT,parentKey TEXT,childId INTEGER NOT NULL,duplicateKeyHash TEXT NOT NULL,extractionType INTEGER,sourceKey TEXT, duplicateKeyHashBlob BLOB,UNIQUE(parentKey, childId))
CREATE TABLE serializedContacts (id INTEGER PRIMARY KEY AUTOINCREMENT,entityId INTEGER,data BLOB)
CREATE TABLE identityPerson (    identityPersonId INTEGER PRIMARY KEY AUTOINCREMENT,    middlename VARCHAR(256),    surname VARCHAR(256),    fullname TEXT,    nameSketches TEXT NOT NULL,    phones TEXT NOT NULL,    email TEXT NOT NULL,    recordId INTEGER NOT NULL,    curated BOOLEAN NOT NULL)
CREATE TABLE identityLink (    recordId1 INTEGER NOT NULL,    recordId2 INTEGER NOT NULL,    type INT NOT NULL,    strength REAL NOT NULL,    PRIMARY KEY (recordId1, recordId2, type))
CREATE TABLE identityInterdict (a TEXT NOT NULL, b TEXT NOT NULL)
CREATE TABLE entityReferences (id INTEGER PRIMARY KEY AUTOINCREMENT,bundleIdentifier TEXT,uniqueIdentifier TEXT,entityId INTEGER,domainIdentifier TEXT)
CREATE TABLE cnContactsToSgContacts (id INTEGER PRIMARY KEY AUTOINCREMENT,cnContactIdentifier TEXT,maxEntityId INTEGER,entityId INTEGER)
CREATE TABLE cnContactsToSgContactsCacheJobs (id INTEGER PRIMARY KEY AUTOINCREMENT,batch TEXT)
CREATE TABLE harvestQueueTombstones (bundleIdentifier TEXT,uniqueIdentifier TEXT,domainIdentifier TEXT)
CREATE TABLE identityPhones (    recordId INTEGER NOT NULL,    phone TEXT NOT NULL)
CREATE TABLE statsCounters (key TEXT NOT NULL,value REAL NOT NULL)
CREATE TABLE serializedContactCacheJobs (id INTEGER PRIMARY KEY AUTOINCREMENT)
CREATE TABLE metadata (key TEXT NOT NULL, value)
CREATE TABLE messageTracer (domain TEXT NOT NULL,key TEXT NOT NULL,value INTEGER NOT NULL)
CREATE TABLE identityBlobAnalysisJobs (id INTEGER PRIMARY KEY AUTOINCREMENT,mergeBlob BLOB)
CREATE TABLE identityInterdictNext (a TEXT NOT NULL, b TEXT NOT NULL)
CREATE UNIQUE INDEX entityIdIdx on entity(id)
CREATE INDEX entityMasterEntityIdIdx on entity(masterEntityId)
CREATE INDEX entityStateIdx on entity(state)
CREATE INDEX ix_entityTags_tag ON entityTags(tag)
CREATE INDEX ix_entityTags_dupKey ON entityTags(entityKey, entityType, parentKey)
CREATE INDEX entityParentageChildIdx on entityParentage(childId)
CREATE UNIQUE INDEX serializedContactsEntityIdIdx ON serializedC
Completed in 40.3ms
ontacts(entityId)
CREATE INDEX ix_identityPerson_surname ON identityPerson(surname)
CREATE INDEX ix_identityPerson_middlename ON identityPerson(middlename)
CREATE INDEX ix_identityPerson_email_nameless ON identityPerson(email)
CREATE UNIQUE INDEX ix_identityPerson_recordId ON identityPerson(recordId)
CREATE INDEX ix_identityLink_recordId2 ON identityLink(recordId2)
CREATE UNIQUE INDEX entityReferencesUniqueIdx ON entityReferences(bundleIdentifier, uniqueIdentifier)
CREATE INDEX entityReferencesDomainIdx ON entityReferences(bundleIdentifier, domainIdentifier)
CREATE INDEX entityReferencesEntityIdIdx ON entityReferences(entityId)
CREATE INDEX entityDownloadStateIdx on entity(downloadState)
CREATE INDEX groupIdIdx on entity(groupId)
CREATE INDEX cnContactsToSgContactsEntityIdx ON cnContactsToSgContacts(entityId)
CREATE UNIQUE INDEX cnContactsToSgContactsUniqueJoin ON cnContactsToSgContacts(cnContactIdentifier, entityId)
CREATE INDEX ix_identityPhones_recordId ON identityPhones(recordId)
CREATE INDEX ix_identityPhones_phone ON identityPhones(phone)
CREATE UNIQUE INDEX ix_statsCounters_key ON statsCounters(key)
CREATE INDEX entityDupKeyIdx ON entity(entityKey, entityType)
CREATE INDEX entityTypeIdx ON entity(entityType)
CREATE UNIQUE INDEX ix_identityPhones_unique ON identityPhones(recordId, phone)
CREATE INDEX entityParentageParentKeyChildIdIdx on entityParentage(parentKey, childId)
CREATE UNIQUE INDEX ix_harvestQueueTombstones_unique ON harvestQueueTombstones(bundleIdentifier, uniqueIdentifier, domainIdentifier)
CREATE UNIQUE INDEX entityContentHashBlobIdx ON entity(contentHashBlob)
CREATE UNIQUE INDEX entityParentageDuplicateKeyHashBlobIdx on entityParentage(duplicateKeyHashBlob, extractionType)
CREATE INDEX ix_entityTags_dupKeyHashBlob ON entityTags(duplicateKeyHashBlob)
CREATE UNIQUE INDEX metadataKeyIndex ON metadata(key)
CREATE UNIQUE INDEX messageTracerIdx ON messageTracer(domain, key)
CREATE INDEX ix_entityTags_parentKey ON entityTags(parentKey)
CREATE INDEX entityPendingGeocodeIdx ON entity(pendingGeocode) WHERE pendingGeocode=1
[1m

Snippets Schema:[0m 44

CREATE TABLE snippets (id INTEGER PRIMARY KEY AUTOINCREMENT,entityId INTEGER,title TEXT,content TEXT,contentRangeOfInterest TEXT)
CREATE UNIQUE INDEX entityIdIdx ON snippets(entityId)
