ALTER TABLE submenu ADD COLUMN alias VARCHAR(30) AFTER name;

UPDATE submenu SET alias = 'Menu' WHERE route = 'setting-menu';
UPDATE submenu SET alias = 'Submenu' WHERE route = 'setting-submenu';
UPDATE submenu SET alias = 'Akses' WHERE route = 'setting-access';
UPDATE submenu SET alias = 'Master Petugas' WHERE route = 'data-petugas';
UPDATE submenu SET alias = 'Master Kandang' WHERE route = 'data-kandang';
UPDATE submenu SET alias = 'Laporan Kandang' WHERE route = 'report-kandang';
UPDATE submenu SET alias = 'Laporan Ternak' WHERE route = 'report-ternak';

INSERT INTO submenu(number, menu_id, name, alias, route) 
VALUES(3, 5, 'Monitoring Kesehatan', 'Laporan Kesehatan', 'report-kesehatan');

INSERT INTO submenu(number, menu_id, name, alias, route) 
VALUES(3, 3, 'Data Ternak', 'Master Ternak', 'data-ternak');