create_admin_script.js

const bcrypt = require('bcrypt');
const mysql = require('mysql2/promise');

// UPDATE THESE WITH YOUR DATABASE CREDENTIALS
const DB_CONFIG = {
    host: 'localhost',
    user: 'univ_user',              // Change to your MySQL username
    password: '98652006',  // Change to your MySQL password
    database: 'university_map'
};

async function createAdminUser() {
    let connection;
    
    try {
        console.log('🔗 Connecting to database...');
        connection = await mysql.createConnection(DB_CONFIG);
        console.log('✅ Connected to database\n');

        // Define admin credentials
        const adminUser = {
            username: 'admin',
            password: 'admin123',  // Plain text password
            email: 'admin@university.edu',
            full_name: 'System Administrator',
            role: 'admin'
        };

        console.log('🔐 Hashing password...');
        const password_hash = await bcrypt.hash(adminUser.password, 10);
        console.log('✅ Password hashed successfully');
        console.log('Hash:', password_hash, '\n');

        // Check if admin already exists
        console.log('🔍 Checking for existing admin user...');
        const [existingUsers] = await connection.query(
            'SELECT user_id, username FROM users WHERE username = ?',
            [adminUser.username]
        );

        if (existingUsers.length > 0) {
            console.log('⚠️  Admin user already exists. Updating password...');
            await connection.query(
                'UPDATE users SET password_hash = ?, email = ?, full_name = ?, role = ?, is_active = TRUE WHERE username = ?',
                [password_hash, adminUser.email, adminUser.full_name, adminUser.role, adminUser.username]
            );
            console.log('✅ Admin password updated successfully!');
        } else {
            console.log('➕ Creating new admin user...');
            await connection.query(
                'INSERT INTO users (username, password_hash, email, full_name, role, is_active) VALUES (?, ?, ?, ?, ?, TRUE)',
                [adminUser.username, password_hash, adminUser.email, adminUser.full_name, adminUser.role]
            );
            console.log('✅ Admin user created successfully!');
        }

        // Verify the user was created/updated
        console.log('\n📋 Verifying admin user...');
        const [users] = await connection.query(
            'SELECT user_id, username, email, full_name, role, is_active FROM users WHERE username = ?',
            [adminUser.username]
        );

        if (users.length > 0) {
            console.log('✅ Admin user verified:');
            console.log('─────────────────────────────────────');
            console.log('User ID    :', users[0].user_id);
            console.log('Username   :', users[0].username);
            console.log('Email      :', users[0].email);
            console.log('Full Name  :', users[0].full_name);
            console.log('Role       :', users[0].role);
            console.log('Active     :', users[0].is_active ? 'Yes' : 'No');
            console.log('─────────────────────────────────────');
        }

        // Test the password
        console.log('\n🧪 Testing password verification...');
        const [testUsers] = await connection.query(
            'SELECT password_hash FROM users WHERE username = ?',
            [adminUser.username]
        );
        
        const isValid = await bcrypt.compare(adminUser.password, testUsers[0].password_hash);
        
        if (isValid) {
            console.log('✅ Password verification test PASSED!');
        } else {
            console.log('❌ Password verification test FAILED!');
            throw new Error('Password verification failed');
        }

        console.log('\n🎉 SUCCESS! You can now login with:');
        console.log('─────────────────────────────────────');
        console.log('Username: admin');
        console.log('Password: admin123');
        console.log('─────────────────────────────────────');
        console.log('\n💡 TIP: Change this password after first login!');

    } catch (error) {
        console.error('\n❌ ERROR:', error.message);
        
        if (error.code === 'ER_ACCESS_DENIED_ERROR') {
            console.log('\n🔧 Fix: Update DB_CONFIG in this file with correct MySQL credentials');
        } else if (error.code === 'ER_BAD_DB_ERROR') {
            console.log('\n🔧 Fix: Create the database first:');
            console.log('   mysql -u root -p');
            console.log('   CREATE DATABASE university_map;');
        } else if (error.code === 'ECONNREFUSED') {
            console.log('\n🔧 Fix: Start MySQL service');
        } else if (error.code === 'ER_NO_SUCH_TABLE') {
            console.log('\n🔧 Fix: Import the database schema:');
            console.log('   mysql -u root -p university_map < university_map.sql');
        }
        
        process.exit(1);
    } finally {
        if (connection) {
            await connection.end();
            console.log('\n👋 Database connection closed');
        }
    }
}

// Run the script
console.log('╔════════════════════════════════════════╗');
console.log('║   Admin User Creation Script           ║');
console.log('║   University Map System                ║');
console.log('╚════════════════════════════════════════╝\n');

createAdminUser();