-- Author: Andrew Fitz Gibbon
-- Last updated: 11.22.19
-- Sets up a new posts table in a blog database.
CREATE TABLE `posts` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `timestamp` datetime DEFAULT CURRENT_TIMESTAMP,
  `author` varchar(200) DEFAULT 'Fitz',
  `title` varchar(200) DEFAULT NULL,
  `body` text,
  PRIMARY KEY (`id`)
);