As mentioned above, I have done some looking at the Event table. The details of the events I have are:
Code:
Id Description
0 Sync with Kobo - One for each book synced, but only when a new book is downloaded? LastOccurence is updated
3 Open book
4 Started a digital library - One for each kepub
5 Finished book
46 Turn page
47 Read all night
48 Read all night
80 Page Turner
1001 Read 12am-1am
1002 Read 1am-5am
1004 Read 7am-9am
1005 Read 9am-12am
1006 Read 12pm-2pm
1007 Read 2pm-4pm
1008 Read 4pm-6pm
1009 Read 6pm-8pm
1010 Read 8pm-10pm
1011 Read 10pm-12pm
1020 ?Close book?
1021 ?Open book?
Events 47 to 1011 listed above, are used for the Achievements. But, they might also be used for other things. The blob that is stored with the 46 and 80 events are fairly large. And they look like they hold timestamps.
Also, the list isn't complete. I just noticed events in the range 51 to 68. And I might have the meaning of the last two events swapped.
As to restoring the database, it is reasonably safe to do so as long as it isn't corrupt in some way. If the books are in the same place, then it will be OK. You might have a problem if any kepubs are not on place. But, you can probably delete these and force a download.