
ALTER TABLE ks_menuitem
DROP `mi_labelbm`, 
DROP `mi_labelbi`,
DROP `mi_tooltipsbm`,
DROP `mi_tooltipsbi`;

ALTER TABLE ks_menuitem
ADD COLUMN `mi_label` VARCHAR(100) NULL AFTER `mi_notlogin`;
ALTER TABLE ks_menuitem
ADD COLUMN `mi_tooltip` VARCHAR(50) NULL AFTER 
`mi_image2`;
ALTER TABLE ks_menuitem
ADD COLUMN `mi_option` LONGTEXT NULL AFTER
`mi_order`;

TRUNCATE TABLE ks_menuitem;
INSERT INTO `ks_menuitem` (`mi_id`, `mi_menuid`, `mi_parentid`, `mi_notlogin`, `mi_label`, `mi_urltype`, `mi_url`, `mi_image1`, `mi_image2`, `mi_tooltip`, `mi_roles`, `mi_order`,`mi_option`) VALUES
(1, 1, 0, 0, 'Halaman Utama', 'internal', 'main', '', '','', 'ADMIN;EXCO;HEBI;KP;MB;PDT;PENASIHAT;SETPOL;SPEAKER;SUK;SUPER;UPEN;', 1,''),
(3, 1, 0, 1, 'Lost Password', 'internal', 'user/lostpassword.php', '', '', '','', 14,''),
(4, 1, 0, 1, 'Login', 'internal', 'user/login.php', '', '', '','', 15,''),
(5, 1, 0, 0, 'Hantar Permohonan', 'internal', 'adun/addsumb.php', '', '','', 'ADUN;', 4,''),
(15, 1, 0, 0, 'Kelulusan Permohonan', 'internal', 'approval', '', '','', 'MB;SUK;', 9,''),
(6, 1, 0, 0, 'Halaman Utama', 'internal', 'home.php', '', '','', 'ADUN;', 3,''),
(7, 1, 0, 0, 'Senarai Permohonan', 'internal', 'adun/senarai.php', '', '','', 'ADUN;', 7,''),
(8, 1, 7, 0, 'Semua Permohonan', 'internal', 'adun/senarai.php', '','', '', 'ADUN;', 8,''),
(9, 1, 0, 0, 'Statistik', 'internal', 'adun/statistik.php', '', '','', 'ADUN;', 10,''),
(10, 1, 0, 0, 'Proses Borang', 'internal', 'process/', '', '','', 'ADMIN;SUPER;UPEN;', 2 ,''),
(12, 1, 0, 0, 'Laporan &amp; Dashboard', 'internal', 'report', '', '','', 'ADMIN;MB;UPEN;', 31 ,''),
(13, 1, 0, 0, 'Pemantauan', 'internal', 'monitor/', '', '','', 'ADMIN;SUPER;UPEN;', 12 ,''),
(39, 1, 22, 0, 'Projek', 'internal', 'main/addproj', '', '','', 'ADMIN;EXCO;HEBI;KP;MB;PENASIHAT;SETPOL;SPEAKER;SUK;SUPER;UPEN;', 35 ,''),
(16, 1, 0, 0, 'Pentadbiran', 'internal', 'main', '', '','', 'ADMIN;', 17 ,''),
(17, 1, 16, 0, 'Pemohon', 'internal', 'pemohon', '', '','', 'ADMIN;', 18 ,''),
(35, 1, 16, 0, 'Peruntukan', 'internal', 'peruntukan', '', '','','ADMIN;', 19 ,''),
(19, 1, 16, 0, 'Agensi', 'internal', 'agensi', '', '','', 'ADMIN;', 20 ,''),
(20, 1, 5, 0,  'Sumbangan', 'internal', 'adun/addsumb.php', '', '','', 'ADUN;', 5 ,''),
(21, 1, 5, 0, 'Projek', 'internal', 'adun/addproj.php', '', '','', 'ADUN;', 6 ,''),
(22, 1, 0, 0, 'Hantar Permohonan', 'internal', 'main/addsumb', '', '','', 'ADMIN;EXCO;HEBI;KP;MB;PENASIHAT;SETPOL;SPEAKER;SUPER;UPEN;', 22 ,''),
(23, 1, 22, 0, 'Sumbangan', 'internal', 'main/addsumb', '', '','', 'EXCO;HEBI;KP;MB;PENASIHAT;SETPOL;SPEAKER;UPEN;', 23 ,''),
(24, 1, 29, 0,'Projek', 'internal', 'main/addproj', '', '','', 'EXCO;HEBI;KP;MB;PENASIHAT;SETPOL;SPEAKER;SUK;UPEN;', 30 ,''),
(25, 1, 0, 0, 'Senarai Permohonan', 'internal', 'main/list', '', '','', 'ADMIN;EXCO;HEBI;KP;MB;PDT;PENASIHAT;SETPOL;SPEAKER;SUPER;UPEN;', 24 ,''),
(26, 1, 25, 0, 'Semua Permohonan', 'internal', 'main/list', '', '','',  'ADMIN;EXCO;HEBI;KP;MB;PDT;PENASIHAT;SETPOL;SPEAKER;SUK;SUPER;UPEN;', 25 ,''),
(27, 1, 0, 0, 'Statistik', 'internal', 'main/statistik', '', '','',  'EXCO;HEBI;KP;MB;PDT;PENASIHAT;SETPOL;SPEAKER;', 27 ,''),
(28, 1, 0, 0, 'Laporan', 'internal', 'main/laporan', '', '','',  'EXCO;HEBI;KP;PENASIHAT;SETPOL;SPEAKER;', 28 ,''),
(29, 1, 0, 0, 'Laporan', 'internal', 'adun/laporan.php', '', '','',  'ADUN;', 29 ,''),
(30, 1, 0, 0, 'Hantar Permohonan', 'internal', 'main/addproj', '', '','', 'PDT;', 21 ,''),
(32, 1, 0, 0, 'Baucar &amp; Waran', 'external', 'kewangan/', '', '','', 'ADMIN;SUPER;UPEN;', 11 ,''),
(33, 1, 0, 0, 'Prestasi Bulanan', 'internal', 'projek-status/', '', '','', 'PDT;', 26 ,''),
(34, 1, 0, 0,  'Laporan', 'external', 'main/laporanpdt', '', '','', 'PDT;', 32 ,''),
(36, 1, 0, 0, 'Pentadbiran', 'internal', 'main', '', '','','SUPER;UPEN;', 16 ,''),
(37, 1, 36, 0, 'Pemohon', 'internal', 'pemohon', '', '','',  'SUPER;UPEN;', 33 ,''),
(38, 1, 36, 0, 'Agensi', 'internal', 'agensi', '', '','', 'SUPER;UPEN;', 34 ,'');