SyncEngineDatabase Schema v19

OneDrive Versions

23.216.1017.0001

Changes

DROP TABLE odc_Convergence_ScopeInfo_Records; -- due to schema mismatch
CREATE TABLE odc_Convergence_ScopeInfo_Records ( scopeID TEXT PRIMARY KEY NOT NULL COLLATE NOCASE CHECK (length(scopeID) > 0), scopeType INTEGER NOT NULL , spoScopeID_deprecated TEXT DEFAULT "", spoScopeID TEXT COLLATE NOCASE DEFAULT "") WITHOUT ROWID;
DROP TABLE odc_convergence_items; -- due to schema mismatch
CREATE TABLE odc_convergence_items ( resourceID TEXT PRIMARY KEY NOT NULL COLLATE NOCASE, parentResourceID TEXT NOT NULL COLLATE NOCASE, volumeID INTEGER NOT NULL, itemIndex INTEGER NOT NULL, name TEXT NOT NULL COLLATE NOCASE, itemStatus INTEGER NOT NULL, isFolder INTEGER NOT NULL, size INTEGER, modifiedTime INTEGER NOT NULL, hashDigest BLOB, hashAlgorithm INTEGER, hashDescriptor INTEGER, receivedPostMigration INTEGER , etag TEXT, scopeID TEXT, scopeType INTEGER, spoResourceID_deprecated TEXT DEFAULT "", spoScopeID_deprecated TEXT DEFAULT "", spoParentResourceID_deprecated TEXT DEFAULT "", spoResourceID TEXT COLLATE NOCASE DEFAULT "", spoScopeID TEXT COLLATE NOCASE DEFAULT "", spoParentResourceID TEXT COLLATE NOCASE DEFAULT "") WITHOUT ROWID;

__oddbm_schema

Field	Type	Nullable	Key	Default	Index	Extra
name	TEXT	YES	PRI	NULL	X
value	INTEGER	YES	UNI	NULL	X

odc_convergence_items

Field	Type	Nullable	Key	Default	Index	Extra
resourceID	TEXT	NO	PRI		X
parentResourceID	TEXT	NO
volumeID	INTEGER	NO
itemIndex	INTEGER	NO
name	TEXT	NO
itemStatus	INTEGER	NO
isFolder	INTEGER	NO
size	INTEGER	YES		NULL
modifiedTime	INTEGER	NO
hashDigest	BLOB	YES		NULL
hashAlgorithm	INTEGER	YES		NULL
hashDescriptor	INTEGER	YES		NULL
receivedPostMigration	INTEGER	YES		NULL
etag	TEXT	YES		NULL
scopeID	TEXT	YES		NULL
scopeType	INTEGER	YES		NULL
spoResourceID_deprecated	TEXT	YES
spoScopeID_deprecated	TEXT	YES
spoParentResourceID_deprecated	TEXT	YES
spoResourceID	TEXT	YES
spoScopeID	TEXT	YES
spoParentResourceID	TEXT	YES

od_SelectiveSync_Records

Field	Type	Nullable	Key	Default	Index	Extra
resourceID	TEXT	NO	PRI		X
rootFolderID	TEXT	NO
syncState	INTEGER	NO
syncChildrenFiles	INTEGER	YES		NULL

od_ScopeInfo_Records

Field	Type	Nullable	Key	Default	Index	Extra
scopeID	TEXT	NO	PRI		X
flags	INTEGER	NO
scopeType	INTEGER	NO
resyncStatus	INTEGER	YES		NULL
resyncScheduled	INTEGER	YES		NULL
syncTokenData	BLOB	YES		NULL
selectiveSyncEnabled	INTEGER	YES		NULL
syncRootFiles	INTEGER	YES		NULL
sourceResourceID	TEXT	YES		NULL
cid	TEXT	YES		NULL
scopeSequentialID	INTEGER	YES		NULL
shortcutVolumeID	INTEGER	YES		NULL
shortcutItemIndex	INTEGER	YES		NULL
siteID	TEXT	YES		NULL
webID	TEXT	YES		NULL
listID	TEXT	YES		NULL
resyncFolderID	TEXT	YES		NULL
libraryType	INTEGER	YES		NULL
spoPermissions	INTEGER	YES		NULL
checkedOutState	INTEGER	YES		NULL
resyncRestrictions	INTEGER	YES		NULL
libraryIrmPolicyState	INTEGER	YES		NULL
webURL	TEXT	YES		NULL
tenantID	TEXT	YES		NULL
remotePath	TEXT	YES		NULL

