====================================
Fixing Domains Table Structure
====================================

Current columns: id, tld_id, domain_name, order_id, user_id, registration_date, expiry_date, auto_renew, status, date_added

Column tld_id already exists ✓
Column order_id already exists ✓
Column domain_name already exists ✓
Column user_id already exists ✓
Column registration_date already exists ✓
Column expiry_date already exists ✓
Column auto_renew already exists ✓


Status column is already ENUM ✓


Making domain_name and user_id NOT NULL...
  ✅ Columns set to NOT NULL

Index domains_user_id_index already exists ✓
Index domains_tld_id_index already exists ✓
Index domains_expiry_date_index already exists ✓

====================================
✅ Domains table structure updated!
====================================

Final columns:
  - id (int(11)) NOT NULL
  - tld_id (int(11)) NULL
  - domain_name (varchar(255)) NOT NULL
  - order_id (int(11)) NULL
  - user_id (int(11)) NOT NULL
  - registration_date (datetime) NULL
  - expiry_date (datetime) NULL
  - auto_renew (enum('0','1')) NOT NULL
  - status (enum('active','expired','transferred','cancelled')) NOT NULL
  - date_added (timestamp) NOT NULL