X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=setup%2Fsqlite2%2Fseen.sql;h=75c76392a2ee311c14b1e9f69c57a4114b923287;hb=40f6dad8bfd5a8a707a69cb31ba62cc6d26139c1;hp=d920f79bc5230843719147a5e59ab7b381c567e9;hpb=1c0a2202fe58159dd4d4197c4ff8b21f9387685e;p=infobot.git

diff --git a/setup/sqlite2/seen.sql b/setup/sqlite2/seen.sql
index d920f79..75c7639 100644
--- a/setup/sqlite2/seen.sql
+++ b/setup/sqlite2/seen.sql
@@ -1,8 +1,8 @@
 CREATE TABLE seen (
  nick VARCHAR(20) NOT NULL,
  time INT NOT NULL,
- channel VARCHAR(20) NOT NULL,
+ channel VARCHAR(30) NOT NULL,
  host VARCHAR(80) NOT NULL,
  message TINYTEXT NOT NULL,
- PRIMARY KEY (nick,channel)
+ PRIMARY KEY(nick)
 );