From d22a61311a7d19667e781e6d8026e24395ef3087 Mon Sep 17 00:00:00 2001
From: Matthias Andreas Benkard <code@mail.matthias.benkard.de>
Date: Tue, 10 Apr 2012 17:35:38 +0200
Subject: Lafargue: Add XMPP notification capability.

---
 schema.sql | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

(limited to 'schema.sql')

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,
-- 
cgit v1.2.3

