

-- Nouveaux champs informatifs sur les chambres (non affichés sur le site public pour l'instant).
ALTER TABLE `rooms`
    ADD COLUMN `base_price` SMALLINT UNSIGNED NULL AFTER `sort_order`,
    ADD COLUMN `surface`    SMALLINT UNSIGNED NULL AFTER `base_price`,
    ADD COLUMN `floor`      TINYINT UNSIGNED  NULL AFTER `surface`;
    -- floor : 0 = RDC, 1 = 1er étage, 2 = 2e étage

-- Seed des valeurs connues pour les chambres existantes
UPDATE `rooms` SET `surface` = 50, `floor` = 1 WHERE `slug` = 'marlon-brando';
UPDATE `rooms` SET `surface` = 30, `floor` = 0 WHERE `slug` = 'monica-bellucci';
UPDATE `rooms` SET `surface` = 45, `floor` = 2 WHERE `slug` = 'steve-mcqueen';
UPDATE `rooms` SET `surface` = 30, `floor` = 1 WHERE `slug` = 'miou-miou';
UPDATE `rooms` SET `surface` = 50, `floor` = 1 WHERE `slug` = 'jean-gabin';
