Code Duplication - OpenConext/Stepup-Middleware - Measure and Improve Code Quality continuously with Scrutinizer


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141031144721 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('CREATE TABLE identity (name_id VARCHAR(255) NOT NULL, PRIMARY KEY(name_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('DROP TABLE identity');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141119093423 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE unverified_second_factor ADD verification_code_nonce VARCHAR(64) NOT NULL, ADD email_verified TINYINT(1) NOT NULL');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE unverified_second_factor DROP verification_code_nonce, DROP email_verified');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141119113444 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE unverified_second_factor CHANGE verification_code_nonce email_verification_code_nonce VARCHAR(64) NOT NULL');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE unverified_second_factor CHANGE email_verification_code_nonce verification_code_nonce VARCHAR(64) NOT NULL');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141119113553 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE unverified_second_factor CHANGE email_verification_code_nonce email_verification_code_nonce VARCHAR(64) DEFAULT NULL');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE unverified_second_factor CHANGE email_verification_code_nonce email_verification_code_nonce VARCHAR(64) NOT NULL');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141120150430 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE unverified_second_factor CHANGE email_verification_code_nonce email_verification_nonce VARCHAR(64) DEFAULT NULL');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE unverified_second_factor CHANGE email_verification_nonce email_verification_code_nonce VARCHAR(64) DEFAULT NULL');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141120152310 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE unverified_second_factor DROP email_verification_nonce');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE unverified_second_factor ADD email_verification_nonce VARCHAR(64) DEFAULT NULL');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141125154133 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE unverified_second_factor ADD email_verification_nonce VARCHAR(32) NOT NULL');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE unverified_second_factor DROP email_verification_nonce');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141125154214 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE identity CHANGE institution institution VARCHAR(255) NOT NULL');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE identity CHANGE institution institution VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141125155001 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE unverified_second_factor DROP email_verified');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE unverified_second_factor ADD email_verified TINYINT(1) NOT NULL');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141128143946 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE identity CHANGE institution institution VARCHAR(255) NOT NULL');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE identity CHANGE institution institution VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141204140639 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE verified_second_factor ADD registration_code VARCHAR(8) NOT NULL');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE verified_second_factor DROP registration_code');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141205112641 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE TABLE raa (id INT AUTO_INCREMENT NOT NULL, institution VARCHAR(150) NOT NULL, name_id VARCHAR(150) NOT NULL, location LONGTEXT DEFAULT NULL, contact_information LONGTEXT DEFAULT NULL, INDEX idx_raa_institution (institution), INDEX idx_raa_institution_nameid (institution, name_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('DROP TABLE raa');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141208121040 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE TABLE sraa (name_id VARCHAR(200) NOT NULL, PRIMARY KEY(name_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('DROP TABLE sraa');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141208172438 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE TABLE ra (id INT AUTO_INCREMENT NOT NULL, institution VARCHAR(150) NOT NULL, name_id VARCHAR(150) NOT NULL, location LONGTEXT DEFAULT NULL, contact_information LONGTEXT DEFAULT NULL, INDEX idx_ra_institution (institution), INDEX idx_ra_institution_nameid (institution, name_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('DROP TABLE ra');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141215150518 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE unverified_second_factor ADD verification_nonce VARCHAR(32) NOT NULL');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE unverified_second_factor DROP verification_nonce');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150217122017 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE unverified_second_factor ADD verification_nonce_valid_until DATETIME NOT NULL');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE unverified_second_factor DROP verification_nonce_valid_until');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150225155343 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('CREATE TABLE ra_second_factor (id VARCHAR(36) NOT NULL, type VARCHAR(16) NOT NULL, second_factor_id VARCHAR(36) NOT NULL, status VARCHAR(10) NOT NULL, identity_id VARCHAR(36) NOT NULL, institution VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, INDEX idx_ra_second_factor_type (type), INDEX idx_ra_second_factor_second_factor_id (second_factor_id), INDEX idx_ra_second_factor_status (status), INDEX idx_ra_second_factor_identity_id (identity_id), INDEX idx_ra_second_factor_institution (institution), INDEX idx_ra_second_factor_name (name), INDEX idx_ra_second_factor_email (email), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('DROP TABLE ra_second_factor');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150330160809 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('CREATE TABLE audit_log (id INT AUTO_INCREMENT NOT NULL, actor_id VARCHAR(36) DEFAULT NULL, actor_institution VARCHAR(255) DEFAULT NULL, identity_id VARCHAR(36) NOT NULL, identity_institution VARCHAR(255) NOT NULL, second_factor_id VARCHAR(36) DEFAULT NULL, second_factor_type VARCHAR(36) DEFAULT NULL, action VARCHAR(255) NOT NULL, recorded_on DATETIME NOT NULL, INDEX idx_auditlog_actorid (actor_id), INDEX idx_auditlog_identityid (identity_id), INDEX idx_auditlog_identityinstitution (identity_institution), INDEX idx_auditlog_secondfactorid (second_factor_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('DROP TABLE audit_log');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150407103950 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE audit_log CHANGE action event VARCHAR(255) NOT NULL');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('ALTER TABLE audit_log CHANGE event action VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150408122247 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE TABLE identity_identifying_data (id VARCHAR(36) NOT NULL, common_name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('DROP TABLE identity_identifying_data');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150409142404 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('CREATE TABLE email_templates (id VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, locale VARCHAR(255) NOT NULL, html_content LONGTEXT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }

    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        
        $this->addSql('DROP TABLE email_templates');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150422162952 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE TABLE ra_listing (identity_id VARCHAR(36) NOT NULL, institution VARCHAR(255) NOT NULL, common_name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, role VARCHAR(20) NOT NULL, location LONGTEXT DEFAULT NULL, contact_information LONGTEXT DEFAULT NULL, INDEX idx_ra_listing_institution (institution), PRIMARY KEY(identity_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('DROP TABLE ra_listing');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150428153351 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE TABLE ra_candidate (identity_id VARCHAR(36) NOT NULL, institution VARCHAR(255) NOT NULL, common_name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, INDEX idx_ra_candidate_institution (institution), FULLTEXT INDEX idxft_ra_candidate_email (email), FULLTEXT INDEX idxft_ra_candidate_commonname (common_name), PRIMARY KEY(identity_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('DROP TABLE ra_candidate');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150428174400 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE TABLE institution_listing (institution VARCHAR(255) NOT NULL, PRIMARY KEY(institution)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('DROP TABLE institution_listing');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150518152006 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE audit_log ADD actor_common_name VARCHAR(255) DEFAULT NULL, ADD second_factor_identifier VARCHAR(255) DEFAULT NULL');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE audit_log DROP actor_common_name, DROP second_factor_identifier');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150526152956 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE identity ADD preferred_locale VARCHAR(255) NOT NULL');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE identity DROP preferred_locale');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150601154557 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('DROP TABLE ra');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE TABLE ra (id VARCHAR(36) NOT NULL COLLATE utf8_unicode_ci, institution VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, name_id VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, location LONGTEXT DEFAULT NULL COLLATE utf8_unicode_ci, contact_information LONGTEXT DEFAULT NULL COLLATE utf8_unicode_ci, INDEX idx_ra_institution (institution), INDEX idx_ra_institution_nameid (institution, name_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150601154942 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('DROP TABLE raa');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE TABLE raa (id VARCHAR(36) NOT NULL COLLATE utf8_unicode_ci, institution VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, name_id VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, location LONGTEXT DEFAULT NULL COLLATE utf8_unicode_ci, contact_information LONGTEXT DEFAULT NULL COLLATE utf8_unicode_ci, INDEX idx_raa_institution (institution), INDEX idx_raa_institution_nameid (institution, name_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150604143755 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('
            CREATE TABLE sensitive_data_stream (
              id VARCHAR(36) NOT NULL,
              identity_id VARCHAR(36) NOT NULL,
              playhead INT NOT NULL,
              sensitive_data LONGTEXT DEFAULT NULL,
              PRIMARY KEY(id)
            ) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB
        ');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('DROP TABLE sensitive_data_stream');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150604143757 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE event_stream CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE event_stream CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150604143758 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('DROP TABLE identity_identifying_data');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE TABLE identity_identifying_data (id VARCHAR(36) NOT NULL, common_name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150617141129 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE TABLE second_factor_revocation (id VARCHAR(36) NOT NULL, institution VARCHAR(255) NOT NULL, second_factor_type VARCHAR(36) DEFAULT NULL, recorded_on DATETIME NOT NULL, INDEX idx_secondfactorrevocation_recordedon (recorded_on), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('DROP TABLE second_factor_revocation');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150618121907 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE second_factor_revocation ADD revoked_by VARCHAR(255) NOT NULL');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE second_factor_revocation DROP revoked_by');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160621112027 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE TABLE institution_with_personal_ra_details (institution VARCHAR(255) NOT NULL, PRIMARY KEY(institution)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('DROP TABLE institution_with_personal_ra_details');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160622100140 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE ra_second_factor CHANGE institution institution VARCHAR(255) NOT NULL, CHANGE name name VARCHAR(255) NOT NULL, CHANGE email email VARCHAR(255) NOT NULL, CHANGE status status INT NOT NULL, CHANGE document_number document_number VARCHAR(255) DEFAULT NULL');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE ra_second_factor CHANGE institution institution VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, CHANGE name name VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, CHANGE email email VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, CHANGE document_number document_number VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, CHANGE status status INT NOT NULL');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160719090050 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE TABLE configured_institution (institution VARCHAR(255) NOT NULL, PRIMARY KEY(institution)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('DROP TABLE configured_institution');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160719090051 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE TABLE institution_configuration_options (institution VARCHAR(255) NOT NULL, use_ra_locations_option TINYINT(1) NOT NULL, show_raa_contact_information_option TINYINT(1) NOT NULL, PRIMARY KEY(institution)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('DROP TABLE institution_configuration_options');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20170210140051 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf(
            $this->connection->getDatabasePlatform()->getName() != 'mysql',
            'Migration can only be executed safely on \'mysql\'.'
        );

        $this->addSql(
            'CREATE TABLE allowed_second_factor (institution VARCHAR(255) NOT NULL, second_factor_type VARCHAR(255) NOT NULL, PRIMARY KEY(institution)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'
        );
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('DROP TABLE allowed_second_factor');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20180116091349 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE institution_configuration_options ADD verify_email_option TINYINT(1) NOT NULL COLLATE utf8_unicode_ci');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE institution_configuration_options DROP verify_email_option');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20180330094402 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE institution_configuration_options CHANGE verify_email_option verify_email_option TINYINT(1) DEFAULT \'1\' NOT NULL');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE institution_configuration_options CHANGE verify_email_option verify_email_option TINYINT(1) NOT NULL');
    }
}



/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20180926144517 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE TABLE institution_authorization (institution VARCHAR(255) NOT NULL COMMENT \'(DC2Type:stepup_configuration_institution)\', institution_relation VARCHAR(255) NOT NULL COMMENT \'(DC2Type:stepup_configuration_institution)\', institution_role VARCHAR(10) NOT NULL COMMENT \'(DC2Type:stepup_institution_role)\', PRIMARY KEY(institution, institution_relation, institution_role)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('DROP TABLE institution_authorization');
    }
}



 * Example: John Doe is accredited to become RA by Joe from institution-a. The actual institution John is
 * appointed RA for is stored in this field.
 */
class Version20181101103348 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE audit_log ADD ra_institution VARCHAR(255) DEFAULT NULL');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE audit_log DROP ra_institution;');
    }
}



