Mercurial > libervia-pubsub

comparison db/pubsub.sql @ 466:0d38c3529972

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
comparison
equal deleted inserted replaced
465:9af0ef2c145c 466:0d38c3529972
136 CREATE TRIGGER items_fts_tsvector_update 136 CREATE TRIGGER items_fts_tsvector_update
137 BEFORE INSERT OR UPDATE OF data_fts_cfg,data ON items 137 BEFORE INSERT OR UPDATE OF data_fts_cfg,data ON items
138 FOR EACH ROW 138 FOR EACH ROW
139 EXECUTE PROCEDURE update_data_fts(); 139 EXECUTE PROCEDURE update_data_fts();
140 140
141 /* Roster */
142
143 CREATE TABLE roster (
144 roster_id serial PRIMARY KEY,
145 jid text NOT NULL UNIQUE,
146 version text,
147 updated timestamp with time zone NOT NULL,
148 roster xml NOT NULL
149 );
150
141 151
142 CREATE TABLE metadata ( 152 CREATE TABLE metadata (
143 key text PRIMARY KEY, 153 key text PRIMARY KEY,
144 value text 154 value text
145 ); 155 );
146 156
147 INSERT INTO metadata VALUES ('version', '8'); 157 INSERT INTO metadata VALUES ('version', '9');