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

     1  -- +goose Up
     2  
     3  ALTER TABLE orders
     4        RENAME COLUMN initial_peak_size TO peak_size;
     5  ALTER TABLE orders
     6        RENAME COLUMN minimum_peak_size TO minimum_visible_size;
     7  ALTER TABLE orders_live
     8        RENAME COLUMN initial_peak_size TO peak_size;
     9  ALTER TABLE orders_live
    10        RENAME COLUMN minimum_peak_size TO minimum_visible_size;
    11  
    12  drop view orders_current_versions;
    13  drop view orders_current_desc;
    14  drop view orders_current_desc_by_reference;
    15  drop view orders_current_desc_by_party;
    16  drop view orders_current_desc_by_market;
    17  
    18  CREATE OR REPLACE VIEW orders_current_versions AS (
    19     SELECT DISTINCT ON (id, version) * FROM orders ORDER BY id, version DESC, vega_time DESC
    20  );
    21  
    22  CREATE OR REPLACE VIEW orders_current_desc
    23   AS
    24  SELECT DISTINCT ON (orders.created_at, orders.id) *
    25  FROM orders
    26  ORDER BY orders.created_at DESC, orders.id, orders.vega_time DESC, orders.seq_num DESC;
    27  
    28  
    29  CREATE OR REPLACE VIEW orders_current_desc_by_market
    30   AS
    31  SELECT DISTINCT ON (orders.created_at, orders.market_id, orders.id) *
    32  FROM orders
    33  ORDER BY orders.created_at DESC, orders.market_id, orders.id, orders.vega_time DESC, orders.seq_num DESC;
    34  
    35  CREATE OR REPLACE VIEW orders_current_desc_by_party
    36  AS
    37  SELECT DISTINCT ON (orders.created_at, orders.party_id, orders.id) *
    38          FROM orders
    39          ORDER BY orders.created_at DESC, orders.party_id, orders.id, orders.vega_time DESC, orders.seq_num DESC;
    40  
    41  CREATE OR REPLACE VIEW orders_current_desc_by_reference
    42  AS
    43  SELECT DISTINCT ON (orders.created_at, orders.reference, orders.id) *
    44          FROM orders
    45          ORDER BY orders.created_at DESC, orders.reference, orders.id, orders.vega_time DESC, orders.seq_num DESC;
    46  
    47  
    48  -- +goose Down
    49  
    50  drop view orders_current_versions;
    51  drop view orders_current_desc;
    52  drop view orders_current_desc_by_reference;
    53  drop view orders_current_desc_by_party;
    54  drop view orders_current_desc_by_market;
    55  
    56  
    57  ALTER TABLE orders
    58        RENAME COLUMN peak_size TO initial_peak_size;
    59  ALTER TABLE orders
    60        RENAME COLUMN minimum_visible_size TO minimum_peak_size;
    61  ALTER TABLE orders_live
    62        RENAME COLUMN peak_size TO initial_peak_size;
    63  ALTER TABLE orders_live
    64        RENAME COLUMN minimum_visible_size TO minimum_peak_size;
    65  
    66  CREATE OR REPLACE VIEW orders_current_versions AS (
    67     SELECT DISTINCT ON (id, version) * FROM orders ORDER BY id, version DESC, vega_time DESC
    68  );
    69  
    70  CREATE VIEW orders_current_desc
    71   AS
    72  SELECT DISTINCT ON (orders.created_at, orders.id) *
    73  FROM orders
    74  ORDER BY orders.created_at DESC, orders.id, orders.vega_time DESC, orders.seq_num DESC;
    75  
    76  
    77  CREATE VIEW orders_current_desc_by_market
    78   AS
    79  SELECT DISTINCT ON (orders.created_at, orders.market_id, orders.id) *
    80  FROM orders
    81  ORDER BY orders.created_at DESC, orders.market_id, orders.id, orders.vega_time DESC, orders.seq_num DESC;
    82  
    83  CREATE VIEW orders_current_desc_by_party
    84  AS
    85  SELECT DISTINCT ON (orders.created_at, orders.party_id, orders.id) *
    86          FROM orders
    87          ORDER BY orders.created_at DESC, orders.party_id, orders.id, orders.vega_time DESC, orders.seq_num DESC;
    88  
    89  CREATE VIEW orders_current_desc_by_reference
    90  AS
    91  SELECT DISTINCT ON (orders.created_at, orders.reference, orders.id) *
    92          FROM orders
    93          ORDER BY orders.created_at DESC, orders.reference, orders.id, orders.vega_time DESC, orders.seq_num DESC;