🌙 File Manager - @r3dc0d3r1337-WORDPRESS
PHP:
8.1.34
Server:
LiteSpeed
OS:
Linux 5.14.0-611.34.1.el9_7.x86_64
User:
fastear1
Navigate
Upload:
Upload
New File
New Folder
Editing: update_database.sql
-- Quick Update Script - Add Missing Columns -- This will update your existing database without losing data USE fast_earn_2; -- Add username column if it doesn't exist ALTER TABLE users ADD COLUMN IF NOT EXISTS username VARCHAR(50) UNIQUE DEFAULT NULL COMMENT 'Username for admin login' AFTER id; -- Add role column if it doesn't exist ALTER TABLE users ADD COLUMN IF NOT EXISTS role ENUM('user', 'admin') DEFAULT 'user' COMMENT 'User role' AFTER password; -- Update admin user (ID = 1) with username and role UPDATE users SET username = 'admin', role = 'admin', full_name = 'Administrator' WHERE id = 1; -- Set all other users to role 'user' UPDATE users SET role = 'user' WHERE id != 1 AND role IS NULL; SELECT 'Database updated successfully!' as Status;
Save Changes
Cancel
Create New File
Create New Folder