Quote:
Originally Posted by theducks
I am looking at the file /opt/calibre/resources/metadata_sqlite.sql and that field is not there 
I assumed this was the file used to create the original (empty) DB. |
It is. However, as you suspected, it isn't the end of the story. There is code in library.database and library.database2 that upgrades the database to the current version. When initializing, calibre creates a V1 database (the sql you were looking at), then upgrades it.
It is worth noting that metadata is a view, so is never ALTERed. It is simply recreated as needed.