Mercurial > libervia-pubsub

diff db/pubsub.sql @ 438:b5e1e8d93dd4

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
backend, pgsql: new `overwrite_policy` node setting: /!\ pgsql schema needs to be updated /!\ this settings can be set currently to 2 values: - `original_publisher` (default), when only original publisher of an item can overwrite it (except node owner/admin) - `any_publisher` when any entity with publishing right can overwrite any item.
author Goffi <goffi@goffi.org>
date Sat, 27 Feb 2021 21:20:32 +0100
parents 920440200570
children c57b9ede1381
line wrap: on
line diff
--- a/db/pubsub.sql	Mon Feb 08 19:01:29 2021 +0100
+++ b/db/pubsub.sql	Sat Feb 27 21:20:32 2021 +0100
@@ -15,6 +15,8 @@
     deliver_payloads boolean NOT NULL DEFAULT TRUE,
     max_items integer NOT NULL DEFAULT 0
         CHECK (max_items >= 0),
+	overwrite_policy text NOT NULL DEFAULT 'original_publisher'
+		CHECK (overwrite_policy IN ('original_publisher', 'any_publisher')),
     serial_ids boolean NOT NULL DEFAULT FALSE,
     consistent_publisher boolean NOT NULL DEFAULT FALSE,
     fts_language text NOT NULL DEFAULT 'generic',