major re-organisation of the different SQL files; cleanup and fixing of the postgres...

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

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