HEX
Server: Apache/2.4.46 (Win64) OpenSSL/1.1.1j PHP/8.4.25
System: Windows NT DESKTOP-4TAV2RJ 10.0 build 19045 (Windows 10) AMD64
User: fred (0)
PHP: 8.4.25
Disabled: NONE
Upload Files
File: C:/Users/fred/AppData/Local/Microsoft/OneDrive/settings/Business1/SyncEngineDatabase.db
SQLite format 3@  P._�������77�'tableod_ClientFile_Recordsod_ClientFile_RecordsCREATE TABLE od_ClientFile_Records ( resourceID TEXT PRIMARY KEY NOT NULL COLLATE NOCASE CHECK (length(resourceID) > 0), parentResourceID TEXT NOT NULL COLLATE NOCASE, eTag TEXT NOT NULL COLLATE NOCASE, fileName TEXT NOT NULL COLLATE NOCASE, resyncState INTEGER, volumeID INTEGER, itemIndex INTEGER, lastChange INTEGER, size INTEGER, fileStatus INTEGER, spoPermissions INTEGER, checkedOutState INTEGER, serverSize INTEGER, serverLastChange INTEGER, mediaDateTaken INTEGER, mediaWidth INTEGER, mediaHeight INTEGER, mediaDuration INTEGER, holdStateBegin INTEGER, holdStateReason INTEGER, holdStateResolution INTEGER, locallyDeleted INTEGER, isOneNoteShortcut INTEGER, reuploadNeeded INTEGER, matchesMissingVersion INTEGER, serverFileIsNewerThanLocalFile INTEGER, serverDeleted INTEGER, irmEncrypted INTEGER, irmDecryptableByClient INTEGER, irmDecryptableByServer INTEGER, coAuthOcsi INTEGER, ocsiModified INTEGER, lastModifiedViaOcsi INTEGER, lastMovedViaOcsi INTEGER, needsContentCheck INTEGER, linkifiedShortcut INTEGER, webBasedFile INTEGER, mediaFileMetadataUpToDate INTEGER, cfAlwaysFullFlagAttempted INTEGER, oneNoteFixupRequired INTEGER, sharedItem INTEGER, subScope INTEGER, localHashDigest BLOB, localHashAlgorithm INTEGER, localHashDescriptor INTEGER, serverHashDigest BLOB, serverHashAlgorithm INTEGER, serverHashDescriptor INTEGER, irmEnabled INTEGER, irmPolicyState INTEGER, irmEncryptedFileSize INTEGER, irmHashDigest BLOB, irmHashAlgorithm INTEGER, irmHashDescriptor INTEGER, localWriteValidationToken BLOB, localWaterlineData BLOB, localCobaltHashDigest BLOB, localCobaltHashAlgorithm INTEGER, localCobaltHashDescriptor INTEGER, serverWriteValidationToken BLOB, serverWaterlineData BLOB, serverCobaltHashDigest BLOB, serverCobaltHashAlgorithm INTEGER, serverCobaltHashDescriptor INTEGER, localCLPIsMipDecrypted INTEGER, localCLPLabelHashScope INTEGER, localCLPHashDigest BLOB, localCLPHashAlgorithm INTEGER, localCLPHashDescriptor INTEGER, serverCLPIsMipDecrypted INTEGER, serverCLPLabelHashScope INTEGER, serverCLPHashDigest BLOB, serverCLPHashAlgorithm INTEGER, serverCLPHashDescriptor INTEGER ) WITHOUT ROWID�h55�stableod_ScopeInfo_Recordsod_ScopeInfo_RecordsCREATE TABLE od_ScopeInfo_Records ( scopeID TEXT PRIMARY KEY NOT NULL COLLATE NOCASE CHECK (length(scopeID) > 0), flags INTEGER NOT NULL, scopeType INTEGER NOT NULL, resyncStatus INTEGER, resyncScheduled INTEGER, syncTokenData BLOB, selectiveSyncEnabled INTEGER, syncRootFiles INTEGER, sourceResourceID TEXT COLLATE NOCASE, cid TEXT COLLATE NOCASE, scopeSequentialID INTEGER, shortcutVolumeID INTEGER, shortcutItemIndex INTEGER, siteID TEXT COLLATE NOCASE, webID TEXT COLLATE NOCASE, listID TEXT COLLATE NOCASE, resyncFolderID TEXT COLLATE NOCASE, libraryType INTEGER, spoPermissions INTEGER, checkedOutState INTEGER, resyncRestrictions INTEGER, libraryIrmPolicyState INTEGER ) WITHOUT ROWID�)==�etableod_SelectiveSync_Recordsod_SelectiveSync_RecordsCREATE TABLE od_SelectiveSync_Records ( resourceID TEXT PRIMARY KEY NOT NULL COLLATE NOCASE CHECK (length(resourceID) > 0), rootFolderID TEXT NOT NULL COLLATE NOCASE, syncState INTEGER NOT NULL, syncChildrenFiles INTEGER ) WITHOUT ROWID�l77�wtableodc_convergence_itemsodc_convergence_itemsCREATE 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 ) WITHOUT ROWID�))�;table__oddbm_schema__oddbm_schemaCREATE TABLE __oddbm_schema (name TEXT PRIMARY KEY, value INTEGER UNIQUE) WITHOUT ROWID;O)indexsqlite_autoindex___oddbm_schema_2__oddbm_

	
��version#
��#version





	�@��
�#55�+tableod_ScopeInfo_Recordsod_ScopeInfo_RecordsCREATE TABLE od_ScopeInfo_Records ( scopeID TEXT PRIMARY KEY NOT NULL COLLATE NOCASE CHECK (length(scopeID) > 0), flags INTEGER NOT NULL, scopeType INTEGER NOT NULL, resyncStatus INTEGER, resyncScheduled INTEGER, syncTokenData BLOB, selectiveSyncEnabled INTEGER, syncRootFiles INTEGER, sourceResourceID TEXT COLLATE NOCASE, cid TEXT COLLATE NOCASE, scopeSequentialID INTEGER, shortcutVolumeID INTEGER, shortcutItemIndex INTEGER, siteID TEXT COLLATE NOCASE, webID TEXT COLLATE NOCASE, listID TEXT COLLATE NOCASE, resyncFolderID TEXT COLLATE NOCASE, libraryType INTEGER, spoPermissions INTEGER, checkedOutState INTEGER, resyncRestrictions INTEGER, libraryIrmPolicyState INTEGER , webURL TEXT, tenantID TEXT) WITHOUT ROWID�77�tableod_ClientFile_Recordsod_ClientFile_RecordsCREATE TABLE od_ClientFile_Records ( resourceID TEXT PRIMARY KEY NOT NULL COLLATE NOCASE CHECK (length(resourceID) > 0), parentResourceID TEXT NOT NULL COLLATE NOCASE, eTag TEXT NOT NULL COLLATE NOCASE, fileName TEXT NOT NULL COLLATE NOCASE, resyncState INTEGER, volumeID INTEGER, itemIndex INTEGER, lastChange INTEGER, size INTEGER, fileStatus INTEGER, spoPermissions INTEGER, checkedOutState INTEGER, serverSize INTEGER, serverLastChange INTEGER, mediaDateTaken INTEGER, mediaWidth INTEGER, mediaHeight INTEGER, mediaDuration INTEGER, holdStateBegin INTEGER, holdStateReason INTEGER, holdStateResolution INTEGER, locallyDeleted INTEGE�&77�ktableodc_convergence_itemsodc_convergence_itemsCREATE 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�55�Mtableod_ScopeInfo_Recordsod_ScopeInfo_RecordsCREATE TABLE od_ScopeInfo_Records ( scopeID TEXT PRIMARY KEY NOT NULL COLLATE NOCASE CHECK (length(scopeID) > 0), flags INTEGER NOT NULL, scopeType INTEGER NOT NULL, resyncStatus INTEGER, resyncScheduled INTEGER, syncTokenData BLOB, selectiveSyncEnabled INTEGER, syncRootFiles INTEGER, sourceResourceID TEXT COLLATE NOCASE, cid TEXT COLLATE NOCASE, scopeSequentialID INTEGER, shortcutVolumeID INTEGER, shortcutItemIndex INT�055�tableod_ScopeInfo_Recordsod_ScopeInfo_RecordsCREATE TABLE od_ScopeInfo_Records ( scopeID TEXT PRIMARY KEY NOT NULL COLLATE NOCASE CHECK (length(scopeID) > 0), flags INTEGER NOT NULL, scopeType INTEGER NOT NULL, resyncStatus INTEGER, resyncScheduled INTEGER, syncTokenData BLOB, selectiveSyncEnabled INTEGER, syncRootFiles INTEGER, sourceResourceID TEXT COLLATE NOCASE, cid TEXT COLLATE NOCASE, scopeSequentialID INTEGER, shortcutVolumeID INTEGER, shortcutItemIndex INTEGER, siteID TEXT COLLATE NOCASE, webID TEXT COLLATE NOCASE, listID TEXT COLLATE NOCASE, resyncFolderID TEXT COLLATE NOCASE, libraryType INTEGER, spoPermissions INTEGER, checkedOutState INTEGER, resyncRestrictions INTEGER, libraryIrmPolicyState INTEGER , webURL TEXT, tenantID TEXT, remotePath TEXT, lastResyncVersion INTEGER) WITHOUT ROWID�)==�etableod_SelectiveSync_Recordsod_SelectiveSync_RecordsCREATE TABLE od_SelectiveSync_Records ( resourceID TEXT PRIMARY KEY NOT NULL COLLATE NOCASE CHECK (length(resourceID) > 0), rootFolderID TEXT NOT NULL COLLATE NOCASE, syncState INTEGER NOT NULL, syncChildrenFiles INTEGER ) WITHOUT ROWID�))�;table__oddbm_schema__oddbm_schemaCREATE TABLE __oddbm_schema (name TEXT PRIMARY KEY, value INTEGER UNIQUE) WITHOUT ROWID;O)indexsqlite_autoindex___oddbm_schema_2__oddbm_schema
@@


