17 lines
711 B
SQL
17 lines
711 B
SQL
CREATE TABLE IF NOT EXISTS app_settings (
|
|
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
|
|
setting_key VARCHAR(120) NOT NULL,
|
|
setting_value TEXT NULL,
|
|
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
UNIQUE KEY app_settings_setting_key_unique (setting_key)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
INSERT INTO app_settings (setting_key, setting_value, created_at, updated_at)
|
|
VALUES
|
|
('cron_run_on_web', '0', NOW(), NOW()),
|
|
('cron_web_limit', '5', NOW(), NOW())
|
|
ON DUPLICATE KEY UPDATE
|
|
setting_value = VALUES(setting_value),
|
|
updated_at = VALUES(updated_at);
|