Mercurial > libervia-pubsub

diff db/pubsub.sql @ 350:4d4575911060

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
sql (PostgreSQL): schema update: - added version check on top of update files, SQL will not be applied if the version is not the one expected - new db schema version (3) - added "presence" access_model in nodes - added "schema" column in nodes - converted items data to xml, this will allow the use of all XML functions PostgreSQL now needs to have been compiled with --with-libxml .
author Goffi <goffi@goffi.org>
date Fri, 08 Sep 2017 08:02:04 +0200
parents 98409ef42c94
children 1d93f94feee3
line wrap: on
line diff
--- a/db/pubsub.sql	Sun Aug 27 20:33:39 2017 +0200
+++ b/db/pubsub.sql	Fri Sep 08 08:02:04 2017 +0200
@@ -10,13 +10,14 @@
     node_type text NOT NULL DEFAULT 'leaf'
         CHECK (node_type IN ('leaf', 'collection')),
     access_model text NOT NULL DEFAULT 'open'
-        CHECK (access_model IN ('open', 'publisher-roster', 'whitelist', 'publish-only', 'self-publisher')),
+        CHECK (access_model IN ('open', 'presence', 'publisher-roster', 'whitelist', 'publish-only', 'self-publisher')),
     persist_items boolean,
     deliver_payloads boolean NOT NULL DEFAULT TRUE,
     send_last_published_item text NOT NULL DEFAULT 'on_sub'
         CHECK (send_last_published_item IN ('never', 'on_sub')),
     publish_model text NOT NULL DEFAULT 'publishers'
         CHECK (publish_model IN ('publishers', 'subscribers', 'open'))
+    schema xml;
 );
 
 /* we need 2 partial indexes to manage NULL value for PEP */
@@ -59,7 +60,7 @@
     node_id integer NOT NULL REFERENCES nodes ON DELETE CASCADE,
     item text NOT NULL,
     publisher text NOT NULL,
-    data text,
+    data xml,
     access_model text NOT NULL DEFAULT 'open'
         CHECK (access_model IN ('open', 'publisher-roster', 'whitelist')),
     date timestamp with time zone NOT NULL DEFAULT now(),
@@ -99,4 +100,4 @@
 	value text
 );
 
-INSERT INTO metadata VALUES ('version', '2');
+INSERT INTO metadata VALUES ('version', '3');