[infobot.git] / setup / sqlite / seen.sql

CREATE TABLE seen (
 nick VARCHAR(20) NOT NULL,
 time INT NOT NULL,
 channel VARCHAR(30) NOT NULL,
 host VARCHAR(80) NOT NULL,
 message TINYTEXT NOT NULL,
 PRIMARY KEY (nick)
);