* Missed DebianBugs.pl in the previous merge

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

diff --git a/setup/pgsql/seen.sql b/setup/pgsql/seen.sql
index 8cf6cd15ba844901e8e0f962587b05e63a64f68d..d90a6f61bd3e012d0fb692d4835a5f2cae1fd6d5 100644 (file)
--- a/setup/pgsql/seen.sql
+++ b/setup/pgsql/seen.sql
@@ -4,11 +4,9 @@ CREATE TABLE seen (
     channel VARCHAR(30) NOT NULL,
     host VARCHAR(80) NOT NULL,
     message text NOT NULL,
-    hehcount numeric DEFAULT 0 NOT NULL,
-    messagecount numeric DEFAULT 0 NOT NULL
 ) WITHOUT OIDS;
 
 REVOKE ALL ON TABLE seen FROM PUBLIC;
 
 ALTER TABLE ONLY seen
-    ADD CONSTRAINT seen_pkey PRIMARY KEY (nick, channel);
+    ADD CONSTRAINT seen_pkey PRIMARY KEY (nick);