app/DoctrineMigrations/Version20241231143524.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.  * Auto-generated Migration: Please modify to your needs!
  12.  */
  13. final class Version20241231143524 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         // this up() migration is auto-generated, please modify it to your needs
  24.         // dtb_category_artist
  25.         $this->addSql("CREATE TABLE `dtb_category_artist` (
  26.             `id` int unsigned NOT NULL AUTO_INCREMENT,
  27.             `parent_category_id` int unsigned DEFAULT NULL,
  28.             `creator_id` int unsigned DEFAULT NULL,
  29.             `category_name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  31.             `category_kana` varchar(255) COLLATE utf8mb4_bin NULL,
  32.             `category_likename` varchar(255) COLLATE utf8mb4_bin NULL,
  33.             `category_content` varchar(1000) COLLATE utf8mb4_bin NULL,
  34.             `template_id` int NULL DEFAULT '1',
  35.             `category_label` smallint unsigned DEFAULT NULL,
  37.             `hierarchy` int unsigned NOT NULL,
  38.             `sort_no` int NOT NULL,
  39.             `period_date` date DEFAULT NULL,
  40.             `create_date` datetime NOT NULL COMMENT '(DC2Type:datetimetz)',
  41.             `update_date` datetime NOT NULL COMMENT '(DC2Type:datetimetz)',
  42.             `discriminator_type` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  43.             PRIMARY KEY (`id`),
  44.             KEY `IDX_5ED2C2B796A8F93` (`parent_category_id`),
  45.             KEY `IDX_5ED2C2B61220EA7` (`creator_id`),
  46.             CONSTRAINT `FK_5ED2C2B61220EA7` FOREIGN KEY (`creator_id`) REFERENCES `dtb_member` (`id`),
  47.             CONSTRAINT `FK_5ED2C2B796A8F93` FOREIGN KEY (`parent_category_id`) REFERENCES `dtb_category_artist` (`id`)
  48.             ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;");
  50.         // dtb_category_tv
  51.         $this->addSql("CREATE TABLE `dtb_category_tv` (
  52.             `id` int unsigned NOT NULL AUTO_INCREMENT,
  53.             `parent_category_id` int unsigned DEFAULT NULL,
  54.             `creator_id` int unsigned DEFAULT NULL,
  55.             `category_name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  56.             
  57.             `no` varchar(4) NULL,
  58.             `contents` text NULL,
  59.             `reserve_flg` tinyint DEFAULT '0',
  60.             `hierarchy` int unsigned NOT NULL,
  61.             `sort_no` int NOT NULL,
  63.             `period_date` date DEFAULT NULL,
  64.             `create_date` datetime NOT NULL COMMENT '(DC2Type:datetimetz)',
  65.             `update_date` datetime NOT NULL COMMENT '(DC2Type:datetimetz)',
  66.             `discriminator_type` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  67.             PRIMARY KEY (`id`),
  68.             KEY `IDX_5ED2C2B796A8F94` (`parent_category_id`),
  69.             KEY `IDX_5ED2C2B61220EA8` (`creator_id`),
  70.             CONSTRAINT `FK_5ED2C2B61220EA8` FOREIGN KEY (`creator_id`) REFERENCES `dtb_member` (`id`),
  71.             CONSTRAINT `FK_5ED2C2B796A8F94` FOREIGN KEY (`parent_category_id`) REFERENCES `dtb_category_tv` (`id`)
  72.         ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;");
  74.         // dtb_product_category_artist
  75.         $this->addSql("CREATE TABLE `dtb_product_category_artist` (
  76.             `product_id` int unsigned NOT NULL,
  77.             `category_id` int unsigned NOT NULL,
  78.             `discriminator_type` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  79.             PRIMARY KEY (`product_id`,`category_id`),
  80.             KEY `IDX_B05778914584666B` (`product_id`),
  81.             KEY `IDX_B057789112469DF3` (`category_id`),
  82.             CONSTRAINT `FK_B057789112469DF3` FOREIGN KEY (`category_id`) REFERENCES `dtb_category_artist` (`id`),
  83.             CONSTRAINT `FK_B05778914584666B` FOREIGN KEY (`product_id`) REFERENCES `dtb_product` (`id`)
  84.             ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;");
  85.         
  86.         // dtb_product_category_artist
  87.         $this->addSql("CREATE TABLE `dtb_product_category_artist_rel` (
  88.             `product_id` int unsigned NOT NULL,
  89.             `category_id` int unsigned NOT NULL,
  90.             `discriminator_type` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  91.             PRIMARY KEY (`product_id`,`category_id`),
  92.             KEY `IDX_B05778914584666C` (`product_id`),
  93.             KEY `IDX_B057789112469DF6` (`category_id`),
  94.             CONSTRAINT `FK_B057789112469DF6` FOREIGN KEY (`category_id`) REFERENCES `dtb_category_artist` (`id`),
  95.             CONSTRAINT `FK_B05778914584666C` FOREIGN KEY (`product_id`) REFERENCES `dtb_product` (`id`)
  96.             ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;");
  98.         // dtb_product_category_tv
  99.         $this->addSql("CREATE TABLE `dtb_product_category_tv` (
  100.             `product_id` int unsigned NOT NULL,
  101.             `category_id` int unsigned NOT NULL,
  102.             `discriminator_type` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  103.             PRIMARY KEY (`product_id`,`category_id`),
  104.             KEY `IDX_B05778914584666C` (`product_id`),
  105.             KEY `IDX_B057789112469DF4` (`category_id`),
  106.             CONSTRAINT `FK_B057789112469DF4` FOREIGN KEY (`category_id`) REFERENCES `dtb_category_tv` (`id`),
  107.             CONSTRAINT `FK_B05778914584666C` FOREIGN KEY (`product_id`) REFERENCES `dtb_product` (`id`)
  108.           ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;");
  109.     }
  111.     public function down(Schema $schema): void
  112.     {
  113.         // this down() migration is auto-generated, please modify it to your needs
  115.         $this->addSql("DROP TABLE dtb_category_artist;");
  116.         $this->addSql("DROP TABLE dtb_category_tv;");
  117.         $this->addSql("DROP TABLE dtb_product_category_artist;");
  118.         $this->addSql("DROP TABLE dtb_product_category_tv;");
  119.     }
  120. }