Symfony Profiler

<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
final class Version20250112102106 extends AbstractMigration
{
public function getDescription(): string
{
return '';
}
public function up(Schema $schema): void
{
// this up() migration is auto-generated, please modify it to your needs
// TV
$this->addSql("INSERT INTO `mtb_csv_type` (`id`, `name`, `sort_no`, `discriminator_type`) VALUES ('6', 'TVカテゴリCSV', '6', 'csvtype');");
$this->addSql("INSERT INTO `dtb_csv` (`csv_type_id`, `entity_name`, `field_name`, `disp_name`, `sort_no`, `enabled`, `create_date`, `update_date`, `discriminator_type`) VALUES ('6', 'Customize\\\\Entity\\\\CategoryTv', 'id', 'カテゴリID', '1', '1', '2025-01-10 10:14:00', '2025-01-10 10:14:00', 'csv');
INSERT INTO `dtb_csv` (`csv_type_id`, `entity_name`, `field_name`, `disp_name`, `sort_no`, `enabled`, `create_date`, `update_date`, `discriminator_type`) VALUES ('6', 'Customize\\\\Entity\\\\CategoryTv', 'sort_no', '表示ランク', '2', '1', '2025-01-10 10:14:00', '2025-01-10 10:14:00', 'csv');
INSERT INTO `dtb_csv` (`csv_type_id`, `entity_name`, `field_name`, `disp_name`, `sort_no`, `enabled`, `create_date`, `update_date`, `discriminator_type`) VALUES ('6', 'Customize\\\\Entity\\\\CategoryTv', 'name', 'カテゴリ名', '3', '1', '2025-01-10 10:14:00', '2025-01-10 10:14:00', 'csv');
INSERT INTO `dtb_csv` (`csv_type_id`, `entity_name`, `field_name`, `reference_field_name`, `disp_name`, `sort_no`, `enabled`, `create_date`, `update_date`, `discriminator_type`) VALUES ('6', 'Customize\\\\Entity\\\\CategoryTv', 'Parent', 'id', '親カテゴリID', '4', '1', '2025-01-10 10:14:00', '2025-01-10 10:14:00', 'csv');
INSERT INTO `dtb_csv` (`csv_type_id`, `entity_name`, `field_name`, `disp_name`, `sort_no`, `enabled`, `create_date`, `update_date`, `discriminator_type`) VALUES ('6', 'Customize\\\\Entity\\\\CategoryTv', 'level', '階層', '5', '1', '2025-01-10 10:14:00', '2025-01-10 10:14:00', 'csv');
");
// Artist
$this->addSql("INSERT INTO `mtb_csv_type` (`id`, `name`, `sort_no`, `discriminator_type`) VALUES ('7', 'アーティストCSV', '7', 'csvtype');");
$this->addSql("INSERT INTO `dtb_csv` (`csv_type_id`, `entity_name`, `field_name`, `disp_name`, `sort_no`, `enabled`, `create_date`, `update_date`, `discriminator_type`) VALUES ('7', 'Customize\\\\Entity\\\\CategoryArtist', 'id', 'カテゴリID', '1', '1', '2025-01-10 10:14:00', '2025-01-10 10:14:00', 'csv');
INSERT INTO `dtb_csv` (`csv_type_id`, `entity_name`, `field_name`, `disp_name`, `sort_no`, `enabled`, `create_date`, `update_date`, `discriminator_type`) VALUES ('7', 'Customize\\\\Entity\\\\CategoryArtist', 'sort_no', '表示ランク', '2', '1', '2025-01-10 10:14:00', '2025-01-10 10:14:00', 'csv');
INSERT INTO `dtb_csv` (`csv_type_id`, `entity_name`, `field_name`, `disp_name`, `sort_no`, `enabled`, `create_date`, `update_date`, `discriminator_type`) VALUES ('7', 'Customize\\\\Entity\\\\CategoryArtist', 'name', 'カテゴリ名', '3', '1', '2025-01-10 10:14:00', '2025-01-10 10:14:00', 'csv');
INSERT INTO `dtb_csv` (`csv_type_id`, `entity_name`, `field_name`, `reference_field_name`, `disp_name`, `sort_no`, `enabled`, `create_date`, `update_date`, `discriminator_type`) VALUES ('7', 'Customize\\\\Entity\\\\CategoryArtist', 'Parent', 'id', '親カテゴリID', '4', '1', '2025-01-10 10:14:00', '2025-01-10 10:14:00', 'csv');
INSERT INTO `dtb_csv` (`csv_type_id`, `entity_name`, `field_name`, `disp_name`, `sort_no`, `enabled`, `create_date`, `update_date`, `discriminator_type`) VALUES ('7', 'Customize\\\\Entity\\\\CategoryArtist', 'level', '階層', '5', '1', '2025-01-10 10:14:00', '2025-01-10 10:14:00', 'csv');
");
// mtb_artist_template
$this->addSql("CREATE TABLE `mtb_artist_template` (
`id` smallint unsigned NOT NULL,
`name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`sort_no` smallint unsigned NOT NULL,
`discriminator_type` varchar(255) COLLATE utf8mb4_bin NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin");
$this->addSql("INSERT INTO `mtb_artist_template` (`id`,`name`,`sort_no`,`discriminator_type`) VALUES (1,'標準',1,'artisttemplate');
INSERT INTO `mtb_artist_template` (`id`,`name`,`sort_no`,`discriminator_type`) VALUES (2,'ニューカマー用',2,'artisttemplate');");
// mtb_category_label
$this->addSql("CREATE TABLE `mtb_category_label` (
`id` smallint unsigned NOT NULL,
`name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`sort_no` smallint unsigned NOT NULL,
`discriminator_type` varchar(255) COLLATE utf8mb4_bin NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin");
$this->addSql("INSERT INTO `mtb_category_label` (`id`,`name`,`sort_no`,`discriminator_type`) VALUES (1,'ワードレコーズ',1,'categorylabel');
INSERT INTO `mtb_category_label` (`id`,`name`,`sort_no`,`discriminator_type`) VALUES (2,'ケイオスレインズ',2,'categorylabel');
INSERT INTO `mtb_category_label` (`id`,`name`,`sort_no`,`discriminator_type`) VALUES (3,'その他',3,'categorylabel');
INSERT INTO `mtb_category_label` (`id`,`name`,`sort_no`,`discriminator_type`) VALUES (4, 'La\'cryma Christi',4,'categorylabel');");
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
// TV
$this->addSql("DELETE FROM `dtb_csv` WHERE (`csv_type_id` = '6');");
$this->addSql("DELETE FROM `mtb_csv_type` WHERE (`id` = '6');");
// Artist
$this->addSql("DELETE FROM `dtb_csv` WHERE (`csv_type_id` = '7');");
$this->addSql("DELETE FROM `mtb_csv_type` WHERE (`id` = '7');");
// drop table mtb
$this->addSql("DROP TABLE mtb_artist_template;");
$this->addSql("DROP TABLE mtb_category_label;");
}
}

app/DoctrineMigrations/Version20250112102106.php line 1