|
@@ 20-28 (lines=9) @@
|
| 17 |
|
return ''; |
| 18 |
|
} |
| 19 |
|
|
| 20 |
|
public function up(Schema $schema) : void |
| 21 |
|
{ |
| 22 |
|
// this up() migration is auto-generated, please modify it to your needs |
| 23 |
|
$this->addSql('ALTER TABLE users CHANGE roles roles LONGTEXT NOT NULL COMMENT \'(DC2Type:json)\''); |
| 24 |
|
$this->addSql('DROP INDEX uniq_8d93d649f85e0677 ON users'); |
| 25 |
|
$this->addSql('CREATE UNIQUE INDEX UNIQ_1483A5E9F85E0677 ON users (username)'); |
| 26 |
|
$this->addSql('DROP INDEX uniq_8d93d649e7927c74 ON users'); |
| 27 |
|
$this->addSql('CREATE UNIQUE INDEX UNIQ_1483A5E9E7927C74 ON users (email)'); |
| 28 |
|
} |
| 29 |
|
|
| 30 |
|
public function down(Schema $schema) : void |
| 31 |
|
{ |
|
@@ 30-38 (lines=9) @@
|
| 27 |
|
$this->addSql('CREATE UNIQUE INDEX UNIQ_1483A5E9E7927C74 ON users (email)'); |
| 28 |
|
} |
| 29 |
|
|
| 30 |
|
public function down(Schema $schema) : void |
| 31 |
|
{ |
| 32 |
|
// this down() migration is auto-generated, please modify it to your needs |
| 33 |
|
$this->addSql('ALTER TABLE users CHANGE roles roles LONGTEXT CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_bin`'); |
| 34 |
|
$this->addSql('DROP INDEX uniq_1483a5e9f85e0677 ON users'); |
| 35 |
|
$this->addSql('CREATE UNIQUE INDEX UNIQ_8D93D649F85E0677 ON users (username)'); |
| 36 |
|
$this->addSql('DROP INDEX uniq_1483a5e9e7927c74 ON users'); |
| 37 |
|
$this->addSql('CREATE UNIQUE INDEX UNIQ_8D93D649E7927C74 ON users (email)'); |
| 38 |
|
} |
| 39 |
|
} |
| 40 |
|
|