Mercurial > libervia-pubsub

comparison 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
comparison
equal deleted inserted replaced
437:454f61a32427 438:b5e1e8d93dd4
13 CHECK (access_model IN ('open', 'presence', 'publisher-roster', 'whitelist', 'publish-only', 'self-publisher')), 13 CHECK (access_model IN ('open', 'presence', 'publisher-roster', 'whitelist', 'publish-only', 'self-publisher')),
14 persist_items boolean, 14 persist_items boolean,
15 deliver_payloads boolean NOT NULL DEFAULT TRUE, 15 deliver_payloads boolean NOT NULL DEFAULT TRUE,
16 max_items integer NOT NULL DEFAULT 0 16 max_items integer NOT NULL DEFAULT 0
17 CHECK (max_items >= 0), 17 CHECK (max_items >= 0),
18 overwrite_policy text NOT NULL DEFAULT 'original_publisher'
19 CHECK (overwrite_policy IN ('original_publisher', 'any_publisher')),
18 serial_ids boolean NOT NULL DEFAULT FALSE, 20 serial_ids boolean NOT NULL DEFAULT FALSE,
19 consistent_publisher boolean NOT NULL DEFAULT FALSE, 21 consistent_publisher boolean NOT NULL DEFAULT FALSE,
20 fts_language text NOT NULL DEFAULT 'generic', 22 fts_language text NOT NULL DEFAULT 'generic',
21 send_last_published_item text NOT NULL DEFAULT 'on_sub' 23 send_last_published_item text NOT NULL DEFAULT 'on_sub'
22 CHECK (send_last_published_item IN ('never', 'on_sub')), 24 CHECK (send_last_published_item IN ('never', 'on_sub')),