Passed
Pull Request — master (#6059)
by
unknown
07:48
created

Version20250129120000::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 5
Code Lines 2

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
cc 1
eloc 2
c 1
b 0
f 0
nc 1
nop 1
dl 0
loc 5
rs 10
1
<?php
2
3
declare(strict_types=1);
4
5
/* For licensing terms, see /license.txt */
6
7
namespace Chamilo\CoreBundle\Migrations\Schema\V200;
8
9
use Chamilo\CoreBundle\Migrations\AbstractMigrationChamilo;
10
use Doctrine\DBAL\Schema\Schema;
11
12
final class Version20250129120000 extends AbstractMigrationChamilo
13
{
14
    public function getDescription(): string
15
    {
16
        return 'Remove registration_date from user table and migrate data to created_at';
17
    }
18
19
    public function up(Schema $schema): void
20
    {
21
        $this->addSql('UPDATE user SET created_at = registration_date WHERE created_at IS NULL');
22
23
        $this->addSql('ALTER TABLE user DROP COLUMN registration_date');
24
    }
25
26
    public function down(Schema $schema): void
27
    {
28
        $this->addSql('ALTER TABLE user ADD registration_date DATETIME DEFAULT NULL');
29
30
        $this->addSql('UPDATE user SET registration_date = created_at WHERE registration_date IS NULL');
31
    }
32
}
33