
CREATE TABLE IF NOT EXISTS account_tasks (
  id INT AUTO_INCREMENT PRIMARY KEY,
  user_id INT NOT NULL,
  suggested_email VARCHAR(255) NOT NULL,
  suggested_password VARCHAR(255) NOT NULL,
  first_name VARCHAR(100) DEFAULT NULL,
  last_name VARCHAR(100) DEFAULT NULL,
  birth_date DATE DEFAULT NULL,
  gender VARCHAR(20) DEFAULT NULL,
  notes TEXT DEFAULT NULL,
  status ENUM('pending','done') DEFAULT 'pending',
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  completed_at TIMESTAMP NULL DEFAULT NULL,
  final_email VARCHAR(255) DEFAULT NULL,
  encrypted_password TEXT DEFAULT NULL
);
