-- Tabel untuk menyimpan konfigurasi sistem
CREATE TABLE IF NOT EXISTS settings (
    key_name VARCHAR(50) PRIMARY KEY,
    key_value TEXT
);

-- Masukkan data awal (default)
INSERT INTO settings (key_name, key_value) VALUES 
('api_key', 'MASUKKAN_API_KEY_DISINI'),
('app_name', 'My Transfer System'),
('min_transfer', '1000');

-- Tabel riwayat transfer (jika belum buat)
CREATE TABLE IF NOT EXISTS riwayat_transfer (
    id INT AUTO_INCREMENT PRIMARY KEY,
    sender_id VARCHAR(50),
    sender_name VARCHAR(100),
    receiver_id VARCHAR(50),
    receiver_name VARCHAR(100),
    amount INT,
    note TEXT,
    created_at DATETIME
);