Mercurial > libervia-pubsub

comparison db/pubsub.sql @ 359:1d93f94feee3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
psql (schema): fixed forgotten comma
author Goffi <goffi@goffi.org>
date Wed, 11 Oct 2017 19:15:14 +0200
parents 4d4575911060
children 6350622d9eb9
comparison
equal deleted inserted replaced
358:9e40fc16f4df 359:1d93f94feee3
14 persist_items boolean, 14 persist_items boolean,
15 deliver_payloads boolean NOT NULL DEFAULT TRUE, 15 deliver_payloads boolean NOT NULL DEFAULT TRUE,
16 send_last_published_item text NOT NULL DEFAULT 'on_sub' 16 send_last_published_item text NOT NULL DEFAULT 'on_sub'
17 CHECK (send_last_published_item IN ('never', 'on_sub')), 17 CHECK (send_last_published_item IN ('never', 'on_sub')),
18 publish_model text NOT NULL DEFAULT 'publishers' 18 publish_model text NOT NULL DEFAULT 'publishers'
19 CHECK (publish_model IN ('publishers', 'subscribers', 'open')) 19 CHECK (publish_model IN ('publishers', 'subscribers', 'open')),
20 schema xml; 20 schema xml;
21 ); 21 );
22 22
23 /* we need 2 partial indexes to manage NULL value for PEP */ 23 /* we need 2 partial indexes to manage NULL value for PEP */
24 CREATE UNIQUE INDEX nodes_node_pep_key_not_null ON nodes(node, pep) WHERE pep IS NOT NULL; 24 CREATE UNIQUE INDEX nodes_node_pep_key_not_null ON nodes(node, pep) WHERE pep IS NOT NULL;