addSql('ALTER TABLE "user" ADD roles JSON NOT NULL'); $this->addSql('ALTER TABLE "user" ALTER username TYPE VARCHAR(180)'); $this->addSql('CREATE UNIQUE INDEX UNIQ_8D93D649F85E0677 ON "user" (username)'); } public function down(Schema $schema): void { // this down() migration is auto-generated, please modify it to your needs $this->addSql('CREATE SCHEMA public'); $this->addSql('DROP INDEX UNIQ_8D93D649F85E0677'); $this->addSql('ALTER TABLE "user" DROP roles'); $this->addSql('ALTER TABLE "user" ALTER username TYPE VARCHAR(255)'); } }