CREATE TABLE IF NOT EXISTS settings (id TINYINT PRIMARY KEY, group_id VARCHAR(255) DEFAULT '', enabled TINYINT NOT NULL DEFAULT 0, interval_minutes INT NOT NULL DEFAULT 15, batch_size INT NOT NULL DEFAULT 4, last_run DATETIME NULL, api_token_hash CHAR(64) NOT NULL);
CREATE TABLE IF NOT EXISTS contacts (id INT AUTO_INCREMENT PRIMARY KEY, phone VARCHAR(24) NOT NULL UNIQUE, consent TINYINT NOT NULL DEFAULT 0, status ENUM('pending','processing','added','invited','failed','skipped') NOT NULL DEFAULT 'pending', attempts INT NOT NULL DEFAULT 0, detail VARCHAR(255), updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
CREATE TABLE IF NOT EXISTS events (id INT AUTO_INCREMENT PRIMARY KEY, contact_id INT NULL, action VARCHAR(40) NOT NULL, detail TEXT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP);
