for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
/* For licensing terms, see /license.txt */
declare(strict_types=1);
namespace Chamilo\CoreBundle\Migrations\Schema\V200;
use Chamilo\CoreBundle\Migrations\AbstractMigrationChamilo;
use Doctrine\DBAL\Schema\Schema;
final class Version20240702222600 extends AbstractMigrationChamilo
{
public function getDescription(): string
return 'Migration resource_node --* resource_file (during development)';
}
public function up(Schema $schema): void
$tblResourceFile = $schema->getTable('resource_file');
$tblResourceNode = $schema->getTable('resource_node');
if (!$tblResourceFile->hasColumn('resource_node_id')) {
$this->addSql('ALTER TABLE resource_file ADD resource_node_id INT DEFAULT NULL');
if (!$tblResourceFile->hasForeignKey('FK_83BF96AA1BAD783F')) {
$this->addSql('ALTER TABLE resource_file ADD CONSTRAINT FK_83BF96AA1BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id)');
if (!$tblResourceFile->hasIndex('IDX_83BF96AA1BAD783F')) {
$this->addSql('CREATE INDEX IDX_83BF96AA1BAD783F ON resource_file (resource_node_id)');
if ($tblResourceNode->hasForeignKey('FK_8A5F48FFCE6B9E84')) {
$this->addSql('ALTER TABLE resource_node DROP FOREIGN KEY FK_8A5F48FFCE6B9E84');
if ($tblResourceNode->hasIndex('UNIQ_8A5F48FFCE6B9E84')) {
$this->addSql('DROP INDEX UNIQ_8A5F48FFCE6B9E84 ON resource_node');
if ($tblResourceNode->hasColumn('resource_file_id')) {
$this->addSql('ALTER TABLE resource_node DROP resource_file_id');
chamilo /
chamilo-lms
