join debugging

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

diff --git a/setup/sqlite2/seen.sql b/setup/sqlite2/seen.sql
index d920f79bc5230843719147a5e59ab7b381c567e9..75c76392a2ee311c14b1e9f69c57a4114b923287 100644 (file)
--- 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)
 );