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

git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk@1875 c11ca15a-4712-0410-83d8-924469b57eb5

diff --git a/ChangeLog b/ChangeLog
index ff2ced08c633538fda37d1bc4a424caa298e3290..b991a7438f9536bc6edc6088a7cd2e5bf7ed018c 100644 (file)
--- a/ChangeLog
+++ b/ChangeLog
@@ -23,6 +23,7 @@
 * Removed +W3Search in infobot.chan, added +Google (don't forget to update your
 configs)
 
+* Fixed minor typo in seen.sql for Pgsql (closes #2868436)
 
 1.5.3
 =====

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);