Passed
Push — develop ( 37c69c...faa16c )
by Laurent
03:14 queued 37s
created

Version20201219174027::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 12
Code Lines 9

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
cc 1
eloc 9
c 1
b 0
f 0
nc 1
nop 1
dl 0
loc 12
rs 9.9666
1
<?php
2
3
declare(strict_types=1);
4
5
/*
6
 * This file is part of the G.L.S.R. Apps package.
7
 *
8
 * (c) Dev-Int Création <[email protected]>.
9
 *
10
 * For the full copyright and license information, please view the LICENSE
11
 * file that was distributed with this source code.
12
 */
13
14
namespace Administration\Infrastructure\DoctrineMigrations;
15
16
use Doctrine\DBAL\Schema\Schema;
17
use Doctrine\Migrations\AbstractMigration;
18
19
/**
20
 * Auto-generated Migration: Please modify to your needs!
21
 */
22
final class Version20201219174027 extends AbstractMigration
23
{
24
    public function getDescription(): string
25
    {
26
        return 'Create user table';
27
    }
28
29
    public function up(Schema $schema): void
30
    {
31
        // this up() migration is auto-generated, please modify it to your needs
32
        $this->addSql(
33
            'CREATE TABLE user (' .
34
            'uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:guid)\', ' .
35
            'username VARCHAR(150) NOT NULL, ' .
36
            'email VARCHAR(255) NOT NULL, ' .
37
            'password VARCHAR(36) NOT NULL, ' .
38
            'roles LONGTEXT NOT NULL COMMENT \'(DC2Type:array)\', ' .
39
            'PRIMARY KEY(uuid)' .
40
            ') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'
41
        );
42
    }
43
44
    public function down(Schema $schema): void
45
    {
46
        // this down() migration is auto-generated, please modify it to your needs
47
        $this->addSql('DROP TABLE user');
48
    }
49
}
50