Symfony Profiler

<?php
declare(strict_types=1);
namespace App\Migrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
use Doctrine\Migrations\Exception\AbortMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
final class Version20201122160429 extends AbstractMigration
{
public function getDescription() : string
{
return '';
}
public function up(Schema $schema) : void
{
$dbDriver = $this->connection->getDatabasePlatform()->getName();
if ($dbDriver === 'mysql') {
$this->addSql('CREATE TABLE common (id VARCHAR(36) NOT NULL, name VARCHAR(100) NOT NULL, type VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE history (id VARCHAR(36) NOT NULL, user VARCHAR(36) NOT NULL, entity VARCHAR(36) NOT NULL, date DATETIME NOT NULL, action VARCHAR(100) NOT NULL, INDEX IDX_27BA704B8D93D649 (user), INDEX IDX_27BA704BE284468 (entity), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user (id VARCHAR(36) NOT NULL, username VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, civility VARCHAR(30) DEFAULT NULL, firstname VARCHAR(100) DEFAULT NULL, lastname VARCHAR(100) DEFAULT NULL, password LONGTEXT DEFAULT NULL, salt LONGTEXT DEFAULT NULL, roles LONGTEXT NOT NULL COMMENT \'(DC2Type:array)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_personal_infos (id VARCHAR(36) NOT NULL, user VARCHAR(36) NOT NULL, phone_number VARCHAR(35) DEFAULT NULL, email VARCHAR(255) DEFAULT NULL, UNIQUE INDEX UNIQ_DD161B228D93D649 (user), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE validation_token (id VARCHAR(36) NOT NULL, user_id VARCHAR(36) DEFAULT NULL, token VARCHAR(100) NOT NULL, property VARCHAR(20) NOT NULL, value VARCHAR(255) DEFAULT NULL, send_mode VARCHAR(20) NOT NULL, creation DATETIME NOT NULL, expiration DATETIME NOT NULL, INDEX IDX_B724A428A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('ALTER TABLE history ADD CONSTRAINT FK_27BA704B8D93D649 FOREIGN KEY (user) REFERENCES user (id)');
$this->addSql('ALTER TABLE history ADD CONSTRAINT FK_27BA704BE284468 FOREIGN KEY (entity) REFERENCES common (id)');
$this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D649BF396750 FOREIGN KEY (id) REFERENCES common (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE user_personal_infos ADD CONSTRAINT FK_DD161B228D93D649 FOREIGN KEY (user) REFERENCES user (id)');
$this->addSql('ALTER TABLE user_personal_infos ADD CONSTRAINT FK_DD161B22BF396750 FOREIGN KEY (id) REFERENCES common (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE validation_token ADD CONSTRAINT FK_B724A428A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
} elseif ($dbDriver === 'sqlite') {
$this->addSql('CREATE TABLE common (id VARCHAR(36) NOT NULL, name VARCHAR(100) NOT NULL, type VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE history (id VARCHAR(36) NOT NULL, user VARCHAR(36) NOT NULL, entity VARCHAR(36) NOT NULL, date DATETIME NOT NULL, "action" VARCHAR(100) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_27BA704B8D93D649 ON history (user)');
$this->addSql('CREATE INDEX IDX_27BA704BE284468 ON history (entity)');
$this->addSql('CREATE TABLE user (id VARCHAR(36) NOT NULL, username VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, civility VARCHAR(30) DEFAULT NULL, firstname VARCHAR(100) DEFAULT NULL, lastname VARCHAR(100) DEFAULT NULL, password CLOB DEFAULT NULL, salt CLOB DEFAULT NULL, roles CLOB NOT NULL --(DC2Type:array)
, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE user_personal_infos (id VARCHAR(36) NOT NULL, user VARCHAR(36) NOT NULL, phone_number VARCHAR(35) DEFAULT NULL, email VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_DD161B228D93D649 ON user_personal_infos (user)');
$this->addSql('CREATE TABLE validation_token (id VARCHAR(36) NOT NULL, user_id VARCHAR(36) DEFAULT NULL, token VARCHAR(100) NOT NULL, property VARCHAR(20) NOT NULL, value VARCHAR(255) DEFAULT NULL, send_mode VARCHAR(20) NOT NULL, creation DATETIME NOT NULL, expiration DATETIME NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_B724A428A76ED395 ON validation_token (user_id)');
} else {
throw new AbortMigration('Migration can only be executed safely on \'mysql\'.');
}
}
public function down(Schema $schema) : void
{
$dbDriver = $this->connection->getDatabasePlatform()->getName();
if ($dbDriver === 'mysql') {
$this->addSql('ALTER TABLE history DROP FOREIGN KEY FK_27BA704BE284468');
$this->addSql('ALTER TABLE user DROP FOREIGN KEY FK_8D93D649BF396750');
$this->addSql('ALTER TABLE user_personal_infos DROP FOREIGN KEY FK_DD161B22BF396750');
$this->addSql('ALTER TABLE history DROP FOREIGN KEY FK_27BA704B8D93D649');
$this->addSql('ALTER TABLE user_personal_infos DROP FOREIGN KEY FK_DD161B228D93D649');
$this->addSql('ALTER TABLE validation_token DROP FOREIGN KEY FK_B724A428A76ED395');
$this->addSql('DROP TABLE common');
$this->addSql('DROP TABLE history');
$this->addSql('DROP TABLE user');
$this->addSql('DROP TABLE user_personal_infos');
$this->addSql('DROP TABLE validation_token');
} elseif ($dbDriver === 'sqlite') {
$this->addSql('DROP TABLE common');
$this->addSql('DROP TABLE history');
$this->addSql('DROP TABLE user');
$this->addSql('DROP TABLE user_personal_infos');
$this->addSql('DROP TABLE validation_token');
}
}
}

src/Migrations/Version20201122160429.php line 1