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

     1  -- +goose Up
     2  
     3  ALTER TABLE markets ADD COLUMN IF NOT EXISTS enable_tx_reordering bool default FALSE;
     4  ALTER TABLE markets_current ADD COLUMN IF NOT EXISTS enable_tx_reordering bool default FALSE;
     5  
     6  -- +goose StatementBegin
     7  CREATE OR REPLACE FUNCTION update_current_markets()
     8      RETURNS TRIGGER
     9      LANGUAGE PLPGSQL AS
    10  $$
    11  BEGIN
    12  INSERT INTO markets_current(id,tx_hash,vega_time,instrument_id,tradable_instrument,decimal_places,fees,opening_auction,price_monitoring_settings,liquidity_monitoring_parameters,trading_mode,state,market_timestamps,position_decimal_places,lp_price_range, linear_slippage_factor, quadratic_slippage_factor, parent_market_id, insurance_pool_fraction, liquidity_sla_parameters, liquidation_strategy, mark_price_configuration, tick_size, enable_tx_reordering)
    13  VALUES (NEW.id,NEW.tx_hash,NEW.vega_time,NEW.instrument_id,NEW.tradable_instrument,NEW.decimal_places,NEW.fees,NEW.opening_auction,NEW.price_monitoring_settings,NEW.liquidity_monitoring_parameters,NEW.trading_mode,NEW.state,NEW.market_timestamps,NEW.position_decimal_places,NEW.lp_price_range, NEW.linear_slippage_factor, NEW.quadratic_slippage_factor, NEW.parent_market_id, NEW.insurance_pool_fraction, NEW.liquidity_sla_parameters, NEW.liquidation_strategy, NEW.mark_price_configuration, NEW.tick_size, NEW.enable_tx_reordering)
    14      ON CONFLICT(id) DO UPDATE SET
    15      tx_hash=EXCLUDED.tx_hash,
    16                             instrument_id=EXCLUDED.instrument_id,
    17                             tradable_instrument=EXCLUDED.tradable_instrument,
    18                             decimal_places=EXCLUDED.decimal_places,
    19                             fees=EXCLUDED.fees,
    20                             opening_auction=EXCLUDED.opening_auction,
    21                             price_monitoring_settings=EXCLUDED.price_monitoring_settings,
    22                             liquidity_monitoring_parameters=EXCLUDED.liquidity_monitoring_parameters,
    23                             trading_mode=EXCLUDED.trading_mode,
    24                             state=EXCLUDED.state,
    25                             market_timestamps=EXCLUDED.market_timestamps,
    26                             position_decimal_places=EXCLUDED.position_decimal_places,
    27                             lp_price_range=EXCLUDED.lp_price_range,
    28                             linear_slippage_factor=EXCLUDED.linear_slippage_factor,
    29                             quadratic_slippage_factor=EXCLUDED.quadratic_slippage_factor,
    30                             vega_time=EXCLUDED.vega_time,
    31                             parent_market_id=EXCLUDED.parent_market_id,
    32                             insurance_pool_fraction=EXCLUDED.insurance_pool_fraction,
    33                             liquidity_sla_parameters=EXCLUDED.liquidity_sla_parameters,
    34                             liquidation_strategy=EXCLUDED.liquidation_strategy,
    35                             mark_price_configuration=EXCLUDED.mark_price_configuration,
    36                             tick_size=EXCLUDED.tick_size,
    37                             enable_tx_reordering=EXCLUDED.enable_tx_reordering;
    38  RETURN NULL;
    39  END;
    40  $$;
    41  -- +goose StatementEnd
    42  
    43  
    44  -- +goose Down
    45  ALTER TABLE markets DROP COLUMN IF EXISTS enable_tx_reordering;
    46  ALTER TABLE markets_current DROP COLUMN IF EXISTS enable_tx_reordering;
    47  
    48  -- +goose StatementBegin
    49  CREATE OR REPLACE FUNCTION update_current_markets()
    50      RETURNS TRIGGER
    51      LANGUAGE PLPGSQL AS
    52  $$
    53  BEGIN
    54  INSERT INTO markets_current(id,tx_hash,vega_time,instrument_id,tradable_instrument,decimal_places,fees,opening_auction,price_monitoring_settings,liquidity_monitoring_parameters,trading_mode,state,market_timestamps,position_decimal_places,lp_price_range, linear_slippage_factor, quadratic_slippage_factor, parent_market_id, insurance_pool_fraction, liquidity_sla_parameters, liquidation_strategy, mark_price_configuration, tick_size)
    55  VALUES (NEW.id,NEW.tx_hash,NEW.vega_time,NEW.instrument_id,NEW.tradable_instrument,NEW.decimal_places,NEW.fees,NEW.opening_auction,NEW.price_monitoring_settings,NEW.liquidity_monitoring_parameters,NEW.trading_mode,NEW.state,NEW.market_timestamps,NEW.position_decimal_places,NEW.lp_price_range, NEW.linear_slippage_factor, NEW.quadratic_slippage_factor, NEW.parent_market_id, NEW.insurance_pool_fraction, NEW.liquidity_sla_parameters, NEW.liquidation_strategy, NEW.mark_price_configuration, NEW.tick_size)
    56      ON CONFLICT(id) DO UPDATE SET
    57      tx_hash=EXCLUDED.tx_hash,
    58                             instrument_id=EXCLUDED.instrument_id,
    59                             tradable_instrument=EXCLUDED.tradable_instrument,
    60                             decimal_places=EXCLUDED.decimal_places,
    61                             fees=EXCLUDED.fees,
    62                             opening_auction=EXCLUDED.opening_auction,
    63                             price_monitoring_settings=EXCLUDED.price_monitoring_settings,
    64                             liquidity_monitoring_parameters=EXCLUDED.liquidity_monitoring_parameters,
    65                             trading_mode=EXCLUDED.trading_mode,
    66                             state=EXCLUDED.state,
    67                             market_timestamps=EXCLUDED.market_timestamps,
    68                             position_decimal_places=EXCLUDED.position_decimal_places,
    69                             lp_price_range=EXCLUDED.lp_price_range,
    70                             linear_slippage_factor=EXCLUDED.linear_slippage_factor,
    71                             quadratic_slippage_factor=EXCLUDED.quadratic_slippage_factor,
    72                             vega_time=EXCLUDED.vega_time,
    73                             parent_market_id=EXCLUDED.parent_market_id,
    74                             insurance_pool_fraction=EXCLUDED.insurance_pool_fraction,
    75                             liquidity_sla_parameters=EXCLUDED.liquidity_sla_parameters,
    76                             liquidation_strategy=EXCLUDED.liquidation_strategy,
    77                             mark_price_configuration=EXCLUDED.mark_price_configuration,
    78                             tick_size=EXCLUDED.tick_size;
    79  RETURN NULL;
    80  END;
    81  $$;
    82  -- +goose StatementEnd