-- Run this SQL in your MySQL database (e.g., via phpMyAdmin)
ALTER TABLE users ADD COLUMN password VARCHAR(255) AFTER email;

-- Optional: If you want to make email unique (recommended)
ALTER TABLE users ADD UNIQUE (email);
