-- Split local HPP into two business costs:
-- hppAwal  = modal awal / harga kulakan for order-entry profit estimates.
-- hppFinal = modal final + packing/other fulfilment cost for real cash-in profit.
ALTER TABLE "ShopeeProductSku" ADD COLUMN "hppAwal" REAL;
ALTER TABLE "ShopeeProductSku" ADD COLUMN "hppAwalCurrency" TEXT;
ALTER TABLE "ShopeeProductSku" ADD COLUMN "hppAwalUpdatedAt" DATETIME;
ALTER TABLE "ShopeeProductSku" ADD COLUMN "hppFinal" REAL;
ALTER TABLE "ShopeeProductSku" ADD COLUMN "hppFinalCurrency" TEXT;
ALTER TABLE "ShopeeProductSku" ADD COLUMN "hppFinalUpdatedAt" DATETIME;

UPDATE "ShopeeProductSku"
SET
  "hppAwal" = "hpp",
  "hppAwalCurrency" = "hppCurrency",
  "hppAwalUpdatedAt" = "hppUpdatedAt",
  "hppFinal" = "hpp",
  "hppFinalCurrency" = "hppCurrency",
  "hppFinalUpdatedAt" = "hppUpdatedAt"
WHERE "hpp" IS NOT NULL;