-- Auto-generated oleh scripts/gen_seeds_roomrev.py — JANGAN edit manual.
-- 190_room_master.sql — room_type (6) + room_segment (17), ADR-015a


-- Master sebagai DATA (ADR-015a): tambah tipe kamar/segmen = INSERT baris baru, tanpa deploy.
-- Master/config (bukan transaksional) -> ON DUPLICATE KEY UPDATE, pola 103_department.sql.

INSERT INTO room_type (id, code, name, inventory, sort_order, is_active) VALUES
(1, 'PREMIERE_SUITE', 'PREMIERE SUITE ROOM', 18, 10, 1),
(2, 'DELUXE_PRIVATE_POOL_VILLA', 'DELUXE PRIVATE POOL VILLA', 8, 20, 1),
(3, 'PREMIERE_PRIVATE_POOL_VILLA', 'PREMIERE PRIVATE POOL VILLA', 5, 30, 1),
(4, 'PRESIDENTIAL_1BR', '1 BR PRESIDENSIAL POOL VILLA', 1, 40, 1),
(5, 'PRESIDENTIAL_2BR', '2 BR PRESIDENTIAL POOL VILLA', 1, 50, 1),
(6, 'DELUXE_SUITE', 'DELUXE SUITE ROOM', 24, 60, 1)
ON DUPLICATE KEY UPDATE name=VALUES(name), inventory=VALUES(inventory), sort_order=VALUES(sort_order), is_active=VALUES(is_active);

INSERT INTO room_segment (id, code, name, group_name, sort_order, is_active) VALUES
(1, 'WALK_IN_GUEST', 'WALK IN GUEST', 'FIT DIRECT', 10, 1),
(2, 'WEBSITE_BOOKING_ENGINE', 'WEBSITE - BOOKING ENGINE', 'FIT DIRECT', 20, 1),
(3, 'EMAIL_WA', 'EMAIL / WA', 'FIT DIRECT', 30, 1),
(4, 'ONLINE_TRAVEL_AGENT', 'ONLINE TRAVEL AGENT', 'TRAVEL AGENT', 40, 1),
(5, 'TA_DOMESTIC', 'TA DOMESTIC', 'TRAVEL AGENT', 50, 1),
(6, 'TA_OVER_SEAS', 'TA OVER SEAS', 'TRAVEL AGENT', 60, 1),
(7, 'TA_MICE', 'MICE', 'TRAVEL AGENT', 70, 1),
(8, 'TA_GROUP_SERIES', 'GROUP SERIES', 'TRAVEL AGENT', 80, 1),
(9, 'WS_MICE', 'MICE - WS', 'WHOLESALER', 90, 1),
(10, 'WS_GROUP_SERIES', 'GROUP SERIES - WS', 'WHOLESALER', 100, 1),
(11, 'WS_INDIVIDUAL', 'INDIVIUAL - WS', 'WHOLESALER', 110, 1),
(12, 'CORP_BANK', 'BANK', 'CORPORATE', 120, 1),
(13, 'CORP_COMPANY', 'COMPANY', 'CORPORATE', 130, 1),
(14, 'CORP_HOSPITAL', 'HOSPITAL', 'CORPORATE', 140, 1),
(15, 'GOVERNMENT', 'GOVERNMENT', 'GOVERNMENT', 150, 1),
(16, 'COMPLIMENTARY', 'COMPLIMENTARY', 'COMPLIMENTARY', 160, 1),
(17, 'HOUSE_USE', 'HOUSE USE', 'HOUSE USE', 170, 1)
ON DUPLICATE KEY UPDATE name=VALUES(name), group_name=VALUES(group_name), sort_order=VALUES(sort_order), is_active=VALUES(is_active);
