11 lines
749 B
SQL
11 lines
749 B
SQL
-- 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.');
|