SafeDelete Schema v7

OneDrive Versions

23.050.0307.0002

Changes

ALTER TABLE deletes_last_touched_by_sync_engine ADD COLUMN isKFMOptOut;

__oddbm_schema

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

filter_delete_info

Field Type Nullable Key Default Index Extra
fileId INTEGER NO PRI
volumeId INTEGER NO PRI 0 NOT NULL
notificationTime INTEGER NO
path TEXT YES "" COLLATE NOCASE
process TEXT YES "" COLLATE NOCASE

deletes_last_touched_by_sync_engine

Field Type Nullable Key Default Index Extra
resourceId TEXT NO PRI
notificationTime INTEGER NO
isKFMOptOut BOOLEAN NO 0

unvalidated_deletes_displayed_in_ux

Field Type Nullable Key Default Index Extra
resourceId TEXT NO PRI
path TEXT YES "" COLLATE NOCASE
lastCloudUpdateTime INTEGER NO
notificationTime INTEGER NO
uxUserAction INTEGER NO
uiDisplayType INTEGER NO
parentResourceID TEXT NO '0' NOT NULL COLLATE NOCASE
itemType INTEGER NO 0
isFoundByScanner BOOLEAN NO 0
isDisplayedToUser BOOLEAN NO 0

items_moved_to_recycle_bin

Field Type Nullable Key Default Index Extra
fileId INTEGER NO PRI
volumeId INTEGER NO PRI
itemName TEXT NO
resourceId TEXT NO
parentResourceId TEXT NO X
reparentStatus INTEGER NO X
notificationTime INTEGER NO

No comments:

Post a Comment