Lafargue: Add XMPP notification capability.

1 files changed, 8 insertions, 1 deletions

diff --git a/schema.sql b/schema.sql
index c12f73e..f1f07fc 100644
--- a/schema.sql
+++ b/schema.sql
@@ -34,9 +34,16 @@ CREATE TABLE user_nicknames(
   PRIMARY KEY(nickname),
   FOREIGN KEY("user") REFERENCES users
 );
-
 CREATE INDEX user_nicknames_user ON user_nicknames ("user");
 
+CREATE TABLE user_jids(
+  "user" INTEGER NOT NULL,
+  jid    VARCHAR NOT NULL,
+  PRIMARY KEY("user", jid),
+  FOREIGN KEY("user") REFERENCES users
+);
+CREATE INDEX user_jids_user ON user_jids ("user");
+
 CREATE TABLE page_keys(
   "user" INTEGER NOT NULL,
   page   VARCHAR NOT NULL,