CREATE TABLE `division_names` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `division` varchar(50) NOT NULL,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `division_names` (`division`, `name`) VALUES
-- LEADER
('leader', 'Sdri. Melati'),
('leader', 'Sdri. Yesika'),
('leader', 'Ibu Yohana'),
('leader', 'Bpk. Christian'),
('leader', 'Ibu Silvia'),

-- SINGER
('singer', 'Sdri. Astutik'),
('singer', 'Ibu Yohana'),
('singer', 'Ibu Titian'),
('singer', 'Ibu Evi'),

-- KEYBOARD
('keyboard', 'Sdri. Vani'),
('keyboard', 'Sdr. Freddy'),
('keyboard', 'Bpk. Christian'),

-- GITAR
('guitar', 'Bpk. Christian'),
('guitar', 'Sdr. Freddy'),

-- BASS
('bass', 'Bpk. Christian'),
('bass', 'Bpk. Anang'),

-- DRUM
('drum', 'Sdr. Arya'),
('drum', 'Bpk. Christian'),
('drum', 'Bpk. Sandy'),
('drum', 'Ibu Yohana'),

-- MANAGER
('manager', 'Ibu Yohana'),
('manager', 'Bpk. Christian'),
('manager', 'Sdr. Freddy'),
('manager', 'Sdri. Vani'),
('manager', 'Sdri. Astutik'),

-- LIGHTING
('lighting', 'Sdri. Vani'),
('lighting', 'Bpk. Christian'),
('lighting', 'Sdri. Seteven'),

-- MULTIMEDIA
('multimedia', 'Bpk. Ivan'),
('multimedia', 'Sdri. Vani'),
('multimedia', 'Bpk. Christian'),
('multimedia', 'Sdri. Seteven'),
('multimedia', 'Ibu Silvia'),

-- KAMERA
('kamera', 'Sdri. Vani'),
('kamera', 'Bpk. Christian'),
('kamera', 'Ibu Silvia'),
('kamera', 'Ibu Yohana');