OpenConext / Stepup-Middleware

/**

 * Auto-generated Migration: Please modify to your needs!

 */

class Version20150305134846 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 ra_second_factor ADD status_int INT NOT NULL');

        $this->addSql('UPDATE ra_second_factor SET status_int=0 WHERE `status`="unverified"');

        $this->addSql('UPDATE ra_second_factor SET status_int=10 WHERE `status`="verified"');

        $this->addSql('UPDATE ra_second_factor SET status_int=20 WHERE `status`="vetted"');

        $this->addSql('UPDATE ra_second_factor SET status_int=30 WHERE `status`="revoked"');

        $this->addSql('ALTER TABLE ra_second_factor DROP `status`');

        $this->addSql('ALTER TABLE ra_second_factor CHANGE status_int `status` INT 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 ra_second_factor CHANGE `status` `status` VARCHAR(10) NOT NULL COLLATE utf8_unicode_ci');

        $this->addSql('ALTER TABLE ra_second_factor ADD status_string VARCHAR(10) NOT NULL COLLATE utf8_unicode_ci');

        $this->addSql('UPDATE ra_second_factor SET status_string="unverified" WHERE `status`=0');

        $this->addSql('UPDATE ra_second_factor SET status_string="verified" WHERE `status`=10');

        $this->addSql('UPDATE ra_second_factor SET status_string="vetted" WHERE `status`=20');

        $this->addSql('UPDATE ra_second_factor SET status_string="revoked" WHERE `status`=30');

        $this->addSql('ALTER TABLE ra_second_factor DROP `status`');

        $this->addSql('ALTER TABLE ra_second_factor CHANGE status_string `status` VARCHAR(10) NOT NULL COLLATE utf8_unicode_ci');

    }

}

/**

 * Auto-generated Migration: Please modify to your needs!

 */

class Version20150611163038 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 verified_second_factor DROP FOREIGN KEY fk_verified_second_factor_identity');

        $this->addSql('DROP INDEX IDX_7964F91CFF3ED4A8 ON verified_second_factor');

        $this->addSql('ALTER TABLE verified_second_factor ADD institution VARCHAR(255) NOT NULL, ADD common_name VARCHAR(255) NOT NULL, CHANGE identity_id identity_id VARCHAR(36) NOT NULL');

        $this->addSql('ALTER TABLE vetted_second_factor DROP FOREIGN KEY fk_vetted_second_factor_identity');

        $this->addSql('DROP INDEX IDX_29F96B72FF3ED4A8 ON vetted_second_factor');

        $this->addSql('ALTER TABLE unverified_second_factor DROP FOREIGN KEY fk_unverified_second_factor_identity');

        $this->addSql('DROP INDEX IDX_D79226A2FF3ED4A8 ON unverified_second_factor');

    }

    /**

     * @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 unverified_second_factor ADD CONSTRAINT fk_unverified_second_factor_identity FOREIGN KEY (identity_id) REFERENCES identity (id) ON DELETE CASCADE');

        $this->addSql('CREATE INDEX IDX_D79226A2FF3ED4A8 ON unverified_second_factor (identity_id)');

        $this->addSql('ALTER TABLE verified_second_factor DROP institution, DROP common_name, CHANGE identity_id identity_id VARCHAR(36) DEFAULT NULL COLLATE utf8_unicode_ci');

        $this->addSql('ALTER TABLE verified_second_factor ADD CONSTRAINT fk_verified_second_factor_identity FOREIGN KEY (identity_id) REFERENCES identity (id) ON DELETE CASCADE');

        $this->addSql('CREATE INDEX IDX_7964F91CFF3ED4A8 ON verified_second_factor (identity_id)');

        $this->addSql('ALTER TABLE vetted_second_factor ADD CONSTRAINT fk_vetted_second_factor_identity FOREIGN KEY (identity_id) REFERENCES identity (id) ON DELETE CASCADE');

        $this->addSql('CREATE INDEX IDX_29F96B72FF3ED4A8 ON vetted_second_factor (identity_id)');

    }

}