migrations/Version20220818135228.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace CoreMigrations;
  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 Version20220818135228 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->addSql('CREATE TABLE products_bundle__search_association (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', product_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', declination_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', search_word_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', INDEX IDX_A4AC80614584665A (product_id), INDEX IDX_A4AC80619941A932 (declination_id), INDEX IDX_A4AC80616E86AC17 (search_word_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  24.         $this->addSql('CREATE TABLE products_bundle__search_word (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', word VARCHAR(32) NOT NULL, INDEX word (word), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  25.         $this->addSql('ALTER TABLE products_bundle__search_association ADD CONSTRAINT FK_A4AC80614584665A FOREIGN KEY (product_id) REFERENCES products_bundle__product (id)');
  26.         $this->addSql('ALTER TABLE products_bundle__search_association ADD CONSTRAINT FK_A4AC80619941A932 FOREIGN KEY (declination_id) REFERENCES products_bundle__declination (id)');
  27.         $this->addSql('ALTER TABLE products_bundle__search_association ADD CONSTRAINT FK_A4AC80616E86AC17 FOREIGN KEY (search_word_id) REFERENCES products_bundle__search_word (id)');
  28.         $this->addSql('CREATE INDEX deleted_at ON context (deleted_at)');
  29.         $this->addSql('CREATE INDEX created_at ON context (created_at)');
  30.         $this->addSql('CREATE INDEX updated_at ON context (updated_at)');
  31.         $this->addSql('CREATE INDEX deleted_at ON country (deleted_at)');
  32.         $this->addSql('CREATE INDEX created_at ON country (created_at)');
  33.         $this->addSql('CREATE INDEX updated_at ON country (updated_at)');
  34.         $this->addSql('CREATE INDEX deleted_at ON country_state (deleted_at)');
  35.         $this->addSql('CREATE INDEX created_at ON country_state (created_at)');
  36.         $this->addSql('CREATE INDEX updated_at ON country_state (updated_at)');
  37.         $this->addSql('CREATE FULLTEXT INDEX content ON country_translations (content)');
  38.         $this->addSql('CREATE INDEX deleted_at ON country_zone (deleted_at)');
  39.         $this->addSql('CREATE INDEX created_at ON country_zone (created_at)');
  40.         $this->addSql('CREATE INDEX updated_at ON country_zone (updated_at)');
  41.         $this->addSql('CREATE FULLTEXT INDEX content ON country_zone_translations (content)');
  42.         $this->addSql('CREATE INDEX deleted_at ON currency (deleted_at)');
  43.         $this->addSql('CREATE INDEX created_at ON currency (created_at)');
  44.         $this->addSql('CREATE INDEX updated_at ON currency (updated_at)');
  45.         $this->addSql('CREATE INDEX deleted_at ON language (deleted_at)');
  46.         $this->addSql('CREATE INDEX created_at ON language (created_at)');
  47.         $this->addSql('CREATE INDEX updated_at ON language (updated_at)');
  48.         $this->addSql('CREATE INDEX deleted_at ON mail_server (deleted_at)');
  49.         $this->addSql('CREATE INDEX deleted_at ON profile (deleted_at)');
  50.         $this->addSql('DROP INDEX location_unique ON stocks_bundle__location');
  51.         $this->addSql('CREATE UNIQUE INDEX location_unique ON stocks_bundle__location (warehouse_id, x, y, z, deleted_at)');
  52.         $this->addSql('CREATE INDEX deleted_at ON tax (deleted_at)');
  53.         $this->addSql('CREATE INDEX created_at ON tax (created_at)');
  54.         $this->addSql('CREATE INDEX updated_at ON tax (updated_at)');
  55.         $this->addSql('CREATE INDEX deleted_at ON tax_rule (deleted_at)');
  56.         $this->addSql('CREATE INDEX created_at ON tax_rule (created_at)');
  57.         $this->addSql('CREATE INDEX updated_at ON tax_rule (updated_at)');
  58.         $this->addSql('CREATE INDEX deleted_at ON tax_rule_country (deleted_at)');
  59.         $this->addSql('CREATE INDEX created_at ON tax_rule_country (created_at)');
  60.         $this->addSql('CREATE INDEX updated_at ON tax_rule_country (updated_at)');
  61.         $this->addSql('CREATE INDEX deleted_at ON unit_measure (deleted_at)');
  62.         $this->addSql('CREATE INDEX created_at ON unit_measure (created_at)');
  63.         $this->addSql('CREATE INDEX updated_at ON unit_measure (updated_at)');
  64.         $this->addSql('DROP INDEX state ON user');
  65.         $this->addSql('CREATE INDEX is_active ON user (is_active)');
  66.         $this->addSql('CREATE INDEX deleted_at ON user (deleted_at)');
  67.         $this->addSql('CREATE INDEX created_at ON user (created_at)');
  68.         $this->addSql('CREATE INDEX updated_at ON user (updated_at)');
  69.         $this->addSql('CREATE INDEX is_active ON webservice_key (is_active)');
  70.         $this->addSql('CREATE INDEX deleted_at ON webservice_key (deleted_at)');
  71.         $this->addSql('CREATE INDEX created_at ON webservice_key (created_at)');
  72.         $this->addSql('CREATE INDEX updated_at ON webservice_key (updated_at)');
  73.         $this->addSql('CREATE INDEX deleted_at ON webservice_permission (deleted_at)');
  74.         $this->addSql('CREATE INDEX created_at ON webservice_permission (created_at)');
  75.         $this->addSql('CREATE INDEX updated_at ON webservice_permission (updated_at)');
  76.     }
  78.     public function down(Schema $schema): void
  79.     {
  80.         // this down() migration is auto-generated, please modify it to your needs
  81.         $this->addSql('ALTER TABLE products_bundle__search_association DROP FOREIGN KEY FK_A4AC80616E86AC17');
  82.         $this->addSql('DROP TABLE products_bundle__search_association');
  83.         $this->addSql('DROP TABLE products_bundle__search_word');
  84.         $this->addSql('DROP INDEX deleted_at ON context');
  85.         $this->addSql('DROP INDEX created_at ON context');
  86.         $this->addSql('DROP INDEX updated_at ON context');
  87.         $this->addSql('DROP INDEX deleted_at ON country');
  88.         $this->addSql('DROP INDEX created_at ON country');
  89.         $this->addSql('DROP INDEX updated_at ON country');
  90.         $this->addSql('DROP INDEX deleted_at ON country_state');
  91.         $this->addSql('DROP INDEX created_at ON country_state');
  92.         $this->addSql('DROP INDEX updated_at ON country_state');
  93.         $this->addSql('DROP INDEX content ON country_translations');
  94.         $this->addSql('DROP INDEX deleted_at ON country_zone');
  95.         $this->addSql('DROP INDEX created_at ON country_zone');
  96.         $this->addSql('DROP INDEX updated_at ON country_zone');
  97.         $this->addSql('DROP INDEX content ON country_zone_translations');
  98.         $this->addSql('DROP INDEX deleted_at ON currency');
  99.         $this->addSql('DROP INDEX created_at ON currency');
  100.         $this->addSql('DROP INDEX updated_at ON currency');
  101.         $this->addSql('DROP INDEX deleted_at ON language');
  102.         $this->addSql('DROP INDEX created_at ON language');
  103.         $this->addSql('DROP INDEX updated_at ON language');
  104.         $this->addSql('DROP INDEX deleted_at ON mail_server');
  105.         $this->addSql('DROP INDEX deleted_at ON profile');
  106.         $this->addSql('DROP INDEX location_unique ON stocks_bundle__location');
  107.         $this->addSql('CREATE UNIQUE INDEX location_unique ON stocks_bundle__location (warehouse_id, x, y, z)');
  108.         $this->addSql('DROP INDEX deleted_at ON tax');
  109.         $this->addSql('DROP INDEX created_at ON tax');
  110.         $this->addSql('DROP INDEX updated_at ON tax');
  111.         $this->addSql('DROP INDEX deleted_at ON tax_rule');
  112.         $this->addSql('DROP INDEX created_at ON tax_rule');
  113.         $this->addSql('DROP INDEX updated_at ON tax_rule');
  114.         $this->addSql('DROP INDEX deleted_at ON tax_rule_country');
  115.         $this->addSql('DROP INDEX created_at ON tax_rule_country');
  116.         $this->addSql('DROP INDEX updated_at ON tax_rule_country');
  117.         $this->addSql('DROP INDEX deleted_at ON unit_measure');
  118.         $this->addSql('DROP INDEX created_at ON unit_measure');
  119.         $this->addSql('DROP INDEX updated_at ON unit_measure');
  120.         $this->addSql('DROP INDEX is_active ON user');
  121.         $this->addSql('DROP INDEX deleted_at ON user');
  122.         $this->addSql('DROP INDEX created_at ON user');
  123.         $this->addSql('DROP INDEX updated_at ON user');
  124.         $this->addSql('CREATE INDEX state ON user (is_active, deleted_at)');
  125.         $this->addSql('DROP INDEX is_active ON webservice_key');
  126.         $this->addSql('DROP INDEX deleted_at ON webservice_key');
  127.         $this->addSql('DROP INDEX created_at ON webservice_key');
  128.         $this->addSql('DROP INDEX updated_at ON webservice_key');
  129.         $this->addSql('DROP INDEX deleted_at ON webservice_permission');
  130.         $this->addSql('DROP INDEX created_at ON webservice_permission');
  131.         $this->addSql('DROP INDEX updated_at ON webservice_permission');
  132.     }
  133. }