liquid_feedback_core

diff update/core-update.v4.2.0-v4.2.1.sql @ 616:ae53fc96c953
Added JSONB column "attr" to table "unit" for extended attributes of any kind
author: jbe
date: Tue Jul 28 18:57:20 2020 +0200 (2020-07-28)
parents: 5ae68278492f
children: 8e9d0878b5dc
     1.1 --- a/update/core-update.v4.2.0-v4.2.1.sql	Sun May 17 13:56:43 2020 +0200
     1.2 +++ b/update/core-update.v4.2.0-v4.2.1.sql	Tue Jul 28 18:57:20 2020 +0200
     1.3 @@ -4,6 +4,9 @@
     1.4  
     1.5  BEGIN;
     1.6  
     1.7 +ALTER TABLE "unit" ADD COLUMN "attr" JSONB NOT NULL DEFAULT '{}' CHECK (jsonb_typeof("attr") = 'object');
     1.8 +COMMENT ON COLUMN "unit"."attr" IS 'Opaque data structure to store any extended attributes used by frontend or middleware';
     1.9 +
    1.10  ALTER TABLE "unit" ADD COLUMN "member_weight" INT4;
    1.11  COMMENT ON COLUMN "unit"."member_weight" IS 'Sum of active members'' voting weight';
    1.12