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

     1  -- +goose Up
     2  
     3  ALTER TABLE proposals
     4        ADD COLUMN batch_id BYTEA,
     5        ADD COLUMN batch_terms JSONB DEFAULT '{}' NOT NULL,
     6        ALTER COLUMN terms DROP NOT NULL;
     7  
     8  CREATE INDEX ON proposals (batch_id);
     9  ALTER TYPE proposal_error ADD VALUE IF NOT EXISTS 'PROPOSAL_ERROR_PROPOSAL_IN_BATCH_REJECTED';
    10  ALTER TYPE proposal_error ADD VALUE IF NOT EXISTS 'PROPOSAL_ERROR_PROPOSAL_IN_BATCH_DECLINED';
    11  
    12  CREATE OR REPLACE VIEW proposals_current AS (
    13    SELECT DISTINCT ON (id) * FROM proposals ORDER BY id, vega_time DESC
    14  );
    15  
    16  ALTER TABLE votes ADD COLUMN per_market_equity_like_share_weight JSONB;
    17  
    18  CREATE OR REPLACE VIEW votes_current AS (
    19    SELECT DISTINCT ON (proposal_id, party_id) * FROM votes ORDER BY proposal_id, party_id, vega_time DESC
    20  );
    21  
    22  -- +goose Down
    23  
    24  DROP INDEX IF EXISTS proposals_idx_batch_id;
    25  DROP VIEW proposals_current;
    26  ALTER TABLE proposals
    27        DROP COLUMN IF EXISTS batch_id,
    28        DROP COLUMN IF EXISTS batch_terms;
    29  
    30  CREATE OR REPLACE VIEW proposals_current AS (
    31    SELECT DISTINCT ON (id) * FROM proposals ORDER BY id, vega_time DESC
    32  );
    33  
    34  DROP VIEW votes_current;
    35  ALTER TABLE votes DROP COLUMN per_market_equity_like_share_weight;
    36  
    37  CREATE OR REPLACE VIEW votes_current AS (
    38    SELECT DISTINCT ON (proposal_id, party_id) * FROM votes ORDER BY proposal_id, party_id, vega_time DESC
    39  );