vendor/bluue/inventories-bundle/migrations/Version20231206123655.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace InventoriesBundleMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. final class Version20231206123655 extends AbstractMigration
  11. {
  12.     public function up(Schema $schema): void
  13.     {
  14.         $this->addSql('CREATE INDEX reference ON inventories_bundle__inventory (reference)');
  15.         $this->addSql('CREATE INDEX name ON inventories_bundle__inventory (name)');
  16.         $this->addSql('CREATE INDEX deleted_at ON inventories_bundle__inventory (deleted_at)');
  17.         $this->addSql('CREATE INDEX created_at ON inventories_bundle__inventory (created_at)');
  18.         $this->addSql('CREATE INDEX updated_at ON inventories_bundle__inventory (updated_at)');
  19.         $this->addSql('CREATE INDEX deleted_at ON inventories_bundle__inventory_original_product (deleted_at)');
  20.         $this->addSql('CREATE INDEX created_at ON inventories_bundle__inventory_original_product (created_at)');
  21.         $this->addSql('CREATE INDEX updated_at ON inventories_bundle__inventory_original_product (updated_at)');
  22.         $this->addSql('CREATE INDEX deleted_at ON inventories_bundle__inventory_original_product_quantity (deleted_at)');
  23.         $this->addSql('CREATE INDEX created_at ON inventories_bundle__inventory_original_product_quantity (created_at)');
  24.         $this->addSql('CREATE INDEX updated_at ON inventories_bundle__inventory_original_product_quantity (updated_at)');
  25.         $this->addSql('CREATE INDEX deleted_at ON inventories_bundle__inventory_product (deleted_at)');
  26.         $this->addSql('CREATE INDEX created_at ON inventories_bundle__inventory_product (created_at)');
  27.         $this->addSql('CREATE INDEX updated_at ON inventories_bundle__inventory_product (updated_at)');
  28.         $this->addSql('CREATE INDEX deleted_at ON inventories_bundle__inventory_product_quantity (deleted_at)');
  29.         $this->addSql('CREATE INDEX created_at ON inventories_bundle__inventory_product_quantity (created_at)');
  30.         $this->addSql('CREATE INDEX updated_at ON inventories_bundle__inventory_product_quantity (updated_at)');
  31.     }
  33.     public function down(Schema $schema): void
  34.     {
  35.         $this->addSql('DROP INDEX reference ON inventories_bundle__inventory');
  36.         $this->addSql('DROP INDEX name ON inventories_bundle__inventory');
  37.         $this->addSql('DROP INDEX deleted_at ON inventories_bundle__inventory');
  38.         $this->addSql('DROP INDEX created_at ON inventories_bundle__inventory');
  39.         $this->addSql('DROP INDEX updated_at ON inventories_bundle__inventory');
  40.         $this->addSql('DROP INDEX deleted_at ON inventories_bundle__inventory_original_product');
  41.         $this->addSql('DROP INDEX created_at ON inventories_bundle__inventory_original_product');
  42.         $this->addSql('DROP INDEX updated_at ON inventories_bundle__inventory_original_product');
  43.         $this->addSql('DROP INDEX deleted_at ON inventories_bundle__inventory_original_product_quantity');
  44.         $this->addSql('DROP INDEX created_at ON inventories_bundle__inventory_original_product_quantity');
  45.         $this->addSql('DROP INDEX updated_at ON inventories_bundle__inventory_original_product_quantity');
  46.         $this->addSql('DROP INDEX deleted_at ON inventories_bundle__inventory_product');
  47.         $this->addSql('DROP INDEX created_at ON inventories_bundle__inventory_product');
  48.         $this->addSql('DROP INDEX updated_at ON inventories_bundle__inventory_product');
  49.         $this->addSql('DROP INDEX deleted_at ON inventories_bundle__inventory_product_quantity');
  50.         $this->addSql('DROP INDEX created_at ON inventories_bundle__inventory_product_quantity');
  51.         $this->addSql('DROP INDEX updated_at ON inventories_bundle__inventory_product_quantity');
  52.     }
  53. }