<?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 Version20240117202617 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 brand (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, label VARCHAR(255) NOT NULL, description LONGTEXT DEFAULT NULL, logo VARCHAR(255) DEFAULT NULL, url VARCHAR(255) DEFAULT NULL, INDEX IDX_1C52F958A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE centerinterest (id INT AUTO_INCREMENT NOT NULL, usercreate_id INT NOT NULL, label VARCHAR(255) NOT NULL, defaut TINYINT(1) NOT NULL, INDEX IDX_5DC4C57620537CE3 (usercreate_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE centerinterestdefault (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, centerinterest_id INT NOT NULL, value LONGTEXT DEFAULT NULL, INDEX IDX_831F3ADA76ED395 (user_id), INDEX IDX_831F3AD1CB9F42D (centerinterest_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE color (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, label VARCHAR(255) DEFAULT NULL, value VARCHAR(255) NOT NULL, INDEX IDX_665648E9A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE confidentialite (id INT AUTO_INCREMENT NOT NULL, label VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE community_relationship (id INT AUTO_INCREMENT NOT NULL, sender_id INT NOT NULL, recipient_id INT NOT NULL, confidentiality_id INT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', status VARCHAR(255) NOT NULL, INDEX IDX_7F15FC3FF624B39D (sender_id), INDEX IDX_7F15FC3FE92F8F78 (recipient_id), INDEX IDX_7F15FC3FB0F4D1E (confidentiality_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE confidentialite_confidentialite (confidentialite_source INT NOT NULL, confidentialite_target INT NOT NULL, INDEX IDX_EEB6E2A57F9F51CF (confidentialite_source), INDEX IDX_EEB6E2A5667A0140 (confidentialite_target), PRIMARY KEY(confidentialite_source, confidentialite_target)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE email_verification (id INT AUTO_INCREMENT NOT NULL, author_id INT NOT NULL, email VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', token VARCHAR(255) NOT NULL, INDEX IDX_FE22358F675F31B (author_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE gift (id INT AUTO_INCREMENT NOT NULL, confidentality_id INT NOT NULL, list_id INT DEFAULT NULL, user_id INT NOT NULL, reserved_id INT DEFAULT NULL, public_reservation_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, price DOUBLE PRECISION DEFAULT NULL, website VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, image VARCHAR(255) DEFAULT NULL, is_reserved TINYINT(1) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', can_be_reserved TINYINT(1) DEFAULT NULL, INDEX IDX_A47C990D9870F83F (confidentality_id), INDEX IDX_A47C990D3DAE168B (list_id), INDEX IDX_A47C990DA76ED395 (user_id), INDEX IDX_A47C990D71386FB0 (reserved_id), INDEX IDX_A47C990DD8C93AD7 (public_reservation_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE gift_like (id INT AUTO_INCREMENT NOT NULL, gift_id INT NOT NULL, user_id INT DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_5E1EB2EE97A95A83 (gift_id), INDEX IDX_5E1EB2EEA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE gift_reservation (id INT AUTO_INCREMENT NOT NULL, gift_id INT NOT NULL, user_id INT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', give_gift_date DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_75BD836297A95A83 (gift_id), INDEX IDX_75BD8362A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE gift_to_avoid (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, label VARCHAR(255) NOT NULL, url VARCHAR(255) DEFAULT NULL, image VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, INDEX IDX_DC767A68A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE giftlist (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, required_date DATE DEFAULT NULL, name VARCHAR(255) NOT NULL, description LONGTEXT DEFAULT NULL, slug VARCHAR(255) NOT NULL, image VARCHAR(255) DEFAULT NULL, public_list TINYINT(1) DEFAULT 0 NOT NULL, url VARCHAR(255) DEFAULT NULL, UNIQUE INDEX UNIQ_1651F2B1989D9B62 (slug), INDEX IDX_1651F2B1A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE invitefriend (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, confidentiality_id INT NOT NULL, email VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_D2A31E02A76ED395 (user_id), INDEX IDX_D2A31E02B0F4D1E (confidentiality_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE pleasure (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, label VARCHAR(255) NOT NULL, url VARCHAR(255) DEFAULT NULL, image VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, INDEX IDX_726E8316A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE public_reservation (id INT AUTO_INCREMENT NOT NULL, list_id INT NOT NULL, lastname VARCHAR(255) NOT NULL, firstname VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, token VARCHAR(255) NOT NULL, INDEX IDX_7151C6243DAE168B (list_id), 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 remove_suggestion_friend (id INT AUTO_INCREMENT NOT NULL, author_id INT NOT NULL, user_id INT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_543F3580F675F31B (author_id), INDEX IDX_543F3580A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE sizeguide (id INT AUTO_INCREMENT NOT NULL, label VARCHAR(255) NOT NULL, type VARCHAR(255) DEFAULT NULL, unit_measure VARCHAR(255) DEFAULT NULL, ordre INT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, email VARCHAR(180) NOT NULL, roles LONGTEXT NOT NULL COMMENT \'(DC2Type:json)\', password VARCHAR(255) NOT NULL, is_verified TINYINT(1) NOT NULL, confirmation_token VARCHAR(255) DEFAULT NULL, firstname VARCHAR(255) DEFAULT NULL, lastname VARCHAR(255) DEFAULT NULL, created_at DATETIME NOT NULL, last_login_at DATETIME DEFAULT NULL, updated_at DATETIME NOT NULL, facebook_id VARCHAR(255) DEFAULT NULL, google_id VARCHAR(255) DEFAULT NULL, countconnexion INT NOT NULL, avatar VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, birthday DATE DEFAULT NULL, username VARCHAR(255) NOT NULL, address LONGTEXT DEFAULT NULL, background_profile VARCHAR(255) DEFAULT NULL, apple_id VARCHAR(255) DEFAULT NULL, delete_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', UNIQUE INDEX UNIQ_8D93D649E7927C74 (email), UNIQUE INDEX UNIQ_8D93D649F85E0677 (username), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_centerinterest (user_id INT NOT NULL, centerinterest_id INT NOT NULL, INDEX IDX_36411A2FA76ED395 (user_id), INDEX IDX_36411A2F1CB9F42D (centerinterest_id), PRIMARY KEY(user_id, centerinterest_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_informations (id INT AUTO_INCREMENT NOT NULL, confidentialite_id INT NOT NULL, user_id INT NOT NULL, sizeguide_id INT NOT NULL, value VARCHAR(255) DEFAULT NULL, INDEX IDX_EF5A188B11C0A539 (confidentialite_id), INDEX IDX_EF5A188BA76ED395 (user_id), INDEX IDX_EF5A188B46C82E4E (sizeguide_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE visite_guidee (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, profile TINYINT(1) NOT NULL, list TINYINT(1) NOT NULL, wall_activity TINYINT(1) NOT NULL, gift TINYINT(1) NOT NULL, profile_friend TINYINT(1) NOT NULL, UNIQUE INDEX UNIQ_2148C4FA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE website (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, label VARCHAR(255) NOT NULL, description LONGTEXT DEFAULT NULL, logo VARCHAR(255) DEFAULT NULL, url VARCHAR(255) DEFAULT NULL, INDEX IDX_476F5DE7A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('ALTER TABLE brand ADD CONSTRAINT FK_1C52F958A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE centerinterest ADD CONSTRAINT FK_5DC4C57620537CE3 FOREIGN KEY (usercreate_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE centerinterestdefault ADD CONSTRAINT FK_831F3ADA76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE centerinterestdefault ADD CONSTRAINT FK_831F3AD1CB9F42D FOREIGN KEY (centerinterest_id) REFERENCES centerinterest (id)');
$this->addSql('ALTER TABLE color ADD CONSTRAINT FK_665648E9A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE community_relationship ADD CONSTRAINT FK_7F15FC3FF624B39D FOREIGN KEY (sender_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE community_relationship ADD CONSTRAINT FK_7F15FC3FE92F8F78 FOREIGN KEY (recipient_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE community_relationship ADD CONSTRAINT FK_7F15FC3FB0F4D1E FOREIGN KEY (confidentiality_id) REFERENCES confidentialite (id)');
$this->addSql('ALTER TABLE confidentialite_confidentialite ADD CONSTRAINT FK_EEB6E2A57F9F51CF FOREIGN KEY (confidentialite_source) REFERENCES confidentialite (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE confidentialite_confidentialite ADD CONSTRAINT FK_EEB6E2A5667A0140 FOREIGN KEY (confidentialite_target) REFERENCES confidentialite (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE email_verification ADD CONSTRAINT FK_FE22358F675F31B FOREIGN KEY (author_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE gift ADD CONSTRAINT FK_A47C990D9870F83F FOREIGN KEY (confidentality_id) REFERENCES confidentialite (id)');
$this->addSql('ALTER TABLE gift ADD CONSTRAINT FK_A47C990D3DAE168B FOREIGN KEY (list_id) REFERENCES giftlist (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE gift ADD CONSTRAINT FK_A47C990DA76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE gift ADD CONSTRAINT FK_A47C990D71386FB0 FOREIGN KEY (reserved_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE gift ADD CONSTRAINT FK_A47C990DD8C93AD7 FOREIGN KEY (public_reservation_id) REFERENCES public_reservation (id)');
$this->addSql('ALTER TABLE gift_like ADD CONSTRAINT FK_5E1EB2EE97A95A83 FOREIGN KEY (gift_id) REFERENCES gift (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE gift_like ADD CONSTRAINT FK_5E1EB2EEA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE gift_reservation ADD CONSTRAINT FK_75BD836297A95A83 FOREIGN KEY (gift_id) REFERENCES gift (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE gift_reservation ADD CONSTRAINT FK_75BD8362A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE gift_to_avoid ADD CONSTRAINT FK_DC767A68A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE giftlist ADD CONSTRAINT FK_1651F2B1A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE invitefriend ADD CONSTRAINT FK_D2A31E02A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE invitefriend ADD CONSTRAINT FK_D2A31E02B0F4D1E FOREIGN KEY (confidentiality_id) REFERENCES confidentialite (id)');
$this->addSql('ALTER TABLE pleasure ADD CONSTRAINT FK_726E8316A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE public_reservation ADD CONSTRAINT FK_7151C6243DAE168B FOREIGN KEY (list_id) REFERENCES giftlist (id)');
$this->addSql('ALTER TABLE remove_suggestion_friend ADD CONSTRAINT FK_543F3580F675F31B FOREIGN KEY (author_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE remove_suggestion_friend ADD CONSTRAINT FK_543F3580A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE user_centerinterest ADD CONSTRAINT FK_36411A2FA76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE user_centerinterest ADD CONSTRAINT FK_36411A2F1CB9F42D FOREIGN KEY (centerinterest_id) REFERENCES centerinterest (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE user_informations ADD CONSTRAINT FK_EF5A188B11C0A539 FOREIGN KEY (confidentialite_id) REFERENCES confidentialite (id)');
$this->addSql('ALTER TABLE user_informations ADD CONSTRAINT FK_EF5A188BA76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE user_informations ADD CONSTRAINT FK_EF5A188B46C82E4E FOREIGN KEY (sizeguide_id) REFERENCES sizeguide (id)');
$this->addSql('ALTER TABLE visite_guidee ADD CONSTRAINT FK_2148C4FA76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE website ADD CONSTRAINT FK_476F5DE7A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE brand DROP FOREIGN KEY FK_1C52F958A76ED395');
$this->addSql('ALTER TABLE centerinterest DROP FOREIGN KEY FK_5DC4C57620537CE3');
$this->addSql('ALTER TABLE centerinterestdefault DROP FOREIGN KEY FK_831F3ADA76ED395');
$this->addSql('ALTER TABLE centerinterestdefault DROP FOREIGN KEY FK_831F3AD1CB9F42D');
$this->addSql('ALTER TABLE color DROP FOREIGN KEY FK_665648E9A76ED395');
$this->addSql('ALTER TABLE community_relationship DROP FOREIGN KEY FK_7F15FC3FF624B39D');
$this->addSql('ALTER TABLE community_relationship DROP FOREIGN KEY FK_7F15FC3FE92F8F78');
$this->addSql('ALTER TABLE community_relationship DROP FOREIGN KEY FK_7F15FC3FB0F4D1E');
$this->addSql('ALTER TABLE confidentialite_confidentialite DROP FOREIGN KEY FK_EEB6E2A57F9F51CF');
$this->addSql('ALTER TABLE confidentialite_confidentialite DROP FOREIGN KEY FK_EEB6E2A5667A0140');
$this->addSql('ALTER TABLE email_verification DROP FOREIGN KEY FK_FE22358F675F31B');
$this->addSql('ALTER TABLE gift DROP FOREIGN KEY FK_A47C990D9870F83F');
$this->addSql('ALTER TABLE gift DROP FOREIGN KEY FK_A47C990D3DAE168B');
$this->addSql('ALTER TABLE gift DROP FOREIGN KEY FK_A47C990DA76ED395');
$this->addSql('ALTER TABLE gift DROP FOREIGN KEY FK_A47C990D71386FB0');
$this->addSql('ALTER TABLE gift DROP FOREIGN KEY FK_A47C990DD8C93AD7');
$this->addSql('ALTER TABLE gift_like DROP FOREIGN KEY FK_5E1EB2EE97A95A83');
$this->addSql('ALTER TABLE gift_like DROP FOREIGN KEY FK_5E1EB2EEA76ED395');
$this->addSql('ALTER TABLE gift_reservation DROP FOREIGN KEY FK_75BD836297A95A83');
$this->addSql('ALTER TABLE gift_reservation DROP FOREIGN KEY FK_75BD8362A76ED395');
$this->addSql('ALTER TABLE gift_to_avoid DROP FOREIGN KEY FK_DC767A68A76ED395');
$this->addSql('ALTER TABLE giftlist DROP FOREIGN KEY FK_1651F2B1A76ED395');
$this->addSql('ALTER TABLE invitefriend DROP FOREIGN KEY FK_D2A31E02A76ED395');
$this->addSql('ALTER TABLE invitefriend DROP FOREIGN KEY FK_D2A31E02B0F4D1E');
$this->addSql('ALTER TABLE pleasure DROP FOREIGN KEY FK_726E8316A76ED395');
$this->addSql('ALTER TABLE public_reservation DROP FOREIGN KEY FK_7151C6243DAE168B');
$this->addSql('ALTER TABLE remove_suggestion_friend DROP FOREIGN KEY FK_543F3580F675F31B');
$this->addSql('ALTER TABLE remove_suggestion_friend DROP FOREIGN KEY FK_543F3580A76ED395');
$this->addSql('ALTER TABLE user_centerinterest DROP FOREIGN KEY FK_36411A2FA76ED395');
$this->addSql('ALTER TABLE user_centerinterest DROP FOREIGN KEY FK_36411A2F1CB9F42D');
$this->addSql('ALTER TABLE user_informations DROP FOREIGN KEY FK_EF5A188B11C0A539');
$this->addSql('ALTER TABLE user_informations DROP FOREIGN KEY FK_EF5A188BA76ED395');
$this->addSql('ALTER TABLE user_informations DROP FOREIGN KEY FK_EF5A188B46C82E4E');
$this->addSql('ALTER TABLE visite_guidee DROP FOREIGN KEY FK_2148C4FA76ED395');
$this->addSql('ALTER TABLE website DROP FOREIGN KEY FK_476F5DE7A76ED395');
$this->addSql('DROP TABLE brand');
$this->addSql('DROP TABLE centerinterest');
$this->addSql('DROP TABLE centerinterestdefault');
$this->addSql('DROP TABLE color');
$this->addSql('DROP TABLE community_relationship');
$this->addSql('DROP TABLE confidentialite');
$this->addSql('DROP TABLE confidentialite_confidentialite');
$this->addSql('DROP TABLE email_verification');
$this->addSql('DROP TABLE gift');
$this->addSql('DROP TABLE gift_like');
$this->addSql('DROP TABLE gift_reservation');
$this->addSql('DROP TABLE gift_to_avoid');
$this->addSql('DROP TABLE giftlist');
$this->addSql('DROP TABLE invitefriend');
$this->addSql('DROP TABLE pleasure');
$this->addSql('DROP TABLE public_reservation');
$this->addSql('DROP TABLE refresh_tokens');
$this->addSql('DROP TABLE remove_suggestion_friend');
$this->addSql('DROP TABLE sizeguide');
$this->addSql('DROP TABLE user');
$this->addSql('DROP TABLE user_centerinterest');
$this->addSql('DROP TABLE user_informations');
$this->addSql('DROP TABLE visite_guidee');
$this->addSql('DROP TABLE website');
}
}