src/Migrations/Version20191203234955.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. /**
  11. * Auto-generated Migration: Please modify to your needs!
  12. */
  13. final class Version20191203234955 extends AbstractMigration
  14. {
  15. public function getDescription() : string
  16. {
  17. return '';
  18. }
  20. public function up(Schema $schema) : void
  21. {
  22. // this up() migration is auto-generated, please modify it to your needs
  23. $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
  25. $this->addSql('ALTER TABLE access DROP FOREIGN KEY FK_6692B54A76ED395');
  26. $this->addSql('DROP INDEX IDX_6692B54A76ED395 ON access');
  27. $this->addSql('ALTER TABLE access CHANGE user_id external_user_id INT DEFAULT NULL');
  28. $this->addSql('ALTER TABLE access ADD CONSTRAINT FK_6692B547ECC0AD6 FOREIGN KEY (external_user_id) REFERENCES external_user (id)');
  29. $this->addSql('CREATE INDEX IDX_6692B547ECC0AD6 ON access (external_user_id)');
  30. }
  32. public function down(Schema $schema) : void
  33. {
  34. // this down() migration is auto-generated, please modify it to your needs
  35. $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
  37. $this->addSql('ALTER TABLE access DROP FOREIGN KEY FK_6692B547ECC0AD6');
  38. $this->addSql('DROP INDEX IDX_6692B547ECC0AD6 ON access');
  39. $this->addSql('ALTER TABLE access CHANGE external_user_id user_id INT DEFAULT NULL');
  40. $this->addSql('ALTER TABLE access ADD CONSTRAINT FK_6692B54A76ED395 FOREIGN KEY (user_id) REFERENCES external_user (id)');
  41. $this->addSql('CREATE INDEX IDX_6692B54A76ED395 ON access (user_id)');
  42. }
  43. }