code.vegaprotocol.io/vega@v0.79.0/datanode/networkhistory/testdata/testmigration.sql (about)

     1  -- +goose Up
     2  ALTER TABLE trades ADD COLUMN testref text;
     3  Update trades set testref = 'nondefaulttestref';
     4  
     5  ALTER TABLE trades ALTER COLUMN testref SET DEFAULT 'defaulttestref';
     6  
     7  
     8  create table transfers2 (
     9                              id bytea not null,
    10                              tx_hash bytea not null,
    11                              vega_time timestamp with time zone not null,
    12                              from_account_id bytea NOT NULL REFERENCES accounts(id),
    13                              to_account_id bytea NOT NULL REFERENCES accounts(id),
    14                              primary key (id, vega_time)
    15  );
    16  
    17  create index on transfers2 (from_account_id);
    18  create index on transfers2 (to_account_id);
    19  
    20  -- +goose Down
    21  ALTER TABLE trades DROP COLUMN testref;
    22  DROP TABLE transfers2;