[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_chatlog.chatlog_event (
   2    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
   3    channel VARCHAR(64) BINARY NOT NULL,
   4    epoch INT UNSIGNED NOT NULL,
   5    author VARCHAR(64) BINARY NOT NULL,
   6    type VARCHAR(4) NOT NULL,
   7    message LONGBLOB NOT NULL,
   8    loggedByPHID VARCHAR(64) BINARY NOT NULL,
   9    KEY (channel, epoch)
  10  );