Book Marx: Apply role-based access scheme.

1 files changed, 6 insertions, 3 deletions

diff --git a/schema.sql b/schema.sql
index ea5110f..ad773af 100644
--- a/schema.sql
+++ b/schema.sql
@@ -129,10 +129,8 @@ CREATE TABLE bookmarks INHERITS posts (
   uri         VARCHAR   NOT NULL,
   title       VARCHAR,
   description VARCHAR,
-  visibility  VARCHAR,
   PRIMARY KEY(id),
-  FOREIGN KEY(owner) REFERENCES users,
-  CHECK (visibility IN ('private', 'protected', 'public'))
+  FOREIGN KEY(owner) REFERENCES users
 );
 
 CREATE TABLE bookmark_tags(
@@ -251,5 +249,10 @@ CREATE VIEW user_visible_lazychat_messages AS
     FROM user_visible_posts uvp
     INNER JOIN lazychat_messages lm ON lm.id = uvp.message;
 
+CREATE VIEW user_visible_bookmarks AS
+  SELECT uvp.user, uvp.message
+    FROM user_visible_posts uvp
+    INNER JOIN bookmarks bm ON bm.id = uvp.message;
+
 ROLLBACK;
 --COMMIT;