Mercurial > libervia-pubsub

comparison db/pubsub.sql @ 243:42048e37699e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added experimental roster access_model (use remote_roster)
author Goffi <goffi@goffi.org>
date Sun, 27 May 2012 15:55:25 +0200
parents 70c8bb90d75f
children 3ecc94407e36
comparison
equal deleted inserted replaced
242:a6170637690d 243:42048e37699e
25 affiliation text NOT NULL 25 affiliation text NOT NULL
26 CHECK (affiliation IN ('outcast', 'publisher', 'owner')), 26 CHECK (affiliation IN ('outcast', 'publisher', 'owner')),
27 UNIQUE (entity_id, node_id) 27 UNIQUE (entity_id, node_id)
28 ); 28 );
29 29
30 CREATE TABLE node_groups_authorized (
31 node_groups_authorized_id serial PRIMARY KEY,
32 node_id integer NOT NULL references nodes ON DELETE CASCADE,
33 groupname text NOT NULL,
34 UNIQUE (node_id,groupname)
35 );
36
30 CREATE TABLE subscriptions ( 37 CREATE TABLE subscriptions (
31 subscription_id serial PRIMARY KEY, 38 subscription_id serial PRIMARY KEY,
32 entity_id integer NOT NULL REFERENCES entities ON DELETE CASCADE, 39 entity_id integer NOT NULL REFERENCES entities ON DELETE CASCADE,
33 resource text, 40 resource text,
34 node_id integer NOT NULL REFERENCES nodes ON delete CASCADE, 41 node_id integer NOT NULL REFERENCES nodes ON delete CASCADE,