od_ClientFile_Records

Field	Type	Nullable	Key	Default	Index	Extra
resourceID	TEXT	NO	PRI		X
parentResourceID	TEXT	NO
eTag	TEXT	NO
fileName	TEXT	NO
resyncState	INTEGER	YES		NULL
volumeID	INTEGER	YES		NULL
itemIndex	INTEGER	YES		NULL
lastChange	INTEGER	YES		NULL
size	INTEGER	YES		NULL
fileStatus	INTEGER	YES		NULL
spoPermissions	INTEGER	YES		NULL
checkedOutState	INTEGER	YES		NULL
serverSize	INTEGER	YES		NULL
serverLastChange	INTEGER	YES		NULL
mediaDateTaken	INTEGER	YES		NULL
mediaWidth	INTEGER	YES		NULL
mediaHeight	INTEGER	YES		NULL
mediaDuration	INTEGER	YES		NULL
holdStateBegin	INTEGER	YES		NULL
holdStateReason	INTEGER	YES		NULL
holdStateResolution	INTEGER	YES		NULL
locallyDeleted	INTEGER	YES		NULL
isOneNoteShortcut	INTEGER	YES		NULL
reuploadNeeded	INTEGER	YES		NULL
matchesMissingVersion	INTEGER	YES		NULL
serverFileIsNewerThanLocalFile	INTEGER	YES		NULL
serverDeleted	INTEGER	YES		NULL
irmEncrypted	INTEGER	YES		NULL
irmDecryptableByClient	INTEGER	YES		NULL
irmDecryptableByServer	INTEGER	YES		NULL
coAuthOcsi	INTEGER	YES		NULL
ocsiModified	INTEGER	YES		NULL
lastModifiedViaOcsi	INTEGER	YES		NULL
lastMovedViaOcsi	INTEGER	YES		NULL
needsContentCheck	INTEGER	YES		NULL
linkifiedShortcut	INTEGER	YES		NULL
webBasedFile	INTEGER	YES		NULL
mediaFileMetadataUpToDate	INTEGER	YES		NULL
cfAlwaysFullFlagAttempted	INTEGER	YES		NULL
oneNoteFixupRequired	INTEGER	YES		NULL
sharedItem	INTEGER	YES		NULL
subScope	INTEGER	YES		NULL
localHashDigest	BLOB	YES		NULL
localHashAlgorithm	INTEGER	YES		NULL
localHashDescriptor	INTEGER	YES		NULL
serverHashDigest	BLOB	YES		NULL
serverHashAlgorithm	INTEGER	YES		NULL
serverHashDescriptor	INTEGER	YES		NULL
irmEnabled	INTEGER	YES		NULL
irmPolicyState	INTEGER	YES		NULL
irmEncryptedFileSize	INTEGER	YES		NULL
irmHashDigest	BLOB	YES		NULL
irmHashAlgorithm	INTEGER	YES		NULL
irmHashDescriptor	INTEGER	YES		NULL
localWriteValidationToken	BLOB	YES		NULL
localWaterlineData	BLOB	YES		NULL
localCobaltHashDigest	BLOB	YES		NULL
localCobaltHashAlgorithm	INTEGER	YES		NULL
localCobaltHashDescriptor	INTEGER	YES		NULL
serverWriteValidationToken	BLOB	YES		NULL
serverWaterlineData	BLOB	YES		NULL
serverCobaltHashDigest	BLOB	YES		NULL
serverCobaltHashAlgorithm	INTEGER	YES		NULL
serverCobaltHashDescriptor	INTEGER	YES		NULL
localCLPIsMipDecrypted	INTEGER	YES		NULL
localCLPLabelHashScope	INTEGER	YES		NULL
localCLPHashDigest	BLOB	YES		NULL
localCLPHashAlgorithm	INTEGER	YES		NULL
localCLPHashDescriptor	INTEGER	YES		NULL
serverCLPIsMipDecrypted	INTEGER	YES		NULL
serverCLPLabelHashScope	INTEGER	YES		NULL
serverCLPHashDigest	BLOB	YES		NULL
serverCLPHashAlgorithm	INTEGER	YES		NULL
serverCLPHashDescriptor	INTEGER	YES		NULL
localProtocolSupport	INTEGER	YES		NULL
localSyncTokenData	BLOB	YES		NULL
serverProtocolSupport	INTEGER	YES		NULL
serverSyncTokenData	BLOB	YES		NULL
cloudVisibleOnly	INTEGER	YES		NULL
LinkifiedODCShortcut	INTEGER	YES		NULL
LinkifiedSPOShortcut	INTEGER	YES		NULL

