-- Auto-generated oleh scripts/gen_seeds.py — JANGAN edit manual.
-- 103_department.sql — 12 departemen (kontrak butir 3)


INSERT INTO department (id, code, name, sort_order) VALUES
(1, 'FO', 'Front Office', 10),
(2, 'HK', 'Housekeeping', 20),
(3, 'FB', 'Food & Beverage', 30),
(4, 'SPA', 'SPA & Activities', 40),
(5, 'LDY', 'Laundry', 50),
(6, 'AG', 'Admin & General', 60),
(7, 'ICT', 'Information & Communication Technology', 70),
(8, 'HC', 'Human Capital', 80),
(9, 'SM', 'Sales & Marketing', 90),
(10, 'POM', 'Property Operation & Maintenance', 100),
(11, 'ROOMREV', 'Room Revenue', 5),
(12, 'FIXED', 'Fixed & Non-Operating', 110)
ON DUPLICATE KEY UPDATE code=VALUES(code), name=VALUES(name), sort_order=VALUES(sort_order);