FileMaster
Search
Toggle Dark Mode
Home
/
.
/
wp-content
/
plugins
/
mailpoet
/
lib
/
Migrations
/
Db
Edit File: Migration_20230824_054259_Db.php
<?php declare(strict_types = 1); namespace MailPoet\Migrations\Db; if (!defined('ABSPATH')) exit; use MailPoet\DI\ContainerWrapper; use MailPoet\Entities\StatisticsWooCommercePurchaseEntity; use MailPoet\Migrator\DbMigration; class Migration_20230824_054259_Db extends DbMigration { public const DEFAULT_STATUS = 'unknown'; public function __construct( ContainerWrapper $container ) { parent::__construct($container); } public function run(): void { $this->createStatusColumn(); } private function createStatusColumn(): void { $revenueTable = $this->getTableName(StatisticsWooCommercePurchaseEntity::class); if (!$this->tableExists($revenueTable) || $this->columnExists($revenueTable, 'status')) { return; } $this->connection->executeQuery( "ALTER TABLE `" . $revenueTable . "` ADD COLUMN `status` VARCHAR(40) NOT NULL DEFAULT '" . self::DEFAULT_STATUS . "', ADD INDEX `status` (`status`)" ); } }
Save
Back