Mercurial > libervia-pubsub

comparison db/pubsub.sql @ 260:f0cd02c032b3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
publish model management
author Goffi <goffi@goffi.org>
date Mon, 06 May 2013 00:26:37 +0200
parents 50f6ee966da8
children df1edebb0466
comparison
equal deleted inserted replaced
259:6fe7da6b4b32 260:f0cd02c032b3
11 access_model text NOT NULL DEFAULT 'open' 11 access_model text NOT NULL DEFAULT 'open'
12 CHECK (access_model IN ('open', 'roster')), 12 CHECK (access_model IN ('open', 'roster')),
13 persist_items boolean, 13 persist_items boolean,
14 deliver_payloads boolean NOT NULL DEFAULT TRUE, 14 deliver_payloads boolean NOT NULL DEFAULT TRUE,
15 send_last_published_item text NOT NULL DEFAULT 'on_sub' 15 send_last_published_item text NOT NULL DEFAULT 'on_sub'
16 CHECK (send_last_published_item IN ('never', 'on_sub')) 16 CHECK (send_last_published_item IN ('never', 'on_sub')),
17 publish_model text NOT NULL DEFAULT 'publishers'
18 CHECK (publish_model IN ('publishers', 'subscribers', 'open'))
17 ); 19 );
18 20
19 INSERT INTO nodes (node, node_type) values ('', 'collection'); 21 INSERT INTO nodes (node, node_type) values ('', 'collection');
20 22
21 CREATE TABLE affiliations ( 23 CREATE TABLE affiliations (