24 lines
1.1 KiB
SQL
24 lines
1.1 KiB
SQL
-- AlterTable
|
|
ALTER TABLE "orders_quotation" ADD COLUMN "exchange_rate" DECIMAL(24,10),
|
|
ADD COLUMN "exchange_rate_effective_date" DATE,
|
|
ADD COLUMN "exchange_rate_locked_at" TIMESTAMP(3),
|
|
ADD COLUMN "exchange_rate_provider" VARCHAR(255),
|
|
ADD COLUMN "exchange_rate_quoted_at" TIMESTAMP(3),
|
|
ADD COLUMN "exchange_rate_snapshot_uuid" VARCHAR(100),
|
|
ADD COLUMN "pricing_country_code" VARCHAR(2),
|
|
ADD COLUMN "pricing_kyc_profile_uuid" VARCHAR(100),
|
|
ADD COLUMN "source_amount" DECIMAL(12,2),
|
|
ADD COLUMN "source_currency" VARCHAR(10);
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "orders_order" ADD COLUMN "exchange_rate" DECIMAL(24,10),
|
|
ADD COLUMN "exchange_rate_effective_date" DATE,
|
|
ADD COLUMN "exchange_rate_locked_at" TIMESTAMP(3),
|
|
ADD COLUMN "exchange_rate_provider" VARCHAR(255),
|
|
ADD COLUMN "exchange_rate_quoted_at" TIMESTAMP(3),
|
|
ADD COLUMN "exchange_rate_snapshot_uuid" VARCHAR(100),
|
|
ADD COLUMN "pricing_country_code" VARCHAR(2),
|
|
ADD COLUMN "pricing_kyc_profile_uuid" VARCHAR(100),
|
|
ADD COLUMN "source_amount" DECIMAL(12,2),
|
|
ADD COLUMN "source_currency" VARCHAR(10);
|