-- =========================================================================
-- IMPORT: 32 Anak Syarikat Rasmi MBI (senarai 29 Julai 2026)
-- Untuk FRESH INSTALL sahaja — jadual "subsidiaries" installer sudah ada
-- kolum cluster & sector terbina, jadi TIADA ALTER TABLE diperlukan di sini.
--
-- Jalankan di phpMyAdmin > tab SQL, SELEPAS installer (/install.php)
-- selesai dan akaun Super Admin sudah dicipta.
--
-- Selamat dijalankan berulang kali (ON DUPLICATE KEY UPDATE — kemaskini
-- nama/cluster/sector jika kod sudah wujud, bukan cipta pendua).
-- =========================================================================

INSERT INTO subsidiaries (subsidiary_id, code, name, cluster, sector, is_active) VALUES
(UUID(), 'SSDU',        'SSDU Innovations Sdn Bhd',                          'strategy',   'Media & Digital AI', 1),
(UUID(), 'MSSB',        'Media Selangor Sdn Bhd',                            'strategy',   'Media & Digital AI', 1),
(UUID(), 'UNISEL',      'UNISEL Sdn Bhd',                                    'commercial', 'Healthcare & Education', 1),
(UUID(), 'INPEN_STDC',  'INPEN (Selangor) Sdn Bhd',                          'commercial', 'Healthcare & Education', 1),
(UUID(), 'ISB',         'Invest Selangor Berhad',                            'strategy',   'Invest, Tourism & Social Promotion', 1),
(UUID(), 'TSSB',        'Tourism Selangor Sdn Bhd',                          'strategy',   'Invest, Tourism & Social Promotion', 1),
(UUID(), 'HIS',         'HIS Toyyiba Sdn Bhd',                               'strategy',   'Invest, Tourism & Social Promotion', 1),
(UUID(), 'YAWAS',       'Yayasan Warisan Anak Selangor',                     'strategy',   'Invest, Tourism & Social Promotion', 1),
(UUID(), 'WBS',         'Wanita Berdaya Selangor Sdn Bhd',                   'strategy',   'Invest, Tourism & Social Promotion', 1),
(UUID(), 'YANIS',       'Yayasan Insan Istimewa Selangor',                   'strategy',   'Invest, Tourism & Social Promotion', 1),
(UUID(), 'KHSB',        'Kumpulan Hartanah Selangor Berhad',                 'commercial', 'Land & Property', 1),
(UUID(), 'CSSB',        'Central Spectrum (M) Sdn Bhd',                      'commercial', 'Land & Property', 1),
(UUID(), 'PNSB',        'Permodalan Negeri Selangor Berhad',                 'commercial', 'Land & Property', 1),
(UUID(), 'LLSB',        'Landasan Lumayan Sdn Bhd',                          'commercial', 'Land & Property', 1),
(UUID(), 'BBGC',        'Bukit Beruntung Golf & Country Resort Berhad',      'commercial', 'Land & Property', 1),
(UUID(), 'PASB',        'Pengurusan Air Selangor Sdn Bhd',                   'commercial', 'Water', 1),
(UUID(), 'AISHOLDINGS', 'Air Selangor Holdings Berhad',                      'commercial', 'Water', 1),
(UUID(), 'HELIOSEL',    'Heliosel Sdn Bhd',                                  'commercial', 'Water', 1),
(UUID(), 'CUBIQMETERS', 'Cubiq Meters Sdn Bhd',                              'commercial', 'Water', 1),
(UUID(), 'AIRLESTARI',  'Air Lestari Sdn Bhd',                               'commercial', 'Water', 1),
(UUID(), 'HIJRAH',      'Yayasan Hijrah Selangor',                           'commercial', 'Retail & Financial Services', 1),
(UUID(), 'KSSB',        'Kumpulan Semesta Sdn Bhd',                          'commercial', 'Mining & Minerals', 1),
(UUID(), 'SIDEC',       'SIDEC Sdn Bhd',                                     'commercial', 'Start Up & VC', 1),
(UUID(), 'WAVPAY',      'Wavpay Fintech Holdings Sdn Bhd',                   'commercial', 'Retail & Financial Services', 1),
(UUID(), 'RMSB',        'Rantaian Mesra Sdn Bhd',                            'commercial', 'Retail & Financial Services', 1),
(UUID(), 'KPS',         'Kumpulan Perangsang Selangor Berhad',               'commercial', 'Investment', 1),
(UUID(), 'SELATI',      'Selangor Aviation & Technology Innovation Sdn Bhd', 'commercial', 'Investment', 1),
(UUID(), 'KDEBWM',      'KDEB Waste Management Sdn Bhd',                     'commercial', 'Energy & Utilities', 1),
(UUID(), 'KUSEL',       'Koridor Utiliti Selangor Sdn Bhd',                  'commercial', 'Energy & Utilities', 1),
(UUID(), 'SMARTSEL',    'Smartsel Sdn Bhd',                                  'commercial', 'Energy & Utilities', 1),
(UUID(), 'DEFM',        'Darul Ehsan Facilities Management Sdn Bhd',         'commercial', 'Energy & Utilities', 1),
(UUID(), 'URBANCUBES',  'Urbancubes Sdn Bhd',                                'commercial', 'Energy & Utilities', 1)
ON DUPLICATE KEY UPDATE
    name = VALUES(name),
    cluster = VALUES(cluster),
    sector = VALUES(sector);
