bridge/app/server/prisma/migrations/20241125192846_deposit_action/migration.sql

-- CreateTable
CREATE TABLE "Network" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "display_name" TEXT,
    "internal_name" TEXT,
    "native_currency" TEXT,
    "is_testnet" BOOLEAN,
    "is_featured" BOOLEAN,
    "logo" TEXT,
    "chain_id" TEXT,
    "type" TEXT,
    "average_completion_time" TEXT,
    "transaction_explorer_template" TEXT,
    "account_explorer_template" TEXT,
    "listing_date" DATETIME
);

-- CreateTable
CREATE TABLE "Currency" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "name" TEXT NOT NULL,
    "asset" TEXT NOT NULL,
    "logo" TEXT,
    "contract_address" TEXT,
    "decimals" INTEGER,
    "price_in_usd" REAL,
    "precision" INTEGER,
    "is_native" BOOLEAN,
    "listing_date" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "network_id" INTEGER NOT NULL,
    CONSTRAINT "Currency_network_id_fkey" FOREIGN KEY ("network_id") REFERENCES "Network" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
);

-- CreateTable
CREATE TABLE "DepositAction" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "type" TEXT DEFAULT 'transfer',
    "status" TEXT NOT NULL,
    "from" TEXT NOT NULL,
    "to" TEXT NOT NULL,
    "amount" REAL NOT NULL,
    "transaction_hash" TEXT NOT NULL,
    "max_confirmations" INTEGER NOT NULL,
    "confirmations" INTEGER NOT NULL,
    "created_date" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "timestamp" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "network_id" INTEGER NOT NULL,
    "currency_id" INTEGER NOT NULL,
    "swap_id" TEXT NOT NULL,
    CONSTRAINT "DepositAction_network_id_fkey" FOREIGN KEY ("network_id") REFERENCES "Network" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
    CONSTRAINT "DepositAction_currency_id_fkey" FOREIGN KEY ("currency_id") REFERENCES "Currency" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
    CONSTRAINT "DepositAction_swap_id_fkey" FOREIGN KEY ("swap_id") REFERENCES "Swap" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
);

-- CreateTable
CREATE TABLE "Swap" (
    "id" TEXT NOT NULL PRIMARY KEY,
    "created_date" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "source_network_id" INTEGER NOT NULL,
    "source_exchange" TEXT,
    "source_asset_id" INTEGER NOT NULL,
    "source_address" TEXT NOT NULL,
    "destination_network_id" INTEGER NOT NULL,
    "destination_exchange" TEXT,
    "destination_asset_id" INTEGER NOT NULL,
    "destination_address" TEXT NOT NULL,
    "refuel" BOOLEAN NOT NULL,
    "use_deposit_address" BOOLEAN NOT NULL,
    "use_teleporter" BOOLEAN DEFAULT false,
    "requested_amount" REAL NOT NULL,
    "status" TEXT NOT NULL,
    "fail_reason" TEXT,
    "metadata_sequence_number" INTEGER,
    "deposit_address" TEXT,
    CONSTRAINT "Swap_source_network_id_fkey" FOREIGN KEY ("source_network_id") REFERENCES "Network" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
    CONSTRAINT "Swap_source_asset_id_fkey" FOREIGN KEY ("source_asset_id") REFERENCES "Currency" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
    CONSTRAINT "Swap_destination_network_id_fkey" FOREIGN KEY ("destination_network_id") REFERENCES "Network" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
    CONSTRAINT "Swap_destination_asset_id_fkey" FOREIGN KEY ("destination_asset_id") REFERENCES "Currency" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
);

-- CreateTable
CREATE TABLE "Transaction" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "type" TEXT DEFAULT 'transfer',
    "status" TEXT NOT NULL,
    "from" TEXT NOT NULL,
    "to" TEXT NOT NULL,
    "amount" REAL NOT NULL,
    "transaction_hash" TEXT NOT NULL,
    "max_confirmations" INTEGER NOT NULL,
    "confirmations" INTEGER NOT NULL,
    "created_date" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "timestamp" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "network_id" INTEGER NOT NULL,
    "currency_id" INTEGER NOT NULL,
    "swap_id" TEXT NOT NULL,
    CONSTRAINT "Transaction_network_id_fkey" FOREIGN KEY ("network_id") REFERENCES "Network" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
    CONSTRAINT "Transaction_currency_id_fkey" FOREIGN KEY ("currency_id") REFERENCES "Currency" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
    CONSTRAINT "Transaction_swap_id_fkey" FOREIGN KEY ("swap_id") REFERENCES "Swap" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
);

-- CreateTable
CREATE TABLE "Quote" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "swap_id" TEXT NOT NULL,
    "receive_amount" REAL NOT NULL,
    "min_receive_amount" REAL NOT NULL,
    "blockchain_fee" REAL NOT NULL,
    "service_fee" REAL NOT NULL,
    "avg_completion_time" TEXT NOT NULL,
    "slippage" REAL NOT NULL,
    "total_fee" REAL NOT NULL,
    "total_fee_in_usd" REAL NOT NULL,
    CONSTRAINT "Quote_swap_id_fkey" FOREIGN KEY ("swap_id") REFERENCES "Swap" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
);

-- CreateTable
CREATE TABLE "RpcNode" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "url" TEXT NOT NULL,
    "network_id" INTEGER NOT NULL,
    CONSTRAINT "RpcNode_network_id_fkey" FOREIGN KEY ("network_id") REFERENCES "Network" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
);

-- CreateIndex
CREATE UNIQUE INDEX "Network_internal_name_key" ON "Network"("internal_name");

-- CreateIndex
CREATE INDEX "Currency_network_id_idx" ON "Currency"("network_id");

-- CreateIndex
CREATE INDEX "Currency_asset_idx" ON "Currency"("asset");

-- CreateIndex
CREATE UNIQUE INDEX "Currency_network_id_asset_key" ON "Currency"("network_id", "asset");

-- CreateIndex
CREATE INDEX "DepositAction_swap_id_idx" ON "DepositAction"("swap_id");

-- CreateIndex
CREATE INDEX "DepositAction_transaction_hash_idx" ON "DepositAction"("transaction_hash");

-- CreateIndex
CREATE INDEX "DepositAction_currency_id_idx" ON "DepositAction"("currency_id");

-- CreateIndex
CREATE INDEX "DepositAction_network_id_idx" ON "DepositAction"("network_id");

-- CreateIndex
CREATE INDEX "Swap_id_idx" ON "Swap"("id");

-- CreateIndex
CREATE INDEX "Transaction_swap_id_idx" ON "Transaction"("swap_id");

-- CreateIndex
CREATE INDEX "Transaction_transaction_hash_idx" ON "Transaction"("transaction_hash");

-- CreateIndex
CREATE INDEX "Transaction_currency_id_idx" ON "Transaction"("currency_id");

-- CreateIndex
CREATE INDEX "Transaction_network_id_idx" ON "Transaction"("network_id");

-- CreateIndex
CREATE UNIQUE INDEX "Quote_swap_id_key" ON "Quote"("swap_id");