Symfony Profiler

<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use App\Utils\CommonFunctions;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
final class Version20220425135935 extends AbstractMigration
{
public function getDescription(): string
{
return 'Migration inicial';
}
public function up(Schema $schema): void
{
// this up() migration is auto-generated, please modify it to your needs
$this->addSql('CREATE TABLE area_gobierno (id INT AUTO_INCREMENT NOT NULL, nombre VARCHAR(255) NOT NULL, descripcion VARCHAR(255) DEFAULT NULL, link VARCHAR(255) NOT NULL, imagen VARCHAR(255) NOT NULL, activo TINYINT(1) NOT NULL, posicion INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, deleted_at DATETIME DEFAULT NULL, INDEX IDX_NOMBRE (nombre), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE categoria (id INT AUTO_INCREMENT NOT NULL, categoria_id INT DEFAULT NULL, nombre VARCHAR(255) NOT NULL, descripcion VARCHAR(255) DEFAULT NULL, icono LONGTEXT NOT NULL, activo TINYINT(1) NOT NULL, posicion INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, deleted_at DATETIME DEFAULT NULL, INDEX IDX_4E10122D3397707A (categoria_id), INDEX IDX_NOMBRE (nombre), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE grupo (id INT AUTO_INCREMENT NOT NULL, categoria_id INT DEFAULT NULL, nombre VARCHAR(255) NOT NULL, descripcion VARCHAR(255) DEFAULT NULL, activo TINYINT(1) NOT NULL, posicion INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, deleted_at DATETIME DEFAULT NULL, INDEX IDX_8C0E9BD33397707A (categoria_id), INDEX IDX_NOMBRE (nombre), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE imagen (id INT AUTO_INCREMENT NOT NULL, filename VARCHAR(255) NOT NULL, link VARCHAR(255) DEFAULT NULL, activo TINYINT(1) NOT NULL, posicion INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_FILENAME (filename), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE material_recurso (id INT AUTO_INCREMENT NOT NULL, categoria_id INT DEFAULT NULL, grupo_id INT DEFAULT NULL, nombre VARCHAR(255) NOT NULL, link LONGTEXT NOT NULL, activo TINYINT(1) NOT NULL, posicion INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_321ECCB3397707A (categoria_id), INDEX IDX_321ECCB9C833003 (grupo_id), INDEX IDX_NOMBRE (nombre), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE parameter (id INT AUTO_INCREMENT NOT NULL, type VARCHAR(255) DEFAULT NULL, name VARCHAR(255) NOT NULL, value LONGTEXT DEFAULT NULL, description LONGTEXT DEFAULT NULL, help VARCHAR(255) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_2A9791105E237E06 (name), INDEX IDX_NAME (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE perfil (id INT AUTO_INCREMENT NOT NULL, nombre VARCHAR(255) NOT NULL, descripcion LONGTEXT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, deleted_at DATETIME DEFAULT NULL, INDEX IDX_NOMBRE (nombre), UNIQUE INDEX UNIQ_966576473A9091264AF38FD1 (nombre, deleted_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE perfil_role (perfil_id INT NOT NULL, role_id INT NOT NULL, INDEX IDX_C7CCA53F57291544 (perfil_id), INDEX IDX_C7CCA53FD60322AC (role_id), PRIMARY KEY(perfil_id, role_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE red_social (id INT AUTO_INCREMENT NOT NULL, link VARCHAR(255) NOT NULL, icono VARCHAR(255) NOT NULL, activo TINYINT(1) NOT NULL, posicion INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_LINK (link), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE reset_password_request (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, selector VARCHAR(20) NOT NULL, hashed_token VARCHAR(100) NOT NULL, requested_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', expires_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_7CE748AA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE role (id INT AUTO_INCREMENT NOT NULL, nombre VARCHAR(255) NOT NULL, descripcion LONGTEXT NOT NULL, activo TINYINT(1) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_57698A6A3A909126 (nombre), INDEX IDX_NOMBRE (nombre), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE telefono (id INT AUTO_INCREMENT NOT NULL, titulo VARCHAR(255) NOT NULL, descripcion LONGTEXT NOT NULL, numero VARCHAR(255) NOT NULL, principal TINYINT(1) NOT NULL, activo TINYINT(1) NOT NULL, posicion INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_NUMERO (numero), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE tramite (id INT AUTO_INCREMENT NOT NULL, grupo_id INT DEFAULT NULL, nombre VARCHAR(255) NOT NULL, descripcion VARCHAR(255) DEFAULT NULL, link LONGTEXT DEFAULT NULL, activo TINYINT(1) NOT NULL, posicion INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, deleted_at DATETIME DEFAULT NULL, INDEX IDX_9F322F259C833003 (grupo_id), INDEX IDX_NOMBRE (nombre), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE usuario (id INT AUTO_INCREMENT NOT NULL, nombre VARCHAR(255) NOT NULL, apellido VARCHAR(255) NOT NULL, password VARCHAR(255) DEFAULT NULL, email VARCHAR(255) NOT NULL, cuit VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, deleted_at DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_2265B05DB9BA48814AF38FD1 (cuit, deleted_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE usuario_perfil (usuario_id INT NOT NULL, perfil_id INT NOT NULL, INDEX IDX_6C77954EDB38439E (usuario_id), INDEX IDX_6C77954E57291544 (perfil_id), PRIMARY KEY(usuario_id, perfil_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE usuario_miba (id INT AUTO_INCREMENT NOT NULL, miba_id VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, deleted_at DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_AB0A2296A19E04A04AF38FD1 (miba_id, deleted_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('ALTER TABLE categoria ADD CONSTRAINT FK_4E10122D3397707A FOREIGN KEY (categoria_id) REFERENCES categoria (id)');
$this->addSql('ALTER TABLE grupo ADD CONSTRAINT FK_8C0E9BD33397707A FOREIGN KEY (categoria_id) REFERENCES categoria (id)');
$this->addSql('ALTER TABLE material_recurso ADD CONSTRAINT FK_321ECCB3397707A FOREIGN KEY (categoria_id) REFERENCES categoria (id)');
$this->addSql('ALTER TABLE material_recurso ADD CONSTRAINT FK_321ECCB9C833003 FOREIGN KEY (grupo_id) REFERENCES grupo (id)');
$this->addSql('ALTER TABLE perfil_role ADD CONSTRAINT FK_C7CCA53F57291544 FOREIGN KEY (perfil_id) REFERENCES perfil (id)');
$this->addSql('ALTER TABLE perfil_role ADD CONSTRAINT FK_C7CCA53FD60322AC FOREIGN KEY (role_id) REFERENCES role (id)');
$this->addSql('ALTER TABLE reset_password_request ADD CONSTRAINT FK_7CE748AA76ED395 FOREIGN KEY (user_id) REFERENCES usuario (id)');
$this->addSql('ALTER TABLE tramite ADD CONSTRAINT FK_9F322F259C833003 FOREIGN KEY (grupo_id) REFERENCES grupo (id)');
$this->addSql('ALTER TABLE usuario_perfil ADD CONSTRAINT FK_6C77954EDB38439E FOREIGN KEY (usuario_id) REFERENCES usuario (id)');
$this->addSql('ALTER TABLE usuario_perfil ADD CONSTRAINT FK_6C77954E57291544 FOREIGN KEY (perfil_id) REFERENCES perfil (id)');
// Inserts Perfil, Role y Usuario
$this->addSql(CommonFunctions::getFile(__DIR__ . '/Data/insert_perfil_role.sql'));
// Inserts Areas de gobierno
$this->addSql(CommonFunctions::getFile(__DIR__ . '/Data/AreasGobierno/insert_areas_gobierno.sql'));
// Inserts Telefonos
$this->addSql(CommonFunctions::getFile(__DIR__ . '/Data/Telefonos/insert_telefonos.sql'));
// Inserts Redes sociales
$this->addSql(CommonFunctions::getFile(__DIR__ . '/Data/RedesSociales/insert_redes_sociales.sql'));
// Inserts Tramites y servicios
$this->addSql(CommonFunctions::getFile(__DIR__ . '/Data/TramitesServicios/inserts_ambiente.sql'));
$this->addSql(CommonFunctions::getFile(__DIR__ . '/Data/TramitesServicios/inserts_comunidad.sql'));
$this->addSql(CommonFunctions::getFile(__DIR__ . '/Data/TramitesServicios/inserts_denuncias.sql'));
$this->addSql(CommonFunctions::getFile(__DIR__ . '/Data/TramitesServicios/inserts_educacion.sql'));
$this->addSql(CommonFunctions::getFile(__DIR__ . '/Data/TramitesServicios/inserts_identidad.sql'));
$this->addSql(CommonFunctions::getFile(__DIR__ . '/Data/TramitesServicios/inserts_salud.sql'));
$this->addSql(CommonFunctions::getFile(__DIR__ . '/Data/TramitesServicios/inserts_trabajo.sql'));
$this->addSql(CommonFunctions::getFile(__DIR__ . '/Data/TramitesServicios/inserts_transito.sql'));
$this->addSql(CommonFunctions::getFile(__DIR__ . '/Data/TramitesServicios/inserts_materiales_recursos.sql'));
// Insert Terminos y condiciones
$this->addSql(CommonFunctions::getFile(__DIR__ . '/Data/TerminosCondiciones/insert_terminos_condiciones.sql'));
// Insert Parameters
$this->addSql(CommonFunctions::getFile(__DIR__ . '/Data/Parameters/insert_parameters.sql'));
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE categoria DROP FOREIGN KEY FK_4E10122D3397707A');
$this->addSql('ALTER TABLE grupo DROP FOREIGN KEY FK_8C0E9BD33397707A');
$this->addSql('ALTER TABLE material_recurso DROP FOREIGN KEY FK_321ECCB3397707A');
$this->addSql('ALTER TABLE material_recurso DROP FOREIGN KEY FK_321ECCB9C833003');
$this->addSql('ALTER TABLE tramite DROP FOREIGN KEY FK_9F322F259C833003');
$this->addSql('ALTER TABLE perfil_role DROP FOREIGN KEY FK_C7CCA53F57291544');
$this->addSql('ALTER TABLE usuario_perfil DROP FOREIGN KEY FK_6C77954E57291544');
$this->addSql('ALTER TABLE perfil_role DROP FOREIGN KEY FK_C7CCA53FD60322AC');
$this->addSql('ALTER TABLE reset_password_request DROP FOREIGN KEY FK_7CE748AA76ED395');
$this->addSql('ALTER TABLE usuario_perfil DROP FOREIGN KEY FK_6C77954EDB38439E');
$this->addSql('DROP TABLE area_gobierno');
$this->addSql('DROP TABLE categoria');
$this->addSql('DROP TABLE grupo');
$this->addSql('DROP TABLE imagen');
$this->addSql('DROP TABLE material_recurso');
$this->addSql('DROP TABLE parameter');
$this->addSql('DROP TABLE perfil');
$this->addSql('DROP TABLE perfil_role');
$this->addSql('DROP TABLE red_social');
$this->addSql('DROP TABLE reset_password_request');
$this->addSql('DROP TABLE role');
$this->addSql('DROP TABLE telefono');
$this->addSql('DROP TABLE tramite');
$this->addSql('DROP TABLE usuario');
$this->addSql('DROP TABLE usuario_perfil');
$this->addSql('DROP TABLE usuario_miba');
}
}

migrations/Version20220425135935.php line 1