-- Laufzeit-Konfiguration (z. B. Garantiezeit), durch Admin aenderbar ohne Deploy.
CREATE TABLE IF NOT EXISTS settings (
    setting_key   VARCHAR(64) NOT NULL PRIMARY KEY,
    setting_value VARCHAR(255) NOT NULL,
    updated_at    DATETIME NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Standard-Garantiezeit setzen (kann jederzeit ueberschrieben werden).
INSERT INTO settings (setting_key, setting_value, updated_at)
VALUES ('warranty_years', '5', NOW())
ON DUPLICATE KEY UPDATE setting_key = setting_key;
