vendor/plna-penezenka/pp-sdk-bundle/migrations/Version20220406112246_WebPushEndpointIndex.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace PPSDKDoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  11. final class Version20220406112246_WebPushEndpointIndex extends AbstractMigration
  12. {
  13.     public function getDescription(): string
  14.     {
  15.         return 'Index endpoint_hash added to web_push_endpoint';
  16.     }
  18.     public function up(Schema $schema): void
  19.     {
  20.         $this->addSql('CREATE INDEX endpoint_hash ON web_push_endpoint (hash, user_id, web_id)');
  21.         $this->addSql('ALTER TABLE notifications ADD web_push_endpoints_to_deliver_count INT DEFAULT 0 NOT NULL, ADD web_push_sent_to_endpoint_ids LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:simple_array)\'');
  22.     }
  24.     public function down(Schema $schema): void
  25.     {
  26.         $this->addSql('DROP INDEX endpoint_hash ON web_push_endpoint');
  27.         $this->addSql('ALTER TABLE notifications DROP web_push_endpoints_to_deliver_count, DROP web_push_sent_to_endpoint_ids');
  28.     }
  29. }