Quote:
Originally Posted by geek1011
Yes, that should work for now. Just copy the contents of 'Series' to 'SeriesID' for sideloaded books (and remember to exclude the rows used for TOC entries).
|
Ok, dumb question, but for TOC entries, isn't the Series data set to NULL anyways? So copying it over to SeriesID should still be NULL and be fine, right? Although I only really spot checked and didn't check every TOC entry but the ones I did encounter were NULL.
I was really hoping something like
Code:
UPDATE content SET SeriesID = Series;
would work.
Although I was playing around (haven't actually deployed it yet) and it seemed to set SeriesNumberFloat to 0.0 for all non-NULL entries at the same time. Not sure if that's a quirk of the program I'm using (
DB Browser for SQLite) or if that's what's supposed to happen. Should I be copying over SeriesNumber to that column too?