migrations/Version20251027105020.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 Version20251027105020 extends AbstractMigration
  11. {
  12.     public function getDescription(): string
  13.     {
  14.         return 'Create table std_advertisements (aligned UNSIGNED types)';
  15.     }
  17.     public function up(Schema $schema): void
  18.     {
  19.         $this->addSql(<<<'SQL'
  20.             CREATE TABLE `std_advertisements` (
  21.               `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  22.               `campaign_id` INT UNSIGNED NULL,
  23.               `zone_id` INT UNSIGNED NULL,
  24.               `title` VARCHAR(255) NULL,
  25.               `description_tooltip` VARCHAR(255) NULL,
  26.               `media_path` VARCHAR(255) NULL,
  27.               `href` VARCHAR(512) NULL,
  28.               `open_in_new_tab` TINYINT(1) DEFAULT 1,
  29.               `nofollow` TINYINT(1) DEFAULT 1,
  30.               `weight` INT DEFAULT 1,
  31.               `clicks` INT DEFAULT 0,
  32.               `status` VARCHAR(20) DEFAULT 'open',
  33.               `is_active` TINYINT(1) DEFAULT 1,
  34.               `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  35.               `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  36.               PRIMARY KEY (`id`),
  37.               KEY `idx_advertisement_campaign` (`campaign_id`),
  38.               KEY `idx_advertisement_zone` (`zone_id`),
  39.               CONSTRAINT `fk_advertisement_campaign`
  40.                 FOREIGN KEY (`campaign_id`)
  41.                 REFERENCES `std_ads_campaigns` (`id`)
  42.                 ON DELETE CASCADE,
  43.               CONSTRAINT `fk_advertisement_zone`
  44.                 FOREIGN KEY (`zone_id`)
  45.                 REFERENCES `std_ads_zones` (`id`)
  46.                 ON DELETE SET NULL
  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_advertisements`');
  57.     }
  58. }