KB00094 - Clearing personal data from stickies.db

Helping to debug a problem?

If you need to send the structure of your data file to someone, but not the content, load the file into DB Browser for SQLite, click the Execute SQL tab, and paste the below into the window:

-- Set all images to be a 1x1 red pixel update [content_png] set [png] = X'89504E470D0A1A0A0000000D4948445200000001000000010802000000907753DE000000017352474200AECE1CE90000000467414D410000B18F0BFC6105000000097048597300000EC300000EC301C76FA8640000000C49444154185763F86F9F060003E501A5C2FAE7070000000049454E44AE426082'; -- Set all text to be 'x' update [content_rtf] set [rtf] = '{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang2057{\colortbl ;\red0\green0\blue0;}\pard x\par}'; update [content_rtf] set [search] = NULL; -- Clear all note titles update [stickies] set [title] = 'title'; -- Clear all category names update [categories] set [name] = 'catName' where key != 1; -- Clear all friend names and contact details update [friends] set [email] = 'address@email.com'; update [friends] set [name] = 'friendName'; update [friends] set [address] = '127.0.0.1'; -- Clear all stack titles update [stacks] set [title] = 'stackTitle'; -- Reset the encrypted password update [options] set [value] = 'xxx' where [option] = 'manage.encrypted.password'; vacuum;

Click the little ">" button (or press F5), and click Yes to the warning about "Setting pragma values or vacuuming"

The file has now had all your user data stripped from it.