

CREATE TABLE IF NOT EXISTS tester_logs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    tester_id INT NOT NULL,
    app_id INT NOT NULL,
    action VARCHAR(50) NOT NULL, -- Install, Open, Review
    details TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (tester_id) REFERENCES tester_users (id) ON DELETE CASCADE
);