use Doctrine\DBAL\Migrations\AbstractMigration;
use Doctrine\DBAL\Schema\Schema;

class Version20200416135127 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE INDEX idx_vetted_second_factor_type ON vetted_second_factor (type)');
        $this->addSql('DROP TABLE ra_candidate');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        $this->throwIrreversibleMigrationException('This migration is irreversible and cannot be reverted because it will need a replay on the RACandidateProjector.');
    }
}


		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20141031144721 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('CREATE TABLE identity (name_id VARCHAR(255) NOT NULL, PRIMARY KEY(name_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('DROP TABLE identity');
27		}
28		}
29

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20141119093423 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('ALTER TABLE unverified_second_factor ADD verification_code_nonce VARCHAR(64) NOT NULL, ADD email_verified TINYINT(1) NOT NULL');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('ALTER TABLE unverified_second_factor DROP verification_code_nonce, DROP email_verified');
27		}
28		}
29

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20141119113444 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('ALTER TABLE unverified_second_factor CHANGE verification_code_nonce email_verification_code_nonce VARCHAR(64) NOT NULL');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('ALTER TABLE unverified_second_factor CHANGE email_verification_code_nonce verification_code_nonce VARCHAR(64) NOT NULL');
27		}
28		}
29

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20141119113553 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('ALTER TABLE unverified_second_factor CHANGE email_verification_code_nonce email_verification_code_nonce VARCHAR(64) DEFAULT NULL');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('ALTER TABLE unverified_second_factor CHANGE email_verification_code_nonce email_verification_code_nonce VARCHAR(64) NOT NULL');
27		}
28		}
29

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20141120150430 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('ALTER TABLE unverified_second_factor CHANGE email_verification_code_nonce email_verification_nonce VARCHAR(64) DEFAULT NULL');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('ALTER TABLE unverified_second_factor CHANGE email_verification_nonce email_verification_code_nonce VARCHAR(64) DEFAULT NULL');
27		}
28		}
29

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20141120152310 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('ALTER TABLE unverified_second_factor DROP email_verification_nonce');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('ALTER TABLE unverified_second_factor ADD email_verification_nonce VARCHAR(64) DEFAULT NULL');
27		}
28		}
29

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20141125154133 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('ALTER TABLE unverified_second_factor ADD email_verification_nonce VARCHAR(32) NOT NULL');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('ALTER TABLE unverified_second_factor DROP email_verification_nonce');
27		}
28		}
29

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20141125154214 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('ALTER TABLE identity CHANGE institution institution VARCHAR(255) NOT NULL');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('ALTER TABLE identity CHANGE institution institution VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci');
27		}
28		}
29

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20141125155001 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('ALTER TABLE unverified_second_factor DROP email_verified');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('ALTER TABLE unverified_second_factor ADD email_verified TINYINT(1) NOT NULL');
27		}
28		}
29

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20141128143946 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('ALTER TABLE identity CHANGE institution institution VARCHAR(255) NOT NULL');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('ALTER TABLE identity CHANGE institution institution VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci');
27		}
28		}
29

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20141204140639 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('ALTER TABLE verified_second_factor ADD registration_code VARCHAR(8) NOT NULL');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('ALTER TABLE verified_second_factor DROP registration_code');
27		}
28		}
29

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20141205112641 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('CREATE TABLE raa (id INT AUTO_INCREMENT NOT NULL, institution VARCHAR(150) NOT NULL, name_id VARCHAR(150) NOT NULL, location LONGTEXT DEFAULT NULL, contact_information LONGTEXT DEFAULT NULL, INDEX idx_raa_institution (institution), INDEX idx_raa_institution_nameid (institution, name_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('DROP TABLE raa');
27		}
28		}
29

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20141208121040 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('CREATE TABLE sraa (name_id VARCHAR(200) NOT NULL, PRIMARY KEY(name_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('DROP TABLE sraa');
27		}
28		}
29

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20141208172438 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('CREATE TABLE ra (id INT AUTO_INCREMENT NOT NULL, institution VARCHAR(150) NOT NULL, name_id VARCHAR(150) NOT NULL, location LONGTEXT DEFAULT NULL, contact_information LONGTEXT DEFAULT NULL, INDEX idx_ra_institution (institution), INDEX idx_ra_institution_nameid (institution, name_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('DROP TABLE ra');
27		}
28		}
29

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20141215150518 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('ALTER TABLE unverified_second_factor ADD verification_nonce VARCHAR(32) NOT NULL');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('ALTER TABLE unverified_second_factor DROP verification_nonce');
27		}
28		}
29

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20150217122017 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('ALTER TABLE unverified_second_factor ADD verification_nonce_valid_until DATETIME NOT NULL');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('ALTER TABLE unverified_second_factor DROP verification_nonce_valid_until');
27		}
28		}
29

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20150225155343 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('CREATE TABLE ra_second_factor (id VARCHAR(36) NOT NULL, type VARCHAR(16) NOT NULL, second_factor_id VARCHAR(36) NOT NULL, status VARCHAR(10) NOT NULL, identity_id VARCHAR(36) NOT NULL, institution VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, INDEX idx_ra_second_factor_type (type), INDEX idx_ra_second_factor_second_factor_id (second_factor_id), INDEX idx_ra_second_factor_status (status), INDEX idx_ra_second_factor_identity_id (identity_id), INDEX idx_ra_second_factor_institution (institution), INDEX idx_ra_second_factor_name (name), INDEX idx_ra_second_factor_email (email), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('DROP TABLE ra_second_factor');
27		}
28		}
29

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20150330160809 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('CREATE TABLE audit_log (id INT AUTO_INCREMENT NOT NULL, actor_id VARCHAR(36) DEFAULT NULL, actor_institution VARCHAR(255) DEFAULT NULL, identity_id VARCHAR(36) NOT NULL, identity_institution VARCHAR(255) NOT NULL, second_factor_id VARCHAR(36) DEFAULT NULL, second_factor_type VARCHAR(36) DEFAULT NULL, action VARCHAR(255) NOT NULL, recorded_on DATETIME NOT NULL, INDEX idx_auditlog_actorid (actor_id), INDEX idx_auditlog_identityid (identity_id), INDEX idx_auditlog_identityinstitution (identity_institution), INDEX idx_auditlog_secondfactorid (second_factor_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('DROP TABLE audit_log');
27		}
28		}
29

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20150407103950 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('ALTER TABLE audit_log CHANGE action event VARCHAR(255) NOT NULL');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('ALTER TABLE audit_log CHANGE event action VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci');
27		}
28		}
29

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20150408122247 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('CREATE TABLE identity_identifying_data (id VARCHAR(36) NOT NULL, common_name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('DROP TABLE identity_identifying_data');
27		}
28		}
29

