From 202ef602aa8672c74619cd2db47dc3e1bab747a6 Mon Sep 17 00:00:00 2001 From: Matthias Andreas Benkard Date: Sat, 18 Aug 2012 16:29:03 +0200 Subject: Lafargue: Fix semi-private posting. --- schema.sql | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql index 984fdea..ae843f8 100644 --- a/schema.sql +++ b/schema.sql @@ -165,6 +165,14 @@ CREATE TABLE lazychat_references( FOREIGN KEY(referee) REFERENCES lazychat_messages ); +CREATE TABLE user_default_target( + "user" INTEGER NOT NULL, + target INTEGER NOT NULL, + PRIMARY KEY("user", target), + FOREIGN KEY("user") REFERENCES users, + FOREIGN KEY(target) REFERENCES roles +); + CREATE VIEW effective_role_subroles AS WITH RECURSIVE t(superrole, subrole) AS ( SELECT id, id -- cgit v1.2.3