-- Migration: Add employee profile fields for internal directory
-- Adds fields for bio, hobbies, skills, interests, and social links
-- These are optional fields employees can choose to share

-- Add profile fields to users table (since profile data is associated with the user)
ALTER TABLE `users` 
ADD COLUMN `bio` TEXT NULL COMMENT 'Short bio or about me' AFTER `notes`,
ADD COLUMN `hobbies` TEXT NULL COMMENT 'Personal hobbies and interests' AFTER `bio`,
ADD COLUMN `skills` TEXT NULL COMMENT 'Professional skills (comma-separated)' AFTER `hobbies`,
ADD COLUMN `interests` TEXT NULL COMMENT 'Professional interests' AFTER `skills`,
ADD COLUMN `linkedin_url` VARCHAR(255) NULL AFTER `interests`,
ADD COLUMN `personal_website` VARCHAR(255) NULL AFTER `linkedin_url`,
ADD COLUMN `fun_fact` TEXT NULL COMMENT 'Fun fact about yourself' AFTER `personal_website`,
ADD COLUMN `favorite_quote` TEXT NULL AFTER `fun_fact`,
ADD COLUMN `years_of_experience` INT NULL AFTER `favorite_quote`,
ADD COLUMN `education` TEXT NULL COMMENT 'Educational background' AFTER `years_of_experience`,
ADD COLUMN `certifications` TEXT NULL COMMENT 'Professional certifications' AFTER `education`,
ADD COLUMN `languages` VARCHAR(255) NULL COMMENT 'Languages spoken' AFTER `certifications`,
ADD COLUMN `timezone` VARCHAR(50) NULL DEFAULT 'America/New_York' AFTER `languages`,
ADD COLUMN `show_in_directory` TINYINT(1) NOT NULL DEFAULT 1 COMMENT 'Show profile in employee directory' AFTER `timezone`;

-- Add index for directory filtering
ALTER TABLE `users` ADD INDEX `idx_show_in_directory` (`show_in_directory`);