-- PHP User Registration - Migration: role column (user, moderator, admin, superadmin)
-- Developer: Molla Samser | RSK World - https://rskworld.in
-- Contact: help@rskworld.in | +91 93305 39277
-- Year: 2026
-- Run once. Select your database first, then run.

ALTER TABLE users ADD COLUMN role VARCHAR(30) DEFAULT 'user' AFTER is_admin;
UPDATE users SET role = 'admin' WHERE is_admin = 1;
