Passed
Push — master ( 9bcb7e...39575c )
by
unknown
10:52
created

Version20170626122910::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 5
Code Lines 2

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 1
eloc 2
nc 1
nop 1
dl 0
loc 5
rs 10
c 0
b 0
f 0
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 Version20170626122910 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