-- Replace plaintext token storage with encrypted live token storage.
CREATE TABLE "ShopeeShopToken" (
    "id" TEXT NOT NULL PRIMARY KEY,
    "shopId" TEXT NOT NULL,
    "accessTokenEnc" TEXT NOT NULL,
    "refreshTokenEnc" TEXT NOT NULL,
    "expireIn" INTEGER,
    "tokenCreatedAt" DATETIME NOT NULL,
    "connectedAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updatedAt" DATETIME NOT NULL,
    "status" TEXT NOT NULL DEFAULT 'active'
);

CREATE UNIQUE INDEX "ShopeeShopToken_shopId_key" ON "ShopeeShopToken"("shopId");

CREATE TABLE "new_ShopeeApiLog" (
    "id" TEXT NOT NULL PRIMARY KEY,
    "shopId" TEXT,
    "path" TEXT NOT NULL,
    "method" TEXT NOT NULL,
    "statusCode" INTEGER,
    "success" BOOLEAN NOT NULL,
    "message" TEXT,
    "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);

DROP TABLE IF EXISTS "ShopeeApiLog";
ALTER TABLE "new_ShopeeApiLog" RENAME TO "ShopeeApiLog";
DROP TABLE IF EXISTS "ShopeeToken";