od_UnrealizedFile_Records

Field	Type	Nullable	Key	Default	Index	Extra
resourceID	TEXT	NO	PRI		X
size	INTEGER	YES		NULL
modTime	INTEGER	YES		NULL
filePath	TEXT	NO
ocsiModified	INTEGER	YES		NULL
irmEnabled	INTEGER	YES		NULL
irmPolicyState	INTEGER	YES		NULL
irmEncryptedFileSize	INTEGER	YES		NULL
irmHashDigest	BLOB	YES		NULL
irmHashAlgorithm	INTEGER	YES		NULL
irmHashDescriptor	INTEGER	YES		NULL
cmWriteValidationToken	BLOB	YES		NULL
cmWaterlineData	BLOB	YES		NULL
cmHashDigest	BLOB	YES		NULL
cmHashAlgorithm	INTEGER	YES		NULL
cmHashDescriptor	INTEGER	YES		NULL
clpIsMipDecrypted	INTEGER	YES		NULL
clpLabelHashScope	INTEGER	YES		NULL
clpHashDigest	BLOB	YES		NULL
clpHashAlgorithm	INTEGER	YES		NULL
clpHashDescriptor	INTEGER	YES		NULL
cmProtocolSupport	INTEGER	YES		NULL
cmSyncTokenData	BLOB	YES		NULL

od_ClientFolder_Records

Field	Type	Nullable	Key	Default	Index	Extra
resourceID	TEXT	NO	PRI		X
parentResourceID	TEXT	NO
parentScopeID	TEXT	NO
eTag	TEXT	NO
folderName	TEXT	NO
resyncState	INTEGER	YES		NULL
volumeID	INTEGER	YES		NULL
itemIndex	INTEGER	YES		NULL
folderStatus	INTEGER	YES		NULL
syncChildrenFiles	INTEGER	YES		NULL
locallyDeleted	INTEGER	YES		NULL
serverDeleted	INTEGER	YES		NULL
jumpLinkType	INTEGER	YES		NULL
spoPermissions	INTEGER	YES		NULL
checkedOutState	INTEGER	YES		NULL
oneNoteDetectionPending	INTEGER	YES		NULL
sharedItem	INTEGER	YES		NULL
subScope	INTEGER	YES		NULL
teamsChannelFolder	INTEGER	YES		NULL
cloudVisibleOnly	INTEGER	YES		NULL

od_ClientFilePostponedChange_Records

Field	Type	Nullable	Key	Default	Index	Extra
persistenceID	INTEGER	NO	PRI		X
sequenceID	INTEGER	NO			X
resourceID	TEXT	NO
parentResourceID	TEXT	NO
parentScopeID	TEXT	NO
eTag	TEXT	NO
changeType	INTEGER	YES		NULL
postponedCount	INTEGER	YES		NULL
flags	INTEGER	YES		NULL
fileName	TEXT	YES		NULL
sourceResourceID	TEXT	YES		NULL
lastChange	INTEGER	YES		NULL
size	INTEGER	YES		NULL
isLocalChange	INTEGER	YES		NULL
isOneNote	INTEGER	YES		NULL
reuploadNeeded	INTEGER	YES		NULL
createStubFile	INTEGER	YES		NULL
itemSharingStatus	INTEGER	YES		NULL
timeAdded	INTEGER	YES		NULL
spoPermissions	INTEGER	YES		NULL
checkedOutState	INTEGER	YES		NULL
irmEnabled	INTEGER	YES		NULL
irmPolicyState	INTEGER	YES		NULL
mediaDateTaken	INTEGER	YES		NULL
mediaWidth	INTEGER	YES		NULL
mediaHeight	INTEGER	YES		NULL
mediaDuration	INTEGER	YES		NULL
hashDigest	BLOB	YES		NULL
hashAlgorithm	INTEGER	YES		NULL
hashDescriptor	INTEGER	YES		NULL
writeValidationToken	BLOB	YES		NULL
waterlineData	BLOB	YES		NULL
cobaltHashDigest	BLOB	YES		NULL
cobaltHashAlgorithm	INTEGER	YES		NULL
cobaltHashDescriptor	INTEGER	YES		NULL
clpIsMipDecrypted	INTEGER	YES		NULL
clpLabelHashScope	INTEGER	YES		NULL
clpHashDigest	BLOB	YES		NULL
clpHashAlgorithm	INTEGER	YES		NULL
clpHashDescriptor	INTEGER	YES		NULL
protocolSupport	INTEGER	YES		NULL
syncTokenData	BLOB	YES		NULL

