<?php
/**
 * Migration Configuration File
 * 
 * Copy this file and modify the settings for different migration scenarios
 */

return [
    // Source database configuration
    'source' => [
        'host' => 'localhost',
        'database' => 'old_database_name',  // CHANGE THIS to your source database
        'username' => 'root',
        'password' => '',
        'charset' => 'utf8mb4'
    ],
    
    // Destination database configuration  
    'destination' => [
        'host' => 'localhost',
        'database' => 'rxcrm',  // Current database
        'username' => 'root',
        'password' => '',
        'charset' => 'utf8mb4'
    ],
    
    // Tables to migrate
    'tables' => [
        'tblpatient',
        'tblpatientdetails', 
        'tblwcpart1',
        'tblreimbursement',
        'tblpatientstatus',
        'tblclient',
        'tblpsp',
        // Add more tables as needed
    ],
    
    // Migration options
    'options' => [
        'truncate_destination' => false,  // Clear destination tables before copying
        'batch_size' => 500,             // Records per batch
        'ignore_duplicates' => true,     // Skip duplicate records
        'log_progress' => true,          // Show detailed progress
        'backup_before_migration' => false, // Create backup before migration
    ],
    
    // Field mappings (if column names are different)
    'field_mappings' => [
        // 'old_table_name' => [
        //     'old_column_name' => 'new_column_name',
        //     'old_id' => 'new_id'
        // ]
    ],
    
    // Data transformations
    'transformations' => [
        // 'table_name' => [
        //     'column_name' => function($value) {
        //         return strtoupper($value); // Example transformation
        //     }
        // ]
    ]
];
?>