-- Penambahan field image menu
ALTER TABLE menu ADD image varchar(255) AFTER icon;

-- Penambahan field image submenu
ALTER TABLE submenu ADD image varchar(255) AFTER route;

-- Set image pada setiap menu
UPDATE menu SET image = 'dashboard.svg' WHERE name = 'Dashboard';
UPDATE menu SET image = 'monitoring.svg' WHERE name = 'Monitoring';
UPDATE menu SET image = 'treatment.svg' WHERE name = 'Treatment';
UPDATE menu SET image = 'rekam-medis.svg' WHERE name = 'Rekam Medis';
UPDATE menu SET image = 'kesehatan.svg' WHERE name = 'Kesehatan';
UPDATE menu SET image = 'laporan.svg' WHERE name = 'Laporan';

UPDATE submenu SET image = 'petugas.svg' WHERE name = 'Petugas';
UPDATE submenu SET image = 'kandang.svg' WHERE name = 'Data Kandang';

-- Penyesuaian nama menu
UPDATE menu SET name = 'Monitoring' WHERE name = 'monitoring';