-- Migration: add is_active boolean to clients for soft-delete

ALTER TABLE clients
  ADD COLUMN is_active TINYINT(1) NOT NULL DEFAULT 1,
  ADD INDEX idx_clients_is_active (is_active);

-- Optional: mark existing clients as active (default handles it)
