ALTER TABLE subscriptions ADD COLUMN status VARCHAR(50) NOT NULL DEFAULT 'submitted' AFTER homeType;