--- a/db/pubsub.sql	Sun May 27 15:55:25 2012 +0200
+++ b/db/pubsub.sql	Wed May 30 01:04:15 2012 +0200
@@ -53,6 +53,16 @@
     item text NOT NULL,
     publisher text NOT NULL,
     data text,
+    access_model text NOT NULL DEFAULT 'default'
+        CHECK (access_model IN ('default','open', 'roster')),
     date timestamp with time zone NOT NULL DEFAULT now(),
     UNIQUE (node_id, item)
 );
+
+CREATE TABLE item_groups_authorized (
+    item_groups_authorized_id serial PRIMARY KEY,
+    item_id integer NOT NULL references items ON DELETE CASCADE,
+    groupname text NOT NULL,
+    UNIQUE (item_id,groupname)
+);
+