CREATE TABLE henryrec
   ( composer           TEXT,
     title              TEXT,
     soloists           TEXT,
     accompanist        TEXT,
     conductor          TEXT,
     orchestra          TEXT,
     date               TEXT,
     hall               TEXT,
     date_catalogued    TEXT,
     composer_involved  TEXT,
     filed_under        TEXT,
     live_studio        TEXT,
     lp_cd              TEXT,
     timing             INT,
     label_and_number   TEXT,
     nationality        TEXT,
     distinctive        TEXT,
     type               TEXT
   );

/* Table inheritance, anyone? */
CREATE TABLE searches
   ( composer           TEXT,
     title              TEXT,
     soloists           TEXT,
     accompanist        TEXT,
     conductor          TEXT,
     orchestra          TEXT,
     date               TEXT,
     hall               TEXT,
     date_catalogued    TEXT,
     composer_involved  TEXT,
     filed_under        TEXT,
     live_studio        TEXT,
     lp_cd              TEXT,
     timing             TEXT,
     label_and_number   TEXT,
     nationality        TEXT,
     distinctive        TEXT,
     type               TEXT,

     date_of_search     TIMESTAMP,
     num_results        INT,
     result_format      TEXT,
     browser_desc       TEXT,
     ip_address         TEXT
   );
