mysql> CREATE TABLE author
(
author_id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
author_first VARCHAR(20),
author_last VARCHAR(20),
author_ts TIMESTAMP
);