migrations/Version20251022100200.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. /**
  11.  * Reorder client_id columns to be positioned directly after id column.
  12.  * Ensures consistency: id, client_id, ... other columns
  13.  */
  14. final class Version20251022100200 extends AbstractMigration
  15. {
  16.     public function getDescription(): string
  17.     {
  18.         return 'Reorder client_id columns to position 2 (after id) in all tables';
  19.     }
  21.     private function columnExists(string $table, string $column): bool
  22.     {
  23.         $result = $this->connection->fetchOne(
  24.             "SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS 
  25.              WHERE TABLE_SCHEMA = DATABASE() 
  26.              AND TABLE_NAME = ? 
  27.              AND COLUMN_NAME = ?",
  28.             [$table, $column]
  29.         );
  30.         
  31.         return $result > 0;
  32.     }
  34.     private function getFirstColumn(string $table): ?string
  35.     {
  36.         $result = $this->connection->fetchOne(
  37.             "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS 
  38.              WHERE TABLE_SCHEMA = DATABASE() 
  39.              AND TABLE_NAME = ? 
  40.              ORDER BY ORDINAL_POSITION 
  41.              LIMIT 1",
  42.             [$table]
  43.         );
  44.         
  45.         return $result ?: null;
  46.     }
  48.     public function up(Schema $schema): void
  49.     {
  50.         // ============================================================
  51.         // Reposition client_id to be right after id column
  52.         // Using MODIFY COLUMN ... AFTER id
  53.         // ============================================================
  54.         
  55.         $tables = [
  56.             // Core entities
  57.             'person',
  58.             'provider', 
  59.             'speaker',
  60.             'tags',
  61.             
  62.             // Newsletter & Communication
  63.             'newsletter',
  64.             'manual_newsletter',
  65.             'attachment',
  66.             
  67.             // Courses & Events
  68.             'course',
  69.             'course_data',
  70.             'course_field',
  71.             'course_occurrence',
  72.             'course_occurrence_time',
  73.             'course_series',
  74.             'course_subscription',
  75.             'course_subscription_booking',
  76.             'course_type',
  77.             'course_image',
  78.             'course_text',
  79.             
  80.             // Shopping & Orders
  81.             'cart',
  82.             'cart_item',
  83.             'customer_order',
  84.             'customer_order_item',
  85.             'customer_order_item_person',
  86.             'wait_item',
  87.             
  88.             // Invoicing
  89.             'invoice',
  90.             'invoice_item',
  91.             'invoice_item_attendees',
  92.             'invoice_payment',
  93.             'invoice_reminder',
  94.             
  95.             // Customer Management
  96.             'customer_document',
  97.             'customer_history_entry',
  98.             
  99.             // System & Configuration
  100.             'client_config',
  101.             'textblocks',
  102.             'protocol_entry',
  103.             'presence',
  104.             'presence_reason',
  105.             'ckimage',
  106.             'search_index_entry',
  107.             'email_history_entry',
  108.             
  109.             // Venue & Location
  110.             'venue',
  111.             'venue_room',
  112.             'venue_document',
  113.             'venue_image',
  114.             
  115.             // Speaker related
  116.             'speaker_image',
  117.             'speaker_text',
  118.             
  119.             // Categories
  120.             'category',
  121.         ];
  123.         foreach ($tables as $table) {
  124.             // Skip search_index_entry - it has a composite primary key
  125.             if ($table === 'search_index_entry') {
  126.                 // Special handling for search_index_entry: rename clientId to client_id
  127.                 if ($this->columnExists($table, 'clientId')) {
  128.                     $this->addSql("ALTER TABLE $table CHANGE clientId client_id INT NOT NULL FIRST");
  129.                 } elseif ($this->columnExists($table, 'client_id')) {
  130.                     // Already renamed, just position it first
  131.                     $this->addSql("ALTER TABLE $table MODIFY client_id INT NOT NULL FIRST");
  132.                 }
  133.                 continue;
  134.             }
  135.             
  136.             if ($this->columnExists($table, 'client_id')) {
  137.                 // Check if table has 'id' column
  138.                 if ($this->columnExists($table, 'id')) {
  139.                     // Position after 'id' column
  140.                     $this->addSql("ALTER TABLE $table MODIFY client_id INT DEFAULT NULL AFTER id");
  141.                 } else {
  142.                     // Skip tables without 'id' column
  143.                     // This shouldn't happen in our entities
  144.                 }
  145.             }
  146.         }
  147.     }
  149.     public function down(Schema $schema): void
  150.     {
  151.         // No need to reverse - column order doesn't affect functionality
  152.         // But if needed, we could reposition to original location
  153.     }
  154. }