ALTER TABLE "ShopeeOrderItem" ADD COLUMN "shopId" TEXT;

UPDATE "ShopeeOrderItem"
SET "shopId" = (
  SELECT "ShopeeOrder"."shopId"
  FROM "ShopeeOrder"
  WHERE "ShopeeOrder"."orderSn" = "ShopeeOrderItem"."orderSn"
  ORDER BY "ShopeeOrder"."updatedAt" DESC
  LIMIT 1
)
WHERE "shopId" IS NULL;

CREATE INDEX "ShopeeOrderItem_shopId_orderSn_idx" ON "ShopeeOrderItem"("shopId", "orderSn");