From d29f7f7d348f8401a5e6f5f377d6afe9af888dc5 Mon Sep 17 00:00:00 2001
From: djmcgrath <djmcgrath@c11ca15a-4712-0410-83d8-924469b57eb5>
Date: Thu, 8 Oct 2009 13:03:15 +0000
Subject: [PATCH] * 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
---
 ChangeLog            |  1 +
 setup/pgsql/seen.sql | 16 ++++++----------
 2 files changed, 7 insertions(+), 10 deletions(-)

diff --git a/ChangeLog b/ChangeLog
index ff2ced0..b991a74 100644
--- 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 d90a6f6..f0b4fa8 100644
--- 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);
-- 
2.39.2