Mercurial > libervia-pubsub

comparison db/pubsub.sql @ 240:70c8bb90d75f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added access_model to config, default to 'open'
author Goffi <goffi@goffi.org>
date Tue, 22 May 2012 21:21:57 +0200
parents 274a45d2a5ab
children 42048e37699e
comparison
equal deleted inserted replaced
239:2b50e4664d74 240:70c8bb90d75f
6 CREATE TABLE nodes ( 6 CREATE TABLE nodes (
7 node_id serial PRIMARY KEY, 7 node_id serial PRIMARY KEY,
8 node text NOT NULL UNIQUE, 8 node text NOT NULL UNIQUE,
9 node_type text NOT NULL DEFAULT 'leaf' 9 node_type text NOT NULL DEFAULT 'leaf'
10 CHECK (node_type IN ('leaf', 'collection')), 10 CHECK (node_type IN ('leaf', 'collection')),
11 access_model text NOT NULL DEFAULT 'open'
12 CHECK (access_model IN ('open', 'roster')),
11 persist_items boolean, 13 persist_items boolean,
12 deliver_payloads boolean NOT NULL DEFAULT TRUE, 14 deliver_payloads boolean NOT NULL DEFAULT TRUE,
13 send_last_published_item text NOT NULL DEFAULT 'on_sub' 15 send_last_published_item text NOT NULL DEFAULT 'on_sub'
14 CHECK (send_last_published_item IN ('never', 'on_sub')) 16 CHECK (send_last_published_item IN ('never', 'on_sub'))
15 ); 17 );