* Fixed minor typo in postgresql seen.sql (closes bug #2868436)

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

diff --git a/setup/pgsql/seen.sql b/setup/pgsql/seen.sql
index d90a6f61bd3e012d0fb692d4835a5f2cae1fd6d5..f0b4fa8615a3b3270472d95f895872b73ca350e3 100644 (file)
--- a/setup/pgsql/seen.sql
+++ b/setup/pgsql/seen.sql
@@ -1,12 +1,8 @@
 CREATE TABLE seen (
-    nick VARCHAR(20) NOT NULL,
-    "time" numeric NOT NULL,
-    channel VARCHAR(30) NOT NULL,
-    host VARCHAR(80) NOT NULL,
-    message text NOT NULL,
+   nick character varying(20) NOT NULL, 
+   "time" numeric NOT NULL, 
+   channel character varying(30) NOT NULL, 
+   host character varying(80) NOT NULL, 
+   message text NOT NULL, 
+   CONSTRAINT seen_pkey PRIMARY KEY (nick)
 ) WITHOUT OIDS;
-
-REVOKE ALL ON TABLE seen FROM PUBLIC;
-
-ALTER TABLE ONLY seen
-    ADD CONSTRAINT seen_pkey PRIMARY KEY (nick);