-- create.sql - create a database to store irc messages

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


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

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

  `irc_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `datetime` DATETIME NOT NULL,
  `author_id` BIGINT NOT NULL,
  `irc` VARCHAR(1024) NOT NULL
  
);