OpenConext / Stepup-Middleware

Code Duplication Length = 18-32 lines in 43 locations

src/Migrations/Version20141031144721.php 1 location

src/Migrations/Version20141119093423.php 1 location

src/Migrations/Version20141119113444.php 1 location

src/Migrations/Version20141119113553.php 1 location

src/Migrations/Version20141120150430.php 1 location

src/Migrations/Version20141120152310.php 1 location

src/Migrations/Version20141125154133.php 1 location

src/Migrations/Version20141125154214.php 1 location

src/Migrations/Version20141125155001.php 1 location

src/Migrations/Version20141128143946.php 1 location

src/Migrations/Version20141204140639.php 1 location

src/Migrations/Version20141205112641.php 1 location

src/Migrations/Version20141208121040.php 1 location

src/Migrations/Version20141208172438.php 1 location

src/Migrations/Version20141215150518.php 1 location

src/Migrations/Version20150217122017.php 1 location

src/Migrations/Version20150225155343.php 1 location

src/Migrations/Version20150330160809.php 1 location

src/Migrations/Version20150407103950.php 1 location

src/Migrations/Version20150408122247.php 1 location

src/Migrations/Version20150409142404.php 1 location

src/Migrations/Version20150422162952.php 1 location

src/Migrations/Version20150428153351.php 1 location

