code.vegaprotocol.io/vega@v0.79.0/datanode/sqlstore/migrations/0086_party_profile.sql (about)

     1  -- +goose Up
     2  
     3  ALTER TABLE parties
     4    ADD COLUMN IF NOT EXISTS alias VARCHAR(32) NOT NULL DEFAULT '';
     5  
     6  ALTER TABLE parties
     7    ADD COLUMN IF NOT EXISTS metadata JSONB;
     8  
     9  UPDATE parties SET alias = 'network' WHERE id = '\x03';
    10  
    11  -- +goose Down
    12  
    13  ALTER TABLE parties
    14    DROP COLUMN IF EXISTS alias;
    15  
    16  ALTER TABLE parties
    17    DROP COLUMN IF EXISTS metadata;