Where is file name in sqlite3 db?
I've stupidly run a find command that I use for other purposes from inside the calibre library directory. The net result of this was to move all the individual files from where they were in the library to one new directory. I was hoping to write a script that used information from metadata.db to put the files back where they belonged. I can find the pathname in the books table, but I can't find the file names anywhere in the database. Are the filenames there?