-- Manual SQL equivalent to Doctrine migration Version20260506200000
-- Description: Add start/end agency flags to listpickup routes
--
-- Ejecutar en MySQL/MariaDB contra la base del entorno cuando no usás doctrine:migrations.

-- UP
ALTER TABLE `listpickup`
  ADD COLUMN `start_in_agency` TINYINT(1) NOT NULL DEFAULT 0,
  ADD COLUMN `end_in_agency` TINYINT(1) NOT NULL DEFAULT 0;

-- DOWN / rollback manual (solo si necesitás revertir)
-- ALTER TABLE `listpickup`
--   DROP COLUMN `start_in_agency`,
--   DROP COLUMN `end_in_agency`;