Lafargue: Fix semi-private posting.

1 files changed, 8 insertions, 0 deletions

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