db.store.h2.V0_400_1__init.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of yaci-store-script Show documentation

Yaci Stroe Script Module

The newest version!

drop table if exists script;
create table script
(
    script_hash   varchar(56) not null
        primary key,
    script_type   varchar(30),
    content json,
    create_datetime  timestamp,
    update_datetime  timestamp
);

drop table if exists transaction_scripts;
create table transaction_scripts
(
    id                    uuid  not null
        primary key,
    slot                  bigint,
    block_hash            varchar(64),
    tx_hash               varchar(64) not null,
    script_hash           varchar(56),
    script_type           smallint,
    datum_hash            varchar(64),
    redeemer_cbor         clob,
    unit_mem              bigint,
    unit_steps            bigint,
    purpose               varchar(20),
    redeemer_index        int,
    redeemer_datahash     varchar(64),
    block                 bigint,
    block_time            bigint,
    update_datetime       timestamp
);

CREATE INDEX if not exists idx_txn_scripts_tx_hash
    ON transaction_scripts(tx_hash);

drop table if exists datum;
create table datum (
    hash   varchar(64) not null
        primary key,
    datum clob,
    created_at_tx varchar(64),
    create_datetime timestamp,
    update_datetime timestamp
);

CREATE INDEX if not exists idx_datum_hash
    ON datum(hash);