go-cyber/networks/local/cyberindex/schema/07-wasm.sql

CREATE TABLE contracts
(
    address       TEXT                        NOT NULL UNIQUE PRIMARY KEY,
    code_id       BIGINT                      NOT NULL,
    creator       TEXT                        NOT NULL DEFAULT '',
    admin         TEXT                        NOT NULL DEFAULT '',
    label         TEXT                        NOT NULL DEFAULT '',
    creation_time TEXT                        NOT NULL DEFAULT '',
    tx            BIGINT                      NOT NULL DEFAULT 0,
    gas           BIGINT                      NOT NULL DEFAULT 0,
    fees          BIGINT                      NOT NULL DEFAULT 0,
    height        BIGINT                      NOT NULL
);

CREATE INDEX contracts_code_id_index ON contracts (code_id);
CREATE INDEX contracts_creator_index ON contracts (creator);