-- Migration to add refined registration fields to users table
ALTER TABLE users 
ADD COLUMN user_type ENUM('individual', 'organization') DEFAULT 'organization',
ADD COLUMN salutation VARCHAR(20) DEFAULT NULL,
ADD COLUMN personal_email VARCHAR(255) DEFAULT NULL,
ADD COLUMN personal_phone VARCHAR(50) DEFAULT NULL,
ADD COLUMN company_email VARCHAR(255) DEFAULT NULL,
ADD COLUMN company_phone VARCHAR(50) DEFAULT NULL,
ADD COLUMN designation VARCHAR(255) DEFAULT NULL,
ADD COLUMN website VARCHAR(255) DEFAULT NULL,
ADD COLUMN service_chains TEXT DEFAULT NULL,
ADD COLUMN enabling_pillars TEXT DEFAULT NULL,
ADD COLUMN challenges_sector TEXT DEFAULT NULL;
