vendor/bluue/products-bundle/migrations/Version20240905100211.php line 1

Open in your IDE?
  1. <?php
  2. declare(strict_types=1);
  3. namespace ProductsBundleMigrations;
  4. use Doctrine\DBAL\Schema\Schema;
  5. use Doctrine\Migrations\AbstractMigration;
  6. final class Version20240905100211 extends AbstractMigration
  7. {
  8.     public function up(Schema $schema): void
  9.     {
  10.         $this->addSql('CREATE INDEX deleted_at ON products_bundle__declination_image (deleted_at)');
  11.         $this->addSql('CREATE INDEX created_at ON products_bundle__declination_image (created_at)');
  12.         $this->addSql('CREATE INDEX updated_at ON products_bundle__declination_image (updated_at)');
  13.         $this->addSql('CREATE INDEX deleted_at ON products_bundle__ean13 (deleted_at)');
  14.         $this->addSql('CREATE INDEX created_at ON products_bundle__ean13 (created_at)');
  15.         $this->addSql('CREATE INDEX updated_at ON products_bundle__ean13 (updated_at)');
  16.         $this->addSql('CREATE INDEX deleted_at ON products_bundle__pack_product (deleted_at)');
  17.         $this->addSql('CREATE INDEX created_at ON products_bundle__pack_product (created_at)');
  18.         $this->addSql('CREATE INDEX updated_at ON products_bundle__pack_product (updated_at)');
  19.         $this->addSql('CREATE INDEX deleted_at ON products_bundle__product_context (deleted_at)');
  20.         $this->addSql('CREATE INDEX created_at ON products_bundle__product_context (created_at)');
  21.         $this->addSql('CREATE INDEX updated_at ON products_bundle__product_context (updated_at)');
  22.         $this->addSql('CREATE INDEX deleted_at ON products_bundle__product_feature (deleted_at)');
  23.         $this->addSql('CREATE INDEX created_at ON products_bundle__product_feature (created_at)');
  24.         $this->addSql('CREATE INDEX updated_at ON products_bundle__product_feature (updated_at)');
  25.         $this->addSql('CREATE INDEX is_cover ON products_bundle__product_image (is_cover)');
  26.         $this->addSql('CREATE INDEX deleted_at ON products_bundle__product_image (deleted_at)');
  27.         $this->addSql('CREATE INDEX created_at ON products_bundle__product_image (created_at)');
  28.         $this->addSql('CREATE INDEX updated_at ON products_bundle__product_image (updated_at)');
  29.         $this->addSql('CREATE INDEX deleted_at ON products_bundle__related_product (deleted_at)');
  30.         $this->addSql('CREATE INDEX created_at ON products_bundle__related_product (created_at)');
  31.         $this->addSql('CREATE INDEX updated_at ON products_bundle__related_product (updated_at)');
  32.         $this->addSql('CREATE INDEX deleted_at ON products_bundle__substitute_product (deleted_at)');
  33.         $this->addSql('CREATE INDEX created_at ON products_bundle__substitute_product (created_at)');
  34.         $this->addSql('CREATE INDEX updated_at ON products_bundle__substitute_product (updated_at)');
  35.     }
  36.     public function down(Schema $schema): void
  37.     {
  38.         $this->addSql('DROP INDEX deleted_at ON products_bundle__declination_image');
  39.         $this->addSql('DROP INDEX created_at ON products_bundle__declination_image');
  40.         $this->addSql('DROP INDEX updated_at ON products_bundle__declination_image');
  41.         $this->addSql('DROP INDEX deleted_at ON products_bundle__ean13');
  42.         $this->addSql('DROP INDEX created_at ON products_bundle__ean13');
  43.         $this->addSql('DROP INDEX updated_at ON products_bundle__ean13');
  44.         $this->addSql('DROP INDEX deleted_at ON products_bundle__pack_product');
  45.         $this->addSql('DROP INDEX created_at ON products_bundle__pack_product');
  46.         $this->addSql('DROP INDEX updated_at ON products_bundle__pack_product');
  47.         $this->addSql('DROP INDEX deleted_at ON products_bundle__product_context');
  48.         $this->addSql('DROP INDEX created_at ON products_bundle__product_context');
  49.         $this->addSql('DROP INDEX updated_at ON products_bundle__product_context');
  50.         $this->addSql('DROP INDEX deleted_at ON products_bundle__product_feature');
  51.         $this->addSql('DROP INDEX created_at ON products_bundle__product_feature');
  52.         $this->addSql('DROP INDEX updated_at ON products_bundle__product_feature');
  53.         $this->addSql('DROP INDEX is_cover ON products_bundle__product_image');
  54.         $this->addSql('DROP INDEX deleted_at ON products_bundle__product_image');
  55.         $this->addSql('DROP INDEX created_at ON products_bundle__product_image');
  56.         $this->addSql('DROP INDEX updated_at ON products_bundle__product_image');
  57.         $this->addSql('DROP INDEX deleted_at ON products_bundle__related_product');
  58.         $this->addSql('DROP INDEX created_at ON products_bundle__related_product');
  59.         $this->addSql('DROP INDEX updated_at ON products_bundle__related_product');
  60.         $this->addSql('DROP INDEX deleted_at ON products_bundle__substitute_product');
  61.         $this->addSql('DROP INDEX created_at ON products_bundle__substitute_product');
  62.         $this->addSql('DROP INDEX updated_at ON products_bundle__substitute_product');
  63.     }
  64. }