7 lines
306 B
SQL
7 lines
306 B
SQL
ALTER TABLE "FixedPlan"
|
|
ADD COLUMN IF NOT EXISTS "amountMode" TEXT NOT NULL DEFAULT 'fixed',
|
|
ADD COLUMN IF NOT EXISTS "estimatedCents" BIGINT,
|
|
ADD COLUMN IF NOT EXISTS "actualCents" BIGINT,
|
|
ADD COLUMN IF NOT EXISTS "actualCycleDueOn" TIMESTAMP(3),
|
|
ADD COLUMN IF NOT EXISTS "actualRecordedAt" TIMESTAMP(3);
|