SyncEngineDatabase Schema v43

OneDrive Versions

26.064.0406.0001

Changes

CREATE TABLE od_ClientPolicy_Records ( siteID TEXT NOT NULL COLLATE NOCASE, webID TEXT NOT NULL COLLATE NOCASE, listID TEXT NOT NULL COLLATE NOCASE, schemaVersion INTEGER DEFAULT 1, etag TEXT COLLATE NOCASE, lastRefresh INTEGER, lastUpdate INTEGER, lastHash TEXT COLLATE NOCASE, davUrlMatch TEXT COLLATE NOCASE, davUrlTemplate TEXT COLLATE NOCASE, davUrlNamespace TEXT COLLATE NOCASE, davUrlNoCaretTemplate TEXT COLLATE NOCASE, davUrlNoCaretNamespace TEXT COLLATE NOCASE, downloadUrlTemplate TEXT COLLATE NOCASE, shareUrlTemplate TEXT COLLATE NOCASE, shareUrlTemplateV2 TEXT COLLATE NOCASE, wacUrlTemplate TEXT COLLATE NOCASE, viewOnlineUrlTemplate TEXT COLLATE NOCASE, ocdiDavUrlTemplate TEXT COLLATE NOCASE, ocdiDavUrlNamespace TEXT COLLATE NOCASE, ocdiDavUrlMatches TEXT COLLATE NOCASE, policyDocumentPollIntervalSeconds INTEGER, backoffOnErrorsIntervalSeconds INTEGER, policyDocumentPrefetchIntervalSeconds INTEGER, backgroundPollShortIntervalSeconds INTEGER, backgroundPollLongIntervalSeconds INTEGER, documentBackgroundPollIntervalSeconds INTEGER, syncVerificationInterval INTEGER, syncProgressInterval INTEGER, uploadBlockSizeKB INTEGER, downloadBlockSizeKB INTEGER, maxInlineUploadSizeKB INTEGER, encryptionBlockSizeKB INTEGER, maxFileSizeBytes INTEGER, tier1MaxFileSizeBytes INTEGER, cloudSizeLimitForFullSyncInKB INTEGER, uploadBatchMaxDocumentCount INTEGER, uploadBatchMaxFileCommitCount INTEGER, tier1FileInclusionList TEXT COLLATE NOCASE, filenameExclusionList TEXT COLLATE NOCASE, coauthSupportedFileExtensionsList TEXT COLLATE NOCASE, highVisibilityFileExclusionList TEXT COLLATE NOCASE, irmSupportedFileExtensions TEXT COLLATE NOCASE, officeExcludeList TEXT COLLATE NOCASE, highFrequencyBackoffExtensions TEXT COLLATE NOCASE, mediumFrequencyBackoffExtensions TEXT COLLATE NOCASE, lowFrequencyBackoffExtensions TEXT COLLATE NOCASE, coauthMinimumProtocolVersionsV5 TEXT COLLATE NOCASE, coauthAppNameMap TEXT COLLATE NOCASE, coauthIntervalToPostponeLocalChange INTEGER, coauthMaxNumberOfClients INTEGER, coauthWaitTimeOutSeconds INTEGER, skyApiURL TEXT COLLATE NOCASE, rootFolderName TEXT COLLATE NOCASE, skyDriveURI TEXT COLLATE NOCASE, skyDriveItemsURI TEXT COLLATE NOCASE, skyDriveItemsByPathURI TEXT COLLATE NOCASE, skyDriveItemsByPathURIForSubscopes TEXT COLLATE NOCASE, collabVectorClockURI TEXT COLLATE NOCASE, skyDriveFarmUri TEXT COLLATE NOCASE, skyDriveItemsFarmUri TEXT COLLATE NOCASE, skyDriveFarmDirectUri TEXT COLLATE NOCASE, skyDriveItemsFarmDirectUri TEXT COLLATE NOCASE, storageManagementURI TEXT COLLATE NOCASE, recycleBinURI TEXT COLLATE NOCASE, getSignatureUri TEXT COLLATE NOCASE, syncVerificationEnabled INTEGER, isCloudSizeCheckNeededForFullSync INTEGER, fullSyncMaxItemCount INTEGER, incrementalSyncMaxItemCount INTEGER, incrementalSyncMaxItemCountUpperBound INTEGER, syncVerificationMaxItemCount INTEGER, syncVerificationPageSize INTEGER, telemetryId TEXT COLLATE NOCASE, syncTelemetryURL TEXT COLLATE NOCASE, qosCollectionEnabled INTEGER, telemetryItemAlreadyExistsErrorCallbackFrequency INTEGER, telemetryItemAlreadyExistsMinReportingThreshold INTEGER, telemetryItemAlreadyExistsMaxReportingThreshold INTEGER, telemetryDefaultMaxErrorEvents INTEGER, telemetryDefaultErrorCallbackFrequency INTEGER, telemetryDefaultMinReportingThreshold INTEGER, telemetryDefaultMaxReportingThreshold INTEGER, loggingMaxLogFileSizeMB INTEGER, maxLogFilesToKeep INTEGER, logUploadUri TEXT COLLATE NOCASE, logUploadV2Uri TEXT COLLATE NOCASE, maxLogUploadRetries INTEGER, loggingMinTimeBetweenLogUploadsInSeconds INTEGER, logUploadTimeboundDurationDays INTEGER, logUploadRetryTimeSeconds INTEGER, logUploadV2BatchMinSize INTEGER, logUploadV2BatchMaxSize INTEGER, logUploadV2MinSecondsBetweenBatches INTEGER, logUploadV2MaxSecondsBetweenBatches INTEGER, logUploadV2MaxLogsInQueue INTEGER, officeProgID TEXT COLLATE NOCASE, officeRegKey TEXT COLLATE NOCASE, office15MinVersion TEXT COLLATE NOCASE, office16MinVersion TEXT COLLATE NOCASE, irmLibraryId TEXT COLLATE NOCASE, blockSharedFolderSync INTEGER, hashAlgorithm TEXT COLLATE NOCASE, grooveCVR INTEGER, zipItEnabled INTEGER, opcEnabled INTEGER, aipIntegrationEnabled INTEGER, caretEncodingDisabled INTEGER, disableReportProblemDialog INTEGER, maxUploadKBPerSecond INTEGER, maxDownloadKBPerSecond INTEGER, bandwidthAutoManagedRateCheckDuration INTEGER, bandwidthAutoManagedRateCheckInterval INTEGER, bandwidthAutoManagedThrottlePercentage INTEGER, maxClientMBTransferredPerDay INTEGER, maxClientRequestsPerDay INTEGER, numberOfConcurrentStorageRequests INTEGER, deltaDownloadBlockSizeKB INTEGER, deltaUploadBlockSizeKB INTEGER, minSupportDeltaFileSizeKB INTEGER, maxSupportDeltaFileSizeKB INTEGER, maxInlineDeltaUploadSizeKB INTEGER, deltaMaxUnitOfWorkKB INTEGER, deltaMaxUploadBatchFileSizeKB INTEGER, deltaMaxDownloadRangesPerRequest INTEGER, deltaAlgo TEXT COLLATE NOCASE, deltaTypeFilterMax TEXT COLLATE NOCASE, deltaTypeFixedChunk4MBSha1 TEXT COLLATE NOCASE, deltaTypeFixedChunk3MBSha1 TEXT COLLATE NOCASE, deltaTypeZip TEXT COLLATE NOCASE, deltaExtensionAntler TEXT COLLATE NOCASE, deltaExtensionOffice TEXT COLLATE NOCASE, periodicRetryIntervalSeconds INTEGER, periodicRetryMaxIntervalSeconds INTEGER, deferredDownloadRetrySeconds INTEGER, maxHttpRetriesBeforeUnmounting INTEGER, selfHealingBackOffPeriodInSeconds INTEGER, pathChangeSubscriptionScenarioName TEXT COLLATE NOCASE, clientNotificationCoalesceSeconds INTEGER, massDeleteMinFolderCount INTEGER, massDeleteMinFileCount INTEGER, massDeleteMinTotalFilesSizeKB INTEGER, localMassDeleteFileDeleteThreshold INTEGER, downloadStreamingMaxStreamSizeKB INTEGER, uploadStreamingMaxStreamSizeKB INTEGER, syncProgressAuditMaxFilesToShow INTEGER, currentMinimumOneDriveSupportedVersion TEXT COLLATE NOCASE, futureMinimumOneDriveSupportedVersion TEXT COLLATE NOCASE, futureMinimumOneDriveSupportedVersionTimestamp INTEGER, createPersonalVault INTEGER, revisedVaultQuota INTEGER, itemCount INTEGER, autoMountDelayMaxIntervalMinutes INTEGER, rootFarmUrl TEXT COLLATE NOCASE, rootFarmExpressUrl TEXT COLLATE NOCASE, rootTenantUrl TEXT COLLATE NOCASE, scopeBaseUrl TEXT COLLATE NOCASE, downloadForegroundUrl TEXT COLLATE NOCASE, downloadBackgroundUrl TEXT COLLATE NOCASE, inlineUploadForegroundUrl TEXT COLLATE NOCASE, inlineUploadBackgroundUrl TEXT COLLATE NOCASE, streamedUploadForegroundUrl TEXT COLLATE NOCASE, streamedUploadBackgroundUrl TEXT COLLATE NOCASE, downloadUrlFarmTemplate TEXT COLLATE NOCASE, graphDriveId TEXT COLLATE NOCASE, allowWnsSubscriptions INTEGER, wnsAuthAppId TEXT COLLATE NOCASE, wnsAuthAppIdUri TEXT COLLATE NOCASE, wnsEndpoint TEXT COLLATE NOCASE, webPushAppServerPublicKey TEXT COLLATE NOCASE, moiFootprintMetadataCollection TEXT COLLATE NOCASE, moiFootprintOptIn INTEGER, moiFootprintFlightId TEXT COLLATE NOCASE, moiFootprintHeavyTests TEXT COLLATE NOCASE, moiFootprintHeavyTestFrequency INTEGER, moiFootprintLightTestFrequency INTEGER, rampGroup TEXT COLLATE NOCASE, hasSharePointCopilotLicense INTEGER, preferEventualConsistencyReadOnly INTEGER, postponedChangesUIThreshold INTEGER, minNumOfForksBeforeReportInfiniteForkTelemetry INTEGER, maxIntervalSinceLastPotentialForkInSeconds INTEGER, winboxFALMinIntegrationVersion TEXT COLLATE NOCASE, maxUrlLength INTEGER, autoResumeTimersInHours TEXT COLLATE NOCASE, oneRMPollingIntervalHours INTEGER, speedTestMaximumDuration INTEGER, speedTestInterval INTEGER, speedTestRetryInterval INTEGER, speedTestTerminationVariancePercent INTEGER, speedTestMaximumNumberOfThreads INTEGER, speedTestEnablePercentage INTEGER, siteTitle TEXT COLLATE NOCASE, libraryTitle TEXT COLLATE NOCASE, macFALMinIntegrationVersion TEXT COLLATE NOCASE, macFALMinIntegrationVersionProd TEXT COLLATE NOCASE, PRIMARY KEY (siteID, webID, listID) ) 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			X
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
lastResyncVersion	INTEGER	YES		NULL
lastProcessedChange	TEXT	YES		NULL
lastKnownFolderPath	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
CoAuthClockData	TEXT	YES		NULL
diskLastAccessTime	INTEGER	YES		NULL
diskCreationTime	INTEGER	YES		NULL
lastKnownPinState	INTEGER	YES		NULL
archiveState	INTEGER	YES		NULL
fixedCidForA2odConsumer	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
CoAuthClockData	TEXT	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
folderColor	INTEGER	YES		NULL
localFolderColor	INTEGER	YES		NULL
fixedCidForA2odConsumer	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
shouldHardDelete	INTEGER	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
folderColor	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
forkedItemAtPathOnce	BOOLEAN	YES		0

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

