-- افزودن فیلدهای سخت‌افزاری برای هر سرور
ALTER TABLE servers
  ADD COLUMN ram_total_gb INT NULL AFTER unit_number,
  ADD COLUMN ram_modules_count INT NULL AFTER ram_total_gb,
  ADD COLUMN ram_freq_mhz INT NULL AFTER ram_modules_count,
  ADD COLUMN cpu_model VARCHAR(200) NULL AFTER ram_freq_mhz,
  ADD COLUMN cpu_count INT NULL AFTER cpu_model,
  ADD COLUMN nic_speed_gbps INT NULL AFTER cpu_count,
  ADD COLUMN sfp_owner ENUM('customer','provider') NULL AFTER nic_speed_gbps,
  ADD COLUMN nvme_capacity_gb INT NULL AFTER sfp_owner,
  ADD COLUMN nvme_model VARCHAR(200) NULL AFTER nvme_capacity_gb,
  ADD COLUMN nvme_serial VARCHAR(200) NULL AFTER nvme_model,
  ADD COLUMN sas_drives TEXT NULL AFTER nvme_serial;
