SafeDelete Schema v9

OneDrive Vesrsions

25.154.0810.0001 ->

Changes

CREATE TABLE redundant_placeholder_deletes ( fsid TEXT NOT NULL COLLATE NOCASE, resourceId TEXT COLLATE NOCASE, itemName TEXT, PRIMARY KEY(fsid));

__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
volumeId INTEGER NO 0 NOT NULL
notificationTime INTEGER NO
path TEXT YES "" COLLATE NOCASE
process TEXT YES "" COLLATE NOCASE
PRIMARY KEY(fileId, volumeId) YES NULL

deletes_last_touched_by_sync_engine

Field Type Nullable Key Default Index Extra
resourceId TEXT NO
notificationTime INTEGER NO
isKFMOptOut BOOLEAN NO 0
PRIMARY KEY(resourceId) YES NULL

unvalidated_deletes_displayed_in_ux

Field Type Nullable Key Default Index Extra
resourceId TEXT NO
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
PRIMARY KEY(resourceId) YES NULL

items_moved_to_recycle_bin

Field Type Nullable Key Default Index Extra
fileId INTEGER NO
volumeId INTEGER NO
itemName TEXT NO
resourceId TEXT NO
parentResourceId TEXT NO X
reparentStatus INTEGER NO X
notificationTime INTEGER NO
PRIMARY KEY(fileId, volumeId) YES NULL

placeholder_deletes_info

Field Type Nullable Key Default Index Extra
resourceId TEXT NO
fsid TEXT NO
originalFileName TEXT NO
notificationTime INTEGER NO
PRIMARY KEY(fsid) YES NULL

redundant_placeholder_deletes

Field Type Nullable Key Default Index Extra
fsid TEXT NO
resourceId TEXT YES NULL
itemName TEXT YES NULL
PRIMARY KEY(fsid) YES NULL

No comments:

Post a Comment