migrations/Version20220206100125.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 Version20220206100125 extends AbstractMigration
  14. {
  15. public function getDescription(): string
  16. {
  17. return '';
  18. }
  20. public function up(Schema $schema): void
  21. {
  22. $this->addSql('ALTER TABLE exams ADD allowed_resources VARCHAR(255) DEFAULT NULL AFTER paper_only');
  23. $this->addSql("UPDATE exams SET allowed_resources='Blank paper allowed, student may choose to write answers on this paper' WHERE id = 5");
  24. $this->addSql("UPDATE exams SET allowed_resources='Blank paper allowed, student may choose to write answers on this paper' WHERE id = 6");
  25. $this->addSql("UPDATE exams SET allowed_resources='Blank paper allowed, student may choose to write answers on this paper' WHERE id = 17");
  26. $this->addSql("UPDATE exams SET allowed_resources='Blank paper allowed, student may choose to write answers on this paper' WHERE id = 18");
  27. $this->addSql("UPDATE exams SET allowed_resources='Blank paper allowed, student may choose to write answers on this paper' WHERE id = 15");
  28. $this->addSql("UPDATE exams SET allowed_resources='Blank paper allowed, student may choose to write answers on this paper' WHERE id = 16");
  29. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 35");
  30. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 41");
  31. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 149");
  32. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 140");
  33. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 144");
  34. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 151");
  35. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 188");
  36. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 38");
  37. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 43");
  38. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 150");
  39. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 141");
  40. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 145");
  41. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 152");
  42. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 189");
  43. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 36");
  44. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 42");
  45. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 138");
  46. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 142");
  47. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 146");
  48. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 153");
  49. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 155");
  50. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 190");
  51. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 245");
  52. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 279");
  53. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 39");
  54. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 44");
  55. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 139");
  56. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 143");
  57. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 147");
  58. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 154");
  59. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 156");
  60. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 191");
  61. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 192");
  62. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 246");
  63. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 37");
  64. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 73");
  65. $this->addSql("UPDATE exams SET allowed_resources='Student may open and print the PDF which is available once the exam is started.' WHERE id = 40");
  66. $this->addSql("UPDATE exams SET allowed_resources='Blank paper allowed, student may choose to write answers on this paper' WHERE id = 32");
  67. $this->addSql("UPDATE exams SET allowed_resources='Blank paper allowed, student may choose to write answers on this paper' WHERE id = 33");
  68. $this->addSql("UPDATE exams SET allowed_resources='Blank paper allowed, student may choose to write answers on this paper' WHERE id = 30");
  69. $this->addSql("UPDATE exams SET allowed_resources='Blank paper allowed, student may choose to write answers on this paper' WHERE id = 31");
  70. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; student may open Excel' WHERE id = 280");
  71. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; student may open Excel' WHERE id = 281");
  72. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; student may open Excel' WHERE id = 393");
  73. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; student may open Excel' WHERE id = 290");
  74. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; student may open Excel' WHERE id = 394");
  75. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; student may open Excel' WHERE id = 395");
  76. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; student may open Excel' WHERE id = 396");
  77. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 200");
  78. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 204");
  79. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 202");
  80. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 285");
  81. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 282");
  82. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 277");
  83. $this->addSql("UPDATE exams SET allowed_resources='Calculator, scrap paper, open notes and Coopersmith study materials allowed' WHERE id = 239");
  84. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 380");
  85. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 311");
  86. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 249");
  87. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 379");
  88. $this->addSql("UPDATE exams SET allowed_resources='Calculator, scrap paper and open notes allowed' WHERE id = 391");
  89. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 310");
  90. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 309");
  91. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 296");
  92. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 314");
  93. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 205");
  94. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 318");
  95. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 232");
  96. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 305");
  97. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 381");
  98. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 306");
  99. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 308");
  100. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 307");
  101. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 236");
  102. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 237");
  103. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 388");
  104. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 389");
  105. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 254");
  106. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 390");
  107. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 196");
  108. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 195");
  109. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 201");
  110. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 197");
  111. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 264");
  112. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; student may open Excel' WHERE id = 288");
  113. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 303");
  114. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 319");
  115. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; open book exam' WHERE id = 234");
  116. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; open book exam' WHERE id = 235");
  117. $this->addSql("UPDATE exams SET allowed_resources='Non-graphing calculator and scrap paper allowed' WHERE id = 193");
  118. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; student may open Excel' WHERE id = 194");
  119. $this->addSql("UPDATE exams SET allowed_resources='Non-graphing calculator and scrap paper allowed' WHERE id = 213");
  120. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; student may open Excel' WHERE id = 265");
  121. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; student may open Excel' WHERE id = 313");
  122. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; student may open Excel' WHERE id = 289");
  123. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; student may open Excel' WHERE id = 315");
  124. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 312");
  125. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 214");
  126. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 217");
  127. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 215");
  128. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 283");
  129. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 219");
  130. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 226");
  131. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 225");
  132. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 386");
  133. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 378");
  134. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 210");
  135. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 203");
  136. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 199");
  137. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 198");
  138. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 240");
  139. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 248");
  140. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 261");
  141. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; open book exam' WHERE id = 257");
  142. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; open book exam' WHERE id = 258");
  143. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; open book exam' WHERE id = 259");
  144. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 263");
  145. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 216");
  146. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 392");
  147. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 231");
  148. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 224");
  149. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 220");
  150. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 221");
  151. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; student may open Word' WHERE id = 209");
  152. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed; student may open Powerpoint' WHERE id = 208");
  153. $this->addSql("UPDATE exams SET allowed_resources='Calculator, scrap paper and open notes allowed; student may open Excel' WHERE id = 207");
  154. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 206");
  155. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 262");
  156. $this->addSql("UPDATE exams SET allowed_resources='Calculator and scrap paper allowed' WHERE id = 385");
  157. $this->addSql("UPDATE exams SET allowed_resources='Calculator allowed' WHERE id = 332");
  158. $this->addSql("UPDATE exams SET allowed_resources='Calculator allowed' WHERE id = 353");
  159. $this->addSql("UPDATE exams SET allowed_resources='Calculator allowed' WHERE id = 375");
  160. $this->addSql("UPDATE exams SET allowed_resources='Calculator allowed' WHERE id = 333");
  161. }
  163. public function down(Schema $schema): void
  164. {
  165. $this->addSql('ALTER TABLE exams DROP allowed_resources');
  166. }
  167. }