5 lines
302 B
SQL
5 lines
302 B
SQL
-- Add billing period and gross price snapshot to existing instances.
|
|
ALTER TABLE instances
|
|
ADD COLUMN IF NOT EXISTS billing_period ENUM('monthly', 'yearly') NOT NULL DEFAULT 'monthly' AFTER plan,
|
|
ADD COLUMN IF NOT EXISTS price_gross_cents INT UNSIGNED NOT NULL DEFAULT 0 AFTER billing_period;
|