Mercurial > libervia-pubsub
comparison 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 |
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'); |