migrations/Version20251027105034.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 Version20251027105034 extends AbstractMigration
  11. {
  12.     public function getDescription(): string
  13.     {
  14.         return 'Create table std_ads_tracking to log both impressions and clicks for advertisements (aligned types)';
  15.     }
  17.     public function up(Schema $schema): void
  18.     {
  19.         $this->addSql(<<<'SQL'
  20.             CREATE TABLE `std_ads_tracking` (
  21.               `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  22.               `campaign_id` INT UNSIGNED NOT NULL,
  23.               `advertisement_id` INT UNSIGNED NOT NULL,
  24.               `zone_id` INT UNSIGNED NOT NULL,
  25.               `page` VARCHAR(255) DEFAULT NULL,
  26.               `ip` VARCHAR(100) DEFAULT NULL,
  27.               `user_id` INT UNSIGNED DEFAULT NULL,
  28.               `event_type` ENUM('impression','click') NOT NULL,
  29.               `target_href` VARCHAR(512) DEFAULT NULL,
  30.               `datetime` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  31.               PRIMARY KEY (`id`),
  32.               KEY `idx_tracking_campaign` (`campaign_id`),
  33.               KEY `idx_tracking_advertisement` (`advertisement_id`),
  34.               KEY `idx_tracking_zone` (`zone_id`),
  35.               CONSTRAINT `fk_tracking_campaign`
  36.                 FOREIGN KEY (`campaign_id`)
  37.                 REFERENCES `std_ads_campaigns` (`id`)
  38.                 ON DELETE CASCADE,
  39.               CONSTRAINT `fk_tracking_advertisement`
  40.                 FOREIGN KEY (`advertisement_id`)
  41.                 REFERENCES `std_advertisements` (`id`)
  42.                 ON DELETE CASCADE,
  43.               CONSTRAINT `fk_tracking_zone`
  44.                 FOREIGN KEY (`zone_id`)
  45.                 REFERENCES `std_ads_zones` (`id`)
  46.                 ON DELETE CASCADE
  47.             )
  48.             ENGINE=InnoDB
  49.             DEFAULT CHARSET=utf8mb4
  50.             COLLATE=utf8mb4_unicode_ci;
  51.         SQL);
  52.     }
  54.     public function down(Schema $schema): void
  55.     {
  56.         $this->addSql('DROP TABLE IF EXISTS `std_ads_tracking`');
  57.     }
  58. }