-- db/migrations/004_add_initial_settings.sql

-- Insert initial settings if they do not already exist
INSERT IGNORE INTO settings (setting_key, setting_value, setting_type, default_value, description)
VALUES
    ('site_title', 'My Web Directory', 'text', 'My Web Directory', 'The main title of the website.'),
    ('maintenance_mode', '0', 'checkbox', '0', 'Enable or disable maintenance mode for the site.'),
    ('items_per_page', '10', 'number', '10', 'Number of items to display per page in listings.'),
    ('admin_email', 'admin@example.com', 'text', 'admin@example.com', 'The email address for administrative notifications.'),
    ('tar_pit_delay', '0', 'number', '0', 'Delay (in seconds) for tar pit defense against brute-force attacks.');