-- Migration 008: rental-specific application fields. MySQL syntax (not MariaDB).
-- Standard rental-screening details collected with each application.

ALTER TABLE applications
    ADD COLUMN occupants      TINYINT UNSIGNED NULL AFTER desired_move_in,
    ADD COLUMN pets           VARCHAR(255) NULL AFTER occupants,
    ADD COLUMN monthly_income DECIMAL(10,2) NULL AFTER pets,
    ADD COLUMN employer       VARCHAR(160) NULL AFTER monthly_income;