public function up(Schema $schema)
{
$this->abortIf($this->connection->getDatabasePlatform()->getName() != "postgresql");
// skip execution of corresponding sql queries if migration has been applied already (see https://review.typo3.org/36299)
$this->skipIf(array_key_exists('roleidentifiers', $this->sm->listTableColumns('typo3_flow_security_account')), 'Migration not needed, already applied earlier.');
$this->addSql("ALTER TABLE typo3_flow_security_account_roles_join DROP CONSTRAINT fk_adf11bbc23a1047c");
$this->addSql("ALTER TABLE typo3_flow_security_policy_role_parentroles_join DROP CONSTRAINT fk_d459c58e23a1047c");
$this->addSql("ALTER TABLE typo3_flow_security_policy_role_parentroles_join DROP CONSTRAINT fk_d459c58e6a8abcde");
$this->addSql("DROP TABLE typo3_flow_security_policy_role");
$this->addSql("DROP TABLE typo3_flow_security_authorization_resource_securitypublis_861cb");
$this->addSql("DROP TABLE typo3_flow_security_account_roles_join");
$this->addSql("DROP TABLE typo3_flow_security_policy_role_parentroles_join");
$this->addSql("ALTER TABLE typo3_flow_security_account ADD roleidentifiers TEXT DEFAULT NULL");
$this->addSql("COMMENT ON COLUMN typo3_flow_security_account.roleidentifiers IS '(DC2Type:simple_array)'");
}