From d22a61311a7d19667e781e6d8026e24395ef3087 Mon Sep 17 00:00:00 2001 From: Matthias Andreas Benkard 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