od_HydrationData

Field	Type	Nullable	Key	Default	Index	Extra
resourceID	TEXT	NO	PRI		X
firstHydrationTime	INTEGER	NO
lastHydrationTime	INTEGER	YES		NULL
hydrationCount	INTEGER	YES		1
lastHydrationType	TEXT	NO		Active

od_CreateAddedFolderFailures

Field	Type	Nullable	Key	Default	Index	Extra
siteID	TEXT	NO
listID	TEXT	NO
folderID	TEXT	NO
lastSuccessfulSync	INTEGER	NO
reason	INTEGER	YES		NULL
lastFailedAttempt	INTEGER	YES		NULL
PRIMARY	KEY	YES		NULL
listID		YES		NULL
folderID)		YES		NULL

od_ArchiveData_Records

Field	Type	Nullable	Key	Default	Index	Extra
resourceID	TEXT	NO	PRI		X
fileName	TEXT	YES		NULL
lastReportedAccessTime	INTEGER	NO
lastReportingTime	INTEGER	YES		NULL

od_ThrottleHistory

Field	Type	Nullable	Key	Default	Index	Extra
startTime	INTEGER	YES	PRI	NULL	X
duration	INTEGER	YES		NULL
scenario	INTEGER	YES		NULL
reason	TEXT	YES		NULL
isKFM	INTEGER	YES		NULL
isOnBackoffList	INTEGER	YES		NULL

