<?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 Version20220114130551 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 activity (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, link VARCHAR(255) DEFAULT NULL, status TINYINT(1) NOT NULL, name VARCHAR(255) NOT NULL, description LONGTEXT DEFAULT NULL, full_description LONGTEXT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_AC74095AA76ED395 (user_id), INDEX IDX_AC74095ADE12AB56 (created_by), INDEX IDX_AC74095A16FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE audit_activity_log (id INT UNSIGNED AUTO_INCREMENT NOT NULL, type VARCHAR(10) NOT NULL, object_id VARCHAR(255) NOT NULL, discriminator VARCHAR(255) DEFAULT NULL, transaction_hash VARCHAR(40) DEFAULT NULL, diffs LONGTEXT DEFAULT NULL, blame_id VARCHAR(255) DEFAULT NULL, blame_user VARCHAR(255) DEFAULT NULL, blame_user_fqdn VARCHAR(255) DEFAULT NULL, blame_user_firewall VARCHAR(100) DEFAULT NULL, ip VARCHAR(45) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX type_437857e8803c66411cc72aac277aa24e_idx (type), INDEX object_id_437857e8803c66411cc72aac277aa24e_idx (object_id), INDEX discriminator_437857e8803c66411cc72aac277aa24e_idx (discriminator), INDEX transaction_hash_437857e8803c66411cc72aac277aa24e_idx (transaction_hash), INDEX blame_id_437857e8803c66411cc72aac277aa24e_idx (blame_id), INDEX created_at_437857e8803c66411cc72aac277aa24e_idx (created_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE answer (id INT AUTO_INCREMENT NOT NULL, voting_id INT DEFAULT NULL, text LONGTEXT NOT NULL, is_active TINYINT(1) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_DADD4A254254ACF8 (voting_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE banned (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, event_id INT DEFAULT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, reason VARCHAR(255) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_9B490DB6A76ED395 (user_id), INDEX IDX_9B490DB671F7E88B (event_id), INDEX IDX_9B490DB6DE12AB56 (created_by), INDEX IDX_9B490DB616FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE competence (id INT AUTO_INCREMENT NOT NULL, project_id INT NOT NULL, federal_id INT DEFAULT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, global INT DEFAULT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_94D4687F166D1F9C (project_id), INDEX IDX_94D4687FAEE0B307 (federal_id), INDEX IDX_94D4687FDE12AB56 (created_by), INDEX IDX_94D4687F16FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE custom_user_answer (id INT AUTO_INCREMENT NOT NULL, voting_id INT DEFAULT NULL, user_id INT DEFAULT NULL, answer_text LONGTEXT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_89B3E4D24254ACF8 (voting_id), INDEX IDX_89B3E4D2A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE deactivate_users (id INT AUTO_INCREMENT NOT NULL, firstname VARCHAR(255) DEFAULT NULL, lastname VARCHAR(255) DEFAULT NULL, middlename VARCHAR(255) DEFAULT NULL, avatar VARCHAR(255) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE device (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, device_name VARCHAR(255) NOT NULL, os VARCHAR(255) NOT NULL, activate TINYINT(1) NOT NULL, ip VARCHAR(255) NOT NULL, cookie_info VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_92FB68EA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE discussion_post (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, deactivate_user_id INT DEFAULT NULL, event_id INT DEFAULT NULL, parent_id INT DEFAULT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, description LONGTEXT DEFAULT NULL, full_description LONGTEXT DEFAULT NULL, INDEX IDX_7FE4C0BBA76ED395 (user_id), INDEX IDX_7FE4C0BBB783D599 (deactivate_user_id), INDEX IDX_7FE4C0BB71F7E88B (event_id), INDEX IDX_7FE4C0BB727ACA70 (parent_id), INDEX IDX_7FE4C0BBDE12AB56 (created_by), INDEX IDX_7FE4C0BB16FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE audit_discussion_post_log (id INT UNSIGNED AUTO_INCREMENT NOT NULL, type VARCHAR(10) NOT NULL, object_id VARCHAR(255) NOT NULL, discriminator VARCHAR(255) DEFAULT NULL, transaction_hash VARCHAR(40) DEFAULT NULL, diffs LONGTEXT DEFAULT NULL, blame_id VARCHAR(255) DEFAULT NULL, blame_user VARCHAR(255) DEFAULT NULL, blame_user_fqdn VARCHAR(255) DEFAULT NULL, blame_user_firewall VARCHAR(100) DEFAULT NULL, ip VARCHAR(45) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX type_7d20e30e125395d761af460061912d65_idx (type), INDEX object_id_7d20e30e125395d761af460061912d65_idx (object_id), INDEX discriminator_7d20e30e125395d761af460061912d65_idx (discriminator), INDEX transaction_hash_7d20e30e125395d761af460061912d65_idx (transaction_hash), INDEX blame_id_7d20e30e125395d761af460061912d65_idx (blame_id), INDEX created_at_7d20e30e125395d761af460061912d65_idx (created_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE event (id INT AUTO_INCREMENT NOT NULL, project_id INT DEFAULT NULL, parent_id INT DEFAULT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, entity VARCHAR(255) NOT NULL, postedAt DATETIME DEFAULT NULL, status INT NOT NULL, description LONGTEXT DEFAULT NULL, result_vote LONGTEXT DEFAULT NULL, date_from DATETIME DEFAULT NULL, date_to DATETIME DEFAULT NULL, draft TINYINT(1) NOT NULL, send_mail_notify TINYINT(1) NOT NULL, send_local_notify TINYINT(1) NOT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, archive TINYINT(1) NOT NULL, slug VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_3BAE0AA7989D9B62 (slug), INDEX IDX_3BAE0AA7166D1F9C (project_id), INDEX IDX_3BAE0AA7727ACA70 (parent_id), INDEX IDX_3BAE0AA7DE12AB56 (created_by), INDEX IDX_3BAE0AA716FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE audit_event_log (id INT UNSIGNED AUTO_INCREMENT NOT NULL, type VARCHAR(10) NOT NULL, object_id VARCHAR(255) NOT NULL, discriminator VARCHAR(255) DEFAULT NULL, transaction_hash VARCHAR(40) DEFAULT NULL, diffs LONGTEXT DEFAULT NULL, blame_id VARCHAR(255) DEFAULT NULL, blame_user VARCHAR(255) DEFAULT NULL, blame_user_fqdn VARCHAR(255) DEFAULT NULL, blame_user_firewall VARCHAR(100) DEFAULT NULL, ip VARCHAR(45) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX type_9ed41b615d79102aa10f43b2de6fed6c_idx (type), INDEX object_id_9ed41b615d79102aa10f43b2de6fed6c_idx (object_id), INDEX discriminator_9ed41b615d79102aa10f43b2de6fed6c_idx (discriminator), INDEX transaction_hash_9ed41b615d79102aa10f43b2de6fed6c_idx (transaction_hash), INDEX blame_id_9ed41b615d79102aa10f43b2de6fed6c_idx (blame_id), INDEX created_at_9ed41b615d79102aa10f43b2de6fed6c_idx (created_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE federal (id INT AUTO_INCREMENT NOT NULL, project_id INT NOT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, name VARCHAR(255) NOT NULL, description LONGTEXT DEFAULT NULL, full_description LONGTEXT DEFAULT NULL, slug VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_22EE255F989D9B62 (slug), INDEX IDX_22EE255F166D1F9C (project_id), INDEX IDX_22EE255FDE12AB56 (created_by), INDEX IDX_22EE255F16FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE audit_federal_log (id INT UNSIGNED AUTO_INCREMENT NOT NULL, type VARCHAR(10) NOT NULL, object_id VARCHAR(255) NOT NULL, discriminator VARCHAR(255) DEFAULT NULL, transaction_hash VARCHAR(40) DEFAULT NULL, diffs LONGTEXT DEFAULT NULL, blame_id VARCHAR(255) DEFAULT NULL, blame_user VARCHAR(255) DEFAULT NULL, blame_user_fqdn VARCHAR(255) DEFAULT NULL, blame_user_firewall VARCHAR(100) DEFAULT NULL, ip VARCHAR(45) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX type_d69bca3f4dbf81fc04f7c3bfe3f5a644_idx (type), INDEX object_id_d69bca3f4dbf81fc04f7c3bfe3f5a644_idx (object_id), INDEX discriminator_d69bca3f4dbf81fc04f7c3bfe3f5a644_idx (discriminator), INDEX transaction_hash_d69bca3f4dbf81fc04f7c3bfe3f5a644_idx (transaction_hash), INDEX blame_id_d69bca3f4dbf81fc04f7c3bfe3f5a644_idx (blame_id), INDEX created_at_d69bca3f4dbf81fc04f7c3bfe3f5a644_idx (created_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE federal_items (id INT AUTO_INCREMENT NOT NULL, event_id INT DEFAULT NULL, federal_id INT DEFAULT NULL, competence_id INT DEFAULT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, archive TINYINT(1) NOT NULL, INDEX IDX_92B6BB0271F7E88B (event_id), INDEX IDX_92B6BB02AEE0B307 (federal_id), INDEX IDX_92B6BB0215761DAB (competence_id), INDEX IDX_92B6BB02DE12AB56 (created_by), INDEX IDX_92B6BB0216FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE files (id INT AUTO_INCREMENT NOT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, path VARCHAR(255) NOT NULL, file_name VARCHAR(255) NOT NULL, entity VARCHAR(255) NOT NULL, entity_id VARCHAR(255) NOT NULL, type INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_6354059DE12AB56 (created_by), INDEX IDX_635405916FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE invitation (id INT AUTO_INCREMENT NOT NULL, user INT DEFAULT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, status INT NOT NULL, project_id INT DEFAULT NULL, token LONGTEXT NOT NULL, email VARCHAR(255) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_F11D61A28D93D649 (user), INDEX IDX_F11D61A2DE12AB56 (created_by), INDEX IDX_F11D61A216FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE audit_invitation_log (id INT UNSIGNED AUTO_INCREMENT NOT NULL, type VARCHAR(10) NOT NULL, object_id VARCHAR(255) NOT NULL, discriminator VARCHAR(255) DEFAULT NULL, transaction_hash VARCHAR(40) DEFAULT NULL, diffs LONGTEXT DEFAULT NULL, blame_id VARCHAR(255) DEFAULT NULL, blame_user VARCHAR(255) DEFAULT NULL, blame_user_fqdn VARCHAR(255) DEFAULT NULL, blame_user_firewall VARCHAR(100) DEFAULT NULL, ip VARCHAR(45) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX type_d55ae3341bb3a242a0557045b3066b3c_idx (type), INDEX object_id_d55ae3341bb3a242a0557045b3066b3c_idx (object_id), INDEX discriminator_d55ae3341bb3a242a0557045b3066b3c_idx (discriminator), INDEX transaction_hash_d55ae3341bb3a242a0557045b3066b3c_idx (transaction_hash), INDEX blame_id_d55ae3341bb3a242a0557045b3066b3c_idx (blame_id), INDEX created_at_d55ae3341bb3a242a0557045b3066b3c_idx (created_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE notes (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, description LONGTEXT DEFAULT NULL, full_description LONGTEXT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_11BA68CA76ED395 (user_id), INDEX IDX_11BA68CDE12AB56 (created_by), INDEX IDX_11BA68C16FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE notifications (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, project_id INT DEFAULT NULL, title VARCHAR(255) NOT NULL, description LONGTEXT NOT NULL, link VARCHAR(255) NOT NULL, additional_data LONGTEXT NOT NULL COMMENT \'(DC2Type:array)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', send_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', posted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', type VARCHAR(255) NOT NULL, slug VARCHAR(255) DEFAULT NULL, activity VARCHAR(255) DEFAULT NULL, is_viewed TINYINT(1) DEFAULT \'0\' NOT NULL, INDEX IDX_6000B0D3A76ED395 (user_id), INDEX IDX_6000B0D3166D1F9C (project_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE notify_post (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, event_id INT DEFAULT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_2EE4B43BA76ED395 (user_id), INDEX IDX_2EE4B43B71F7E88B (event_id), INDEX IDX_2EE4B43BDE12AB56 (created_by), INDEX IDX_2EE4B43B16FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects (id INT AUTO_INCREMENT NOT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, name VARCHAR(255) NOT NULL, color VARCHAR(255) DEFAULT NULL, direction INT DEFAULT NULL, type INT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, description LONGTEXT DEFAULT NULL, full_description LONGTEXT DEFAULT NULL, slug VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_5C93B3A4989D9B62 (slug), INDEX IDX_5C93B3A4DE12AB56 (created_by), INDEX IDX_5C93B3A416FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE audit_projects_log (id INT UNSIGNED AUTO_INCREMENT NOT NULL, type VARCHAR(10) NOT NULL, object_id VARCHAR(255) NOT NULL, discriminator VARCHAR(255) DEFAULT NULL, transaction_hash VARCHAR(40) DEFAULT NULL, diffs LONGTEXT DEFAULT NULL, blame_id VARCHAR(255) DEFAULT NULL, blame_user VARCHAR(255) DEFAULT NULL, blame_user_fqdn VARCHAR(255) DEFAULT NULL, blame_user_firewall VARCHAR(100) DEFAULT NULL, ip VARCHAR(45) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX type_2aeeb4581225b4da57b9e58632b6f5de_idx (type), INDEX object_id_2aeeb4581225b4da57b9e58632b6f5de_idx (object_id), INDEX discriminator_2aeeb4581225b4da57b9e58632b6f5de_idx (discriminator), INDEX transaction_hash_2aeeb4581225b4da57b9e58632b6f5de_idx (transaction_hash), INDEX blame_id_2aeeb4581225b4da57b9e58632b6f5de_idx (blame_id), INDEX created_at_2aeeb4581225b4da57b9e58632b6f5de_idx (created_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_experts (id INT AUTO_INCREMENT NOT NULL, project_id INT NOT NULL, user_id INT NOT NULL, parent_id INT DEFAULT NULL, federal_id INT DEFAULT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, reason VARCHAR(255) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_AE50EF35166D1F9C (project_id), INDEX IDX_AE50EF35A76ED395 (user_id), INDEX IDX_AE50EF35727ACA70 (parent_id), INDEX IDX_AE50EF35AEE0B307 (federal_id), INDEX IDX_AE50EF35DE12AB56 (created_by), INDEX IDX_AE50EF3516FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_managers (id INT AUTO_INCREMENT NOT NULL, project_id INT NOT NULL, user_id INT NOT NULL, parent_id INT DEFAULT NULL, federal_id INT DEFAULT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_C3D403EF166D1F9C (project_id), INDEX IDX_C3D403EFA76ED395 (user_id), INDEX IDX_C3D403EF727ACA70 (parent_id), INDEX IDX_C3D403EFAEE0B307 (federal_id), INDEX IDX_C3D403EFDE12AB56 (created_by), INDEX IDX_C3D403EF16FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE recovery (id INT AUTO_INCREMENT NOT NULL, user INT DEFAULT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, status INT NOT NULL, token LONGTEXT NOT NULL, email VARCHAR(255) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_F34393C98D93D649 (user), INDEX IDX_F34393C9DE12AB56 (created_by), INDEX IDX_F34393C916FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE refresh_tokens (id INT AUTO_INCREMENT NOT NULL, refresh_token VARCHAR(128) NOT NULL, username VARCHAR(255) NOT NULL, valid DATETIME NOT NULL, UNIQUE INDEX UNIQ_9BACE7E1C74F2195 (refresh_token), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE sent_mail (id INT AUTO_INCREMENT NOT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, email VARCHAR(255) NOT NULL, title VARCHAR(255) NOT NULL, body LONGTEXT NOT NULL COMMENT \'(DC2Type:array)\', twig VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_36371640DE12AB56 (created_by), INDEX IDX_3637164016FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE sleep_users (id INT AUTO_INCREMENT NOT NULL, firstname VARCHAR(255) DEFAULT NULL, lastname VARCHAR(255) DEFAULT NULL, middlename VARCHAR(255) DEFAULT NULL, project_id VARCHAR(255) NOT NULL, federal_ids VARCHAR(255) DEFAULT NULL, email VARCHAR(255) NOT NULL, activate TINYINT(1) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_answer (id INT AUTO_INCREMENT NOT NULL, voting_id INT DEFAULT NULL, answer_id INT DEFAULT NULL, user_id INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_BF8F51184254ACF8 (voting_id), INDEX IDX_BF8F5118AA334807 (answer_id), INDEX IDX_BF8F5118A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_competence (id INT AUTO_INCREMENT NOT NULL, project_id INT NOT NULL, federal_id INT DEFAULT NULL, user_id INT DEFAULT NULL, moderator_id INT DEFAULT NULL, competence_id INT DEFAULT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, status INT NOT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_33B3AE93166D1F9C (project_id), INDEX IDX_33B3AE93AEE0B307 (federal_id), INDEX IDX_33B3AE93A76ED395 (user_id), INDEX IDX_33B3AE93D0AFA354 (moderator_id), INDEX IDX_33B3AE9315761DAB (competence_id), INDEX IDX_33B3AE93DE12AB56 (created_by), INDEX IDX_33B3AE9316FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_education (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_DBEAD336A76ED395 (user_id), INDEX IDX_DBEAD336DE12AB56 (created_by), INDEX IDX_DBEAD33616FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_organization (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, position VARCHAR(255) NOT NULL, default_company TINYINT(1) DEFAULT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_41221F7EA76ED395 (user_id), INDEX IDX_41221F7EDE12AB56 (created_by), INDEX IDX_41221F7E16FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_rank (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, status TINYINT(1) NOT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_F2F8A42CA76ED395 (user_id), INDEX IDX_F2F8A42CDE12AB56 (created_by), INDEX IDX_F2F8A42C16FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_social_network (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, work TINYINT(1) NOT NULL, status TINYINT(1) NOT NULL, link VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_847A8D78A76ED395 (user_id), INDEX IDX_847A8D78DE12AB56 (created_by), INDEX IDX_847A8D7816FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE users (id INT AUTO_INCREMENT NOT NULL, firstname VARCHAR(255) DEFAULT NULL, lastname VARCHAR(255) DEFAULT NULL, middlename VARCHAR(255) DEFAULT NULL, email VARCHAR(255) NOT NULL, password VARCHAR(255) DEFAULT NULL, login VARCHAR(255) NOT NULL, phone_number VARCHAR(255) NOT NULL, step TINYINT(1) NOT NULL, view_phone TINYINT(1) DEFAULT NULL, verify_phone TINYINT(1) DEFAULT NULL, view_email TINYINT(1) DEFAULT NULL, roles JSON NOT NULL, avatar VARCHAR(255) DEFAULT NULL, is_verified TINYINT(1) NOT NULL, is_confirmed_status INT DEFAULT NULL, notification_token VARCHAR(255) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE audit_users_log (id INT UNSIGNED AUTO_INCREMENT NOT NULL, type VARCHAR(10) NOT NULL, object_id VARCHAR(255) NOT NULL, discriminator VARCHAR(255) DEFAULT NULL, transaction_hash VARCHAR(40) DEFAULT NULL, diffs LONGTEXT DEFAULT NULL, blame_id VARCHAR(255) DEFAULT NULL, blame_user VARCHAR(255) DEFAULT NULL, blame_user_fqdn VARCHAR(255) DEFAULT NULL, blame_user_firewall VARCHAR(100) DEFAULT NULL, ip VARCHAR(45) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX type_fe95beb7ad964d05d75ecccad4aced76_idx (type), INDEX object_id_fe95beb7ad964d05d75ecccad4aced76_idx (object_id), INDEX discriminator_fe95beb7ad964d05d75ecccad4aced76_idx (discriminator), INDEX transaction_hash_fe95beb7ad964d05d75ecccad4aced76_idx (transaction_hash), INDEX blame_id_fe95beb7ad964d05d75ecccad4aced76_idx (blame_id), INDEX created_at_fe95beb7ad964d05d75ecccad4aced76_idx (created_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE verify_sms (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, device_id INT DEFAULT NULL, type INT NOT NULL, activate TINYINT(1) NOT NULL, code VARCHAR(255) NOT NULL, phone_number VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, archive TINYINT(1) NOT NULL, INDEX IDX_89B54F1A76ED395 (user_id), INDEX IDX_89B54F194A4C7D4 (device_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE views (id INT AUTO_INCREMENT NOT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, entity VARCHAR(255) NOT NULL, entity_id VARCHAR(255) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_11F09C87DE12AB56 (created_by), INDEX IDX_11F09C8716FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE voting (id INT AUTO_INCREMENT NOT NULL, project_id INT DEFAULT NULL, event_id INT DEFAULT NULL, created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, name LONGTEXT NOT NULL, type SMALLINT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, archive TINYINT(1) NOT NULL, slug VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_FC28DA55989D9B62 (slug), INDEX IDX_FC28DA55166D1F9C (project_id), INDEX IDX_FC28DA5571F7E88B (event_id), INDEX IDX_FC28DA55DE12AB56 (created_by), INDEX IDX_FC28DA5516FE72E1 (updated_by), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE audit_voting_log (id INT UNSIGNED AUTO_INCREMENT NOT NULL, type VARCHAR(10) NOT NULL, object_id VARCHAR(255) NOT NULL, discriminator VARCHAR(255) DEFAULT NULL, transaction_hash VARCHAR(40) DEFAULT NULL, diffs LONGTEXT DEFAULT NULL, blame_id VARCHAR(255) DEFAULT NULL, blame_user VARCHAR(255) DEFAULT NULL, blame_user_fqdn VARCHAR(255) DEFAULT NULL, blame_user_firewall VARCHAR(100) DEFAULT NULL, ip VARCHAR(45) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX type_97af7608a5118207b305a8c11b310711_idx (type), INDEX object_id_97af7608a5118207b305a8c11b310711_idx (object_id), INDEX discriminator_97af7608a5118207b305a8c11b310711_idx (discriminator), INDEX transaction_hash_97af7608a5118207b305a8c11b310711_idx (transaction_hash), INDEX blame_id_97af7608a5118207b305a8c11b310711_idx (blame_id), INDEX created_at_97af7608a5118207b305a8c11b310711_idx (created_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('ALTER TABLE activity ADD CONSTRAINT FK_AC74095AA76ED395 FOREIGN KEY (user_id) REFERENCES users (id)');
$this->addSql('ALTER TABLE activity ADD CONSTRAINT FK_AC74095ADE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE activity ADD CONSTRAINT FK_AC74095A16FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE answer ADD CONSTRAINT FK_DADD4A254254ACF8 FOREIGN KEY (voting_id) REFERENCES voting (id)');
$this->addSql('ALTER TABLE banned ADD CONSTRAINT FK_9B490DB6A76ED395 FOREIGN KEY (user_id) REFERENCES users (id)');
$this->addSql('ALTER TABLE banned ADD CONSTRAINT FK_9B490DB671F7E88B FOREIGN KEY (event_id) REFERENCES event (id)');
$this->addSql('ALTER TABLE banned ADD CONSTRAINT FK_9B490DB6DE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE banned ADD CONSTRAINT FK_9B490DB616FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE competence ADD CONSTRAINT FK_94D4687F166D1F9C FOREIGN KEY (project_id) REFERENCES projects (id)');
$this->addSql('ALTER TABLE competence ADD CONSTRAINT FK_94D4687FAEE0B307 FOREIGN KEY (federal_id) REFERENCES federal (id)');
$this->addSql('ALTER TABLE competence ADD CONSTRAINT FK_94D4687FDE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE competence ADD CONSTRAINT FK_94D4687F16FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE custom_user_answer ADD CONSTRAINT FK_89B3E4D24254ACF8 FOREIGN KEY (voting_id) REFERENCES voting (id)');
$this->addSql('ALTER TABLE custom_user_answer ADD CONSTRAINT FK_89B3E4D2A76ED395 FOREIGN KEY (user_id) REFERENCES users (id)');
$this->addSql('ALTER TABLE device ADD CONSTRAINT FK_92FB68EA76ED395 FOREIGN KEY (user_id) REFERENCES users (id)');
$this->addSql('ALTER TABLE discussion_post ADD CONSTRAINT FK_7FE4C0BBA76ED395 FOREIGN KEY (user_id) REFERENCES users (id)');
$this->addSql('ALTER TABLE discussion_post ADD CONSTRAINT FK_7FE4C0BBB783D599 FOREIGN KEY (deactivate_user_id) REFERENCES deactivate_users (id)');
$this->addSql('ALTER TABLE discussion_post ADD CONSTRAINT FK_7FE4C0BB71F7E88B FOREIGN KEY (event_id) REFERENCES event (id)');
$this->addSql('ALTER TABLE discussion_post ADD CONSTRAINT FK_7FE4C0BB727ACA70 FOREIGN KEY (parent_id) REFERENCES discussion_post (id)');
$this->addSql('ALTER TABLE discussion_post ADD CONSTRAINT FK_7FE4C0BBDE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE discussion_post ADD CONSTRAINT FK_7FE4C0BB16FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE event ADD CONSTRAINT FK_3BAE0AA7166D1F9C FOREIGN KEY (project_id) REFERENCES projects (id)');
$this->addSql('ALTER TABLE event ADD CONSTRAINT FK_3BAE0AA7727ACA70 FOREIGN KEY (parent_id) REFERENCES event (id)');
$this->addSql('ALTER TABLE event ADD CONSTRAINT FK_3BAE0AA7DE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE event ADD CONSTRAINT FK_3BAE0AA716FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE federal ADD CONSTRAINT FK_22EE255F166D1F9C FOREIGN KEY (project_id) REFERENCES projects (id)');
$this->addSql('ALTER TABLE federal ADD CONSTRAINT FK_22EE255FDE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE federal ADD CONSTRAINT FK_22EE255F16FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE federal_items ADD CONSTRAINT FK_92B6BB0271F7E88B FOREIGN KEY (event_id) REFERENCES event (id)');
$this->addSql('ALTER TABLE federal_items ADD CONSTRAINT FK_92B6BB02AEE0B307 FOREIGN KEY (federal_id) REFERENCES federal (id)');
$this->addSql('ALTER TABLE federal_items ADD CONSTRAINT FK_92B6BB0215761DAB FOREIGN KEY (competence_id) REFERENCES competence (id)');
$this->addSql('ALTER TABLE federal_items ADD CONSTRAINT FK_92B6BB02DE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE federal_items ADD CONSTRAINT FK_92B6BB0216FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE files ADD CONSTRAINT FK_6354059DE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE files ADD CONSTRAINT FK_635405916FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE invitation ADD CONSTRAINT FK_F11D61A28D93D649 FOREIGN KEY (user) REFERENCES users (id)');
$this->addSql('ALTER TABLE invitation ADD CONSTRAINT FK_F11D61A2DE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE invitation ADD CONSTRAINT FK_F11D61A216FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE notes ADD CONSTRAINT FK_11BA68CA76ED395 FOREIGN KEY (user_id) REFERENCES users (id)');
$this->addSql('ALTER TABLE notes ADD CONSTRAINT FK_11BA68CDE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE notes ADD CONSTRAINT FK_11BA68C16FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE notifications ADD CONSTRAINT FK_6000B0D3A76ED395 FOREIGN KEY (user_id) REFERENCES users (id)');
$this->addSql('ALTER TABLE notifications ADD CONSTRAINT FK_6000B0D3166D1F9C FOREIGN KEY (project_id) REFERENCES projects (id)');
$this->addSql('ALTER TABLE notify_post ADD CONSTRAINT FK_2EE4B43BA76ED395 FOREIGN KEY (user_id) REFERENCES users (id)');
$this->addSql('ALTER TABLE notify_post ADD CONSTRAINT FK_2EE4B43B71F7E88B FOREIGN KEY (event_id) REFERENCES event (id)');
$this->addSql('ALTER TABLE notify_post ADD CONSTRAINT FK_2EE4B43BDE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE notify_post ADD CONSTRAINT FK_2EE4B43B16FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE projects ADD CONSTRAINT FK_5C93B3A4DE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE projects ADD CONSTRAINT FK_5C93B3A416FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE projects_experts ADD CONSTRAINT FK_AE50EF35166D1F9C FOREIGN KEY (project_id) REFERENCES projects (id)');
$this->addSql('ALTER TABLE projects_experts ADD CONSTRAINT FK_AE50EF35A76ED395 FOREIGN KEY (user_id) REFERENCES users (id)');
$this->addSql('ALTER TABLE projects_experts ADD CONSTRAINT FK_AE50EF35727ACA70 FOREIGN KEY (parent_id) REFERENCES projects_experts (id)');
$this->addSql('ALTER TABLE projects_experts ADD CONSTRAINT FK_AE50EF35AEE0B307 FOREIGN KEY (federal_id) REFERENCES federal (id)');
$this->addSql('ALTER TABLE projects_experts ADD CONSTRAINT FK_AE50EF35DE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE projects_experts ADD CONSTRAINT FK_AE50EF3516FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE projects_managers ADD CONSTRAINT FK_C3D403EF166D1F9C FOREIGN KEY (project_id) REFERENCES projects (id)');
$this->addSql('ALTER TABLE projects_managers ADD CONSTRAINT FK_C3D403EFA76ED395 FOREIGN KEY (user_id) REFERENCES users (id)');
$this->addSql('ALTER TABLE projects_managers ADD CONSTRAINT FK_C3D403EF727ACA70 FOREIGN KEY (parent_id) REFERENCES projects_experts (id)');
$this->addSql('ALTER TABLE projects_managers ADD CONSTRAINT FK_C3D403EFAEE0B307 FOREIGN KEY (federal_id) REFERENCES federal (id)');
$this->addSql('ALTER TABLE projects_managers ADD CONSTRAINT FK_C3D403EFDE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE projects_managers ADD CONSTRAINT FK_C3D403EF16FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE recovery ADD CONSTRAINT FK_F34393C98D93D649 FOREIGN KEY (user) REFERENCES users (id)');
$this->addSql('ALTER TABLE recovery ADD CONSTRAINT FK_F34393C9DE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE recovery ADD CONSTRAINT FK_F34393C916FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE sent_mail ADD CONSTRAINT FK_36371640DE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE sent_mail ADD CONSTRAINT FK_3637164016FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE user_answer ADD CONSTRAINT FK_BF8F51184254ACF8 FOREIGN KEY (voting_id) REFERENCES voting (id)');
$this->addSql('ALTER TABLE user_answer ADD CONSTRAINT FK_BF8F5118AA334807 FOREIGN KEY (answer_id) REFERENCES answer (id)');
$this->addSql('ALTER TABLE user_answer ADD CONSTRAINT FK_BF8F5118A76ED395 FOREIGN KEY (user_id) REFERENCES users (id)');
$this->addSql('ALTER TABLE user_competence ADD CONSTRAINT FK_33B3AE93166D1F9C FOREIGN KEY (project_id) REFERENCES projects (id)');
$this->addSql('ALTER TABLE user_competence ADD CONSTRAINT FK_33B3AE93AEE0B307 FOREIGN KEY (federal_id) REFERENCES federal (id)');
$this->addSql('ALTER TABLE user_competence ADD CONSTRAINT FK_33B3AE93A76ED395 FOREIGN KEY (user_id) REFERENCES users (id)');
$this->addSql('ALTER TABLE user_competence ADD CONSTRAINT FK_33B3AE93D0AFA354 FOREIGN KEY (moderator_id) REFERENCES users (id)');
$this->addSql('ALTER TABLE user_competence ADD CONSTRAINT FK_33B3AE9315761DAB FOREIGN KEY (competence_id) REFERENCES competence (id)');
$this->addSql('ALTER TABLE user_competence ADD CONSTRAINT FK_33B3AE93DE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE user_competence ADD CONSTRAINT FK_33B3AE9316FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE user_education ADD CONSTRAINT FK_DBEAD336A76ED395 FOREIGN KEY (user_id) REFERENCES users (id)');
$this->addSql('ALTER TABLE user_education ADD CONSTRAINT FK_DBEAD336DE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE user_education ADD CONSTRAINT FK_DBEAD33616FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE user_organization ADD CONSTRAINT FK_41221F7EA76ED395 FOREIGN KEY (user_id) REFERENCES users (id)');
$this->addSql('ALTER TABLE user_organization ADD CONSTRAINT FK_41221F7EDE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE user_organization ADD CONSTRAINT FK_41221F7E16FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE user_rank ADD CONSTRAINT FK_F2F8A42CA76ED395 FOREIGN KEY (user_id) REFERENCES users (id)');
$this->addSql('ALTER TABLE user_rank ADD CONSTRAINT FK_F2F8A42CDE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE user_rank ADD CONSTRAINT FK_F2F8A42C16FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE user_social_network ADD CONSTRAINT FK_847A8D78A76ED395 FOREIGN KEY (user_id) REFERENCES users (id)');
$this->addSql('ALTER TABLE user_social_network ADD CONSTRAINT FK_847A8D78DE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE user_social_network ADD CONSTRAINT FK_847A8D7816FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE verify_sms ADD CONSTRAINT FK_89B54F1A76ED395 FOREIGN KEY (user_id) REFERENCES users (id)');
$this->addSql('ALTER TABLE verify_sms ADD CONSTRAINT FK_89B54F194A4C7D4 FOREIGN KEY (device_id) REFERENCES device (id)');
$this->addSql('ALTER TABLE views ADD CONSTRAINT FK_11F09C87DE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE views ADD CONSTRAINT FK_11F09C8716FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE voting ADD CONSTRAINT FK_FC28DA55166D1F9C FOREIGN KEY (project_id) REFERENCES projects (id)');
$this->addSql('ALTER TABLE voting ADD CONSTRAINT FK_FC28DA5571F7E88B FOREIGN KEY (event_id) REFERENCES event (id)');
$this->addSql('ALTER TABLE voting ADD CONSTRAINT FK_FC28DA55DE12AB56 FOREIGN KEY (created_by) REFERENCES users (id)');
$this->addSql('ALTER TABLE voting ADD CONSTRAINT FK_FC28DA5516FE72E1 FOREIGN KEY (updated_by) REFERENCES users (id)');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE user_answer DROP FOREIGN KEY FK_BF8F5118AA334807');
$this->addSql('ALTER TABLE federal_items DROP FOREIGN KEY FK_92B6BB0215761DAB');
$this->addSql('ALTER TABLE user_competence DROP FOREIGN KEY FK_33B3AE9315761DAB');
$this->addSql('ALTER TABLE discussion_post DROP FOREIGN KEY FK_7FE4C0BBB783D599');
$this->addSql('ALTER TABLE verify_sms DROP FOREIGN KEY FK_89B54F194A4C7D4');
$this->addSql('ALTER TABLE discussion_post DROP FOREIGN KEY FK_7FE4C0BB727ACA70');
$this->addSql('ALTER TABLE banned DROP FOREIGN KEY FK_9B490DB671F7E88B');
$this->addSql('ALTER TABLE discussion_post DROP FOREIGN KEY FK_7FE4C0BB71F7E88B');
$this->addSql('ALTER TABLE event DROP FOREIGN KEY FK_3BAE0AA7727ACA70');
$this->addSql('ALTER TABLE federal_items DROP FOREIGN KEY FK_92B6BB0271F7E88B');
$this->addSql('ALTER TABLE notify_post DROP FOREIGN KEY FK_2EE4B43B71F7E88B');
$this->addSql('ALTER TABLE voting DROP FOREIGN KEY FK_FC28DA5571F7E88B');
$this->addSql('ALTER TABLE competence DROP FOREIGN KEY FK_94D4687FAEE0B307');
$this->addSql('ALTER TABLE federal_items DROP FOREIGN KEY FK_92B6BB02AEE0B307');
$this->addSql('ALTER TABLE projects_experts DROP FOREIGN KEY FK_AE50EF35AEE0B307');
$this->addSql('ALTER TABLE projects_managers DROP FOREIGN KEY FK_C3D403EFAEE0B307');
$this->addSql('ALTER TABLE user_competence DROP FOREIGN KEY FK_33B3AE93AEE0B307');
$this->addSql('ALTER TABLE competence DROP FOREIGN KEY FK_94D4687F166D1F9C');
$this->addSql('ALTER TABLE event DROP FOREIGN KEY FK_3BAE0AA7166D1F9C');
$this->addSql('ALTER TABLE federal DROP FOREIGN KEY FK_22EE255F166D1F9C');
$this->addSql('ALTER TABLE notifications DROP FOREIGN KEY FK_6000B0D3166D1F9C');
$this->addSql('ALTER TABLE projects_experts DROP FOREIGN KEY FK_AE50EF35166D1F9C');
$this->addSql('ALTER TABLE projects_managers DROP FOREIGN KEY FK_C3D403EF166D1F9C');
$this->addSql('ALTER TABLE user_competence DROP FOREIGN KEY FK_33B3AE93166D1F9C');
$this->addSql('ALTER TABLE voting DROP FOREIGN KEY FK_FC28DA55166D1F9C');
$this->addSql('ALTER TABLE projects_experts DROP FOREIGN KEY FK_AE50EF35727ACA70');
$this->addSql('ALTER TABLE projects_managers DROP FOREIGN KEY FK_C3D403EF727ACA70');
$this->addSql('ALTER TABLE activity DROP FOREIGN KEY FK_AC74095AA76ED395');
$this->addSql('ALTER TABLE activity DROP FOREIGN KEY FK_AC74095ADE12AB56');
$this->addSql('ALTER TABLE activity DROP FOREIGN KEY FK_AC74095A16FE72E1');
$this->addSql('ALTER TABLE banned DROP FOREIGN KEY FK_9B490DB6A76ED395');
$this->addSql('ALTER TABLE banned DROP FOREIGN KEY FK_9B490DB6DE12AB56');
$this->addSql('ALTER TABLE banned DROP FOREIGN KEY FK_9B490DB616FE72E1');
$this->addSql('ALTER TABLE competence DROP FOREIGN KEY FK_94D4687FDE12AB56');
$this->addSql('ALTER TABLE competence DROP FOREIGN KEY FK_94D4687F16FE72E1');
$this->addSql('ALTER TABLE custom_user_answer DROP FOREIGN KEY FK_89B3E4D2A76ED395');
$this->addSql('ALTER TABLE device DROP FOREIGN KEY FK_92FB68EA76ED395');
$this->addSql('ALTER TABLE discussion_post DROP FOREIGN KEY FK_7FE4C0BBA76ED395');
$this->addSql('ALTER TABLE discussion_post DROP FOREIGN KEY FK_7FE4C0BBDE12AB56');
$this->addSql('ALTER TABLE discussion_post DROP FOREIGN KEY FK_7FE4C0BB16FE72E1');
$this->addSql('ALTER TABLE event DROP FOREIGN KEY FK_3BAE0AA7DE12AB56');
$this->addSql('ALTER TABLE event DROP FOREIGN KEY FK_3BAE0AA716FE72E1');
$this->addSql('ALTER TABLE federal DROP FOREIGN KEY FK_22EE255FDE12AB56');
$this->addSql('ALTER TABLE federal DROP FOREIGN KEY FK_22EE255F16FE72E1');
$this->addSql('ALTER TABLE federal_items DROP FOREIGN KEY FK_92B6BB02DE12AB56');
$this->addSql('ALTER TABLE federal_items DROP FOREIGN KEY FK_92B6BB0216FE72E1');
$this->addSql('ALTER TABLE files DROP FOREIGN KEY FK_6354059DE12AB56');
$this->addSql('ALTER TABLE files DROP FOREIGN KEY FK_635405916FE72E1');
$this->addSql('ALTER TABLE invitation DROP FOREIGN KEY FK_F11D61A28D93D649');
$this->addSql('ALTER TABLE invitation DROP FOREIGN KEY FK_F11D61A2DE12AB56');
$this->addSql('ALTER TABLE invitation DROP FOREIGN KEY FK_F11D61A216FE72E1');
$this->addSql('ALTER TABLE notes DROP FOREIGN KEY FK_11BA68CA76ED395');
$this->addSql('ALTER TABLE notes DROP FOREIGN KEY FK_11BA68CDE12AB56');
$this->addSql('ALTER TABLE notes DROP FOREIGN KEY FK_11BA68C16FE72E1');
$this->addSql('ALTER TABLE notifications DROP FOREIGN KEY FK_6000B0D3A76ED395');
$this->addSql('ALTER TABLE notify_post DROP FOREIGN KEY FK_2EE4B43BA76ED395');
$this->addSql('ALTER TABLE notify_post DROP FOREIGN KEY FK_2EE4B43BDE12AB56');
$this->addSql('ALTER TABLE notify_post DROP FOREIGN KEY FK_2EE4B43B16FE72E1');
$this->addSql('ALTER TABLE projects DROP FOREIGN KEY FK_5C93B3A4DE12AB56');
$this->addSql('ALTER TABLE projects DROP FOREIGN KEY FK_5C93B3A416FE72E1');
$this->addSql('ALTER TABLE projects_experts DROP FOREIGN KEY FK_AE50EF35A76ED395');
$this->addSql('ALTER TABLE projects_experts DROP FOREIGN KEY FK_AE50EF35DE12AB56');
$this->addSql('ALTER TABLE projects_experts DROP FOREIGN KEY FK_AE50EF3516FE72E1');
$this->addSql('ALTER TABLE projects_managers DROP FOREIGN KEY FK_C3D403EFA76ED395');
$this->addSql('ALTER TABLE projects_managers DROP FOREIGN KEY FK_C3D403EFDE12AB56');
$this->addSql('ALTER TABLE projects_managers DROP FOREIGN KEY FK_C3D403EF16FE72E1');
$this->addSql('ALTER TABLE recovery DROP FOREIGN KEY FK_F34393C98D93D649');
$this->addSql('ALTER TABLE recovery DROP FOREIGN KEY FK_F34393C9DE12AB56');
$this->addSql('ALTER TABLE recovery DROP FOREIGN KEY FK_F34393C916FE72E1');
$this->addSql('ALTER TABLE sent_mail DROP FOREIGN KEY FK_36371640DE12AB56');
$this->addSql('ALTER TABLE sent_mail DROP FOREIGN KEY FK_3637164016FE72E1');
$this->addSql('ALTER TABLE user_answer DROP FOREIGN KEY FK_BF8F5118A76ED395');
$this->addSql('ALTER TABLE user_competence DROP FOREIGN KEY FK_33B3AE93A76ED395');
$this->addSql('ALTER TABLE user_competence DROP FOREIGN KEY FK_33B3AE93D0AFA354');
$this->addSql('ALTER TABLE user_competence DROP FOREIGN KEY FK_33B3AE93DE12AB56');
$this->addSql('ALTER TABLE user_competence DROP FOREIGN KEY FK_33B3AE9316FE72E1');
$this->addSql('ALTER TABLE user_education DROP FOREIGN KEY FK_DBEAD336A76ED395');
$this->addSql('ALTER TABLE user_education DROP FOREIGN KEY FK_DBEAD336DE12AB56');
$this->addSql('ALTER TABLE user_education DROP FOREIGN KEY FK_DBEAD33616FE72E1');
$this->addSql('ALTER TABLE user_organization DROP FOREIGN KEY FK_41221F7EA76ED395');
$this->addSql('ALTER TABLE user_organization DROP FOREIGN KEY FK_41221F7EDE12AB56');
$this->addSql('ALTER TABLE user_organization DROP FOREIGN KEY FK_41221F7E16FE72E1');
$this->addSql('ALTER TABLE user_rank DROP FOREIGN KEY FK_F2F8A42CA76ED395');
$this->addSql('ALTER TABLE user_rank DROP FOREIGN KEY FK_F2F8A42CDE12AB56');
$this->addSql('ALTER TABLE user_rank DROP FOREIGN KEY FK_F2F8A42C16FE72E1');
$this->addSql('ALTER TABLE user_social_network DROP FOREIGN KEY FK_847A8D78A76ED395');
$this->addSql('ALTER TABLE user_social_network DROP FOREIGN KEY FK_847A8D78DE12AB56');
$this->addSql('ALTER TABLE user_social_network DROP FOREIGN KEY FK_847A8D7816FE72E1');
$this->addSql('ALTER TABLE verify_sms DROP FOREIGN KEY FK_89B54F1A76ED395');
$this->addSql('ALTER TABLE views DROP FOREIGN KEY FK_11F09C87DE12AB56');
$this->addSql('ALTER TABLE views DROP FOREIGN KEY FK_11F09C8716FE72E1');
$this->addSql('ALTER TABLE voting DROP FOREIGN KEY FK_FC28DA55DE12AB56');
$this->addSql('ALTER TABLE voting DROP FOREIGN KEY FK_FC28DA5516FE72E1');
$this->addSql('ALTER TABLE answer DROP FOREIGN KEY FK_DADD4A254254ACF8');
$this->addSql('ALTER TABLE custom_user_answer DROP FOREIGN KEY FK_89B3E4D24254ACF8');
$this->addSql('ALTER TABLE user_answer DROP FOREIGN KEY FK_BF8F51184254ACF8');
$this->addSql('DROP TABLE activity');
$this->addSql('DROP TABLE audit_activity_log');
$this->addSql('DROP TABLE answer');
$this->addSql('DROP TABLE banned');
$this->addSql('DROP TABLE competence');
$this->addSql('DROP TABLE custom_user_answer');
$this->addSql('DROP TABLE deactivate_users');
$this->addSql('DROP TABLE device');
$this->addSql('DROP TABLE discussion_post');
$this->addSql('DROP TABLE audit_discussion_post_log');
$this->addSql('DROP TABLE event');
$this->addSql('DROP TABLE audit_event_log');
$this->addSql('DROP TABLE federal');
$this->addSql('DROP TABLE audit_federal_log');
$this->addSql('DROP TABLE federal_items');
$this->addSql('DROP TABLE files');
$this->addSql('DROP TABLE invitation');
$this->addSql('DROP TABLE audit_invitation_log');
$this->addSql('DROP TABLE notes');
$this->addSql('DROP TABLE notifications');
$this->addSql('DROP TABLE notify_post');
$this->addSql('DROP TABLE projects');
$this->addSql('DROP TABLE audit_projects_log');
$this->addSql('DROP TABLE projects_experts');
$this->addSql('DROP TABLE projects_managers');
$this->addSql('DROP TABLE recovery');
$this->addSql('DROP TABLE refresh_tokens');
$this->addSql('DROP TABLE sent_mail');
$this->addSql('DROP TABLE sleep_users');
$this->addSql('DROP TABLE user_answer');
$this->addSql('DROP TABLE user_competence');
$this->addSql('DROP TABLE user_education');
$this->addSql('DROP TABLE user_organization');
$this->addSql('DROP TABLE user_rank');
$this->addSql('DROP TABLE user_social_network');
$this->addSql('DROP TABLE users');
$this->addSql('DROP TABLE audit_users_log');
$this->addSql('DROP TABLE verify_sms');
$this->addSql('DROP TABLE views');
$this->addSql('DROP TABLE voting');
$this->addSql('DROP TABLE audit_voting_log');
}
}