-- Migration: Add project_type to projects table
-- Date: 2025-01-XX
-- Description: Adds project_type field to support different project categories (promotion, development, other)

-- Add project_type column to projects table
ALTER TABLE projects 
ADD COLUMN project_type ENUM('promotion', 'development', 'other') DEFAULT 'promotion' AFTER project_name;

-- Add index for project_type
ALTER TABLE projects 
ADD INDEX idx_project_type (project_type);

