CREATE TABLE customer_users (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    firm_name VARCHAR(150) NULL,
    mobile_number VARCHAR(20) NOT NULL UNIQUE,
    status ENUM('pending','approved','rejected','blocked') NOT NULL DEFAULT 'pending',
    device_id VARCHAR(191) NULL,
    auth_token VARCHAR(191) NULL UNIQUE,
    screenshot_allowed TINYINT(1) NOT NULL DEFAULT 0,
    allowed_duration_minutes INT NULL,
    approved_at DATETIME NULL,
    rejected_reason VARCHAR(255) NULL,
    last_seen_at DATETIME NULL,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE INDEX idx_customer_users_status ON customer_users (status);
CREATE INDEX idx_customer_users_device ON customer_users (device_id);