Symfony Profiler

<?php
declare(strict_types=1);
namespace ProjectsBundleMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
use Symfony\Component\Uid\UuidV6;
final class Version20230129220826 extends AbstractMigration
{
public function up(Schema $schema): void
{
$this->addSql('CREATE TABLE projects_bundle__project (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', customer_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', state_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', current_step_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', type_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', created_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', updated_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', deleted_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', name VARCHAR(255) NOT NULL, customer_request LONGTEXT DEFAULT NULL, internal_note LONGTEXT DEFAULT NULL, date_start DATE DEFAULT NULL, date_end DATE DEFAULT NULL, deadline DATE DEFAULT NULL, drive_link VARCHAR(255) DEFAULT NULL, origin VARCHAR(255) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, deleted_at DATETIME DEFAULT NULL, INDEX IDX_9317E9C9395C3F3 (customer_id), INDEX IDX_9317E9C5D83CC1 (state_id), INDEX IDX_9317E9CD9BF9B19 (current_step_id), INDEX IDX_9317E9CC54C8C93 (type_id), INDEX IDX_9317E9CB03A8386 (created_by_id), INDEX IDX_9317E9C896DBBDE (updated_by_id), INDEX IDX_9317E9CC76F1F52 (deleted_by_id), INDEX name (name), INDEX date_start (date_start), INDEX date_end (date_end), INDEX deadline (deadline), INDEX deleted_at (deleted_at), INDEX created_at (created_at), INDEX updated_at (updated_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_bundle__project_context (project_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', context_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', INDEX IDX_905BD8B2166D1F9C (project_id), INDEX IDX_905BD8B26B00C1CF (context_id), PRIMARY KEY(project_id, context_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_bundle__project_member (project_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', user_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', INDEX IDX_71DEB3BE166D1F9C (project_id), INDEX IDX_71DEB3BEA76ED395 (user_id), PRIMARY KEY(project_id, user_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_bundle__project_quotation (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', project_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', INDEX IDX_35DF4AB4166D1F9C (project_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_bundle__project_state (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', created_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', updated_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', deleted_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', name VARCHAR(128) NOT NULL, color VARCHAR(7) NOT NULL, text_color VARCHAR(7) NOT NULL, started TINYINT(1) NOT NULL, finished TINYINT(1) NOT NULL, canceled TINYINT(1) NOT NULL, archived TINYINT(1) NOT NULL, position INT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, deleted_at DATETIME DEFAULT NULL, is_active TINYINT(1) DEFAULT 1 NOT NULL, is_default TINYINT(1) NOT NULL, INDEX IDX_42AB12BAB03A8386 (created_by_id), INDEX IDX_42AB12BA896DBBDE (updated_by_id), INDEX IDX_42AB12BAC76F1F52 (deleted_by_id), INDEX color (color), INDEX text_color (text_color), INDEX name (name), INDEX started (started), INDEX finished (finished), INDEX canceled (canceled), INDEX archived (archived), INDEX position (position), INDEX is_active (is_active), INDEX is_default (is_default), INDEX deleted_at (deleted_at), INDEX created_at (created_at), INDEX updated_at (updated_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_bundle__project_state_translations (id INT AUTO_INCREMENT NOT NULL, object_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_A9908FC2232D562B (object_id), FULLTEXT INDEX content (content), UNIQUE INDEX lookup_unique_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_bundle__project_step (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', created_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', updated_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', name VARCHAR(128) NOT NULL, color VARCHAR(7) NOT NULL, text_color VARCHAR(7) NOT NULL, number INT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_75E1A777B03A8386 (created_by_id), INDEX IDX_75E1A777896DBBDE (updated_by_id), INDEX color (color), INDEX text_color (text_color), INDEX name (name), INDEX number (number), INDEX created_at (created_at), INDEX updated_at (updated_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_bundle__project_step_translations (id INT AUTO_INCREMENT NOT NULL, object_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_A1DEADDE232D562B (object_id), FULLTEXT INDEX content (content), UNIQUE INDEX lookup_unique_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_bundle__project_type (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', created_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', updated_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', deleted_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', name VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, deleted_at DATETIME DEFAULT NULL, is_active TINYINT(1) DEFAULT 1 NOT NULL, INDEX IDX_BA860E62B03A8386 (created_by_id), INDEX IDX_BA860E62896DBBDE (updated_by_id), INDEX IDX_BA860E62C76F1F52 (deleted_by_id), INDEX name (name), INDEX is_active (is_active), INDEX deleted_at (deleted_at), INDEX created_at (created_at), INDEX updated_at (updated_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_bundle__project_type_translations (id INT AUTO_INCREMENT NOT NULL, object_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_1DF2E009232D562B (object_id), FULLTEXT INDEX content (content), UNIQUE INDEX lookup_unique_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_bundle__task (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', project_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', project_step_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', state_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', priority_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', parent_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', created_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', updated_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', deleted_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', is_group TINYINT(1) NOT NULL, number INT NOT NULL, name VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, estimated_time NUMERIC(20, 2) DEFAULT NULL, drive_link VARCHAR(255) DEFAULT NULL, position INT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, deleted_at DATETIME DEFAULT NULL, INDEX IDX_FD5802CF166D1F9C (project_id), INDEX IDX_FD5802CFE5AC12F9 (project_step_id), INDEX IDX_FD5802CF5D83CC1 (state_id), INDEX IDX_FD5802CF497B19F9 (priority_id), INDEX IDX_FD5802CF727ACA70 (parent_id), INDEX IDX_FD5802CFB03A8386 (created_by_id), INDEX IDX_FD5802CF896DBBDE (updated_by_id), INDEX IDX_FD5802CFC76F1F52 (deleted_by_id), INDEX is_group (is_group), INDEX number (number), INDEX name (name), INDEX estimated_time (estimated_time), INDEX position (position), INDEX deleted_at (deleted_at), INDEX created_at (created_at), INDEX updated_at (updated_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_bundle__task_user (project_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', user_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', INDEX IDX_D247F12B166D1F9C (project_id), INDEX IDX_D247F12BA76ED395 (user_id), PRIMARY KEY(project_id, user_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_bundle__task_model (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', project_step_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', created_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', updated_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', deleted_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', name VARCHAR(255) NOT NULL, description LONGTEXT DEFAULT NULL, estimated_time NUMERIC(20, 2) DEFAULT NULL, todos JSON NOT NULL, position INT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, deleted_at DATETIME DEFAULT NULL, INDEX IDX_7476A68AE5AC12F9 (project_step_id), INDEX IDX_7476A68AB03A8386 (created_by_id), INDEX IDX_7476A68A896DBBDE (updated_by_id), INDEX IDX_7476A68AC76F1F52 (deleted_by_id), INDEX name (name), INDEX estimated_time (estimated_time), INDEX position (position), INDEX deleted_at (deleted_at), INDEX created_at (created_at), INDEX updated_at (updated_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_bundle__task_priority (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', created_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', updated_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', deleted_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', name VARCHAR(128) NOT NULL, color VARCHAR(7) NOT NULL, text_color VARCHAR(7) NOT NULL, position INT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, deleted_at DATETIME DEFAULT NULL, is_active TINYINT(1) DEFAULT 1 NOT NULL, is_default TINYINT(1) NOT NULL, INDEX IDX_D00BFFB4B03A8386 (created_by_id), INDEX IDX_D00BFFB4896DBBDE (updated_by_id), INDEX IDX_D00BFFB4C76F1F52 (deleted_by_id), INDEX color (color), INDEX text_color (text_color), INDEX name (name), INDEX position (position), INDEX is_active (is_active), INDEX is_default (is_default), INDEX deleted_at (deleted_at), INDEX created_at (created_at), INDEX updated_at (updated_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_bundle__task_priority_translations (id INT AUTO_INCREMENT NOT NULL, object_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_B16F63E8232D562B (object_id), FULLTEXT INDEX content (content), UNIQUE INDEX lookup_unique_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_bundle__task_state (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', created_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', updated_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', deleted_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', name VARCHAR(128) NOT NULL, color VARCHAR(7) NOT NULL, text_color VARCHAR(7) NOT NULL, done TINYINT(1) NOT NULL, position INT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, deleted_at DATETIME DEFAULT NULL, is_active TINYINT(1) DEFAULT 1 NOT NULL, is_default TINYINT(1) NOT NULL, INDEX IDX_7006A8B03A8386 (created_by_id), INDEX IDX_7006A8896DBBDE (updated_by_id), INDEX IDX_7006A8C76F1F52 (deleted_by_id), INDEX color (color), INDEX text_color (text_color), INDEX name (name), INDEX done (done), INDEX position (position), INDEX is_active (is_active), INDEX is_default (is_default), INDEX deleted_at (deleted_at), INDEX created_at (created_at), INDEX updated_at (updated_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_bundle__task_state_translations (id INT AUTO_INCREMENT NOT NULL, object_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_C4E4F2B2232D562B (object_id), FULLTEXT INDEX content (content), UNIQUE INDEX lookup_unique_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_bundle__task_time (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', task_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', created_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', updated_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', deleted_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', time_start DATETIME NOT NULL, time NUMERIC(20, 2) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, deleted_at DATETIME DEFAULT NULL, INDEX IDX_3040BF278DB60186 (task_id), INDEX IDX_3040BF27B03A8386 (created_by_id), INDEX IDX_3040BF27896DBBDE (updated_by_id), INDEX IDX_3040BF27C76F1F52 (deleted_by_id), INDEX time_start (time_start), INDEX time (time), INDEX deleted_at (deleted_at), INDEX created_at (created_at), INDEX updated_at (updated_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE projects_bundle__todo (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', task_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', closed_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', created_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', updated_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', deleted_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', name VARCHAR(255) NOT NULL, closed_at DATETIME DEFAULT NULL, position INT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, deleted_at DATETIME DEFAULT NULL, INDEX IDX_F5286F4A8DB60186 (task_id), INDEX IDX_F5286F4AE1FA7797 (closed_by_id), INDEX IDX_F5286F4AB03A8386 (created_by_id), INDEX IDX_F5286F4A896DBBDE (updated_by_id), INDEX IDX_F5286F4AC76F1F52 (deleted_by_id), INDEX name (name), INDEX closed_at (closed_at), INDEX deleted_at (deleted_at), INDEX created_at (created_at), INDEX updated_at (updated_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('ALTER TABLE projects_bundle__project ADD CONSTRAINT FK_9317E9C9395C3F3 FOREIGN KEY (customer_id) REFERENCES customers_bundle__customer (id)');
$this->addSql('ALTER TABLE projects_bundle__project ADD CONSTRAINT FK_9317E9C5D83CC1 FOREIGN KEY (state_id) REFERENCES projects_bundle__project_state (id)');
$this->addSql('ALTER TABLE projects_bundle__project ADD CONSTRAINT FK_9317E9CD9BF9B19 FOREIGN KEY (current_step_id) REFERENCES projects_bundle__project_step (id)');
$this->addSql('ALTER TABLE projects_bundle__project ADD CONSTRAINT FK_9317E9CC54C8C93 FOREIGN KEY (type_id) REFERENCES projects_bundle__project_type (id)');
$this->addSql('ALTER TABLE projects_bundle__project ADD CONSTRAINT FK_9317E9CB03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__project ADD CONSTRAINT FK_9317E9C896DBBDE FOREIGN KEY (updated_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__project ADD CONSTRAINT FK_9317E9CC76F1F52 FOREIGN KEY (deleted_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__project_context ADD CONSTRAINT FK_905BD8B2166D1F9C FOREIGN KEY (project_id) REFERENCES projects_bundle__project (id)');
$this->addSql('ALTER TABLE projects_bundle__project_context ADD CONSTRAINT FK_905BD8B26B00C1CF FOREIGN KEY (context_id) REFERENCES context (id)');
$this->addSql('ALTER TABLE projects_bundle__project_member ADD CONSTRAINT FK_71DEB3BE166D1F9C FOREIGN KEY (project_id) REFERENCES projects_bundle__project (id)');
$this->addSql('ALTER TABLE projects_bundle__project_member ADD CONSTRAINT FK_71DEB3BEA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__project_quotation ADD CONSTRAINT FK_35DF4AB4166D1F9C FOREIGN KEY (project_id) REFERENCES projects_bundle__project (id)');
$this->addSql('ALTER TABLE projects_bundle__project_state ADD CONSTRAINT FK_42AB12BAB03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__project_state ADD CONSTRAINT FK_42AB12BA896DBBDE FOREIGN KEY (updated_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__project_state ADD CONSTRAINT FK_42AB12BAC76F1F52 FOREIGN KEY (deleted_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__project_state_translations ADD CONSTRAINT FK_A9908FC2232D562B FOREIGN KEY (object_id) REFERENCES projects_bundle__project_state (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE projects_bundle__project_step ADD CONSTRAINT FK_75E1A777B03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__project_step ADD CONSTRAINT FK_75E1A777896DBBDE FOREIGN KEY (updated_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__project_step_translations ADD CONSTRAINT FK_A1DEADDE232D562B FOREIGN KEY (object_id) REFERENCES projects_bundle__project_step (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE projects_bundle__project_type ADD CONSTRAINT FK_BA860E62B03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__project_type ADD CONSTRAINT FK_BA860E62896DBBDE FOREIGN KEY (updated_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__project_type ADD CONSTRAINT FK_BA860E62C76F1F52 FOREIGN KEY (deleted_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__project_type_translations ADD CONSTRAINT FK_1DF2E009232D562B FOREIGN KEY (object_id) REFERENCES projects_bundle__project_type (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE projects_bundle__task ADD CONSTRAINT FK_FD5802CF166D1F9C FOREIGN KEY (project_id) REFERENCES projects_bundle__project (id)');
$this->addSql('ALTER TABLE projects_bundle__task ADD CONSTRAINT FK_FD5802CFE5AC12F9 FOREIGN KEY (project_step_id) REFERENCES projects_bundle__project_step (id)');
$this->addSql('ALTER TABLE projects_bundle__task ADD CONSTRAINT FK_FD5802CF5D83CC1 FOREIGN KEY (state_id) REFERENCES projects_bundle__task_state (id)');
$this->addSql('ALTER TABLE projects_bundle__task ADD CONSTRAINT FK_FD5802CF497B19F9 FOREIGN KEY (priority_id) REFERENCES projects_bundle__task_priority (id)');
$this->addSql('ALTER TABLE projects_bundle__task ADD CONSTRAINT FK_FD5802CF727ACA70 FOREIGN KEY (parent_id) REFERENCES projects_bundle__task (id)');
$this->addSql('ALTER TABLE projects_bundle__task ADD CONSTRAINT FK_FD5802CFB03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__task ADD CONSTRAINT FK_FD5802CF896DBBDE FOREIGN KEY (updated_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__task ADD CONSTRAINT FK_FD5802CFC76F1F52 FOREIGN KEY (deleted_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__task_user ADD CONSTRAINT FK_D247F12B166D1F9C FOREIGN KEY (project_id) REFERENCES projects_bundle__task (id)');
$this->addSql('ALTER TABLE projects_bundle__task_user ADD CONSTRAINT FK_D247F12BA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__task_model ADD CONSTRAINT FK_7476A68AE5AC12F9 FOREIGN KEY (project_step_id) REFERENCES projects_bundle__project_step (id)');
$this->addSql('ALTER TABLE projects_bundle__task_model ADD CONSTRAINT FK_7476A68AB03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__task_model ADD CONSTRAINT FK_7476A68A896DBBDE FOREIGN KEY (updated_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__task_model ADD CONSTRAINT FK_7476A68AC76F1F52 FOREIGN KEY (deleted_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__task_priority ADD CONSTRAINT FK_D00BFFB4B03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__task_priority ADD CONSTRAINT FK_D00BFFB4896DBBDE FOREIGN KEY (updated_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__task_priority ADD CONSTRAINT FK_D00BFFB4C76F1F52 FOREIGN KEY (deleted_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__task_priority_translations ADD CONSTRAINT FK_B16F63E8232D562B FOREIGN KEY (object_id) REFERENCES projects_bundle__task_priority (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE projects_bundle__task_state ADD CONSTRAINT FK_7006A8B03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__task_state ADD CONSTRAINT FK_7006A8896DBBDE FOREIGN KEY (updated_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__task_state ADD CONSTRAINT FK_7006A8C76F1F52 FOREIGN KEY (deleted_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__task_state_translations ADD CONSTRAINT FK_C4E4F2B2232D562B FOREIGN KEY (object_id) REFERENCES projects_bundle__task_state (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE projects_bundle__task_time ADD CONSTRAINT FK_3040BF278DB60186 FOREIGN KEY (task_id) REFERENCES projects_bundle__task (id)');
$this->addSql('ALTER TABLE projects_bundle__task_time ADD CONSTRAINT FK_3040BF27B03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__task_time ADD CONSTRAINT FK_3040BF27896DBBDE FOREIGN KEY (updated_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__task_time ADD CONSTRAINT FK_3040BF27C76F1F52 FOREIGN KEY (deleted_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__todo ADD CONSTRAINT FK_F5286F4A8DB60186 FOREIGN KEY (task_id) REFERENCES projects_bundle__task (id)');
$this->addSql('ALTER TABLE projects_bundle__todo ADD CONSTRAINT FK_F5286F4AE1FA7797 FOREIGN KEY (closed_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__todo ADD CONSTRAINT FK_F5286F4AB03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__todo ADD CONSTRAINT FK_F5286F4A896DBBDE FOREIGN KEY (updated_by_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE projects_bundle__todo ADD CONSTRAINT FK_F5286F4AC76F1F52 FOREIGN KEY (deleted_by_id) REFERENCES user (id)');
}
public function postUp(Schema $schema): void
{
parent::postUp($schema);
$now = (new \DateTime())->format('Y-m-d H:i:s');
$languages = $this->connection->executeQuery('SELECT * FROM language WHERE deleted_at IS NULL')
->fetchAllAssociative();
$rootLocale = 'en';
$defaultLocale = $this->connection
->executeQuery('SELECT locale FROM language WHERE deleted_at IS NULL AND is_default = 1')
->fetchOne() ?: 'en';
$projectSteps = [
[
'names' => ['fr' => 'Commerce', 'en' => 'Trade'],
'color' => '#fbf422',
'text_color' => '#000000',
'number' => 1
],
[
'names' => ['fr' => 'Administratif', 'en' => 'Administrative'],
'color' => '#ffa500',
'text_color' => '#ffffff',
'number' => 2
],
[
'names' => ['fr' => 'Conception', 'en' => 'Conception'],
'color' => '#0000ff',
'text_color' => '#ffffff',
'number' => 3
],
[
'names' => ['fr' => 'Production', 'en' => 'Production'],
'color' => '#ff0000',
'text_color' => '#ffffff',
'number' => 4
],
[
'names' => ['fr' => 'Support', 'en' => 'Support'],
'color' => '#008000',
'text_color' => '#ffffff',
'number' => 5
],
[
'names' => ['fr' => 'Clos', 'en' => 'Closed'],
'color' => '#000',
'text_color' => '#fff',
'number' => 6
]
];
foreach ($projectSteps as $projectStep) {
$projectStepId = (new UuidV6())->toBinary();
$this->connection->insert('projects_bundle__project_step', [
'id' => $projectStepId,
'name' => !empty($projectStep['names'][$defaultLocale]) ?
$projectStep['names'][$defaultLocale] : $projectStep['names'][$rootLocale],
'color' => $projectStep['color'],
'text_color' => $projectStep['text_color'],
'number' => $projectStep['number'],
'created_at' => $now,
'updated_at' => $now
]);
foreach ($languages as $language) {
$localeTo = $rootLocale;
if (!empty($projectStep['names'][$language['locale']])) {
$localeTo = $language['locale'];
} elseif (!empty($projectStep['names'][$defaultLocale])) {
$localeTo = $defaultLocale;
}
$this->connection->insert('projects_bundle__project_step_translations', [
'object_id' => $projectStepId,
'locale' => $language['locale'],
'field' => 'name',
'content' => $projectStep['names'][$localeTo]
]);
}
}
$projectStates = [
[
'names' => ['fr' => 'À débuter', 'en' => 'To be started'],
'color' => '#bdbdbd',
'text_color' => '#ffffff',
'default' => 1,
'active' => 1,
'started' => 1,
'finished' => 0,
'canceled' => 0,
'archived' => 0,
'position' => 1
],
[
'names' => ['fr' => 'En cours', 'en' => 'In progress'],
'color' => '#4eb1fd',
'text_color' => '#ffffff',
'default' => 0,
'active' => 1,
'started' => 0,
'finished' => 0,
'canceled' => 0,
'archived' => 0,
'position' => 2
],
[
'names' => ['fr' => 'En attente', 'en' => 'On hold'],
'color' => '#05ffb8',
'text_color' => '#ffffff',
'default' => 0,
'active' => 1,
'started' => 0,
'finished' => 0,
'canceled' => 0,
'archived' => 0,
'position' => 3
],
[
'names' => ['fr' => 'Clos', 'en' => 'Closed'],
'color' => '#06b711',
'text_color' => '#ffffff',
'default' => 0,
'active' => 1,
'started' => 0,
'finished' => 1,
'canceled' => 0,
'archived' => 0,
'position' => 4
],
[
'names' => ['fr' => 'Annulé', 'en' => 'Canceled'],
'color' => '#ef1f1f',
'text_color' => '#ffffff',
'default' => 0,
'active' => 1,
'started' => 0,
'finished' => 1,
'canceled' => 1,
'archived' => 0,
'position' => 5
],
[
'names' => ['fr' => 'Archivé', 'en' => 'Archived'],
'color' => '#f7963b',
'text_color' => '#ffffff',
'default' => 0,
'active' => 1,
'started' => 0,
'finished' => 1,
'canceled' => 0,
'archived' => 1,
'position' => 6
]
];
foreach ($projectStates as $projectState) {
$projectStateId = (new UuidV6())->toBinary();
$this->connection->insert('projects_bundle__project_state', [
'id' => $projectStateId,
'name' => !empty($projectState['names'][$defaultLocale]) ?
$projectState['names'][$defaultLocale] : $projectState['names'][$rootLocale],
'color' => $projectState['color'],
'text_color' => $projectState['text_color'],
'started' => $projectState['started'],
'finished' => $projectState['finished'],
'canceled' => $projectState['canceled'],
'archived' => $projectState['archived'],
'is_active' => $projectState['active'],
'is_default' => $projectState['default'],
'position' => $projectState['position'],
'created_at' => $now,
'updated_at' => $now
]);
foreach ($languages as $language) {
$localeTo = $rootLocale;
if (!empty($projectState['names'][$language['locale']])) {
$localeTo = $language['locale'];
} elseif (!empty($projectState['names'][$defaultLocale])) {
$localeTo = $defaultLocale;
}
$this->connection->insert('projects_bundle__project_state_translations', [
'object_id' => $projectStateId,
'locale' => $language['locale'],
'field' => 'name',
'content' => $projectState['names'][$localeTo]
]);
}
}
$taskStates = [
[
'names' => ['fr' => 'À faire', 'en' => 'To do'],
'color' => '#cd05f5',
'text_color' => '#ffffff',
'done' => 0,
'active' => 1,
'default' => 0,
'position' => 1
],
[
'names' => ['fr' => 'En cours', 'en' => 'In progress'],
'color' => '#1ab2ff',
'text_color' => '#ffffff',
'done' => 0,
'active' => 1,
'default' => 0,
'position' => 2
],
[
'names' => ['fr' => 'Coincé', 'en' => 'Stuck'],
'color' => '#ff0a0a',
'text_color' => '#ffffff',
'done' => 0,
'active' => 1,
'default' => 0,
'position' => 3
],
[
'names' => ['fr' => 'En attente', 'en' => 'On hold'],
'color' => '#01f4c3',
'text_color' => '#ffffff',
'done' => 0,
'active' => 1,
'default' => 0,
'position' => 4
],
[
'names' => ['fr' => 'Fait', 'en' => 'Done'],
'color' => '#00d123',
'text_color' => '#ffffff',
'done' => 1,
'active' => 1,
'default' => 0,
'position' => 5
],
[
'names' => ['fr' => 'Aucun', 'en' => 'None'],
'color' => '#b8b8b8',
'text_color' => '#fff',
'done' => 0,
'active' => 1,
'default' => 1,
'position' => 6
]
];
foreach ($taskStates as $taskState) {
$taskStateId = (new UuidV6())->toBinary();
$this->connection->insert('projects_bundle__task_state', [
'id' => $taskStateId,
'name' => !empty($taskState['names'][$defaultLocale]) ?
$taskState['names'][$defaultLocale] : $taskState['names'][$rootLocale],
'color' => $taskState['color'],
'text_color' => $taskState['text_color'],
'done' => $taskState['done'],
'is_active' => $taskState['active'],
'is_default' => $taskState['default'],
'position' => $taskState['position'],
'created_at' => $now,
'updated_at' => $now
]);
foreach ($languages as $language) {
$localeTo = $rootLocale;
if (!empty($taskState['names'][$language['locale']])) {
$localeTo = $language['locale'];
} elseif (!empty($taskState['names'][$defaultLocale])) {
$localeTo = $defaultLocale;
}
$this->connection->insert('projects_bundle__task_state_translations', [
'object_id' => $taskStateId,
'locale' => $language['locale'],
'field' => 'name',
'content' => $taskState['names'][$localeTo]
]);
}
}
$taskPriorities = [
[
'names' => ['fr' => 'Faible', 'en' => 'Low'],
'color' => '#79affd',
'text_color' => '#000000',
'active' => 1,
'default' => 0,
'position' => 1
],
[
'names' => ['fr' => 'Normal', 'en' => 'Normal'],
'color' => '#ffa500',
'text_color' => '#ffffff',
'active' => 1,
'default' => 1,
'position' => 2
],
[
'names' => ['fr' => 'Important', 'en' => 'Important'],
'color' => '#febd63',
'text_color' => '#ffffff',
'active' => 1,
'default' => 0,
'position' => 3
],
[
'names' => ['fr' => 'Critique', 'en' => 'Critical'],
'color' => '#c85c75',
'text_color' => '#ffffff',
'active' => 1,
'default' => 0,
'position' => 4
]
];
foreach ($taskPriorities as $taskPriority) {
$taskPriorityId = (new UuidV6())->toBinary();
$this->connection->insert('projects_bundle__task_priority', [
'id' => $taskPriorityId,
'name' => !empty($taskPriority['names'][$defaultLocale]) ?
$taskPriority['names'][$defaultLocale] : $taskPriority['names'][$rootLocale],
'color' => $taskPriority['color'],
'text_color' => $taskPriority['text_color'],
'is_active' => $taskPriority['active'],
'is_default' => $taskPriority['default'],
'position' => $taskPriority['position'],
'created_at' => $now,
'updated_at' => $now
]);
foreach ($languages as $language) {
$localeTo = $rootLocale;
if (!empty($taskPriority['names'][$language['locale']])) {
$localeTo = $language['locale'];
} elseif (!empty($taskPriority['names'][$defaultLocale])) {
$localeTo = $defaultLocale;
}
$this->connection->insert('projects_bundle__task_priority_translations', [
'object_id' => $taskPriorityId,
'locale' => $language['locale'],
'field' => 'name',
'content' => $taskPriority['names'][$localeTo]
]);
}
}
$this->connection->insert('cron_job', [
'name' => 'projects-check-project-step',
'command' => 'bluue-bundle:projects:check-project-step',
'schedule' => '0 5 * * *',
'description' => '',
'enabled' => 1
]);
}
public function down(Schema $schema): void
{
$this->addSql('ALTER TABLE projects_bundle__project DROP FOREIGN KEY FK_9317E9C9395C3F3');
$this->addSql('ALTER TABLE projects_bundle__project DROP FOREIGN KEY FK_9317E9C5D83CC1');
$this->addSql('ALTER TABLE projects_bundle__project DROP FOREIGN KEY FK_9317E9CD9BF9B19');
$this->addSql('ALTER TABLE projects_bundle__project DROP FOREIGN KEY FK_9317E9CC54C8C93');
$this->addSql('ALTER TABLE projects_bundle__project DROP FOREIGN KEY FK_9317E9CB03A8386');
$this->addSql('ALTER TABLE projects_bundle__project DROP FOREIGN KEY FK_9317E9C896DBBDE');
$this->addSql('ALTER TABLE projects_bundle__project DROP FOREIGN KEY FK_9317E9CC76F1F52');
$this->addSql('ALTER TABLE projects_bundle__project_context DROP FOREIGN KEY FK_905BD8B2166D1F9C');
$this->addSql('ALTER TABLE projects_bundle__project_context DROP FOREIGN KEY FK_905BD8B26B00C1CF');
$this->addSql('ALTER TABLE projects_bundle__project_member DROP FOREIGN KEY FK_71DEB3BE166D1F9C');
$this->addSql('ALTER TABLE projects_bundle__project_member DROP FOREIGN KEY FK_71DEB3BEA76ED395');
$this->addSql('ALTER TABLE projects_bundle__project_quotation DROP FOREIGN KEY FK_35DF4AB4166D1F9C');
$this->addSql('ALTER TABLE projects_bundle__project_state DROP FOREIGN KEY FK_42AB12BAB03A8386');
$this->addSql('ALTER TABLE projects_bundle__project_state DROP FOREIGN KEY FK_42AB12BA896DBBDE');
$this->addSql('ALTER TABLE projects_bundle__project_state DROP FOREIGN KEY FK_42AB12BAC76F1F52');
$this->addSql('ALTER TABLE projects_bundle__project_state_translations DROP FOREIGN KEY FK_A9908FC2232D562B');
$this->addSql('ALTER TABLE projects_bundle__project_step DROP FOREIGN KEY FK_75E1A777B03A8386');
$this->addSql('ALTER TABLE projects_bundle__project_step DROP FOREIGN KEY FK_75E1A777896DBBDE');
$this->addSql('ALTER TABLE projects_bundle__project_step_translations DROP FOREIGN KEY FK_A1DEADDE232D562B');
$this->addSql('ALTER TABLE projects_bundle__project_type DROP FOREIGN KEY FK_BA860E62B03A8386');
$this->addSql('ALTER TABLE projects_bundle__project_type DROP FOREIGN KEY FK_BA860E62896DBBDE');
$this->addSql('ALTER TABLE projects_bundle__project_type DROP FOREIGN KEY FK_BA860E62C76F1F52');
$this->addSql('ALTER TABLE projects_bundle__project_type_translations DROP FOREIGN KEY FK_1DF2E009232D562B');
$this->addSql('ALTER TABLE projects_bundle__task DROP FOREIGN KEY FK_FD5802CF166D1F9C');
$this->addSql('ALTER TABLE projects_bundle__task DROP FOREIGN KEY FK_FD5802CFE5AC12F9');
$this->addSql('ALTER TABLE projects_bundle__task DROP FOREIGN KEY FK_FD5802CF5D83CC1');
$this->addSql('ALTER TABLE projects_bundle__task DROP FOREIGN KEY FK_FD5802CF497B19F9');
$this->addSql('ALTER TABLE projects_bundle__task DROP FOREIGN KEY FK_FD5802CF727ACA70');
$this->addSql('ALTER TABLE projects_bundle__task DROP FOREIGN KEY FK_FD5802CFB03A8386');
$this->addSql('ALTER TABLE projects_bundle__task DROP FOREIGN KEY FK_FD5802CF896DBBDE');
$this->addSql('ALTER TABLE projects_bundle__task DROP FOREIGN KEY FK_FD5802CFC76F1F52');
$this->addSql('ALTER TABLE projects_bundle__task_user DROP FOREIGN KEY FK_D247F12B166D1F9C');
$this->addSql('ALTER TABLE projects_bundle__task_user DROP FOREIGN KEY FK_D247F12BA76ED395');
$this->addSql('ALTER TABLE projects_bundle__task_model DROP FOREIGN KEY FK_7476A68AE5AC12F9');
$this->addSql('ALTER TABLE projects_bundle__task_model DROP FOREIGN KEY FK_7476A68AB03A8386');
$this->addSql('ALTER TABLE projects_bundle__task_model DROP FOREIGN KEY FK_7476A68A896DBBDE');
$this->addSql('ALTER TABLE projects_bundle__task_model DROP FOREIGN KEY FK_7476A68AC76F1F52');
$this->addSql('ALTER TABLE projects_bundle__task_priority DROP FOREIGN KEY FK_D00BFFB4B03A8386');
$this->addSql('ALTER TABLE projects_bundle__task_priority DROP FOREIGN KEY FK_D00BFFB4896DBBDE');
$this->addSql('ALTER TABLE projects_bundle__task_priority DROP FOREIGN KEY FK_D00BFFB4C76F1F52');
$this->addSql('ALTER TABLE projects_bundle__task_priority_translations DROP FOREIGN KEY FK_B16F63E8232D562B');
$this->addSql('ALTER TABLE projects_bundle__task_state DROP FOREIGN KEY FK_7006A8B03A8386');
$this->addSql('ALTER TABLE projects_bundle__task_state DROP FOREIGN KEY FK_7006A8896DBBDE');
$this->addSql('ALTER TABLE projects_bundle__task_state DROP FOREIGN KEY FK_7006A8C76F1F52');
$this->addSql('ALTER TABLE projects_bundle__task_state_translations DROP FOREIGN KEY FK_C4E4F2B2232D562B');
$this->addSql('ALTER TABLE projects_bundle__task_time DROP FOREIGN KEY FK_3040BF278DB60186');
$this->addSql('ALTER TABLE projects_bundle__task_time DROP FOREIGN KEY FK_3040BF27B03A8386');
$this->addSql('ALTER TABLE projects_bundle__task_time DROP FOREIGN KEY FK_3040BF27896DBBDE');
$this->addSql('ALTER TABLE projects_bundle__task_time DROP FOREIGN KEY FK_3040BF27C76F1F52');
$this->addSql('ALTER TABLE projects_bundle__todo DROP FOREIGN KEY FK_F5286F4A8DB60186');
$this->addSql('ALTER TABLE projects_bundle__todo DROP FOREIGN KEY FK_F5286F4AE1FA7797');
$this->addSql('ALTER TABLE projects_bundle__todo DROP FOREIGN KEY FK_F5286F4AB03A8386');
$this->addSql('ALTER TABLE projects_bundle__todo DROP FOREIGN KEY FK_F5286F4A896DBBDE');
$this->addSql('ALTER TABLE projects_bundle__todo DROP FOREIGN KEY FK_F5286F4AC76F1F52');
$this->addSql('DROP TABLE projects_bundle__project');
$this->addSql('DROP TABLE projects_bundle__project_context');
$this->addSql('DROP TABLE projects_bundle__project_member');
$this->addSql('DROP TABLE projects_bundle__project_quotation');
$this->addSql('DROP TABLE projects_bundle__project_state');
$this->addSql('DROP TABLE projects_bundle__project_state_translations');
$this->addSql('DROP TABLE projects_bundle__project_step');
$this->addSql('DROP TABLE projects_bundle__project_step_translations');
$this->addSql('DROP TABLE projects_bundle__project_type');
$this->addSql('DROP TABLE projects_bundle__project_type_translations');
$this->addSql('DROP TABLE projects_bundle__task');
$this->addSql('DROP TABLE projects_bundle__task_user');
$this->addSql('DROP TABLE projects_bundle__task_model');
$this->addSql('DROP TABLE projects_bundle__task_priority');
$this->addSql('DROP TABLE projects_bundle__task_priority_translations');
$this->addSql('DROP TABLE projects_bundle__task_state');
$this->addSql('DROP TABLE projects_bundle__task_state_translations');
$this->addSql('DROP TABLE projects_bundle__task_time');
$this->addSql('DROP TABLE projects_bundle__todo');
}
}

vendor/bluue/projects-bundle/migrations/Version20230129220826.php line 1