<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
final class Version20240203185538 extends AbstractMigration
{
public function getDescription(): string
{
return '';
}
public function up(Schema $schema): void
{
// this up() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE submission CHANGE civility civility VARCHAR(255) DEFAULT NULL, CHANGE fname fname VARCHAR(255) DEFAULT NULL, CHANGE lname lname VARCHAR(255) DEFAULT NULL, CHANGE nationality nationality VARCHAR(255) DEFAULT NULL, CHANGE currentaddress currentaddress VARCHAR(255) DEFAULT NULL, CHANGE cellphone cellphone VARCHAR(255) DEFAULT NULL, CHANGE livingcountry livingcountry VARCHAR(255) DEFAULT NULL, CHANGE livingcity livingcity VARCHAR(255) DEFAULT NULL, CHANGE baccalaureatestatus baccalaureatestatus VARCHAR(255) DEFAULT NULL, CHANGE identity identity VARCHAR(255) DEFAULT NULL, CHANGE massar massar VARCHAR(255) DEFAULT NULL, CHANGE region region VARCHAR(255) DEFAULT NULL, CHANGE cellphonealt cellphonealt VARCHAR(255) DEFAULT NULL, CHANGE lastschoolcity lastschoolcity VARCHAR(255) DEFAULT NULL, CHANGE lastschoolcountry lastschoolcountry VARCHAR(255) DEFAULT NULL, CHANGE lastschooltimingstart lastschooltimingstart VARCHAR(255) DEFAULT NULL, CHANGE educationalsystem educationalsystem VARCHAR(255) DEFAULT NULL, CHANGE educationalsystemtype educationalsystemtype VARCHAR(255) DEFAULT NULL, CHANGE studymodality studymodality VARCHAR(255) DEFAULT NULL, CHANGE sector sector VARCHAR(255) DEFAULT NULL, CHANGE notes1 notes1 VARCHAR(255) DEFAULT NULL, CHANGE notes2 notes2 VARCHAR(255) DEFAULT NULL, CHANGE notes3 notes3 VARCHAR(255) DEFAULT NULL, CHANGE regionalexam regionalexam VARCHAR(255) DEFAULT NULL, CHANGE obtainedate obtainedate VARCHAR(255) DEFAULT NULL, CHANGE baccalaureatenote baccalaureatenote VARCHAR(255) DEFAULT NULL, CHANGE othertraining othertraining VARCHAR(255) DEFAULT NULL, CHANGE englishtest englishtest VARCHAR(255) DEFAULT NULL, CHANGE nationalschoolreport nationalschoolreport VARCHAR(255) DEFAULT NULL, CHANGE regionalschoolreport regionalschoolreport VARCHAR(255) DEFAULT NULL, CHANGE lastschool lastschool VARCHAR(255) DEFAULT NULL, CHANGE reference reference VARCHAR(255) NOT NULL, CHANGE notes4 notes4 VARCHAR(255) DEFAULT NULL, CHANGE notes5 notes5 VARCHAR(255) DEFAULT NULL, CHANGE notes6 notes6 VARCHAR(255) DEFAULT NULL, CHANGE notes7 notes7 VARCHAR(255) DEFAULT NULL, CHANGE notes8 notes8 VARCHAR(255) DEFAULT NULL, CHANGE notes9 notes9 VARCHAR(255) DEFAULT NULL, CHANGE lastschooltimingend lastschooltimingend VARCHAR(255) DEFAULT NULL, CHANGE profile profile VARCHAR(255) DEFAULT NULL, CHANGE identification identification VARCHAR(255) DEFAULT NULL, CHANGE languagespokenathome languagespokenathome VARCHAR(255) DEFAULT NULL, CHANGE languagespokenathomeothers languagespokenathomeothers VARCHAR(255) DEFAULT NULL, CHANGE academicintrests academicintrests VARCHAR(255) DEFAULT NULL, CHANGE zipcode zipcode VARCHAR(255) DEFAULT NULL, CHANGE cellphonetype cellphonetype VARCHAR(255) DEFAULT NULL, CHANGE cellphonealttype cellphonealttype VARCHAR(255) DEFAULT NULL, CHANGE email email VARCHAR(255) DEFAULT NULL, CHANGE signature signature VARCHAR(255) DEFAULT NULL, CHANGE source source VARCHAR(255) DEFAULT NULL, CHANGE othersource othersource VARCHAR(255) DEFAULT NULL, CHANGE dualnationality dualnationality VARCHAR(255) DEFAULT NULL, CHANGE status status VARCHAR(255) NOT NULL, CHANGE subscribeto subscribeto VARCHAR(255) NOT NULL, CHANGE bacnote bacnote VARCHAR(255) DEFAULT NULL, CHANGE othersector othersector VARCHAR(255) DEFAULT NULL, CHANGE applicationcountry applicationcountry VARCHAR(255) DEFAULT NULL, CHANGE applicationsector applicationsector VARCHAR(255) DEFAULT NULL, CHANGE frenshsector frenshsector VARCHAR(255) DEFAULT NULL, CHANGE otherlastschool otherlastschool VARCHAR(255) DEFAULT NULL, CHANGE noteadmission noteadmission VARCHAR(255) DEFAULT NULL, CHANGE booked_language booked_language VARCHAR(255) DEFAULT NULL, CHANGE note_english note_english VARCHAR(255) DEFAULT NULL, CHANGE notephilosophy notephilosophy VARCHAR(255) DEFAULT NULL, CHANGE noteoral noteoral VARCHAR(255) DEFAULT NULL, CHANGE cv cv VARCHAR(255) DEFAULT NULL, CHANGE motivation_letter motivation_letter VARCHAR(255) DEFAULT NULL, CHANGE seasion seasion VARCHAR(255) NOT NULL, CHANGE birth_country birth_country VARCHAR(255) DEFAULT NULL, CHANGE birth_city birth_city VARCHAR(255) DEFAULT NULL, CHANGE currentschool currentschool VARCHAR(255) DEFAULT NULL, CHANGE othercurrentschool othercurrentschool VARCHAR(255) DEFAULT NULL, CHANGE grade grade VARCHAR(255) DEFAULT NULL, CHANGE othergrade othergrade VARCHAR(255) DEFAULT NULL, CHANGE enrolment_proof enrolment_proof VARCHAR(255) DEFAULT NULL, CHANGE studies studies VARCHAR(255) DEFAULT NULL, CHANGE preferred_language preferred_language VARCHAR(255) DEFAULT NULL, CHANGE study study VARCHAR(255) DEFAULT NULL, CHANGE comfortable_language comfortable_language VARCHAR(255) DEFAULT NULL, CHANGE comfortable_languageothers comfortable_languageothers VARCHAR(255) DEFAULT NULL, CHANGE maritalstatus maritalstatus VARCHAR(255) DEFAULT NULL, CHANGE openposition openposition VARCHAR(255) DEFAULT NULL, CHANGE mobility mobility VARCHAR(255) DEFAULT NULL');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE submission CHANGE profile profile TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE educationalsystem educationalsystem TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE educationalsystemtype educationalsystemtype TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE studymodality studymodality TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE sector sector TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE notes1 notes1 TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE notes2 notes2 TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE notes3 notes3 TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE notes4 notes4 TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE notes5 notes5 TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE notes6 notes6 TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE notes7 notes7 TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE notes8 notes8 TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE notes9 notes9 TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE regionalexam regionalexam TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE baccalaureatestatus baccalaureatestatus TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE obtainedate obtainedate TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE baccalaureatenote baccalaureatenote TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE othertraining othertraining TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE englishtest englishtest TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE nationalschoolreport nationalschoolreport TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE regionalschoolreport regionalschoolreport TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE identity identity TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE reference reference TEXT CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE identification identification TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE languagespokenathome languagespokenathome TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE languagespokenathomeothers languagespokenathomeothers TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE academicintrests academicintrests TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE zipcode zipcode TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE cellphonetype cellphonetype TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE cellphonealttype cellphonealttype TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE email email TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE signature signature TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE source source TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE othersource othersource TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE dualnationality dualnationality TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE status status TEXT CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE subscribeto subscribeto TEXT CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE bacnote bacnote TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE othersector othersector TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE applicationcountry applicationcountry TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE applicationsector applicationsector TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE frenshsector frenshsector TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE otherlastschool otherlastschool TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE noteadmission noteadmission TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE booked_language booked_language TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE note_english note_english TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE notephilosophy notephilosophy TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE noteoral noteoral TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE cv cv TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE motivation_letter motivation_letter TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE seasion seasion TEXT CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE grade grade TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE othergrade othergrade TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE enrolment_proof enrolment_proof TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE studies studies TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE preferred_language preferred_language TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE study study TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE comfortable_language comfortable_language TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE comfortable_languageothers comfortable_languageothers TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE maritalstatus maritalstatus TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE openposition openposition TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE mobility mobility TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE massar massar TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE civility civility TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE fname fname TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE lname lname TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE birth_country birth_country TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE birth_city birth_city TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE nationality nationality TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE currentaddress currentaddress TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE region region TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE livingcity livingcity TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE livingcountry livingcountry TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE cellphone cellphone TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE cellphonealt cellphonealt TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE currentschool currentschool TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE othercurrentschool othercurrentschool TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE lastschool lastschool TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE lastschoolcity lastschoolcity TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE lastschoolcountry lastschoolcountry TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE lastschooltimingstart lastschooltimingstart TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`, CHANGE lastschooltimingend lastschooltimingend TEXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`');
}
}