<?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 Version20221103155036 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 address (id INT AUTO_INCREMENT NOT NULL, street VARCHAR(255) NOT NULL, complement VARCHAR(255) DEFAULT NULL, zip_code VARCHAR(255) NOT NULL, city VARCHAR(255) NOT NULL, country VARCHAR(255) NOT NULL, latitude NUMERIC(10, 8) DEFAULT NULL, longitude NUMERIC(10, 8) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', deleted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE administrator (id INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE collection (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', deleted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE color (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, reference VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', deleted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE company (id INT AUTO_INCREMENT NOT NULL, type VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, short_description VARCHAR(255) NOT NULL, long_description LONGTEXT NOT NULL, phone VARCHAR(255) DEFAULT NULL, email VARCHAR(255) DEFAULT NULL, website VARCHAR(255) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', deleted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE customer (id INT NOT NULL, shop_id INT NOT NULL, INDEX IDX_81398E094D16C4DD (shop_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE emotion (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', deleted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE employee (id INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE employee_shop (id INT AUTO_INCREMENT NOT NULL, employee_id INT NOT NULL, shop_id INT NOT NULL, main TINYINT(1) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', deleted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_19B306E58C03F15C (employee_id), INDEX IDX_19B306E54D16C4DD (shop_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE frame (id INT AUTO_INCREMENT NOT NULL, shape_id INT NOT NULL, designer_id INT DEFAULT NULL, supplier_id INT DEFAULT NULL, material_id INT NOT NULL, color_id INT NOT NULL, emotion_id INT NOT NULL, collection_id INT NOT NULL, name VARCHAR(255) NOT NULL, size INT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', deleted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_B5F83CCD50266CBB (shape_id), INDEX IDX_B5F83CCDCFC54FAB (designer_id), INDEX IDX_B5F83CCD2ADD6D8C (supplier_id), INDEX IDX_B5F83CCDE308AC6F (material_id), INDEX IDX_B5F83CCD7ADA1FB5 (color_id), INDEX IDX_B5F83CCD1EE4A582 (emotion_id), INDEX IDX_B5F83CCD514956FD (collection_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE image (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) DEFAULT NULL, original_name VARCHAR(255) NOT NULL, size INT NOT NULL, mime_type VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', deleted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE keyword (id INT AUTO_INCREMENT NOT NULL, emotion_id INT DEFAULT NULL, collection_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', deleted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_5A93713B1EE4A582 (emotion_id), INDEX IDX_5A93713B514956FD (collection_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE material (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', deleted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE notification (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(255) NOT NULL, description LONGTEXT DEFAULT NULL, content LONGTEXT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', deleted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE position (id INT AUTO_INCREMENT NOT NULL, tray_id INT NOT NULL, frame_id INT NOT NULL, next_frame_id INT DEFAULT NULL, locked TINYINT(1) NOT NULL, stock INT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', deleted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_462CE4F5E8C42A45 (tray_id), INDEX IDX_462CE4F53FA3C347 (frame_id), INDEX IDX_462CE4F57B98FA9 (next_frame_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE reset_password_request (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, selector VARCHAR(20) NOT NULL, hashed_token VARCHAR(100) NOT NULL, requested_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', expires_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', deleted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_7CE748AA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE shape (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', deleted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE shop (id INT AUTO_INCREMENT NOT NULL, address_id INT NOT NULL, name VARCHAR(255) NOT NULL, phone VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, siret VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', deleted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', UNIQUE INDEX UNIQ_AC6A4CA2F5B7AF75 (address_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE tray (id INT AUTO_INCREMENT NOT NULL, master_id INT DEFAULT NULL, shop_id INT NOT NULL, shape_id INT NOT NULL, name VARCHAR(255) NOT NULL, is_master TINYINT(1) NOT NULL, size INT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', deleted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_C753C79713B3DB11 (master_id), INDEX IDX_C753C7974D16C4DD (shop_id), INDEX IDX_C753C79750266CBB (shape_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE tray_collection (tray_id INT NOT NULL, collection_id INT NOT NULL, INDEX IDX_CEF557D8E8C42A45 (tray_id), INDEX IDX_CEF557D8514956FD (collection_id), PRIMARY KEY(tray_id, collection_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE tray_emotion (tray_id INT NOT NULL, emotion_id INT NOT NULL, INDEX IDX_89460F75E8C42A45 (tray_id), INDEX IDX_89460F751EE4A582 (emotion_id), PRIMARY KEY(tray_id, emotion_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE `user` (id INT AUTO_INCREMENT NOT NULL, avatar_id INT DEFAULT NULL, civility VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, last_name VARCHAR(255) NOT NULL, first_name VARCHAR(255) NOT NULL, roles LONGTEXT NOT NULL COMMENT \'(DC2Type:json)\', password VARCHAR(255) NOT NULL, last_logged_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', email_validated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', reset_password_token VARCHAR(255) DEFAULT NULL, reset_password_token_created_at DATETIME DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', deleted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', type VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_8D93D649E7927C74 (email), UNIQUE INDEX UNIQ_8D93D64986383B10 (avatar_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 administrator ADD CONSTRAINT FK_58DF0651BF396750 FOREIGN KEY (id) REFERENCES `user` (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE customer ADD CONSTRAINT FK_81398E094D16C4DD FOREIGN KEY (shop_id) REFERENCES shop (id)');
$this->addSql('ALTER TABLE customer ADD CONSTRAINT FK_81398E09BF396750 FOREIGN KEY (id) REFERENCES `user` (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE employee ADD CONSTRAINT FK_5D9F75A1BF396750 FOREIGN KEY (id) REFERENCES `user` (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE employee_shop ADD CONSTRAINT FK_19B306E58C03F15C FOREIGN KEY (employee_id) REFERENCES employee (id)');
$this->addSql('ALTER TABLE employee_shop ADD CONSTRAINT FK_19B306E54D16C4DD FOREIGN KEY (shop_id) REFERENCES shop (id)');
$this->addSql('ALTER TABLE frame ADD CONSTRAINT FK_B5F83CCD50266CBB FOREIGN KEY (shape_id) REFERENCES shape (id)');
$this->addSql('ALTER TABLE frame ADD CONSTRAINT FK_B5F83CCDCFC54FAB FOREIGN KEY (designer_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE frame ADD CONSTRAINT FK_B5F83CCD2ADD6D8C FOREIGN KEY (supplier_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE frame ADD CONSTRAINT FK_B5F83CCDE308AC6F FOREIGN KEY (material_id) REFERENCES material (id)');
$this->addSql('ALTER TABLE frame ADD CONSTRAINT FK_B5F83CCD7ADA1FB5 FOREIGN KEY (color_id) REFERENCES color (id)');
$this->addSql('ALTER TABLE frame ADD CONSTRAINT FK_B5F83CCD1EE4A582 FOREIGN KEY (emotion_id) REFERENCES emotion (id)');
$this->addSql('ALTER TABLE frame ADD CONSTRAINT FK_B5F83CCD514956FD FOREIGN KEY (collection_id) REFERENCES collection (id)');
$this->addSql('ALTER TABLE keyword ADD CONSTRAINT FK_5A93713B1EE4A582 FOREIGN KEY (emotion_id) REFERENCES emotion (id)');
$this->addSql('ALTER TABLE keyword ADD CONSTRAINT FK_5A93713B514956FD FOREIGN KEY (collection_id) REFERENCES collection (id)');
$this->addSql('ALTER TABLE position ADD CONSTRAINT FK_462CE4F5E8C42A45 FOREIGN KEY (tray_id) REFERENCES tray (id)');
$this->addSql('ALTER TABLE position ADD CONSTRAINT FK_462CE4F53FA3C347 FOREIGN KEY (frame_id) REFERENCES frame (id)');
$this->addSql('ALTER TABLE position ADD CONSTRAINT FK_462CE4F57B98FA9 FOREIGN KEY (next_frame_id) REFERENCES frame (id)');
$this->addSql('ALTER TABLE reset_password_request ADD CONSTRAINT FK_7CE748AA76ED395 FOREIGN KEY (user_id) REFERENCES `user` (id)');
$this->addSql('ALTER TABLE shop ADD CONSTRAINT FK_AC6A4CA2F5B7AF75 FOREIGN KEY (address_id) REFERENCES address (id)');
$this->addSql('ALTER TABLE tray ADD CONSTRAINT FK_C753C79713B3DB11 FOREIGN KEY (master_id) REFERENCES tray (id)');
$this->addSql('ALTER TABLE tray ADD CONSTRAINT FK_C753C7974D16C4DD FOREIGN KEY (shop_id) REFERENCES shop (id)');
$this->addSql('ALTER TABLE tray ADD CONSTRAINT FK_C753C79750266CBB FOREIGN KEY (shape_id) REFERENCES shape (id)');
$this->addSql('ALTER TABLE tray_collection ADD CONSTRAINT FK_CEF557D8E8C42A45 FOREIGN KEY (tray_id) REFERENCES tray (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE tray_collection ADD CONSTRAINT FK_CEF557D8514956FD FOREIGN KEY (collection_id) REFERENCES collection (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE tray_emotion ADD CONSTRAINT FK_89460F75E8C42A45 FOREIGN KEY (tray_id) REFERENCES tray (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE tray_emotion ADD CONSTRAINT FK_89460F751EE4A582 FOREIGN KEY (emotion_id) REFERENCES emotion (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE `user` ADD CONSTRAINT FK_8D93D64986383B10 FOREIGN KEY (avatar_id) REFERENCES image (id)');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE shop DROP FOREIGN KEY FK_AC6A4CA2F5B7AF75');
$this->addSql('ALTER TABLE frame DROP FOREIGN KEY FK_B5F83CCD514956FD');
$this->addSql('ALTER TABLE keyword DROP FOREIGN KEY FK_5A93713B514956FD');
$this->addSql('ALTER TABLE tray_collection DROP FOREIGN KEY FK_CEF557D8514956FD');
$this->addSql('ALTER TABLE frame DROP FOREIGN KEY FK_B5F83CCD7ADA1FB5');
$this->addSql('ALTER TABLE frame DROP FOREIGN KEY FK_B5F83CCDCFC54FAB');
$this->addSql('ALTER TABLE frame DROP FOREIGN KEY FK_B5F83CCD2ADD6D8C');
$this->addSql('ALTER TABLE frame DROP FOREIGN KEY FK_B5F83CCD1EE4A582');
$this->addSql('ALTER TABLE keyword DROP FOREIGN KEY FK_5A93713B1EE4A582');
$this->addSql('ALTER TABLE tray_emotion DROP FOREIGN KEY FK_89460F751EE4A582');
$this->addSql('ALTER TABLE employee_shop DROP FOREIGN KEY FK_19B306E58C03F15C');
$this->addSql('ALTER TABLE position DROP FOREIGN KEY FK_462CE4F53FA3C347');
$this->addSql('ALTER TABLE position DROP FOREIGN KEY FK_462CE4F57B98FA9');
$this->addSql('ALTER TABLE `user` DROP FOREIGN KEY FK_8D93D64986383B10');
$this->addSql('ALTER TABLE frame DROP FOREIGN KEY FK_B5F83CCDE308AC6F');
$this->addSql('ALTER TABLE frame DROP FOREIGN KEY FK_B5F83CCD50266CBB');
$this->addSql('ALTER TABLE tray DROP FOREIGN KEY FK_C753C79750266CBB');
$this->addSql('ALTER TABLE customer DROP FOREIGN KEY FK_81398E094D16C4DD');
$this->addSql('ALTER TABLE employee_shop DROP FOREIGN KEY FK_19B306E54D16C4DD');
$this->addSql('ALTER TABLE tray DROP FOREIGN KEY FK_C753C7974D16C4DD');
$this->addSql('ALTER TABLE position DROP FOREIGN KEY FK_462CE4F5E8C42A45');
$this->addSql('ALTER TABLE tray DROP FOREIGN KEY FK_C753C79713B3DB11');
$this->addSql('ALTER TABLE tray_collection DROP FOREIGN KEY FK_CEF557D8E8C42A45');
$this->addSql('ALTER TABLE tray_emotion DROP FOREIGN KEY FK_89460F75E8C42A45');
$this->addSql('ALTER TABLE administrator DROP FOREIGN KEY FK_58DF0651BF396750');
$this->addSql('ALTER TABLE customer DROP FOREIGN KEY FK_81398E09BF396750');
$this->addSql('ALTER TABLE employee DROP FOREIGN KEY FK_5D9F75A1BF396750');
$this->addSql('ALTER TABLE reset_password_request DROP FOREIGN KEY FK_7CE748AA76ED395');
$this->addSql('DROP TABLE address');
$this->addSql('DROP TABLE administrator');
$this->addSql('DROP TABLE collection');
$this->addSql('DROP TABLE color');
$this->addSql('DROP TABLE company');
$this->addSql('DROP TABLE customer');
$this->addSql('DROP TABLE emotion');
$this->addSql('DROP TABLE employee');
$this->addSql('DROP TABLE employee_shop');
$this->addSql('DROP TABLE frame');
$this->addSql('DROP TABLE image');
$this->addSql('DROP TABLE keyword');
$this->addSql('DROP TABLE material');
$this->addSql('DROP TABLE notification');
$this->addSql('DROP TABLE position');
$this->addSql('DROP TABLE reset_password_request');
$this->addSql('DROP TABLE shape');
$this->addSql('DROP TABLE shop');
$this->addSql('DROP TABLE tray');
$this->addSql('DROP TABLE tray_collection');
$this->addSql('DROP TABLE tray_emotion');
$this->addSql('DROP TABLE `user`');
$this->addSql('DROP TABLE messenger_messages');
}
}