Neos\Flow\Persistence\Doctrine\Migrations\Version20110920104739::down PHP Method

Version20110920104739 Class Documentation ファイルを表示 Open project: neos/neos-development-collection

down() public method

public down ( Doctrine\DBAL\Schema\Schema $schema ) : void
$schema Doctrine\DBAL\Schema\Schema
return void 
    public function down(Schema $schema)
    {
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != "mysql");
        $this->addSql("CREATE TABLE contentTypesDeclaredSuperTypes (typo3cr_contenttype VARCHAR(40) NOT NULL, declaredSuperTypeId VARCHAR(40) NOT NULL, INDEX IDX_BEE1B2BEE2741BEE (declaredSuperTypeId), INDEX IDX_BEE1B2BEF2209F2 (typo3cr_contenttype), PRIMARY KEY(declaredSuperTypeId, typo3cr_contenttype)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB");
        $this->addSql("CREATE TABLE typo3_typo3cr_domain_model_contenttype (flow3_persistence_identifier VARCHAR(40) NOT NULL, name VARCHAR(255) DEFAULT NULL, PRIMARY KEY(flow3_persistence_identifier)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB");
        $this->addSql("ALTER TABLE contentTypesDeclaredSuperTypes ADD CONSTRAINT contenttypesdeclaredsupertypes_ibfk_2 FOREIGN KEY (typo3cr_contenttype) REFERENCES typo3_typo3cr_domain_model_contenttype(flow3_persistence_identifier)");
        $this->addSql("ALTER TABLE contentTypesDeclaredSuperTypes ADD CONSTRAINT contenttypesdeclaredsupertypes_ibfk_1 FOREIGN KEY (declaredSuperTypeId) REFERENCES typo3_typo3cr_domain_model_contenttype(flow3_persistence_identifier)");
    }
Version20110920104739
down
up