�G77�-tableod_ClientFile_Recordsod_ClientFile_RecordsCREATE TABLE od_ClientFile_Records ( resourceID TEXT PRIMARY KEY NOT NULL COLLATE NOCASE CHECK (length(resourceID) > 0), parentResourceID TEXT NOT NULL COLLATE NOCASE, eTag TEXT NOT NULL COLLATE NOCASE, fileName TEXT NOT NULL COLLATE NOCASE, resyncState INTEGER, volumeID INTEGER, itemIndex INTEGER, lastChange INTEGER, size INTEGER, fileStatus INTEGER, spoPermissions INTEGER, checkedOutState INTEGER, serverSize INTEGER, serverLastChange INTEGER, mediaDateTaken INTEGER, mediaWidth INTEGER, mediaHeight INTEGER, mediaDuration INTEGER, holdStateBegin INTEGER, holdStateReason INTEGER, holdStateResolution INTEGER, locallyDeleted INTEGER, isOneNoteShortcut INTEGER, reuploadNeeded INTEGER, matchesMissingVersion INTEGER, serverFileIsNewerThanLocalFile INTEGER, serverDeleted INTEGER, irmEncrypted INTEGER, irmDecryptableByClient INTEGER, irmDecryptableByServer INTEGER, coAuthOcsi INTEGER, ocsiModified INTEGER, lastModifiedViaOcsi INTEGER, lastMovedViaOcsi INTEGER, needsContentCheck INTEGER, linkifiedShortcut INTEGER, webBasedFile INTEGER, mediaFileMetadataUpToDate INTEGER, cfAlwaysFullFlagAttempted INTEGER, oneNoteFixupRequired INTEGER, sharedItem INTEGER, subScope INTEGER, localHashDigest BLOB, localHashAlgorithm INTEGER, localHashDescriptor INTEGER, serverHashDigest BLOB, serverHashAlgorithm INTEGER, serverHashDescriptor INTEGER, irmEnabled INTEGER, irmPolicyState INTEGER, irmEncryptedFileSize INTEGER, irmHashDigest BLOB, irmHashAlgorithm INTEGER, irmHashDescriptor INTEGER, localWriteValidationToken BLOB, localWaterlineData BLOB, localCobaltHashDigest BLOB, localCobaltHashAlgorithm INTEGER, localCobaltHashDescriptor INTEGER, serverWriteValidationToken BLOB, serverWaterlineData BLOB, serverCobaltHashDigest BLOB, serverCobaltHashAlgorithm INTEGER, serverCobaltHashDescriptor INTEGER, localCLPIsMipDecrypted INTEGER, localCLPLabelHashScope INTEGER, localCLPHashDigest BLOB, localCLPHashAlgorithm INTEGER, localCLPHashDescriptor INTEGER, serverCLPIsMipDecrypted INTEGER, serverCLPLabelHashScope INTEGER, serverCLPHashDigest BLOB, serverCLPHashAlgorithm INTEGER, serverCLPHashDescriptor INTEGER , localProtocolSupport INTEGER, localSyncTokenData BLOB, serverProtocolSupport INTEGER, serverSyncTokenData BLOB, cloudVisibleOnly INTEGER, LinkifiedODCShortcut INTEGER, LinkifiedSPOShortcut INTEGER, CoAuthClockData TEXT, diskLastAccessTime INTEGER, diskCreationTime INTEGER, lastKnownPinState INTEGER, archiveState INTEGER) WITHOUT ROWID�x;;�tableod_ClientFolder_Recordsod_ClientFolder_RecordsCREATE TABLE od_ClientFolder_Records ( resourceID TEXT PRIMARY KEY NOT NULL COLLATE NOCASE CHECK (length(resourceID) > 0), parentResourceID TEXT NOT NULL COLLATE NOCASE, parentScopeID TEXT NOT NULL COLLATE NOCASE, eTag TEXT NOT NULL COLLATE NOCASE, folderName TEXT NOT NULL COLLATE NOCASE, resyncState INTEGER, volumeID INTEGER, itemIndex INTEGER, folderStatus INTEGER, syncChildrenFiles INTEGER, locallyDeleted INTEGER, serverDeleted INTEGER, jumpLinkType INTEGER, spoPermissions INTEGER, checkedOutState INTEGER, oneNoteDetectionPending INTEGER, sharedItem INTEGER, subScope INTEGER , teamsChannelFolder INTEGER, cloudVisibleOnly INTEGER, folderColor INTEGER, localFolderColor INTEGER) WITHOUT ROWID�x??�tableod_UnrealizedFile_Recordsod_UnrealizedFile_RecordsCREATE TABLE od_UnrealizedFile_Records ( resourceID TEXT PRIMARY KEY NOT NULL COLLATE NOCASE CHECK (length(resourceID) > 0), size INTEGER, modTime INTEGER, filePath TEXT NOT NULL COLLATE NOCASE, ocsiModified INTEGER, irmEnabled INTEGER, irmPolicyState INTEGER, irmEncryptedFileSize INTEGER, irmHashDigest BLOB, irmHashAlgorithm INTEGER, irmHashDescriptor INTEGER, cmWriteValidationToken BLOB, cmWaterlineData BLOB, cmHashDigest BLOB, cmHashAlgorithm INTEGER, cmHashDescriptor INTEGER, clpIsMipDecrypted INTEGER, clpLabelHashScope INTEGER, clpHashDigest BLOB, clpHashAlgorithm INTEGER, clpHashDescriptor INTEGER , cmProtocolSupport INTEGER, cmSyncTokenData BLOB, CoAuthClockData TEXT) WITHOUT ROWID






	N6;	%�NK$5��AA�)tableod_GraphMe�e
