CREATE TABLE suppliers (
  id TEXT PRIMARY KEY,
  name TEXT NOT NULL,
  supplier_type TEXT NOT NULL,
  category TEXT NOT NULL DEFAULT 'Maintenance',
  specialties TEXT NOT NULL DEFAULT '',
  ice TEXT NOT NULL DEFAULT '',
  rc TEXT NOT NULL DEFAULT '',
  contact_name TEXT NOT NULL DEFAULT '',
  phone TEXT NOT NULL DEFAULT '',
  email TEXT NOT NULL DEFAULT '',
  address TEXT NOT NULL DEFAULT '',
  city TEXT NOT NULL DEFAULT '',
  payment_terms TEXT NOT NULL DEFAULT '30 jours',
  rating_tenths INTEGER NOT NULL DEFAULT 40,
  status TEXT NOT NULL DEFAULT 'Actif',
  created_by TEXT NOT NULL,
  created_at TEXT NOT NULL,
  updated_at TEXT NOT NULL
);
CREATE UNIQUE INDEX idx_suppliers_name ON suppliers(name COLLATE NOCASE);
CREATE INDEX idx_suppliers_type_status ON suppliers(supplier_type, status);