Spaces:
No application file
No application file
File size: 1,921 Bytes
d2897cd |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 |
<?php
namespace Mautic\CoreBundle\Doctrine;
use Doctrine\DBAL\Schema\Schema;
/**
* @deprecated since Mautic 5.0, to be removed in 6.0 with no replacement.
*/
trait TranslationMigrationTrait
{
/**
* Add translation parent/child relationship columns.
*/
protected function addTranslationSchema(Schema $schema, $tableName, $languageColumnName = 'lang')
{
$fkName = $this->generatePropertyName($tableName, 'fk', ['translation_parent_id']);
$idxName = $this->generatePropertyName($tableName, 'idx', ['translation_parent_id']);
$tableName = "{$this->prefix}$tableName";
$table = $schema->getTable($tableName);
if (!$table->hasColumn('translation_parent_id')) {
$this->addSql("ALTER TABLE $tableName ADD translation_parent_id INT DEFAULT NULL");
$this->addSql(
"ALTER TABLE $tableName ADD CONSTRAINT ".$fkName
." FOREIGN KEY (translation_parent_id) REFERENCES $tableName (id) ON DELETE CASCADE"
);
$this->addSql("CREATE INDEX $idxName ON $tableName (translation_parent_id)");
} else {
// Drop and recreate the parent FK to ensure DELETE CASCADE
if ($table->hasForeignKey($fkName)) {
$this->addSql("ALTER TABLE $tableName DROP FOREIGN KEY $fkName");
}
$this->addSql(
"ALTER TABLE $tableName ADD CONSTRAINT ".$fkName
." FOREIGN KEY (translation_parent_id) REFERENCES $tableName (id) ON DELETE CASCADE"
);
if (!$table->hasIndex($idxName)) {
$this->addSql("CREATE INDEX $idxName ON $tableName (translation_parent_id)");
}
}
if ($languageColumnName && !$table->hasColumn($languageColumnName)) {
$this->addSql("ALTER TABLE $tableName ADD COLUMN `lang` varchar(191) NULL");
}
}
}
|