-- PHP User Registration - Migration: add new feature columns
-- Developer: Molla Samser | RSK World - https://rskworld.in
-- Contact: help@rskworld.in | +91 93305 39277
-- Year: 2026
-- Run once on existing database if you added this project before the new features.
-- Select your database first (e.g. php_registration or b11_41100569_2), then run.

ALTER TABLE users ADD COLUMN password_reset_token VARCHAR(64) NULL AFTER token_expires_at;
ALTER TABLE users ADD COLUMN password_reset_expires_at DATETIME NULL AFTER password_reset_token;
ALTER TABLE users ADD COLUMN last_login_at DATETIME NULL AFTER password_reset_expires_at;
ALTER TABLE users ADD INDEX idx_password_reset_token (password_reset_token);
