* Synced schema for seen table in other engines to match sqlite2 schema (PKEY only...

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

diff --git a/setup/mysql/seen.sql b/setup/mysql/seen.sql
index 831e64dd73605154e3f55f43bc4e4f7426c8d178..9a2b691531db5a57b8250e03decda1603dbf4178 100644 (file)
--- a/setup/mysql/seen.sql
+++ b/setup/mysql/seen.sql
@@ -8,5 +8,5 @@ CREATE TABLE `seen` (
   `channel` varchar(30) NOT NULL default '',
   `host` varchar(64) NOT NULL default '',
   `message` tinytext NOT NULL,
-  PRIMARY KEY  (`nick`,`channel`)
+  PRIMARY KEY  (`nick`)
 ) TYPE=MyISAM;