SyncEngineDatabase Schema v20

OneDrive Versions

23.221.1024.0002 -> 23.246.1127.0002

Changes

CREATE INDEX itemIndex_volumeID_clientFile_Index ON od_ClientFile_Records (itemIndex, volumeID);
CREATE INDEX itemIndex_volumeID_clientFolder_Index ON od_ClientFolder_Records (itemIndex, volumeID);

__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 X
itemIndex INTEGER YES NULL X
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 X
itemIndex INTEGER YES NULL X
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

No comments:

Post a Comment

Subscribe to: Posts (Atom)