My interest was in removing Preloaded books I have read or stumbled over from the Books list when the "My Books" [only] option is selected. It appears that such books have ReadStatus = "2" in the content table. Thus, the SQL commands to sqlite to list such entries and to reset them to "unread" are respectively:
Code:
select Title, ReadStatus, FirstTimeReading from content where ReadStatus = "2";
update content set ReadStatus = '0', FirstTimeReading = 'true' where ReadStatus = "2";