* Rename of insertDB.pl to factpack.pl

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

diff --git a/setup/pgsql/seen.sql b/setup/pgsql/seen.sql
index 550f5bfc8489db0fac8aff878faa59424ca1815c..d90a6f61bd3e012d0fb692d4835a5f2cae1fd6d5 100644 (file)
--- a/setup/pgsql/seen.sql
+++ b/setup/pgsql/seen.sql
@@ -1,14 +1,12 @@
 CREATE TABLE seen (
     nick VARCHAR(20) NOT NULL,
     "time" numeric NOT NULL,
-    channel VARCHAR(20) NOT NULL,
+    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);