migrations/Version20221218073250.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 Version20221218073250 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 `seminary_testing_students` (
  24. `id` INT NOT NULL AUTO_INCREMENT,
  25. `firstName` VARCHAR(45) NULL,
  26. `lastName` VARCHAR(45) NULL,
  27. `email` VARCHAR(100) NULL,
  28. `ssn` VARCHAR(20) NULL,
  29. `dob` DATE NULL,
  30. `seminary_id` INT NULL,
  31. `tal_guid` VARCHAR(255) NULL,
  32. `created_date` DATE NULL,
  33. `created_by` VARCHAR(100) NULL,
  34. PRIMARY KEY (`id`));
  35. ");
  38. $this->addSql("CREATE TABLE `seminary_testing_student_exams` (
  39. `id` INT NOT NULL AUTO_INCREMENT,
  40. `student_id` INT NULL,
  41. `exam_id` INT NULL,
  42. `exam_taken_date` DATETIME NULL,
  43. `created_date` DATETIME NULL,
  44. PRIMARY KEY (`id`));");
  46. $this->addSql("ALTER TABLE `seminaries`
  47. ADD COLUMN `for_seminary_testing` TINYINT NULL DEFAULT 0 AFTER `name`;");
  49. $this->addSql("ALTER TABLE `exams`
  50. ADD COLUMN `for_seminary_testing` TINYINT NULL DEFAULT 0 AFTER `assignments`;");
  51. }
  53. public function down(Schema $schema): void
  54. {
  55. // this down() migration is auto-generated, please modify it to your needs
  56. $this->addSql("drop table seminary_testing_students");
  57. $this->addSql("drop table seminary_testing_student_exams");
  58. $this->addSql("ALTER TABLE `seminaries` drop COLUMN `for_seminary_testing`");
  59. $this->addSql("ALTER TABLE `exams` drop COLUMN `for_seminary_testing`;");
  60. }
  61. }