Symfony Profiler

<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
final class Version20190828090412 extends AbstractMigration
{
public function getDescription(): string
{
return 'Drop Tmetric integration tables';
}
/**
* @throws \Doctrine\DBAL\DBALException
*/
public function up(Schema $schema): void
{
// this up() migration is auto-generated, please modify it to your needs
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'postgresql', 'Migration can only be executed safely on \'postgresql\'.');
$this->addSql('ALTER TABLE hub_user DROP CONSTRAINT fk_8bd464f553738cb9');
$this->addSql('ALTER TABLE project_user DROP CONSTRAINT fk_b4021e51a76ed395');
$this->addSql('ALTER TABLE project DROP CONSTRAINT fk_2fb3d0ee53738cb9');
$this->addSql('ALTER TABLE project_user DROP CONSTRAINT fk_b4021e51166d1f9c');
$this->addSql('ALTER TABLE tmetric_project DROP CONSTRAINT fk_84cf078f9b6b5fba');
$this->addSql('DROP TABLE tmetric_user');
$this->addSql('DROP TABLE tmetric_project');
$this->addSql('DROP TABLE tmetric_account');
$this->addSql('DROP TABLE project_user');
$this->addSql('DROP INDEX uniq_8bd464f553738cb9');
$this->addSql('ALTER TABLE hub_user DROP tmetric_id');
$this->addSql('DROP INDEX uniq_2fb3d0ee53738cb9');
$this->addSql('ALTER TABLE project DROP tmetric_id');
}
/**
* @throws \Doctrine\DBAL\DBALException
*/
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'postgresql', 'Migration can only be executed safely on \'postgresql\'.');
$this->addSql('CREATE TABLE tmetric_user (id UUID NOT NULL, user_id UUID DEFAULT NULL, user_profile_id INT DEFAULT NULL, active_account_id INT DEFAULT NULL, user_name VARCHAR(255) DEFAULT NULL, date_format VARCHAR(255) DEFAULT \'DD.MM.YYYY\' NOT NULL, time_format VARCHAR(255) DEFAULT \'H:mm\' NOT NULL, show_breaks BOOLEAN DEFAULT \'true\' NOT NULL, registration_date TIMESTAMP(0) WITH TIME ZONE NOT NULL, time_zone_info VARCHAR(255) DEFAULT \'Asia/Yekaterinburg\' NOT NULL, is_registered BOOLEAN DEFAULT \'true\' NOT NULL, email VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX uniq_35f74956a76ed395 ON tmetric_user (user_id)');
$this->addSql('COMMENT ON COLUMN tmetric_user.id IS \'(DC2Type:uuid)\'');
$this->addSql('COMMENT ON COLUMN tmetric_user.user_id IS \'(DC2Type:uuid)\'');
$this->addSql('CREATE TABLE tmetric_project (id UUID NOT NULL, account_id UUID DEFAULT NULL, project_id UUID DEFAULT NULL, remote_id VARCHAR(255) DEFAULT NULL, project_name VARCHAR(255) DEFAULT NULL, project_code VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX idx_84cf078f9b6b5fba ON tmetric_project (account_id)');
$this->addSql('CREATE UNIQUE INDEX uniq_84cf078f166d1f9c ON tmetric_project (project_id)');
$this->addSql('COMMENT ON COLUMN tmetric_project.id IS \'(DC2Type:uuid)\'');
$this->addSql('COMMENT ON COLUMN tmetric_project.account_id IS \'(DC2Type:uuid)\'');
$this->addSql('COMMENT ON COLUMN tmetric_project.project_id IS \'(DC2Type:uuid)\'');
$this->addSql('CREATE TABLE tmetric_account (id UUID NOT NULL, api_key VARCHAR(255) DEFAULT NULL, account_id VARCHAR(255) DEFAULT NULL, active BOOLEAN DEFAULT \'true\' NOT NULL, PRIMARY KEY(id))');
$this->addSql('COMMENT ON COLUMN tmetric_account.id IS \'(DC2Type:uuid)\'');
$this->addSql('CREATE TABLE project_user (project_id UUID NOT NULL, user_id UUID NOT NULL, PRIMARY KEY(project_id, user_id))');
$this->addSql('CREATE INDEX idx_b4021e51a76ed395 ON project_user (user_id)');
$this->addSql('CREATE INDEX idx_b4021e51166d1f9c ON project_user (project_id)');
$this->addSql('COMMENT ON COLUMN project_user.project_id IS \'(DC2Type:uuid)\'');
$this->addSql('COMMENT ON COLUMN project_user.user_id IS \'(DC2Type:uuid)\'');
$this->addSql('ALTER TABLE tmetric_user ADD CONSTRAINT fk_35f74956a76ed395 FOREIGN KEY (user_id) REFERENCES hub_user (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE tmetric_project ADD CONSTRAINT fk_84cf078f9b6b5fba FOREIGN KEY (account_id) REFERENCES tmetric_account (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE tmetric_project ADD CONSTRAINT fk_84cf078f166d1f9c FOREIGN KEY (project_id) REFERENCES project (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE project_user ADD CONSTRAINT fk_b4021e51166d1f9c FOREIGN KEY (project_id) REFERENCES tmetric_project (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE project_user ADD CONSTRAINT fk_b4021e51a76ed395 FOREIGN KEY (user_id) REFERENCES tmetric_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE hub_user ADD tmetric_id UUID DEFAULT NULL');
$this->addSql('COMMENT ON COLUMN hub_user.tmetric_id IS \'(DC2Type:uuid)\'');
$this->addSql('ALTER TABLE hub_user ADD CONSTRAINT fk_8bd464f553738cb9 FOREIGN KEY (tmetric_id) REFERENCES tmetric_user (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('CREATE UNIQUE INDEX uniq_8bd464f553738cb9 ON hub_user (tmetric_id)');
$this->addSql('ALTER TABLE project ADD tmetric_id UUID DEFAULT NULL');
$this->addSql('COMMENT ON COLUMN project.tmetric_id IS \'(DC2Type:uuid)\'');
$this->addSql('ALTER TABLE project ADD CONSTRAINT fk_2fb3d0ee53738cb9 FOREIGN KEY (tmetric_id) REFERENCES tmetric_project (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('CREATE UNIQUE INDEX uniq_2fb3d0ee53738cb9 ON project (tmetric_id)');
}
}

migrations/Version20190828090412.php line 1