52 lines
1.8 KiB
PHP
Executable File
52 lines
1.8 KiB
PHP
Executable File
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
namespace Mautic\Migrations;
|
|
|
|
use Doctrine\DBAL\Schema\Schema;
|
|
use Doctrine\Migrations\Exception\SkipMigration;
|
|
use Mautic\CoreBundle\Doctrine\AbstractMauticMigration;
|
|
|
|
final class Version20201019100000 extends AbstractMauticMigration
|
|
{
|
|
protected const TABLE_NAME = 'emails_draft';
|
|
|
|
/**
|
|
* @throws SkipMigration
|
|
*/
|
|
public function preUp(Schema $schema): void
|
|
{
|
|
if ($schema->hasTable($this->getPrefixedTableName())) {
|
|
throw new SkipMigration(sprintf('Table %s already exists. Skipping migration', $this->getPrefixedTableName()));
|
|
}
|
|
}
|
|
|
|
public function up(Schema $schema): void
|
|
{
|
|
$emailsTable = $schema->getTable($this->getPrefixedTableName('emails'));
|
|
$idColumn = $emailsTable->getColumn('id');
|
|
$idDataType = $idColumn->getUnsigned() ? 'UNSIGNED' : 'SIGNED';
|
|
$fkName = $this->generatePropertyName('emails_draft', 'fk', ['email_id']);
|
|
$ukName = $this->generatePropertyName('emails_draft', 'uniq', ['email_id']);
|
|
|
|
$this->addSql(
|
|
"CREATE TABLE `{$this->getPrefixedTableName()}` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`email_id` int(10) {$idDataType} NOT NULL,
|
|
`html` longtext,
|
|
`template` varchar(191) DEFAULT NULL,
|
|
`public_preview` tinyint(1) DEFAULT 1 NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `{$ukName}` (`email_id`),
|
|
CONSTRAINT `{$fkName}` FOREIGN KEY (`email_id`) REFERENCES `{$this->getPrefixedTableName('emails')}` (`id`)
|
|
)DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC;"
|
|
);
|
|
}
|
|
|
|
public function down(Schema $schema): void
|
|
{
|
|
$schema->dropTable($this->getPrefixedTableName());
|
|
}
|
|
}
|