<?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 Version20250207134306 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 ecos_actor (id INT AUTO_INCREMENT NOT NULL, vignette_id INT NOT NULL, profile_id INT NOT NULL, instructions LONGTEXT DEFAULT NULL, UNIQUE INDEX UNIQ_1A6E79447D16298B (vignette_id), INDEX IDX_1A6E7944CCFA12B8 (profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE ecos_actor_profile (ecos_actor_id INT NOT NULL, profile_id INT NOT NULL, INDEX IDX_3996F39445256ED6 (ecos_actor_id), INDEX IDX_3996F394CCFA12B8 (profile_id), PRIMARY KEY(ecos_actor_id, profile_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE ecos_evaluation (id INT AUTO_INCREMENT NOT NULL, evaluation_grid_id INT NOT NULL, student_number VARCHAR(100) NOT NULL, created_at DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', INDEX IDX_376EEAF3FE2701F (evaluation_grid_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE ecos_evaluation_grade (id INT AUTO_INCREMENT NOT NULL, evaluation_grid_id INT NOT NULL, name VARCHAR(100) NOT NULL, points SMALLINT NOT NULL, INDEX IDX_D8DD8544FE2701F (evaluation_grid_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE ecos_evaluation_grid (id INT AUTO_INCREMENT NOT NULL, vignette_id INT NOT NULL, profile_id INT NOT NULL, created_at DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', UNIQUE INDEX UNIQ_171D64E37D16298B (vignette_id), INDEX IDX_171D64E3CCFA12B8 (profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE ecos_evaluation_grid_profile (ecos_evaluation_grid_id INT NOT NULL, profile_id INT NOT NULL, INDEX IDX_EA315BD1AF7269A4 (ecos_evaluation_grid_id), INDEX IDX_EA315BD1CCFA12B8 (profile_id), PRIMARY KEY(ecos_evaluation_grid_id, profile_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE ecos_evaluation_score (id INT AUTO_INCREMENT NOT NULL, evaluation_id INT NOT NULL, evaluation_grade_id INT NOT NULL, points SMALLINT NOT NULL, INDEX IDX_B31E1C21456C5646 (evaluation_id), INDEX IDX_B31E1C21F357D88E (evaluation_grade_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE ecos_media (id INT AUTO_INCREMENT NOT NULL, vignette_id INT NOT NULL, profile_id INT NOT NULL, UNIQUE INDEX UNIQ_34378EB17D16298B (vignette_id), INDEX IDX_34378EB1CCFA12B8 (profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE ecos_media_profile (ecos_media_id INT NOT NULL, profile_id INT NOT NULL, INDEX IDX_7AB425B7BF6041E9 (ecos_media_id), INDEX IDX_7AB425B7CCFA12B8 (profile_id), PRIMARY KEY(ecos_media_id, profile_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE ecos_vignette (id INT AUTO_INCREMENT NOT NULL, profile_id INT NOT NULL, program VARCHAR(100) NOT NULL, title VARCHAR(100) NOT NULL, theme VARCHAR(100) NOT NULL, author VARCHAR(100) DEFAULT NULL, context LONGTEXT DEFAULT NULL, to_do LONGTEXT DEFAULT NULL, to_avoid LONGTEXT DEFAULT NULL, INDEX IDX_5EB4CA82CCFA12B8 (profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE ecos_vignette_profile (ecos_vignette_id INT NOT NULL, profile_id INT NOT NULL, INDEX IDX_8A1429D979E942D1 (ecos_vignette_id), INDEX IDX_8A1429D9CCFA12B8 (profile_id), PRIMARY KEY(ecos_vignette_id, profile_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE evaluation (id INT AUTO_INCREMENT NOT NULL, evaluation_grid_id INT NOT NULL, student_number VARCHAR(100) NOT NULL, created_at DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', INDEX IDX_1323A575FE2701F (evaluation_grid_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE evaluation_grade (id INT AUTO_INCREMENT NOT NULL, evaluation_grid_id INT NOT NULL, name VARCHAR(100) NOT NULL, points SMALLINT NOT NULL, INDEX IDX_9CADD3C5FE2701F (evaluation_grid_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE evaluation_grid (id INT AUTO_INCREMENT NOT NULL, evaluation_sheet_id INT DEFAULT NULL, profile_id INT DEFAULT NULL, program_sheet_id INT DEFAULT NULL, name VARCHAR(255) DEFAULT NULL, created_at DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', UNIQUE INDEX UNIQ_6366968F865C7F83 (evaluation_sheet_id), INDEX IDX_6366968FCCFA12B8 (profile_id), INDEX IDX_6366968FA27FA90 (program_sheet_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE evaluation_score (id INT AUTO_INCREMENT NOT NULL, evaluation_id INT NOT NULL, evaluation_grade_id INT NOT NULL, points SMALLINT NOT NULL, INDEX IDX_F76E4AA0456C5646 (evaluation_id), INDEX IDX_F76E4AA0F357D88E (evaluation_grade_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE evaluation_sheet (id INT AUTO_INCREMENT NOT NULL, profile_id INT DEFAULT NULL, program_sheet_id INT DEFAULT NULL, program VARCHAR(100) NOT NULL, title VARCHAR(100) NOT NULL, theme VARCHAR(100) NOT NULL, author VARCHAR(100) DEFAULT NULL, context LONGTEXT DEFAULT NULL, to_do LONGTEXT DEFAULT NULL, to_avoid LONGTEXT DEFAULT NULL, instructions LONGTEXT DEFAULT NULL, INDEX IDX_42CBEC13CCFA12B8 (profile_id), INDEX IDX_42CBEC13A27FA90 (program_sheet_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE event (id INT AUTO_INCREMENT NOT NULL, profile_id INT DEFAULT NULL, title VARCHAR(255) NOT NULL, start_at DATETIME NOT NULL COMMENT \'(DC2Type:datetimetz_immutable)\', end_at DATETIME NOT NULL COMMENT \'(DC2Type:datetimetz_immutable)\', color VARCHAR(10) NOT NULL, email VARCHAR(255) DEFAULT NULL, rooms JSON DEFAULT NULL COMMENT \'(DC2Type:json)\', INDEX IDX_3BAE0AA7CCFA12B8 (profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE file (id INT AUTO_INCREMENT NOT NULL, owner_id INT DEFAULT NULL, evaluation_sheet_id INT DEFAULT NULL, ecos_media_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, size INT NOT NULL, mime_type VARCHAR(100) NOT NULL, original_name VARCHAR(255) NOT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_8C9F36107E3C61F9 (owner_id), INDEX IDX_8C9F3610865C7F83 (evaluation_sheet_id), INDEX IDX_8C9F3610BF6041E9 (ecos_media_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE inventory_category (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE inventory_location (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE inventory_order (id INT AUTO_INCREMENT NOT NULL, product_id INT NOT NULL, status VARCHAR(30) NOT NULL, amount INT NOT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_29B538984584665A (product_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE inventory_product (id INT AUTO_INCREMENT NOT NULL, provider_id INT DEFAULT NULL, category_id INT DEFAULT NULL, location_id INT DEFAULT NULL, reference VARCHAR(255) DEFAULT NULL, internal_reference VARCHAR(255) DEFAULT NULL, description VARCHAR(255) DEFAULT NULL, price DOUBLE PRECISION DEFAULT NULL, stock INT NOT NULL, order_threshold INT NOT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_924EA251A53A8AA (provider_id), INDEX IDX_924EA25112469DE2 (category_id), INDEX IDX_924EA25164D218E (location_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE inventory_provider (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE profile (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, last_name VARCHAR(100) NOT NULL, first_name VARCHAR(100) NOT NULL, birth_date DATE DEFAULT NULL, discipline VARCHAR(255) DEFAULT NULL, `function` VARCHAR(255) DEFAULT NULL, skill VARCHAR(255) DEFAULT NULL, diplomas JSON NOT NULL COMMENT \'(DC2Type:json)\', speciality VARCHAR(255) DEFAULT NULL, UNIQUE INDEX UNIQ_8157AA0FA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE program_sheet (id INT AUTO_INCREMENT NOT NULL, profile_id INT DEFAULT NULL, title VARCHAR(100) NOT NULL, theme VARCHAR(100) NOT NULL, keywords VARCHAR(255) NOT NULL, type JSON NOT NULL COMMENT \'(DC2Type:json)\', day_sessions VARCHAR(10) NOT NULL, edsessions VARCHAR(10) NOT NULL, half_day_sessions VARCHAR(10) NOT NULL, target VARCHAR(255) NOT NULL, students_per_session VARCHAR(10) NOT NULL, approach_type JSON NOT NULL COMMENT \'(DC2Type:json)\', standard_patient VARCHAR(50) NOT NULL, general_goals LONGTEXT NOT NULL, technical_educational_goals LONGTEXT NOT NULL, non_technical_educational_goals LONGTEXT NOT NULL, project_owners LONGTEXT NOT NULL, instructors LONGTEXT NOT NULL, evaluation_modalities JSON NOT NULL COMMENT \'(DC2Type:json)\', evaluation_modalities_other VARCHAR(100) DEFAULT NULL, files LONGTEXT DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_1955E214CCFA12B8 (profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE program_sheet_profile (program_sheet_id INT NOT NULL, profile_id INT NOT NULL, INDEX IDX_A862AF2AA27FA90 (program_sheet_id), INDEX IDX_A862AF2ACCFA12B8 (profile_id), PRIMARY KEY(program_sheet_id, profile_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE program_sheet_scenario_sheet (program_sheet_id INT NOT NULL, scenario_sheet_id INT NOT NULL, INDEX IDX_D1807079A27FA90 (program_sheet_id), INDEX IDX_D18070798B0DC065 (scenario_sheet_id), PRIMARY KEY(program_sheet_id, scenario_sheet_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE scenario_sheet (id INT AUTO_INCREMENT NOT NULL, profile_id INT DEFAULT NULL, title VARCHAR(100) NOT NULL, speciality VARCHAR(100) NOT NULL, theme VARCHAR(100) DEFAULT NULL, validated_at DATE NOT NULL, general_goals LONGTEXT NOT NULL, technical_goals LONGTEXT NOT NULL, non_technical_goals LONGTEXT NOT NULL, pedagogical_technique VARCHAR(100) DEFAULT NULL, hybrid_simulation VARCHAR(100) DEFAULT NULL, high_technicality_simulation VARCHAR(100) DEFAULT NULL, target VARCHAR(100) NOT NULL, course_type VARCHAR(100) NOT NULL, briefing_message LONGTEXT NOT NULL, scenario_evolution LONGTEXT NOT NULL, scenography_and_equipment LONGTEXT NOT NULL, debriefing_goals LONGTEXT NOT NULL, INDEX IDX_A83320B3CCFA12B8 (profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE scenario_sheet_profile (scenario_sheet_id INT NOT NULL, profile_id INT NOT NULL, INDEX IDX_A06202FE8B0DC065 (scenario_sheet_id), INDEX IDX_A06202FECCFA12B8 (profile_id), PRIMARY KEY(scenario_sheet_id, profile_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 JSON NOT NULL COMMENT \'(DC2Type:json)\', password VARCHAR(255) NOT NULL, reset_token VARCHAR(255) DEFAULT NULL, is_active TINYINT(1) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', UNIQUE INDEX UNIQ_8D93D649E7927C74 (email), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('ALTER TABLE ecos_actor ADD CONSTRAINT FK_1A6E79447D16298B FOREIGN KEY (vignette_id) REFERENCES ecos_vignette (id)');
$this->addSql('ALTER TABLE ecos_actor ADD CONSTRAINT FK_1A6E7944CCFA12B8 FOREIGN KEY (profile_id) REFERENCES profile (id)');
$this->addSql('ALTER TABLE ecos_actor_profile ADD CONSTRAINT FK_3996F39445256ED6 FOREIGN KEY (ecos_actor_id) REFERENCES ecos_actor (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE ecos_actor_profile ADD CONSTRAINT FK_3996F394CCFA12B8 FOREIGN KEY (profile_id) REFERENCES profile (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE ecos_evaluation ADD CONSTRAINT FK_376EEAF3FE2701F FOREIGN KEY (evaluation_grid_id) REFERENCES ecos_evaluation_grid (id)');
$this->addSql('ALTER TABLE ecos_evaluation_grade ADD CONSTRAINT FK_D8DD8544FE2701F FOREIGN KEY (evaluation_grid_id) REFERENCES ecos_evaluation_grid (id)');
$this->addSql('ALTER TABLE ecos_evaluation_grid ADD CONSTRAINT FK_171D64E37D16298B FOREIGN KEY (vignette_id) REFERENCES ecos_vignette (id)');
$this->addSql('ALTER TABLE ecos_evaluation_grid ADD CONSTRAINT FK_171D64E3CCFA12B8 FOREIGN KEY (profile_id) REFERENCES profile (id)');
$this->addSql('ALTER TABLE ecos_evaluation_grid_profile ADD CONSTRAINT FK_EA315BD1AF7269A4 FOREIGN KEY (ecos_evaluation_grid_id) REFERENCES ecos_evaluation_grid (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE ecos_evaluation_grid_profile ADD CONSTRAINT FK_EA315BD1CCFA12B8 FOREIGN KEY (profile_id) REFERENCES profile (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE ecos_evaluation_score ADD CONSTRAINT FK_B31E1C21456C5646 FOREIGN KEY (evaluation_id) REFERENCES ecos_evaluation (id)');
$this->addSql('ALTER TABLE ecos_evaluation_score ADD CONSTRAINT FK_B31E1C21F357D88E FOREIGN KEY (evaluation_grade_id) REFERENCES ecos_evaluation_grade (id)');
$this->addSql('ALTER TABLE ecos_media ADD CONSTRAINT FK_34378EB17D16298B FOREIGN KEY (vignette_id) REFERENCES ecos_vignette (id)');
$this->addSql('ALTER TABLE ecos_media ADD CONSTRAINT FK_34378EB1CCFA12B8 FOREIGN KEY (profile_id) REFERENCES profile (id)');
$this->addSql('ALTER TABLE ecos_media_profile ADD CONSTRAINT FK_7AB425B7BF6041E9 FOREIGN KEY (ecos_media_id) REFERENCES ecos_media (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE ecos_media_profile ADD CONSTRAINT FK_7AB425B7CCFA12B8 FOREIGN KEY (profile_id) REFERENCES profile (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE ecos_vignette ADD CONSTRAINT FK_5EB4CA82CCFA12B8 FOREIGN KEY (profile_id) REFERENCES profile (id)');
$this->addSql('ALTER TABLE ecos_vignette_profile ADD CONSTRAINT FK_8A1429D979E942D1 FOREIGN KEY (ecos_vignette_id) REFERENCES ecos_vignette (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE ecos_vignette_profile ADD CONSTRAINT FK_8A1429D9CCFA12B8 FOREIGN KEY (profile_id) REFERENCES profile (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE evaluation ADD CONSTRAINT FK_1323A575FE2701F FOREIGN KEY (evaluation_grid_id) REFERENCES evaluation_grid (id)');
$this->addSql('ALTER TABLE evaluation_grade ADD CONSTRAINT FK_9CADD3C5FE2701F FOREIGN KEY (evaluation_grid_id) REFERENCES evaluation_grid (id)');
$this->addSql('ALTER TABLE evaluation_grid ADD CONSTRAINT FK_6366968F865C7F83 FOREIGN KEY (evaluation_sheet_id) REFERENCES evaluation_sheet (id)');
$this->addSql('ALTER TABLE evaluation_grid ADD CONSTRAINT FK_6366968FCCFA12B8 FOREIGN KEY (profile_id) REFERENCES profile (id)');
$this->addSql('ALTER TABLE evaluation_grid ADD CONSTRAINT FK_6366968FA27FA90 FOREIGN KEY (program_sheet_id) REFERENCES program_sheet (id)');
$this->addSql('ALTER TABLE evaluation_score ADD CONSTRAINT FK_F76E4AA0456C5646 FOREIGN KEY (evaluation_id) REFERENCES evaluation (id)');
$this->addSql('ALTER TABLE evaluation_score ADD CONSTRAINT FK_F76E4AA0F357D88E FOREIGN KEY (evaluation_grade_id) REFERENCES evaluation_grade (id)');
$this->addSql('ALTER TABLE evaluation_sheet ADD CONSTRAINT FK_42CBEC13CCFA12B8 FOREIGN KEY (profile_id) REFERENCES profile (id)');
$this->addSql('ALTER TABLE evaluation_sheet ADD CONSTRAINT FK_42CBEC13A27FA90 FOREIGN KEY (program_sheet_id) REFERENCES program_sheet (id)');
$this->addSql('ALTER TABLE event ADD CONSTRAINT FK_3BAE0AA7CCFA12B8 FOREIGN KEY (profile_id) REFERENCES profile (id)');
$this->addSql('ALTER TABLE file ADD CONSTRAINT FK_8C9F36107E3C61F9 FOREIGN KEY (owner_id) REFERENCES profile (id)');
$this->addSql('ALTER TABLE file ADD CONSTRAINT FK_8C9F3610865C7F83 FOREIGN KEY (evaluation_sheet_id) REFERENCES evaluation_sheet (id)');
$this->addSql('ALTER TABLE file ADD CONSTRAINT FK_8C9F3610BF6041E9 FOREIGN KEY (ecos_media_id) REFERENCES ecos_media (id)');
$this->addSql('ALTER TABLE inventory_order ADD CONSTRAINT FK_29B538984584665A FOREIGN KEY (product_id) REFERENCES inventory_product (id)');
$this->addSql('ALTER TABLE inventory_product ADD CONSTRAINT FK_924EA251A53A8AA FOREIGN KEY (provider_id) REFERENCES inventory_provider (id)');
$this->addSql('ALTER TABLE inventory_product ADD CONSTRAINT FK_924EA25112469DE2 FOREIGN KEY (category_id) REFERENCES inventory_category (id)');
$this->addSql('ALTER TABLE inventory_product ADD CONSTRAINT FK_924EA25164D218E FOREIGN KEY (location_id) REFERENCES inventory_location (id)');
$this->addSql('ALTER TABLE profile ADD CONSTRAINT FK_8157AA0FA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE program_sheet ADD CONSTRAINT FK_1955E214CCFA12B8 FOREIGN KEY (profile_id) REFERENCES profile (id)');
$this->addSql('ALTER TABLE program_sheet_profile ADD CONSTRAINT FK_A862AF2AA27FA90 FOREIGN KEY (program_sheet_id) REFERENCES program_sheet (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE program_sheet_profile ADD CONSTRAINT FK_A862AF2ACCFA12B8 FOREIGN KEY (profile_id) REFERENCES profile (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE program_sheet_scenario_sheet ADD CONSTRAINT FK_D1807079A27FA90 FOREIGN KEY (program_sheet_id) REFERENCES program_sheet (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE program_sheet_scenario_sheet ADD CONSTRAINT FK_D18070798B0DC065 FOREIGN KEY (scenario_sheet_id) REFERENCES scenario_sheet (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE scenario_sheet ADD CONSTRAINT FK_A83320B3CCFA12B8 FOREIGN KEY (profile_id) REFERENCES profile (id)');
$this->addSql('ALTER TABLE scenario_sheet_profile ADD CONSTRAINT FK_A06202FE8B0DC065 FOREIGN KEY (scenario_sheet_id) REFERENCES scenario_sheet (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE scenario_sheet_profile ADD CONSTRAINT FK_A06202FECCFA12B8 FOREIGN KEY (profile_id) REFERENCES profile (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 ecos_actor DROP FOREIGN KEY FK_1A6E79447D16298B');
$this->addSql('ALTER TABLE ecos_actor DROP FOREIGN KEY FK_1A6E7944CCFA12B8');
$this->addSql('ALTER TABLE ecos_actor_profile DROP FOREIGN KEY FK_3996F39445256ED6');
$this->addSql('ALTER TABLE ecos_actor_profile DROP FOREIGN KEY FK_3996F394CCFA12B8');
$this->addSql('ALTER TABLE ecos_evaluation DROP FOREIGN KEY FK_376EEAF3FE2701F');
$this->addSql('ALTER TABLE ecos_evaluation_grade DROP FOREIGN KEY FK_D8DD8544FE2701F');
$this->addSql('ALTER TABLE ecos_evaluation_grid DROP FOREIGN KEY FK_171D64E37D16298B');
$this->addSql('ALTER TABLE ecos_evaluation_grid DROP FOREIGN KEY FK_171D64E3CCFA12B8');
$this->addSql('ALTER TABLE ecos_evaluation_grid_profile DROP FOREIGN KEY FK_EA315BD1AF7269A4');
$this->addSql('ALTER TABLE ecos_evaluation_grid_profile DROP FOREIGN KEY FK_EA315BD1CCFA12B8');
$this->addSql('ALTER TABLE ecos_evaluation_score DROP FOREIGN KEY FK_B31E1C21456C5646');
$this->addSql('ALTER TABLE ecos_evaluation_score DROP FOREIGN KEY FK_B31E1C21F357D88E');
$this->addSql('ALTER TABLE ecos_media DROP FOREIGN KEY FK_34378EB17D16298B');
$this->addSql('ALTER TABLE ecos_media DROP FOREIGN KEY FK_34378EB1CCFA12B8');
$this->addSql('ALTER TABLE ecos_media_profile DROP FOREIGN KEY FK_7AB425B7BF6041E9');
$this->addSql('ALTER TABLE ecos_media_profile DROP FOREIGN KEY FK_7AB425B7CCFA12B8');
$this->addSql('ALTER TABLE ecos_vignette DROP FOREIGN KEY FK_5EB4CA82CCFA12B8');
$this->addSql('ALTER TABLE ecos_vignette_profile DROP FOREIGN KEY FK_8A1429D979E942D1');
$this->addSql('ALTER TABLE ecos_vignette_profile DROP FOREIGN KEY FK_8A1429D9CCFA12B8');
$this->addSql('ALTER TABLE evaluation DROP FOREIGN KEY FK_1323A575FE2701F');
$this->addSql('ALTER TABLE evaluation_grade DROP FOREIGN KEY FK_9CADD3C5FE2701F');
$this->addSql('ALTER TABLE evaluation_grid DROP FOREIGN KEY FK_6366968F865C7F83');
$this->addSql('ALTER TABLE evaluation_grid DROP FOREIGN KEY FK_6366968FCCFA12B8');
$this->addSql('ALTER TABLE evaluation_grid DROP FOREIGN KEY FK_6366968FA27FA90');
$this->addSql('ALTER TABLE evaluation_score DROP FOREIGN KEY FK_F76E4AA0456C5646');
$this->addSql('ALTER TABLE evaluation_score DROP FOREIGN KEY FK_F76E4AA0F357D88E');
$this->addSql('ALTER TABLE evaluation_sheet DROP FOREIGN KEY FK_42CBEC13CCFA12B8');
$this->addSql('ALTER TABLE evaluation_sheet DROP FOREIGN KEY FK_42CBEC13A27FA90');
$this->addSql('ALTER TABLE event DROP FOREIGN KEY FK_3BAE0AA7CCFA12B8');
$this->addSql('ALTER TABLE file DROP FOREIGN KEY FK_8C9F36107E3C61F9');
$this->addSql('ALTER TABLE file DROP FOREIGN KEY FK_8C9F3610865C7F83');
$this->addSql('ALTER TABLE file DROP FOREIGN KEY FK_8C9F3610BF6041E9');
$this->addSql('ALTER TABLE inventory_order DROP FOREIGN KEY FK_29B538984584665A');
$this->addSql('ALTER TABLE inventory_product DROP FOREIGN KEY FK_924EA251A53A8AA');
$this->addSql('ALTER TABLE inventory_product DROP FOREIGN KEY FK_924EA25112469DE2');
$this->addSql('ALTER TABLE inventory_product DROP FOREIGN KEY FK_924EA25164D218E');
$this->addSql('ALTER TABLE profile DROP FOREIGN KEY FK_8157AA0FA76ED395');
$this->addSql('ALTER TABLE program_sheet DROP FOREIGN KEY FK_1955E214CCFA12B8');
$this->addSql('ALTER TABLE program_sheet_profile DROP FOREIGN KEY FK_A862AF2AA27FA90');
$this->addSql('ALTER TABLE program_sheet_profile DROP FOREIGN KEY FK_A862AF2ACCFA12B8');
$this->addSql('ALTER TABLE program_sheet_scenario_sheet DROP FOREIGN KEY FK_D1807079A27FA90');
$this->addSql('ALTER TABLE program_sheet_scenario_sheet DROP FOREIGN KEY FK_D18070798B0DC065');
$this->addSql('ALTER TABLE scenario_sheet DROP FOREIGN KEY FK_A83320B3CCFA12B8');
$this->addSql('ALTER TABLE scenario_sheet_profile DROP FOREIGN KEY FK_A06202FE8B0DC065');
$this->addSql('ALTER TABLE scenario_sheet_profile DROP FOREIGN KEY FK_A06202FECCFA12B8');
$this->addSql('DROP TABLE ecos_actor');
$this->addSql('DROP TABLE ecos_actor_profile');
$this->addSql('DROP TABLE ecos_evaluation');
$this->addSql('DROP TABLE ecos_evaluation_grade');
$this->addSql('DROP TABLE ecos_evaluation_grid');
$this->addSql('DROP TABLE ecos_evaluation_grid_profile');
$this->addSql('DROP TABLE ecos_evaluation_score');
$this->addSql('DROP TABLE ecos_media');
$this->addSql('DROP TABLE ecos_media_profile');
$this->addSql('DROP TABLE ecos_vignette');
$this->addSql('DROP TABLE ecos_vignette_profile');
$this->addSql('DROP TABLE evaluation');
$this->addSql('DROP TABLE evaluation_grade');
$this->addSql('DROP TABLE evaluation_grid');
$this->addSql('DROP TABLE evaluation_score');
$this->addSql('DROP TABLE evaluation_sheet');
$this->addSql('DROP TABLE event');
$this->addSql('DROP TABLE file');
$this->addSql('DROP TABLE inventory_category');
$this->addSql('DROP TABLE inventory_location');
$this->addSql('DROP TABLE inventory_order');
$this->addSql('DROP TABLE inventory_product');
$this->addSql('DROP TABLE inventory_provider');
$this->addSql('DROP TABLE profile');
$this->addSql('DROP TABLE program_sheet');
$this->addSql('DROP TABLE program_sheet_profile');
$this->addSql('DROP TABLE program_sheet_scenario_sheet');
$this->addSql('DROP TABLE scenario_sheet');
$this->addSql('DROP TABLE scenario_sheet_profile');
$this->addSql('DROP TABLE user');
}
}