Talk:Check inventory script

With UPDATE inventoryfolders SET `type` = '-1' WHERE `AgentID` = 'user-uuid' AND `parentFolderID` != 'folderID of My Inventory';

All "My inventory" root folders will be of type -1.

I used UPDATE inventoryfolders SET `type` = '-1' WHERE `AgentID` = 'user-uuid' AND `parentFolderID` != 'folderID of My Inventory' AND `parentFolderID` != '00000000-0000-0000-0000-000000000000';

DBeaver does operations based on the dataset you selected so technically that works, but I'll change the query up.