migrations/Version20251006095500.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. /**
  11. * Add performance indexes to log table for improved query performance
  12. *
  13. * These indexes optimize:
  14. * - User filtering (idx_log_user)
  15. * - Date range queries (idx_log_created_at)
  16. * - HTTP method filtering (idx_log_method)
  17. * - IP address filtering (idx_log_remote_addr)
  18. * - URI searches (idx_log_uri)
  19. * - Combined user + date queries (idx_log_user_created)
  20. */
  21. final class Version20251006095500 extends AbstractMigration
  22. {
  23. public function getDescription(): string
  24. {
  25. return 'Add performance indexes to log table for faster filtering and searching';
  26. }
  28. public function up(Schema $schema): void
  29. {
  30. // Add indexes for log table to improve query performance
  31. $this->addSql('CREATE INDEX idx_log_user ON log (user)');
  32. $this->addSql('CREATE INDEX idx_log_created_at ON log (created_at)');
  33. $this->addSql('CREATE INDEX idx_log_method ON log (method)');
  34. $this->addSql('CREATE INDEX idx_log_remote_addr ON log (remote_addr)');
  35. $this->addSql('CREATE INDEX idx_log_uri ON log (uri(255))');
  36. $this->addSql('CREATE INDEX idx_log_user_created ON log (user, created_at)');
  37. }
  39. public function down(Schema $schema): void
  40. {
  41. // Remove log indexes
  42. $this->addSql('DROP INDEX idx_log_user ON log');
  43. $this->addSql('DROP INDEX idx_log_created_at ON log');
  44. $this->addSql('DROP INDEX idx_log_method ON log');
  45. $this->addSql('DROP INDEX idx_log_remote_addr ON log');
  46. $this->addSql('DROP INDEX idx_log_uri ON log');
  47. $this->addSql('DROP INDEX idx_log_user_created ON log');
  48. }
  49. }