-- Migration: Add email and phone fields to users table for profile
ALTER TABLE `users`
  ADD COLUMN IF NOT EXISTS `email`       VARCHAR(255) NULL DEFAULT NULL AFTER `username`,
  ADD COLUMN IF NOT EXISTS `phone`       VARCHAR(60)  NULL DEFAULT NULL AFTER `email`,
  ADD COLUMN IF NOT EXISTS `full_name`   VARCHAR(255) NULL DEFAULT NULL AFTER `phone`,
  ADD COLUMN IF NOT EXISTS `last_login_at` DATETIME NULL DEFAULT NULL;
