Mercurial > libervia-pubsub

comparison db/pubsub.sql @ 360:6350622d9eb9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
psql (schema): fixed bad semi-colon
author Goffi <goffi@goffi.org>
date Fri, 13 Oct 2017 20:57:47 +0200
parents 1d93f94feee3
children a772f7dac930
comparison
equal deleted inserted replaced
359:1d93f94feee3 360:6350622d9eb9
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;
25 CREATE UNIQUE INDEX nodes_node_pep_key_null ON nodes(node) WHERE pep IS NULL; 25 CREATE UNIQUE INDEX nodes_node_pep_key_null ON nodes(node) WHERE pep IS NULL;