od_ClientFolderPostponedChange_Records

Field	Type	Nullable	Key	Default	Index	Extra
persistenceId	INTEGER	NO	PRI		X
sequenceID	INTEGER	NO			X
resourceID	TEXT	NO
parentResourceID	TEXT	NO
parentScopeID	TEXT	NO
eTag	TEXT	NO
changeType	INTEGER	YES		NULL
postponedCount	INTEGER	YES		NULL
flags	INTEGER	YES		NULL
folderName	TEXT	YES		NULL
sourceResourceID	TEXT	YES		NULL
subScopeOwnerResourceID	TEXT	YES		NULL
itemSharingStatus	INTEGER	YES		NULL
isLocalChange	INTEGER	YES		NULL
jumpLinkType	INTEGER	YES		NULL
spoPermissions	INTEGER	YES		NULL
checkedOutState	INTEGER	YES		NULL

od_MigrateItemPostponedChange_Records

Field	Type	Nullable	Key	Default	Index	Extra
persistenceID	INTEGER	NO	PRI		X
sequenceID	INTEGER	NO			X
resourceID	TEXT	NO
parentResourceID	TEXT	NO
parentScopeID	TEXT	NO
eTag	TEXT	NO
changeType	INTEGER	YES		NULL
postponedCount	INTEGER	YES		NULL
flags	INTEGER	YES		NULL
itemName	TEXT	YES		NULL
itemSharingStatus	INTEGER	YES		NULL
isDelete	INTEGER	YES		NULL
spoPermissions	INTEGER	YES		NULL
checkedOutState	INTEGER	YES		NULL
jumpLinkType	INTEGER	YES		NULL
lastChange	INTEGER	YES		NULL
size	INTEGER	YES		NULL
mediaDateTaken	INTEGER	YES		NULL
mediaWidth	INTEGER	YES		NULL
mediaHeight	INTEGER	YES		NULL
mediaDuration	INTEGER	YES		NULL
hashDigest	BLOB	YES		NULL
hashAlgorithm	INTEGER	YES		NULL
hashDescriptor	INTEGER	YES		NULL
serverSha1HashDigest	BLOB	YES		NULL
writeValidationToken	BLOB	YES		NULL
waterlineData	BLOB	YES		NULL
cobaltHashDigest	BLOB	YES		NULL
cobaltHashAlgorithm	INTEGER	YES		NULL
cobaltHashDescriptor	INTEGER	YES		NULL
protocolSupport	INTEGER	YES		NULL
syncTokenData	BLOB	YES		NULL

od_GraphMetadata_Records

Field	Type	Nullable	Key	Default	Index	Extra
resourceID	TEXT	NO	PRI		X
graphMetadataJSON	TEXT	NO
spoCompositeID	TEXT	NO
createdBy	TEXT	NO
modifiedBy	TEXT	NO
filePolicies	TEXT	YES		NULL
fileExtension	TEXT	YES		NULL	X
lastWriteCount	INTEGER	NO		0 NOT NULL	X

od_GraphMetadata_LastWrite

Field	Type	Nullable	Key	Default	Index	Extra
name	TEXT	YES	PRI	NULL	X
value	INTEGER	YES		NULL
lastWriteTableId	TEXT	NO

odc_Convergence_ScopeInfo_Records

Field	Type	Nullable	Key	Default	Index	Extra
scopeID	TEXT	NO	PRI		X
scopeType	INTEGER	NO
spoScopeID_deprecated	TEXT	YES
spoScopeID	TEXT	YES