@@ -30,13 +30,13 @@ |
||
30 | 30 | { |
31 | 31 | // this up() migration is auto-generated, please modify it to your needs |
32 | 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)' . |
|
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 | 40 | ') DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB' |
41 | 41 | ); |
42 | 42 | } |