migrations/Version20260401000001.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. final class Version20260401000001 extends AbstractMigration
  11. {
  12.     public function getDescription(): string
  13.     {
  14.         return 'Create notification_event_rules table';
  15.     }
  17.     public function up(Schema $schema): void
  18.     {
  19.         $this->addSql('CREATE TABLE notification_event_rules (
  20.             id INT AUTO_INCREMENT NOT NULL,
  21.             notification_system_id INT NOT NULL,
  22.             trigger_timing VARCHAR(50) NOT NULL,
  23.             trigger_values JSON DEFAULT NULL,
  24.             status_condition JSON DEFAULT NULL,
  25.             is_enabled TINYINT(1) NOT NULL DEFAULT 1,
  26.             created_at DATETIME NOT NULL,
  27.             updated_at DATETIME NOT NULL,
  28.             deleted_at DATETIME DEFAULT NULL,
  29.             PRIMARY KEY(id),
  30.             INDEX idx_ner_trigger_timing (trigger_timing),
  31.             INDEX idx_ner_is_enabled (is_enabled),
  32.             INDEX idx_ner_notification_system_id (notification_system_id),
  33.             CONSTRAINT fk_ner_notification_system
  34.                 FOREIGN KEY (notification_system_id)
  35.                 REFERENCES notification_system (id)
  36.                 ON DELETE CASCADE
  37.         ) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  38.     }
  40.     public function down(Schema $schema): void
  41.     {
  42.         $this->addSql('DROP TABLE notification_event_rules');
  43.     }
  44. }