WW�)tableod_MigrateItemPostponedChange_Recordsod_MigrateItemPostponedChange_RecordsCREATE TABLE od_MigrateItemPostponedChange_Records ( persistenceID INTEGER PRIMARY KEY NOT NULL, sequenceID INTEGER NOT NULL, resourceID TEXT NOT NULL COLLATE NOCASE, parentResourceID TEXT NOT NULL COLLATE NOCASE, parentScopeID TEXT NOT NULL COLLATE NOCASE, eTag TEXT NOT NULL COLLATE NOCASE, changeType INTEGER, postponedCount INTEGER, flags INTEGER, itemName TEXT, itemSharingStatus INTEGER, isDelete INTEGER, spoPermissions INTEGER, checkedOutState INTEGER, jumpLinkType INTEGER, lastChange INTEGER, size INTEGER, mediaDateTaken INTEGER, mediaWidth INTEGER, mediaHeight INTEGER, mediaDuration INTEGER, hashDigest BLOB, hashAlgorithm INTEGER, hashDescriptor INTEGER, serverSha1HashDigest BLOB, writeValidationToken BLOB, waterlineData BLOB, cobaltHashDigest BLOB, cobaltHashAlgorithm INTEGER, cobaltHashDescriptor INTEGER, protocolSupport INTEGER, syncTokenData BLOB , forkedItemAtPathOnce BOOLEAN DEFAULT 0)�O	UU�tableod_ClientFilePostponedChange_Recordsod_ClientFilePostponedChange_RecordsCREATE TABLE od_ClientFilePostponedChange_Records ( persistenceID INTEGER PRIMARY KEY NOT NULL, sequenceID INTEGER NOT NULL, resourceID TEXT NOT NULL COLLATE NOCASE, parentResourceID TEXT NOT NULL COLLATE NOCASE, parentScopeID TEXT NOT NULL COLLATE NOCASE, eTag TEXT NOT NULL COLLATE NOCASE, changeType INTEGER, postponedCount INTEGER, flags INTEGER, fileName TEXT, sourceResourceID TEXT COLLATE NOCASE, lastChange INTEGER, size INTEGER, isLocalChange INTEGER, isOneNote INTEGER, reuploadNeeded INTEGER, createStubFile INTEGER, itemSharingStatus INTEGER, timeAdded INTEGER, spoPermissions INTEGER, checkedOutState INTEGER, irmEnabled INTEGER, irmPolicyState INTEGER, mediaDateTaken INTEGER, mediaWidth INTEGER, mediaHeight INTEGER, mediaDuration INTEGER, hashDigest BLOB, hashAlgorithm INTEGER, hashDescriptor INTEGER, writeValidationToken BLOB, waterlineData BLOB, cobaltHashDigest BLOB, cobaltHashAlgorithm INTEGER, cobaltHashDescriptor INTEGER, clpIsMipDecrypted INTEGER, clpLabelHashScope INTEGER, clpHashDigest BLOB, clpHashAlgorithm INTEGER, clpHashDescriptor INTEGER , protocolSupport INTEGER, syncTokenData BLOB, shouldHardDelete INTEGER)�;;�)tableod_ClientFolde�,YY�3tableod_ClientFolderPostponedChange_Recordsod_ClientFolderPostponedChange_RecordsCREATE TABLE od_ClientFolderPostponedChange_Records ( persistenceId INTEGER PRIMARY KEY NOT NULL, sequenceID INTEGER NOT NULL, resourceID TEXT NOT NULL COLLATE NOCASE, parentResourceID TEXT NOT NULL COLLATE NOCASE, parentScopeID TEXT NOT NULL COLLATE NOCASE, eTag TEXT NOT NULL COLLATE NOCASE, changeType INTEGER, postponedCount INTEGER, flags INTEGER, folderName TEXT, sourceResourceID TEXT COLLATE NOCASE, subScopeOwnerResourceID TEXT COLLATE NOCASE, itemSharingStatus INTEGER, isLocalChange INTEGER, jumpLinkType INTEGER, spoPermissions INTEGER, checkedOutState INTEGER , folderColor INTEGER)�JaY�gindexclientFolderPostponedChangeSequenceIdIndexod_ClientFolderPostponedChange_RecordsCREATE INDEX clientFolderPostponedChangeSequenceIdIndex ON od_ClientFolderPostponedChange_Records(sequenceID)�YY�	tableod_ClientFolderPostponedChange_Recordsod_ClientFolderPostponedChange_RecordsCREATE TABLE od_ClientFolderPostponedChange_Records ( persistenceId INTEGER PRIMARY KEY NOT NULL, sequenceID INTEGER NOT NULL, resourceID TEXT NOT NULL COLLATE NOCASE, parentResourceID TEXT NOT NULL COLLATE NOCASE, parentScopeID TEXT NOT NULL COLLATE NOCASE, eTag TEXT NOT NULL COLLATE NOCASE, changeType INTEGER, postponedCount INTEGER, flags INTEGER, folderName TEXT, sourceResourceID TEXT COLLATE NOCASE, subScopeOwnerResourceID TEXT COLLATE NOCASE, itemSharingStatus INTEGER, isLocalChange INTEGER, jumpLinkType INTEGER, spoPermissions INTEGER, checkedOutState INTEGER )�B
]U�_indexclientFilePostponedChangeSequenceIdIndexod_ClientFilePostponedChange_Records
CREATE INDEX clientFilePostponedChangeSequenceIdIndex ON od_ClientFilePostponedChange_Records(sequenceID)


