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

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;

/**
 * The "created_at" column must be NULL in some tables to avoid "there can be only one
 * TIMESTAMP column with CURRENT_TIMESTAMP" error on MySQL version < 5.6.5 that occurs
 * even when other timestamp is simply "NOT NULL".
 *
 * Additionally, having multiple timestamp columns with "NOT NULL" seems to produce the
 * following error in some SQL modes:
 *   SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'updated_at'"
 */
class Migration_20221110_151621 extends DbMigration {
  public function run(): void {
    $this->createTable('automations', [
      'id int(11) unsigned NOT NULL AUTO_INCREMENT',
      'name varchar(191) NOT NULL',
      'author bigint NOT NULL',
      'status varchar(191) NOT NULL',
      'created_at timestamp NULL', // must be NULL, see comment at the top
      'updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP',
      'activated_at timestamp NULL',
      'deleted_at timestamp NULL',
      'PRIMARY KEY (id)',
    ]);

$this->createTable('automation_versions', [
      'id int(11) unsigned NOT NULL AUTO_INCREMENT',
      'automation_id int(11) unsigned NOT NULL',
      'steps longtext',
      'created_at timestamp NULL', // must be NULL, see comment at the top
      'updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP',
      'PRIMARY KEY (id)',
      'INDEX (automation_id)',
    ]);

$this->createTable('automation_triggers', [
      'automation_id int(11) unsigned NOT NULL',
      'trigger_key varchar(191)',
      'PRIMARY KEY (automation_id, trigger_key)',
    ]);

$this->createTable('automation_runs', [
      'id int(11) unsigned NOT NULL AUTO_INCREMENT',
      'automation_id int(11) unsigned NOT NULL',
      'version_id int(11) unsigned NOT NULL',
      'trigger_key varchar(191) NOT NULL',
      'status varchar(191) NOT NULL',
      'created_at timestamp NULL', // must be NULL, see comment at the top
      'updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP',
      'subjects longtext',
      'next_step_id varchar(191)',
      'PRIMARY KEY (id)',
      'INDEX (automation_id, status)',
    ]);

$this->createTable('automation_run_logs', [
      'id int(11) unsigned NOT NULL AUTO_INCREMENT',
      'automation_run_id int(11) unsigned NOT NULL',
      'step_id varchar(191) NOT NULL',
      'status varchar(191) NOT NULL',
      'started_at timestamp NOT NULL',
      'completed_at timestamp NULL DEFAULT NULL',
      'error longtext',
      'data longtext',
      'PRIMARY KEY (id)',
      'INDEX (automation_run_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]