CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  company_name VARCHAR(150),
  email VARCHAR(150) UNIQUE,
  contact_name VARCHAR(100),
  password VARCHAR(255),
  status ENUM('pending','approved') DEFAULT 'pending',
  phone_number VARCHAR(20) DEFAULT NULL,
  registration_number VARCHAR(50) DEFAULT NULL,
  address TEXT DEFAULT NULL,
  business_type VARCHAR(100) DEFAULT NULL,
  profile_completed TINYINT(1) DEFAULT 0,
  verification_code VARCHAR(6),
  email_verified TINYINT(1) DEFAULT 0,
  account_status ENUM('active','inactive') DEFAULT 'active',
  deleted_at DATETIME DEFAULT NULL,
  reactivation_code VARCHAR(6) DEFAULT NULL,
  delete_code VARCHAR(6) DEFAULT NULL,
  reset_code VARCHAR(6) DEFAULT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
