9 lines
232 B
SQL
9 lines
232 B
SQL
ALTER TABLE "expense_claims"
|
|
ADD COLUMN "items" JSONB;
|
|
|
|
ALTER TABLE "expense_claims"
|
|
ADD COLUMN "totalAmount" DECIMAL(12,2);
|
|
|
|
UPDATE "expense_claims"
|
|
SET "totalAmount" = "amount"
|
|
WHERE "totalAmount" IS NULL AND "amount" IS NOT NULL; |