Mercurial > libervia-pubsub
diff db/pubsub.sql @ 466:0d38c3529972
psql: schema update (9) to add `roster` table
author | Goffi <goffi@goffi.org> |
---|---|
date | Fri, 15 Oct 2021 13:40:59 +0200 |
parents | c57b9ede1381 |
children | b544109ab4c4 |
line wrap: on
line diff
--- a/db/pubsub.sql Fri Oct 15 13:40:59 2021 +0200 +++ b/db/pubsub.sql Fri Oct 15 13:40:59 2021 +0200 @@ -138,10 +138,20 @@ FOR EACH ROW EXECUTE PROCEDURE update_data_fts(); +/* Roster */ + +CREATE TABLE roster ( + roster_id serial PRIMARY KEY, + jid text NOT NULL UNIQUE, + version text, + updated timestamp with time zone NOT NULL, + roster xml NOT NULL +); + CREATE TABLE metadata ( key text PRIMARY KEY, value text ); -INSERT INTO metadata VALUES ('version', '8'); +INSERT INTO metadata VALUES ('version', '9');