USE compras_solicitacoes;
-- Adiciona buyer_id na tabela de requests (se ainda não existir)
ALTER TABLE requests
  ADD COLUMN IF NOT EXISTS buyer_id INT NULL,
  ADD INDEX IF NOT EXISTS idx_requests_buyer (buyer_id);

-- (Opcional) Se quiser amarrar o buyer_id a users.id:
-- ALTER TABLE requests
--   ADD CONSTRAINT fk_requests_buyer FOREIGN KEY (buyer_id) REFERENCES users(id);
