-- Starting data: the NAC programme catalogue, default settings and an admin login.
SET NAMES utf8mb4;

-- Photo slot labels — the admin can rename these in Settings.
INSERT INTO settings (name, value) VALUES
  ('photo1_label', 'Photo 1'),
  ('photo2_label', 'Photo 2'),
  ('college_name', 'National Aviation College')
ON DUPLICATE KEY UPDATE value = VALUES(value);

-- Programmes: name, level, delivery mode. More can be added in the app.
INSERT IGNORE INTO programs (name, level, mode) VALUES
  ('Foundation in Travel and Tourism (Ticketing)', 'Certificate', 'Regular'),
  ('Foundation in Travel and Tourism (Ticketing)', 'Certificate', 'Extension'),
  ('Front Office Service',                          'Level IV',    'Regular'),
  ('Front Office Service',                          'Level IV',    'Extension'),
  ('Hardware & Network Service',                    'Level IV',    'Regular'),
  ('Hardware & Network Service',                    'Level IV',    'Extension'),
  ('Airline Cabin Crew',                            'Certificate', 'Regular'),
  ('Flight Operation Officer',                      'Certificate', 'Regular'),
  ('Aircraft Maintenance Technician',               'Certificate', 'Regular'),
  ('Marketing & Sales Management',                  'Level IV',    'Regular'),
  ('Marketing & Sales Management',                  'Level IV',    'Extension'),
  ('Accounting & Finance',                          'Level IV',    'Regular'),
  ('Accounting & Finance',                          'Level IV',    'Extension'),
  ('Accounting & Finance',                          'B.A',         'Regular'),
  ('Accounting & Finance',                          'B.A',         'Distance'),
  ('Pharmacy',                                      'Level IV',    'Regular'),
  ('Nursing',                                       'Level IV',    'Regular'),
  ('MSc in International Trade & Economics',        'M.Sc',        'Regular'),
  ('MA in Logistics & Supply Chain Management',     'MA',          'Regular'),
  ('BSc in Aviation Management',                    'B.Sc',        'Regular'),
  ('BA in Hotel Management',                        'B.A',         'Regular'),
  ('Marketing Management',                          'B.A',         'Regular'),
  ('Marketing Management',                          'B.A',         'Distance'),
  ('Business Management',                           'B.A',         'Distance');

-- Default administrator — password is "admin123". Change it on first login.
INSERT IGNORE INTO users (username, password_hash, full_name, role) VALUES
  ('admin', '$2y$10$GfCSIeFkT8GI7f1pAXtAMOoUCxjJnui9uTDb9WjiUOVyb5NfrkW/O', 'Administrator', 'admin');