-- Boyz Fashion: orders e city + zone (19 Oct 2026). phpMyAdmin > SQL e paste > Go.
-- Na thakle shudhu tokhon e add hoy; duibar chalaleo error nei.
SET @db = DATABASE();

SET @s = IF((SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = @db AND TABLE_NAME = 'orders' AND COLUMN_NAME = 'city') = 0,
    'ALTER TABLE `orders` ADD COLUMN `city` VARCHAR(60) NULL DEFAULT NULL AFTER `address`',
    'SELECT ''orders.city: already ache'' AS info');
PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st;

SET @s = IF((SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = @db AND TABLE_NAME = 'orders' AND COLUMN_NAME = 'zone') = 0,
    'ALTER TABLE `orders` ADD COLUMN `zone` VARCHAR(80) NULL DEFAULT NULL AFTER `city`',
    'SELECT ''orders.zone: already ache'' AS info');
PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st;

INSERT INTO `migrations` (`migration`, `batch`)
SELECT '2026_10_19_000001_add_city_zone_to_orders', (SELECT IFNULL(MAX(`batch`), 0) + 1 FROM (SELECT `batch` FROM `migrations`) AS b)
FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM (SELECT `migration` FROM `migrations`) AS m WHERE m.migration = '2026_10_19_000001_add_city_zone_to_orders');

SELECT 'Done: city/zone added' AS result;