From 202ef602aa8672c74619cd2db47dc3e1bab747a6 Mon Sep 17 00:00:00 2001
From: Matthias Andreas Benkard <code@mail.matthias.benkard.de>
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

