Mercurial > libervia-pubsub
diff db/pubsub.sql @ 295:bed30cef11a8
fixed bad queries in pubsub.sql file
author | Goffi <goffi@goffi.org> |
---|---|
date | Thu, 20 Aug 2015 14:06:49 +0200 |
parents | df1edebb0466 |
children | 05c875a13a62 |
line wrap: on
line diff
--- 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 */