-- Add zone column to posts table
-- Aligns posts with staff zones for zone-based controller assignments

ALTER TABLE posts ADD COLUMN zone ENUM('Buea', 'Limbe', 'Douala', 'Tiko', 'Yaounde', 'Bamenda', 'Kumba') AFTER status;

ALTER TABLE posts ADD INDEX idx_zone (zone);
