-- Ajout du champ surface_terrain à la table annonces
-- Pour stocker la surface du terrain en mètres carrés

ALTER TABLE `annonces` 
ADD COLUMN `surface_terrain` DECIMAL(10,2) NULL COMMENT 'Surface du terrain en m²' AFTER `surface`;

-- Mise à jour de quelques annonces de maisons avec des valeurs de terrain
UPDATE `annonces` SET `surface_terrain` = 800.00 WHERE `id` = 2;
UPDATE `annonces` SET `surface_terrain` = 800.00 WHERE `id` = 8;
UPDATE `annonces` SET `surface_terrain` = 600.00 WHERE `id` = 12;
UPDATE `annonces` SET `surface_terrain` = 800.00 WHERE `id` = 18;
UPDATE `annonces` SET `surface_terrain` = 650.00 WHERE `id` = 19;
UPDATE `annonces` SET `surface_terrain` = 600.00 WHERE `id` = 21;
UPDATE `annonces` SET `surface_terrain` = 1200.00 WHERE `id` = 22;
UPDATE `annonces` SET `surface_terrain` = 900.00 WHERE `id` = 23;
UPDATE `annonces` SET `surface_terrain` = 1000.00 WHERE `id` = 24;
UPDATE `annonces` SET `surface_terrain` = 800.00 WHERE `id` = 25;
UPDATE `annonces` SET `surface_terrain` = 750.00 WHERE `id` = 38;
UPDATE `annonces` SET `surface_terrain` = 600.00 WHERE `id` = 39;
