migrations/Version20240104081237.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 Version20240104081237 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 woodmont_student_status (
  24.                                 id INT AUTO_INCREMENT NOT NULL, 
  25.                                 student_id INT NOT NULL, 
  26.                                 type VARCHAR(50) NOT NULL, 
  27.                                 name VARCHAR(50) NOT NULL, 
  28.                                 status VARCHAR(50) NOT NULL, 
  29.                                 status_date DATE DEFAULT NULL, 
  30.                                 institution1 VARCHAR(100) DEFAULT NULL, 
  31.                                 transcript1 TINYINT(1) DEFAULT NULL, 
  32.                                 official1 TINYINT(1) DEFAULT NULL, 
  33.                                 institution2 VARCHAR(100) DEFAULT NULL, 
  34.                                 transcript2 TINYINT(1) DEFAULT NULL, 
  35.                                 official2 TINYINT(1) DEFAULT NULL, 
  36.                                 institution3 VARCHAR(100) DEFAULT NULL, 
  37.                                 transcript3 TINYINT(1) DEFAULT NULL, 
  38.                                 official3 TINYINT(1) DEFAULT NULL, 
  39.                                 unofficial_hs_transcript TINYINT(1) DEFAULT NULL, 
  40.                                 official_hs_transcript TINYINT(1) DEFAULT NULL, 
  41.                                 photo_id TINYINT(1) DEFAULT NULL, 
  42.                                 personal_statement TINYINT(1) DEFAULT NULL, 
  43.                                 deans_letter TINYINT(1) DEFAULT NULL, 
  44.                                 credits_earned_td DOUBLE PRECISION NOT NULL, 
  45.                                 transfer_credits DOUBLE PRECISION NOT NULL, 
  46.                                 payment_complete TINYINT(1) DEFAULT NULL, 
  47.                                 preliminary_review TINYINT(1) DEFAULT NULL, 
  48.                                 total_payments DOUBLE PRECISION DEFAULT NULL, 
  49.                                 enrolled_status_date DATE DEFAULT NULL, 
  50.                                 tti_received_credit_package DATE DEFAULT NULL, 
  51.                                 payment_complete_date DATE DEFAULT NULL, 
  52.                                 woodmont_invoice_number INT DEFAULT NULL, 
  53.                                 woodmont_invoice_sent DATE DEFAULT NULL, 
  54.                                 woodmont_invoice_paid DATE DEFAULT NULL, 
  55.                                 tti_recorded_graduation TINYINT(1) DEFAULT NULL, 
  56.                                 woodmont_promotion_may2023 TINYINT(1) DEFAULT NULL, 
  57.                                 credit_package_type VARCHAR(15) DEFAULT NULL, 
  58.                                 academic_policy_year INT DEFAULT NULL, 
  59.                                 PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  60.     }
  62.     public function down(Schema $schema): void
  63.     {
  64.         $this->addSql('DROP TABLE woodmont_student_status');
  65.     }
  66. }