]> git.donarmstrong.com Git - infobot.git/blob - setup/seen.sql
if requested_by is NOT NULL, then we better fill it in on creation
[infobot.git] / setup / seen.sql
1 CREATE TABLE seen (
2         nick VARCHAR(20) NOT NULL,
3         time INT NOT NULL,
4         channel VARCHAR(20) NOT NULL,
5         host VARCHAR(80) NOT NULL,
6         message TINYTEXT NOT NULL,
7
8         PRIMARY KEY (nick,channel)
9 );