# HG changeset patch
# User Goffi <goffi@goffi.org>
# Date 1440072409 -7200
# Node ID bed30cef11a8706be67fe2ce8419938104c7c88a
# Parent  df1edebb046649fa6e454a534b9b289618f11ce6
fixed bad queries in pubsub.sql file

diff -r df1edebb0466 -r bed30cef11a8 db/pubsub.sql
--- a/db/pubsub.sql	Sun Aug 16 01:32:42 2015 +0200
+++ b/db/pubsub.sql	Thu Aug 20 14:06:49 2015 +0200
@@ -16,9 +16,7 @@
     send_last_published_item text NOT NULL DEFAULT 'on_sub'
         CHECK (send_last_published_item IN ('never', 'on_sub')),
     publish_model text NOT NULL DEFAULT 'publishers'
-        CHECK (publish_model IN ('publishers', 'subscribers', 'open')),
-	UNIQUE (node, pep) WHERE pep IS NOT NULL,
-	UNIQUE (node) WHERE pep IS NULL
+        CHECK (publish_model IN ('publishers', 'subscribers', 'open'))
 );
 
 /* we need 2 partial indexes to manage NULL value for PEP */