-- =============================================================================
-- Manual SQL — pickup route item order column
--
-- Version20260506213000 — add column (legacy name: orden)
-- Version20260521180000 — rename orden -> order
--
-- Run the block that matches your database state.
-- =============================================================================

SET NAMES utf8mb4;

-- -----------------------------------------------------------------------------
-- Fresh install (no order column yet)
-- -----------------------------------------------------------------------------
-- ALTER TABLE `pickup` ADD COLUMN `order` INT DEFAULT NULL;

-- -----------------------------------------------------------------------------
-- Version20260521180000 — rename orden -> order (if column is still named orden)
-- -----------------------------------------------------------------------------
ALTER TABLE `pickup` CHANGE `orden` `order` INT DEFAULT NULL;

-- -----------------------------------------------------------------------------
-- Rollback — uncomment only to revert the rename
-- -----------------------------------------------------------------------------
-- ALTER TABLE `pickup` CHANGE `order` `orden` INT DEFAULT NULL;