backend/database/dev/backup/update_003_make_zone_code_required_unique.sql


1
2
3
4
5
6
7
8

-- Make zone_code required and unique
-- This ensures data integrity for audits and lookups

-- First, modify the column to be NOT NULL
ALTER TABLE `zones` MODIFY `zone_code` VARCHAR(50) NOT NULL;

-- Then add the unique constraint
ALTER TABLE `zones` ADD UNIQUE KEY `unique_zone_code` (`zone_code`);