-- =============================================================================
-- 07-work-schedule-timezone.sql
-- Migration: WorkScheduleTimezone1780950000000
-- Adds working_schedule.timezone
--
-- cPanel / phpMyAdmin: paste in SQL tab → Go
-- Standard MySQL/MariaDB syntax (works on cPanel; no IF NOT EXISTS).
-- =============================================================================

ALTER TABLE `working_schedule`
  ADD `timezone` VARCHAR(64) NOT NULL DEFAULT 'Asia/Dhaka';

INSERT INTO migrations (timestamp, name)
SELECT 1780950000000, 'WorkScheduleTimezone1780950000000'
WHERE NOT EXISTS (
  SELECT 1 FROM migrations WHERE name = 'WorkScheduleTimezone1780950000000'
);

SHOW COLUMNS FROM `working_schedule` LIKE 'timezone';
