github.com/0xPolygon/supernets2-node@v0.0.0-20230711153321-2fe574524eaa/db/migrations/pool/0001.sql (about)

     1  -- +migrate Down
     2  DROP SCHEMA IF EXISTS pool CASCADE;
     3  
     4  -- +migrate Up
     5  CREATE SCHEMA pool;
     6  
     7  CREATE TABLE pool.transaction
     8  (
     9      hash                   VARCHAR PRIMARY KEY,
    10      encoded                VARCHAR,
    11      decoded                jsonb,
    12      status                 varchar(15),
    13      gas_price              DECIMAL(78, 0),
    14      nonce                  DECIMAL(78, 0),
    15      is_claims              BOOLEAN,
    16      cumulative_gas_used    BIGINT,
    17      used_keccak_hashes     INTEGER,
    18      used_poseidon_hashes   INTEGER,
    19      used_poseidon_paddings INTEGER,
    20      used_mem_aligns        INTEGER,
    21      used_arithmetics       INTEGER,
    22      used_binaries          INTEGER,
    23      used_steps             INTEGER,
    24      failed_counter         DECIMAL(78, 0) DEFAULT 0,
    25      received_at            TIMESTAMP WITH TIME ZONE NOT NULL,
    26      from_address           varchar                  NOT NULL
    27  );
    28  
    29  CREATE INDEX idx_state_gas_price_nonce ON pool.transaction (status, gas_price, nonce);
    30  CREATE INDEX idx_failed_counter ON pool.transaction (failed_counter);
    31  
    32  CREATE TABLE pool.gas_price
    33  (
    34      item_id   SERIAL PRIMARY KEY,
    35      price     DECIMAL(78, 0),
    36      timestamp TIMESTAMP WITH TIME ZONE NOT NULL
    37  );