od_ServiceOperationHistory

Field	Type	Nullable	Key	Default	Index	Extra
id	INTEGER	YES	PRI	NULL	X	AUTOINCREMENT
timestamp	INTEGER	NO
scopeId	TEXT	NO
operationName	TEXT	NO
resultCode	INTEGER	NO
sizeInBytes	REAL	YES		NULL
scenarioName	TEXT	YES		NULL

od_IgnoredItem_Records

Field	Type	Nullable	Key	Default	Index	Extra
itemIndex	INTEGER	NO
volumeID	INTEGER	NO
PRIMARY	KEY(itemIndex	YES		NULL
volumeID)		YES		NULL

od_ClientPolicy_Records

Field	Type	Nullable	Key	Default	Index	Extra
siteID	TEXT	NO
webID	TEXT	NO
listID	TEXT	NO
schemaVersion	INTEGER	YES		1
etag	TEXT	YES		NULL
lastRefresh	INTEGER	YES		NULL
lastUpdate	INTEGER	YES		NULL
lastHash	TEXT	YES		NULL
davUrlMatch	TEXT	YES		NULL
davUrlTemplate	TEXT	YES		NULL
davUrlNamespace	TEXT	YES		NULL
davUrlNoCaretTemplate	TEXT	YES		NULL
davUrlNoCaretNamespace	TEXT	YES		NULL
downloadUrlTemplate	TEXT	YES		NULL
shareUrlTemplate	TEXT	YES		NULL
shareUrlTemplateV2	TEXT	YES		NULL
wacUrlTemplate	TEXT	YES		NULL
viewOnlineUrlTemplate	TEXT	YES		NULL
ocdiDavUrlTemplate	TEXT	YES		NULL
ocdiDavUrlNamespace	TEXT	YES		NULL
ocdiDavUrlMatches	TEXT	YES		NULL
policyDocumentPollIntervalSeconds	INTEGER	YES		NULL
backoffOnErrorsIntervalSeconds	INTEGER	YES		NULL
policyDocumentPrefetchIntervalSeconds	INTEGER	YES		NULL
backgroundPollShortIntervalSeconds	INTEGER	YES		NULL
backgroundPollLongIntervalSeconds	INTEGER	YES		NULL
documentBackgroundPollIntervalSeconds	INTEGER	YES		NULL
syncVerificationInterval	INTEGER	YES		NULL
syncProgressInterval	INTEGER	YES		NULL
uploadBlockSizeKB	INTEGER	YES		NULL
downloadBlockSizeKB	INTEGER	YES		NULL
maxInlineUploadSizeKB	INTEGER	YES		NULL
encryptionBlockSizeKB	INTEGER	YES		NULL
maxFileSizeBytes	INTEGER	YES		NULL
tier1MaxFileSizeBytes	INTEGER	YES		NULL
cloudSizeLimitForFullSyncInKB	INTEGER	YES		NULL
uploadBatchMaxDocumentCount	INTEGER	YES		NULL
uploadBatchMaxFileCommitCount	INTEGER	YES		NULL
tier1FileInclusionList	TEXT	YES		NULL
filenameExclusionList	TEXT	YES		NULL
coauthSupportedFileExtensionsList	TEXT	YES		NULL
highVisibilityFileExclusionList	TEXT	YES		NULL
irmSupportedFileExtensions	TEXT	YES		NULL
officeExcludeList	TEXT	YES		NULL
highFrequencyBackoffExtensions	TEXT	YES		NULL
mediumFrequencyBackoffExtensions	TEXT	YES		NULL
lowFrequencyBackoffExtensions	TEXT	YES		NULL
coauthMinimumProtocolVersionsV5	TEXT	YES		NULL
coauthAppNameMap	TEXT	YES		NULL
coauthIntervalToPostponeLocalChange	INTEGER	YES		NULL
coauthMaxNumberOfClients	INTEGER	YES		NULL
coauthWaitTimeOutSeconds	INTEGER	YES		NULL
skyApiURL	TEXT	YES		NULL
rootFolderName	TEXT	YES		NULL
skyDriveURI	TEXT	YES		NULL
skyDriveItemsURI	TEXT	YES		NULL
skyDriveItemsByPathURI	TEXT	YES		NULL
skyDriveItemsByPathURIForSubscopes	TEXT	YES		NULL
collabVectorClockURI	TEXT	YES		NULL
skyDriveFarmUri	TEXT	YES		NULL
skyDriveItemsFarmUri	TEXT	YES		NULL
skyDriveFarmDirectUri	TEXT	YES		NULL
skyDriveItemsFarmDirectUri	TEXT	YES		NULL
storageManagementURI	TEXT	YES		NULL
recycleBinURI	TEXT	YES		NULL
getSignatureUri	TEXT	YES		NULL
syncVerificationEnabled	INTEGER	YES		NULL
isCloudSizeCheckNeededForFullSync	INTEGER	YES		NULL
fullSyncMaxItemCount	INTEGER	YES		NULL
incrementalSyncMaxItemCount	INTEGER	YES		NULL
incrementalSyncMaxItemCountUpperBound	INTEGER	YES		NULL
syncVerificationMaxItemCount	INTEGER	YES		NULL
syncVerificationPageSize	INTEGER	YES		NULL
telemetryId	TEXT	YES		NULL
syncTelemetryURL	TEXT	YES		NULL
qosCollectionEnabled	INTEGER	YES		NULL
telemetryItemAlreadyExistsErrorCallbackFrequency	INTEGER	YES		NULL
telemetryItemAlreadyExistsMinReportingThreshold	INTEGER	YES		NULL
telemetryItemAlreadyExistsMaxReportingThreshold	INTEGER	YES		NULL
telemetryDefaultMaxErrorEvents	INTEGER	YES		NULL
telemetryDefaultErrorCallbackFrequency	INTEGER	YES		NULL
telemetryDefaultMinReportingThreshold	INTEGER	YES		NULL
telemetryDefaultMaxReportingThreshold	INTEGER	YES		NULL
loggingMaxLogFileSizeMB	INTEGER	YES		NULL
maxLogFilesToKeep	INTEGER	YES		NULL
logUploadUri	TEXT	YES		NULL
logUploadV2Uri	TEXT	YES		NULL
maxLogUploadRetries	INTEGER	YES		NULL
loggingMinTimeBetweenLogUploadsInSeconds	INTEGER	YES		NULL
logUploadTimeboundDurationDays	INTEGER	YES		NULL
logUploadRetryTimeSeconds	INTEGER	YES		NULL
logUploadV2BatchMinSize	INTEGER	YES		NULL
logUploadV2BatchMaxSize	INTEGER	YES		NULL
logUploadV2MinSecondsBetweenBatches	INTEGER	YES		NULL
logUploadV2MaxSecondsBetweenBatches	INTEGER	YES		NULL
logUploadV2MaxLogsInQueue	INTEGER	YES		NULL
officeProgID	TEXT	YES		NULL
officeRegKey	TEXT	YES		NULL
office15MinVersion	TEXT	YES		NULL
office16MinVersion	TEXT	YES		NULL
irmLibraryId	TEXT	YES		NULL
blockSharedFolderSync	INTEGER	YES		NULL
hashAlgorithm	TEXT	YES		NULL
grooveCVR	INTEGER	YES		NULL
zipItEnabled	INTEGER	YES		NULL
opcEnabled	INTEGER	YES		NULL
aipIntegrationEnabled	INTEGER	YES		NULL
caretEncodingDisabled	INTEGER	YES		NULL
disableReportProblemDialog	INTEGER	YES		NULL
maxUploadKBPerSecond	INTEGER	YES		NULL
maxDownloadKBPerSecond	INTEGER	YES		NULL
bandwidthAutoManagedRateCheckDuration	INTEGER	YES		NULL
bandwidthAutoManagedRateCheckInterval	INTEGER	YES		NULL
bandwidthAutoManagedThrottlePercentage	INTEGER	YES		NULL
maxClientMBTransferredPerDay	INTEGER	YES		NULL
maxClientRequestsPerDay	INTEGER	YES		NULL
numberOfConcurrentStorageRequests	INTEGER	YES		NULL
deltaDownloadBlockSizeKB	INTEGER	YES		NULL
deltaUploadBlockSizeKB	INTEGER	YES		NULL
minSupportDeltaFileSizeKB	INTEGER	YES		NULL
maxSupportDeltaFileSizeKB	INTEGER	YES		NULL
maxInlineDeltaUploadSizeKB	INTEGER	YES		NULL
deltaMaxUnitOfWorkKB	INTEGER	YES		NULL
deltaMaxUploadBatchFileSizeKB	INTEGER	YES		NULL
deltaMaxDownloadRangesPerRequest	INTEGER	YES		NULL
deltaAlgo	TEXT	YES		NULL
deltaTypeFilterMax	TEXT	YES		NULL
deltaTypeFixedChunk4MBSha1	TEXT	YES		NULL
deltaTypeFixedChunk3MBSha1	TEXT	YES		NULL
deltaTypeZip	TEXT	YES		NULL
deltaExtensionAntler	TEXT	YES		NULL
deltaExtensionOffice	TEXT	YES		NULL
periodicRetryIntervalSeconds	INTEGER	YES		NULL
periodicRetryMaxIntervalSeconds	INTEGER	YES		NULL
deferredDownloadRetrySeconds	INTEGER	YES		NULL
maxHttpRetriesBeforeUnmounting	INTEGER	YES		NULL
selfHealingBackOffPeriodInSeconds	INTEGER	YES		NULL
pathChangeSubscriptionScenarioName	TEXT	YES		NULL
clientNotificationCoalesceSeconds	INTEGER	YES		NULL
massDeleteMinFolderCount	INTEGER	YES		NULL
massDeleteMinFileCount	INTEGER	YES		NULL
massDeleteMinTotalFilesSizeKB	INTEGER	YES		NULL
localMassDeleteFileDeleteThreshold	INTEGER	YES		NULL
downloadStreamingMaxStreamSizeKB	INTEGER	YES		NULL
uploadStreamingMaxStreamSizeKB	INTEGER	YES		NULL
syncProgressAuditMaxFilesToShow	INTEGER	YES		NULL
currentMinimumOneDriveSupportedVersion	TEXT	YES		NULL
futureMinimumOneDriveSupportedVersion	TEXT	YES		NULL
futureMinimumOneDriveSupportedVersionTimestamp	INTEGER	YES		NULL
createPersonalVault	INTEGER	YES		NULL
revisedVaultQuota	INTEGER	YES		NULL
itemCount	INTEGER	YES		NULL
autoMountDelayMaxIntervalMinutes	INTEGER	YES		NULL
rootFarmUrl	TEXT	YES		NULL
rootFarmExpressUrl	TEXT	YES		NULL
rootTenantUrl	TEXT	YES		NULL
scopeBaseUrl	TEXT	YES		NULL
downloadForegroundUrl	TEXT	YES		NULL
downloadBackgroundUrl	TEXT	YES		NULL
inlineUploadForegroundUrl	TEXT	YES		NULL
inlineUploadBackgroundUrl	TEXT	YES		NULL
streamedUploadForegroundUrl	TEXT	YES		NULL
streamedUploadBackgroundUrl	TEXT	YES		NULL
downloadUrlFarmTemplate	TEXT	YES		NULL
graphDriveId	TEXT	YES		NULL
allowWnsSubscriptions	INTEGER	YES		NULL
wnsAuthAppId	TEXT	YES		NULL
wnsAuthAppIdUri	TEXT	YES		NULL
wnsEndpoint	TEXT	YES		NULL
webPushAppServerPublicKey	TEXT	YES		NULL
moiFootprintMetadataCollection	TEXT	YES		NULL
moiFootprintOptIn	INTEGER	YES		NULL
moiFootprintFlightId	TEXT	YES		NULL
moiFootprintHeavyTests	TEXT	YES		NULL
moiFootprintHeavyTestFrequency	INTEGER	YES		NULL
moiFootprintLightTestFrequency	INTEGER	YES		NULL
rampGroup	TEXT	YES		NULL
hasSharePointCopilotLicense	INTEGER	YES		NULL
preferEventualConsistencyReadOnly	INTEGER	YES		NULL
postponedChangesUIThreshold	INTEGER	YES		NULL
minNumOfForksBeforeReportInfiniteForkTelemetry	INTEGER	YES		NULL
maxIntervalSinceLastPotentialForkInSeconds	INTEGER	YES		NULL
winboxFALMinIntegrationVersion	TEXT	YES		NULL
maxUrlLength	INTEGER	YES		NULL
autoResumeTimersInHours	TEXT	YES		NULL
oneRMPollingIntervalHours	INTEGER	YES		NULL
speedTestMaximumDuration	INTEGER	YES		NULL
speedTestInterval	INTEGER	YES		NULL
speedTestRetryInterval	INTEGER	YES		NULL
speedTestTerminationVariancePercent	INTEGER	YES		NULL
speedTestMaximumNumberOfThreads	INTEGER	YES		NULL
speedTestEnablePercentage	INTEGER	YES		NULL
siteTitle	TEXT	YES		NULL
libraryTitle	TEXT	YES		NULL
macFALMinIntegrationVersion	TEXT	YES		NULL
macFALMinIntegrationVersionProd	TEXT	YES		NULL
PRIMARY	KEY	YES		NULL
webID		YES		NULL
listID)		YES		NULL