src/Migrations/Version20150428174400.php 1 location

src/Migrations/Version20150518152006.php 1 location

src/Migrations/Version20150526152956.php 1 location

src/Migrations/Version20150601154557.php 1 location

src/Migrations/Version20150601154942.php 1 location

src/Migrations/Version20150604143755.php 1 location

src/Migrations/Version20150604143757.php 1 location

src/Migrations/Version20150604143758.php 1 location

src/Migrations/Version20150617141129.php 1 location

src/Migrations/Version20150618121907.php 1 location

src/Migrations/Version20160621112027.php 1 location

src/Migrations/Version20160622100140.php 1 location

src/Migrations/Version20160719090050.php 1 location

src/Migrations/Version20160719090051.php 1 location

src/Migrations/Version20170210140051.php 1 location

src/Migrations/Version20180116091349.php 1 location

src/Migrations/Version20180330094402.php 1 location

src/Migrations/Version20180926144517.php 1 location

src/Migrations/Version20181101103348.php 1 location

src/Migrations/Version20200416135127.php 1 location

		@@ 11-28 (lines=18) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20150409142404 extends AbstractMigration
12		{
13		public function up(Schema $schema)
14		{
15		// this up() migration is auto-generated, please modify it to your needs
16		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18		$this->addSql('CREATE TABLE email_templates (id VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, locale VARCHAR(255) NOT NULL, html_content LONGTEXT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
19		}
20
21		public function down(Schema $schema)
22		{
23		// this down() migration is auto-generated, please modify it to your needs
24		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
25
26		$this->addSql('DROP TABLE email_templates');
27		}
28		}
29

		@@ 11-34 (lines=24) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20150422162952 extends AbstractMigration
12		{
13		/**
14		* @param Schema $schema
15		*/
16		public function up(Schema $schema)
17		{
18		// this up() migration is auto-generated, please modify it to your needs
19		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
20
21		$this->addSql('CREATE TABLE ra_listing (identity_id VARCHAR(36) NOT NULL, institution VARCHAR(255) NOT NULL, common_name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, role VARCHAR(20) NOT NULL, location LONGTEXT DEFAULT NULL, contact_information LONGTEXT DEFAULT NULL, INDEX idx_ra_listing_institution (institution), PRIMARY KEY(identity_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
22		}
23
24		/**
25		* @param Schema $schema
26		*/
27		public function down(Schema $schema)
28		{
29		// this down() migration is auto-generated, please modify it to your needs
30		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
31
32		$this->addSql('DROP TABLE ra_listing');
33		}
34		}
35

		@@ 11-34 (lines=24) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20150428153351 extends AbstractMigration
12		{
13		/**
14		* @param Schema $schema
15		*/
16		public function up(Schema $schema)
17		{
18		// this up() migration is auto-generated, please modify it to your needs
19		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
20
21		$this->addSql('CREATE TABLE ra_candidate (identity_id VARCHAR(36) NOT NULL, institution VARCHAR(255) NOT NULL, common_name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, INDEX idx_ra_candidate_institution (institution), FULLTEXT INDEX idxft_ra_candidate_email (email), FULLTEXT INDEX idxft_ra_candidate_commonname (common_name), PRIMARY KEY(identity_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
22		}
23
24		/**
25		* @param Schema $schema
26		*/
27		public function down(Schema $schema)
28		{
29		// this down() migration is auto-generated, please modify it to your needs
30		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
31
32		$this->addSql('DROP TABLE ra_candidate');
33		}
34		}
35

		@@ 11-34 (lines=24) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20150428174400 extends AbstractMigration
12		{
13		/**
14		* @param Schema $schema
15		*/
16		public function up(Schema $schema)
17		{
18		// this up() migration is auto-generated, please modify it to your needs
19		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
20
21		$this->addSql('CREATE TABLE institution_listing (institution VARCHAR(255) NOT NULL, PRIMARY KEY(institution)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
22		}
23
24		/**
25		* @param Schema $schema
26		*/
27		public function down(Schema $schema)
28		{
29		// this down() migration is auto-generated, please modify it to your needs
30		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
31
32		$this->addSql('DROP TABLE institution_listing');
33		}
34		}
35

		@@ 11-34 (lines=24) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20150518152006 extends AbstractMigration
12		{
13		/**
14		* @param Schema $schema
15		*/
16		public function up(Schema $schema)
17		{
18		// this up() migration is auto-generated, please modify it to your needs
19		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
20
21		$this->addSql('ALTER TABLE audit_log ADD actor_common_name VARCHAR(255) DEFAULT NULL, ADD second_factor_identifier VARCHAR(255) DEFAULT NULL');
22		}
23
24		/**
25		* @param Schema $schema
26		*/
27		public function down(Schema $schema)
28		{
29		// this down() migration is auto-generated, please modify it to your needs
30		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
31
32		$this->addSql('ALTER TABLE audit_log DROP actor_common_name, DROP second_factor_identifier');
33		}
34		}
35

		@@ 11-34 (lines=24) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20150526152956 extends AbstractMigration
12		{
13		/**
14		* @param Schema $schema
15		*/
16		public function up(Schema $schema)
17		{
18		// this up() migration is auto-generated, please modify it to your needs
19		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
20
21		$this->addSql('ALTER TABLE identity ADD preferred_locale VARCHAR(255) NOT NULL');
22		}
23
24		/**
25		* @param Schema $schema
26		*/
27		public function down(Schema $schema)
28		{
29		// this down() migration is auto-generated, please modify it to your needs
30		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
31
32		$this->addSql('ALTER TABLE identity DROP preferred_locale');
33		}
34		}
35

		@@ 11-34 (lines=24) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20150601154557 extends AbstractMigration
12		{
13		/**
14		* @param Schema $schema
15		*/
16		public function up(Schema $schema)
17		{
18		// this up() migration is auto-generated, please modify it to your needs
19		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
20
21		$this->addSql('DROP TABLE ra');
22		}
23
24		/**
25		* @param Schema $schema
26		*/
27		public function down(Schema $schema)
28		{
29		// this down() migration is auto-generated, please modify it to your needs
30		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
31
32		$this->addSql('CREATE TABLE ra (id VARCHAR(36) NOT NULL COLLATE utf8_unicode_ci, institution VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, name_id VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, location LONGTEXT DEFAULT NULL COLLATE utf8_unicode_ci, contact_information LONGTEXT DEFAULT NULL COLLATE utf8_unicode_ci, INDEX idx_ra_institution (institution), INDEX idx_ra_institution_nameid (institution, name_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
33		}
34		}
35

		@@ 11-34 (lines=24) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20150601154942 extends AbstractMigration
12		{
13		/**
14		* @param Schema $schema
15		*/
16		public function up(Schema $schema)
17		{
18		// this up() migration is auto-generated, please modify it to your needs
19		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
20
21		$this->addSql('DROP TABLE raa');
22		}
23
24		/**
25		* @param Schema $schema
26		*/
27		public function down(Schema $schema)
28		{
29		// this down() migration is auto-generated, please modify it to your needs
30		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
31
32		$this->addSql('CREATE TABLE raa (id VARCHAR(36) NOT NULL COLLATE utf8_unicode_ci, institution VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, name_id VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, location LONGTEXT DEFAULT NULL COLLATE utf8_unicode_ci, contact_information LONGTEXT DEFAULT NULL COLLATE utf8_unicode_ci, INDEX idx_raa_institution (institution), INDEX idx_raa_institution_nameid (institution, name_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
33		}
34		}
35

		@@ 11-42 (lines=32) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20150604143755 extends AbstractMigration
12		{
13		/**
14		* @param Schema $schema
15		*/
16		public function up(Schema $schema)
17		{
18		// this up() migration is auto-generated, please modify it to your needs
19		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
20
21		$this->addSql('
22		CREATE TABLE sensitive_data_stream (
23		id VARCHAR(36) NOT NULL,
24		identity_id VARCHAR(36) NOT NULL,
25		playhead INT NOT NULL,
26		sensitive_data LONGTEXT DEFAULT NULL,
27		PRIMARY KEY(id)
28		) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB
29		');
30		}
31
32		/**
33		* @param Schema $schema
34		*/
35		public function down(Schema $schema)
36		{
37		// this down() migration is auto-generated, please modify it to your needs
38		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
39
40		$this->addSql('DROP TABLE sensitive_data_stream');
41		}
42		}
43

		@@ 11-34 (lines=24) @@
8		/**
9		* Auto-generated Migration: Please modify to your needs!
10		*/
11		class Version20150604143757 extends AbstractMigration
12		{
13		/**
14		* @param Schema $schema
15		*/
16		public function up(Schema $schema)
17		{
18		// this up() migration is auto-generated, please modify it to your needs
19		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
20
21		$this->addSql('ALTER TABLE event_stream CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci');
22		}
23
24		/**
25		* @param Schema $schema
26		*/
27		public function down(Schema $schema)
28		{
29		// this down() migration is auto-generated, please modify it to your needs
30		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
31
32		$this->addSql('ALTER TABLE event_stream CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci');
33		}
34		}
35