diff options
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 9 |
1 files changed, 8 insertions, 1 deletions
@@ -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, |