ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / lab2454c / caimegroup.com / wp-content / plugins / mailpoet / lib / Migrations / Db

<?php declare(strict_types = 1);

namespace MailPoet\Migrations\Db;

if (!defined('ABSPATH')) exit;

use MailPoet\Migrator\DbMigration;

class Migration_20230703_105957 extends DbMigration {
  public function run(): void {
    $this->migrateLogTable();
    $this->migrateRunTable();
  }

public function migrateLogTable(): void {
    global $wpdb;

$table = $wpdb->prefix . 'mailpoet_automation_run_logs';
    if (!$this->indexExists($table, 'status')) {
      $this->connection->executeStatement("ALTER TABLE $table ADD INDEX `status` (`status`)");
    }
    if (!$this->indexExists($table, 'step_id')) {
      $this->connection->executeStatement("ALTER TABLE $table ADD INDEX `step_id` (`step_id`)");
    }
  }

public function migrateRunTable(): void {
    global $wpdb;

$table = $wpdb->prefix . 'mailpoet_automation_runs';
    if (!$this->indexExists($table, 'created_at')) {
      $this->connection->executeStatement("ALTER TABLE $table ADD INDEX `created_at` (`created_at`)");
    }
    if (!$this->indexExists($table, 'version_id')) {
      $this->connection->executeStatement("ALTER TABLE $table ADD INDEX `version_id` (`version_id`)");
    }
    if (!$this->indexExists($table, 'status')) {
      $this->connection->executeStatement("ALTER TABLE $table ADD INDEX `status` (`status`)");
    }
    if (!$this->indexExists($table, 'next_step_id')) {
      $this->connection->executeStatement("ALTER TABLE $table ADD INDEX `next_step_id` (`next_step_id`)");
    }
  }
}

[-] Migration_20230605_174836.php [edit]
[-] Migration_20230831_124214_Db.php [edit]
[-] Migration_20230421_135915.php [edit]
[-] Migration_20230221_200520.php [edit]
[-] index.php [edit]
[+] ..
[-] Migration_20240119_113943_Db.php [edit]
[-] Migration_20230215_050813.php [edit]
[-] Migration_20221028_105818.php [edit]
[-] Migration_20230111_120000.php [edit]
[-] Migration_20230703_105957.php [edit]
[-] Migration_20230831_143755_Db.php [edit]
[-] Migration_20230503_210945.php [edit]
[-] Migration_20221110_151621.php [edit]
[-] Migration_20230716_130221_Db.php [edit]
[-] Migration_20230824_054259_Db.php [edit]
[-] Migration_20230111_130000.php [edit]