CREATE TABLE IF NOT EXISTS tester_commands (
    id INT AUTO_INCREMENT PRIMARY KEY,
    tester_id INT NOT NULL,
    command ENUM(
        'INSTALL',
        'OPEN',
        'UNINSTALL',
        'FEEDBACK'
    ) NOT NULL,
    app_id INT NULL,
    status ENUM(
        'PENDING',
        'SENT',
        'COMPLETED',
        'FAILED'
    ) DEFAULT 'PENDING',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (tester_id) REFERENCES tester_users (id) ON DELETE CASCADE
);