DROP TABLE IF EXISTS author;
CREATE TABLE author(
   uniqueAuthorID INTEGER NOT NULL AUTO_INCREMENT,
   /* Name of author exactly as appears, possibly entified, with markup. */
   authorName VARCHAR( 200 ) NOT NULL,
   birthYear INTEGER,
   birthDate DATE,
   cssClass VARCHAR ( 25 ) NOT NULL,
   deathYear INTEGER,
   deathDate DATE,
   notesAboutAuthor VARCHAR ( 1000 ),
   sortKey VARCHAR ( 200 ) NOT NULL /* used to sort authors and detect dups */
   PRIMARY KEY( uniqueAuthorID )
   );
