17 lines
497 B
SQL
17 lines
497 B
SQL
-- ============================================
|
|
-- Migration 003: Import Settings Data
|
|
-- E-Proposal Komite - MySQL Migration
|
|
-- ============================================
|
|
|
|
USE db_proposalkomite;
|
|
|
|
-- Import settings from CSV export
|
|
INSERT INTO settings (setting_key, setting_value) VALUES
|
|
('academic_year', '2026')
|
|
ON DUPLICATE KEY UPDATE
|
|
setting_value = VALUES(setting_value);
|
|
|
|
-- Success Message
|
|
SELECT * FROM settings;
|
|
SELECT 'Settings imported successfully!' AS message;
|