-- Migration: Track who created and last updated each project
ALTER TABLE `projects`
  ADD COLUMN IF NOT EXISTS `created_by_user_id` INT UNSIGNED NULL DEFAULT NULL AFTER `created_at`,
  ADD COLUMN IF NOT EXISTS `updated_by_user_id` INT UNSIGNED NULL DEFAULT NULL AFTER `updated_at`;

-- Optional: Add index for quick lookups
CREATE INDEX IF NOT EXISTS `idx_projects_created_by` ON `projects` (`created_by_user_id`);