|
@edembowski
Ah well the sort column in the authors table is indeed unused. This is because books can have multiple authors.
The database has a normalized structure, in that it tries to contain any given piece of information in only one place. This is good for long term data integrity, but it means that the database isn't easy to edit in a generic database browser program.
I would suggest the following work flow:
Get a list of all the ids and any other needed information using calibredb
Launch calibre-debug
In calibre-debug create a LibraryDatabase instance and just use the set_isbn and set_series methods on it to easily change those fields.
@mollybo
Note that all you books and database will still be contained in a single folder (and its sub folders), so you can continue doing things just as you have been, except that when you copy the database to a new computer/location you have to copy a single folder instead of a single file.
|