Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory :  /home/gositeme/.cursor-server/data/User/History/1bff4b1c/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
require_once 'config/database.php';

echo "🔧 Adding missing variations fields to music_tracks table...\n\n";

$pdo = getDBConnection();
if (!$pdo) {
    echo "❌ Database connection failed\n";
    exit;
}

try {
    // Check if fields already exist
    $stmt = $pdo->query("DESCRIBE music_tracks");
    $columns = $stmt->fetchAll();
    $existingColumns = array_column($columns, 'Field');
    
    echo "📋 Current columns: " . implode(', ', $existingColumns) . "\n\n";
    
    // Add variations_count field if it doesn't exist
    if (!in_array('variations_count', $existingColumns)) {
        echo "🔧 Adding variations_count field...\n";
        $pdo->exec("ALTER TABLE music_tracks ADD COLUMN variations_count INT DEFAULT 0");
        echo "✅ variations_count field added\n";
    } else {
        echo "✅ variations_count field already exists\n";
    }
    
    // Add selected_variation field if it doesn't exist
    if (!in_array('selected_variation', $existingColumns)) {
        echo "🔧 Adding selected_variation field...\n";
        $pdo->exec("ALTER TABLE music_tracks ADD COLUMN selected_variation INT DEFAULT 0");
        echo "✅ selected_variation field added\n";
    } else {
        echo "✅ selected_variation field already exists\n";
    }
    
    // Update existing tracks to have default values
    echo "🔧 Updating existing tracks...\n";
    $pdo->exec("UPDATE music_tracks SET variations_count = 0 WHERE variations_count IS NULL");
    $pdo->exec("UPDATE music_tracks SET selected_variation = 0 WHERE selected_variation IS NULL");
    echo "✅ Existing tracks updated\n";
    
    // Verify the changes
    $stmt = $pdo->query("DESCRIBE music_tracks");
    $columns = $stmt->fetchAll();
    $updatedColumns = array_column($columns, 'Field');
    
    echo "\n📋 Updated columns: " . implode(', ', $updatedColumns) . "\n";
    
    // Check if we can now see variations
    $stmt = $pdo->query("SELECT COUNT(*) as total FROM music_tracks WHERE variations_count > 0");
    $result = $stmt->fetch();
    echo "\n📊 Tracks with variations: {$result['total']}\n";
    
    echo "\n🎯 Database update complete!\n";
    
} catch (Exception $e) {
    echo "❌ Error: " . $e->getMessage() . "\n";
}
?>