<?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 Version20230326092503 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
        $this->addSql('CREATE TABLE cible2063 (id INT AUTO_INCREMENT NOT NULL, domaine_id INT DEFAULT NULL, name LONGTEXT NOT NULL, code VARCHAR(255) NOT NULL, INDEX IDX_360B5D564272FC9F (domaine_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE `utf8_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE indicateur2063 (id INT AUTO_INCREMENT NOT NULL, cible_id INT DEFAULT NULL, indicateur2030_id INT DEFAULT NULL, code VARCHAR(255) NOT NULL, name LONGTEXT NOT NULL, INDEX IDX_17CCFC32A96E5E09 (cible_id), INDEX IDX_17CCFC32B120F46D (indicateur2030_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE `utf8_unicode_ci` ENGINE = InnoDB');
        $this->addSql('ALTER TABLE cible2063 ADD CONSTRAINT FK_360B5D564272FC9F FOREIGN KEY (domaine_id) REFERENCES indicator (id)');
        $this->addSql('ALTER TABLE indicateur2063 ADD CONSTRAINT FK_17CCFC32A96E5E09 FOREIGN KEY (cible_id) REFERENCES cible2063 (id)');
        $this->addSql('ALTER TABLE indicateur2063 ADD CONSTRAINT FK_17CCFC32B120F46D FOREIGN KEY (indicateur2030_id) REFERENCES indicator (id)');
        INSERT INTO `user` (`direction_id`, `username`, `roles`, `password`, `email`, `enabled`, `given_name`, `family_name`, `telephone`, `office`, `avatar`, `commune_id`, `department_id`) VALUES
        (NULL, '', '[\"ROLE_CSPAT\"]', 'mjaz23SQBQEmrm5O1pn/nQ==', 'idakpatchou@gmail.com', 1, 'Ida Phoberie', 'KPATCHOU', '96 00 64 35', 'C/SPAT', NULL, NULL, 3),
        (NULL, '', '[\"ROLE_CSPAT\"]', 'mjaz23SQBQEmrm5O1pn/nQ==', 'Odostar1@yahoo.fr', 1, 'Rodrigue Tranquillin', 'ODO', '96 79 93 76', 'C/SPAT', NULL, NULL, 1),
        (NULL, '', '[\"ROLE_CSPAT\"]', 'mjaz23SQBQEmrm5O1pn/nQ==', 'tassouisdine@gmail.com', 1, 'Isdine', 'TASSOU', '97 33 34 03', 'C/SPAT', NULL, NULL, 2),
        (NULL, '', '[\"ROLE_CSPAT\"]', 'mjaz23SQBQEmrm5O1pn/nQ==', 'dineaden@gmail.com', 1, 'Zaya-Dine', 'ADENIYI', '97 92 25 16', 'C/SPAT', NULL, NULL, 4),
        (NULL, '', '[\"ROLE_CSPAT\"]', 'mjaz23SQBQEmrm5O1pn/nQ==', 'florentinakpovi2@gmail.com', 1, 'Gbêhin Florentin', 'AKPOVI GBEDJI', '62 79 22 56', 'C/SPAT', NULL, NULL, 5),
        (NULL, '', '[\"ROLE_CSPAT\"]', 'mjaz23SQBQEmrm5O1pn/nQ==', 'adopat23@gmail.com', 1, 'Vital Patient', 'ADOMOU', '61 96 62 61/ 60 10 29 72', 'C/SPAT', NULL, NULL, 6),
        (NULL, '', '[\"ROLE_CSPAT\"]', 'mjaz23SQBQEmrm5O1pn/nQ==', 'valereakako.2013@yahoo.fr', 1, 'Valère', 'AKAKO MARTIN', '97 24 03 88', 'C/SPAT', NULL, NULL, 7),
        (NULL, '', '[\"ROLE_CSPAT\"]', 'mjaz23SQBQEmrm5O1pn/nQ==', 'huguesdjidonou@gmail.com', 1, 'Hugues', 'DJIDONOU', '96 78 53 71', 'C/SPAT', NULL, NULL, 8),
        (NULL, '', '[\"ROLE_CSPAT\"]', 'mjaz23SQBQEmrm5O1pn/nQ==', 'randolphermann@gmail.com', 1, 'Hermann Emmanuel', 'RANDOLPH', '97 28 16 24', 'C/SPAT', NULL, NULL, 9),
        (NULL, '', '[\"ROLE_CSPAT\"]', 'mjaz23SQBQEmrm5O1pn/nQ==', 'saidola09@gmail.com', 1, 'Saïd Olatudji', 'LIASSOU', '96 14 92 18', 'C/SPAT', NULL, NULL, 10),
        (NULL, '', '[\"ROLE_CSPAT\"]', 'mjaz23SQBQEmrm5O1pn/nQ==', 'amohamedsadikou@yahoo.com', 1, 'Mohamed Sadikou', 'ABOUBAKARI', '97 02 57 04', 'C/SPAT', NULL, NULL, 11),
        (NULL, '', '[\"ROLE_CSPAT\"]', 'mjaz23SQBQEmrm5O1pn/nQ==', 'mathcaho@yahoo.fr', 1, 'Nonvignon Charles Mathurin', 'AHOKPOSSI', '96 71 94 99', 'C/SPAT', NULL, NULL, 12);

        INSERT INTO `menu` (`id`, `parent_id`, `name`, `route`, `icon`, `position`, `appid`) VALUES
        (131, NULL, 'Graphiques', 'app_gestion', 'fa-chart-pie', 1, 'ddd'),
        (132,131, 'Graphe indicateur', 'app_departement_graphe', NULL, 1, 'ddd');
    }

    public function down(Schema $schema): void
    {
        
    }
}