migrations/Version20230110170453.php line 1
<?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 Version20230110170453 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 speaky_part_event (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, publish_start DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', publish_end DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', thumbnail VARCHAR(255) DEFAULT NULL, speaky_thumbnail VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE trophie (id INT AUTO_INCREMENT NOT NULL, game_id INT DEFAULT NULL, theme_id INT DEFAULT NULL, type VARCHAR(12) NOT NULL, requirement VARCHAR(127) NOT NULL, level SMALLINT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', thumbnail VARCHAR(255) DEFAULT NULL, INDEX IDX_7CDF182DE48FD905 (game_id), INDEX IDX_7CDF182D59027487 (theme_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE url_infos (id INT AUTO_INCREMENT NOT NULL, type VARCHAR(255) NOT NULL, route VARCHAR(255) NOT NULL, entity_id INT NOT NULL, route_param VARCHAR(255) DEFAULT NULL, entity_name VARCHAR(255) DEFAULT NULL, priority SMALLINT NOT NULL, last_mod DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', request_path VARCHAR(512) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, e_country_id INT NOT NULL, library_id INT DEFAULT NULL, avatar_id INT DEFAULT NULL, username VARCHAR(180) NOT NULL, roles JSON NOT NULL, password VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, first_name VARCHAR(255) DEFAULT NULL, last_name VARCHAR(255) DEFAULT NULL, birth_date DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', last_birthday DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', last_app_login DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', male TINYINT(1) NOT NULL, school_name VARCHAR(255) DEFAULT NULL, address VARCHAR(255) DEFAULT NULL, zip_code VARCHAR(255) DEFAULT NULL, city VARCHAR(255) DEFAULT NULL, locale VARCHAR(25) DEFAULT NULL, facebook_id VARCHAR(255) DEFAULT NULL, subscription_expire_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', unsetcard_expire_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', subscription_date DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', is_subscriber TINYINT(1) DEFAULT NULL, subscription_confirmed VARCHAR(10) DEFAULT NULL, is_registration_confirmed TINYINT(1) DEFAULT NULL, presentation LONGTEXT DEFAULT NULL, new_presentation LONGTEXT DEFAULT NULL, incorrect_presentation TINYINT(1) DEFAULT NULL, theme VARCHAR(255) DEFAULT NULL, biblio_id VARCHAR(255) DEFAULT NULL, last_part_bought_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', mail_confirmed_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', salt VARCHAR(255) DEFAULT NULL, legacy_password VARCHAR(255) DEFAULT NULL, newsletter TINYINT(1) NOT NULL, reminder_index INT NOT NULL, serialized_tags LONGTEXT NOT NULL, speakos INT NOT NULL, total_speakos INT NOT NULL, app_token VARCHAR(255) DEFAULT NULL, is_verified TINYINT(1) NOT NULL, username_canonical VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_8D93D649F85E0677 (username), INDEX IDX_8D93D6493AC7A293 (e_country_id), INDEX IDX_8D93D649FE2541D7 (library_id), UNIQUE INDEX UNIQ_8D93D64986383B10 (avatar_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_gift_code (user_id INT NOT NULL, gift_code_id INT NOT NULL, INDEX IDX_85884F21A76ED395 (user_id), INDEX IDX_85884F214B80CDB8 (gift_code_id), PRIMARY KEY(user_id, gift_code_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_activity (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, game_id INT DEFAULT NULL, type VARCHAR(127) NOT NULL, param VARCHAR(127) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_4CF9ED5AA76ED395 (user_id), INDEX IDX_4CF9ED5AE48FD905 (game_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_challenge_reward (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, challenge_id INT NOT NULL, goodies_id INT DEFAULT NULL, level INT NOT NULL, state VARCHAR(25) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_C079934FA76ED395 (user_id), INDEX IDX_C079934F98A21AC6 (challenge_id), INDEX IDX_C079934FBBFA5614 (goodies_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_filter (id INT AUTO_INCREMENT NOT NULL, serialized_filter LONGTEXT DEFAULT NULL, predefined TINYINT(1) NOT NULL, slug VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, static_segment TINYINT(1) NOT NULL, mail_chimp_id INT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_game_config (id INT AUTO_INCREMENT NOT NULL, game_id INT DEFAULT NULL, user_id INT DEFAULT NULL, user_level SMALLINT NOT NULL, subtitles_settings VARCHAR(127) NOT NULL, help_settings VARCHAR(127) NOT NULL, top_score INT NOT NULL, game_rank INT NOT NULL, rank_pos INT NOT NULL, weekly_score INT NOT NULL, weekly_rank INT DEFAULT NULL, weekly_pos INT DEFAULT NULL, favorite TINYINT(1) NOT NULL, popularity INT NOT NULL, INDEX IDX_A44B21A76ED395 (user_id), INDEX IDX_A44B21E48FD905 (game_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_gift_payment (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, e_country_id INT NOT NULL, promo_code_id INT DEFAULT NULL, payment_id INT NOT NULL, reference VARCHAR(255) NOT NULL, bill_number VARCHAR(255) DEFAULT NULL, bill_number_set_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', locale VARCHAR(25) NOT NULL, type VARCHAR(25) NOT NULL, token VARCHAR(255) DEFAULT NULL, paypal_id VARCHAR(255) DEFAULT NULL, first_name VARCHAR(255) NOT NULL, last_name VARCHAR(255) NOT NULL, address VARCHAR(255) NOT NULL, zip_code VARCHAR(127) NOT NULL, city VARCHAR(255) NOT NULL, country VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, montant DOUBLE PRECISION NOT NULL, montant_reel DOUBLE PRECISION NOT NULL, currency_rate DOUBLE PRECISION DEFAULT NULL, base_reel DOUBLE PRECISION DEFAULT NULL, frais_reel DOUBLE PRECISION DEFAULT NULL, tva DOUBLE PRECISION NOT NULL, waiting_payment TINYINT(1) NOT NULL, is_credit TINYINT(1) NOT NULL, statut VARCHAR(255) DEFAULT NULL, private_key VARCHAR(255) DEFAULT NULL, confirmed_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', num_facture INT DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_81BECBA0A76ED395 (user_id), INDEX IDX_81BECBA03AC7A293 (e_country_id), INDEX IDX_81BECBA02FAE4625 (promo_code_id), INDEX IDX_81BECBA04C3A3BB (payment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_group_payment (id INT AUTO_INCREMENT NOT NULL, e_country_id INT NOT NULL, reference VARCHAR(255) NOT NULL, bill_number VARCHAR(255) DEFAULT NULL, bill_number_set_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', type VARCHAR(25) DEFAULT NULL, token VARCHAR(255) DEFAULT NULL, paypal_id VARCHAR(255) DEFAULT NULL, structure VARCHAR(255) NOT NULL, first_name VARCHAR(255) NOT NULL, last_name VARCHAR(255) NOT NULL, address VARCHAR(255) NOT NULL, zip_code VARCHAR(127) NOT NULL, city VARCHAR(255) NOT NULL, country VARCHAR(255) NOT NULL, country_code VARCHAR(20) NOT NULL, email VARCHAR(255) NOT NULL, montant DOUBLE PRECISION NOT NULL, montant_reel DOUBLE PRECISION NOT NULL, montant_one DOUBLE PRECISION NOT NULL, montant_two DOUBLE PRECISION NOT NULL, quantity_one INT NOT NULL, quantity_two INT NOT NULL, currency VARCHAR(255) NOT NULL, waiting_payment TINYINT(1) NOT NULL, statut VARCHAR(255) DEFAULT NULL, private_key VARCHAR(255) NOT NULL, confirmed_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', num_facture INT DEFAULT NULL, tva DOUBLE PRECISION NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_5A67D513AC7A293 (e_country_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_login (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, connections SMALLINT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_48CA3048A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_overall_progress (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, word_progress INT NOT NULL, listened INT NOT NULL, familiar INT NOT NULL, known INT NOT NULL, mastered INT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', time INT NOT NULL, INDEX IDX_185FA60EA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_payment (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, e_country_id INT NOT NULL, promo_code_id INT DEFAULT NULL, user_data_id INT DEFAULT NULL, payment_id INT NOT NULL, reference VARCHAR(255) NOT NULL, bill_number VARCHAR(255) DEFAULT NULL, bill_number_set_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', locale VARCHAR(25) NOT NULL, token VARCHAR(255) DEFAULT NULL, paypal_id VARCHAR(255) DEFAULT NULL, first_name VARCHAR(255) NOT NULL, last_name VARCHAR(255) NOT NULL, type VARCHAR(25) NOT NULL, montant DOUBLE PRECISION NOT NULL, montant_reel DOUBLE PRECISION NOT NULL, currency_rate DOUBLE PRECISION DEFAULT NULL, base_reel DOUBLE PRECISION DEFAULT NULL, frais_reel DOUBLE PRECISION DEFAULT NULL, expire_at INT DEFAULT NULL, waiting_payment TINYINT(1) NOT NULL, is_credit TINYINT(1) NOT NULL, is_refunded TINYINT(1) NOT NULL, statut VARCHAR(255) DEFAULT NULL, confirmed_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', cancelled_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', num_facture INT DEFAULT NULL, tva DOUBLE PRECISION NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', occurence INT NOT NULL, INDEX IDX_35259A07A76ED395 (user_id), INDEX IDX_35259A073AC7A293 (e_country_id), INDEX IDX_35259A072FAE4625 (promo_code_id), INDEX IDX_35259A076FF8BF36 (user_data_id), INDEX IDX_35259A074C3A3BB (payment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_sentence (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, sentence_id INT NOT NULL, sentence_order INT NOT NULL, INDEX IDX_7DEBAAD5A76ED395 (user_id), INDEX IDX_7DEBAAD527289490 (sentence_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_speaky_part (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, part_id INT NOT NULL, owned TINYINT(1) NOT NULL, INDEX IDX_2E341E0BA76ED395 (user_id), INDEX IDX_2E341E0B4CE34BEC (part_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_subscribe_activity (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, type VARCHAR(127) NOT NULL, statut VARCHAR(127) NOT NULL, is_auto TINYINT(1) NOT NULL, validated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_154FD7AFA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_temp_data (id INT AUTO_INCREMENT NOT NULL, e_country_id INT NOT NULL, user_name VARCHAR(255) DEFAULT NULL, first_name VARCHAR(255) DEFAULT NULL, last_name VARCHAR(255) DEFAULT NULL, email VARCHAR(255) DEFAULT NULL, locale VARCHAR(25) NOT NULL, facebook_id VARCHAR(255) DEFAULT NULL, password VARCHAR(255) NOT NULL, serialized_tags LONGTEXT NOT NULL, school_name VARCHAR(255) DEFAULT NULL, address VARCHAR(255) DEFAULT NULL, zip_code VARCHAR(127) DEFAULT NULL, city VARCHAR(255) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_41AF1CD3AC7A293 (e_country_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_trophy (id INT AUTO_INCREMENT NOT NULL, trophy_id INT NOT NULL, user_id INT NOT NULL, score INT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_7478E1D4F59AEEEF (trophy_id), INDEX IDX_7478E1D4A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_weekly_theme (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, weekly_theme_id INT NOT NULL, first_game TINYINT(1) NOT NULL, second_game TINYINT(1) NOT NULL, third_game TINYINT(1) NOT NULL, complete TINYINT(1) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_318BB21AA76ED395 (user_id), INDEX IDX_318BB21AC9B519BA (weekly_theme_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_word_progress (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, word_id INT NOT NULL, progress INT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_E8318EC7A76ED395 (user_id), INDEX IDX_E8318EC7E357438D (word_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE weekly_hero (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, slug VARCHAR(255) NOT NULL, description LONGTEXT NOT NULL, begin_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', end_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', picture VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE weekly_theme (id INT AUTO_INCREMENT NOT NULL, first_game_id INT NOT NULL, second_game_id INT NOT NULL, third_game_id INT NOT NULL, theme_id INT NOT NULL, trophy_id INT NOT NULL, first_condition VARCHAR(25) NOT NULL, first_goal INT NOT NULL, second_condition VARCHAR(25) NOT NULL, second_goal INT NOT NULL, third_condition VARCHAR(25) NOT NULL, third_goal INT NOT NULL, begin_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', end_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', prize VARCHAR(25) NOT NULL, prize_detail INT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_B147CE18F703B5F9 (first_game_id), INDEX IDX_B147CE18F3CD5968 (second_game_id), INDEX IDX_B147CE18762880C7 (third_game_id), INDEX IDX_B147CE1859027487 (theme_id), INDEX IDX_B147CE18F59AEEEF (trophy_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE word (id INT AUTO_INCREMENT NOT NULL, thumbnail_id INT DEFAULT NULL, sound_id INT DEFAULT NULL, prod_id INT NOT NULL, word VARCHAR(255) NOT NULL, translation VARCHAR(255) NOT NULL, intro LONGTEXT NOT NULL, description LONGTEXT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', main_type VARCHAR(32) NOT NULL, no_thumbnail TINYINT(1) NOT NULL, thumbnails_count INT NOT NULL, UNIQUE INDEX UNIQ_C3F17511FDFF2E92 (thumbnail_id), UNIQUE INDEX UNIQ_C3F175116AAA5C3E (sound_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE wrapper_sound (id INT AUTO_INCREMENT NOT NULL, sound_id INT NOT NULL, type VARCHAR(127) NOT NULL, display VARCHAR(20) NOT NULL, subtitle LONGTEXT NOT NULL, translation LONGTEXT NOT NULL, xml_id VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_B7BACDE66AAA5C3E (sound_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE messenger_messages (id BIGINT AUTO_INCREMENT NOT NULL, body LONGTEXT NOT NULL, headers LONGTEXT NOT NULL, queue_name VARCHAR(190) NOT NULL, created_at DATETIME NOT NULL, available_at DATETIME NOT NULL, delivered_at DATETIME DEFAULT NULL, INDEX IDX_75EA56E0FB7336F0 (queue_name), INDEX IDX_75EA56E0E3BD61CE (available_at), INDEX IDX_75EA56E016BA31DB (delivered_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('ALTER TABLE trophie ADD CONSTRAINT FK_7CDF182DE48FD905 FOREIGN KEY (game_id) REFERENCES game (id)');
$this->addSql('ALTER TABLE trophie ADD CONSTRAINT FK_7CDF182D59027487 FOREIGN KEY (theme_id) REFERENCES category (id)');
$this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D6493AC7A293 FOREIGN KEY (e_country_id) REFERENCES country (id)');
$this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D649FE2541D7 FOREIGN KEY (library_id) REFERENCES library (id)');
$this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D64986383B10 FOREIGN KEY (avatar_id) REFERENCES speaky (id)');
$this->addSql('ALTER TABLE user_gift_code ADD CONSTRAINT FK_85884F21A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE user_gift_code ADD CONSTRAINT FK_85884F214B80CDB8 FOREIGN KEY (gift_code_id) REFERENCES gift_code (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE user_activity ADD CONSTRAINT FK_4CF9ED5AA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE user_activity ADD CONSTRAINT FK_4CF9ED5AE48FD905 FOREIGN KEY (game_id) REFERENCES game (id)');
$this->addSql('ALTER TABLE user_challenge_reward ADD CONSTRAINT FK_C079934FA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE user_challenge_reward ADD CONSTRAINT FK_C079934F98A21AC6 FOREIGN KEY (challenge_id) REFERENCES popin (id)');
$this->addSql('ALTER TABLE user_challenge_reward ADD CONSTRAINT FK_C079934FBBFA5614 FOREIGN KEY (goodies_id) REFERENCES goodies (id)');
$this->addSql('ALTER TABLE user_game_config ADD CONSTRAINT FK_A44B21A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE user_game_config ADD CONSTRAINT FK_A44B21E48FD905 FOREIGN KEY (game_id) REFERENCES game (id)');
$this->addSql('ALTER TABLE user_gift_payment ADD CONSTRAINT FK_81BECBA0A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE user_gift_payment ADD CONSTRAINT FK_81BECBA03AC7A293 FOREIGN KEY (e_country_id) REFERENCES country (id)');
$this->addSql('ALTER TABLE user_gift_payment ADD CONSTRAINT FK_81BECBA02FAE4625 FOREIGN KEY (promo_code_id) REFERENCES promo_code (id)');
$this->addSql('ALTER TABLE user_gift_payment ADD CONSTRAINT FK_81BECBA04C3A3BB FOREIGN KEY (payment_id) REFERENCES payment_method (id)');
$this->addSql('ALTER TABLE user_group_payment ADD CONSTRAINT FK_5A67D513AC7A293 FOREIGN KEY (e_country_id) REFERENCES country (id)');
$this->addSql('ALTER TABLE user_login ADD CONSTRAINT FK_48CA3048A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE user_overall_progress ADD CONSTRAINT FK_185FA60EA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE user_payment ADD CONSTRAINT FK_35259A07A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE user_payment ADD CONSTRAINT FK_35259A073AC7A293 FOREIGN KEY (e_country_id) REFERENCES country (id)');
$this->addSql('ALTER TABLE user_payment ADD CONSTRAINT FK_35259A072FAE4625 FOREIGN KEY (promo_code_id) REFERENCES promo_code (id)');
$this->addSql('ALTER TABLE user_payment ADD CONSTRAINT FK_35259A076FF8BF36 FOREIGN KEY (user_data_id) REFERENCES user_temp_data (id)');
$this->addSql('ALTER TABLE user_payment ADD CONSTRAINT FK_35259A074C3A3BB FOREIGN KEY (payment_id) REFERENCES payment_method (id)');
$this->addSql('ALTER TABLE user_sentence ADD CONSTRAINT FK_7DEBAAD5A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE user_sentence ADD CONSTRAINT FK_7DEBAAD527289490 FOREIGN KEY (sentence_id) REFERENCES passport_sentence (id)');
$this->addSql('ALTER TABLE user_speaky_part ADD CONSTRAINT FK_2E341E0BA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE user_speaky_part ADD CONSTRAINT FK_2E341E0B4CE34BEC FOREIGN KEY (part_id) REFERENCES speaky_part (id)');
$this->addSql('ALTER TABLE user_subscribe_activity ADD CONSTRAINT FK_154FD7AFA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE user_temp_data ADD CONSTRAINT FK_41AF1CD3AC7A293 FOREIGN KEY (e_country_id) REFERENCES country (id)');
$this->addSql('ALTER TABLE user_trophy ADD CONSTRAINT FK_7478E1D4F59AEEEF FOREIGN KEY (trophy_id) REFERENCES trophie (id)');
$this->addSql('ALTER TABLE user_trophy ADD CONSTRAINT FK_7478E1D4A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE user_weekly_theme ADD CONSTRAINT FK_318BB21AA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE user_weekly_theme ADD CONSTRAINT FK_318BB21AC9B519BA FOREIGN KEY (weekly_theme_id) REFERENCES weekly_theme (id)');
$this->addSql('ALTER TABLE user_word_progress ADD CONSTRAINT FK_E8318EC7A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE user_word_progress ADD CONSTRAINT FK_E8318EC7E357438D FOREIGN KEY (word_id) REFERENCES word (id)');
$this->addSql('ALTER TABLE weekly_theme ADD CONSTRAINT FK_B147CE18F703B5F9 FOREIGN KEY (first_game_id) REFERENCES game (id)');
$this->addSql('ALTER TABLE weekly_theme ADD CONSTRAINT FK_B147CE18F3CD5968 FOREIGN KEY (second_game_id) REFERENCES game (id)');
$this->addSql('ALTER TABLE weekly_theme ADD CONSTRAINT FK_B147CE18762880C7 FOREIGN KEY (third_game_id) REFERENCES game (id)');
$this->addSql('ALTER TABLE weekly_theme ADD CONSTRAINT FK_B147CE1859027487 FOREIGN KEY (theme_id) REFERENCES category (id)');
$this->addSql('ALTER TABLE weekly_theme ADD CONSTRAINT FK_B147CE18F59AEEEF FOREIGN KEY (trophy_id) REFERENCES trophie (id)');
$this->addSql('ALTER TABLE word ADD CONSTRAINT FK_C3F17511FDFF2E92 FOREIGN KEY (thumbnail_id) REFERENCES media_file (id)');
$this->addSql('ALTER TABLE word ADD CONSTRAINT FK_C3F175116AAA5C3E FOREIGN KEY (sound_id) REFERENCES media_file (id)');
$this->addSql('ALTER TABLE wrapper_sound ADD CONSTRAINT FK_B7BACDE66AAA5C3E FOREIGN KEY (sound_id) REFERENCES media_file (id)');
$this->addSql('ALTER TABLE game ADD CONSTRAINT FK_232B318C24DB0683 FOREIGN KEY (config_id) REFERENCES game_config (id)');
$this->addSql('ALTER TABLE game ADD CONSTRAINT FK_232B318CC6C55574 FOREIGN KEY (main_category_id) REFERENCES category (id)');
$this->addSql('ALTER TABLE game ADD CONSTRAINT FK_232B318C802065F2 FOREIGN KEY (main_theme_id) REFERENCES category (id)');
$this->addSql('ALTER TABLE game ADD CONSTRAINT FK_232B318C33221A65 FOREIGN KEY (main_class_id) REFERENCES category (id)');
$this->addSql('ALTER TABLE game ADD CONSTRAINT FK_232B318C45B0BCD FOREIGN KEY (hero_id) REFERENCES weekly_hero (id)');
$this->addSql('ALTER TABLE game ADD CONSTRAINT FK_232B318CF88470FB FOREIGN KEY (speaky_id) REFERENCES speaky (id)');
$this->addSql('ALTER TABLE game ADD CONSTRAINT FK_232B318C620F77F2 FOREIGN KEY (original_game_id) REFERENCES game (id)');
$this->addSql('ALTER TABLE games_categories ADD CONSTRAINT FK_9AD6626BE48FD905 FOREIGN KEY (game_id) REFERENCES game (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE games_categories ADD CONSTRAINT FK_9AD6626B12469DE2 FOREIGN KEY (category_id) REFERENCES category (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE games_themes ADD CONSTRAINT FK_D76ADD6BE48FD905 FOREIGN KEY (game_id) REFERENCES game (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE games_themes ADD CONSTRAINT FK_D76ADD6B12469DE2 FOREIGN KEY (category_id) REFERENCES category (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE games_classes ADD CONSTRAINT FK_B9241129E48FD905 FOREIGN KEY (game_id) REFERENCES game (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE games_classes ADD CONSTRAINT FK_B924112912469DE2 FOREIGN KEY (category_id) REFERENCES category (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE games_beginner_classes ADD CONSTRAINT FK_8609721EE48FD905 FOREIGN KEY (game_id) REFERENCES game (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE games_beginner_classes ADD CONSTRAINT FK_8609721E12469DE2 FOREIGN KEY (category_id) REFERENCES category (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE games_medium_classes ADD CONSTRAINT FK_44924A11E48FD905 FOREIGN KEY (game_id) REFERENCES game (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE games_medium_classes ADD CONSTRAINT FK_44924A1112469DE2 FOREIGN KEY (category_id) REFERENCES category (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE games_hard_classes ADD CONSTRAINT FK_334B478AE48FD905 FOREIGN KEY (game_id) REFERENCES game (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE games_hard_classes ADD CONSTRAINT FK_334B478A12469DE2 FOREIGN KEY (category_id) REFERENCES category (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE game_comment ADD CONSTRAINT FK_1B62D43A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE game_comment ADD CONSTRAINT FK_1B62D43E48FD905 FOREIGN KEY (game_id) REFERENCES game (id)');
$this->addSql('ALTER TABLE game_comment ADD CONSTRAINT FK_1B62D43727ACA70 FOREIGN KEY (parent_id) REFERENCES game_comment (id)');
$this->addSql('ALTER TABLE game_file ADD CONSTRAINT FK_678A5A3CE48FD905 FOREIGN KEY (game_id) REFERENCES game (id)');
$this->addSql('ALTER TABLE game_play ADD CONSTRAINT FK_B59CB296A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE game_play ADD CONSTRAINT FK_B59CB296E48FD905 FOREIGN KEY (game_id) REFERENCES game (id)');
$this->addSql('ALTER TABLE game_screenshot ADD CONSTRAINT FK_B645D9ACE48FD905 FOREIGN KEY (game_id) REFERENCES game (id)');
$this->addSql('ALTER TABLE game_sound ADD CONSTRAINT FK_CABDBA0BE48FD905 FOREIGN KEY (game_id) REFERENCES game (id)');
$this->addSql('ALTER TABLE game_vote ADD CONSTRAINT FK_B105E948A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE game_vote ADD CONSTRAINT FK_B105E948E48FD905 FOREIGN KEY (game_id) REFERENCES game (id)');
$this->addSql('ALTER TABLE game_word ADD CONSTRAINT FK_28E4193DE357438D FOREIGN KEY (word_id) REFERENCES word (id)');
$this->addSql('ALTER TABLE game_word ADD CONSTRAINT FK_28E4193D6AAA5C3E FOREIGN KEY (sound_id) REFERENCES game_sound (id)');
$this->addSql('ALTER TABLE gift_code ADD CONSTRAINT FK_8568C2C5BBEE08DF FOREIGN KEY (user_gift_payment_id) REFERENCES user_gift_payment (id)');
$this->addSql('ALTER TABLE gift_code ADD CONSTRAINT FK_8568C2C5AE1B80D4 FOREIGN KEY (user_group_payment_id) REFERENCES user_group_payment (id)');
$this->addSql('ALTER TABLE goodies ADD CONSTRAINT FK_1379DF994CE34BEC FOREIGN KEY (part_id) REFERENCES speaky_part (id)');
$this->addSql('ALTER TABLE lexik_trans_unit_translations ADD CONSTRAINT FK_B0AA394493CB796C FOREIGN KEY (file_id) REFERENCES lexik_translation_file (id)');
$this->addSql('ALTER TABLE lexik_trans_unit_translations ADD CONSTRAINT FK_B0AA3944C3C583C9 FOREIGN KEY (trans_unit_id) REFERENCES lexik_trans_unit (id)');
$this->addSql('ALTER TABLE mail_automated_list ADD CONSTRAINT FK_5841BA0ED395B25E FOREIGN KEY (filter_id) REFERENCES user_filter (id)');
$this->addSql('ALTER TABLE mail_trigger ADD CONSTRAINT FK_C0D68E323DAE168B FOREIGN KEY (list_id) REFERENCES mail_automated_list (id)');
$this->addSql('ALTER TABLE mailchimp_template ADD CONSTRAINT FK_47DEDE573DAE168B FOREIGN KEY (list_id) REFERENCES mail_automated_list (id)');
$this->addSql('ALTER TABLE passport_sentence ADD CONSTRAINT FK_572C5BA512469DE2 FOREIGN KEY (category_id) REFERENCES passport_category (id)');
$this->addSql('ALTER TABLE popin ADD CONSTRAINT FK_16710466E48FD905 FOREIGN KEY (game_id) REFERENCES game (id)');
$this->addSql('ALTER TABLE popin ADD CONSTRAINT FK_167104665DFCD4B8 FOREIGN KEY (winner_id) REFERENCES game_play (id)');
$this->addSql('ALTER TABLE popin ADD CONSTRAINT FK_16710466FF961BCC FOREIGN KEY (second_id) REFERENCES game_play (id)');
$this->addSql('ALTER TABLE popin ADD CONSTRAINT FK_1671046674CCD3CA FOREIGN KEY (third_id) REFERENCES game_play (id)');
$this->addSql('ALTER TABLE popin ADD CONSTRAINT FK_1671046698A21AC6 FOREIGN KEY (challenge_id) REFERENCES popin (id)');
$this->addSql('ALTER TABLE popin_user ADD CONSTRAINT FK_D04586975F61A FOREIGN KEY (popin_id) REFERENCES popin (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE popin_user ADD CONSTRAINT FK_D0458A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE popin_targets ADD CONSTRAINT FK_161ECE076975F61A FOREIGN KEY (popin_id) REFERENCES popin (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE popin_targets ADD CONSTRAINT FK_161ECE07A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE promo_code_stat ADD CONSTRAINT FK_3E99F25B27DAFE17 FOREIGN KEY (code_id) REFERENCES promo_code (id)');
$this->addSql('ALTER TABLE reminder_user ADD CONSTRAINT FK_9A6F0A60A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE reset_password_request ADD CONSTRAINT FK_7CE748AA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE speaky_speaky_part ADD CONSTRAINT FK_C45FE729F88470FB FOREIGN KEY (speaky_id) REFERENCES speaky (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE speaky_speaky_part ADD CONSTRAINT FK_C45FE729F4643ECC FOREIGN KEY (speaky_part_id) REFERENCES speaky_part (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE speaky_part CHANGE ranks ranking INT NOT NULL');
$this->addSql('ALTER TABLE speaky_part ADD CONSTRAINT FK_872FD79E7975B7E7 FOREIGN KEY (model_id) REFERENCES speaky_part (id)');
$this->addSql('ALTER TABLE speaky_part ADD CONSTRAINT FK_872FD79EE6A56DF4 FOREIGN KEY (part_event_id) REFERENCES speaky_part_event (id)');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE speaky_part DROP FOREIGN KEY FK_872FD79EE6A56DF4');
$this->addSql('ALTER TABLE game_comment DROP FOREIGN KEY FK_1B62D43A76ED395');
$this->addSql('ALTER TABLE game_play DROP FOREIGN KEY FK_B59CB296A76ED395');
$this->addSql('ALTER TABLE game_vote DROP FOREIGN KEY FK_B105E948A76ED395');
$this->addSql('ALTER TABLE popin_user DROP FOREIGN KEY FK_D0458A76ED395');
$this->addSql('ALTER TABLE popin_targets DROP FOREIGN KEY FK_161ECE07A76ED395');
$this->addSql('ALTER TABLE reminder_user DROP FOREIGN KEY FK_9A6F0A60A76ED395');
$this->addSql('ALTER TABLE reset_password_request DROP FOREIGN KEY FK_7CE748AA76ED395');
$this->addSql('ALTER TABLE mail_automated_list DROP FOREIGN KEY FK_5841BA0ED395B25E');
$this->addSql('ALTER TABLE gift_code DROP FOREIGN KEY FK_8568C2C5BBEE08DF');
$this->addSql('ALTER TABLE gift_code DROP FOREIGN KEY FK_8568C2C5AE1B80D4');
$this->addSql('ALTER TABLE game DROP FOREIGN KEY FK_232B318C45B0BCD');
$this->addSql('ALTER TABLE game_word DROP FOREIGN KEY FK_28E4193DE357438D');
$this->addSql('ALTER TABLE trophie DROP FOREIGN KEY FK_7CDF182DE48FD905');
$this->addSql('ALTER TABLE trophie DROP FOREIGN KEY FK_7CDF182D59027487');
$this->addSql('ALTER TABLE user DROP FOREIGN KEY FK_8D93D6493AC7A293');
$this->addSql('ALTER TABLE user DROP FOREIGN KEY FK_8D93D649FE2541D7');
$this->addSql('ALTER TABLE user DROP FOREIGN KEY FK_8D93D64986383B10');
$this->addSql('ALTER TABLE user_gift_code DROP FOREIGN KEY FK_85884F21A76ED395');
$this->addSql('ALTER TABLE user_gift_code DROP FOREIGN KEY FK_85884F214B80CDB8');
$this->addSql('ALTER TABLE user_activity DROP FOREIGN KEY FK_4CF9ED5AA76ED395');
$this->addSql('ALTER TABLE user_activity DROP FOREIGN KEY FK_4CF9ED5AE48FD905');
$this->addSql('ALTER TABLE user_challenge_reward DROP FOREIGN KEY FK_C079934FA76ED395');
$this->addSql('ALTER TABLE user_challenge_reward DROP FOREIGN KEY FK_C079934F98A21AC6');
$this->addSql('ALTER TABLE user_challenge_reward DROP FOREIGN KEY FK_C079934FBBFA5614');
$this->addSql('ALTER TABLE user_game_config DROP FOREIGN KEY FK_A44B21A76ED395');
$this->addSql('ALTER TABLE user_game_config DROP FOREIGN KEY FK_A44B21E48FD905');
$this->addSql('ALTER TABLE user_gift_payment DROP FOREIGN KEY FK_81BECBA0A76ED395');
$this->addSql('ALTER TABLE user_gift_payment DROP FOREIGN KEY FK_81BECBA03AC7A293');
$this->addSql('ALTER TABLE user_gift_payment DROP FOREIGN KEY FK_81BECBA02FAE4625');
$this->addSql('ALTER TABLE user_gift_payment DROP FOREIGN KEY FK_81BECBA04C3A3BB');
$this->addSql('ALTER TABLE user_group_payment DROP FOREIGN KEY FK_5A67D513AC7A293');
$this->addSql('ALTER TABLE user_login DROP FOREIGN KEY FK_48CA3048A76ED395');
$this->addSql('ALTER TABLE user_overall_progress DROP FOREIGN KEY FK_185FA60EA76ED395');
$this->addSql('ALTER TABLE user_payment DROP FOREIGN KEY FK_35259A07A76ED395');
$this->addSql('ALTER TABLE user_payment DROP FOREIGN KEY FK_35259A073AC7A293');
$this->addSql('ALTER TABLE user_payment DROP FOREIGN KEY FK_35259A072FAE4625');
$this->addSql('ALTER TABLE user_payment DROP FOREIGN KEY FK_35259A076FF8BF36');
$this->addSql('ALTER TABLE user_payment DROP FOREIGN KEY FK_35259A074C3A3BB');
$this->addSql('ALTER TABLE user_sentence DROP FOREIGN KEY FK_7DEBAAD5A76ED395');
$this->addSql('ALTER TABLE user_sentence DROP FOREIGN KEY FK_7DEBAAD527289490');
$this->addSql('ALTER TABLE user_speaky_part DROP FOREIGN KEY FK_2E341E0BA76ED395');
$this->addSql('ALTER TABLE user_speaky_part DROP FOREIGN KEY FK_2E341E0B4CE34BEC');
$this->addSql('ALTER TABLE user_subscribe_activity DROP FOREIGN KEY FK_154FD7AFA76ED395');
$this->addSql('ALTER TABLE user_temp_data DROP FOREIGN KEY FK_41AF1CD3AC7A293');
$this->addSql('ALTER TABLE user_trophy DROP FOREIGN KEY FK_7478E1D4F59AEEEF');
$this->addSql('ALTER TABLE user_trophy DROP FOREIGN KEY FK_7478E1D4A76ED395');
$this->addSql('ALTER TABLE user_weekly_theme DROP FOREIGN KEY FK_318BB21AA76ED395');
$this->addSql('ALTER TABLE user_weekly_theme DROP FOREIGN KEY FK_318BB21AC9B519BA');
$this->addSql('ALTER TABLE user_word_progress DROP FOREIGN KEY FK_E8318EC7A76ED395');
$this->addSql('ALTER TABLE user_word_progress DROP FOREIGN KEY FK_E8318EC7E357438D');
$this->addSql('ALTER TABLE weekly_theme DROP FOREIGN KEY FK_B147CE18F703B5F9');
$this->addSql('ALTER TABLE weekly_theme DROP FOREIGN KEY FK_B147CE18F3CD5968');
$this->addSql('ALTER TABLE weekly_theme DROP FOREIGN KEY FK_B147CE18762880C7');
$this->addSql('ALTER TABLE weekly_theme DROP FOREIGN KEY FK_B147CE1859027487');
$this->addSql('ALTER TABLE weekly_theme DROP FOREIGN KEY FK_B147CE18F59AEEEF');
$this->addSql('ALTER TABLE word DROP FOREIGN KEY FK_C3F17511FDFF2E92');
$this->addSql('ALTER TABLE word DROP FOREIGN KEY FK_C3F175116AAA5C3E');
$this->addSql('ALTER TABLE wrapper_sound DROP FOREIGN KEY FK_B7BACDE66AAA5C3E');
$this->addSql('DROP TABLE speaky_part_event');
$this->addSql('DROP TABLE trophie');
$this->addSql('DROP TABLE url_infos');
$this->addSql('DROP TABLE user');
$this->addSql('DROP TABLE user_gift_code');
$this->addSql('DROP TABLE user_activity');
$this->addSql('DROP TABLE user_challenge_reward');
$this->addSql('DROP TABLE user_filter');
$this->addSql('DROP TABLE user_game_config');
$this->addSql('DROP TABLE user_gift_payment');
$this->addSql('DROP TABLE user_group_payment');
$this->addSql('DROP TABLE user_login');
$this->addSql('DROP TABLE user_overall_progress');
$this->addSql('DROP TABLE user_payment');
$this->addSql('DROP TABLE user_sentence');
$this->addSql('DROP TABLE user_speaky_part');
$this->addSql('DROP TABLE user_subscribe_activity');
$this->addSql('DROP TABLE user_temp_data');
$this->addSql('DROP TABLE user_trophy');
$this->addSql('DROP TABLE user_weekly_theme');
$this->addSql('DROP TABLE user_word_progress');
$this->addSql('DROP TABLE weekly_hero');
$this->addSql('DROP TABLE weekly_theme');
$this->addSql('DROP TABLE word');
$this->addSql('DROP TABLE wrapper_sound');
$this->addSql('DROP TABLE messenger_messages');
$this->addSql('ALTER TABLE game DROP FOREIGN KEY FK_232B318C24DB0683');
$this->addSql('ALTER TABLE game DROP FOREIGN KEY FK_232B318CC6C55574');
$this->addSql('ALTER TABLE game DROP FOREIGN KEY FK_232B318C802065F2');
$this->addSql('ALTER TABLE game DROP FOREIGN KEY FK_232B318C33221A65');
$this->addSql('ALTER TABLE game DROP FOREIGN KEY FK_232B318CF88470FB');
$this->addSql('ALTER TABLE game DROP FOREIGN KEY FK_232B318C620F77F2');
$this->addSql('ALTER TABLE game_comment DROP FOREIGN KEY FK_1B62D43E48FD905');
$this->addSql('ALTER TABLE game_comment DROP FOREIGN KEY FK_1B62D43727ACA70');
$this->addSql('ALTER TABLE game_file DROP FOREIGN KEY FK_678A5A3CE48FD905');
$this->addSql('ALTER TABLE game_play DROP FOREIGN KEY FK_B59CB296E48FD905');
$this->addSql('ALTER TABLE game_screenshot DROP FOREIGN KEY FK_B645D9ACE48FD905');
$this->addSql('ALTER TABLE game_sound DROP FOREIGN KEY FK_CABDBA0BE48FD905');
$this->addSql('ALTER TABLE game_vote DROP FOREIGN KEY FK_B105E948E48FD905');
$this->addSql('ALTER TABLE game_word DROP FOREIGN KEY FK_28E4193D6AAA5C3E');
$this->addSql('ALTER TABLE games_beginner_classes DROP FOREIGN KEY FK_8609721EE48FD905');
$this->addSql('ALTER TABLE games_beginner_classes DROP FOREIGN KEY FK_8609721E12469DE2');
$this->addSql('ALTER TABLE games_categories DROP FOREIGN KEY FK_9AD6626BE48FD905');
$this->addSql('ALTER TABLE games_categories DROP FOREIGN KEY FK_9AD6626B12469DE2');
$this->addSql('ALTER TABLE games_classes DROP FOREIGN KEY FK_B9241129E48FD905');
$this->addSql('ALTER TABLE games_classes DROP FOREIGN KEY FK_B924112912469DE2');
$this->addSql('ALTER TABLE games_hard_classes DROP FOREIGN KEY FK_334B478AE48FD905');
$this->addSql('ALTER TABLE games_hard_classes DROP FOREIGN KEY FK_334B478A12469DE2');
$this->addSql('ALTER TABLE games_medium_classes DROP FOREIGN KEY FK_44924A11E48FD905');
$this->addSql('ALTER TABLE games_medium_classes DROP FOREIGN KEY FK_44924A1112469DE2');
$this->addSql('ALTER TABLE games_themes DROP FOREIGN KEY FK_D76ADD6BE48FD905');
$this->addSql('ALTER TABLE games_themes DROP FOREIGN KEY FK_D76ADD6B12469DE2');
$this->addSql('ALTER TABLE goodies DROP FOREIGN KEY FK_1379DF994CE34BEC');
$this->addSql('ALTER TABLE lexik_trans_unit_translations DROP FOREIGN KEY FK_B0AA394493CB796C');
$this->addSql('ALTER TABLE lexik_trans_unit_translations DROP FOREIGN KEY FK_B0AA3944C3C583C9');
$this->addSql('ALTER TABLE mail_trigger DROP FOREIGN KEY FK_C0D68E323DAE168B');
$this->addSql('ALTER TABLE mailchimp_template DROP FOREIGN KEY FK_47DEDE573DAE168B');
$this->addSql('ALTER TABLE passport_sentence DROP FOREIGN KEY FK_572C5BA512469DE2');
$this->addSql('ALTER TABLE popin DROP FOREIGN KEY FK_16710466E48FD905');
$this->addSql('ALTER TABLE popin DROP FOREIGN KEY FK_167104665DFCD4B8');
$this->addSql('ALTER TABLE popin DROP FOREIGN KEY FK_16710466FF961BCC');
$this->addSql('ALTER TABLE popin DROP FOREIGN KEY FK_1671046674CCD3CA');
$this->addSql('ALTER TABLE popin DROP FOREIGN KEY FK_1671046698A21AC6');
$this->addSql('ALTER TABLE popin_targets DROP FOREIGN KEY FK_161ECE076975F61A');
$this->addSql('ALTER TABLE popin_user DROP FOREIGN KEY FK_D04586975F61A');
$this->addSql('ALTER TABLE promo_code_stat DROP FOREIGN KEY FK_3E99F25B27DAFE17');
$this->addSql('ALTER TABLE speaky_part DROP FOREIGN KEY FK_872FD79E7975B7E7');
$this->addSql('ALTER TABLE speaky_part CHANGE ranking ranks INT NOT NULL');
$this->addSql('ALTER TABLE speaky_speaky_part DROP FOREIGN KEY FK_C45FE729F88470FB');
$this->addSql('ALTER TABLE speaky_speaky_part DROP FOREIGN KEY FK_C45FE729F4643ECC');
}
}