-- Clients table for client showcase
CREATE TABLE IF NOT EXISTS clients (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  company_name TEXT NOT NULL,
  industry TEXT NOT NULL,
  logo_url TEXT,
  description_id TEXT,
  description_en TEXT,
  project_type TEXT, -- valuation, ipo, ma, fundraising, restructuring, dd
  project_value TEXT, -- e.g., "$25M Series B", "IPO Preparation"
  completion_date DATE,
  is_featured BOOLEAN DEFAULT 0,
  is_active BOOLEAN DEFAULT 1,
  sort_order INTEGER DEFAULT 0,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
);

-- Add indexes for clients
CREATE INDEX IF NOT EXISTS idx_clients_active ON clients(is_active);
CREATE INDEX IF NOT EXISTS idx_clients_featured ON clients(is_featured);
CREATE INDEX IF NOT EXISTS idx_clients_sort ON clients(sort_order);
CREATE INDEX IF NOT EXISTS idx_clients_industry ON clients(industry);