-- İlanı ana sayfada gösterme talepleri
CREATE TABLE IF NOT EXISTS service_feature_requests (
  id INT AUTO_INCREMENT PRIMARY KEY,
  company_id INT NOT NULL,
  service_id INT NOT NULL,
  status ENUM('pending','approved','rejected') NOT NULL DEFAULT 'pending',
  requested_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  approved_at DATETIME NULL,
  approved_until DATETIME NULL,
  admin_note TEXT NULL,
  UNIQUE KEY uniq_company_service (company_id, service_id),
  KEY idx_status_until (status, approved_until),
  KEY idx_company (company_id),
  KEY idx_service (service_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


