db.sql

CREATE TABLE `swaps`
(
    `id`          int(11)     NOT NULL AUTO_INCREMENT,
    `address`     varchar(42)          DEFAULT NULL,
    `amount`      decimal(36, 18)      DEFAULT NULL,
    `fees`        decimal(36, 18)      DEFAULT NULL,
    `uuid`        varchar(36)          DEFAULT NULL,
    `time`        timestamp   NOT NULL DEFAULT current_timestamp(),
    `idena_tx`    varchar(66)          DEFAULT NULL,
    `bsc_tx`      varchar(66)          DEFAULT NULL,
    `status`      varchar(20) NOT NULL DEFAULT 'Pending',
    `type`        int(1)      NOT NULL DEFAULT 0,
    `mined`       int(1)               DEFAULT NULL,
    `fail_reason` varchar(255)         DEFAULT NULL,
    PRIMARY KEY (`id`)
);
ALTER TABLE `swaps`
    ADD UNIQUE INDEX `swaps_uuid_unique_idx` (`uuid`);
ALTER TABLE `swaps`
    ADD INDEX `swaps_time_idx` (`time`);
ALTER TABLE `swaps`
    ADD INDEX `swaps_status_idx` (`status`);

CREATE TABLE `used_txs`
(
    `id`         int(11)     NOT NULL AUTO_INCREMENT,
    `blockchain` varchar(5) DEFAULT NULL,
    `tx_hash`    varchar(66) NOT NULL,
    PRIMARY KEY (`id`)
);
ALTER TABLE `used_txs`
    ADD UNIQUE INDEX `used_txs_blockchain_tx_hash_unique_idx` (`tx_hash`, `blockchain`);

CREATE TABLE `pending_refunds`
(
    `id`      int(11)         NOT NULL,
    `address` varchar(42)     NOT NULL,
    `amount`  decimal(36, 18) NOT NULL,
    PRIMARY KEY (`id`)
);

CREATE TABLE `refunds`
(
    `idena_tx` varchar(66)        DEFAULT NULL,
    `time`     timestamp NOT NULL DEFAULT current_timestamp()
)