ALTER TABLE `users`
ADD COLUMN `email` VARCHAR(255) NOT NULL AFTER `name`,
ADD COLUMN `password` VARCHAR(255) NOT NULL AFTER `email`,
ADD COLUMN `role` VARCHAR(50) NOT NULL DEFAULT 'user' AFTER `password`;

-- Add a unique constraint to the email column to prevent duplicate emails
ALTER TABLE `users` ADD UNIQUE (`email`);