USE comptaai_maroc;

ALTER TABLE clients
  ADD COLUMN cnss_number VARCHAR(40) NULL AFTER rc,
  ADD COLUMN legal_form VARCHAR(80) NULL AFTER cnss_number,
  ADD COLUMN activity_sector VARCHAR(140) NULL AFTER legal_form,
  ADD COLUMN phone VARCHAR(40) NULL AFTER city,
  ADD COLUMN email VARCHAR(180) NULL AFTER phone,
  MODIFY status ENUM('active','inactive','archived') NOT NULL DEFAULT 'active',
  ADD INDEX clients_company_name_index (company_name),
  ADD INDEX clients_ice_index (ice),
  ADD INDEX clients_status_index (status);