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. }