Mercurial > libervia-pubsub
comparison db/sat_pubsub_update_7_8.sql @ 438:b5e1e8d93dd4
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 | |
| children |
comparison
equal
deleted
inserted
replaced
| 437:454f61a32427 | 438:b5e1e8d93dd4 |
|---|---|
| 1 -- we check version of the database before doing anything | |
| 2 -- and stop execution if not good | |
| 3 \set ON_ERROR_STOP | |
| 4 DO $$ | |
| 5 DECLARE ver text; | |
| 6 BEGIN | |
| 7 SELECT value INTO ver FROM metadata WHERE key='version'; | |
| 8 IF NOT FOUND OR ver!='7' THEN | |
| 9 RAISE EXCEPTION 'This update file needs to be applied on database schema version 7, you use version %',ver; | |
| 10 END IF; | |
| 11 END$$; | |
| 12 \unset ON_ERROR_STOP | |
| 13 -- end of version check | |
| 14 | |
| 15 /* new "overwrite_policy" option */ | |
| 16 ALTER TABLE nodes ADD COLUMN overwrite_policy text NOT NULL DEFAULT 'original_publisher' | |
| 17 CHECK (overwrite_policy IN ('original_publisher', 'any_publisher')); | |
| 18 | |
| 19 UPDATE metadata SET value='8' WHERE key='version'; |