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 Version20180814170404 extends AbstractMigration
{
public function up(Schema $schema): void
{
// this up() migration is auto-generated, please modify it to your needs
$this->abortIf('mysql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'mysql\'.');
$this->addSql('RENAME TABLE leads TO lead');
$this->addSql('ALTER TABLE lead ENGINE = InnoDB');
$this->addSql('ALTER TABLE lead CHARACTER SET = utf8mb4');
$this->addSql('UPDATE lead SET status = 0 WHERE status IS NULL');
$this->addSql('
ALTER TABLE lead
CHANGE administrators_id user_id INT DEFAULT NULL,
CHANGE customers_id customer_id INT DEFAULT NULL,
CHANGE source_id source_id INT DEFAULT NULL,
CHANGE level level_id INT DEFAULT NULL,
CHANGE tax_debt_id debt_option_id INT DEFAULT NULL,
CHANGE tax_issues_id tax_issue_id INT DEFAULT NULL,
CHANGE name name VARCHAR(255) NOT NULL,
CHANGE telephone_1 phone_number VARCHAR(255) DEFAULT NULL,
CHANGE telephone_2 phone_number2 VARCHAR(255) DEFAULT NULL,
CHANGE email_address email VARCHAR(255) DEFAULT NULL,
CHANGE disposition disposition VARCHAR(255) DEFAULT NULL,
CHANGE type type VARCHAR(255) DEFAULT NULL,
CHANGE street_address street VARCHAR(255) DEFAULT NULL,
CHANGE city city VARCHAR(255) DEFAULT NULL,
CHANGE state state VARCHAR(255) DEFAULT NULL,
CHANGE postcode zip VARCHAR(255) DEFAULT NULL,
CHANGE comments description LONGTEXT DEFAULT NULL,
CHANGE status enabled TINYINT(1) NOT NULL,
CHANGE date_added created_at DATETIME NOT NULL,
CHANGE last_modified modified_at DATETIME NOT NULL
');
$this->addSql('UPDATE lead SET disposition = NULL WHERE disposition = \'0\'');
$this->addSql('UPDATE lead SET disposition = \'transfer\' WHERE disposition = \'1\'');
$this->addSql('UPDATE lead SET disposition = \'left_message\' WHERE disposition = \'2\'');
$this->addSql('UPDATE lead SET disposition = \'call_back\' WHERE disposition = \'8\'');
$this->addSql('UPDATE lead SET disposition = \'no_answer\' WHERE disposition = \'3\'');
$this->addSql('UPDATE lead SET disposition = \'wrong_number\' WHERE disposition = \'4\'');
$this->addSql('UPDATE lead SET disposition = \'no_tax_issue\' WHERE disposition = \'5\'');
$this->addSql('UPDATE lead SET disposition = \'hung_up\' WHERE disposition = \'9\'');
$this->addSql('UPDATE lead SET disposition = \'do_not_call\' WHERE disposition = \'6\'');
$this->addSql('UPDATE lead SET disposition = \'unsubscribe\' WHERE disposition = \'7\'');
$this->addSql('UPDATE lead SET disposition = \'fake_lead\' WHERE disposition = \'10\'');
$this->addSql('UPDATE lead SET type = \'form\' WHERE type = \'0\'');
$this->addSql('UPDATE lead SET type = \'call\' WHERE type = \'1\'');
$this->addSql('UPDATE lead SET type = \'timed\' WHERE type = \'2\'');
$this->addSql('UPDATE lead SET type = \'chat\' WHERE type = \'4\'');
$this->addSql('UPDATE lead SET type = \'handoff\' WHERE type = \'5\'');
$this->addSql('ALTER TABLE lead CHANGE disposition disposition ENUM(\'transfer\', \'left_message\', \'call_back\', \'no_answer\', \'wrong_number\', \'no_tax_issue\', \'hung_up\', \'do_not_call\', \'unsubscribe\', \'fake_lead\') DEFAULT NULL COMMENT \'(DC2Type:LeadDispositionType)\'');
$this->addSql('ALTER TABLE lead CHANGE type type ENUM(\'form\', \'call\', \'timed\', \'chat\', \'handoff\') DEFAULT NULL COMMENT \'(DC2Type:LeadType)\'');
$this->addSql('DROP INDEX idx_administrators_id ON lead');
$this->addSql('DROP INDEX idx_customers_id ON lead');
$this->addSql('DROP INDEX idx_source_id ON lead');
$this->addSql('CREATE INDEX IDX_289161CBA76ED395 ON lead (user_id)');
$this->addSql('CREATE INDEX IDX_289161CB9395C3F3 ON lead (customer_id)');
$this->addSql('CREATE INDEX IDX_289161CB953C1C61 ON lead (source_id)');
$this->addSql('CREATE INDEX IDX_289161CB5FB14BA7 ON lead (level_id)');
$this->addSql('CREATE INDEX IDX_289161CBD456175A ON lead (debt_option_id)');
$this->addSql('CREATE INDEX IDX_289161CBBEEE0432 ON lead (tax_issue_id)');
$this->addSql('RENAME TABLE leads_transfers TO lead_transfer');
$this->addSql('ALTER TABLE lead_transfer ENGINE = InnoDB');
$this->addSql('ALTER TABLE lead_transfer CHARACTER SET = utf8mb4');
$this->addSql('
ALTER TABLE lead_transfer
CHANGE leads_id lead_id INT DEFAULT NULL,
CHANGE administrators_id user_id INT DEFAULT NULL,
CHANGE from_administrators_id sender_id INT DEFAULT NULL,
CHANGE to_administrators_id receiver_id INT DEFAULT NULL,
CHANGE date_added created_at DATETIME NOT NULL
');
$this->addSql('DROP INDEX idx_administrators_id ON lead_transfer');
$this->addSql('DROP INDEX idx_leads_id ON lead_transfer');
$this->addSql('DROP INDEX idx_from_administrators_id ON lead_transfer');
$this->addSql('DROP INDEX idx_to_administrators_id ON lead_transfer');
$this->addSql('CREATE INDEX IDX_EA6721C355458D ON lead_transfer (lead_id)');
$this->addSql('CREATE INDEX IDX_EA6721C3A76ED395 ON lead_transfer (user_id)');
$this->addSql('CREATE INDEX IDX_EA6721C3F624B39D ON lead_transfer (sender_id)');
$this->addSql('CREATE INDEX IDX_EA6721C3CD53EDB6 ON lead_transfer (receiver_id)');
$this->addSql('UPDATE lead SET user_id = NULL WHERE user_id NOT IN (SELECT id FROM user)');
$this->addSql('UPDATE lead SET customer_id = NULL WHERE customer_id NOT IN (SELECT id FROM customer)');
$this->addSql('UPDATE lead SET source_id = NULL WHERE source_id NOT IN (SELECT id FROM config_source)');
$this->addSql('UPDATE lead SET level_id = NULL WHERE level_id NOT IN (SELECT id FROM config_level)');
$this->addSql('UPDATE lead SET debt_option_id = NULL WHERE debt_option_id NOT IN (SELECT id FROM config_debt_option)');
$this->addSql('UPDATE lead SET tax_issue_id = NULL WHERE tax_issue_id NOT IN (SELECT id FROM config_tax_issue)');
$this->addSql('DELETE FROM lead_transfer WHERE lead_id NOT IN (SELECT id FROM lead)');
$this->addSql('UPDATE lead_transfer SET user_id = NULL WHERE user_id NOT IN (SELECT id FROM user)');
$this->addSql('UPDATE lead_transfer SET sender_id = NULL WHERE sender_id NOT IN (SELECT id FROM user)');
$this->addSql('UPDATE lead_transfer SET receiver_id = NULL WHERE receiver_id NOT IN (SELECT id FROM user)');
$this->addSql('ALTER TABLE lead ADD CONSTRAINT FK_289161CBA76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE SET NULL');
$this->addSql('ALTER TABLE lead ADD CONSTRAINT FK_289161CB9395C3F3 FOREIGN KEY (customer_id) REFERENCES customer (id) ON DELETE SET NULL');
$this->addSql('ALTER TABLE lead ADD CONSTRAINT FK_289161CB953C1C61 FOREIGN KEY (source_id) REFERENCES config_source (id) ON DELETE SET NULL');
$this->addSql('ALTER TABLE lead ADD CONSTRAINT FK_289161CB5FB14BA7 FOREIGN KEY (level_id) REFERENCES config_level (id) ON DELETE SET NULL');
$this->addSql('ALTER TABLE lead ADD CONSTRAINT FK_289161CBD456175A FOREIGN KEY (debt_option_id) REFERENCES config_debt_option (id) ON DELETE SET NULL');
$this->addSql('ALTER TABLE lead ADD CONSTRAINT FK_289161CBBEEE0432 FOREIGN KEY (tax_issue_id) REFERENCES config_tax_issue (id) ON DELETE SET NULL');
$this->addSql('ALTER TABLE lead_transfer ADD CONSTRAINT FK_EA6721C355458D FOREIGN KEY (lead_id) REFERENCES lead (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE lead_transfer ADD CONSTRAINT FK_EA6721C3A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE SET NULL');
$this->addSql('ALTER TABLE lead_transfer ADD CONSTRAINT FK_EA6721C3F624B39D FOREIGN KEY (sender_id) REFERENCES user (id) ON DELETE SET NULL');
$this->addSql('ALTER TABLE lead_transfer ADD CONSTRAINT FK_EA6721C3CD53EDB6 FOREIGN KEY (receiver_id) REFERENCES user (id) ON DELETE SET NULL');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->abortIf('mysql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'mysql\'.');
$this->addSql('ALTER TABLE lead_transfer DROP FOREIGN KEY FK_EA6721C355458D');
$this->addSql('ALTER TABLE lead_transfer DROP FOREIGN KEY FK_EA6721C3A76ED395');
$this->addSql('ALTER TABLE lead_transfer DROP FOREIGN KEY FK_EA6721C3F624B39D');
$this->addSql('ALTER TABLE lead_transfer DROP FOREIGN KEY FK_EA6721C3CD53EDB6');
$this->addSql('ALTER TABLE lead DROP FOREIGN KEY FK_289161CBBEEE0432');
$this->addSql('ALTER TABLE lead DROP FOREIGN KEY FK_289161CBD456175A');
$this->addSql('ALTER TABLE lead DROP FOREIGN KEY FK_289161CB5FB14BA7');
$this->addSql('ALTER TABLE lead DROP FOREIGN KEY FK_289161CB953C1C61');
$this->addSql('ALTER TABLE lead DROP FOREIGN KEY FK_289161CB9395C3F3');
$this->addSql('ALTER TABLE lead DROP FOREIGN KEY FK_289161CBA76ED395');
$this->addSql('RENAME TABLE lead TO leads');
$this->addSql('ALTER TABLE leads ENGINE = MyISAM');
$this->addSql('ALTER TABLE leads CHARACTER SET = latin1');
$this->addSql('
ALTER TABLE leads
CHANGE user_id administrators_id INT NOT NULL,
CHANGE customer_id customers_id INT NOT NULL,
CHANGE source_id source_id INT NOT NULL,
CHANGE level_id level TINYINT(1) DEFAULT \'0\',
CHANGE debt_option_id tax_debt_id INT DEFAULT NULL,
CHANGE tax_issue_id tax_issues_id INT DEFAULT NULL,
CHANGE name name VARCHAR(64) NOT NULL,
CHANGE phone_number telephone_1 VARCHAR(32) DEFAULT NULL,
CHANGE phone_number2 telephone_2 VARCHAR(32) DEFAULT NULL,
CHANGE email email_address VARCHAR(255) DEFAULT NULL,
CHANGE disposition disposition VARCHAR(255) DEFAULT NULL,
CHANGE type type VARCHAR(255) DEFAULT NULL,
CHANGE street street_address VARCHAR(64) NOT NULL,
CHANGE city city VARCHAR(32) NOT NULL,
CHANGE state state VARCHAR(32) DEFAULT NULL,
CHANGE zip postcode VARCHAR(10) NOT NULL,
CHANGE description comments TEXT DEFAULT NULL,
CHANGE enabled status TINYINT(1) DEFAULT \'0\',
CHANGE created_at date_added DATETIME DEFAULT NULL,
CHANGE modified_at last_modified DATETIME DEFAULT NULL
');
$this->addSql('UPDATE leads SET disposition = \'1\' WHERE disposition = \'transfer\'');
$this->addSql('UPDATE leads SET disposition = \'2\' WHERE disposition = \'left_message\'');
$this->addSql('UPDATE leads SET disposition = \'8\' WHERE disposition = \'call_back\'');
$this->addSql('UPDATE leads SET disposition = \'3\' WHERE disposition = \'no_answer\'');
$this->addSql('UPDATE leads SET disposition = \'4\' WHERE disposition = \'wrong_number\'');
$this->addSql('UPDATE leads SET disposition = \'5\' WHERE disposition = \'no_tax_issue\'');
$this->addSql('UPDATE leads SET disposition = \'9\' WHERE disposition = \'hung_up\'');
$this->addSql('UPDATE leads SET disposition = \'6\' WHERE disposition = \'do_not_call\'');
$this->addSql('UPDATE leads SET disposition = \'7\' WHERE disposition = \'unsubscribe7\'');
$this->addSql('UPDATE leads SET disposition = \'10\' WHERE disposition = \'fake_lead\'');
$this->addSql('UPDATE leads SET type = \'0\' WHERE type = \'form\'');
$this->addSql('UPDATE leads SET type = \'1\' WHERE type = \'call\'');
$this->addSql('UPDATE leads SET type = \'2\' WHERE type = \'timed\'');
$this->addSql('UPDATE leads SET type = \'4\' WHERE type = \'chat\'');
$this->addSql('UPDATE leads SET type = \'5\' WHERE type = \'handoff\'');
$this->addSql('ALTER TABLE leads CHANGE disposition disposition TINYINT(1) DEFAULT \'0\'');
$this->addSql('ALTER TABLE leads CHANGE type type TINYINT(1) DEFAULT \'0\'');
$this->addSql('DROP INDEX IDX_289161CBA76ED395 ON leads');
$this->addSql('DROP INDEX IDX_289161CB9395C3F3 ON leads');
$this->addSql('DROP INDEX IDX_289161CB953C1C61 ON leads');
$this->addSql('DROP INDEX IDX_289161CB5FB14BA7 ON leads');
$this->addSql('DROP INDEX IDX_289161CBD456175A ON leads');
$this->addSql('DROP INDEX IDX_289161CBBEEE0432 ON leads');
$this->addSql('CREATE INDEX idx_administrators_id ON leads (administrators_id)');
$this->addSql('CREATE INDEX idx_customers_id ON leads (customers_id)');
$this->addSql('CREATE INDEX idx_source_id ON leads (source_id)');
$this->addSql('RENAME TABLE lead_transfer TO leads_transfers');
$this->addSql('ALTER TABLE leads_transfers ENGINE = InnoDB');
$this->addSql('ALTER TABLE leads_transfers CHARACTER SET = utf8mb4');
$this->addSql('
ALTER TABLE leads_transfers
CHANGE lead_id leads_id INT NOT NULL,
CHANGE user_id administrators_id INT NOT NULL,
CHANGE sender_id from_administrators_id INT DEFAULT NULL,
CHANGE receiver_id to_administrators_id INT DEFAULT NULL,
CHANGE created_at date_added DATETIME DEFAULT NULL
');
$this->addSql('DROP INDEX IDX_EA6721C355458D ON leads_transfers');
$this->addSql('DROP INDEX IDX_EA6721C3A76ED395 ON leads_transfers');
$this->addSql('DROP INDEX IDX_EA6721C3F624B39D ON leads_transfers');
$this->addSql('DROP INDEX IDX_EA6721C3CD53EDB6 ON leads_transfers');
$this->addSql('CREATE INDEX idx_administrators_id ON leads_transfers (administrators_id)');
$this->addSql('CREATE INDEX idx_leads_id ON leads_transfers (leads_id)');
$this->addSql('CREATE INDEX idx_from_administrators_id ON leads_transfers (from_administrators_id)');
$this->addSql('CREATE INDEX idx_to_administrators_id ON leads_transfers (to_administrators_id)');
}
}

migrations/Version20180814170404.php line 1