migrations/Version20220329065831.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 Version20220329065831 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("DELETE FROM exam_study_materials where exam_id IN (SELECT id FROM exams WHERE vendor_id = 4)");
  24.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (362,'https://cistesting.org/wp-content/uploads/2022/03/Microeconomics-Practice-Exam.pdf'), (362,'https://cistesting.org/wp-content/uploads/2022/01/CIS-Microeconomics-Presentation-part-1.pptx'), (362,'https://cistesting.org/wp-content/uploads/2022/01/CIS-Microeconomics-Presentation-part-2.pptx')");
  25.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (336,'https://cistesting.org/wp-content/uploads/2022/03/Early-Childhood-Curriculum-Study-Guide.pdf'), (336,'https://cistesting.org/wp-content/uploads/2022/03/Early-Childhood-Curriculum-PowerPoint.pptx')");
  26.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (286,'https://cistesting.org/wp-content/uploads/2022/03/Family-School-and-Community-Collaboration-Practice-Exam.pdf'), (286,'https://cistesting.org/wp-content/uploads/2022/03/Family-School-and-Community-Collaboration-Presentation-for-Print.pdf')");
  27.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (329,'https://cistesting.org/wp-content/uploads/2022/03/Assessment-in-Early-Childhood-Education-Study-Guide.pdf'), (329,'https://cistesting.org/wp-content/uploads/2022/03/Assessment-in-Early-Childhood-Education-PowerPoint.pptx')");
  28.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (287,'https://cistesting.org/wp-content/uploads/2022/03/Teaching-Adolescents-Study-Guide.pdf'), (287,'https://cistesting.org/wp-content/uploads/2022/03/Teaching-Adolescents-PowerPoint.pptx')");
  29.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (343,'https://cistesting.org/wp-content/uploads/2022/03/Foundations-of-Education-Study-Guide.pdf'), (343,'https://cistesting.org/wp-content/uploads/2022/03/Foundations-of-Education-PowerPoint.pptx')");
  30.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (324,'https://cistesting.org/wp-content/uploads/2022/03/Adapting-Curricula-Study-Guide.pdf'), (324,'https://cistesting.org/wp-content/uploads/2022/03/Adapting-Curricula-PowerPoint.pptx')");
  31.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (361,'https://cistesting.org/wp-content/uploads/2022/03/Managing-the-Environment-PowerPoint.pptx'), (361,'https://cistesting.org/wp-content/uploads/2022/03/Managing-the-Environment-Study-Guide.pdf')");
  32.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (377,'https://cistesting.org/wp-content/uploads/2022/03/Exceptional-Child-Study-Guide.pdf'), (377,'https://cistesting.org/wp-content/uploads/2022/03/Exceptional-Child-PowerPoint-1.pptx')");
  33.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (297,'https://cistesting.org/wp-content/uploads/2022/03/Literary-Instruction-for-Secondary-Education-Study-Guide.pdf'), (297,'https://cistesting.org/wp-content/uploads/2022/03/Literary-Instruction-for-Secondary-Education-PowerPoint-1.pptx')");
  34.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (338,'https://cistesting.org/wp-content/uploads/2022/03/English-Composition-I-Assignments-Packet.pdf'), (338,'https://cistesting.org/wp-content/uploads/2022/03/English-Composition-I-Writing-Study-Guide.pdf')");
  35.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (339,'https://cistesting.org/wp-content/uploads/2022/03/CIS-English-Composition-II-Assignments-Packet.pdf'), (339,'https://cistesting.org/wp-content/uploads/2022/03/CIS-English-Composition-II-Writing-Guide.pdf')");
  36.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (348,'https://cistesting.org/wp-content/uploads/2022/03/Information-Literacy-PowerPoint.pptx'), (348,'https://cistesting.org/wp-content/uploads/2022/03/Information-Literacy-Study-Guide.pdf')");
  37.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (369,'https://cistesting.org/wp-content/uploads/2022/03/Principles-of-Health-Promotion-and-Education-Practice-Paper-1.pdf'), (369,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Principles-of-Health-Promotion-and-Education-Presentation-1.pptx')");
  38.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (327,'https://cistesting.org/wp-content/uploads/2022/03/American-Civil-War-and-Reconstruction-Practice-Exam-1.pdf'), (327,'https://cistesting.org/wp-content/uploads/2022/03/CIS-American-Civil-War-and-Reconstruction-Presentation-1.pdf'), (327,'https://cistesting.org/wp-content/uploads/2022/03/CIS-American-Civil-War-and-Reconstruction-Assignments-Guide-1.pdf')");
  39.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (346,'https://cistesting.org/wp-content/uploads/2022/03/CIS-History-of-Women-in-America-Practice-Exam.pdf'), (346,'https://cistesting.org/wp-content/uploads/2022/03/CIS-History-of-Women-in-America-Presentation.pdf'), (346,'https://cistesting.org/wp-content/uploads/2022/03/CIS-History-of-Women-in-America-Assignments-Guide.pdf')");
  40.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (332,'https://cistesting.org/wp-content/uploads/2022/03/College-Algebra-Practice-Exam.pdf'), (332,'https://cistesting.org/wp-content/uploads/2022/03/College-Algebra-Section-1-Presentation.pptx'), (332,'https://cistesting.org/wp-content/uploads/2022/03/College-Algebra-Section-2-Presentation.pptx'), (332,'https://cistesting.org/wp-content/uploads/2022/03/College-Algebra-Section-3-Presentation.pptx'), (332,'https://cistesting.org/wp-content/uploads/2022/03/College-Algebra-Section-4-Presentation.pptx')");
  41.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (353,'https://cistesting.org/wp-content/uploads/2022/03/Introduction-to-Geometry-Practice-Exam.pdf'), (353,'https://cistesting.org/wp-content/uploads/2022/03/Introduction-to-Geometry-Section-1-Presentation.pptx'), (353,'https://cistesting.org/wp-content/uploads/2022/03/Introduction-to-Geometry-Section-2-Presentation.pptx'), (353,'https://cistesting.org/wp-content/uploads/2022/03/Introduction-to-Geometry-Section-3-Presentation.pptx'), (353,'https://cistesting.org/wp-content/uploads/2022/03/Introduction-to-Geometry-Section-4-Presentation.pptx')");
  42.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (375,'https://cistesting.org/wp-content/uploads/2022/03/Statistics-Practice-Exam.pdf'), (375,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Statistics-Section-1-Presentation-1.pptx'), (375,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Statistics-Section-2-Presentation-1.pptx'), (375,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Statistics-Section-3-Presentation-1.pptx')");
  43.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (333,'https://cistesting.org/wp-content/uploads/2022/03/College-Mathematics-Practice-Exam.pdf'), (333,'https://cistesting.org/wp-content/uploads/2022/03/College-Mathematics-PowerPoint.pptx'), (333,'https://cistesting.org/wp-content/uploads/2022/03/College-Mathematics-Study-Guide.pdf')");
  44.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (328,'https://cistesting.org/wp-content/uploads/2022/03/American-Government-Practice-Paper-1.pdf'), (328,'https://cistesting.org/wp-content/uploads/2022/03/CIS-American-Government-Presentation-1.pdf')");
  45.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (355,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Introduction-to-Psychology-Practice-Exam.pdf'), (355,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Introduction-to-Psychology-Presentation.pdf')");
  46.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (347,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Human-Growth-and-Development-Practice-Exam.pdf'), (347,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Human-Growth-and-Development-Presentation.pdf')");
  47.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (372,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Research-in-Psychology-Practice-Exam.pdf'), (372,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Research-in-Psychology-Presentation.pdf')");
  48.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (321,'https://cistesting.org/wp-content/uploads/2022/03/Abnormal-Psychology-Practice-Exam-1.pdf'), (321,'https://cistesting.org/wp-content/uploads/2022/03/Abnormal-Psychology-Presentation-1.pdf'), (321,'https://cistesting.org/wp-content/uploads/2022/03/Abnormal-Psychology-Assignments-Guide-1.pdf'), (321,'https://cistesting.org/wp-content/uploads/2022/03/Abnormal-Psychology-Sample-Assignment-1-1.pdf'), (321,'https://cistesting.org/wp-content/uploads/2022/03/Abnormal-Psychology-Sample-Assignment-2.pdf')");
  49.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (367,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Physiological-Psychology-Practice-Exam.pdf'), (367,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Physiological-Psychology-Presentation.pdf'), (367,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Physiological-Psychology-Assignments-Guide.pdf'), (367,'https://cistesting.org/wp-content/uploads/2022/03/Physiological-Psychology-Sample-Assignments.pdf')");
  50.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (337,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Educational-Psychology-Practice-Exam.pdf'), (337,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Educational-Psychology-Presentation.pdf')");
  51.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (345,'https://cistesting.org/wp-content/uploads/2022/03/History-and-Systems-of-Psychology-Practice-Exam.pdf'), (345,'https://cistesting.org/wp-content/uploads/2022/03/History-and-Systems-of-Psychology-Powerpoint.pdf'), (345,'https://cistesting.org/wp-content/uploads/2022/03/History-and-Systems-of-Psychology-Assignments-Guide.pdf'), (345,'https://cistesting.org/wp-content/uploads/2022/03/History-and-Systems-of-Psychology-Sample-Assignments.pdf')");
  52.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (342,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Foundations-of-Earth-Science-Practice-Exam.pdf'), (342,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Foundations-of-Earth-Science-Presentation.pdf')");
  53.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (351,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Introduction-to-Biology-Practice-Exam.pdf'), (351,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Introduction-to-Biology-Presentation.pdf'), (351,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Introduction-to-Biology-Review-Terms-Worksheet.pdf')");
  54.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (356,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Introduction-to-Sociology-Practice-Exam.pdf'), (356,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Introduction-to-Sociology-Presentation.pdf')");
  55.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (335,'https://cistesting.org/wp-content/uploads/2022/03/Culinary-Arts-Techniques-Practice-Exam-2.pdf'), (335,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Culinary-Arts-Techniques-Presentation-2.pdf'), (335,'https://cistesting.org/wp-content/uploads/2022/03/Culinary-Arts-Techniques-Assignments-Guide-2.pdf')");
  56.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (374,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Sociology-of-Jewish-Food-Practice-Exam.pdf'), (374,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Sociology-of-Jewish-Food-Presentation.pdf')");
  57.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (344,'https://cistesting.org/wp-content/uploads/2022/03/Fundamentals-of-Management-Practice-Exam.pdf'), (344,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Fundamentals-of-Management-Presentation.pptx')");
  58.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (331,'https://cistesting.org/wp-content/uploads/2022/03/Business-Writing-Assignments-Guide.pdf'), (331,'https://cistesting.org/wp-content/uploads/2022/03/Business-Writing-Assignments-Packet.pdf')");
  59.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (349,'https://cistesting.org/wp-content/uploads/2022/03/International-Business-Practice-Exam.pdf'), (349,'https://cistesting.org/wp-content/uploads/2022/03/International-Business-Powerpoint.pdf')");
  60.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (354,'https://cistesting.org/wp-content/uploads/2022/03/Introduction-to-Marketing-Practice-Exam-1.pdf'), (354,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Introduction-to-Marketing-Presentation-1.pptx')");
  61.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (357,'https://cistesting.org/wp-content/uploads/2022/03/The-Law-of-Business-and-Business-Organizations-Study-Guide.pdf'), (357,'https://cistesting.org/wp-content/uploads/2022/03/The-Law-of-Business-and-Business-Organizations-PowerPoint.pptx')");
  62.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (366,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Organizational-Behavior-Practice-Exam.pdf'), (366,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Organizational-Behavior-Presentation-for-Print.pdf')");
  63.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (330,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Business-Communications-Practice-Exam.pdf'), (330,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Business-Communications-Presentation-for-print.pdf'), (330,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Business-Communications-Final-Presentation-Guide.pdf'), (330,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Business-Communications-Sample-Final-Presentation.pptx')");
  64.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (352,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Introduction-to-Business-Practice-Exam-1.pdf'), (352,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Introduction-to-Business-Presentation-for-Print-1.pdf')");
  65.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (370,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Principles-of-Supervision-Practice-Test.pdf'), (370,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Principles-of-Supervision-Presentation-for-print.pdf')");
  66.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (322,'https://cistesting.org/wp-content/uploads/2022/03/Accounting-I-Practice-Exam-1.pdf'), (322,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Accounting-I-Presentation-1.pptx')");
  67.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (323,'https://cistesting.org/wp-content/uploads/2022/03/Accounting-II-Practice-Paper-1.pdf'), (323,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Accounting-II-Presentation-1.pptx')");
  68.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (326,'https://cistesting.org/wp-content/uploads/2022/03/Advanced-Financial-Management-Study-Guide.pdf'), (326,'https://cistesting.org/wp-content/uploads/2022/03/Advanced-Financial-Management-PowerPoint.pptx')");
  69.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (341,'https://cistesting.org/wp-content/uploads/2022/03/Financial-Markets-and-Institutions-Study-Guide.pdf'), (341,'https://cistesting.org/wp-content/uploads/2022/03/Financial-Markets-and-Institutions-PowerPoint.pptx')");
  70.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (373,'https://cistesting.org/wp-content/uploads/2022/03/Securities-Analysis-Study-Guide-1.pdf'), (373,'https://cistesting.org/wp-content/uploads/2022/03/Securities-Analysis-PowerPoint-1.pptx')");
  71.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (350,'https://cistesting.org/wp-content/uploads/2022/03/International-finance-Practice-Exam-2.pdf'), (350,'https://cistesting.org/wp-content/uploads/2022/03/CIS-International-Finance-Presentation-2.pptx'), (350,'https://cistesting.org/wp-content/uploads/2022/03/International-Finance-Assignments-Guide-2.pdf')");
  72.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (368,'https://cistesting.org/wp-content/uploads/2022/03/Principles-of-Finance-Practice-Exam-1.pdf'), (368,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Principles-of-Finance-Presentation-1.pptx'), (368,'https://cistesting.org/wp-content/uploads/2022/03/Principles-of-Finance-Assignments-Guide-1.pdf')");
  73.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (334,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Computing-and-Design-Practice-Exam.pdf'), (334,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Computing-and-Design-presentation-for-print.pdf'), (334,'https://cistesting.org/wp-content/uploads/2022/03/Computing-and-Design-Worksheet.pdf')");
  74.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (365,'https://cistesting.org/wp-content/uploads/2022/03/Microsoft-Word-Practice-Exam.pdf'), (365,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Microsoft-Word-Presentation.pptx')");
  75.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (363,'https://cistesting.org/wp-content/uploads/2022/03/Microsoft-Excel-Study-Guide.pdf'), (363,'https://cistesting.org/wp-content/uploads/2022/03/Microsoft-Excel-PowerPoint.pptx')");
  76.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (364,'https://cistesting.org/wp-content/uploads/2022/03/Microsoft-Powerpoint-Study-Guide.pdf'), (364,'https://cistesting.org/wp-content/uploads/2022/03/Microsoft-Powerpoint-PowerPoint.pptx')");
  77.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (360,'https://cistesting.org/wp-content/uploads/2022/03/Management-Information-Systems-Practice-Exam-1.pdf'), (360,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Management-Information-Systems-Presentation-1.pptx')");
  78.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (371,'https://cistesting.org/wp-content/uploads/2022/03/Public-Speaking-and-Presentations-Guide.pdf')");
  79.         $this->addSql("INSERT INTO exam_study_materials (exam_id, url) values (359,'https://cistesting.org/wp-content/uploads/2022/03/Macroeconomics-Practice-Exam.pdf'), (359,'https://cistesting.org/wp-content/uploads/2022/03/CIS-Macroeconomics-Presentation-for-print.pdf')");
  80.     }
  82.     public function down(Schema $schema): void
  83.     {
  84.         // this down() migration is auto-generated, please modify it to your needs
  86.     }
  87. }