diff

Version20121016140948.php

class Version20121016140948 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is autogenerated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != "mysql");
        
        $this->addSql("ALTER TABLE acl_entries DROP FOREIGN KEY FK_46C8B806EA000B10");
        $this->addSql("ALTER TABLE acl_entries DROP FOREIGN KEY FK_46C8B8063D9AB4A6");
        $this->addSql("ALTER TABLE acl_object_identities DROP FOREIGN KEY FK_9407E54977FA751A");
        $this->addSql("ALTER TABLE acl_object_identity_ancestors DROP FOREIGN KEY FK_825DE2993D9AB4A6");
        $this->addSql("ALTER TABLE acl_object_identity_ancestors DROP FOREIGN KEY FK_825DE299C671CEA1");
        $this->addSql("ALTER TABLE acl_entries DROP FOREIGN KEY FK_46C8B806DF9183C9");
        $this->addSql("ALTER TABLE metro DROP FOREIGN KEY FK_3884E4E18BAC62AF");
        $this->addSql("ALTER TABLE streets DROP FOREIGN KEY FK_93F67B3E8BAC62AF");
        $this->addSql("ALTER TABLE regions DROP FOREIGN KEY FK_A26779F3F92F3E70");
        $this->addSql("ALTER TABLE cities DROP FOREIGN KEY FK_D95DB16B98260155");
        $this->addSql("DROP TABLE acl_classes");
        $this->addSql("DROP TABLE acl_entries");
        $this->addSql("DROP TABLE acl_object_identities");
        $this->addSql("DROP TABLE acl_object_identity_ancestors");
        $this->addSql("DROP TABLE acl_security_identities");
        $this->addSql("DROP TABLE articles");
        $this->addSql("DROP TABLE cities");
        $this->addSql("DROP TABLE countries");
        $this->addSql("DROP TABLE metro");
        $this->addSql("DROP TABLE moderator_location");
        $this->addSql("DROP TABLE phones");
        $this->addSql("DROP TABLE regions");
        $this->addSql("DROP TABLE streets");
        $this->addSql("ALTER TABLE organisations_juridical CHANGE kpp kpp VARCHAR(255) DEFAULT NULL");
        $this->addSql("ALTER TABLE geo_location CHANGE code code VARCHAR(13) DEFAULT NULL");
    }

    public function down(Schema $schema)
    {
        // this down() migration is autogenerated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != "mysql");
        
        $this->addSql("CREATE TABLE acl_classes (id INT AUTO_INCREMENT NOT NULL, class_type VARCHAR(200) NOT NULL, UNIQUE INDEX UNIQ_69DD750638A36066 (class_type), PRIMARY KEY(id)) ENGINE = InnoDB");
        $this->addSql("CREATE TABLE acl_entries (id INT AUTO_INCREMENT NOT NULL, object_identity_id INT DEFAULT NULL, security_identity_id INT NOT NULL, class_id INT NOT NULL, field_name VARCHAR(50) DEFAULT NULL, ace_order SMALLINT NOT NULL, mask INT NOT NULL, granting TINYINT(1) NOT NULL, granting_strategy VARCHAR(30) NOT NULL, audit_success TINYINT(1) NOT NULL, audit_failure TINYINT(1) NOT NULL, UNIQUE INDEX UNIQ_46C8B806EA000B103D9AB4A64DEF17BCE4289BF4 (class_id, object_identity_id, field_name, ace_order), INDEX IDX_46C8B806EA000B103D9AB4A6DF9183C9 (class_id, object_identity_id, security_identity_id), INDEX IDX_46C8B806EA000B10 (class_id), INDEX IDX_46C8B8063D9AB4A6 (object_identity_id), INDEX IDX_46C8B806DF9183C9 (security_identity_id), PRIMARY KEY(id)) ENGINE = InnoDB");
        $this->addSql("CREATE TABLE acl_object_identities (id INT AUTO_INCREMENT NOT NULL, parent_object_identity_id INT DEFAULT NULL, class_id INT NOT NULL, object_identifier VARCHAR(100) NOT NULL, entries_inheriting TINYINT(1) NOT NULL, UNIQUE INDEX UNIQ_9407E5494B12AD6EA000B10 (object_identifier, class_id), INDEX IDX_9407E54977FA751A (parent_object_identity_id), PRIMARY KEY(id)) ENGINE = InnoDB");
        $this->addSql("CREATE TABLE acl_object_identity_ancestors (object_identity_id INT NOT NULL, ancestor_id INT NOT NULL, INDEX IDX_825DE2993D9AB4A6 (object_identity_id), INDEX IDX_825DE299C671CEA1 (ancestor_id), PRIMARY KEY(object_identity_id, ancestor_id)) ENGINE = InnoDB");
        $this->addSql("CREATE TABLE acl_security_identities (id INT AUTO_INCREMENT NOT NULL, identifier VARCHAR(200) NOT NULL, username TINYINT(1) NOT NULL, UNIQUE INDEX UNIQ_8835EE78772E836AF85E0677 (identifier, username), PRIMARY KEY(id)) ENGINE = InnoDB");
        $this->addSql("CREATE TABLE articles (id INT AUTO_INCREMENT NOT NULL, address_id INT DEFAULT NULL, title VARCHAR(255) NOT NULL, content LONGTEXT NOT NULL, INDEX IDX_BFDD3168F5B7AF75 (address_id), PRIMARY KEY(id)) ENGINE = InnoDB");
        $this->addSql("CREATE TABLE cities (id INT AUTO_INCREMENT NOT NULL, region_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(13) NOT NULL, INDEX IDX_D95DB16B98260155 (region_id), PRIMARY KEY(id)) ENGINE = InnoDB");
        $this->addSql("CREATE TABLE countries (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, iso VARCHAR(3) NOT NULL, alpha2 VARCHAR(2) NOT NULL, alpha3 VARCHAR(3) NOT NULL, PRIMARY KEY(id)) ENGINE = InnoDB");
        $this->addSql("CREATE TABLE metro (id INT AUTO_INCREMENT NOT NULL, city_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, INDEX IDX_3884E4E18BAC62AF (city_id), PRIMARY KEY(id)) ENGINE = InnoDB");
        $this->addSql("CREATE TABLE moderator_location (moderator_id INT NOT NULL, location_id INT NOT NULL, INDEX IDX_23AB7A3D0AFA354 (moderator_id), INDEX IDX_23AB7A364D218E (location_id), PRIMARY KEY(moderator_id, location_id)) ENGINE = InnoDB");
        $this->addSql("CREATE TABLE phones (id INT AUTO_INCREMENT NOT NULL, address_id INT DEFAULT NULL, phone VARCHAR(255) NOT NULL, description VARCHAR(255) NOT NULL, INDEX IDX_E3282EF5F5B7AF75 (address_id), PRIMARY KEY(id)) ENGINE = InnoDB");
        $this->addSql("CREATE TABLE regions (id INT AUTO_INCREMENT NOT NULL, country_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(13) NOT NULL, INDEX IDX_A26779F3F92F3E70 (country_id), PRIMARY KEY(id)) ENGINE = InnoDB");
        $this->addSql("CREATE TABLE streets (id INT AUTO_INCREMENT NOT NULL, city_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, postal_code VARCHAR(6) NOT NULL, INDEX IDX_93F67B3E8BAC62AF (city_id), PRIMARY KEY(id)) ENGINE = InnoDB");
        $this->addSql("ALTER TABLE acl_entries ADD CONSTRAINT FK_46C8B8063D9AB4A6 FOREIGN KEY (object_identity_id) REFERENCES acl_object_identities(id) ON UPDATE CASCADE ON DELETE CASCADE");
        $this->addSql("ALTER TABLE acl_entries ADD CONSTRAINT FK_46C8B806DF9183C9 FOREIGN KEY (security_identity_id) REFERENCES acl_security_identities(id) ON UPDATE CASCADE ON DELETE CASCADE");
        $this->addSql("ALTER TABLE acl_entries ADD CONSTRAINT FK_46C8B806EA000B10 FOREIGN KEY (class_id) REFERENCES acl_classes(id) ON UPDATE CASCADE ON DELETE CASCADE");
        $this->addSql("ALTER TABLE acl_object_identities ADD CONSTRAINT FK_9407E54977FA751A FOREIGN KEY (parent_object_identity_id) REFERENCES acl_object_identities(id)");
        $this->addSql("ALTER TABLE acl_object_identity_ancestors ADD CONSTRAINT FK_825DE2993D9AB4A6 FOREIGN KEY (object_identity_id) REFERENCES acl_object_identities(id) ON UPDATE CASCADE ON DELETE CASCADE");
        $this->addSql("ALTER TABLE acl_object_identity_ancestors ADD CONSTRAINT FK_825DE299C671CEA1 FOREIGN KEY (ancestor_id) REFERENCES acl_object_identities(id) ON UPDATE CASCADE ON DELETE CASCADE");
        $this->addSql("ALTER TABLE cities ADD CONSTRAINT FK_D95DB16B98260155 FOREIGN KEY (region_id) REFERENCES regions(id) ON DELETE SET NULL");
        $this->addSql("ALTER TABLE metro ADD CONSTRAINT FK_3884E4E18BAC62AF FOREIGN KEY (city_id) REFERENCES cities(id) ON DELETE SET NULL");
        $this->addSql("ALTER TABLE regions ADD CONSTRAINT FK_A26779F3F92F3E70 FOREIGN KEY (country_id) REFERENCES countries(id) ON DELETE SET NULL");
        $this->addSql("ALTER TABLE streets ADD CONSTRAINT FK_93F67B3E8BAC62AF FOREIGN KEY (city_id) REFERENCES cities(id) ON DELETE SET NULL");
        $this->addSql("ALTER TABLE geo_location CHANGE code code VARCHAR(13) NOT NULL");
        $this->addSql("ALTER TABLE organisations_juridical CHANGE kpp kpp VARCHAR(255) NOT NULL");
    }
}