-- create.sql - create a database to store tweets

-- Eric Lease Morgan <emorgan@nd.edu>
-- February 8, 2001 - first investigations; @ #c4l11


DROP TABLE IF EXISTS `c4l11`.`tweets` ;

CREATE TABLE IF NOT EXISTS `c4l11`.`tweets` (

  `tweet_id` BIGINT NOT NULL PRIMARY KEY,
  `datetime` DATETIME NOT NULL,
  `author_id` BIGINT NOT NULL,
  `tweet` VARCHAR(140) NOT NULL
  
);

