[theducks]

Originally Posted by Starson17

In mine, too. However, suppose you are merging two books, and one has author Unknown, and the other John Smith. Do you want to overwrite Unknown with John's name or not?

If "Unknown" replace if not blank

Same question. (I'll check to see what is in the title when it's left blank, but regardless....) If you are merging two books and one has a title exactly matching "Unknown" and the other does not, do you want to overwrite?

Title is defaulted to "Unknown" by Table rules if NOT explicitly set.

CREATE TABLE authors ( id   INTEGER PRIMARY KEY,
                              name TEXT NOT NULL COLLATE NOCASE,
                              sort TEXT COLLATE NOCASE,
                              UNIQUE(name)
                             );
CREATE TABLE books ( id      INTEGER PRIMARY KEY AUTOINCREMENT,
                             title     TEXT NOT NULL DEFAULT 'Unknown' COLLATE NOCASE,
                             sort      TEXT COLLATE NOCASE,
                             timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                             uri       TEXT,
                             series_index INTEGER NOT NULL DEFAULT 1,
                             author_sort TEXT COLLATE NOCASE,
                             isbn TEXT DEFAULT "" COLLATE NOCASE,
                             path TEXT NOT NULL DEFAULT ""
                        );

Question of logic :^)

You would never combine something into a "Unknown" title
and I can not see a reason setting a "Known" title to "Unknown"
How would you know which was which when combining without at least one decent title displayed.

Generally, I assume I don't want to change author/title in the first selected record during merge, but maybe these are special cases where I should consider "Unknown" to be a blank field.

Congratulations taking on this task. IMHO designing a well thought out UI is very difficult.