-- Migration 004: extra fields that matter for room rentals.
-- MySQL syntax (not MariaDB).

ALTER TABLE rooms
    ADD COLUMN floor        VARCHAR(20) NULL AFTER name,
    ADD COLUMN private_bath TINYINT(1) NOT NULL DEFAULT 0 AFTER floor,
    ADD COLUMN furnished    TINYINT(1) NOT NULL DEFAULT 0 AFTER private_bath,
    ADD COLUMN square_feet  INT UNSIGNED NULL AFTER furnished;