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
--- 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');