As requested, this is how I applied the hack on my Windows XP PC.
- Install SQLiteSpy free program.
Note: I used version 1.8.11, which is not the current version, so I hope this step-by-step is still correct.
- Attach the PRST1 to the PC and copy the file
[int memory:]\Sony_Reader\database\books.db
to the PC. I also took a 2nd copy for backup 'just in case'.
- Launch SQLiteSpy and open the copied books.db file using
File - Open Database
- Copy Kolenka's code, from post #1, into the code panel - see attachment
- Run the code, Execute - Execute SQL
- Check it has run correctly by expanding the left panel (see attachment)
main - Tables - books - Triggers
You should see 2 triggers. The one you have just added is the 2nd one, called recently_added_trigger
- Exit SQLiteSpy. When it asks if you want to 'Save Changes to CREATE TRIGGER ...?' You can say No as the database has already been updated.
- Copy the updated file, books.db back to the PRST1 overwriting the original.
- I don't use an SD card, but if you do you will need to update the books.db file on the SD card in the same way as for the internal memory one.
- Disconnect the PRST1 in the normal way.
- Read Kolenka's caveat in post #1