migrations/Version20250414155105.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. /**
  11.  * Auto-generated Migration: Please modify to your needs!
  12.  */
  13. final class Version20250414155105 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         // this up() migration is auto-generated, please modify it to your needs
  23.         $this->addSql('CREATE TABLE channel_crm_prospects (
  24.           id INT AUTO_INCREMENT NOT NULL,
  25.           channel_id VARCHAR(36) NOT NULL,
  26.           created_by_id VARCHAR(36) DEFAULT NULL,
  27.           updated_by_id VARCHAR(36) DEFAULT NULL,
  28.           email VARCHAR(180) NOT NULL,
  29.           first_name VARCHAR(255) DEFAULT NULL,
  30.           last_name VARCHAR(255) DEFAULT NULL,
  31.           created_at DATETIME NOT NULL,
  32.           updated_at DATETIME DEFAULT NULL,
  33.           INDEX IDX_D584129F72F5A1AA (channel_id),
  34.           INDEX IDX_D584129FB03A8386 (created_by_id),
  35.           INDEX IDX_D584129F896DBBDE (updated_by_id),
  36.           FULLTEXT INDEX IDX_D584129FE7927C74 (email),
  37.           FULLTEXT INDEX IDX_D584129FA9D1C132 (first_name),
  38.           FULLTEXT INDEX IDX_D584129FC808BA5A (last_name),
  39.           UNIQUE INDEX UNIQ_D584129F72F5A1AAE7927C74 (channel_id, email),
  40.           PRIMARY KEY(id)
  41.         ) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  42.         $this->addSql('CREATE TABLE channel_positioning_test_attempt_answers (
  43.           id INT AUTO_INCREMENT NOT NULL,
  44.           attempt_block_id INT NOT NULL,
  45.           question_id INT DEFAULT NULL,
  46.           created_by_id VARCHAR(36) DEFAULT NULL,
  47.           updated_by_id VARCHAR(36) DEFAULT NULL,
  48.           valid TINYINT(1) NOT NULL,
  49.           created_at DATETIME NOT NULL,
  50.           updated_at DATETIME DEFAULT NULL,
  51.           INDEX IDX_2DC4DE2681F474AA (attempt_block_id),
  52.           INDEX IDX_2DC4DE261E27F6BF (question_id),
  53.           INDEX IDX_2DC4DE26B03A8386 (created_by_id),
  54.           INDEX IDX_2DC4DE26896DBBDE (updated_by_id),
  55.           PRIMARY KEY(id)
  56.         ) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  57.         $this->addSql('CREATE TABLE channel_positioning_test_attempt_answer_selected_answers (
  58.           answer_id INT NOT NULL,
  59.           question_answer_id INT NOT NULL,
  60.           INDEX IDX_45D840D5AA334807 (answer_id),
  61.           INDEX IDX_45D840D5A3E60C9C (question_answer_id),
  62.           PRIMARY KEY(answer_id, question_answer_id)
  63.         ) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  64.         $this->addSql('CREATE TABLE channel_positioning_test_attempt_blocks (
  65.           id INT AUTO_INCREMENT NOT NULL,
  66.           attempt_id INT NOT NULL,
  67.           block_id INT DEFAULT NULL,
  68.           created_by_id VARCHAR(36) DEFAULT NULL,
  69.           updated_by_id VARCHAR(36) DEFAULT NULL,
  70.           time INT NOT NULL,
  71.           status VARCHAR(255) DEFAULT \'waiting\',
  72.           result VARCHAR(255) DEFAULT NULL,
  73.           created_at DATETIME NOT NULL,
  74.           updated_at DATETIME DEFAULT NULL,
  75.           INDEX IDX_DD6B04F7B191BE6B (attempt_id),
  76.           INDEX IDX_DD6B04F7E9ED820C (block_id),
  77.           INDEX IDX_DD6B04F7B03A8386 (created_by_id),
  78.           INDEX IDX_DD6B04F7896DBBDE (updated_by_id),
  79.           PRIMARY KEY(id)
  80.         ) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  81.         $this->addSql('CREATE TABLE channel_positioning_test_attempts (
  82.           id INT AUTO_INCREMENT NOT NULL,
  83.           prospect_id INT NOT NULL,
  84.           positioning_test_id INT DEFAULT NULL,
  85.           created_by_id VARCHAR(36) DEFAULT NULL,
  86.           updated_by_id VARCHAR(36) DEFAULT NULL,
  87.           time INT NOT NULL,
  88.           status VARCHAR(255) DEFAULT \'waiting\',
  89.           result VARCHAR(255) DEFAULT NULL,
  90.           created_at DATETIME NOT NULL,
  91.           updated_at DATETIME DEFAULT NULL,
  92.           INDEX IDX_AEEA1A75D182060A (prospect_id),
  93.           INDEX IDX_AEEA1A75F5AF274A (positioning_test_id),
  94.           INDEX IDX_AEEA1A75B03A8386 (created_by_id),
  95.           INDEX IDX_AEEA1A75896DBBDE (updated_by_id),
  96.           PRIMARY KEY(id)
  97.         ) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  98.         $this->addSql('CREATE TABLE channel_positioning_test_blocks (
  99.           id INT AUTO_INCREMENT NOT NULL,
  100.           channel_id VARCHAR(36) NOT NULL,
  101.           created_by_id VARCHAR(36) DEFAULT NULL,
  102.           updated_by_id VARCHAR(36) DEFAULT NULL,
  103.           archived TINYINT(1) NOT NULL,
  104.           title VARCHAR(255) NOT NULL,
  105.           description TEXT NOT NULL,
  106.           estimated_time TIME DEFAULT NULL,
  107.           created_at DATETIME NOT NULL,
  108.           updated_at DATETIME DEFAULT NULL,
  109.           INDEX IDX_E13EC5C672F5A1AA (channel_id),
  110.           INDEX IDX_E13EC5C6B03A8386 (created_by_id),
  111.           INDEX IDX_E13EC5C6896DBBDE (updated_by_id),
  112.           PRIMARY KEY(id)
  113.         ) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  114.         $this->addSql('CREATE TABLE channel_positioning_test_positioning_test_blocks (
  115.           id INT AUTO_INCREMENT NOT NULL,
  116.           positioning_test_id INT NOT NULL,
  117.           block_id INT NOT NULL,
  118.           rank INT NOT NULL,
  119.           INDEX IDX_7051C812F5AF274A (positioning_test_id),
  120.           INDEX IDX_7051C812E9ED820C (block_id),
  121.           PRIMARY KEY(id)
  122.         ) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  123.         $this->addSql('CREATE TABLE channel_positioning_test_question_answers (
  124.           id INT AUTO_INCREMENT NOT NULL,
  125.           question_id INT NOT NULL,
  126.           created_by_id VARCHAR(36) DEFAULT NULL,
  127.           updated_by_id VARCHAR(36) DEFAULT NULL,
  128.           valid TINYINT(1) NOT NULL,
  129.           label VARCHAR(255) NOT NULL,
  130.           rank INT NOT NULL,
  131.           created_at DATETIME NOT NULL,
  132.           updated_at DATETIME DEFAULT NULL,
  133.           INDEX IDX_D06D16D1E27F6BF (question_id),
  134.           INDEX IDX_D06D16DB03A8386 (created_by_id),
  135.           INDEX IDX_D06D16D896DBBDE (updated_by_id),
  136.           PRIMARY KEY(id)
  137.         ) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  138.         $this->addSql('CREATE TABLE channel_positioning_test_questions (
  139.           id INT AUTO_INCREMENT NOT NULL,
  140.           block_id INT NOT NULL,
  141.           created_by_id VARCHAR(36) DEFAULT NULL,
  142.           updated_by_id VARCHAR(36) DEFAULT NULL,
  143.           multiple TINYINT(1) NOT NULL,
  144.           label VARCHAR(255) NOT NULL,
  145.           description TEXT NOT NULL,
  146.           rank INT NOT NULL,
  147.           created_at DATETIME NOT NULL,
  148.           updated_at DATETIME DEFAULT NULL,
  149.           INDEX IDX_E07D59DAE9ED820C (block_id),
  150.           INDEX IDX_E07D59DAB03A8386 (created_by_id),
  151.           INDEX IDX_E07D59DA896DBBDE (updated_by_id),
  152.           PRIMARY KEY(id)
  153.         ) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  154.         $this->addSql('CREATE TABLE channel_positioning_tests (
  155.           id INT AUTO_INCREMENT NOT NULL,
  156.           channel_id VARCHAR(36) NOT NULL,
  157.           created_by_id VARCHAR(36) DEFAULT NULL,
  158.           updated_by_id VARCHAR(36) DEFAULT NULL,
  159.           archived TINYINT(1) NOT NULL,
  160.           title VARCHAR(255) NOT NULL,
  161.           description TEXT NOT NULL,
  162.           break_text TEXT DEFAULT NULL,
  163.           fraud_title VARCHAR(255) DEFAULT NULL,
  164.           fraud_text TEXT DEFAULT NULL,
  165.           created_at DATETIME NOT NULL,
  166.           updated_at DATETIME DEFAULT NULL,
  167.           INDEX IDX_E24E951872F5A1AA (channel_id),
  168.           INDEX IDX_E24E9518B03A8386 (created_by_id),
  169.           INDEX IDX_E24E9518896DBBDE (updated_by_id),
  170.           PRIMARY KEY(id)
  171.         ) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  172.         $this->addSql('CREATE TABLE file_positioning_test_question (
  173.           id INT NOT NULL,
  174.           question_id INT NOT NULL,
  175.           INDEX IDX_FF2853CF1E27F6BF (question_id),
  176.           PRIMARY KEY(id)
  177.         ) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  178.         $this->addSql('ALTER TABLE
  179.           channel_crm_prospects
  180.         ADD
  181.           CONSTRAINT FK_D584129F72F5A1AA FOREIGN KEY (channel_id) REFERENCES channel_channels (id) ON DELETE CASCADE');
  182.         $this->addSql('ALTER TABLE
  183.           channel_crm_prospects
  184.         ADD
  185.           CONSTRAINT FK_D584129FB03A8386 FOREIGN KEY (created_by_id) REFERENCES account_users (id) ON DELETE
  186.         SET
  187.           NULL');
  188.         $this->addSql('ALTER TABLE
  189.           channel_crm_prospects
  190.         ADD
  191.           CONSTRAINT FK_D584129F896DBBDE FOREIGN KEY (updated_by_id) REFERENCES account_users (id) ON DELETE
  192.         SET
  193.           NULL');
  194.         $this->addSql('ALTER TABLE
  195.           channel_positioning_test_attempt_answers
  196.         ADD
  197.           CONSTRAINT FK_2DC4DE2681F474AA FOREIGN KEY (attempt_block_id) REFERENCES channel_positioning_test_attempt_blocks (id) ON DELETE CASCADE');
  198.         $this->addSql('ALTER TABLE
  199.           channel_positioning_test_attempt_answers
  200.         ADD
  201.           CONSTRAINT FK_2DC4DE261E27F6BF FOREIGN KEY (question_id) REFERENCES channel_positioning_test_questions (id) ON DELETE
  202.         SET
  203.           NULL');
  204.         $this->addSql('ALTER TABLE
  205.           channel_positioning_test_attempt_answers
  206.         ADD
  207.           CONSTRAINT FK_2DC4DE26B03A8386 FOREIGN KEY (created_by_id) REFERENCES account_users (id) ON DELETE
  208.         SET
  209.           NULL');
  210.         $this->addSql('ALTER TABLE
  211.           channel_positioning_test_attempt_answers
  212.         ADD
  213.           CONSTRAINT FK_2DC4DE26896DBBDE FOREIGN KEY (updated_by_id) REFERENCES account_users (id) ON DELETE
  214.         SET
  215.           NULL');
  216.         $this->addSql('ALTER TABLE
  217.           channel_positioning_test_attempt_answer_selected_answers
  218.         ADD
  219.           CONSTRAINT FK_45D840D5AA334807 FOREIGN KEY (answer_id) REFERENCES channel_positioning_test_attempt_answers (id) ON DELETE CASCADE');
  220.         $this->addSql('ALTER TABLE
  221.           channel_positioning_test_attempt_answer_selected_answers
  222.         ADD
  223.           CONSTRAINT FK_45D840D5A3E60C9C FOREIGN KEY (question_answer_id) REFERENCES channel_positioning_test_question_answers (id) ON DELETE CASCADE');
  224.         $this->addSql('ALTER TABLE
  225.           channel_positioning_test_attempt_blocks
  226.         ADD
  227.           CONSTRAINT FK_DD6B04F7B191BE6B FOREIGN KEY (attempt_id) REFERENCES channel_positioning_test_attempts (id) ON DELETE CASCADE');
  228.         $this->addSql('ALTER TABLE
  229.           channel_positioning_test_attempt_blocks
  230.         ADD
  231.           CONSTRAINT FK_DD6B04F7E9ED820C FOREIGN KEY (block_id) REFERENCES channel_positioning_test_blocks (id) ON DELETE
  232.         SET
  233.           NULL');
  234.         $this->addSql('ALTER TABLE
  235.           channel_positioning_test_attempt_blocks
  236.         ADD
  237.           CONSTRAINT FK_DD6B04F7B03A8386 FOREIGN KEY (created_by_id) REFERENCES account_users (id) ON DELETE
  238.         SET
  239.           NULL');
  240.         $this->addSql('ALTER TABLE
  241.           channel_positioning_test_attempt_blocks
  242.         ADD
  243.           CONSTRAINT FK_DD6B04F7896DBBDE FOREIGN KEY (updated_by_id) REFERENCES account_users (id) ON DELETE
  244.         SET
  245.           NULL');
  246.         $this->addSql('ALTER TABLE
  247.           channel_positioning_test_attempts
  248.         ADD
  249.           CONSTRAINT FK_AEEA1A75D182060A FOREIGN KEY (prospect_id) REFERENCES channel_crm_prospects (id) ON DELETE CASCADE');
  250.         $this->addSql('ALTER TABLE
  251.           channel_positioning_test_attempts
  252.         ADD
  253.           CONSTRAINT FK_AEEA1A75F5AF274A FOREIGN KEY (positioning_test_id) REFERENCES channel_positioning_tests (id) ON DELETE
  254.         SET
  255.           NULL');
  256.         $this->addSql('ALTER TABLE
  257.           channel_positioning_test_attempts
  258.         ADD
  259.           CONSTRAINT FK_AEEA1A75B03A8386 FOREIGN KEY (created_by_id) REFERENCES account_users (id) ON DELETE
  260.         SET
  261.           NULL');
  262.         $this->addSql('ALTER TABLE
  263.           channel_positioning_test_attempts
  264.         ADD
  265.           CONSTRAINT FK_AEEA1A75896DBBDE FOREIGN KEY (updated_by_id) REFERENCES account_users (id) ON DELETE
  266.         SET
  267.           NULL');
  268.         $this->addSql('ALTER TABLE
  269.           channel_positioning_test_blocks
  270.         ADD
  271.           CONSTRAINT FK_E13EC5C672F5A1AA FOREIGN KEY (channel_id) REFERENCES channel_channels (id) ON DELETE CASCADE');
  272.         $this->addSql('ALTER TABLE
  273.           channel_positioning_test_blocks
  274.         ADD
  275.           CONSTRAINT FK_E13EC5C6B03A8386 FOREIGN KEY (created_by_id) REFERENCES account_users (id) ON DELETE
  276.         SET
  277.           NULL');
  278.         $this->addSql('ALTER TABLE
  279.           channel_positioning_test_blocks
  280.         ADD
  281.           CONSTRAINT FK_E13EC5C6896DBBDE FOREIGN KEY (updated_by_id) REFERENCES account_users (id) ON DELETE
  282.         SET
  283.           NULL');
  284.         $this->addSql('ALTER TABLE
  285.           channel_positioning_test_positioning_test_blocks
  286.         ADD
  287.           CONSTRAINT FK_7051C812F5AF274A FOREIGN KEY (positioning_test_id) REFERENCES channel_positioning_tests (id) ON DELETE CASCADE');
  288.         $this->addSql('ALTER TABLE
  289.           channel_positioning_test_positioning_test_blocks
  290.         ADD
  291.           CONSTRAINT FK_7051C812E9ED820C FOREIGN KEY (block_id) REFERENCES channel_positioning_test_blocks (id) ON DELETE CASCADE');
  292.         $this->addSql('ALTER TABLE
  293.           channel_positioning_test_question_answers
  294.         ADD
  295.           CONSTRAINT FK_D06D16D1E27F6BF FOREIGN KEY (question_id) REFERENCES channel_positioning_test_questions (id) ON DELETE CASCADE');
  296.         $this->addSql('ALTER TABLE
  297.           channel_positioning_test_question_answers
  298.         ADD
  299.           CONSTRAINT FK_D06D16DB03A8386 FOREIGN KEY (created_by_id) REFERENCES account_users (id) ON DELETE
  300.         SET
  301.           NULL');
  302.         $this->addSql('ALTER TABLE
  303.           channel_positioning_test_question_answers
  304.         ADD
  305.           CONSTRAINT FK_D06D16D896DBBDE FOREIGN KEY (updated_by_id) REFERENCES account_users (id) ON DELETE
  306.         SET
  307.           NULL');
  308.         $this->addSql('ALTER TABLE
  309.           channel_positioning_test_questions
  310.         ADD
  311.           CONSTRAINT FK_E07D59DAE9ED820C FOREIGN KEY (block_id) REFERENCES channel_positioning_test_blocks (id) ON DELETE CASCADE');
  312.         $this->addSql('ALTER TABLE
  313.           channel_positioning_test_questions
  314.         ADD
  315.           CONSTRAINT FK_E07D59DAB03A8386 FOREIGN KEY (created_by_id) REFERENCES account_users (id) ON DELETE
  316.         SET
  317.           NULL');
  318.         $this->addSql('ALTER TABLE
  319.           channel_positioning_test_questions
  320.         ADD
  321.           CONSTRAINT FK_E07D59DA896DBBDE FOREIGN KEY (updated_by_id) REFERENCES account_users (id) ON DELETE
  322.         SET
  323.           NULL');
  324.         $this->addSql('ALTER TABLE
  325.           channel_positioning_tests
  326.         ADD
  327.           CONSTRAINT FK_E24E951872F5A1AA FOREIGN KEY (channel_id) REFERENCES channel_channels (id) ON DELETE CASCADE');
  328.         $this->addSql('ALTER TABLE
  329.           channel_positioning_tests
  330.         ADD
  331.           CONSTRAINT FK_E24E9518B03A8386 FOREIGN KEY (created_by_id) REFERENCES account_users (id) ON DELETE
  332.         SET
  333.           NULL');
  334.         $this->addSql('ALTER TABLE
  335.           channel_positioning_tests
  336.         ADD
  337.           CONSTRAINT FK_E24E9518896DBBDE FOREIGN KEY (updated_by_id) REFERENCES account_users (id) ON DELETE
  338.         SET
  339.           NULL');
  340.         $this->addSql('ALTER TABLE
  341.           file_positioning_test_question
  342.         ADD
  343.           CONSTRAINT FK_FF2853CF1E27F6BF FOREIGN KEY (question_id) REFERENCES channel_positioning_test_questions (id) ON DELETE CASCADE');
  344.         $this->addSql('ALTER TABLE
  345.           file_positioning_test_question
  346.         ADD
  347.           CONSTRAINT FK_FF2853CFBF396750 FOREIGN KEY (id) REFERENCES file (id) ON DELETE CASCADE');
  348.     }
  350.     public function down(Schema $schema): void
  351.     {
  352.         // this down() migration is auto-generated, please modify it to your needs
  353.         $this->addSql('ALTER TABLE channel_crm_prospects DROP FOREIGN KEY FK_D584129F72F5A1AA');
  354.         $this->addSql('ALTER TABLE channel_crm_prospects DROP FOREIGN KEY FK_D584129FB03A8386');
  355.         $this->addSql('ALTER TABLE channel_crm_prospects DROP FOREIGN KEY FK_D584129F896DBBDE');
  356.         $this->addSql('ALTER TABLE channel_positioning_test_attempt_answers DROP FOREIGN KEY FK_2DC4DE2681F474AA');
  357.         $this->addSql('ALTER TABLE channel_positioning_test_attempt_answers DROP FOREIGN KEY FK_2DC4DE261E27F6BF');
  358.         $this->addSql('ALTER TABLE channel_positioning_test_attempt_answers DROP FOREIGN KEY FK_2DC4DE26B03A8386');
  359.         $this->addSql('ALTER TABLE channel_positioning_test_attempt_answers DROP FOREIGN KEY FK_2DC4DE26896DBBDE');
  360.         $this->addSql('ALTER TABLE
  361.           channel_positioning_test_attempt_answer_selected_answers
  362.         DROP
  363.           FOREIGN KEY FK_45D840D5AA334807');
  364.         $this->addSql('ALTER TABLE
  365.           channel_positioning_test_attempt_answer_selected_answers
  366.         DROP
  367.           FOREIGN KEY FK_45D840D5A3E60C9C');
  368.         $this->addSql('ALTER TABLE channel_positioning_test_attempt_blocks DROP FOREIGN KEY FK_DD6B04F7B191BE6B');
  369.         $this->addSql('ALTER TABLE channel_positioning_test_attempt_blocks DROP FOREIGN KEY FK_DD6B04F7E9ED820C');
  370.         $this->addSql('ALTER TABLE channel_positioning_test_attempt_blocks DROP FOREIGN KEY FK_DD6B04F7B03A8386');
  371.         $this->addSql('ALTER TABLE channel_positioning_test_attempt_blocks DROP FOREIGN KEY FK_DD6B04F7896DBBDE');
  372.         $this->addSql('ALTER TABLE channel_positioning_test_attempts DROP FOREIGN KEY FK_AEEA1A75D182060A');
  373.         $this->addSql('ALTER TABLE channel_positioning_test_attempts DROP FOREIGN KEY FK_AEEA1A75F5AF274A');
  374.         $this->addSql('ALTER TABLE channel_positioning_test_attempts DROP FOREIGN KEY FK_AEEA1A75B03A8386');
  375.         $this->addSql('ALTER TABLE channel_positioning_test_attempts DROP FOREIGN KEY FK_AEEA1A75896DBBDE');
  376.         $this->addSql('ALTER TABLE channel_positioning_test_blocks DROP FOREIGN KEY FK_E13EC5C672F5A1AA');
  377.         $this->addSql('ALTER TABLE channel_positioning_test_blocks DROP FOREIGN KEY FK_E13EC5C6B03A8386');
  378.         $this->addSql('ALTER TABLE channel_positioning_test_blocks DROP FOREIGN KEY FK_E13EC5C6896DBBDE');
  379.         $this->addSql('ALTER TABLE
  380.           channel_positioning_test_positioning_test_blocks
  381.         DROP
  382.           FOREIGN KEY FK_7051C812F5AF274A');
  383.         $this->addSql('ALTER TABLE
  384.           channel_positioning_test_positioning_test_blocks
  385.         DROP
  386.           FOREIGN KEY FK_7051C812E9ED820C');
  387.         $this->addSql('ALTER TABLE channel_positioning_test_question_answers DROP FOREIGN KEY FK_D06D16D1E27F6BF');
  388.         $this->addSql('ALTER TABLE channel_positioning_test_question_answers DROP FOREIGN KEY FK_D06D16DB03A8386');
  389.         $this->addSql('ALTER TABLE channel_positioning_test_question_answers DROP FOREIGN KEY FK_D06D16D896DBBDE');
  390.         $this->addSql('ALTER TABLE channel_positioning_test_questions DROP FOREIGN KEY FK_E07D59DAE9ED820C');
  391.         $this->addSql('ALTER TABLE channel_positioning_test_questions DROP FOREIGN KEY FK_E07D59DAB03A8386');
  392.         $this->addSql('ALTER TABLE channel_positioning_test_questions DROP FOREIGN KEY FK_E07D59DA896DBBDE');
  393.         $this->addSql('ALTER TABLE channel_positioning_tests DROP FOREIGN KEY FK_E24E951872F5A1AA');
  394.         $this->addSql('ALTER TABLE channel_positioning_tests DROP FOREIGN KEY FK_E24E9518B03A8386');
  395.         $this->addSql('ALTER TABLE channel_positioning_tests DROP FOREIGN KEY FK_E24E9518896DBBDE');
  396.         $this->addSql('ALTER TABLE file_positioning_test_question DROP FOREIGN KEY FK_FF2853CF1E27F6BF');
  397.         $this->addSql('ALTER TABLE file_positioning_test_question DROP FOREIGN KEY FK_FF2853CFBF396750');
  398.         $this->addSql('DROP TABLE channel_crm_prospects');
  399.         $this->addSql('DROP TABLE channel_positioning_test_attempt_answers');
  400.         $this->addSql('DROP TABLE channel_positioning_test_attempt_answer_selected_answers');
  401.         $this->addSql('DROP TABLE channel_positioning_test_attempt_blocks');
  402.         $this->addSql('DROP TABLE channel_positioning_test_attempts');
  403.         $this->addSql('DROP TABLE channel_positioning_test_blocks');
  404.         $this->addSql('DROP TABLE channel_positioning_test_positioning_test_blocks');
  405.         $this->addSql('DROP TABLE channel_positioning_test_question_answers');
  406.         $this->addSql('DROP TABLE channel_positioning_test_questions');
  407.         $this->addSql('DROP TABLE channel_positioning_tests');
  408.         $this->addSql('DROP TABLE file_positioning_test_question');
  409.     }
  410. }