Mercurial > libervia-pubsub

diff 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
line wrap: on
line diff
--- a/db/pubsub.sql	Sun May 27 15:36:06 2012 +0200
+++ b/db/pubsub.sql	Sun May 27 15:55:25 2012 +0200
@@ -27,6 +27,13 @@
     UNIQUE (entity_id, node_id)
 );
 
+CREATE TABLE node_groups_authorized (
+    node_groups_authorized_id serial PRIMARY KEY,
+    node_id integer NOT NULL references nodes ON DELETE CASCADE,
+    groupname text NOT NULL,
+    UNIQUE (node_id,groupname)
+);
+
 CREATE TABLE subscriptions (
     subscription_id serial PRIMARY KEY,
     entity_id integer NOT NULL REFERENCES entities ON DELETE CASCADE,