��-lastWriteCounter
��-	lastWriteCounter

>7
�
�
�0
	a�)>9�WW�)tableod_MigrateItemPostponedChange_Recordsod_MigrateItemPostponedChange_RecordsCREATE TABLE od_MigrateItemPostponedChange_Records ( persistenceID INTEGER PRIMARY KEY NOT NULL, sequenceID INTEGER NOT NULL, resourceID TEXT NOT NULL COLLATE NOCASE, parentResourceID TEXT NOT NULL COLLATE NOCASE, parentScopeID TEXT NOT NULL COLLATE NOCASE, eTag TEXT NOT NULL COLLATE NOCASE, changeType INTEGER, postponedCount INTEGER, flags INTEGER, itemName TEXT, itemSharingStatus INTEGER, isDelete INTEGER, spoPermissions INTEGER, checkedOutState INTEGER, jumpLinkType INTEGER, lastChange INTEGER, size INTEGER, mediaDateTaken INTEGER, mediaWidth INTEGER, mediaHeight INTEGER, mediaDuration INTEGER, hashDigest BLOB, hashAlgorithm INTEGER, hashDescriptor INTEGER, server�h11�{tableod_ThrottleHistoryod_ThrottleHistoryCREATE TABLE od_ThrottleHistory ( startTime INTEGER PRIMARY KEY, duration INTEGER, scenario INTEGER, reason TEXT COLLATE NOCASE, isKFM INTEGER, isOnBackoffList INTEGER ) WITHOUT ROWID�99�#tableod_ArchiveData_Recordsod_ArchiveData_RecordsCREATE TABLE od_ArchiveData_Records ( resourceID TEXT PRIMARY KEY NOT NULL COLLATE NOCASE, fileName TEXT COLLATE NOCASE, lastReportedAccessTime INTEGER NOT NULL, lastReportingTime INTEGER ) WITHOUT ROWID�)M=�Qtriggerod_GraphMetadata_UpdateTimeStampod_GraphMetadata_RecordsCREATE TRIGGER od_GraphMetadata_UpdateTimeStamp AFTER INSERT ON od_GraphMetadata_Records BEGIN UPDATE od_GraphMetadata_Records SET lastWriteCount = (SELECT value+1 FROM od_GraphMetadata_LastWrite WHERE name = 'lastWriteCounter') WHERE resourceID = NEW.resourceID; UPDATE od_GraphMetadata_LastWrite SET value = value+1 WHERE name = 'lastWriteCounter'; END�1--�tableod_HydrationDataod_HydrationDataCREATE TABLE od_HydrationData ( resourceID TEXT PRIMARY KEY NOT NULL COLLATE NOCASE, firstHydrationTime INTEGER NOT NULL , lastHydrationTime INTEGER, hydrationCount INTEGER DEFAULT 1, lastHydrationType TEXT NOT NULL COLLATE NOCASE DEFAULT Active) WITHOUT ROWIDD�MEE�tableod_CreateAddedFolderFailuresod_CreateAddedFolderFailuresCREATE TABLE od_CreateAddedFolderFailures ( siteID TEXT NOT NULL COLLATE NOCASE, listID TEXT NOT NULL COLLATE NOCASE, folderID TEXT NOT NULL COLLATE NOCASE, lastSuccessfulSync INTEGER NOT NULL, reason INTEGER, PRIMARY KEY (siteID, listID, folderID) ) WITHOUT ROWID�,W;�SindexitemIndex_volumeID_clientFolder_Indexod_ClientFolder_RecordsCREATE INDEX itemIndex_volumeID_clientFolder_Index ON od_ClientFolder_Records (itemIndex, volumeID)�$S7�KindexitemIndex_volumeID_clientFile_Indexod_ClientFile_RecordsCREATE INDEX itemIndex_volumeID_clientFile_Index ON od_ClientFile_Records (itemIndex, volumeID)�JOO�tableodc_Convergence_ScopeInfo_Recordsodc_Convergence_ScopeInfo_RecordsCREATE 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�/C=�kindexgraphMetaDataTimeStampIndexod_GraphMetadata_RecordsCREATE INDEX graphMetaDataTimeStampIndex ON od_GraphMetadata_Records(lastWriteCount, resourceID, fileExtension)SgAindexsqlite_autoindex_od_GraphMetadata_LastWrite_1od_GraphMetadata_LastWrite�:AA�tableod_GraphMetadata_LastWriteod_GraphMetadata_LastWriteCREATE TABLE od_GraphMetadata_LastWrite (name TEXT primary key, value INTEGER, lastWriteTableId TEXT NOT NULL DEFAULT '')�l==�ktableod_GraphMetadata_Recordsod_GraphMetadata_RecordsCREATE TABLE od_GraphMetadata_Records ( resourceID TEXT PRIMARY KEY NOT NULL COLLATE NOCASE, graphMetadataJSON TEXT NOT NULL, spoCompositeID TEXT NOT NULL, createdBy TEXT NOT NULL, modifiedBy TEXT NOT NULL , filePolicies TEXT, fileExtension TEXT, lastWriteCount INTEGER DEFAULT 0 NOT NULL) WITHOUT ROWID�F_W�cindexmigrateItemPostponedChangeSequenceIdIndexod_MigrateItemPostponedChange_RecordsCREATE INDEX migrateItemPostponedChangeSequenceIdIndex ON od_MigrateItemPostponedChange_Records(sequenceID)