-- AlterTable
ALTER TABLE `Project`
    ADD COLUMN `districtAr` VARCHAR(512) NULL,
    ADD COLUMN `districtEn` VARCHAR(512) NULL,
    ADD COLUMN `propertyType` ENUM('villa', 'apartment', 'compound', 'commercial', 'office') NOT NULL DEFAULT 'apartment',
    ADD COLUMN `availabilityStatus` ENUM('available', 'coming_soon', 'under_construction', 'completed', 'sold_out') NOT NULL DEFAULT 'available',
    ADD COLUMN `roomsMin` INTEGER NULL,
    ADD COLUMN `roomsMax` INTEGER NULL,
    ADD COLUMN `areaMinSqm` DECIMAL(12, 2) NULL,
    ADD COLUMN `areaMaxSqm` DECIMAL(12, 2) NULL,
    ADD COLUMN `units` JSON NOT NULL DEFAULT (JSON_ARRAY()),
    ADD COLUMN `descriptionAr` TEXT NULL,
    ADD COLUMN `descriptionEn` TEXT NULL;
