migrations/Version20230220133203.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. final class Version20230220133203 extends AbstractMigration
  11. {
  12.     public function getDescription(): string
  13.     {
  14.         return 'Add relation ManyToMany to city and neighborhood fields';
  15.     }
  17.     public function up(Schema $schema): void
  18.     {
  19.         $this->addSql('CREATE TABLE business_request_neighborhood (business_request_entity_id UUID NOT NULL, 
  20.         neighborhood_id INT NOT NULL, PRIMARY KEY(business_request_entity_id, neighborhood_id))');
  21.         $this->addSql('CREATE INDEX IDX_E7649CEC22E18243 ON business_request_neighborhood 
  22.         (business_request_entity_id)');
  23.         $this->addSql('CREATE INDEX IDX_E7649CEC803BB24B ON business_request_neighborhood (neighborhood_id)');
  24.         $this->addSql('COMMENT ON COLUMN business_request_neighborhood.business_request_entity_id 
  25.         IS \'(DC2Type:ulid)\'');
  26.         $this->addSql('CREATE TABLE business_request_city (business_request_entity_id UUID NOT NULL, 
  27.         city_id INT NOT NULL, PRIMARY KEY(business_request_entity_id, city_id))');
  28.         $this->addSql('CREATE INDEX IDX_11D4087D22E18243 ON business_request_city (business_request_entity_id)');
  29.         $this->addSql('CREATE INDEX IDX_11D4087D8BAC62AF ON business_request_city (city_id)');
  30.         $this->addSql('COMMENT ON COLUMN business_request_city.business_request_entity_id IS \'(DC2Type:ulid)\'');
  31.         $this->addSql('ALTER TABLE business_request_neighborhood ADD CONSTRAINT FK_E7649CEC22E18243 
  32.         FOREIGN KEY (business_request_entity_id) REFERENCES business_request (id) ON DELETE CASCADE NOT 
  33.         DEFERRABLE INITIALLY IMMEDIATE');
  34.         $this->addSql('ALTER TABLE business_request_neighborhood ADD CONSTRAINT FK_E7649CEC803BB24B 
  35.         FOREIGN KEY (neighborhood_id) REFERENCES neighborhood (id) ON DELETE CASCADE NOT DEFERRABLE 
  36.         INITIALLY IMMEDIATE');
  37.         $this->addSql('ALTER TABLE business_request_city ADD CONSTRAINT FK_11D4087D22E18243 
  38.         FOREIGN KEY (business_request_entity_id) REFERENCES business_request (id) ON DELETE CASCADE NOT DEFERRABLE 
  39.         INITIALLY IMMEDIATE');
  40.         $this->addSql('ALTER TABLE business_request_city ADD CONSTRAINT FK_11D4087D8BAC62AF FOREIGN KEY (city_id) 
  41.         REFERENCES city (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
  42.         $this->addSql('ALTER TABLE business_request DROP neighborhood');
  43.         $this->addSql('ALTER TABLE business_request DROP city');
  44.         $this->addSql('ALTER TABLE business_request ALTER price DROP NOT NULL');
  45.     }
  47.     public function down(Schema $schema): void
  48.     {
  49.         $this->addSql('ALTER TABLE business_request_neighborhood DROP CONSTRAINT FK_E7649CEC22E18243');
  50.         $this->addSql('ALTER TABLE business_request_neighborhood DROP CONSTRAINT FK_E7649CEC803BB24B');
  51.         $this->addSql('ALTER TABLE business_request_city DROP CONSTRAINT FK_11D4087D22E18243');
  52.         $this->addSql('ALTER TABLE business_request_city DROP CONSTRAINT FK_11D4087D8BAC62AF');
  53.         $this->addSql('DROP TABLE business_request_neighborhood');
  54.         $this->addSql('DROP TABLE business_request_city');
  55.         $this->addSql('ALTER TABLE business_request ADD neighborhood VARCHAR(255) DEFAULT NULL');
  56.         $this->addSql('ALTER TABLE business_request ADD city INT NOT NULL');
  57.         $this->addSql('ALTER TABLE business_request ALTER price SET NOT NULL');
  58.     }
  59. }