-- =====================================================
-- UPGRADE SQL — CMS Sekolahku v3.0.1 → v3.0.2
-- Jalankan file ini sekali saja untuk update database
-- =====================================================

-- 1. Insert footer_links (kolom "Layanan" di footer)
INSERT INTO `settings` (`key`, `value`)
VALUES ('footer_links', '[{"label":"SPMB Online","url":"#"},{"label":"E-Learning","url":"#"},{"label":"Perpustakaan","url":"#"},{"label":"FAQ","url":"#faq"},{"label":"Pengaduan","url":"#"}]')
ON DUPLICATE KEY UPDATE `value` = VALUES(`value`);

-- 2. Update theme_color ke default (tidak ada CSS tambahan)
UPDATE `settings` SET `value` = 'default' WHERE `key` = 'theme_color';