<?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 Version20190626072543 extends AbstractMigration
{
    public function getDescription() : string
    {
        return '';
    }

    public function up(Schema $schema) : void
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE TABLE event_log (id INT AUTO_INCREMENT NOT NULL, created_by_id INT DEFAULT NULL, old_user_id INT DEFAULT NULL, new_user_id INT DEFAULT NULL, old_status_id INT DEFAULT NULL, new_status_id INT DEFAULT NULL, content_id INT DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, discr VARCHAR(255) NOT NULL, INDEX IDX_9EF0AD16B03A8386 (created_by_id), INDEX IDX_9EF0AD16D4FB0AC5 (old_user_id), INDEX IDX_9EF0AD167C2D807B (new_user_id), INDEX IDX_9EF0AD162E43440C (old_status_id), INDEX IDX_9EF0AD16596805D2 (new_status_id), INDEX IDX_9EF0AD1684A0A3ED (content_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE file_association (id INT AUTO_INCREMENT NOT NULL, file_id INT DEFAULT NULL, campaign_id INT DEFAULT NULL, notice_id INT DEFAULT NULL, content_id INT DEFAULT NULL, negotiation_message_id INT DEFAULT NULL, task_id INT DEFAULT NULL, comment_id INT DEFAULT NULL, type VARCHAR(255) DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, discr VARCHAR(255) NOT NULL, INDEX IDX_DF3EDFAE93CB796C (file_id), INDEX IDX_DF3EDFAEF639F774 (campaign_id), INDEX IDX_DF3EDFAE7D540AB (notice_id), INDEX IDX_DF3EDFAE84A0A3ED (content_id), INDEX IDX_DF3EDFAE735468F9 (negotiation_message_id), INDEX IDX_DF3EDFAE8DB60186 (task_id), INDEX IDX_DF3EDFAEF8697D13 (comment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE copyscape_report (id INT AUTO_INCREMENT NOT NULL, created_by_id INT NOT NULL, content_id INT NOT NULL, description LONGTEXT NOT NULL, matched TINYINT(1) DEFAULT NULL, text LONGTEXT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_5195DF77B03A8386 (created_by_id), UNIQUE INDEX UNIQ_5195DF7784A0A3ED (content_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE time_log_type_category (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(50) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE content_version (id INT AUTO_INCREMENT NOT NULL, created_by_id INT NOT NULL, content_id INT DEFAULT NULL, description LONGTEXT NOT NULL, word_count INT DEFAULT NULL, autosaved TINYINT(1) DEFAULT \'0\' NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_60140A70B03A8386 (created_by_id), INDEX IDX_60140A7084A0A3ED (content_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE country (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(255) NOT NULL, semrush_id INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE role (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(100) NOT NULL, role VARCHAR(100) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE stat (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(255) NOT NULL, symbol VARCHAR(10) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE content_placement (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(50) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE content_workflow (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(20) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE content_status (id INT AUTO_INCREMENT NOT NULL, workflow_id INT NOT NULL, title VARCHAR(255) NOT NULL, order_lvl INT DEFAULT NULL, options LONGTEXT DEFAULT NULL, content_lock TINYINT(1) DEFAULT \'0\' NOT NULL, enable_copyscape TINYINT(1) DEFAULT \'0\' NOT NULL, INDEX IDX_133615B02C7C2CBA (workflow_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE content_type (id INT AUTO_INCREMENT NOT NULL, workflow_id INT NOT NULL, title VARCHAR(50) NOT NULL, INDEX IDX_41BCBAEC2C7C2CBA (workflow_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE comment (id INT AUTO_INCREMENT NOT NULL, created_by_id INT DEFAULT NULL, content_id INT DEFAULT NULL, task_id INT DEFAULT NULL, description LONGTEXT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, discr VARCHAR(255) NOT NULL, INDEX IDX_9474526CB03A8386 (created_by_id), INDEX IDX_9474526C84A0A3ED (content_id), INDEX IDX_9474526C8DB60186 (task_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE dashboard (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, title VARCHAR(100) NOT NULL, options LONGTEXT DEFAULT NULL, template TINYINT(1) NOT NULL, description LONGTEXT DEFAULT NULL, main TINYINT(1) NOT NULL, INDEX IDX_5C94FFF8A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE negotiation (id INT AUTO_INCREMENT NOT NULL, prospect_id INT DEFAULT NULL, status_id INT DEFAULT NULL, content_id INT DEFAULT NULL, user_id INT DEFAULT NULL, campaign_id INT DEFAULT NULL, research_id INT DEFAULT NULL, currency_id INT DEFAULT NULL, cost_proposed NUMERIC(10, 0) DEFAULT NULL, cost_agreed NUMERIC(10, 0) DEFAULT NULL, email VARCHAR(20) DEFAULT NULL, INDEX IDX_17989598D182060A (prospect_id), INDEX IDX_179895986BF700BD (status_id), INDEX IDX_1798959884A0A3ED (content_id), INDEX IDX_17989598A76ED395 (user_id), INDEX IDX_17989598F639F774 (campaign_id), INDEX IDX_179895987909E1ED (research_id), INDEX IDX_1798959838248176 (currency_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE research (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, campaign_id INT NOT NULL, status_id INT NOT NULL, content_type_id INT DEFAULT NULL, prospect_research_active TINYINT(1) DEFAULT \'0\', INDEX IDX_57EB50C2A76ED395 (user_id), INDEX IDX_57EB50C2F639F774 (campaign_id), INDEX IDX_57EB50C26BF700BD (status_id), INDEX IDX_57EB50C21A445520 (content_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE research_prospect (research_id INT NOT NULL, prospect_id INT NOT NULL, INDEX IDX_3435DBB77909E1ED (research_id), INDEX IDX_3435DBB7D182060A (prospect_id), PRIMARY KEY(research_id, prospect_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE currency (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(50) NOT NULL, symbol VARCHAR(10) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE content (id INT AUTO_INCREMENT NOT NULL, campaign_id INT DEFAULT NULL, user_id INT DEFAULT NULL, status_id INT DEFAULT NULL, type_id INT NOT NULL, placement_id INT DEFAULT NULL, title VARCHAR(255) NOT NULL, due_date VARCHAR(255) DEFAULT NULL, desired_word_count INT DEFAULT 700 NOT NULL, anchor_href VARCHAR(255) DEFAULT NULL, anchor_text VARCHAR(255) DEFAULT NULL, word_count INT DEFAULT 0 NOT NULL, priority SMALLINT DEFAULT 0, meta_description VARCHAR(255) DEFAULT NULL, meta_title VARCHAR(255) DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_FEC530A9F639F774 (campaign_id), INDEX IDX_FEC530A9A76ED395 (user_id), INDEX IDX_FEC530A96BF700BD (status_id), INDEX IDX_FEC530A9C54C8C93 (type_id), INDEX IDX_FEC530A92F966E9D (placement_id), FULLTEXT INDEX IDX_FEC530A92B36786B (title), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE negotiation_status (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(255) NOT NULL, order_lvl INT DEFAULT NULL, options LONGTEXT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE mailgun_event (id INT AUTO_INCREMENT NOT NULL, negotiation_message_id INT NOT NULL, title VARCHAR(100) NOT NULL, timestamp DATETIME NOT NULL, description LONGTEXT DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_1271933F735468F9 (negotiation_message_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE password_token (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, token VARCHAR(50) NOT NULL, expires_at DATETIME NOT NULL, type ENUM(\'NEW\', \'RESET\') NOT NULL COMMENT \'(DC2Type:EnumPasswordTokenTypeType)\', created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_BEAB6C24A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign (id INT AUTO_INCREMENT NOT NULL, domain_id INT DEFAULT NULL, client_id INT NOT NULL, level_id INT DEFAULT NULL, content_writer_id INT DEFAULT NULL, targeted_country_id INT NOT NULL, title VARCHAR(255) NOT NULL, description LONGTEXT DEFAULT NULL, approvement ENUM(\'MANUAL\', \'AUTOMATIC\', \'AFTER2WEEKS\') DEFAULT NULL COMMENT \'(DC2Type:EnumApprovementType)\', start_date DATE DEFAULT NULL, end_date DATE DEFAULT NULL, ppc TINYINT(1) NOT NULL, random_content_assignment TINYINT(1) NOT NULL, google_analytics_profile_id VARCHAR(255) DEFAULT NULL, semrush_id VARCHAR(255) DEFAULT NULL, assigned_content_writer TINYINT(1) NOT NULL, campaign_start_date DATE DEFAULT NULL, INDEX IDX_1F1512DD115F0EE5 (domain_id), INDEX IDX_1F1512DD19EB6921 (client_id), INDEX IDX_1F1512DD5FB14BA7 (level_id), INDEX IDX_1F1512DD2B20AEB5 (content_writer_id), INDEX IDX_1F1512DD7C16B6A4 (targeted_country_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_campaign_bolton (campaign_id INT NOT NULL, bolton_id INT NOT NULL, INDEX IDX_250FAAD6F639F774 (campaign_id), INDEX IDX_250FAAD618691A53 (bolton_id), PRIMARY KEY(campaign_id, bolton_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE link_check (id INT AUTO_INCREMENT NOT NULL, link_id INT NOT NULL, status_code INT NOT NULL, response_time DOUBLE PRECISION NOT NULL, anchor_href TINYINT(1) NOT NULL, anchor_text VARCHAR(255) DEFAULT NULL, rel_no_follow TINYINT(1) DEFAULT NULL, output LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:array)\', page_authority INT NOT NULL, positive TINYINT(1) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_9335F0CDADA40271 (link_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_bolton (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(255) NOT NULL, options LONGTEXT DEFAULT NULL, content_hours INT DEFAULT 0, technical_hours INT DEFAULT 0, link_target INT DEFAULT 0, guest_posts INT DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_keyword_check (id INT AUTO_INCREMENT NOT NULL, keyword_id INT NOT NULL, position INT NOT NULL, day DATE NOT NULL, google_ad_words_cpc VARCHAR(10) DEFAULT NULL, monthly_searches VARCHAR(10) DEFAULT NULL, diff1 INT DEFAULT NULL, diff7 INT DEFAULT NULL, diff30 INT DEFAULT NULL, landing_url VARCHAR(255) DEFAULT NULL, diff INT DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_135B36C8115D4552 (keyword_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_keyword_tag (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(255) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_report (id INT AUTO_INCREMENT NOT NULL, campaign_id INT NOT NULL, created_by_id INT DEFAULT NULL, user_id INT DEFAULT NULL, preset_id INT DEFAULT NULL, file_id INT DEFAULT NULL, title VARCHAR(255) NOT NULL, description LONGTEXT DEFAULT NULL, date_from DATE NOT NULL, date_to DATE NOT NULL, client_available TINYINT(1) DEFAULT \'0\' NOT NULL, seen_at DATETIME DEFAULT NULL, conclusion ENUM(\'NEGATIVE\', \'NEUTRAL\', \'POSITIVE\') DEFAULT NULL COMMENT \'(DC2Type:EnumConclusionType)\', created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_196C0E29F639F774 (campaign_id), INDEX IDX_196C0E29B03A8386 (created_by_id), INDEX IDX_196C0E29A76ED395 (user_id), INDEX IDX_196C0E2980688E6F (preset_id), UNIQUE INDEX UNIQ_196C0E2993CB796C (file_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_credential (id INT AUTO_INCREMENT NOT NULL, campaign_id INT NOT NULL, account VARCHAR(255) NOT NULL, url VARCHAR(255) NOT NULL, username VARCHAR(255) NOT NULL, password VARCHAR(255) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_C2683DE3F639F774 (campaign_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_task_activity (id INT AUTO_INCREMENT NOT NULL, task_id INT NOT NULL, created_by_id INT NOT NULL, title VARCHAR(255) NOT NULL, options LONGTEXT DEFAULT NULL, type VARCHAR(255) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_2D884E6C8DB60186 (task_id), INDEX IDX_2D884E6CB03A8386 (created_by_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_task (id INT AUTO_INCREMENT NOT NULL, tasklist_id INT NOT NULL, user_id INT DEFAULT NULL, created_by_id INT DEFAULT NULL, title LONGTEXT NOT NULL, description LONGTEXT DEFAULT NULL, completed_at DATETIME DEFAULT NULL, completed TINYINT(1) DEFAULT \'0\', due_at DATE DEFAULT NULL, priority SMALLINT DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_5399E0C7FF3475DB (tasklist_id), INDEX IDX_5399E0C7A76ED395 (user_id), INDEX IDX_5399E0C7B03A8386 (created_by_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_tasklist (id INT AUTO_INCREMENT NOT NULL, created_by_id INT NOT NULL, campaign_id INT DEFAULT NULL, time_log_type_id INT DEFAULT NULL, title VARCHAR(255) NOT NULL, description LONGTEXT DEFAULT NULL, template TINYINT(1) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_5451CF1AB03A8386 (created_by_id), INDEX IDX_5451CF1AF639F774 (campaign_id), INDEX IDX_5451CF1A23B2B0ED (time_log_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_role (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(50) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_keyword (id INT AUTO_INCREMENT NOT NULL, campaign_id INT NOT NULL, latest_check_id INT DEFAULT NULL, title VARCHAR(255) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_F229ED17F639F774 (campaign_id), UNIQUE INDEX UNIQ_F229ED172B4E498C (latest_check_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_keyword_keyword_tag (keyword_id INT NOT NULL, tag_id INT NOT NULL, INDEX IDX_2CFD29A6115D4552 (keyword_id), INDEX IDX_2CFD29A6BAD26311 (tag_id), PRIMARY KEY(keyword_id, tag_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_level (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(255) NOT NULL, options LONGTEXT DEFAULT NULL, link_target INT DEFAULT 0, guest_posts INT DEFAULT 0, colour VARCHAR(7) DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_report_element_type (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(255) NOT NULL, options LONGTEXT DEFAULT NULL, component VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_report_element_type_preset (id INT AUTO_INCREMENT NOT NULL, type_id INT NOT NULL, title VARCHAR(255) NOT NULL, options LONGTEXT NOT NULL, INDEX IDX_22BAF9C4C54C8C93 (type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_report_element (id INT AUTO_INCREMENT NOT NULL, type_id INT NOT NULL, preset_id INT DEFAULT NULL, title VARCHAR(255) NOT NULL, value LONGTEXT DEFAULT NULL, options LONGTEXT DEFAULT NULL, order_lvl INT DEFAULT 0, subject_type VARCHAR(255) NOT NULL, subject_id INT NOT NULL, INDEX IDX_91C887B6C54C8C93 (type_id), INDEX IDX_91C887B680688E6F (preset_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_report_preset (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(255) NOT NULL, description LONGTEXT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_hours (id INT AUTO_INCREMENT NOT NULL, campaign_id INT NOT NULL, category_id INT NOT NULL, start_of_the_month DATE NOT NULL, hours INT NOT NULL, INDEX IDX_C41FD9E2F639F774 (campaign_id), INDEX IDX_C41FD9E212469DE2 (category_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_schedule (id INT AUTO_INCREMENT NOT NULL, campaign_id INT NOT NULL, created_by_id INT DEFAULT NULL, type ENUM(\'ACTIONS\', \'CONTENTS\', \'RESEARCHES\', \'REPORTS\', \'TASK_LISTS\') NOT NULL COMMENT \'(DC2Type:EnumCampaignScheduleType)\', options LONGTEXT DEFAULT NULL, execute_at DATETIME DEFAULT NULL, executed_at DATETIME DEFAULT NULL, output LONGTEXT DEFAULT NULL, origin VARCHAR(255) DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_6848C784F639F774 (campaign_id), INDEX IDX_6848C784B03A8386 (created_by_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_notice (id INT AUTO_INCREMENT NOT NULL, campaign_id INT NOT NULL, created_by_id INT NOT NULL, title VARCHAR(255) NOT NULL, description LONGTEXT DEFAULT NULL, priority ENUM(\'1\', \'2\', \'3\', \'4\') DEFAULT NULL COMMENT \'(DC2Type:EnumNoticePriorityType)\', created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_954E3C6FF639F774 (campaign_id), INDEX IDX_954E3C6FB03A8386 (created_by_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_social_link (id INT AUTO_INCREMENT NOT NULL, campaign_id INT NOT NULL, account VARCHAR(255) NOT NULL, url VARCHAR(255) NOT NULL, managed_by_us TINYINT(1) DEFAULT \'0\', created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_A177766FF639F774 (campaign_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_team (id INT AUTO_INCREMENT NOT NULL, campaign_id INT NOT NULL, user_id INT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_C5079DFDF639F774 (campaign_id), INDEX IDX_C5079DFDA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE campaign_team_role (team_member_id INT NOT NULL, role_id INT NOT NULL, INDEX IDX_4600626AC292CD19 (team_member_id), INDEX IDX_4600626AD60322AC (role_id), PRIMARY KEY(team_member_id, role_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE client_contact (id INT AUTO_INCREMENT NOT NULL, client_id INT NOT NULL, main TINYINT(1) NOT NULL, name VARCHAR(255) DEFAULT NULL, phone VARCHAR(255) DEFAULT NULL, mobile VARCHAR(255) DEFAULT NULL, email VARCHAR(255) DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_1E5FA24519EB6921 (client_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE client_contact_department (client_contact_id INT NOT NULL, department_id INT NOT NULL, INDEX IDX_603ED30D77F5180B (client_contact_id), INDEX IDX_603ED30DAE80F5DF (department_id), PRIMARY KEY(client_contact_id, department_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE link (id INT AUTO_INCREMENT NOT NULL, prospect_id INT NOT NULL, content_id INT NOT NULL, negotiation_id INT NOT NULL, fail_check_id INT DEFAULT NULL, url VARCHAR(255) NOT NULL, status ENUM(\'ACTIVE\', \'INACTIVE\', \'PROBLEM\', \'PENALTY\') DEFAULT NULL COMMENT \'(DC2Type:EnumLinkStatusType)\', checked_at DATETIME DEFAULT NULL, ip_from VARCHAR(50) DEFAULT NULL, ip_to VARCHAR(50) DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_36AC99F1D182060A (prospect_id), INDEX IDX_36AC99F184A0A3ED (content_id), UNIQUE INDEX UNIQ_36AC99F167A34946 (negotiation_id), UNIQUE INDEX UNIQ_36AC99F14A8DFB0C (fail_check_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, avatar_id INT DEFAULT NULL, client_id INT DEFAULT NULL, first_name VARCHAR(255) NOT NULL, last_name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, job_title VARCHAR(255) NOT NULL, password VARCHAR(64) DEFAULT NULL, active TINYINT(1) DEFAULT \'0\' NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_8D93D64986383B10 (avatar_id), INDEX IDX_8D93D64919EB6921 (client_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE user_role (user_id INT NOT NULL, role_id INT NOT NULL, INDEX IDX_2DE8C6A3A76ED395 (user_id), INDEX IDX_2DE8C6A3D60322AC (role_id), PRIMARY KEY(user_id, role_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE negotiation_message (id INT AUTO_INCREMENT NOT NULL, prospect_id INT NOT NULL, user_id INT NOT NULL, negotiation_id INT NOT NULL, description LONGTEXT NOT NULL, direction ENUM(\'INBOUND\', \'OUTBOUND\') NOT NULL COMMENT \'(DC2Type:EnumMessageDirectionType)\', read_at DATETIME DEFAULT NULL, attach_content_format ENUM(\'NONE\', \'PDF\', \'DOCX\') DEFAULT \'NONE\' COMMENT \'(DC2Type:EnumNegotiationMessageAttachContentType)\', created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_A095F861D182060A (prospect_id), INDEX IDX_A095F861A76ED395 (user_id), INDEX IDX_A095F86167A34946 (negotiation_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE client_department (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(50) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE file (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(255) NOT NULL, description LONGTEXT DEFAULT NULL, filename VARCHAR(255) NOT NULL, path VARCHAR(255) NOT NULL, mimetype VARCHAR(255) NOT NULL, size INT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE time_log (id INT AUTO_INCREMENT NOT NULL, campaign_id INT NOT NULL, user_id INT DEFAULT NULL, type_id INT DEFAULT NULL, time_spent INT NOT NULL, date_from VARCHAR(255) NOT NULL, date_to VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, subject_type VARCHAR(255) DEFAULT NULL, subject_id INT DEFAULT NULL, subject LONGTEXT DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_55BE03AFF639F774 (campaign_id), INDEX IDX_55BE03AFA76ED395 (user_id), INDEX IDX_55BE03AFC54C8C93 (type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE prospect_problem (id INT AUTO_INCREMENT NOT NULL, prospect_id INT NOT NULL, source VARCHAR(50) NOT NULL, description LONGTEXT NOT NULL, read_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_14ABDC1CD182060A (prospect_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE billing (id INT AUTO_INCREMENT NOT NULL, link_id INT DEFAULT NULL, cost NUMERIC(10, 2) NOT NULL, due_date DATE NOT NULL, paid_date DATETIME DEFAULT NULL, status ENUM(\'PAID\', \'UNPAID\') NOT NULL COMMENT \'(DC2Type:EnumBillingStatusType)\', created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_EC224CAAADA40271 (link_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE prospect (id INT AUTO_INCREMENT NOT NULL, domain_id INT DEFAULT NULL, country_id INT NOT NULL, currency_id INT DEFAULT NULL, status ENUM(\'NEW\', \'REMOVED\', \'PREQUALIFIED\', \'APPROACHED\', \'REJECTED\', \'ACTIVE\', \'PARTNER\') NOT NULL COMMENT \'(DC2Type:EnumProspectStatusType)\', paypal_email VARCHAR(100) DEFAULT NULL, comment LONGTEXT DEFAULT NULL, score INT DEFAULT 50 NOT NULL, type VARCHAR(255) NOT NULL, guidelines VARCHAR(255) DEFAULT NULL, contact_page VARCHAR(255) DEFAULT NULL, name VARCHAR(255) DEFAULT NULL, phone VARCHAR(255) DEFAULT NULL, mobile VARCHAR(255) DEFAULT NULL, email VARCHAR(255) DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_C9CE8C7D115F0EE5 (domain_id), INDEX IDX_C9CE8C7DF92F3E70 (country_id), INDEX IDX_C9CE8C7D38248176 (currency_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE prospect_category (prospect_id INT NOT NULL, category_id INT NOT NULL, INDEX IDX_8731431CD182060A (prospect_id), INDEX IDX_8731431C12469DE2 (category_id), PRIMARY KEY(prospect_id, category_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE domain (id INT AUTO_INCREMENT NOT NULL, protocol ENUM(\'http://\', \'https://\') NOT NULL COMMENT \'(DC2Type:EnumHttpProtocolType)\', url VARCHAR(255) NOT NULL, checked_at DATETIME DEFAULT NULL, url_type ENUM(\'ROOTDOMAIN\', \'SUBDOMAIN\') DEFAULT \'ROOTDOMAIN\' NOT NULL COMMENT \'(DC2Type:EnumDomainUrlType)\', ip VARCHAR(20) DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE time_log_type (id INT AUTO_INCREMENT NOT NULL, category_id INT DEFAULT NULL, title VARCHAR(255) NOT NULL, INDEX IDX_3935FA9012469DE2 (category_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE user_note (id INT AUTO_INCREMENT NOT NULL, created_by_id INT NOT NULL, description LONGTEXT NOT NULL, colour VARCHAR(255) DEFAULT NULL, order_lvl INT DEFAULT 0 NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_B53CB6DDB03A8386 (created_by_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE domain_topic_trustflow (id INT AUTO_INCREMENT NOT NULL, domain_id INT NOT NULL, topic_id INT NOT NULL, value INT NOT NULL, INDEX IDX_A10009115F0EE5 (domain_id), INDEX IDX_A100091F55203D (topic_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE domain_stat (id INT AUTO_INCREMENT NOT NULL, domain_id INT NOT NULL, stat_id INT NOT NULL, value INT DEFAULT NULL, checked_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_8D64D246115F0EE5 (domain_id), INDEX IDX_8D64D2469502F0B (stat_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE domain_majestic_topic (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE domain_check (id INT AUTO_INCREMENT NOT NULL, stat_id INT NOT NULL, value INT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_EFF584C59502F0B (stat_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE category (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE client (id INT AUTO_INCREMENT NOT NULL, address_country_id INT DEFAULT NULL, title VARCHAR(255) NOT NULL, address_line1 VARCHAR(255) DEFAULT NULL, address_line2 VARCHAR(255) DEFAULT NULL, address_postcode VARCHAR(10) DEFAULT NULL, address_city VARCHAR(255) DEFAULT NULL, INDEX IDX_C744045581B2B6EE (address_country_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE research_status (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(50) NOT NULL, order_lvl INT DEFAULT 0, options LONGTEXT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE cron_report (id INT AUTO_INCREMENT NOT NULL, job_id INT DEFAULT NULL, run_at DATETIME NOT NULL, run_time DOUBLE PRECISION NOT NULL, exit_code INT NOT NULL, output LONGTEXT NOT NULL, INDEX IDX_B6C6A7F5BE04EA9 (job_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('CREATE TABLE cron_job (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, command VARCHAR(1024) NOT NULL, schedule VARCHAR(191) NOT NULL, description VARCHAR(191) NOT NULL, enabled TINYINT(1) NOT NULL, UNIQUE INDEX un_name (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('ALTER TABLE event_log ADD CONSTRAINT FK_9EF0AD16B03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE event_log ADD CONSTRAINT FK_9EF0AD16D4FB0AC5 FOREIGN KEY (old_user_id) REFERENCES user (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE event_log ADD CONSTRAINT FK_9EF0AD167C2D807B FOREIGN KEY (new_user_id) REFERENCES user (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE event_log ADD CONSTRAINT FK_9EF0AD162E43440C FOREIGN KEY (old_status_id) REFERENCES content_status (id)');
        $this->addSql('ALTER TABLE event_log ADD CONSTRAINT FK_9EF0AD16596805D2 FOREIGN KEY (new_status_id) REFERENCES content_status (id)');
        $this->addSql('ALTER TABLE event_log ADD CONSTRAINT FK_9EF0AD1684A0A3ED FOREIGN KEY (content_id) REFERENCES content (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE file_association ADD CONSTRAINT FK_DF3EDFAE93CB796C FOREIGN KEY (file_id) REFERENCES file (id)');
        $this->addSql('ALTER TABLE file_association ADD CONSTRAINT FK_DF3EDFAEF639F774 FOREIGN KEY (campaign_id) REFERENCES campaign (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE file_association ADD CONSTRAINT FK_DF3EDFAE7D540AB FOREIGN KEY (notice_id) REFERENCES campaign_notice (id)');
        $this->addSql('ALTER TABLE file_association ADD CONSTRAINT FK_DF3EDFAE84A0A3ED FOREIGN KEY (content_id) REFERENCES content (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE file_association ADD CONSTRAINT FK_DF3EDFAE735468F9 FOREIGN KEY (negotiation_message_id) REFERENCES negotiation_message (id)');
        $this->addSql('ALTER TABLE file_association ADD CONSTRAINT FK_DF3EDFAE8DB60186 FOREIGN KEY (task_id) REFERENCES campaign_task (id)');
        $this->addSql('ALTER TABLE file_association ADD CONSTRAINT FK_DF3EDFAEF8697D13 FOREIGN KEY (comment_id) REFERENCES comment (id)');
        $this->addSql('ALTER TABLE copyscape_report ADD CONSTRAINT FK_5195DF77B03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE copyscape_report ADD CONSTRAINT FK_5195DF7784A0A3ED FOREIGN KEY (content_id) REFERENCES content (id)');
        $this->addSql('ALTER TABLE content_version ADD CONSTRAINT FK_60140A70B03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE content_version ADD CONSTRAINT FK_60140A7084A0A3ED FOREIGN KEY (content_id) REFERENCES content (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE content_status ADD CONSTRAINT FK_133615B02C7C2CBA FOREIGN KEY (workflow_id) REFERENCES content_workflow (id)');
        $this->addSql('ALTER TABLE content_type ADD CONSTRAINT FK_41BCBAEC2C7C2CBA FOREIGN KEY (workflow_id) REFERENCES content_workflow (id)');
        $this->addSql('ALTER TABLE comment ADD CONSTRAINT FK_9474526CB03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE comment ADD CONSTRAINT FK_9474526C84A0A3ED FOREIGN KEY (content_id) REFERENCES content (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE comment ADD CONSTRAINT FK_9474526C8DB60186 FOREIGN KEY (task_id) REFERENCES campaign_task (id)');
        $this->addSql('ALTER TABLE dashboard ADD CONSTRAINT FK_5C94FFF8A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE negotiation ADD CONSTRAINT FK_17989598D182060A FOREIGN KEY (prospect_id) REFERENCES prospect (id)');
        $this->addSql('ALTER TABLE negotiation ADD CONSTRAINT FK_179895986BF700BD FOREIGN KEY (status_id) REFERENCES negotiation_status (id)');
        $this->addSql('ALTER TABLE negotiation ADD CONSTRAINT FK_1798959884A0A3ED FOREIGN KEY (content_id) REFERENCES content (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE negotiation ADD CONSTRAINT FK_17989598A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE negotiation ADD CONSTRAINT FK_17989598F639F774 FOREIGN KEY (campaign_id) REFERENCES campaign (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE negotiation ADD CONSTRAINT FK_179895987909E1ED FOREIGN KEY (research_id) REFERENCES research (id)');
        $this->addSql('ALTER TABLE negotiation ADD CONSTRAINT FK_1798959838248176 FOREIGN KEY (currency_id) REFERENCES currency (id)');
        $this->addSql('ALTER TABLE research ADD CONSTRAINT FK_57EB50C2A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE research ADD CONSTRAINT FK_57EB50C2F639F774 FOREIGN KEY (campaign_id) REFERENCES campaign (id)');
        $this->addSql('ALTER TABLE research ADD CONSTRAINT FK_57EB50C26BF700BD FOREIGN KEY (status_id) REFERENCES research_status (id)');
        $this->addSql('ALTER TABLE research ADD CONSTRAINT FK_57EB50C21A445520 FOREIGN KEY (content_type_id) REFERENCES content_type (id)');
        $this->addSql('ALTER TABLE research_prospect ADD CONSTRAINT FK_3435DBB77909E1ED FOREIGN KEY (research_id) REFERENCES research (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE research_prospect ADD CONSTRAINT FK_3435DBB7D182060A FOREIGN KEY (prospect_id) REFERENCES prospect (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE content ADD CONSTRAINT FK_FEC530A9F639F774 FOREIGN KEY (campaign_id) REFERENCES campaign (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE content ADD CONSTRAINT FK_FEC530A9A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE SET NULL');
        $this->addSql('ALTER TABLE content ADD CONSTRAINT FK_FEC530A96BF700BD FOREIGN KEY (status_id) REFERENCES content_status (id)');
        $this->addSql('ALTER TABLE content ADD CONSTRAINT FK_FEC530A9C54C8C93 FOREIGN KEY (type_id) REFERENCES content_type (id)');
        $this->addSql('ALTER TABLE content ADD CONSTRAINT FK_FEC530A92F966E9D FOREIGN KEY (placement_id) REFERENCES content_placement (id)');
        $this->addSql('ALTER TABLE mailgun_event ADD CONSTRAINT FK_1271933F735468F9 FOREIGN KEY (negotiation_message_id) REFERENCES negotiation_message (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE password_token ADD CONSTRAINT FK_BEAB6C24A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE campaign ADD CONSTRAINT FK_1F1512DD115F0EE5 FOREIGN KEY (domain_id) REFERENCES domain (id)');
        $this->addSql('ALTER TABLE campaign ADD CONSTRAINT FK_1F1512DD19EB6921 FOREIGN KEY (client_id) REFERENCES client (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE campaign ADD CONSTRAINT FK_1F1512DD5FB14BA7 FOREIGN KEY (level_id) REFERENCES campaign_level (id)');
        $this->addSql('ALTER TABLE campaign ADD CONSTRAINT FK_1F1512DD2B20AEB5 FOREIGN KEY (content_writer_id) REFERENCES user (id) ON DELETE SET NULL');
        $this->addSql('ALTER TABLE campaign ADD CONSTRAINT FK_1F1512DD7C16B6A4 FOREIGN KEY (targeted_country_id) REFERENCES country (id)');
        $this->addSql('ALTER TABLE campaign_campaign_bolton ADD CONSTRAINT FK_250FAAD6F639F774 FOREIGN KEY (campaign_id) REFERENCES campaign (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE campaign_campaign_bolton ADD CONSTRAINT FK_250FAAD618691A53 FOREIGN KEY (bolton_id) REFERENCES campaign_bolton (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE link_check ADD CONSTRAINT FK_9335F0CDADA40271 FOREIGN KEY (link_id) REFERENCES link (id)');
        $this->addSql('ALTER TABLE campaign_keyword_check ADD CONSTRAINT FK_135B36C8115D4552 FOREIGN KEY (keyword_id) REFERENCES campaign_keyword (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE campaign_report ADD CONSTRAINT FK_196C0E29F639F774 FOREIGN KEY (campaign_id) REFERENCES campaign (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE campaign_report ADD CONSTRAINT FK_196C0E29B03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id) ON DELETE SET NULL');
        $this->addSql('ALTER TABLE campaign_report ADD CONSTRAINT FK_196C0E29A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE campaign_report ADD CONSTRAINT FK_196C0E2980688E6F FOREIGN KEY (preset_id) REFERENCES campaign_report_preset (id)');
        $this->addSql('ALTER TABLE campaign_report ADD CONSTRAINT FK_196C0E2993CB796C FOREIGN KEY (file_id) REFERENCES file (id)');
        $this->addSql('ALTER TABLE campaign_credential ADD CONSTRAINT FK_C2683DE3F639F774 FOREIGN KEY (campaign_id) REFERENCES campaign (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE campaign_task_activity ADD CONSTRAINT FK_2D884E6C8DB60186 FOREIGN KEY (task_id) REFERENCES campaign_task (id)');
        $this->addSql('ALTER TABLE campaign_task_activity ADD CONSTRAINT FK_2D884E6CB03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE campaign_task ADD CONSTRAINT FK_5399E0C7FF3475DB FOREIGN KEY (tasklist_id) REFERENCES campaign_tasklist (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE campaign_task ADD CONSTRAINT FK_5399E0C7A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE campaign_task ADD CONSTRAINT FK_5399E0C7B03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id) ON DELETE SET NULL');
        $this->addSql('ALTER TABLE campaign_tasklist ADD CONSTRAINT FK_5451CF1AB03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE campaign_tasklist ADD CONSTRAINT FK_5451CF1AF639F774 FOREIGN KEY (campaign_id) REFERENCES campaign (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE campaign_tasklist ADD CONSTRAINT FK_5451CF1A23B2B0ED FOREIGN KEY (time_log_type_id) REFERENCES time_log_type (id)');
        $this->addSql('ALTER TABLE campaign_keyword ADD CONSTRAINT FK_F229ED17F639F774 FOREIGN KEY (campaign_id) REFERENCES campaign (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE campaign_keyword ADD CONSTRAINT FK_F229ED172B4E498C FOREIGN KEY (latest_check_id) REFERENCES campaign_keyword_check (id) ON DELETE SET NULL');
        $this->addSql('ALTER TABLE campaign_keyword_keyword_tag ADD CONSTRAINT FK_2CFD29A6115D4552 FOREIGN KEY (keyword_id) REFERENCES campaign_keyword (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE campaign_keyword_keyword_tag ADD CONSTRAINT FK_2CFD29A6BAD26311 FOREIGN KEY (tag_id) REFERENCES campaign_keyword_tag (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE campaign_report_element_type_preset ADD CONSTRAINT FK_22BAF9C4C54C8C93 FOREIGN KEY (type_id) REFERENCES campaign_report_element_type (id)');
        $this->addSql('ALTER TABLE campaign_report_element ADD CONSTRAINT FK_91C887B6C54C8C93 FOREIGN KEY (type_id) REFERENCES campaign_report_element_type (id)');
        $this->addSql('ALTER TABLE campaign_report_element ADD CONSTRAINT FK_91C887B680688E6F FOREIGN KEY (preset_id) REFERENCES campaign_report_element_type_preset (id)');
        $this->addSql('ALTER TABLE campaign_hours ADD CONSTRAINT FK_C41FD9E2F639F774 FOREIGN KEY (campaign_id) REFERENCES campaign (id)');
        $this->addSql('ALTER TABLE campaign_hours ADD CONSTRAINT FK_C41FD9E212469DE2 FOREIGN KEY (category_id) REFERENCES time_log_type_category (id)');
        $this->addSql('ALTER TABLE campaign_schedule ADD CONSTRAINT FK_6848C784F639F774 FOREIGN KEY (campaign_id) REFERENCES campaign (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE campaign_schedule ADD CONSTRAINT FK_6848C784B03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id) ON DELETE SET NULL');
        $this->addSql('ALTER TABLE campaign_notice ADD CONSTRAINT FK_954E3C6FF639F774 FOREIGN KEY (campaign_id) REFERENCES campaign (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE campaign_notice ADD CONSTRAINT FK_954E3C6FB03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE campaign_social_link ADD CONSTRAINT FK_A177766FF639F774 FOREIGN KEY (campaign_id) REFERENCES campaign (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE campaign_team ADD CONSTRAINT FK_C5079DFDF639F774 FOREIGN KEY (campaign_id) REFERENCES campaign (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE campaign_team ADD CONSTRAINT FK_C5079DFDA76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE campaign_team_role ADD CONSTRAINT FK_4600626AC292CD19 FOREIGN KEY (team_member_id) REFERENCES campaign_team (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE campaign_team_role ADD CONSTRAINT FK_4600626AD60322AC FOREIGN KEY (role_id) REFERENCES campaign_role (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE client_contact ADD CONSTRAINT FK_1E5FA24519EB6921 FOREIGN KEY (client_id) REFERENCES client (id)');
        $this->addSql('ALTER TABLE client_contact_department ADD CONSTRAINT FK_603ED30D77F5180B FOREIGN KEY (client_contact_id) REFERENCES client_contact (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE client_contact_department ADD CONSTRAINT FK_603ED30DAE80F5DF FOREIGN KEY (department_id) REFERENCES client_department (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE link ADD CONSTRAINT FK_36AC99F1D182060A FOREIGN KEY (prospect_id) REFERENCES prospect (id)');
        $this->addSql('ALTER TABLE link ADD CONSTRAINT FK_36AC99F184A0A3ED FOREIGN KEY (content_id) REFERENCES content (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE link ADD CONSTRAINT FK_36AC99F167A34946 FOREIGN KEY (negotiation_id) REFERENCES negotiation (id)');
        $this->addSql('ALTER TABLE link ADD CONSTRAINT FK_36AC99F14A8DFB0C FOREIGN KEY (fail_check_id) REFERENCES link_check (id)');
        $this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D64986383B10 FOREIGN KEY (avatar_id) REFERENCES file (id)');
        $this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D64919EB6921 FOREIGN KEY (client_id) REFERENCES client (id)');
        $this->addSql('ALTER TABLE user_role ADD CONSTRAINT FK_2DE8C6A3A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE user_role ADD CONSTRAINT FK_2DE8C6A3D60322AC FOREIGN KEY (role_id) REFERENCES role (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE negotiation_message ADD CONSTRAINT FK_A095F861D182060A FOREIGN KEY (prospect_id) REFERENCES prospect (id)');
        $this->addSql('ALTER TABLE negotiation_message ADD CONSTRAINT FK_A095F861A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE negotiation_message ADD CONSTRAINT FK_A095F86167A34946 FOREIGN KEY (negotiation_id) REFERENCES negotiation (id)');
        $this->addSql('ALTER TABLE time_log ADD CONSTRAINT FK_55BE03AFF639F774 FOREIGN KEY (campaign_id) REFERENCES campaign (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE time_log ADD CONSTRAINT FK_55BE03AFA76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE time_log ADD CONSTRAINT FK_55BE03AFC54C8C93 FOREIGN KEY (type_id) REFERENCES time_log_type (id)');
        $this->addSql('ALTER TABLE prospect_problem ADD CONSTRAINT FK_14ABDC1CD182060A FOREIGN KEY (prospect_id) REFERENCES prospect (id)');
        $this->addSql('ALTER TABLE billing ADD CONSTRAINT FK_EC224CAAADA40271 FOREIGN KEY (link_id) REFERENCES link (id) ON DELETE SET NULL');
        $this->addSql('ALTER TABLE prospect ADD CONSTRAINT FK_C9CE8C7D115F0EE5 FOREIGN KEY (domain_id) REFERENCES domain (id)');
        $this->addSql('ALTER TABLE prospect ADD CONSTRAINT FK_C9CE8C7DF92F3E70 FOREIGN KEY (country_id) REFERENCES country (id)');
        $this->addSql('ALTER TABLE prospect ADD CONSTRAINT FK_C9CE8C7D38248176 FOREIGN KEY (currency_id) REFERENCES currency (id)');
        $this->addSql('ALTER TABLE prospect_category ADD CONSTRAINT FK_8731431CD182060A FOREIGN KEY (prospect_id) REFERENCES prospect (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE prospect_category ADD CONSTRAINT FK_8731431C12469DE2 FOREIGN KEY (category_id) REFERENCES category (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE time_log_type ADD CONSTRAINT FK_3935FA9012469DE2 FOREIGN KEY (category_id) REFERENCES time_log_type_category (id)');
        $this->addSql('ALTER TABLE user_note ADD CONSTRAINT FK_B53CB6DDB03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE domain_topic_trustflow ADD CONSTRAINT FK_A10009115F0EE5 FOREIGN KEY (domain_id) REFERENCES domain (id)');
        $this->addSql('ALTER TABLE domain_topic_trustflow ADD CONSTRAINT FK_A100091F55203D FOREIGN KEY (topic_id) REFERENCES domain_majestic_topic (id)');
        $this->addSql('ALTER TABLE domain_stat ADD CONSTRAINT FK_8D64D246115F0EE5 FOREIGN KEY (domain_id) REFERENCES domain (id)');
        $this->addSql('ALTER TABLE domain_stat ADD CONSTRAINT FK_8D64D2469502F0B FOREIGN KEY (stat_id) REFERENCES stat (id)');
        $this->addSql('ALTER TABLE domain_check ADD CONSTRAINT FK_EFF584C59502F0B FOREIGN KEY (stat_id) REFERENCES domain_stat (id)');
        $this->addSql('ALTER TABLE client ADD CONSTRAINT FK_C744045581B2B6EE FOREIGN KEY (address_country_id) REFERENCES country (id)');
        $this->addSql('ALTER TABLE cron_report ADD CONSTRAINT FK_B6C6A7F5BE04EA9 FOREIGN KEY (job_id) REFERENCES cron_job (id) ON DELETE CASCADE');
    }

    public function down(Schema $schema) : void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE campaign_hours DROP FOREIGN KEY FK_C41FD9E212469DE2');
        $this->addSql('ALTER TABLE time_log_type DROP FOREIGN KEY FK_3935FA9012469DE2');
        $this->addSql('ALTER TABLE campaign DROP FOREIGN KEY FK_1F1512DD7C16B6A4');
        $this->addSql('ALTER TABLE prospect DROP FOREIGN KEY FK_C9CE8C7DF92F3E70');
        $this->addSql('ALTER TABLE client DROP FOREIGN KEY FK_C744045581B2B6EE');
        $this->addSql('ALTER TABLE user_role DROP FOREIGN KEY FK_2DE8C6A3D60322AC');
        $this->addSql('ALTER TABLE domain_stat DROP FOREIGN KEY FK_8D64D2469502F0B');
        $this->addSql('ALTER TABLE content DROP FOREIGN KEY FK_FEC530A92F966E9D');
        $this->addSql('ALTER TABLE content_status DROP FOREIGN KEY FK_133615B02C7C2CBA');
        $this->addSql('ALTER TABLE content_type DROP FOREIGN KEY FK_41BCBAEC2C7C2CBA');
        $this->addSql('ALTER TABLE event_log DROP FOREIGN KEY FK_9EF0AD162E43440C');
        $this->addSql('ALTER TABLE event_log DROP FOREIGN KEY FK_9EF0AD16596805D2');
        $this->addSql('ALTER TABLE content DROP FOREIGN KEY FK_FEC530A96BF700BD');
        $this->addSql('ALTER TABLE research DROP FOREIGN KEY FK_57EB50C21A445520');
        $this->addSql('ALTER TABLE content DROP FOREIGN KEY FK_FEC530A9C54C8C93');
        $this->addSql('ALTER TABLE file_association DROP FOREIGN KEY FK_DF3EDFAEF8697D13');
        $this->addSql('ALTER TABLE link DROP FOREIGN KEY FK_36AC99F167A34946');
        $this->addSql('ALTER TABLE negotiation_message DROP FOREIGN KEY FK_A095F86167A34946');
        $this->addSql('ALTER TABLE negotiation DROP FOREIGN KEY FK_179895987909E1ED');
        $this->addSql('ALTER TABLE research_prospect DROP FOREIGN KEY FK_3435DBB77909E1ED');
        $this->addSql('ALTER TABLE negotiation DROP FOREIGN KEY FK_1798959838248176');
        $this->addSql('ALTER TABLE prospect DROP FOREIGN KEY FK_C9CE8C7D38248176');
        $this->addSql('ALTER TABLE event_log DROP FOREIGN KEY FK_9EF0AD1684A0A3ED');
        $this->addSql('ALTER TABLE file_association DROP FOREIGN KEY FK_DF3EDFAE84A0A3ED');
        $this->addSql('ALTER TABLE copyscape_report DROP FOREIGN KEY FK_5195DF7784A0A3ED');
        $this->addSql('ALTER TABLE content_version DROP FOREIGN KEY FK_60140A7084A0A3ED');
        $this->addSql('ALTER TABLE comment DROP FOREIGN KEY FK_9474526C84A0A3ED');
        $this->addSql('ALTER TABLE negotiation DROP FOREIGN KEY FK_1798959884A0A3ED');
        $this->addSql('ALTER TABLE link DROP FOREIGN KEY FK_36AC99F184A0A3ED');
        $this->addSql('ALTER TABLE negotiation DROP FOREIGN KEY FK_179895986BF700BD');
        $this->addSql('ALTER TABLE file_association DROP FOREIGN KEY FK_DF3EDFAEF639F774');
        $this->addSql('ALTER TABLE negotiation DROP FOREIGN KEY FK_17989598F639F774');
        $this->addSql('ALTER TABLE research DROP FOREIGN KEY FK_57EB50C2F639F774');
        $this->addSql('ALTER TABLE content DROP FOREIGN KEY FK_FEC530A9F639F774');
        $this->addSql('ALTER TABLE campaign_campaign_bolton DROP FOREIGN KEY FK_250FAAD6F639F774');
        $this->addSql('ALTER TABLE campaign_report DROP FOREIGN KEY FK_196C0E29F639F774');
        $this->addSql('ALTER TABLE campaign_credential DROP FOREIGN KEY FK_C2683DE3F639F774');
        $this->addSql('ALTER TABLE campaign_tasklist DROP FOREIGN KEY FK_5451CF1AF639F774');
        $this->addSql('ALTER TABLE campaign_keyword DROP FOREIGN KEY FK_F229ED17F639F774');
        $this->addSql('ALTER TABLE campaign_hours DROP FOREIGN KEY FK_C41FD9E2F639F774');
        $this->addSql('ALTER TABLE campaign_schedule DROP FOREIGN KEY FK_6848C784F639F774');
        $this->addSql('ALTER TABLE campaign_notice DROP FOREIGN KEY FK_954E3C6FF639F774');
        $this->addSql('ALTER TABLE campaign_social_link DROP FOREIGN KEY FK_A177766FF639F774');
        $this->addSql('ALTER TABLE campaign_team DROP FOREIGN KEY FK_C5079DFDF639F774');
        $this->addSql('ALTER TABLE time_log DROP FOREIGN KEY FK_55BE03AFF639F774');
        $this->addSql('ALTER TABLE link DROP FOREIGN KEY FK_36AC99F14A8DFB0C');
        $this->addSql('ALTER TABLE campaign_campaign_bolton DROP FOREIGN KEY FK_250FAAD618691A53');
        $this->addSql('ALTER TABLE campaign_keyword DROP FOREIGN KEY FK_F229ED172B4E498C');
        $this->addSql('ALTER TABLE campaign_keyword_keyword_tag DROP FOREIGN KEY FK_2CFD29A6BAD26311');
        $this->addSql('ALTER TABLE file_association DROP FOREIGN KEY FK_DF3EDFAE8DB60186');
        $this->addSql('ALTER TABLE comment DROP FOREIGN KEY FK_9474526C8DB60186');
        $this->addSql('ALTER TABLE campaign_task_activity DROP FOREIGN KEY FK_2D884E6C8DB60186');
        $this->addSql('ALTER TABLE campaign_task DROP FOREIGN KEY FK_5399E0C7FF3475DB');
        $this->addSql('ALTER TABLE campaign_team_role DROP FOREIGN KEY FK_4600626AD60322AC');
        $this->addSql('ALTER TABLE campaign_keyword_check DROP FOREIGN KEY FK_135B36C8115D4552');
        $this->addSql('ALTER TABLE campaign_keyword_keyword_tag DROP FOREIGN KEY FK_2CFD29A6115D4552');
        $this->addSql('ALTER TABLE campaign DROP FOREIGN KEY FK_1F1512DD5FB14BA7');
        $this->addSql('ALTER TABLE campaign_report_element_type_preset DROP FOREIGN KEY FK_22BAF9C4C54C8C93');
        $this->addSql('ALTER TABLE campaign_report_element DROP FOREIGN KEY FK_91C887B6C54C8C93');
        $this->addSql('ALTER TABLE campaign_report_element DROP FOREIGN KEY FK_91C887B680688E6F');
        $this->addSql('ALTER TABLE campaign_report DROP FOREIGN KEY FK_196C0E2980688E6F');
        $this->addSql('ALTER TABLE file_association DROP FOREIGN KEY FK_DF3EDFAE7D540AB');
        $this->addSql('ALTER TABLE campaign_team_role DROP FOREIGN KEY FK_4600626AC292CD19');
        $this->addSql('ALTER TABLE client_contact_department DROP FOREIGN KEY FK_603ED30D77F5180B');
        $this->addSql('ALTER TABLE link_check DROP FOREIGN KEY FK_9335F0CDADA40271');
        $this->addSql('ALTER TABLE billing DROP FOREIGN KEY FK_EC224CAAADA40271');
        $this->addSql('ALTER TABLE event_log DROP FOREIGN KEY FK_9EF0AD16B03A8386');
        $this->addSql('ALTER TABLE event_log DROP FOREIGN KEY FK_9EF0AD16D4FB0AC5');
        $this->addSql('ALTER TABLE event_log DROP FOREIGN KEY FK_9EF0AD167C2D807B');
        $this->addSql('ALTER TABLE copyscape_report DROP FOREIGN KEY FK_5195DF77B03A8386');
        $this->addSql('ALTER TABLE content_version DROP FOREIGN KEY FK_60140A70B03A8386');
        $this->addSql('ALTER TABLE comment DROP FOREIGN KEY FK_9474526CB03A8386');
        $this->addSql('ALTER TABLE dashboard DROP FOREIGN KEY FK_5C94FFF8A76ED395');
        $this->addSql('ALTER TABLE negotiation DROP FOREIGN KEY FK_17989598A76ED395');
        $this->addSql('ALTER TABLE research DROP FOREIGN KEY FK_57EB50C2A76ED395');
        $this->addSql('ALTER TABLE content DROP FOREIGN KEY FK_FEC530A9A76ED395');
        $this->addSql('ALTER TABLE password_token DROP FOREIGN KEY FK_BEAB6C24A76ED395');
        $this->addSql('ALTER TABLE campaign DROP FOREIGN KEY FK_1F1512DD2B20AEB5');
        $this->addSql('ALTER TABLE campaign_report DROP FOREIGN KEY FK_196C0E29B03A8386');
        $this->addSql('ALTER TABLE campaign_report DROP FOREIGN KEY FK_196C0E29A76ED395');
        $this->addSql('ALTER TABLE campaign_task_activity DROP FOREIGN KEY FK_2D884E6CB03A8386');
        $this->addSql('ALTER TABLE campaign_task DROP FOREIGN KEY FK_5399E0C7A76ED395');
        $this->addSql('ALTER TABLE campaign_task DROP FOREIGN KEY FK_5399E0C7B03A8386');
        $this->addSql('ALTER TABLE campaign_tasklist DROP FOREIGN KEY FK_5451CF1AB03A8386');
        $this->addSql('ALTER TABLE campaign_schedule DROP FOREIGN KEY FK_6848C784B03A8386');
        $this->addSql('ALTER TABLE campaign_notice DROP FOREIGN KEY FK_954E3C6FB03A8386');
        $this->addSql('ALTER TABLE campaign_team DROP FOREIGN KEY FK_C5079DFDA76ED395');
        $this->addSql('ALTER TABLE user_role DROP FOREIGN KEY FK_2DE8C6A3A76ED395');
        $this->addSql('ALTER TABLE negotiation_message DROP FOREIGN KEY FK_A095F861A76ED395');
        $this->addSql('ALTER TABLE time_log DROP FOREIGN KEY FK_55BE03AFA76ED395');
        $this->addSql('ALTER TABLE user_note DROP FOREIGN KEY FK_B53CB6DDB03A8386');
        $this->addSql('ALTER TABLE file_association DROP FOREIGN KEY FK_DF3EDFAE735468F9');
        $this->addSql('ALTER TABLE mailgun_event DROP FOREIGN KEY FK_1271933F735468F9');
        $this->addSql('ALTER TABLE client_contact_department DROP FOREIGN KEY FK_603ED30DAE80F5DF');
        $this->addSql('ALTER TABLE file_association DROP FOREIGN KEY FK_DF3EDFAE93CB796C');
        $this->addSql('ALTER TABLE campaign_report DROP FOREIGN KEY FK_196C0E2993CB796C');
        $this->addSql('ALTER TABLE user DROP FOREIGN KEY FK_8D93D64986383B10');
        $this->addSql('ALTER TABLE negotiation DROP FOREIGN KEY FK_17989598D182060A');
        $this->addSql('ALTER TABLE research_prospect DROP FOREIGN KEY FK_3435DBB7D182060A');
        $this->addSql('ALTER TABLE link DROP FOREIGN KEY FK_36AC99F1D182060A');
        $this->addSql('ALTER TABLE negotiation_message DROP FOREIGN KEY FK_A095F861D182060A');
        $this->addSql('ALTER TABLE prospect_problem DROP FOREIGN KEY FK_14ABDC1CD182060A');
        $this->addSql('ALTER TABLE prospect_category DROP FOREIGN KEY FK_8731431CD182060A');
        $this->addSql('ALTER TABLE campaign DROP FOREIGN KEY FK_1F1512DD115F0EE5');
        $this->addSql('ALTER TABLE prospect DROP FOREIGN KEY FK_C9CE8C7D115F0EE5');
        $this->addSql('ALTER TABLE domain_topic_trustflow DROP FOREIGN KEY FK_A10009115F0EE5');
        $this->addSql('ALTER TABLE domain_stat DROP FOREIGN KEY FK_8D64D246115F0EE5');
        $this->addSql('ALTER TABLE campaign_tasklist DROP FOREIGN KEY FK_5451CF1A23B2B0ED');
        $this->addSql('ALTER TABLE time_log DROP FOREIGN KEY FK_55BE03AFC54C8C93');
        $this->addSql('ALTER TABLE domain_check DROP FOREIGN KEY FK_EFF584C59502F0B');
        $this->addSql('ALTER TABLE domain_topic_trustflow DROP FOREIGN KEY FK_A100091F55203D');
        $this->addSql('ALTER TABLE prospect_category DROP FOREIGN KEY FK_8731431C12469DE2');
        $this->addSql('ALTER TABLE campaign DROP FOREIGN KEY FK_1F1512DD19EB6921');
        $this->addSql('ALTER TABLE client_contact DROP FOREIGN KEY FK_1E5FA24519EB6921');
        $this->addSql('ALTER TABLE user DROP FOREIGN KEY FK_8D93D64919EB6921');
        $this->addSql('ALTER TABLE research DROP FOREIGN KEY FK_57EB50C26BF700BD');
        $this->addSql('ALTER TABLE cron_report DROP FOREIGN KEY FK_B6C6A7F5BE04EA9');
        $this->addSql('DROP TABLE event_log');
        $this->addSql('DROP TABLE file_association');
        $this->addSql('DROP TABLE copyscape_report');
        $this->addSql('DROP TABLE time_log_type_category');
        $this->addSql('DROP TABLE content_version');
        $this->addSql('DROP TABLE country');
        $this->addSql('DROP TABLE role');
        $this->addSql('DROP TABLE stat');
        $this->addSql('DROP TABLE content_placement');
        $this->addSql('DROP TABLE content_workflow');
        $this->addSql('DROP TABLE content_status');
        $this->addSql('DROP TABLE content_type');
        $this->addSql('DROP TABLE comment');
        $this->addSql('DROP TABLE dashboard');
        $this->addSql('DROP TABLE negotiation');
        $this->addSql('DROP TABLE research');
        $this->addSql('DROP TABLE research_prospect');
        $this->addSql('DROP TABLE currency');
        $this->addSql('DROP TABLE content');
        $this->addSql('DROP TABLE negotiation_status');
        $this->addSql('DROP TABLE mailgun_event');
        $this->addSql('DROP TABLE password_token');
        $this->addSql('DROP TABLE campaign');
        $this->addSql('DROP TABLE campaign_campaign_bolton');
        $this->addSql('DROP TABLE link_check');
        $this->addSql('DROP TABLE campaign_bolton');
        $this->addSql('DROP TABLE campaign_keyword_check');
        $this->addSql('DROP TABLE campaign_keyword_tag');
        $this->addSql('DROP TABLE campaign_report');
        $this->addSql('DROP TABLE campaign_credential');
        $this->addSql('DROP TABLE campaign_task_activity');
        $this->addSql('DROP TABLE campaign_task');
        $this->addSql('DROP TABLE campaign_tasklist');
        $this->addSql('DROP TABLE campaign_role');
        $this->addSql('DROP TABLE campaign_keyword');
        $this->addSql('DROP TABLE campaign_keyword_keyword_tag');
        $this->addSql('DROP TABLE campaign_level');
        $this->addSql('DROP TABLE campaign_report_element_type');
        $this->addSql('DROP TABLE campaign_report_element_type_preset');
        $this->addSql('DROP TABLE campaign_report_element');
        $this->addSql('DROP TABLE campaign_report_preset');
        $this->addSql('DROP TABLE campaign_hours');
        $this->addSql('DROP TABLE campaign_schedule');
        $this->addSql('DROP TABLE campaign_notice');
        $this->addSql('DROP TABLE campaign_social_link');
        $this->addSql('DROP TABLE campaign_team');
        $this->addSql('DROP TABLE campaign_team_role');
        $this->addSql('DROP TABLE client_contact');
        $this->addSql('DROP TABLE client_contact_department');
        $this->addSql('DROP TABLE link');
        $this->addSql('DROP TABLE user');
        $this->addSql('DROP TABLE user_role');
        $this->addSql('DROP TABLE negotiation_message');
        $this->addSql('DROP TABLE client_department');
        $this->addSql('DROP TABLE file');
        $this->addSql('DROP TABLE time_log');
        $this->addSql('DROP TABLE prospect_problem');
        $this->addSql('DROP TABLE billing');
        $this->addSql('DROP TABLE prospect');
        $this->addSql('DROP TABLE prospect_category');
        $this->addSql('DROP TABLE domain');
        $this->addSql('DROP TABLE time_log_type');
        $this->addSql('DROP TABLE user_note');
        $this->addSql('DROP TABLE domain_topic_trustflow');
        $this->addSql('DROP TABLE domain_stat');
        $this->addSql('DROP TABLE domain_majestic_topic');
        $this->addSql('DROP TABLE domain_check');
        $this->addSql('DROP TABLE category');
        $this->addSql('DROP TABLE client');
        $this->addSql('DROP TABLE research_status');
        $this->addSql('DROP TABLE cron_report');
        $this->addSql('DROP TABLE cron_job');
    }
}