SET NAMES utf8mb4;

CREATE TABLE IF NOT EXISTS backup_settings (
    workspace_id BIGINT UNSIGNED PRIMARY KEY,
    keep_count INT NOT NULL DEFAULT 10,
    max_age_days INT NOT NULL DEFAULT 30,
    allow_restore TINYINT(1) NOT NULL DEFAULT 0,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    CONSTRAINT fk_backup_settings_workspace FOREIGN KEY(workspace_id) REFERENCES workspaces(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE integrations ADD COLUMN IF NOT EXISTS last_error TEXT NULL;
