diff db/pubsub.sql @ 248:50f6ee966da8

item are gotten according to item's access model in getItems
author Goffi <goffi@goffi.org>
date Sun, 03 Jun 2012 15:57:28 +0200
parents 3ecc94407e36
children f0cd02c032b3
line wrap: on
line diff
--- a/db/pubsub.sql	Thu May 31 00:24:20 2012 +0200
+++ b/db/pubsub.sql	Sun Jun 03 15:57:28 2012 +0200
@@ -53,8 +53,8 @@
     item text NOT NULL,
     publisher text NOT NULL,
     data text,
-    access_model text NOT NULL DEFAULT 'default'
-        CHECK (access_model IN ('default','open', 'roster')),
+    access_model text NOT NULL DEFAULT 'open'
+        CHECK (access_model IN ('open', 'roster')),
     date timestamp with time zone NOT NULL DEFAULT now(),
     UNIQUE (node_id, item)
 );