-- Add variable_amount flag to bills.
-- When true, the amount is expected to change each month and must be
-- entered per-paycheck via amount_override on paycheck_bills.
ALTER TABLE bills ADD COLUMN IF NOT EXISTS variable_amount BOOLEAN NOT NULL DEFAULT FALSE;