View Single Post
Old 05-03-2021, 04:46 AM   #3
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,751
Karma: 30237526
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by kovidgoyal View Post
The calibre database is normalised. So author values are not stored directly on book records, instead there is a separate authors table and a link table to join it with the books table. Unknown authors are never stored in the authors table as far as I remember.
@kovid - FWIW the "Unknown" author is stored in the authors table:

Click image for larger version

Name:	Authors.jpg
Views:	91
Size:	94.3 KB
ID:	186884

And the books_author_table associates books with the "Unknown" author

Click image for larger version

Name:	books-authors-link.jpg
Views:	103
Size:	61.8 KB
ID:	186887

It's also in the author_sort column of the books table
Click image for larger version

Name:	Books.jpg
Views:	90
Size:	386.1 KB
ID:	186885

In case I'd done something strange with my Test library, I also checked my Books library - it's the same.

Moderator Notice
@wold - Moved out of Development. See the sticky at top of that sub-forum.


BR

Last edited by BetterRed; 05-03-2021 at 05:00 AM.
BetterRed is online now   Reply With Quote