-- database/module5.sql
-- Run this if the phone column doesn't exist in users table

ALTER TABLE `users`
    ADD COLUMN IF NOT EXISTS `phone` VARCHAR(20) NULL AFTER `email`,
    ADD COLUMN IF NOT EXISTS `status` ENUM('active','inactive') NOT NULL DEFAULT 'active' AFTER `role`;
