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

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

diff --git a/setup/sqlite/seen.sql b/setup/sqlite/seen.sql
index 339803808448342c69dd965d025137f02add30b4..7892d76c011a177d2c8b948bd6fc5e52846a4812 100644 (file)
--- a/setup/sqlite/seen.sql
+++ b/setup/sqlite/seen.sql
@@ -4,5 +4,5 @@ CREATE TABLE seen (
  channel VARCHAR(30) NOT NULL,
  host VARCHAR(80) NOT NULL,
  message TINYTEXT NOT NULL,
- PRIMARY KEY (nick,channel)
+ PRIMARY KEY (nick)
 );