[pssquirrel]

UPDATE: To go straight to the solution, see Post #10 below.

=================================================

I've been trying to figure out a way to batch-remove all the "new" badges that appear on newly-loaded books so that when I re-format my T1 and re-load my library (which I seem to end up doing regularly) I don't have to manually open/close a bazillion books. (PRS+ does this very nicely on my 350, and it's a feature I miss.)

Thanks to some very kind people here on MobileRead, I've just started delving into the books.db, and I'm taking a guess that the "new" badge appears when reading_time is null???

I was thinking of overwriting the null fields with a number, but since I don't really know what I'm doing, I thought I'd run it by those of you who understand these things to make sure I'm not attempting anything stupid. So here's what I'm wondering:

1. Do you think it reasonable that inputting a number in the null fields in the reading_time column will make the "new" badge disappear?

2. What number do you think I should try since the numbers don't seem to correspond to any obvious timestamp that I'm familiar with? Perhaps one digit higher than the number in modified_date?

Screenshots of the pertinent database columns attached.

What think?