-- update_prices.sql

-- 1. Update Room Types Base Prices (and names if needed to match logic)
-- We assume IDs from seed.sql are correct: 
-- 1: Double Standard (Rooms 1, 5) -> 1500
-- 2: Double Comfort (Rooms 2, 6) -> 1700
-- 3: Double Superior (Rooms 3, 7) -> 1700
-- 4: Twin (Room 4) -> 1500
-- 5: Economy Double (Room 8) -> 1400

INSERT INTO room_types (id, name, base_price, capacity_adults) VALUES
(1, 'Double Standard', 1500.00, 2),
(2, 'Double Comfort', 1700.00, 2),
(3, 'Double Superior', 1700.00, 2),
(4, 'Twin', 1500.00, 2),
(5, 'Economy Double', 1400.00, 2)
ON DUPLICATE KEY UPDATE 
name = VALUES(name), 
base_price = VALUES(base_price);

-- 2. Update Extras
TRUNCATE TABLE extras;

INSERT INTO extras (name, price) VALUES 
('Додаткове місце', 400.00),
('Додаткове місце (Стандарт)', 400.00),
('Сніданок', 150.00);

-- 3. Verify Rooms exist (linkage)
UPDATE rooms SET type_id = 1 WHERE room_number IN ('1', '5');
UPDATE rooms SET type_id = 2 WHERE room_number IN ('2', '6');
UPDATE rooms SET type_id = 3 WHERE room_number IN ('3', '7');
UPDATE rooms SET type_id = 4 WHERE room_number IN ('4');
UPDATE rooms SET type_id = 5 WHERE room_number IN ('8');