<?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 Version20221222094532 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->addSql('CREATE TABLE address (id INT AUTO_INCREMENT NOT NULL, address_type_id INT DEFAULT NULL, address_city_id INT DEFAULT NULL, street VARCHAR(100) NOT NULL, number VARCHAR(45) DEFAULT NULL, floor VARCHAR(45) DEFAULT NULL, stair VARCHAR(45) DEFAULT NULL, INDEX IDX_D4E6F819EA97B0B (address_type_id), INDEX IDX_D4E6F81D0499537 (address_city_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE address_city (id INT AUTO_INCREMENT NOT NULL, address_district_id INT DEFAULT NULL, zip VARCHAR(191) NOT NULL, name VARCHAR(191) NOT NULL, gkz VARCHAR(191) DEFAULT NULL, INDEX IDX_5017D2DFA74081B9 (address_district_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE address_country (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, short_name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE address_district (id INT AUTO_INCREMENT NOT NULL, address_state_id INT DEFAULT NULL, name VARCHAR(191) NOT NULL, bkz VARCHAR(191) DEFAULT NULL, INDEX IDX_CF4EAA06FB57C240 (address_state_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE address_lat_lon (id INT AUTO_INCREMENT NOT NULL, address_id INT DEFAULT NULL, lat VARCHAR(32) NOT NULL, lon VARCHAR(32) NOT NULL, UNIQUE INDEX UNIQ_DFA98200F5B7AF75 (address_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE address_state (id INT AUTO_INCREMENT NOT NULL, address_country_id INT DEFAULT NULL, name VARCHAR(191) NOT NULL, short_name VARCHAR(191) NOT NULL, iso_code VARCHAR(191) DEFAULT NULL, INDEX IDX_9436A5DB81B2B6EE (address_country_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE address_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, short_name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE api_login_information (id INT AUTO_INCREMENT NOT NULL, api_password VARCHAR(250) NOT NULL, domain_name VARCHAR(250) NOT NULL, bearer VARCHAR(250) DEFAULT NULL, expire_at DATETIME DEFAULT NULL, created_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE appointment (id INT AUTO_INCREMENT NOT NULL, appointment_type_id INT DEFAULT NULL, appointment_state_id INT DEFAULT NULL, event_id INT DEFAULT NULL, start_time TIME DEFAULT NULL, end_time TIME DEFAULT NULL, start_date DATE DEFAULT NULL, end_date DATE DEFAULT NULL, max_participants INT DEFAULT NULL, created_at DATETIME NOT NULL, bookable_until DATETIME DEFAULT NULL, manual_enroll TINYINT(1) DEFAULT 0 NOT NULL, note TEXT DEFAULT NULL, INDEX IDX_FE38F844546FBEBB (appointment_type_id), INDEX IDX_FE38F84430FCB709 (appointment_state_id), INDEX IDX_FE38F84471F7E88B (event_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE appointment_agreement_entry (id INT AUTO_INCREMENT NOT NULL, weekday_id INT DEFAULT NULL, appointment_id INT DEFAULT NULL, start_time TIME NOT NULL, end_time TIME NOT NULL, INDEX IDX_99D39DD48516439 (weekday_id), INDEX IDX_99D39DDE5B533F9 (appointment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE appointment_individual_mapping (id INT AUTO_INCREMENT NOT NULL, appointment_id INT DEFAULT NULL, contact_id INT DEFAULT NULL, profile_type_id INT DEFAULT NULL, is_active TINYINT(1) DEFAULT 1 NOT NULL, location_id INT DEFAULT NULL, INDEX IDX_78359B99E5B533F9 (appointment_id), INDEX IDX_78359B99E7A1254A (contact_id), INDEX IDX_78359B9916F2520F (profile_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE appointment_state (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE appointment_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE bo_plan (id INT AUTO_INCREMENT NOT NULL, school_class_id INT DEFAULT NULL, boplan_state_id INT DEFAULT NULL, UNIQUE INDEX UNIQ_3EBAE34614463F54 (school_class_id), INDEX IDX_3EBAE346E3EB8173 (boplan_state_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE bo_plan_activity_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE bo_plan_reference (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(2) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE bo_plan_state (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE bo_plan_subject (id INT AUTO_INCREMENT NOT NULL, bo_plan_subject_category_id INT DEFAULT NULL, name VARCHAR(191) NOT NULL, position SMALLINT NOT NULL, INDEX IDX_F77C9E13A2FE0107 (bo_plan_subject_category_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE bo_plan_subject_category (id INT AUTO_INCREMENT NOT NULL, school_class_grade_id INT DEFAULT NULL, name VARCHAR(191) NOT NULL, position SMALLINT NOT NULL, INDEX IDX_A49417288B9A65FF (school_class_grade_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE bo_plan_subject_custom (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE bo_plan_week (id INT AUTO_INCREMENT NOT NULL, bo_plan_id INT DEFAULT NULL, bo_plan_week_state_id INT DEFAULT NULL, event_id INT DEFAULT NULL, bo_plan_subject_id INT DEFAULT NULL, bo_plan_subject_custom_id INT DEFAULT NULL, school_subject_id INT DEFAULT NULL, bo_plan_activity_type_id INT DEFAULT NULL, teacher_delete_id INT DEFAULT NULL, teacher_create_id INT DEFAULT NULL, teacher_done_id INT DEFAULT NULL, bo_plan_reference_id INT DEFAULT NULL, week INT NOT NULL COMMENT \'Schulwoche\', note MEDIUMTEXT NOT NULL COMMENT \'Anmerkung\', hours INT NOT NULL COMMENT \'Stundenanzahl\', lecturer MEDIUMTEXT DEFAULT NULL COMMENT \'Lehrperson\', created_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, done_at DATETIME DEFAULT NULL, INDEX IDX_9C0A3A5F4CB1CEC1 (bo_plan_id), INDEX IDX_9C0A3A5F5C2A31C5 (bo_plan_week_state_id), INDEX IDX_9C0A3A5F71F7E88B (event_id), INDEX IDX_9C0A3A5FCE50426D (bo_plan_subject_id), INDEX IDX_9C0A3A5FB83EE2E8 (bo_plan_subject_custom_id), INDEX IDX_9C0A3A5FB79F5C75 (school_subject_id), INDEX IDX_9C0A3A5F5FBBB4F2 (bo_plan_activity_type_id), INDEX IDX_9C0A3A5F8863C3A6 (teacher_delete_id), INDEX IDX_9C0A3A5F94759198 (teacher_create_id), INDEX IDX_9C0A3A5F650F5579 (teacher_done_id), INDEX IDX_9C0A3A5FA563B7E2 (bo_plan_reference_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE bo_plan_week_changes (id INT AUTO_INCREMENT NOT NULL, week_plan_id INT DEFAULT NULL, teacher_change_id INT DEFAULT NULL, change_date DATETIME DEFAULT NULL, change_fields MEDIUMTEXT DEFAULT NULL, INDEX IDX_6110AB411A8F78AC (week_plan_id), INDEX IDX_6110AB415B57C7EF (teacher_change_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE bo_plan_week_state (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE booking (id INT AUTO_INCREMENT NOT NULL, booking_state_id INT DEFAULT NULL, user_id INT DEFAULT NULL, appointment_id INT DEFAULT NULL, school_class_id INT DEFAULT NULL, person_count INT DEFAULT 0 NOT NULL, note MEDIUMTEXT DEFAULT NULL COMMENT \'Anmerkung\', created_at DATETIME NOT NULL, INDEX IDX_E00CEDDE3EECA24C (booking_state_id), INDEX IDX_E00CEDDEA76ED395 (user_id), INDEX IDX_E00CEDDEE5B533F9 (appointment_id), INDEX IDX_E00CEDDE14463F54 (school_class_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE booking_additional_information (id INT AUTO_INCREMENT NOT NULL, booking_id INT DEFAULT NULL, booking_additional_information_type_id INT DEFAULT NULL, json_data MEDIUMTEXT DEFAULT NULL, created_at DATETIME NOT NULL, INDEX IDX_DFBF83AA3301C60 (booking_id), INDEX IDX_DFBF83AAD34E2FED (booking_additional_information_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE booking_additional_information_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE booking_proposal (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, target_user_id INT DEFAULT NULL, booking_proposal_state_id INT DEFAULT NULL, booking_id INT DEFAULT NULL, date_from DATE DEFAULT NULL, date_to DATE DEFAULT NULL, time_from TIME DEFAULT NULL, time_to TIME DEFAULT NULL, note MEDIUMTEXT DEFAULT NULL COMMENT \'Anmerkung\', created_at DATETIME NOT NULL, INDEX IDX_84D10AFFA76ED395 (user_id), INDEX IDX_84D10AFF6C066AFE (target_user_id), INDEX IDX_84D10AFF7B02371D (booking_proposal_state_id), INDEX IDX_84D10AFF3301C60 (booking_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE booking_proposal_state (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE booking_school_custom_special_field_mapping (id INT AUTO_INCREMENT NOT NULL, booking_id INT DEFAULT NULL, school_custom_special_field_id INT DEFAULT NULL, created_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_FF1C22943301C60 (booking_id), INDEX IDX_FF1C2294ABC709B9 (school_custom_special_field_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE booking_state (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, description VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE bookmark (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, bookmark_type_id INT DEFAULT NULL, target_id INT NOT NULL, created_at DATETIME DEFAULT NULL, INDEX IDX_DA62921DA76ED395 (user_id), INDEX IDX_DA62921DA894E7A8 (bookmark_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE bookmark_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE bopartner_contact (id INT AUTO_INCREMENT NOT NULL, person_id INT DEFAULT NULL, communication_id INT DEFAULT NULL, profile_picture_id INT DEFAULT NULL, bopartner_profile_id INT DEFAULT NULL, employee_position VARCHAR(128) DEFAULT NULL, created_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_85C65A0B217BBB47 (person_id), UNIQUE INDEX UNIQ_85C65A0B1C2D1E0C (communication_id), INDEX IDX_85C65A0B292E8AE2 (profile_picture_id), INDEX IDX_85C65A0B731CCFFD (bopartner_profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE bopartner_location (id INT AUTO_INCREMENT NOT NULL, address_id INT DEFAULT NULL, bopartner_profile_id INT DEFAULT NULL, name VARCHAR(60) NOT NULL, position INT NOT NULL, is_active TINYINT(1) DEFAULT 1 NOT NULL, created_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_E1874C61F5B7AF75 (address_id), INDEX IDX_E1874C61731CCFFD (bopartner_profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE bopartner_profile (id INT AUTO_INCREMENT NOT NULL, communication_id INT DEFAULT NULL, gallery_id INT DEFAULT NULL, video_gallery_id INT DEFAULT NULL, document_gallery_id INT DEFAULT NULL, contact_gallery_id INT DEFAULT NULL, profile_picture_id INT DEFAULT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', name VARCHAR(191) NOT NULL, description MEDIUMTEXT DEFAULT NULL, certificate_information MEDIUMTEXT DEFAULT NULL, url VARCHAR(2048) DEFAULT NULL, click_count INT DEFAULT 0, is_visible TINYINT(1) DEFAULT 1 NOT NULL, UNIQUE INDEX UNIQ_48F3163C1C2D1E0C (communication_id), UNIQUE INDEX UNIQ_48F3163C4E7AF8F (gallery_id), UNIQUE INDEX UNIQ_48F3163C8440B739 (video_gallery_id), UNIQUE INDEX UNIQ_48F3163CA52404D9 (document_gallery_id), UNIQUE INDEX UNIQ_48F3163CC35EF618 (contact_gallery_id), INDEX IDX_48F3163C292E8AE2 (profile_picture_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE bopartner_profile_search_tag_mapping (bopartner_profile_id INT NOT NULL, search_tag_id INT NOT NULL, INDEX IDX_8567513E731CCFFD (bopartner_profile_id), INDEX IDX_8567513E63300C0E (search_tag_id), PRIMARY KEY(bopartner_profile_id, search_tag_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE bopartner_profile_event_mapping (id INT AUTO_INCREMENT NOT NULL, event_id INT DEFAULT NULL, bopartner_profile_id INT DEFAULT NULL, UNIQUE INDEX UNIQ_A9B8ADDB71F7E88B (event_id), INDEX IDX_A9B8ADDB731CCFFD (bopartner_profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE bopartner_profile_mapping (id INT AUTO_INCREMENT NOT NULL, bopartner_profile_id INT DEFAULT NULL, user_id INT DEFAULT NULL, is_active TINYINT(1) DEFAULT 1 NOT NULL, is_selected TINYINT(1) DEFAULT 0 NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_10475A0E731CCFFD (bopartner_profile_id), INDEX IDX_10475A0EA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE bopartner_profile_name_request (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, bopartner_profile_id INT DEFAULT NULL, name_old VARCHAR(191) NOT NULL, name_new VARCHAR(191) NOT NULL, applied_at DATETIME DEFAULT NULL, created_at DATETIME NOT NULL, INDEX IDX_8A0DF279A76ED395 (user_id), INDEX IDX_8A0DF279731CCFFD (bopartner_profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE communication (id INT AUTO_INCREMENT NOT NULL, created_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE communication_entry (id INT AUTO_INCREMENT NOT NULL, communication_id INT DEFAULT NULL, communication_type_id INT DEFAULT NULL, entry_value VARCHAR(255) NOT NULL, change_date DATETIME DEFAULT NULL, created_at DATETIME NOT NULL, INDEX IDX_AAA05CC51C2D1E0C (communication_id), INDEX IDX_AAA05CC5B09DA5C9 (communication_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE communication_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, short_name VARCHAR(191) NOT NULL, visible TINYINT(1) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE company_benefit (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE company_certificate (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, short_name VARCHAR(191) NOT NULL, picture_path VARCHAR(191) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE company_contact (id INT AUTO_INCREMENT NOT NULL, person_id INT DEFAULT NULL, communication_id INT DEFAULT NULL, profile_picture_id INT DEFAULT NULL, company_profile_id INT DEFAULT NULL, employee_position VARCHAR(191) DEFAULT NULL, created_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_6C30FCEF217BBB47 (person_id), UNIQUE INDEX UNIQ_6C30FCEF1C2D1E0C (communication_id), INDEX IDX_6C30FCEF292E8AE2 (profile_picture_id), INDEX IDX_6C30FCEF7174FB2E (company_profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE company_location (id INT AUTO_INCREMENT NOT NULL, address_id INT DEFAULT NULL, company_profile_id INT DEFAULT NULL, name VARCHAR(60) DEFAULT NULL, wknr VARCHAR(10) DEFAULT NULL, bnr VARCHAR(10) DEFAULT NULL, position INT NOT NULL, is_active TINYINT(1) DEFAULT 1 NOT NULL, created_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_46099CA6F5B7AF75 (address_id), INDEX IDX_46099CA67174FB2E (company_profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE company_profile (id INT AUTO_INCREMENT NOT NULL, communication_id INT DEFAULT NULL, gallery_id INT DEFAULT NULL, video_gallery_id INT DEFAULT NULL, document_gallery_id INT DEFAULT NULL, contact_gallery_id INT DEFAULT NULL, company_size_id INT DEFAULT NULL, profile_picture_id INT DEFAULT NULL, uuid CHAR(36) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', name VARCHAR(191) NOT NULL, wknr VARCHAR(10) DEFAULT NULL, is_flexi_profile TINYINT(1) DEFAULT 0, description MEDIUMTEXT DEFAULT NULL, training_information MEDIUMTEXT DEFAULT NULL, certificate_information MEDIUMTEXT DEFAULT NULL, url VARCHAR(2048) DEFAULT NULL, founded INT DEFAULT NULL, no_of_trainees INT DEFAULT NULL, click_count INT DEFAULT 0, is_visible TINYINT(1) DEFAULT 1 NOT NULL, UNIQUE INDEX UNIQ_A105B0D81C2D1E0C (communication_id), UNIQUE INDEX UNIQ_A105B0D84E7AF8F (gallery_id), UNIQUE INDEX UNIQ_A105B0D88440B739 (video_gallery_id), UNIQUE INDEX UNIQ_A105B0D8A52404D9 (document_gallery_id), UNIQUE INDEX UNIQ_A105B0D8C35EF618 (contact_gallery_id), INDEX IDX_A105B0D869DFB2F0 (company_size_id), INDEX IDX_A105B0D8292E8AE2 (profile_picture_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE company_profile_certificate_mapping (company_profile_id INT NOT NULL, company_certificate_id INT NOT NULL, INDEX IDX_1B89EDF07174FB2E (company_profile_id), INDEX IDX_1B89EDF0B7EA105E (company_certificate_id), PRIMARY KEY(company_profile_id, company_certificate_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE company_profile_job_mapping (company_profile_id INT NOT NULL, job_id INT NOT NULL, INDEX IDX_9D7949957174FB2E (company_profile_id), INDEX IDX_9D794995BE04EA9 (job_id), PRIMARY KEY(company_profile_id, job_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE company_profile_sector_mapping (company_profile_id INT NOT NULL, sector_id INT NOT NULL, INDEX IDX_E65CDA1E7174FB2E (company_profile_id), INDEX IDX_E65CDA1EDE95C867 (sector_id), PRIMARY KEY(company_profile_id, sector_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE company_profile_benefit_mapping (company_profile_id INT NOT NULL, company_benefit_id INT NOT NULL, INDEX IDX_43CCFDF27174FB2E (company_profile_id), INDEX IDX_43CCFDF2B6DF921F (company_benefit_id), PRIMARY KEY(company_profile_id, company_benefit_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE company_profile_search_tag_mapping (company_profile_id INT NOT NULL, search_tag_id INT NOT NULL, INDEX IDX_A10820BA7174FB2E (company_profile_id), INDEX IDX_A10820BA63300C0E (search_tag_id), PRIMARY KEY(company_profile_id, search_tag_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE company_profile_event_mapping (id INT AUTO_INCREMENT NOT NULL, event_id INT DEFAULT NULL, company_profile_id INT DEFAULT NULL, UNIQUE INDEX UNIQ_FB8325E271F7E88B (event_id), INDEX IDX_FB8325E27174FB2E (company_profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE company_profile_mapping (id INT AUTO_INCREMENT NOT NULL, company_profile_id INT DEFAULT NULL, user_id INT DEFAULT NULL, is_active TINYINT(1) DEFAULT 1 NOT NULL, is_selected TINYINT(1) DEFAULT 0 NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_D5A9C86B7174FB2E (company_profile_id), INDEX IDX_D5A9C86BA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE company_profile_name_request (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, company_profile_id INT DEFAULT NULL, name_old VARCHAR(191) NOT NULL, name_new VARCHAR(191) NOT NULL, applied_at DATETIME DEFAULT NULL, created_at DATETIME NOT NULL, INDEX IDX_D967FDCAA76ED395 (user_id), INDEX IDX_D967FDCA7174FB2E (company_profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE company_size (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(128) NOT NULL, text VARCHAR(64) DEFAULT NULL, min_employees INT DEFAULT NULL, max_employees INT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE contact (id INT AUTO_INCREMENT NOT NULL, person_id INT DEFAULT NULL, communication_id INT DEFAULT NULL, profile_picture_id INT DEFAULT NULL, profile_type_id INT DEFAULT NULL, employee_position VARCHAR(191) DEFAULT NULL, created_at DATETIME NOT NULL, profile_id VARCHAR(20) NOT NULL, UNIQUE INDEX UNIQ_4C62E638217BBB47 (person_id), UNIQUE INDEX UNIQ_4C62E6381C2D1E0C (communication_id), INDEX IDX_4C62E638292E8AE2 (profile_picture_id), INDEX IDX_4C62E63816F2520F (profile_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE contact_gallery (id INT AUTO_INCREMENT NOT NULL, is_visible TINYINT(1) DEFAULT 1, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE contact_gallery_entry (id INT AUTO_INCREMENT NOT NULL, contact_gallery_id INT DEFAULT NULL, contact_id INT DEFAULT NULL, position INT NOT NULL, INDEX IDX_EE240ED4C35EF618 (contact_gallery_id), INDEX IDX_EE240ED4E7A1254A (contact_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE custom_variable (id INT AUTO_INCREMENT NOT NULL, custom_variable_type_id INT DEFAULT NULL, name VARCHAR(100) NOT NULL, description VARCHAR(100) NOT NULL, int_value INT DEFAULT NULL, string_value VARCHAR(500) DEFAULT NULL, datetime_value DATETIME DEFAULT NULL, INDEX IDX_299F60E986CCF6A2 (custom_variable_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE custom_variable_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(100) NOT NULL, description VARCHAR(100) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE event (id INT AUTO_INCREMENT NOT NULL, address_id INT DEFAULT NULL, gallery_id INT DEFAULT NULL, video_gallery_id INT DEFAULT NULL, document_gallery_id INT DEFAULT NULL, followup_document_gallery_id INT DEFAULT NULL, user_id INT DEFAULT NULL, media_id INT DEFAULT NULL, profile_type_id INT DEFAULT NULL, event_state_id INT DEFAULT NULL, name VARCHAR(191) NOT NULL, description VARCHAR(512) DEFAULT NULL, description_long MEDIUMTEXT DEFAULT NULL, max_participants INT DEFAULT NULL, duration VARCHAR(512) DEFAULT NULL, all_tyrol TINYINT(1) DEFAULT NULL, requirement_text MEDIUMTEXT DEFAULT NULL, profile_id INT NOT NULL, is_visible TINYINT(1) DEFAULT 1 NOT NULL, created_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_3BAE0AA7F5B7AF75 (address_id), UNIQUE INDEX UNIQ_3BAE0AA74E7AF8F (gallery_id), UNIQUE INDEX UNIQ_3BAE0AA78440B739 (video_gallery_id), UNIQUE INDEX UNIQ_3BAE0AA7A52404D9 (document_gallery_id), UNIQUE INDEX UNIQ_3BAE0AA72D0254C5 (followup_document_gallery_id), INDEX IDX_3BAE0AA7A76ED395 (user_id), INDEX IDX_3BAE0AA7EA9FDD75 (media_id), INDEX IDX_3BAE0AA716F2520F (profile_type_id), INDEX IDX_3BAE0AA74334D511 (event_state_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE event_job_mapping (event_id INT NOT NULL, job_id INT NOT NULL, INDEX IDX_7880489171F7E88B (event_id), INDEX IDX_78804891BE04EA9 (job_id), PRIMARY KEY(event_id, job_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE event_search_tag_mapping (event_id INT NOT NULL, search_tag_id INT NOT NULL, INDEX IDX_3A9E542A71F7E88B (event_id), INDEX IDX_3A9E542A63300C0E (search_tag_id), PRIMARY KEY(event_id, search_tag_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE event_feedback (id INT AUTO_INCREMENT NOT NULL, event_id INT DEFAULT NULL, created_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_94C5AD8871F7E88B (event_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE event_feedback_answer (id INT AUTO_INCREMENT NOT NULL, event_feedback_user_id INT DEFAULT NULL, event_feedback_question_id INT DEFAULT NULL, answer MEDIUMTEXT NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_2E421A5B102710FE (event_feedback_user_id), INDEX IDX_2E421A5B15577CC7 (event_feedback_question_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE event_feedback_question (id INT AUTO_INCREMENT NOT NULL, event_feedback_id INT DEFAULT NULL, nr INT NOT NULL, question MEDIUMTEXT NOT NULL, archive TINYINT(1) NOT NULL, INDEX IDX_6C20B85D79C07B07 (event_feedback_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE event_feedback_user (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, event_feedback_id INT DEFAULT NULL, allow_data_transfer TINYINT(1) DEFAULT NULL, created_at DATETIME NOT NULL, INDEX IDX_6C68876CA76ED395 (user_id), INDEX IDX_6C68876C79C07B07 (event_feedback_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE event_preparation (id INT AUTO_INCREMENT NOT NULL, event_id INT DEFAULT NULL, UNIQUE INDEX UNIQ_5279797471F7E88B (event_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE event_preparation_answer (id INT AUTO_INCREMENT NOT NULL, event_preparation_user_id INT DEFAULT NULL, event_preparation_question_id INT DEFAULT NULL, answer MEDIUMTEXT NOT NULL, INDEX IDX_82224000EC32F8D8 (event_preparation_user_id), INDEX IDX_82224000B441551E (event_preparation_question_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE event_preparation_question (id INT AUTO_INCREMENT NOT NULL, event_preparation_id INT DEFAULT NULL, nr INT NOT NULL, question MEDIUMTEXT NOT NULL, archive TINYINT(1) NOT NULL, INDEX IDX_BED12848E29D0EC9 (event_preparation_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE event_preparation_user (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, event_preparation_id INT DEFAULT NULL, allow_data_transfer TINYINT(1) DEFAULT NULL, created_at DATETIME NOT NULL, INDEX IDX_197E6342A76ED395 (user_id), INDEX IDX_197E6342E29D0EC9 (event_preparation_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE event_state (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, description VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE event_tag (id INT AUTO_INCREMENT NOT NULL, event_tag_category_id INT DEFAULT NULL, name VARCHAR(128) NOT NULL, INDEX IDX_12467250C75C8332 (event_tag_category_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE event_tag_category (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(64) NOT NULL, position INT NOT NULL, color_code VARCHAR(10) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE event_tag_mapping (id INT AUTO_INCREMENT NOT NULL, event_tag_id INT DEFAULT NULL, event_id INT DEFAULT NULL, position SMALLINT NOT NULL, is_active TINYINT(1) DEFAULT 1 NOT NULL, INDEX IDX_D05ED2A0884B1443 (event_tag_id), INDEX IDX_D05ED2A071F7E88B (event_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE faq_category (id INT AUTO_INCREMENT NOT NULL, text VARCHAR(191) NOT NULL, url_text VARCHAR(191) DEFAULT NULL, position INT NOT NULL, is_visible TINYINT(1) DEFAULT 1 NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE faq_question (id INT AUTO_INCREMENT NOT NULL, faq_subcategory_id INT DEFAULT NULL, question VARCHAR(191) NOT NULL, answer MEDIUMTEXT NOT NULL, video_link VARCHAR(191) DEFAULT NULL, position INT NOT NULL, INDEX IDX_4A55B0595D8DA562 (faq_subcategory_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE faq_subcategory (id INT AUTO_INCREMENT NOT NULL, faq_category_id INT DEFAULT NULL, text VARCHAR(191) NOT NULL, url_text VARCHAR(191) DEFAULT NULL, position INT NOT NULL, INDEX IDX_E9138971F689B0DB (faq_category_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE file_path (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, path_symfony VARCHAR(191) NOT NULL, path_web VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE game_jeopardy_question (id INT AUTO_INCREMENT NOT NULL, csv_id INT NOT NULL, question MEDIUMTEXT NOT NULL, answer_a MEDIUMTEXT NOT NULL, answer_b MEDIUMTEXT NOT NULL, answer_c MEDIUMTEXT NOT NULL, answer_d MEDIUMTEXT NOT NULL, chapter_id INT NOT NULL, is_active TINYINT(1) DEFAULT 1, created_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_ACA31E105684A52A (csv_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE game_jeopardy_question_school_class_mapping (id INT AUTO_INCREMENT NOT NULL, game_jeopardy_school_class_id INT DEFAULT NULL, game_jeopardy_question_id INT DEFAULT NULL, play_date DATETIME NOT NULL, answer TINYINT(1) NOT NULL, has_sent_answer TINYINT(1) DEFAULT NULL, INDEX IDX_5F8D948584104B01 (game_jeopardy_school_class_id), INDEX IDX_5F8D9485E1F9AB61 (game_jeopardy_question_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE game_jeopardy_school_class (id INT AUTO_INCREMENT NOT NULL, school_class_id INT DEFAULT NULL, start_date DATETIME NOT NULL, chapter_1_questions INT DEFAULT 0 NOT NULL, chapter_2_questions INT DEFAULT 0 NOT NULL, chapter_3_questions INT DEFAULT 0 NOT NULL, chapter_4_questions INT DEFAULT 0 NOT NULL, chapter_5_questions INT DEFAULT 0 NOT NULL, INDEX IDX_52258E0B14463F54 (school_class_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE game_memory_school_class (id INT AUTO_INCREMENT NOT NULL, school_class_id INT DEFAULT NULL, start_date DATETIME NOT NULL, INDEX IDX_2424E3BD14463F54 (school_class_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE game_memory_school_class_job_mapping (id INT AUTO_INCREMENT NOT NULL, job_id INT DEFAULT NULL, game_memory_school_class_id INT DEFAULT NULL, answer TINYINT(1) NOT NULL, points INT DEFAULT NULL, has_sent_answer TINYINT(1) DEFAULT NULL, created_at DATETIME DEFAULT NULL, INDEX IDX_4089C446BE04EA9 (job_id), INDEX IDX_4089C446E297ECA9 (game_memory_school_class_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE game_quiz_question (id INT AUTO_INCREMENT NOT NULL, job_id INT DEFAULT NULL, school_profile_id INT DEFAULT NULL, game_quiz_question_category_id INT DEFAULT NULL, csv_id INT NOT NULL, question MEDIUMTEXT NOT NULL, answer_a MEDIUMTEXT NOT NULL, answer_b MEDIUMTEXT NOT NULL, answer_c MEDIUMTEXT NOT NULL, answer_d MEDIUMTEXT NOT NULL, is_active TINYINT(1) DEFAULT 1, created_at DATETIME NOT NULL, INDEX IDX_CAD72C60BE04EA9 (job_id), INDEX IDX_CAD72C60795B924A (school_profile_id), INDEX IDX_CAD72C60780B43E2 (game_quiz_question_category_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE game_quiz_question_category (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, category_letter VARCHAR(191) NOT NULL, is_active TINYINT(1) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE game_quiz_question_profile_mapping (id INT AUTO_INCREMENT NOT NULL, profile_type_id INT DEFAULT NULL, game_quiz_question_id INT DEFAULT NULL, profile_id INT NOT NULL, additional_info VARCHAR(200) NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_F5FF532216F2520F (profile_type_id), INDEX IDX_F5FF5322F102203 (game_quiz_question_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE game_quiz_question_school_class_mapping (id INT AUTO_INCREMENT NOT NULL, game_quiz_school_class_id INT DEFAULT NULL, game_quiz_question_id INT DEFAULT NULL, play_date DATETIME NOT NULL, answer TINYINT(1) NOT NULL, has_sent_answer TINYINT(1) DEFAULT NULL, INDEX IDX_3FA5BBE333D5D35C (game_quiz_school_class_id), INDEX IDX_3FA5BBE3F102203 (game_quiz_question_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE game_quiz_school_class (id INT AUTO_INCREMENT NOT NULL, school_class_id INT DEFAULT NULL, game_quiz_question_category_id INT DEFAULT NULL, job_daily_routine_id INT DEFAULT NULL, start_date DATETIME NOT NULL, joker_a INT DEFAULT 0 NOT NULL, joker_b INT DEFAULT 0 NOT NULL, joker_c INT DEFAULT 0 NOT NULL, INDEX IDX_F17767F614463F54 (school_class_id), INDEX IDX_F17767F6780B43E2 (game_quiz_question_category_id), INDEX IDX_F17767F6D27F8922 (job_daily_routine_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE hobby (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE info_section_category (id INT AUTO_INCREMENT NOT NULL, section_type_id INT DEFAULT NULL, category_picture_id INT DEFAULT NULL, heading VARCHAR(191) NOT NULL, heading_color VARCHAR(30) DEFAULT NULL, description VARCHAR(191) NOT NULL, url_text VARCHAR(30) DEFAULT NULL, link VARCHAR(191) DEFAULT NULL, target INT DEFAULT NULL COMMENT \'1=self, 2=blank\', position INT NOT NULL, INDEX IDX_BF12A6B3170B419C (section_type_id), INDEX IDX_BF12A6B3C85BEDC1 (category_picture_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE info_section_entry (id INT AUTO_INCREMENT NOT NULL, section_subcategory_id INT DEFAULT NULL, entry_picture_id INT DEFAULT NULL, heading VARCHAR(191) NOT NULL, heading_color VARCHAR(30) DEFAULT NULL, description VARCHAR(191) NOT NULL, url VARCHAR(191) NOT NULL, design INT NOT NULL COMMENT \'1=self, 2=blank\', target INT NOT NULL COMMENT \'1=self, 2=blank\', position INT NOT NULL, INDEX IDX_F4E911886076769F (section_subcategory_id), INDEX IDX_F4E9118876EFF48D (entry_picture_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE info_section_subcategory (id INT AUTO_INCREMENT NOT NULL, info_section_category_id INT DEFAULT NULL, heading VARCHAR(191) NOT NULL, description MEDIUMTEXT DEFAULT NULL, anchor VARCHAR(191) DEFAULT NULL, position INT NOT NULL, INDEX IDX_B527D64BAABDEFE1 (info_section_category_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE info_section_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job (id INT AUTO_INCREMENT NOT NULL, job_image_id INT DEFAULT NULL, job_teaser_image_id INT DEFAULT NULL, job_gallery_id INT DEFAULT NULL, bic_id VARCHAR(255) DEFAULT NULL, name VARCHAR(191) NOT NULL, description MEDIUMTEXT NOT NULL, is_scholastic_professsion TINYINT(1) DEFAULT 0 NOT NULL, scholastic_duration VARCHAR(255) DEFAULT NULL, lbrnr INT DEFAULT NULL, mlbrnr INT DEFAULT NULL, operations_and_tasks MEDIUMTEXT DEFAULT NULL, self_employed MEDIUMTEXT DEFAULT NULL, bic_anforderungen MEDIUMTEXT DEFAULT NULL, bic_alternativen MEDIUMTEXT DEFAULT NULL, bic_lehre_matura MEDIUMTEXT DEFAULT NULL, bic_ausbildung_berufschule MEDIUMTEXT DEFAULT NULL, UNIQUE INDEX UNIQ_FBD8E0F85AE28016 (job_image_id), UNIQUE INDEX UNIQ_FBD8E0F81EF359A0 (job_teaser_image_id), UNIQUE INDEX UNIQ_FBD8E0F86E903F92 (job_gallery_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_sector_mapping (job_id INT NOT NULL, sector_id INT NOT NULL, INDEX IDX_7112EF68BE04EA9 (job_id), INDEX IDX_7112EF68DE95C867 (sector_id), PRIMARY KEY(job_id, sector_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_educational_path_mapping (job_id INT NOT NULL, job_educational_path_id INT NOT NULL, INDEX IDX_E5B4189CBE04EA9 (job_id), INDEX IDX_E5B4189C8421405E (job_educational_path_id), PRIMARY KEY(job_id, job_educational_path_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_workfield_mapping (job_id INT NOT NULL, job_workfield_id INT NOT NULL, INDEX IDX_FBEDF99CBE04EA9 (job_id), INDEX IDX_FBEDF99CEAD7CBC0 (job_workfield_id), PRIMARY KEY(job_id, job_workfield_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_search_tag_mapping (job_id INT NOT NULL, search_tag_id INT NOT NULL, INDEX IDX_CD6D9CEDBE04EA9 (job_id), INDEX IDX_CD6D9CED63300C0E (search_tag_id), PRIMARY KEY(job_id, search_tag_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_ams (id INT AUTO_INCREMENT NOT NULL, job_id INT DEFAULT NULL, ams_id VARCHAR(191) DEFAULT NULL, url_ext VARCHAR(191) DEFAULT NULL, title VARCHAR(191) DEFAULT NULL, salary_from VARCHAR(10) DEFAULT NULL, salary_to VARCHAR(10) DEFAULT NULL, url VARCHAR(2048) DEFAULT NULL, UNIQUE INDEX UNIQ_6BDEDEF8BE04EA9 (job_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_daily_routine (id INT AUTO_INCREMENT NOT NULL, media_id INT DEFAULT NULL, media_2_id INT DEFAULT NULL, job_daily_routine_category_id INT DEFAULT NULL, school_profile_id INT DEFAULT NULL, job_id INT DEFAULT NULL, show_after_date DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_3FC957EEEA9FDD75 (media_id), UNIQUE INDEX UNIQ_3FC957EE21212CC7 (media_2_id), INDEX IDX_3FC957EEC9F81D25 (job_daily_routine_category_id), INDEX IDX_3FC957EE795B924A (school_profile_id), INDEX IDX_3FC957EEBE04EA9 (job_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_daily_routine_category (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(64) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_daily_routine_entry (id INT AUTO_INCREMENT NOT NULL, job_daily_routine_id INT DEFAULT NULL, media_top_id INT DEFAULT NULL, media_right_id INT DEFAULT NULL, media_bottom_id INT DEFAULT NULL, media_picture_id INT DEFAULT NULL, heading MEDIUMTEXT DEFAULT NULL, description MEDIUMTEXT DEFAULT NULL, description_info VARCHAR(191) DEFAULT NULL, videourl MEDIUMTEXT DEFAULT NULL, day_time VARCHAR(191) DEFAULT NULL, position INT DEFAULT NULL, INDEX IDX_23161BE4D27F8922 (job_daily_routine_id), INDEX IDX_23161BE474552888 (media_top_id), INDEX IDX_23161BE45BF64687 (media_right_id), INDEX IDX_23161BE47B8DD49A (media_bottom_id), INDEX IDX_23161BE4E460732B (media_picture_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_educational_path (id INT AUTO_INCREMENT NOT NULL, bic_id VARCHAR(191) DEFAULT NULL, name VARCHAR(191) NOT NULL, name_long VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_link (id INT AUTO_INCREMENT NOT NULL, url VARCHAR(191) NOT NULL, title_frontend VARCHAR(191) NOT NULL, title_backend VARCHAR(191) NOT NULL, start INT NOT NULL, end INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_link_mapping (id INT AUTO_INCREMENT NOT NULL, job_id INT DEFAULT NULL, job_link_id INT DEFAULT NULL, job_link_mapping_category_id INT DEFAULT NULL, job_link_mapping_type_id INT DEFAULT NULL, position INT NOT NULL, start_date DATETIME NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_3BE3E350BE04EA9 (job_id), INDEX IDX_3BE3E350374BB5EA (job_link_id), INDEX IDX_3BE3E350BEE658CB (job_link_mapping_category_id), INDEX IDX_3BE3E350904BC219 (job_link_mapping_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_link_mapping_category (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(64) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_link_mapping_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(64) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_market (id INT AUTO_INCREMENT NOT NULL, address_id INT DEFAULT NULL, media_id INT DEFAULT NULL, custom_advertisment_media_id INT DEFAULT NULL, contact_id INT DEFAULT NULL, company_contact_id INT DEFAULT NULL, job_market_position_type_id INT DEFAULT NULL, job_market_apply_type_id INT DEFAULT NULL, job_market_start_type_id INT DEFAULT NULL, company_profile_id INT DEFAULT NULL, user_id INT DEFAULT NULL, job_market_state_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, number_of_positions INT NOT NULL, start_date DATE DEFAULT NULL, apply_until DATE DEFAULT NULL, description LONGTEXT DEFAULT NULL, requirements LONGTEXT DEFAULT NULL, salary VARCHAR(100) NOT NULL, details LONGTEXT DEFAULT NULL, open_date DATETIME NOT NULL, closed_date DATETIME NOT NULL, url VARCHAR(255) DEFAULT NULL, additional_info LONGTEXT DEFAULT NULL, INDEX IDX_3BA8A84AF5B7AF75 (address_id), INDEX IDX_3BA8A84AEA9FDD75 (media_id), INDEX IDX_3BA8A84A71672B6D (custom_advertisment_media_id), INDEX IDX_3BA8A84AE7A1254A (contact_id), INDEX IDX_3BA8A84A5A2FCCDC (company_contact_id), INDEX IDX_3BA8A84A45E22644 (job_market_position_type_id), INDEX IDX_3BA8A84A45FC6BDC (job_market_apply_type_id), INDEX IDX_3BA8A84A35F10E35 (job_market_start_type_id), INDEX IDX_3BA8A84A7174FB2E (company_profile_id), INDEX IDX_3BA8A84AA76ED395 (user_id), INDEX IDX_3BA8A84A3F56666 (job_market_state_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_market_job_mapping (job_market_id INT NOT NULL, job_id INT NOT NULL, INDEX IDX_AB53959A59FD026 (job_market_id), INDEX IDX_AB53959BE04EA9 (job_id), PRIMARY KEY(job_market_id, job_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_market_apply_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, description VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_market_position_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, description VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_market_start_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, description VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_market_state (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, description VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_school (id INT AUTO_INCREMENT NOT NULL, school_id INT DEFAULT NULL, job_id INT DEFAULT NULL, is_active TINYINT(1) DEFAULT 1 NOT NULL, INDEX IDX_A99AF73AC32A47EE (school_id), INDEX IDX_A99AF73ABE04EA9 (job_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_sector (id INT AUTO_INCREMENT NOT NULL, sector_image_id INT DEFAULT NULL, bic_id VARCHAR(10) DEFAULT NULL, name VARCHAR(128) NOT NULL, default_image_name VARCHAR(128) NOT NULL, description MEDIUMTEXT DEFAULT NULL, INDEX IDX_1BA7F46998051D95 (sector_image_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_sector_image (id INT AUTO_INCREMENT NOT NULL, file_path_id INT DEFAULT NULL, name VARCHAR(191) NOT NULL, alttext VARCHAR(191) NOT NULL, filename VARCHAR(191) NOT NULL, file_extension VARCHAR(10) NOT NULL, INDEX IDX_1D852DE1820AEF50 (file_path_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_workfield (id INT AUTO_INCREMENT NOT NULL, job_workfield_image_id INT DEFAULT NULL, bic_id VARCHAR(255) DEFAULT NULL, name VARCHAR(191) NOT NULL, default_image_name VARCHAR(128) DEFAULT NULL, description MEDIUMTEXT NOT NULL, INDEX IDX_38A36B6AC9C39BE9 (job_workfield_image_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE job_workfield_image (id INT AUTO_INCREMENT NOT NULL, job_workfield_id INT DEFAULT NULL, file_path_id INT DEFAULT NULL, name VARCHAR(191) NOT NULL, alttext VARCHAR(191) NOT NULL, filename VARCHAR(191) NOT NULL, file_extension VARCHAR(10) NOT NULL, INDEX IDX_7D2E8060EAD7CBC0 (job_workfield_id), INDEX IDX_7D2E8060820AEF50 (file_path_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE lebenslauf (id INT AUTO_INCREMENT NOT NULL, code VARCHAR(255) NOT NULL, persoenliches LONGTEXT DEFAULT NULL, bildung_schule LONGTEXT DEFAULT NULL, bildung_weitere LONGTEXT DEFAULT NULL, berufserfahrung LONGTEXT DEFAULT NULL, weitere_angaben LONGTEXT DEFAULT NULL, dokumente LONGTEXT DEFAULT NULL, anschreiben LONGTEXT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE media__gallery (id INT AUTO_INCREMENT NOT NULL, media_gallery_category_id INT DEFAULT NULL, context VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, default_format VARCHAR(255) NOT NULL, enabled TINYINT(1) DEFAULT 0 NOT NULL, updated_at DATETIME NOT NULL, created_at DATETIME NOT NULL, owner_id INT NOT NULL, INDEX IDX_3C02B7F53F01A74C (media_gallery_category_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE media__gallery_media (id INT AUTO_INCREMENT NOT NULL, gallery_id INT DEFAULT NULL, media_id INT DEFAULT NULL, position SMALLINT NOT NULL, enabled TINYINT(1) DEFAULT 0 NOT NULL, updated_at DATETIME NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_80D4C5414E7AF8F (gallery_id), INDEX IDX_80D4C541EA9FDD75 (media_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE media__media (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, provider_name VARCHAR(255) NOT NULL, provider_reference VARCHAR(255) NOT NULL, provider_metadata TEXT DEFAULT NULL COMMENT \'(DC2Type:json)\', content_type VARCHAR(255) DEFAULT NULL, context VARCHAR(64) DEFAULT NULL, updated_at DATETIME NOT NULL, created_at DATETIME NOT NULL, owner_id INT DEFAULT NULL, document_type INT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE media_gallery_category (id INT AUTO_INCREMENT NOT NULL, category TINYTEXT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE misc_file (id INT AUTO_INCREMENT NOT NULL, file_path_id INT DEFAULT NULL, name VARCHAR(191) NOT NULL, filename VARCHAR(191) NOT NULL, file_extension VARCHAR(10) NOT NULL, INDEX IDX_C0F9CF99820AEF50 (file_path_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE news (id INT AUTO_INCREMENT NOT NULL, sender_user_id INT DEFAULT NULL, receiver_user_id INT DEFAULT NULL, news_type_id INT DEFAULT NULL, news_message_id INT DEFAULT NULL, is_new TINYINT(1) DEFAULT 1, is_system TINYINT(1) DEFAULT 0, link_object_id INT DEFAULT NULL, booking_msg_count INT DEFAULT NULL, created_at DATETIME DEFAULT NULL, read_at DATETIME DEFAULT NULL, INDEX IDX_1DD399502A98155E (sender_user_id), INDEX IDX_1DD39950DA57E237 (receiver_user_id), INDEX IDX_1DD3995092A89075 (news_type_id), INDEX IDX_1DD39950BF05C450 (news_message_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE news_message (id INT AUTO_INCREMENT NOT NULL, subject VARCHAR(191) DEFAULT NULL, news_text MEDIUMTEXT DEFAULT NULL, news_small_text MEDIUMTEXT DEFAULT NULL, created_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE news_reminder (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, send_at DATETIME DEFAULT NULL, INDEX IDX_909EC11A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE news_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE person (id INT AUTO_INCREMENT NOT NULL, firstname VARCHAR(191) NOT NULL, lastname VARCHAR(191) NOT NULL, sex SMALLINT DEFAULT NULL, birthday DATE DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE person_title_mapping (person_id INT NOT NULL, title_id INT NOT NULL, INDEX IDX_314263E217BBB47 (person_id), INDEX IDX_314263EA9F87BD (title_id), PRIMARY KEY(person_id, title_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE profile_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, short_name VARCHAR(191) NOT NULL, position INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_address (id INT AUTO_INCREMENT NOT NULL, address_city_id INT DEFAULT NULL, street VARCHAR(191) DEFAULT NULL, number VARCHAR(30) DEFAULT NULL, INDEX IDX_FD285985D0499537 (address_city_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_booking (id INT AUTO_INCREMENT NOT NULL, rookie_offer_time_slot_mapping_id INT DEFAULT NULL, rookie_person_id INT DEFAULT NULL, rookie_district_id INT DEFAULT NULL, rookie_school_class_id INT DEFAULT NULL, created_at DATETIME NOT NULL, sent_at DATETIME NOT NULL, INDEX IDX_106ADBDAA4F20E15 (rookie_offer_time_slot_mapping_id), INDEX IDX_106ADBDA8AAD1BBC (rookie_person_id), INDEX IDX_106ADBDA9111923A (rookie_district_id), INDEX IDX_106ADBDACD261DDC (rookie_school_class_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_communication (id INT AUTO_INCREMENT NOT NULL, email VARCHAR(191) NOT NULL, phone VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_contact (id INT AUTO_INCREMENT NOT NULL, rookie_contact_type_id INT DEFAULT NULL, rookie_person_id INT DEFAULT NULL, rookie_district_id INT DEFAULT NULL, INDEX IDX_BC04D03C86038F9A (rookie_contact_type_id), INDEX IDX_BC04D03C8AAD1BBC (rookie_person_id), INDEX IDX_BC04D03C9111923A (rookie_district_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_contact_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_district (id INT AUTO_INCREMENT NOT NULL, district_name VARCHAR(100) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_offer (id INT AUTO_INCREMENT NOT NULL, rookie_provider_contact_mapping_id INT DEFAULT NULL, job_id INT DEFAULT NULL, rookie_provider_location_id INT DEFAULT NULL, rookie_district_id INT DEFAULT NULL, user_op_id INT DEFAULT NULL, person_max INT DEFAULT 0 NOT NULL, work_time MEDIUMTEXT DEFAULT NULL COMMENT \'Arbeitszeit\', work_clothes MEDIUMTEXT DEFAULT NULL COMMENT \'Arbeitskleidung\', work_comment MEDIUMTEXT DEFAULT NULL COMMENT \'Arbeitshinweis\', is_active TINYINT(1) NOT NULL, edited_at DATETIME DEFAULT NULL, created_at DATETIME NOT NULL, INDEX IDX_8A54E9ADAF707042 (rookie_provider_contact_mapping_id), INDEX IDX_8A54E9ADBE04EA9 (job_id), INDEX IDX_8A54E9AD505285EC (rookie_provider_location_id), INDEX IDX_8A54E9AD9111923A (rookie_district_id), INDEX IDX_8A54E9ADCDBD5067 (user_op_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_offer_time_slot_mapping (id INT AUTO_INCREMENT NOT NULL, rookie_offer_id INT DEFAULT NULL, rookie_time_slot_id INT DEFAULT NULL, user_op_id INT DEFAULT NULL, limit_reached TINYINT(1) DEFAULT 0 NOT NULL, is_active TINYINT(1) NOT NULL, edited_at DATETIME DEFAULT NULL, created_at DATETIME NOT NULL, INDEX IDX_2FF41139545BD6C1 (rookie_offer_id), INDEX IDX_2FF411397544E768 (rookie_time_slot_id), INDEX IDX_2FF41139CDBD5067 (user_op_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_person (id INT AUTO_INCREMENT NOT NULL, gender SMALLINT DEFAULT NULL, pre_title VARCHAR(191) DEFAULT NULL, firstname VARCHAR(191) NOT NULL, lastname VARCHAR(191) NOT NULL, post_title VARCHAR(191) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_person_address_mapping (id INT AUTO_INCREMENT NOT NULL, rookie_person_id INT DEFAULT NULL, rookie_address_id INT DEFAULT NULL, INDEX IDX_E0749A7F8AAD1BBC (rookie_person_id), INDEX IDX_E0749A7FDF735241 (rookie_address_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_person_communication_mapping (id INT AUTO_INCREMENT NOT NULL, rookie_person_id INT DEFAULT NULL, rookie_communication_id INT DEFAULT NULL, UNIQUE INDEX UNIQ_AD6657368AAD1BBC (rookie_person_id), UNIQUE INDEX UNIQ_AD665736FF97753C (rookie_communication_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_provider (id INT AUTO_INCREMENT NOT NULL, company_profile_id INT DEFAULT NULL, rookie_district_id INT DEFAULT NULL, user_op_id INT DEFAULT NULL, optional_name VARCHAR(255) DEFAULT NULL, homepage VARCHAR(255) DEFAULT NULL, email VARCHAR(255) DEFAULT NULL, is_visible TINYINT(1) DEFAULT 1 NOT NULL, edited_at DATETIME DEFAULT NULL, created_at DATETIME NOT NULL, INDEX IDX_9559D1B37174FB2E (company_profile_id), INDEX IDX_9559D1B39111923A (rookie_district_id), INDEX IDX_9559D1B3CDBD5067 (user_op_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_provider_contact_mapping (id INT AUTO_INCREMENT NOT NULL, rookie_provider_id INT DEFAULT NULL, rookie_contact_id INT DEFAULT NULL, INDEX IDX_D3C53D602BCD98E2 (rookie_provider_id), INDEX IDX_D3C53D60CD65D87E (rookie_contact_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_provider_location (id INT AUTO_INCREMENT NOT NULL, rookie_provider_id INT DEFAULT NULL, rookie_address_id INT DEFAULT NULL, lat VARCHAR(40) DEFAULT NULL, lon VARCHAR(40) DEFAULT NULL, INDEX IDX_30E66DE52BCD98E2 (rookie_provider_id), INDEX IDX_30E66DE5DF735241 (rookie_address_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_provider_register_time (id INT AUTO_INCREMENT NOT NULL, rookie_district_id INT DEFAULT NULL, open_at DATETIME NOT NULL, close_at DATETIME NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_3D83B02E9111923A (rookie_district_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_school (id INT AUTO_INCREMENT NOT NULL, rookie_district_id INT DEFAULT NULL, school_id INT DEFAULT NULL, rookie_time_slot_id INT DEFAULT NULL, optional_name VARCHAR(255) DEFAULT NULL, is_visible TINYINT(1) DEFAULT 1 NOT NULL, INDEX IDX_903B9A2B9111923A (rookie_district_id), INDEX IDX_903B9A2BC32A47EE (school_id), INDEX IDX_903B9A2B7544E768 (rookie_time_slot_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_school_class (id INT AUTO_INCREMENT NOT NULL, rookie_school_id INT DEFAULT NULL, name VARCHAR(191) DEFAULT NULL, INDEX IDX_4B97F81768FCE715 (rookie_school_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_school_contact_mapping (id INT AUTO_INCREMENT NOT NULL, rookie_school_id INT DEFAULT NULL, rookie_school_class_id INT DEFAULT NULL, rookie_contact_id INT DEFAULT NULL, INDEX IDX_7E9F545168FCE715 (rookie_school_id), INDEX IDX_7E9F5451CD261DDC (rookie_school_class_id), INDEX IDX_7E9F5451CD65D87E (rookie_contact_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_time_slot (id INT AUTO_INCREMENT NOT NULL, rookie_district_id INT DEFAULT NULL, rookie_time_slot_state_id INT DEFAULT NULL, name VARCHAR(100) NOT NULL, open_at DATETIME NOT NULL, close_at DATETIME NOT NULL, work_from DATETIME NOT NULL, work_to DATETIME NOT NULL, comment MEDIUMTEXT DEFAULT NULL, INDEX IDX_AA6589B19111923A (rookie_district_id), INDEX IDX_AA6589B1597A6244 (rookie_time_slot_state_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rookie_time_slot_state (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school (id INT AUTO_INCREMENT NOT NULL, communication_id INT DEFAULT NULL, address_id INT DEFAULT NULL, name VARCHAR(191) NOT NULL, school_number VARCHAR(255) DEFAULT NULL, url VARCHAR(191) DEFAULT NULL, is_active TINYINT(1) DEFAULT 1 NOT NULL, created_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_F99EDABB1C2D1E0C (communication_id), UNIQUE INDEX UNIQ_F99EDABBF5B7AF75 (address_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_type_mapping (school_id INT NOT NULL, school_type_id INT NOT NULL, INDEX IDX_AAF5F6C1C32A47EE (school_id), INDEX IDX_AAF5F6C15763BE0B (school_type_id), PRIMARY KEY(school_id, school_type_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_award_mapping (school_id INT NOT NULL, school_award_id INT NOT NULL, INDEX IDX_9A345F77C32A47EE (school_id), INDEX IDX_9A345F77C314B68B (school_award_id), PRIMARY KEY(school_id, school_award_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_award (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(60) NOT NULL, description VARCHAR(255) NOT NULL, points INT NOT NULL, end_date DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_benefit (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_class (id INT AUTO_INCREMENT NOT NULL, school_id INT DEFAULT NULL, school_class_grade_id INT DEFAULT NULL, school_class_year_id INT DEFAULT NULL, school_class_user_id INT DEFAULT NULL, school_class_state_id INT DEFAULT NULL, number_part VARCHAR(10) DEFAULT NULL, text_part VARCHAR(50) DEFAULT NULL, created_at DATETIME NOT NULL, deleted_at DATETIME DEFAULT NULL, history_id INT DEFAULT NULL, number_of_students INT NOT NULL, user_password VARCHAR(191) DEFAULT NULL, INDEX IDX_33B1AF85C32A47EE (school_id), INDEX IDX_33B1AF858B9A65FF (school_class_grade_id), INDEX IDX_33B1AF85A9A63565 (school_class_year_id), INDEX IDX_33B1AF854E091857 (school_class_user_id), INDEX IDX_33B1AF85705BF896 (school_class_state_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_class_custom_special_field_mapping (id INT AUTO_INCREMENT NOT NULL, school_class_id INT DEFAULT NULL, school_custom_special_field_id INT DEFAULT NULL, number_of_students INT NOT NULL, is_active TINYINT(1) DEFAULT 1 NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_748537E614463F54 (school_class_id), INDEX IDX_748537E6ABC709B9 (school_custom_special_field_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_class_grade (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, grade INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_class_state (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, description VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_class_teacher_mapping (id INT AUTO_INCREMENT NOT NULL, school_class_id INT DEFAULT NULL, user_id INT DEFAULT NULL, is_active TINYINT(1) DEFAULT 1 NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_4288B0BC14463F54 (school_class_id), INDEX IDX_4288B0BCA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_class_year (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, start_year INT NOT NULL, end_year INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_contact (id INT AUTO_INCREMENT NOT NULL, person_id INT DEFAULT NULL, communication_id INT DEFAULT NULL, profile_picture_id INT DEFAULT NULL, school_profile_id INT DEFAULT NULL, employee_position VARCHAR(128) DEFAULT NULL, created_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_DE4DD4A0217BBB47 (person_id), UNIQUE INDEX UNIQ_DE4DD4A01C2D1E0C (communication_id), INDEX IDX_DE4DD4A0292E8AE2 (profile_picture_id), INDEX IDX_DE4DD4A0795B924A (school_profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_custom_special_field (id INT AUTO_INCREMENT NOT NULL, school_id INT DEFAULT NULL, teacher_user_id INT DEFAULT NULL, name VARCHAR(191) NOT NULL, is_active TINYINT(1) DEFAULT 1, created_at DATETIME NOT NULL, INDEX IDX_1B937E1CC32A47EE (school_id), INDEX IDX_1B937E1C6AAC5ED4 (teacher_user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_custom_special_field_special_field_mapping (school_custom_special_field_id INT NOT NULL, school_special_field_id INT NOT NULL, INDEX IDX_A2F4FD5CABC709B9 (school_custom_special_field_id), INDEX IDX_A2F4FD5C1B74263C (school_special_field_id), PRIMARY KEY(school_custom_special_field_id, school_special_field_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_director_mapping (id INT AUTO_INCREMENT NOT NULL, school_id INT DEFAULT NULL, user_id INT DEFAULT NULL, is_active TINYINT(1) DEFAULT 1 NOT NULL, is_selected TINYINT(1) DEFAULT 0 NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_45A6B5DEC32A47EE (school_id), INDEX IDX_45A6B5DEA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_location (id INT AUTO_INCREMENT NOT NULL, address_id INT DEFAULT NULL, school_profile_id INT DEFAULT NULL, name VARCHAR(60) NOT NULL, position INT NOT NULL, is_active TINYINT(1) DEFAULT 1 NOT NULL, created_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_A0D8BD8FF5B7AF75 (address_id), INDEX IDX_A0D8BD8F795B924A (school_profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_profile (id INT AUTO_INCREMENT NOT NULL, school_id INT DEFAULT NULL, communication_id INT DEFAULT NULL, profile_picture_id INT DEFAULT NULL, gallery_id INT DEFAULT NULL, video_gallery_id INT DEFAULT NULL, document_gallery_id INT DEFAULT NULL, contact_gallery_id INT DEFAULT NULL, uuid CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', name VARCHAR(191) NOT NULL, description MEDIUMTEXT DEFAULT NULL, training_information MEDIUMTEXT DEFAULT NULL, certificate_information MEDIUMTEXT DEFAULT NULL, url VARCHAR(2048) DEFAULT NULL, click_count INT DEFAULT 0, is_visible TINYINT(1) DEFAULT 1 NOT NULL, UNIQUE INDEX UNIQ_13789897C32A47EE (school_id), UNIQUE INDEX UNIQ_137898971C2D1E0C (communication_id), UNIQUE INDEX UNIQ_13789897292E8AE2 (profile_picture_id), UNIQUE INDEX UNIQ_137898974E7AF8F (gallery_id), UNIQUE INDEX UNIQ_137898978440B739 (video_gallery_id), UNIQUE INDEX UNIQ_13789897A52404D9 (document_gallery_id), UNIQUE INDEX UNIQ_13789897C35EF618 (contact_gallery_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_profile_job_mapping (school_profile_id INT NOT NULL, job_id INT NOT NULL, INDEX IDX_86F4E9B5795B924A (school_profile_id), INDEX IDX_86F4E9B5BE04EA9 (job_id), PRIMARY KEY(school_profile_id, job_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_profile_benefit_mapping (school_profile_id INT NOT NULL, school_benefit_id INT NOT NULL, INDEX IDX_3ECE2046795B924A (school_profile_id), INDEX IDX_3ECE2046BEF0FB7B (school_benefit_id), PRIMARY KEY(school_profile_id, school_benefit_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_profile_search_tag_mapping (company_profile_id INT NOT NULL, search_tag_id INT NOT NULL, INDEX IDX_B9C7AC757174FB2E (company_profile_id), INDEX IDX_B9C7AC7563300C0E (search_tag_id), PRIMARY KEY(company_profile_id, search_tag_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_profile_event_mapping (id INT AUTO_INCREMENT NOT NULL, event_id INT DEFAULT NULL, school_profile_id INT DEFAULT NULL, UNIQUE INDEX UNIQ_B8D1B92571F7E88B (event_id), INDEX IDX_B8D1B925795B924A (school_profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_profile_name_request (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, school_profile_id INT DEFAULT NULL, name_old VARCHAR(191) NOT NULL, name_new VARCHAR(191) NOT NULL, applied_at DATETIME DEFAULT NULL, created_at DATETIME NOT NULL, INDEX IDX_E21250A2A76ED395 (user_id), INDEX IDX_E21250A2795B924A (school_profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_role (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(45) NOT NULL, short_name VARCHAR(10) NOT NULL, description VARCHAR(45) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_special_field (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, is_active TINYINT(1) DEFAULT 1, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_subject (id INT AUTO_INCREMENT NOT NULL, abbreviation VARCHAR(30) NOT NULL, name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_teacher_invitation (id INT AUTO_INCREMENT NOT NULL, school_id INT DEFAULT NULL, director_id INT DEFAULT NULL, invitation_state_id INT DEFAULT NULL, email VARCHAR(191) NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_443D7FE8C32A47EE (school_id), INDEX IDX_443D7FE8899FB366 (director_id), INDEX IDX_443D7FE825CC445C (invitation_state_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_teacher_invitation_role_mapping (school_teacher_invitation_id INT NOT NULL, school_role_id INT NOT NULL, INDEX IDX_799B78B8317F6D44 (school_teacher_invitation_id), INDEX IDX_799B78B8442C1034 (school_role_id), PRIMARY KEY(school_teacher_invitation_id, school_role_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_teacher_invitation_state (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, description VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_teacher_mapping (id INT AUTO_INCREMENT NOT NULL, school_id INT DEFAULT NULL, user_id INT DEFAULT NULL, is_active TINYINT(1) DEFAULT 1 NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_1A817967C32A47EE (school_id), INDEX IDX_1A817967A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_teacher_role_mapping (school_teacher_mapping_id INT NOT NULL, school_role_id INT NOT NULL, INDEX IDX_5B2A6BD4F9B6986 (school_teacher_mapping_id), INDEX IDX_5B2A6BD442C1034 (school_role_id), PRIMARY KEY(school_teacher_mapping_id, school_role_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_type (id INT AUTO_INCREMENT NOT NULL, school_type_category_id INT DEFAULT NULL, name VARCHAR(191) NOT NULL, short_name VARCHAR(191) NOT NULL, INDEX IDX_CDF688C486A10068 (school_type_category_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_type_category (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, shortname VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE score (id INT AUTO_INCREMENT NOT NULL, score_type_id INT DEFAULT NULL, school_class_id INT DEFAULT NULL, points DOUBLE PRECISION DEFAULT \'0\' NOT NULL, reference_id INT DEFAULT NULL, created_at DATETIME NOT NULL, INDEX IDX_32993751A4C4A907 (score_type_id), INDEX IDX_3299375114463F54 (school_class_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE score_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, points INT DEFAULT 0 NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE search_tag (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE shuttle_booking (id INT AUTO_INCREMENT NOT NULL, shuttle_contact_id INT DEFAULT NULL, shuttle_tour_id INT DEFAULT NULL, school_id INT DEFAULT NULL, number_of_students INT NOT NULL, created_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_9D53859FC0096F0A (shuttle_contact_id), INDEX IDX_9D53859F68B2E502 (shuttle_tour_id), INDEX IDX_9D53859FC32A47EE (school_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE shuttle_company (id INT AUTO_INCREMENT NOT NULL, address_id INT DEFAULT NULL, profile_picture_id INT DEFAULT NULL, shuttle_duration_id INT DEFAULT NULL, name VARCHAR(150) NOT NULL, url VARCHAR(300) NOT NULL, remarks LONGTEXT DEFAULT NULL, additional_location LONGTEXT DEFAULT NULL, created_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_32E0610EF5B7AF75 (address_id), UNIQUE INDEX UNIQ_32E0610E292E8AE2 (profile_picture_id), INDEX IDX_32E0610E41426E02 (shuttle_duration_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE shuttle_company_job_mapping (shuttle_company_id INT NOT NULL, job_id INT NOT NULL, INDEX IDX_C2FA562CB0335096 (shuttle_company_id), INDEX IDX_C2FA562CBE04EA9 (job_id), PRIMARY KEY(shuttle_company_id, job_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE shuttle_company_date_mapping (id INT AUTO_INCREMENT NOT NULL, shuttle_company_id INT DEFAULT NULL, shuttle_date_id INT DEFAULT NULL, shuttle_tour_id INT DEFAULT NULL, INDEX IDX_287894ABB0335096 (shuttle_company_id), INDEX IDX_287894ABC5C85E2A (shuttle_date_id), INDEX IDX_287894AB68B2E502 (shuttle_tour_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE shuttle_contact (id INT AUTO_INCREMENT NOT NULL, shuttle_company_id INT DEFAULT NULL, firstname VARCHAR(191) NOT NULL, lastname VARCHAR(191) NOT NULL, email VARCHAR(191) NOT NULL, phone VARCHAR(191) NOT NULL, position VARCHAR(191) NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_313D8E79B0335096 (shuttle_company_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE shuttle_date (id INT AUTO_INCREMENT NOT NULL, shuttle_date_state_id INT DEFAULT NULL, date DATETIME NOT NULL, INDEX IDX_7295A97D64EC54D5 (shuttle_date_state_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE shuttle_date_state (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(20) NOT NULL, description VARCHAR(50) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE shuttle_duration (id INT AUTO_INCREMENT NOT NULL, value VARCHAR(5) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE shuttle_school (id INT AUTO_INCREMENT NOT NULL, school_id INT DEFAULT NULL, number_of_allowed_bookings INT NOT NULL, UNIQUE INDEX UNIQ_A1682A34C32A47EE (school_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE shuttle_tour (id INT AUTO_INCREMENT NOT NULL, shuttle_date_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, position INT NOT NULL, INDEX IDX_B2DA676EC5C85E2A (shuttle_date_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE shuttle_tour_school_mapping (shuttle_tour_id INT NOT NULL, school_id INT NOT NULL, INDEX IDX_4A8788D968B2E502 (shuttle_tour_id), INDEX IDX_4A8788D9C32A47EE (school_id), PRIMARY KEY(shuttle_tour_id, school_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE slider_item (id INT AUTO_INCREMENT NOT NULL, media_id INT DEFAULT NULL, heading VARCHAR(100) NOT NULL, sub_heading VARCHAR(100) NOT NULL, destination VARCHAR(255) NOT NULL, target INT NOT NULL COMMENT \'1=self, 2=blank\', show_after_date DATETIME DEFAULT NULL, show_until_date DATETIME DEFAULT NULL, position SMALLINT NOT NULL, created_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_788595CEEA9FDD75 (media_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE switch_user_token (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, token VARCHAR(191) NOT NULL, used TINYINT(1) NOT NULL, created_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE tesis_picta_group (id INT AUTO_INCREMENT NOT NULL, group_name VARCHAR(100) NOT NULL, position INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE tesis_picta_group_sector_mapping (picta_group_id INT NOT NULL, job_sector_id INT NOT NULL, INDEX IDX_3EEC0E7BAB3D627A (picta_group_id), INDEX IDX_3EEC0E7B19252776 (job_sector_id), PRIMARY KEY(picta_group_id, job_sector_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE tirol_tv_video (id INT AUTO_INCREMENT NOT NULL, url VARCHAR(191) NOT NULL, video_title VARCHAR(191) NOT NULL, image_name VARCHAR(191) NOT NULL, position INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE title (id INT AUTO_INCREMENT NOT NULL, title_type_id INT DEFAULT NULL, description VARCHAR(191) NOT NULL, short_name VARCHAR(255) NOT NULL, INDEX IDX_2B36786B8730B5EA (title_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE title_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(32) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, username VARCHAR(191) NOT NULL, password VARCHAR(191) NOT NULL, email VARCHAR(191) NOT NULL, is_active TINYINT(1) NOT NULL, created_at DATETIME NOT NULL, last_login DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_8D93D649F85E0677 (username), UNIQUE INDEX UNIQ_8D93D649E7927C74 (email), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_role_mapping (user_id INT NOT NULL, user_role_id INT NOT NULL, INDEX IDX_75E7F573A76ED395 (user_id), INDEX IDX_75E7F5738E0E3CA6 (user_role_id), PRIMARY KEY(user_id, user_role_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_activation_link (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, code VARCHAR(30) NOT NULL, is_confirmed TINYINT(1) NOT NULL, created_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_A932897CA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_data (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, person_id INT DEFAULT NULL, address_id INT DEFAULT NULL, communication_id INT DEFAULT NULL, changed_at DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_D772BFAAA76ED395 (user_id), UNIQUE INDEX UNIQ_D772BFAA217BBB47 (person_id), UNIQUE INDEX UNIQ_D772BFAAF5B7AF75 (address_id), UNIQUE INDEX UNIQ_D772BFAA1C2D1E0C (communication_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_operator (id INT AUTO_INCREMENT NOT NULL, username VARCHAR(60) NOT NULL, email VARCHAR(60) NOT NULL, password VARCHAR(191) NOT NULL, is_active TINYINT(1) NOT NULL, pin INT DEFAULT NULL, created_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_372B4381F85E0677 (username), UNIQUE INDEX UNIQ_372B4381E7927C74 (email), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_operator_role_mapping (user_operator_id INT NOT NULL, user_operator_role_id INT NOT NULL, INDEX IDX_BAE3E398F15E5136 (user_operator_id), INDEX IDX_BAE3E3983653B812 (user_operator_role_id), PRIMARY KEY(user_operator_id, user_operator_role_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_operator_role (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, description VARCHAR(191) NOT NULL, can_create TINYINT(1) NOT NULL, can_delete TINYINT(1) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_operator_rookie_district_mapping (id INT AUTO_INCREMENT NOT NULL, user_operator_id INT DEFAULT NULL, rookie_district_id INT DEFAULT NULL, is_active TINYINT(1) NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_7F9AC30DF15E5136 (user_operator_id), INDEX IDX_7F9AC30D9111923A (rookie_district_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_password_change (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, code VARCHAR(64) NOT NULL, code_used TINYINT(1) NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_DF620397A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_role (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(45) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_setting (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, selected_user_role_id INT DEFAULT NULL, created_at DATETIME DEFAULT NULL, changed_at DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_C779A692A76ED395 (user_id), INDEX IDX_C779A6928AEC2E80 (selected_user_role_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE weekday (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(191) NOT NULL, position INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('ALTER TABLE address ADD CONSTRAINT FK_D4E6F819EA97B0B FOREIGN KEY (address_type_id) REFERENCES address_type (id)');
$this->addSql('ALTER TABLE address ADD CONSTRAINT FK_D4E6F81D0499537 FOREIGN KEY (address_city_id) REFERENCES address_city (id)');
$this->addSql('ALTER TABLE address_city ADD CONSTRAINT FK_5017D2DFA74081B9 FOREIGN KEY (address_district_id) REFERENCES address_district (id)');
$this->addSql('ALTER TABLE address_district ADD CONSTRAINT FK_CF4EAA06FB57C240 FOREIGN KEY (address_state_id) REFERENCES address_state (id)');
$this->addSql('ALTER TABLE address_lat_lon ADD CONSTRAINT FK_DFA98200F5B7AF75 FOREIGN KEY (address_id) REFERENCES address (id)');
$this->addSql('ALTER TABLE address_state ADD CONSTRAINT FK_9436A5DB81B2B6EE FOREIGN KEY (address_country_id) REFERENCES address_country (id)');
$this->addSql('ALTER TABLE appointment ADD CONSTRAINT FK_FE38F844546FBEBB FOREIGN KEY (appointment_type_id) REFERENCES appointment_type (id)');
$this->addSql('ALTER TABLE appointment ADD CONSTRAINT FK_FE38F84430FCB709 FOREIGN KEY (appointment_state_id) REFERENCES appointment_state (id)');
$this->addSql('ALTER TABLE appointment ADD CONSTRAINT FK_FE38F84471F7E88B FOREIGN KEY (event_id) REFERENCES event (id)');
$this->addSql('ALTER TABLE appointment_agreement_entry ADD CONSTRAINT FK_99D39DD48516439 FOREIGN KEY (weekday_id) REFERENCES weekday (id)');
$this->addSql('ALTER TABLE appointment_agreement_entry ADD CONSTRAINT FK_99D39DDE5B533F9 FOREIGN KEY (appointment_id) REFERENCES appointment (id)');
$this->addSql('ALTER TABLE appointment_individual_mapping ADD CONSTRAINT FK_78359B99E5B533F9 FOREIGN KEY (appointment_id) REFERENCES appointment (id)');
$this->addSql('ALTER TABLE appointment_individual_mapping ADD CONSTRAINT FK_78359B99E7A1254A FOREIGN KEY (contact_id) REFERENCES contact (id)');
$this->addSql('ALTER TABLE appointment_individual_mapping ADD CONSTRAINT FK_78359B9916F2520F FOREIGN KEY (profile_type_id) REFERENCES profile_type (id)');
$this->addSql('ALTER TABLE bo_plan ADD CONSTRAINT FK_3EBAE34614463F54 FOREIGN KEY (school_class_id) REFERENCES school_class (id)');
$this->addSql('ALTER TABLE bo_plan ADD CONSTRAINT FK_3EBAE346E3EB8173 FOREIGN KEY (boplan_state_id) REFERENCES bo_plan_state (id)');
$this->addSql('ALTER TABLE bo_plan_subject ADD CONSTRAINT FK_F77C9E13A2FE0107 FOREIGN KEY (bo_plan_subject_category_id) REFERENCES bo_plan_subject_category (id)');
$this->addSql('ALTER TABLE bo_plan_subject_category ADD CONSTRAINT FK_A49417288B9A65FF FOREIGN KEY (school_class_grade_id) REFERENCES school_class_grade (id)');
$this->addSql('ALTER TABLE bo_plan_week ADD CONSTRAINT FK_9C0A3A5F4CB1CEC1 FOREIGN KEY (bo_plan_id) REFERENCES bo_plan (id)');
$this->addSql('ALTER TABLE bo_plan_week ADD CONSTRAINT FK_9C0A3A5F5C2A31C5 FOREIGN KEY (bo_plan_week_state_id) REFERENCES bo_plan_week_state (id)');
$this->addSql('ALTER TABLE bo_plan_week ADD CONSTRAINT FK_9C0A3A5F71F7E88B FOREIGN KEY (event_id) REFERENCES event (id)');
$this->addSql('ALTER TABLE bo_plan_week ADD CONSTRAINT FK_9C0A3A5FCE50426D FOREIGN KEY (bo_plan_subject_id) REFERENCES bo_plan_subject (id)');
$this->addSql('ALTER TABLE bo_plan_week ADD CONSTRAINT FK_9C0A3A5FB83EE2E8 FOREIGN KEY (bo_plan_subject_custom_id) REFERENCES bo_plan_subject_custom (id)');
$this->addSql('ALTER TABLE bo_plan_week ADD CONSTRAINT FK_9C0A3A5FB79F5C75 FOREIGN KEY (school_subject_id) REFERENCES school_subject (id)');
$this->addSql('ALTER TABLE bo_plan_week ADD CONSTRAINT FK_9C0A3A5F5FBBB4F2 FOREIGN KEY (bo_plan_activity_type_id) REFERENCES bo_plan_activity_type (id)');
$this->addSql('ALTER TABLE bo_plan_week ADD CONSTRAINT FK_9C0A3A5F8863C3A6 FOREIGN KEY (teacher_delete_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE bo_plan_week ADD CONSTRAINT FK_9C0A3A5F94759198 FOREIGN KEY (teacher_create_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE bo_plan_week ADD CONSTRAINT FK_9C0A3A5F650F5579 FOREIGN KEY (teacher_done_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE bo_plan_week ADD CONSTRAINT FK_9C0A3A5FA563B7E2 FOREIGN KEY (bo_plan_reference_id) REFERENCES bo_plan_reference (id)');
$this->addSql('ALTER TABLE bo_plan_week_changes ADD CONSTRAINT FK_6110AB411A8F78AC FOREIGN KEY (week_plan_id) REFERENCES bo_plan_week (id)');
$this->addSql('ALTER TABLE bo_plan_week_changes ADD CONSTRAINT FK_6110AB415B57C7EF FOREIGN KEY (teacher_change_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE booking ADD CONSTRAINT FK_E00CEDDE3EECA24C FOREIGN KEY (booking_state_id) REFERENCES booking_state (id)');
$this->addSql('ALTER TABLE booking ADD CONSTRAINT FK_E00CEDDEA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE booking ADD CONSTRAINT FK_E00CEDDEE5B533F9 FOREIGN KEY (appointment_id) REFERENCES appointment (id)');
$this->addSql('ALTER TABLE booking ADD CONSTRAINT FK_E00CEDDE14463F54 FOREIGN KEY (school_class_id) REFERENCES school_class (id)');
$this->addSql('ALTER TABLE booking_additional_information ADD CONSTRAINT FK_DFBF83AA3301C60 FOREIGN KEY (booking_id) REFERENCES booking (id)');
$this->addSql('ALTER TABLE booking_additional_information ADD CONSTRAINT FK_DFBF83AAD34E2FED FOREIGN KEY (booking_additional_information_type_id) REFERENCES booking_additional_information_type (id)');
$this->addSql('ALTER TABLE booking_proposal ADD CONSTRAINT FK_84D10AFFA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE booking_proposal ADD CONSTRAINT FK_84D10AFF6C066AFE FOREIGN KEY (target_user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE booking_proposal ADD CONSTRAINT FK_84D10AFF7B02371D FOREIGN KEY (booking_proposal_state_id) REFERENCES booking_proposal_state (id)');
$this->addSql('ALTER TABLE booking_proposal ADD CONSTRAINT FK_84D10AFF3301C60 FOREIGN KEY (booking_id) REFERENCES booking (id)');
$this->addSql('ALTER TABLE booking_school_custom_special_field_mapping ADD CONSTRAINT FK_FF1C22943301C60 FOREIGN KEY (booking_id) REFERENCES booking (id)');
$this->addSql('ALTER TABLE booking_school_custom_special_field_mapping ADD CONSTRAINT FK_FF1C2294ABC709B9 FOREIGN KEY (school_custom_special_field_id) REFERENCES school_custom_special_field (id)');
$this->addSql('ALTER TABLE bookmark ADD CONSTRAINT FK_DA62921DA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE bookmark ADD CONSTRAINT FK_DA62921DA894E7A8 FOREIGN KEY (bookmark_type_id) REFERENCES bookmark_type (id)');
$this->addSql('ALTER TABLE bopartner_contact ADD CONSTRAINT FK_85C65A0B217BBB47 FOREIGN KEY (person_id) REFERENCES person (id)');
$this->addSql('ALTER TABLE bopartner_contact ADD CONSTRAINT FK_85C65A0B1C2D1E0C FOREIGN KEY (communication_id) REFERENCES communication (id)');
$this->addSql('ALTER TABLE bopartner_contact ADD CONSTRAINT FK_85C65A0B292E8AE2 FOREIGN KEY (profile_picture_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE bopartner_contact ADD CONSTRAINT FK_85C65A0B731CCFFD FOREIGN KEY (bopartner_profile_id) REFERENCES bopartner_profile (id)');
$this->addSql('ALTER TABLE bopartner_location ADD CONSTRAINT FK_E1874C61F5B7AF75 FOREIGN KEY (address_id) REFERENCES address (id)');
$this->addSql('ALTER TABLE bopartner_location ADD CONSTRAINT FK_E1874C61731CCFFD FOREIGN KEY (bopartner_profile_id) REFERENCES bopartner_profile (id)');
$this->addSql('ALTER TABLE bopartner_profile ADD CONSTRAINT FK_48F3163C1C2D1E0C FOREIGN KEY (communication_id) REFERENCES communication (id)');
$this->addSql('ALTER TABLE bopartner_profile ADD CONSTRAINT FK_48F3163C4E7AF8F FOREIGN KEY (gallery_id) REFERENCES media__gallery (id)');
$this->addSql('ALTER TABLE bopartner_profile ADD CONSTRAINT FK_48F3163C8440B739 FOREIGN KEY (video_gallery_id) REFERENCES media__gallery (id)');
$this->addSql('ALTER TABLE bopartner_profile ADD CONSTRAINT FK_48F3163CA52404D9 FOREIGN KEY (document_gallery_id) REFERENCES media__gallery (id)');
$this->addSql('ALTER TABLE bopartner_profile ADD CONSTRAINT FK_48F3163CC35EF618 FOREIGN KEY (contact_gallery_id) REFERENCES contact_gallery (id)');
$this->addSql('ALTER TABLE bopartner_profile ADD CONSTRAINT FK_48F3163C292E8AE2 FOREIGN KEY (profile_picture_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE bopartner_profile_search_tag_mapping ADD CONSTRAINT FK_8567513E731CCFFD FOREIGN KEY (bopartner_profile_id) REFERENCES bopartner_profile (id)');
$this->addSql('ALTER TABLE bopartner_profile_search_tag_mapping ADD CONSTRAINT FK_8567513E63300C0E FOREIGN KEY (search_tag_id) REFERENCES search_tag (id)');
$this->addSql('ALTER TABLE bopartner_profile_event_mapping ADD CONSTRAINT FK_A9B8ADDB71F7E88B FOREIGN KEY (event_id) REFERENCES event (id)');
$this->addSql('ALTER TABLE bopartner_profile_event_mapping ADD CONSTRAINT FK_A9B8ADDB731CCFFD FOREIGN KEY (bopartner_profile_id) REFERENCES bopartner_profile (id)');
$this->addSql('ALTER TABLE bopartner_profile_mapping ADD CONSTRAINT FK_10475A0E731CCFFD FOREIGN KEY (bopartner_profile_id) REFERENCES bopartner_profile (id)');
$this->addSql('ALTER TABLE bopartner_profile_mapping ADD CONSTRAINT FK_10475A0EA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE bopartner_profile_name_request ADD CONSTRAINT FK_8A0DF279A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE bopartner_profile_name_request ADD CONSTRAINT FK_8A0DF279731CCFFD FOREIGN KEY (bopartner_profile_id) REFERENCES bopartner_profile (id)');
$this->addSql('ALTER TABLE communication_entry ADD CONSTRAINT FK_AAA05CC51C2D1E0C FOREIGN KEY (communication_id) REFERENCES communication (id)');
$this->addSql('ALTER TABLE communication_entry ADD CONSTRAINT FK_AAA05CC5B09DA5C9 FOREIGN KEY (communication_type_id) REFERENCES communication_type (id)');
$this->addSql('ALTER TABLE company_contact ADD CONSTRAINT FK_6C30FCEF217BBB47 FOREIGN KEY (person_id) REFERENCES person (id)');
$this->addSql('ALTER TABLE company_contact ADD CONSTRAINT FK_6C30FCEF1C2D1E0C FOREIGN KEY (communication_id) REFERENCES communication (id)');
$this->addSql('ALTER TABLE company_contact ADD CONSTRAINT FK_6C30FCEF292E8AE2 FOREIGN KEY (profile_picture_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE company_contact ADD CONSTRAINT FK_6C30FCEF7174FB2E FOREIGN KEY (company_profile_id) REFERENCES company_profile (id)');
$this->addSql('ALTER TABLE company_location ADD CONSTRAINT FK_46099CA6F5B7AF75 FOREIGN KEY (address_id) REFERENCES address (id)');
$this->addSql('ALTER TABLE company_location ADD CONSTRAINT FK_46099CA67174FB2E FOREIGN KEY (company_profile_id) REFERENCES company_profile (id)');
$this->addSql('ALTER TABLE company_profile ADD CONSTRAINT FK_A105B0D81C2D1E0C FOREIGN KEY (communication_id) REFERENCES communication (id)');
$this->addSql('ALTER TABLE company_profile ADD CONSTRAINT FK_A105B0D84E7AF8F FOREIGN KEY (gallery_id) REFERENCES media__gallery (id)');
$this->addSql('ALTER TABLE company_profile ADD CONSTRAINT FK_A105B0D88440B739 FOREIGN KEY (video_gallery_id) REFERENCES media__gallery (id)');
$this->addSql('ALTER TABLE company_profile ADD CONSTRAINT FK_A105B0D8A52404D9 FOREIGN KEY (document_gallery_id) REFERENCES media__gallery (id)');
$this->addSql('ALTER TABLE company_profile ADD CONSTRAINT FK_A105B0D8C35EF618 FOREIGN KEY (contact_gallery_id) REFERENCES contact_gallery (id)');
$this->addSql('ALTER TABLE company_profile ADD CONSTRAINT FK_A105B0D869DFB2F0 FOREIGN KEY (company_size_id) REFERENCES company_size (id)');
$this->addSql('ALTER TABLE company_profile ADD CONSTRAINT FK_A105B0D8292E8AE2 FOREIGN KEY (profile_picture_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE company_profile_certificate_mapping ADD CONSTRAINT FK_1B89EDF07174FB2E FOREIGN KEY (company_profile_id) REFERENCES company_profile (id)');
$this->addSql('ALTER TABLE company_profile_certificate_mapping ADD CONSTRAINT FK_1B89EDF0B7EA105E FOREIGN KEY (company_certificate_id) REFERENCES company_certificate (id)');
$this->addSql('ALTER TABLE company_profile_job_mapping ADD CONSTRAINT FK_9D7949957174FB2E FOREIGN KEY (company_profile_id) REFERENCES company_profile (id)');
$this->addSql('ALTER TABLE company_profile_job_mapping ADD CONSTRAINT FK_9D794995BE04EA9 FOREIGN KEY (job_id) REFERENCES job (id)');
$this->addSql('ALTER TABLE company_profile_sector_mapping ADD CONSTRAINT FK_E65CDA1E7174FB2E FOREIGN KEY (company_profile_id) REFERENCES company_profile (id)');
$this->addSql('ALTER TABLE company_profile_sector_mapping ADD CONSTRAINT FK_E65CDA1EDE95C867 FOREIGN KEY (sector_id) REFERENCES job_sector (id)');
$this->addSql('ALTER TABLE company_profile_benefit_mapping ADD CONSTRAINT FK_43CCFDF27174FB2E FOREIGN KEY (company_profile_id) REFERENCES company_profile (id)');
$this->addSql('ALTER TABLE company_profile_benefit_mapping ADD CONSTRAINT FK_43CCFDF2B6DF921F FOREIGN KEY (company_benefit_id) REFERENCES company_benefit (id)');
$this->addSql('ALTER TABLE company_profile_search_tag_mapping ADD CONSTRAINT FK_A10820BA7174FB2E FOREIGN KEY (company_profile_id) REFERENCES company_profile (id)');
$this->addSql('ALTER TABLE company_profile_search_tag_mapping ADD CONSTRAINT FK_A10820BA63300C0E FOREIGN KEY (search_tag_id) REFERENCES search_tag (id)');
$this->addSql('ALTER TABLE company_profile_event_mapping ADD CONSTRAINT FK_FB8325E271F7E88B FOREIGN KEY (event_id) REFERENCES event (id)');
$this->addSql('ALTER TABLE company_profile_event_mapping ADD CONSTRAINT FK_FB8325E27174FB2E FOREIGN KEY (company_profile_id) REFERENCES company_profile (id)');
$this->addSql('ALTER TABLE company_profile_mapping ADD CONSTRAINT FK_D5A9C86B7174FB2E FOREIGN KEY (company_profile_id) REFERENCES company_profile (id)');
$this->addSql('ALTER TABLE company_profile_mapping ADD CONSTRAINT FK_D5A9C86BA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE company_profile_name_request ADD CONSTRAINT FK_D967FDCAA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE company_profile_name_request ADD CONSTRAINT FK_D967FDCA7174FB2E FOREIGN KEY (company_profile_id) REFERENCES company_profile (id)');
$this->addSql('ALTER TABLE contact ADD CONSTRAINT FK_4C62E638217BBB47 FOREIGN KEY (person_id) REFERENCES person (id)');
$this->addSql('ALTER TABLE contact ADD CONSTRAINT FK_4C62E6381C2D1E0C FOREIGN KEY (communication_id) REFERENCES communication (id)');
$this->addSql('ALTER TABLE contact ADD CONSTRAINT FK_4C62E638292E8AE2 FOREIGN KEY (profile_picture_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE contact ADD CONSTRAINT FK_4C62E63816F2520F FOREIGN KEY (profile_type_id) REFERENCES profile_type (id)');
$this->addSql('ALTER TABLE contact_gallery_entry ADD CONSTRAINT FK_EE240ED4C35EF618 FOREIGN KEY (contact_gallery_id) REFERENCES contact_gallery (id)');
$this->addSql('ALTER TABLE contact_gallery_entry ADD CONSTRAINT FK_EE240ED4E7A1254A FOREIGN KEY (contact_id) REFERENCES contact (id)');
$this->addSql('ALTER TABLE custom_variable ADD CONSTRAINT FK_299F60E986CCF6A2 FOREIGN KEY (custom_variable_type_id) REFERENCES custom_variable_type (id)');
$this->addSql('ALTER TABLE event ADD CONSTRAINT FK_3BAE0AA7F5B7AF75 FOREIGN KEY (address_id) REFERENCES address (id)');
$this->addSql('ALTER TABLE event ADD CONSTRAINT FK_3BAE0AA74E7AF8F FOREIGN KEY (gallery_id) REFERENCES media__gallery (id)');
$this->addSql('ALTER TABLE event ADD CONSTRAINT FK_3BAE0AA78440B739 FOREIGN KEY (video_gallery_id) REFERENCES media__gallery (id)');
$this->addSql('ALTER TABLE event ADD CONSTRAINT FK_3BAE0AA7A52404D9 FOREIGN KEY (document_gallery_id) REFERENCES media__gallery (id)');
$this->addSql('ALTER TABLE event ADD CONSTRAINT FK_3BAE0AA72D0254C5 FOREIGN KEY (followup_document_gallery_id) REFERENCES media__gallery (id)');
$this->addSql('ALTER TABLE event ADD CONSTRAINT FK_3BAE0AA7A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE event ADD CONSTRAINT FK_3BAE0AA7EA9FDD75 FOREIGN KEY (media_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE event ADD CONSTRAINT FK_3BAE0AA716F2520F FOREIGN KEY (profile_type_id) REFERENCES profile_type (id)');
$this->addSql('ALTER TABLE event ADD CONSTRAINT FK_3BAE0AA74334D511 FOREIGN KEY (event_state_id) REFERENCES event_state (id)');
$this->addSql('ALTER TABLE event_job_mapping ADD CONSTRAINT FK_7880489171F7E88B FOREIGN KEY (event_id) REFERENCES event (id)');
$this->addSql('ALTER TABLE event_job_mapping ADD CONSTRAINT FK_78804891BE04EA9 FOREIGN KEY (job_id) REFERENCES job (id)');
$this->addSql('ALTER TABLE event_search_tag_mapping ADD CONSTRAINT FK_3A9E542A71F7E88B FOREIGN KEY (event_id) REFERENCES event (id)');
$this->addSql('ALTER TABLE event_search_tag_mapping ADD CONSTRAINT FK_3A9E542A63300C0E FOREIGN KEY (search_tag_id) REFERENCES search_tag (id)');
$this->addSql('ALTER TABLE event_feedback ADD CONSTRAINT FK_94C5AD8871F7E88B FOREIGN KEY (event_id) REFERENCES event (id)');
$this->addSql('ALTER TABLE event_feedback_answer ADD CONSTRAINT FK_2E421A5B102710FE FOREIGN KEY (event_feedback_user_id) REFERENCES event_feedback_user (id)');
$this->addSql('ALTER TABLE event_feedback_answer ADD CONSTRAINT FK_2E421A5B15577CC7 FOREIGN KEY (event_feedback_question_id) REFERENCES event_feedback_question (id)');
$this->addSql('ALTER TABLE event_feedback_question ADD CONSTRAINT FK_6C20B85D79C07B07 FOREIGN KEY (event_feedback_id) REFERENCES event_feedback (id)');
$this->addSql('ALTER TABLE event_feedback_user ADD CONSTRAINT FK_6C68876CA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE event_feedback_user ADD CONSTRAINT FK_6C68876C79C07B07 FOREIGN KEY (event_feedback_id) REFERENCES event_feedback (id)');
$this->addSql('ALTER TABLE event_preparation ADD CONSTRAINT FK_5279797471F7E88B FOREIGN KEY (event_id) REFERENCES event (id)');
$this->addSql('ALTER TABLE event_preparation_answer ADD CONSTRAINT FK_82224000EC32F8D8 FOREIGN KEY (event_preparation_user_id) REFERENCES event_preparation_user (id)');
$this->addSql('ALTER TABLE event_preparation_answer ADD CONSTRAINT FK_82224000B441551E FOREIGN KEY (event_preparation_question_id) REFERENCES event_preparation_question (id)');
$this->addSql('ALTER TABLE event_preparation_question ADD CONSTRAINT FK_BED12848E29D0EC9 FOREIGN KEY (event_preparation_id) REFERENCES event_preparation (id)');
$this->addSql('ALTER TABLE event_preparation_user ADD CONSTRAINT FK_197E6342A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE event_preparation_user ADD CONSTRAINT FK_197E6342E29D0EC9 FOREIGN KEY (event_preparation_id) REFERENCES event_preparation (id)');
$this->addSql('ALTER TABLE event_tag ADD CONSTRAINT FK_12467250C75C8332 FOREIGN KEY (event_tag_category_id) REFERENCES event_tag_category (id)');
$this->addSql('ALTER TABLE event_tag_mapping ADD CONSTRAINT FK_D05ED2A0884B1443 FOREIGN KEY (event_tag_id) REFERENCES event_tag (id)');
$this->addSql('ALTER TABLE event_tag_mapping ADD CONSTRAINT FK_D05ED2A071F7E88B FOREIGN KEY (event_id) REFERENCES event (id)');
$this->addSql('ALTER TABLE faq_question ADD CONSTRAINT FK_4A55B0595D8DA562 FOREIGN KEY (faq_subcategory_id) REFERENCES faq_subcategory (id)');
$this->addSql('ALTER TABLE faq_subcategory ADD CONSTRAINT FK_E9138971F689B0DB FOREIGN KEY (faq_category_id) REFERENCES faq_category (id)');
$this->addSql('ALTER TABLE game_jeopardy_question_school_class_mapping ADD CONSTRAINT FK_5F8D948584104B01 FOREIGN KEY (game_jeopardy_school_class_id) REFERENCES game_jeopardy_school_class (id)');
$this->addSql('ALTER TABLE game_jeopardy_question_school_class_mapping ADD CONSTRAINT FK_5F8D9485E1F9AB61 FOREIGN KEY (game_jeopardy_question_id) REFERENCES game_jeopardy_question (id)');
$this->addSql('ALTER TABLE game_jeopardy_school_class ADD CONSTRAINT FK_52258E0B14463F54 FOREIGN KEY (school_class_id) REFERENCES school_class (id)');
$this->addSql('ALTER TABLE game_memory_school_class ADD CONSTRAINT FK_2424E3BD14463F54 FOREIGN KEY (school_class_id) REFERENCES school_class (id)');
$this->addSql('ALTER TABLE game_memory_school_class_job_mapping ADD CONSTRAINT FK_4089C446BE04EA9 FOREIGN KEY (job_id) REFERENCES job (id)');
$this->addSql('ALTER TABLE game_memory_school_class_job_mapping ADD CONSTRAINT FK_4089C446E297ECA9 FOREIGN KEY (game_memory_school_class_id) REFERENCES game_memory_school_class (id)');
$this->addSql('ALTER TABLE game_quiz_question ADD CONSTRAINT FK_CAD72C60BE04EA9 FOREIGN KEY (job_id) REFERENCES job (id)');
$this->addSql('ALTER TABLE game_quiz_question ADD CONSTRAINT FK_CAD72C60795B924A FOREIGN KEY (school_profile_id) REFERENCES school_profile (id)');
$this->addSql('ALTER TABLE game_quiz_question ADD CONSTRAINT FK_CAD72C60780B43E2 FOREIGN KEY (game_quiz_question_category_id) REFERENCES game_quiz_question_category (id)');
$this->addSql('ALTER TABLE game_quiz_question_profile_mapping ADD CONSTRAINT FK_F5FF532216F2520F FOREIGN KEY (profile_type_id) REFERENCES profile_type (id)');
$this->addSql('ALTER TABLE game_quiz_question_profile_mapping ADD CONSTRAINT FK_F5FF5322F102203 FOREIGN KEY (game_quiz_question_id) REFERENCES game_quiz_question (id)');
$this->addSql('ALTER TABLE game_quiz_question_school_class_mapping ADD CONSTRAINT FK_3FA5BBE333D5D35C FOREIGN KEY (game_quiz_school_class_id) REFERENCES game_quiz_school_class (id)');
$this->addSql('ALTER TABLE game_quiz_question_school_class_mapping ADD CONSTRAINT FK_3FA5BBE3F102203 FOREIGN KEY (game_quiz_question_id) REFERENCES game_quiz_question (id)');
$this->addSql('ALTER TABLE game_quiz_school_class ADD CONSTRAINT FK_F17767F614463F54 FOREIGN KEY (school_class_id) REFERENCES school_class (id)');
$this->addSql('ALTER TABLE game_quiz_school_class ADD CONSTRAINT FK_F17767F6780B43E2 FOREIGN KEY (game_quiz_question_category_id) REFERENCES game_quiz_question_category (id)');
$this->addSql('ALTER TABLE game_quiz_school_class ADD CONSTRAINT FK_F17767F6D27F8922 FOREIGN KEY (job_daily_routine_id) REFERENCES job_daily_routine (id)');
$this->addSql('ALTER TABLE info_section_category ADD CONSTRAINT FK_BF12A6B3170B419C FOREIGN KEY (section_type_id) REFERENCES info_section_type (id)');
$this->addSql('ALTER TABLE info_section_category ADD CONSTRAINT FK_BF12A6B3C85BEDC1 FOREIGN KEY (category_picture_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE info_section_entry ADD CONSTRAINT FK_F4E911886076769F FOREIGN KEY (section_subcategory_id) REFERENCES info_section_subcategory (id)');
$this->addSql('ALTER TABLE info_section_entry ADD CONSTRAINT FK_F4E9118876EFF48D FOREIGN KEY (entry_picture_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE info_section_subcategory ADD CONSTRAINT FK_B527D64BAABDEFE1 FOREIGN KEY (info_section_category_id) REFERENCES info_section_category (id)');
$this->addSql('ALTER TABLE job ADD CONSTRAINT FK_FBD8E0F85AE28016 FOREIGN KEY (job_image_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE job ADD CONSTRAINT FK_FBD8E0F81EF359A0 FOREIGN KEY (job_teaser_image_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE job ADD CONSTRAINT FK_FBD8E0F86E903F92 FOREIGN KEY (job_gallery_id) REFERENCES media__gallery (id)');
$this->addSql('ALTER TABLE job_sector_mapping ADD CONSTRAINT FK_7112EF68BE04EA9 FOREIGN KEY (job_id) REFERENCES job (id)');
$this->addSql('ALTER TABLE job_sector_mapping ADD CONSTRAINT FK_7112EF68DE95C867 FOREIGN KEY (sector_id) REFERENCES job_sector (id)');
$this->addSql('ALTER TABLE job_educational_path_mapping ADD CONSTRAINT FK_E5B4189CBE04EA9 FOREIGN KEY (job_id) REFERENCES job (id)');
$this->addSql('ALTER TABLE job_educational_path_mapping ADD CONSTRAINT FK_E5B4189C8421405E FOREIGN KEY (job_educational_path_id) REFERENCES job_educational_path (id)');
$this->addSql('ALTER TABLE job_workfield_mapping ADD CONSTRAINT FK_FBEDF99CBE04EA9 FOREIGN KEY (job_id) REFERENCES job (id)');
$this->addSql('ALTER TABLE job_workfield_mapping ADD CONSTRAINT FK_FBEDF99CEAD7CBC0 FOREIGN KEY (job_workfield_id) REFERENCES job_workfield (id)');
$this->addSql('ALTER TABLE job_search_tag_mapping ADD CONSTRAINT FK_CD6D9CEDBE04EA9 FOREIGN KEY (job_id) REFERENCES job (id)');
$this->addSql('ALTER TABLE job_search_tag_mapping ADD CONSTRAINT FK_CD6D9CED63300C0E FOREIGN KEY (search_tag_id) REFERENCES search_tag (id)');
$this->addSql('ALTER TABLE job_ams ADD CONSTRAINT FK_6BDEDEF8BE04EA9 FOREIGN KEY (job_id) REFERENCES job (id)');
$this->addSql('ALTER TABLE job_daily_routine ADD CONSTRAINT FK_3FC957EEEA9FDD75 FOREIGN KEY (media_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE job_daily_routine ADD CONSTRAINT FK_3FC957EE21212CC7 FOREIGN KEY (media_2_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE job_daily_routine ADD CONSTRAINT FK_3FC957EEC9F81D25 FOREIGN KEY (job_daily_routine_category_id) REFERENCES job_daily_routine_category (id)');
$this->addSql('ALTER TABLE job_daily_routine ADD CONSTRAINT FK_3FC957EE795B924A FOREIGN KEY (school_profile_id) REFERENCES school_profile (id)');
$this->addSql('ALTER TABLE job_daily_routine ADD CONSTRAINT FK_3FC957EEBE04EA9 FOREIGN KEY (job_id) REFERENCES job (id)');
$this->addSql('ALTER TABLE job_daily_routine_entry ADD CONSTRAINT FK_23161BE4D27F8922 FOREIGN KEY (job_daily_routine_id) REFERENCES job_daily_routine (id)');
$this->addSql('ALTER TABLE job_daily_routine_entry ADD CONSTRAINT FK_23161BE474552888 FOREIGN KEY (media_top_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE job_daily_routine_entry ADD CONSTRAINT FK_23161BE45BF64687 FOREIGN KEY (media_right_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE job_daily_routine_entry ADD CONSTRAINT FK_23161BE47B8DD49A FOREIGN KEY (media_bottom_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE job_daily_routine_entry ADD CONSTRAINT FK_23161BE4E460732B FOREIGN KEY (media_picture_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE job_link_mapping ADD CONSTRAINT FK_3BE3E350BE04EA9 FOREIGN KEY (job_id) REFERENCES job (id)');
$this->addSql('ALTER TABLE job_link_mapping ADD CONSTRAINT FK_3BE3E350374BB5EA FOREIGN KEY (job_link_id) REFERENCES job_link (id)');
$this->addSql('ALTER TABLE job_link_mapping ADD CONSTRAINT FK_3BE3E350BEE658CB FOREIGN KEY (job_link_mapping_category_id) REFERENCES job_link_mapping_category (id)');
$this->addSql('ALTER TABLE job_link_mapping ADD CONSTRAINT FK_3BE3E350904BC219 FOREIGN KEY (job_link_mapping_type_id) REFERENCES job_link_mapping_type (id)');
$this->addSql('ALTER TABLE job_market ADD CONSTRAINT FK_3BA8A84AF5B7AF75 FOREIGN KEY (address_id) REFERENCES address (id)');
$this->addSql('ALTER TABLE job_market ADD CONSTRAINT FK_3BA8A84AEA9FDD75 FOREIGN KEY (media_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE job_market ADD CONSTRAINT FK_3BA8A84A71672B6D FOREIGN KEY (custom_advertisment_media_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE job_market ADD CONSTRAINT FK_3BA8A84AE7A1254A FOREIGN KEY (contact_id) REFERENCES contact (id)');
$this->addSql('ALTER TABLE job_market ADD CONSTRAINT FK_3BA8A84A5A2FCCDC FOREIGN KEY (company_contact_id) REFERENCES company_contact (id)');
$this->addSql('ALTER TABLE job_market ADD CONSTRAINT FK_3BA8A84A45E22644 FOREIGN KEY (job_market_position_type_id) REFERENCES job_market_position_type (id)');
$this->addSql('ALTER TABLE job_market ADD CONSTRAINT FK_3BA8A84A45FC6BDC FOREIGN KEY (job_market_apply_type_id) REFERENCES job_market_apply_type (id)');
$this->addSql('ALTER TABLE job_market ADD CONSTRAINT FK_3BA8A84A35F10E35 FOREIGN KEY (job_market_start_type_id) REFERENCES job_market_start_type (id)');
$this->addSql('ALTER TABLE job_market ADD CONSTRAINT FK_3BA8A84A7174FB2E FOREIGN KEY (company_profile_id) REFERENCES company_profile (id)');
$this->addSql('ALTER TABLE job_market ADD CONSTRAINT FK_3BA8A84AA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE job_market ADD CONSTRAINT FK_3BA8A84A3F56666 FOREIGN KEY (job_market_state_id) REFERENCES job_market_state (id)');
$this->addSql('ALTER TABLE job_market_job_mapping ADD CONSTRAINT FK_AB53959A59FD026 FOREIGN KEY (job_market_id) REFERENCES job_market (id)');
$this->addSql('ALTER TABLE job_market_job_mapping ADD CONSTRAINT FK_AB53959BE04EA9 FOREIGN KEY (job_id) REFERENCES job (id)');
$this->addSql('ALTER TABLE job_school ADD CONSTRAINT FK_A99AF73AC32A47EE FOREIGN KEY (school_id) REFERENCES school (id)');
$this->addSql('ALTER TABLE job_school ADD CONSTRAINT FK_A99AF73ABE04EA9 FOREIGN KEY (job_id) REFERENCES job (id)');
$this->addSql('ALTER TABLE job_sector ADD CONSTRAINT FK_1BA7F46998051D95 FOREIGN KEY (sector_image_id) REFERENCES job_sector_image (id)');
$this->addSql('ALTER TABLE job_sector_image ADD CONSTRAINT FK_1D852DE1820AEF50 FOREIGN KEY (file_path_id) REFERENCES file_path (id)');
$this->addSql('ALTER TABLE job_workfield ADD CONSTRAINT FK_38A36B6AC9C39BE9 FOREIGN KEY (job_workfield_image_id) REFERENCES job_workfield_image (id)');
$this->addSql('ALTER TABLE job_workfield_image ADD CONSTRAINT FK_7D2E8060EAD7CBC0 FOREIGN KEY (job_workfield_id) REFERENCES job_workfield (id)');
$this->addSql('ALTER TABLE job_workfield_image ADD CONSTRAINT FK_7D2E8060820AEF50 FOREIGN KEY (file_path_id) REFERENCES file_path (id)');
$this->addSql('ALTER TABLE media__gallery ADD CONSTRAINT FK_3C02B7F53F01A74C FOREIGN KEY (media_gallery_category_id) REFERENCES media_gallery_category (id)');
$this->addSql('ALTER TABLE media__gallery_media ADD CONSTRAINT FK_80D4C5414E7AF8F FOREIGN KEY (gallery_id) REFERENCES media__gallery (id)');
$this->addSql('ALTER TABLE media__gallery_media ADD CONSTRAINT FK_80D4C541EA9FDD75 FOREIGN KEY (media_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE misc_file ADD CONSTRAINT FK_C0F9CF99820AEF50 FOREIGN KEY (file_path_id) REFERENCES file_path (id)');
$this->addSql('ALTER TABLE news ADD CONSTRAINT FK_1DD399502A98155E FOREIGN KEY (sender_user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE news ADD CONSTRAINT FK_1DD39950DA57E237 FOREIGN KEY (receiver_user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE news ADD CONSTRAINT FK_1DD3995092A89075 FOREIGN KEY (news_type_id) REFERENCES news_type (id)');
$this->addSql('ALTER TABLE news ADD CONSTRAINT FK_1DD39950BF05C450 FOREIGN KEY (news_message_id) REFERENCES news_message (id)');
$this->addSql('ALTER TABLE news_reminder ADD CONSTRAINT FK_909EC11A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE person_title_mapping ADD CONSTRAINT FK_314263E217BBB47 FOREIGN KEY (person_id) REFERENCES person (id)');
$this->addSql('ALTER TABLE person_title_mapping ADD CONSTRAINT FK_314263EA9F87BD FOREIGN KEY (title_id) REFERENCES title (id)');
$this->addSql('ALTER TABLE rookie_address ADD CONSTRAINT FK_FD285985D0499537 FOREIGN KEY (address_city_id) REFERENCES address_city (id)');
$this->addSql('ALTER TABLE rookie_booking ADD CONSTRAINT FK_106ADBDAA4F20E15 FOREIGN KEY (rookie_offer_time_slot_mapping_id) REFERENCES rookie_offer_time_slot_mapping (id)');
$this->addSql('ALTER TABLE rookie_booking ADD CONSTRAINT FK_106ADBDA8AAD1BBC FOREIGN KEY (rookie_person_id) REFERENCES rookie_person (id)');
$this->addSql('ALTER TABLE rookie_booking ADD CONSTRAINT FK_106ADBDA9111923A FOREIGN KEY (rookie_district_id) REFERENCES rookie_district (id)');
$this->addSql('ALTER TABLE rookie_booking ADD CONSTRAINT FK_106ADBDACD261DDC FOREIGN KEY (rookie_school_class_id) REFERENCES rookie_school_class (id)');
$this->addSql('ALTER TABLE rookie_contact ADD CONSTRAINT FK_BC04D03C86038F9A FOREIGN KEY (rookie_contact_type_id) REFERENCES rookie_contact_type (id)');
$this->addSql('ALTER TABLE rookie_contact ADD CONSTRAINT FK_BC04D03C8AAD1BBC FOREIGN KEY (rookie_person_id) REFERENCES rookie_person (id)');
$this->addSql('ALTER TABLE rookie_contact ADD CONSTRAINT FK_BC04D03C9111923A FOREIGN KEY (rookie_district_id) REFERENCES rookie_district (id)');
$this->addSql('ALTER TABLE rookie_offer ADD CONSTRAINT FK_8A54E9ADAF707042 FOREIGN KEY (rookie_provider_contact_mapping_id) REFERENCES rookie_provider_contact_mapping (id)');
$this->addSql('ALTER TABLE rookie_offer ADD CONSTRAINT FK_8A54E9ADBE04EA9 FOREIGN KEY (job_id) REFERENCES job (id)');
$this->addSql('ALTER TABLE rookie_offer ADD CONSTRAINT FK_8A54E9AD505285EC FOREIGN KEY (rookie_provider_location_id) REFERENCES rookie_provider_location (id)');
$this->addSql('ALTER TABLE rookie_offer ADD CONSTRAINT FK_8A54E9AD9111923A FOREIGN KEY (rookie_district_id) REFERENCES rookie_district (id)');
$this->addSql('ALTER TABLE rookie_offer ADD CONSTRAINT FK_8A54E9ADCDBD5067 FOREIGN KEY (user_op_id) REFERENCES user_operator (id)');
$this->addSql('ALTER TABLE rookie_offer_time_slot_mapping ADD CONSTRAINT FK_2FF41139545BD6C1 FOREIGN KEY (rookie_offer_id) REFERENCES rookie_offer (id)');
$this->addSql('ALTER TABLE rookie_offer_time_slot_mapping ADD CONSTRAINT FK_2FF411397544E768 FOREIGN KEY (rookie_time_slot_id) REFERENCES rookie_time_slot (id)');
$this->addSql('ALTER TABLE rookie_offer_time_slot_mapping ADD CONSTRAINT FK_2FF41139CDBD5067 FOREIGN KEY (user_op_id) REFERENCES user_operator (id)');
$this->addSql('ALTER TABLE rookie_person_address_mapping ADD CONSTRAINT FK_E0749A7F8AAD1BBC FOREIGN KEY (rookie_person_id) REFERENCES rookie_person (id)');
$this->addSql('ALTER TABLE rookie_person_address_mapping ADD CONSTRAINT FK_E0749A7FDF735241 FOREIGN KEY (rookie_address_id) REFERENCES rookie_address (id)');
$this->addSql('ALTER TABLE rookie_person_communication_mapping ADD CONSTRAINT FK_AD6657368AAD1BBC FOREIGN KEY (rookie_person_id) REFERENCES rookie_person (id)');
$this->addSql('ALTER TABLE rookie_person_communication_mapping ADD CONSTRAINT FK_AD665736FF97753C FOREIGN KEY (rookie_communication_id) REFERENCES rookie_communication (id)');
$this->addSql('ALTER TABLE rookie_provider ADD CONSTRAINT FK_9559D1B37174FB2E FOREIGN KEY (company_profile_id) REFERENCES company_profile (id)');
$this->addSql('ALTER TABLE rookie_provider ADD CONSTRAINT FK_9559D1B39111923A FOREIGN KEY (rookie_district_id) REFERENCES rookie_district (id)');
$this->addSql('ALTER TABLE rookie_provider ADD CONSTRAINT FK_9559D1B3CDBD5067 FOREIGN KEY (user_op_id) REFERENCES user_operator (id)');
$this->addSql('ALTER TABLE rookie_provider_contact_mapping ADD CONSTRAINT FK_D3C53D602BCD98E2 FOREIGN KEY (rookie_provider_id) REFERENCES rookie_provider (id)');
$this->addSql('ALTER TABLE rookie_provider_contact_mapping ADD CONSTRAINT FK_D3C53D60CD65D87E FOREIGN KEY (rookie_contact_id) REFERENCES rookie_contact (id)');
$this->addSql('ALTER TABLE rookie_provider_location ADD CONSTRAINT FK_30E66DE52BCD98E2 FOREIGN KEY (rookie_provider_id) REFERENCES rookie_provider (id)');
$this->addSql('ALTER TABLE rookie_provider_location ADD CONSTRAINT FK_30E66DE5DF735241 FOREIGN KEY (rookie_address_id) REFERENCES rookie_address (id)');
$this->addSql('ALTER TABLE rookie_provider_register_time ADD CONSTRAINT FK_3D83B02E9111923A FOREIGN KEY (rookie_district_id) REFERENCES rookie_district (id)');
$this->addSql('ALTER TABLE rookie_school ADD CONSTRAINT FK_903B9A2B9111923A FOREIGN KEY (rookie_district_id) REFERENCES rookie_district (id)');
$this->addSql('ALTER TABLE rookie_school ADD CONSTRAINT FK_903B9A2BC32A47EE FOREIGN KEY (school_id) REFERENCES school (id)');
$this->addSql('ALTER TABLE rookie_school ADD CONSTRAINT FK_903B9A2B7544E768 FOREIGN KEY (rookie_time_slot_id) REFERENCES rookie_time_slot (id)');
$this->addSql('ALTER TABLE rookie_school_class ADD CONSTRAINT FK_4B97F81768FCE715 FOREIGN KEY (rookie_school_id) REFERENCES rookie_school (id)');
$this->addSql('ALTER TABLE rookie_school_contact_mapping ADD CONSTRAINT FK_7E9F545168FCE715 FOREIGN KEY (rookie_school_id) REFERENCES rookie_school (id)');
$this->addSql('ALTER TABLE rookie_school_contact_mapping ADD CONSTRAINT FK_7E9F5451CD261DDC FOREIGN KEY (rookie_school_class_id) REFERENCES rookie_school_class (id)');
$this->addSql('ALTER TABLE rookie_school_contact_mapping ADD CONSTRAINT FK_7E9F5451CD65D87E FOREIGN KEY (rookie_contact_id) REFERENCES rookie_contact (id)');
$this->addSql('ALTER TABLE rookie_time_slot ADD CONSTRAINT FK_AA6589B19111923A FOREIGN KEY (rookie_district_id) REFERENCES rookie_district (id)');
$this->addSql('ALTER TABLE rookie_time_slot ADD CONSTRAINT FK_AA6589B1597A6244 FOREIGN KEY (rookie_time_slot_state_id) REFERENCES rookie_time_slot_state (id)');
$this->addSql('ALTER TABLE school ADD CONSTRAINT FK_F99EDABB1C2D1E0C FOREIGN KEY (communication_id) REFERENCES communication (id)');
$this->addSql('ALTER TABLE school ADD CONSTRAINT FK_F99EDABBF5B7AF75 FOREIGN KEY (address_id) REFERENCES address (id)');
$this->addSql('ALTER TABLE school_type_mapping ADD CONSTRAINT FK_AAF5F6C1C32A47EE FOREIGN KEY (school_id) REFERENCES school (id)');
$this->addSql('ALTER TABLE school_type_mapping ADD CONSTRAINT FK_AAF5F6C15763BE0B FOREIGN KEY (school_type_id) REFERENCES school_type (id)');
$this->addSql('ALTER TABLE school_award_mapping ADD CONSTRAINT FK_9A345F77C32A47EE FOREIGN KEY (school_id) REFERENCES school (id)');
$this->addSql('ALTER TABLE school_award_mapping ADD CONSTRAINT FK_9A345F77C314B68B FOREIGN KEY (school_award_id) REFERENCES school_award (id)');
$this->addSql('ALTER TABLE school_class ADD CONSTRAINT FK_33B1AF85C32A47EE FOREIGN KEY (school_id) REFERENCES school (id)');
$this->addSql('ALTER TABLE school_class ADD CONSTRAINT FK_33B1AF858B9A65FF FOREIGN KEY (school_class_grade_id) REFERENCES school_class_grade (id)');
$this->addSql('ALTER TABLE school_class ADD CONSTRAINT FK_33B1AF85A9A63565 FOREIGN KEY (school_class_year_id) REFERENCES school_class_year (id)');
$this->addSql('ALTER TABLE school_class ADD CONSTRAINT FK_33B1AF854E091857 FOREIGN KEY (school_class_user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE school_class ADD CONSTRAINT FK_33B1AF85705BF896 FOREIGN KEY (school_class_state_id) REFERENCES school_class_state (id)');
$this->addSql('ALTER TABLE school_class_custom_special_field_mapping ADD CONSTRAINT FK_748537E614463F54 FOREIGN KEY (school_class_id) REFERENCES school_class (id)');
$this->addSql('ALTER TABLE school_class_custom_special_field_mapping ADD CONSTRAINT FK_748537E6ABC709B9 FOREIGN KEY (school_custom_special_field_id) REFERENCES school_custom_special_field (id)');
$this->addSql('ALTER TABLE school_class_teacher_mapping ADD CONSTRAINT FK_4288B0BC14463F54 FOREIGN KEY (school_class_id) REFERENCES school_class (id)');
$this->addSql('ALTER TABLE school_class_teacher_mapping ADD CONSTRAINT FK_4288B0BCA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE school_contact ADD CONSTRAINT FK_DE4DD4A0217BBB47 FOREIGN KEY (person_id) REFERENCES person (id)');
$this->addSql('ALTER TABLE school_contact ADD CONSTRAINT FK_DE4DD4A01C2D1E0C FOREIGN KEY (communication_id) REFERENCES communication (id)');
$this->addSql('ALTER TABLE school_contact ADD CONSTRAINT FK_DE4DD4A0292E8AE2 FOREIGN KEY (profile_picture_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE school_contact ADD CONSTRAINT FK_DE4DD4A0795B924A FOREIGN KEY (school_profile_id) REFERENCES school_profile (id)');
$this->addSql('ALTER TABLE school_custom_special_field ADD CONSTRAINT FK_1B937E1CC32A47EE FOREIGN KEY (school_id) REFERENCES school (id)');
$this->addSql('ALTER TABLE school_custom_special_field ADD CONSTRAINT FK_1B937E1C6AAC5ED4 FOREIGN KEY (teacher_user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE school_custom_special_field_special_field_mapping ADD CONSTRAINT FK_A2F4FD5CABC709B9 FOREIGN KEY (school_custom_special_field_id) REFERENCES school_custom_special_field (id)');
$this->addSql('ALTER TABLE school_custom_special_field_special_field_mapping ADD CONSTRAINT FK_A2F4FD5C1B74263C FOREIGN KEY (school_special_field_id) REFERENCES school_special_field (id)');
$this->addSql('ALTER TABLE school_director_mapping ADD CONSTRAINT FK_45A6B5DEC32A47EE FOREIGN KEY (school_id) REFERENCES school (id)');
$this->addSql('ALTER TABLE school_director_mapping ADD CONSTRAINT FK_45A6B5DEA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE school_location ADD CONSTRAINT FK_A0D8BD8FF5B7AF75 FOREIGN KEY (address_id) REFERENCES address (id)');
$this->addSql('ALTER TABLE school_location ADD CONSTRAINT FK_A0D8BD8F795B924A FOREIGN KEY (school_profile_id) REFERENCES school_profile (id)');
$this->addSql('ALTER TABLE school_profile ADD CONSTRAINT FK_13789897C32A47EE FOREIGN KEY (school_id) REFERENCES school (id)');
$this->addSql('ALTER TABLE school_profile ADD CONSTRAINT FK_137898971C2D1E0C FOREIGN KEY (communication_id) REFERENCES communication (id)');
$this->addSql('ALTER TABLE school_profile ADD CONSTRAINT FK_13789897292E8AE2 FOREIGN KEY (profile_picture_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE school_profile ADD CONSTRAINT FK_137898974E7AF8F FOREIGN KEY (gallery_id) REFERENCES media__gallery (id)');
$this->addSql('ALTER TABLE school_profile ADD CONSTRAINT FK_137898978440B739 FOREIGN KEY (video_gallery_id) REFERENCES media__gallery (id)');
$this->addSql('ALTER TABLE school_profile ADD CONSTRAINT FK_13789897A52404D9 FOREIGN KEY (document_gallery_id) REFERENCES media__gallery (id)');
$this->addSql('ALTER TABLE school_profile ADD CONSTRAINT FK_13789897C35EF618 FOREIGN KEY (contact_gallery_id) REFERENCES contact_gallery (id)');
$this->addSql('ALTER TABLE school_profile_job_mapping ADD CONSTRAINT FK_86F4E9B5795B924A FOREIGN KEY (school_profile_id) REFERENCES school_profile (id)');
$this->addSql('ALTER TABLE school_profile_job_mapping ADD CONSTRAINT FK_86F4E9B5BE04EA9 FOREIGN KEY (job_id) REFERENCES job (id)');
$this->addSql('ALTER TABLE school_profile_benefit_mapping ADD CONSTRAINT FK_3ECE2046795B924A FOREIGN KEY (school_profile_id) REFERENCES school_profile (id)');
$this->addSql('ALTER TABLE school_profile_benefit_mapping ADD CONSTRAINT FK_3ECE2046BEF0FB7B FOREIGN KEY (school_benefit_id) REFERENCES school_benefit (id)');
$this->addSql('ALTER TABLE school_profile_search_tag_mapping ADD CONSTRAINT FK_B9C7AC757174FB2E FOREIGN KEY (company_profile_id) REFERENCES school_profile (id)');
$this->addSql('ALTER TABLE school_profile_search_tag_mapping ADD CONSTRAINT FK_B9C7AC7563300C0E FOREIGN KEY (search_tag_id) REFERENCES search_tag (id)');
$this->addSql('ALTER TABLE school_profile_event_mapping ADD CONSTRAINT FK_B8D1B92571F7E88B FOREIGN KEY (event_id) REFERENCES event (id)');
$this->addSql('ALTER TABLE school_profile_event_mapping ADD CONSTRAINT FK_B8D1B925795B924A FOREIGN KEY (school_profile_id) REFERENCES school_profile (id)');
$this->addSql('ALTER TABLE school_profile_name_request ADD CONSTRAINT FK_E21250A2A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE school_profile_name_request ADD CONSTRAINT FK_E21250A2795B924A FOREIGN KEY (school_profile_id) REFERENCES school_profile (id)');
$this->addSql('ALTER TABLE school_teacher_invitation ADD CONSTRAINT FK_443D7FE8C32A47EE FOREIGN KEY (school_id) REFERENCES school (id)');
$this->addSql('ALTER TABLE school_teacher_invitation ADD CONSTRAINT FK_443D7FE8899FB366 FOREIGN KEY (director_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE school_teacher_invitation ADD CONSTRAINT FK_443D7FE825CC445C FOREIGN KEY (invitation_state_id) REFERENCES school_teacher_invitation_state (id)');
$this->addSql('ALTER TABLE school_teacher_invitation_role_mapping ADD CONSTRAINT FK_799B78B8317F6D44 FOREIGN KEY (school_teacher_invitation_id) REFERENCES school_teacher_invitation (id)');
$this->addSql('ALTER TABLE school_teacher_invitation_role_mapping ADD CONSTRAINT FK_799B78B8442C1034 FOREIGN KEY (school_role_id) REFERENCES school_role (id)');
$this->addSql('ALTER TABLE school_teacher_mapping ADD CONSTRAINT FK_1A817967C32A47EE FOREIGN KEY (school_id) REFERENCES school (id)');
$this->addSql('ALTER TABLE school_teacher_mapping ADD CONSTRAINT FK_1A817967A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE school_teacher_role_mapping ADD CONSTRAINT FK_5B2A6BD4F9B6986 FOREIGN KEY (school_teacher_mapping_id) REFERENCES school_teacher_mapping (id)');
$this->addSql('ALTER TABLE school_teacher_role_mapping ADD CONSTRAINT FK_5B2A6BD442C1034 FOREIGN KEY (school_role_id) REFERENCES school_role (id)');
$this->addSql('ALTER TABLE school_type ADD CONSTRAINT FK_CDF688C486A10068 FOREIGN KEY (school_type_category_id) REFERENCES school_type_category (id)');
$this->addSql('ALTER TABLE score ADD CONSTRAINT FK_32993751A4C4A907 FOREIGN KEY (score_type_id) REFERENCES score_type (id)');
$this->addSql('ALTER TABLE score ADD CONSTRAINT FK_3299375114463F54 FOREIGN KEY (school_class_id) REFERENCES school_class (id)');
$this->addSql('ALTER TABLE shuttle_booking ADD CONSTRAINT FK_9D53859FC0096F0A FOREIGN KEY (shuttle_contact_id) REFERENCES shuttle_contact (id)');
$this->addSql('ALTER TABLE shuttle_booking ADD CONSTRAINT FK_9D53859F68B2E502 FOREIGN KEY (shuttle_tour_id) REFERENCES shuttle_tour (id)');
$this->addSql('ALTER TABLE shuttle_booking ADD CONSTRAINT FK_9D53859FC32A47EE FOREIGN KEY (school_id) REFERENCES school (id)');
$this->addSql('ALTER TABLE shuttle_company ADD CONSTRAINT FK_32E0610EF5B7AF75 FOREIGN KEY (address_id) REFERENCES address (id)');
$this->addSql('ALTER TABLE shuttle_company ADD CONSTRAINT FK_32E0610E292E8AE2 FOREIGN KEY (profile_picture_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE shuttle_company ADD CONSTRAINT FK_32E0610E41426E02 FOREIGN KEY (shuttle_duration_id) REFERENCES shuttle_duration (id)');
$this->addSql('ALTER TABLE shuttle_company_job_mapping ADD CONSTRAINT FK_C2FA562CB0335096 FOREIGN KEY (shuttle_company_id) REFERENCES shuttle_company (id)');
$this->addSql('ALTER TABLE shuttle_company_job_mapping ADD CONSTRAINT FK_C2FA562CBE04EA9 FOREIGN KEY (job_id) REFERENCES job (id)');
$this->addSql('ALTER TABLE shuttle_company_date_mapping ADD CONSTRAINT FK_287894ABB0335096 FOREIGN KEY (shuttle_company_id) REFERENCES shuttle_company (id)');
$this->addSql('ALTER TABLE shuttle_company_date_mapping ADD CONSTRAINT FK_287894ABC5C85E2A FOREIGN KEY (shuttle_date_id) REFERENCES shuttle_date (id)');
$this->addSql('ALTER TABLE shuttle_company_date_mapping ADD CONSTRAINT FK_287894AB68B2E502 FOREIGN KEY (shuttle_tour_id) REFERENCES shuttle_tour (id)');
$this->addSql('ALTER TABLE shuttle_contact ADD CONSTRAINT FK_313D8E79B0335096 FOREIGN KEY (shuttle_company_id) REFERENCES shuttle_company (id)');
$this->addSql('ALTER TABLE shuttle_date ADD CONSTRAINT FK_7295A97D64EC54D5 FOREIGN KEY (shuttle_date_state_id) REFERENCES shuttle_date_state (id)');
$this->addSql('ALTER TABLE shuttle_school ADD CONSTRAINT FK_A1682A34C32A47EE FOREIGN KEY (school_id) REFERENCES school (id)');
$this->addSql('ALTER TABLE shuttle_tour ADD CONSTRAINT FK_B2DA676EC5C85E2A FOREIGN KEY (shuttle_date_id) REFERENCES shuttle_date (id)');
$this->addSql('ALTER TABLE shuttle_tour_school_mapping ADD CONSTRAINT FK_4A8788D968B2E502 FOREIGN KEY (shuttle_tour_id) REFERENCES shuttle_tour (id)');
$this->addSql('ALTER TABLE shuttle_tour_school_mapping ADD CONSTRAINT FK_4A8788D9C32A47EE FOREIGN KEY (school_id) REFERENCES school (id)');
$this->addSql('ALTER TABLE slider_item ADD CONSTRAINT FK_788595CEEA9FDD75 FOREIGN KEY (media_id) REFERENCES media__media (id)');
$this->addSql('ALTER TABLE tesis_picta_group_sector_mapping ADD CONSTRAINT FK_3EEC0E7BAB3D627A FOREIGN KEY (picta_group_id) REFERENCES tesis_picta_group (id)');
$this->addSql('ALTER TABLE tesis_picta_group_sector_mapping ADD CONSTRAINT FK_3EEC0E7B19252776 FOREIGN KEY (job_sector_id) REFERENCES job_sector (id)');
$this->addSql('ALTER TABLE title ADD CONSTRAINT FK_2B36786B8730B5EA FOREIGN KEY (title_type_id) REFERENCES title_type (id)');
$this->addSql('ALTER TABLE user_role_mapping ADD CONSTRAINT FK_75E7F573A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE user_role_mapping ADD CONSTRAINT FK_75E7F5738E0E3CA6 FOREIGN KEY (user_role_id) REFERENCES user_role (id)');
$this->addSql('ALTER TABLE user_activation_link ADD CONSTRAINT FK_A932897CA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE user_data ADD CONSTRAINT FK_D772BFAAA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE user_data ADD CONSTRAINT FK_D772BFAA217BBB47 FOREIGN KEY (person_id) REFERENCES person (id)');
$this->addSql('ALTER TABLE user_data ADD CONSTRAINT FK_D772BFAAF5B7AF75 FOREIGN KEY (address_id) REFERENCES address (id)');
$this->addSql('ALTER TABLE user_data ADD CONSTRAINT FK_D772BFAA1C2D1E0C FOREIGN KEY (communication_id) REFERENCES communication (id)');
$this->addSql('ALTER TABLE user_operator_role_mapping ADD CONSTRAINT FK_BAE3E398F15E5136 FOREIGN KEY (user_operator_id) REFERENCES user_operator (id)');
$this->addSql('ALTER TABLE user_operator_role_mapping ADD CONSTRAINT FK_BAE3E3983653B812 FOREIGN KEY (user_operator_role_id) REFERENCES user_operator_role (id)');
$this->addSql('ALTER TABLE user_operator_rookie_district_mapping ADD CONSTRAINT FK_7F9AC30DF15E5136 FOREIGN KEY (user_operator_id) REFERENCES user_operator (id)');
$this->addSql('ALTER TABLE user_operator_rookie_district_mapping ADD CONSTRAINT FK_7F9AC30D9111923A FOREIGN KEY (rookie_district_id) REFERENCES rookie_district (id)');
$this->addSql('ALTER TABLE user_password_change ADD CONSTRAINT FK_DF620397A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE user_setting ADD CONSTRAINT FK_C779A692A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE user_setting ADD CONSTRAINT FK_C779A6928AEC2E80 FOREIGN KEY (selected_user_role_id) REFERENCES user_role (id)');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE address_lat_lon DROP FOREIGN KEY FK_DFA98200F5B7AF75');
$this->addSql('ALTER TABLE bopartner_location DROP FOREIGN KEY FK_E1874C61F5B7AF75');
$this->addSql('ALTER TABLE company_location DROP FOREIGN KEY FK_46099CA6F5B7AF75');
$this->addSql('ALTER TABLE event DROP FOREIGN KEY FK_3BAE0AA7F5B7AF75');
$this->addSql('ALTER TABLE job_market DROP FOREIGN KEY FK_3BA8A84AF5B7AF75');
$this->addSql('ALTER TABLE school DROP FOREIGN KEY FK_F99EDABBF5B7AF75');
$this->addSql('ALTER TABLE school_location DROP FOREIGN KEY FK_A0D8BD8FF5B7AF75');
$this->addSql('ALTER TABLE shuttle_company DROP FOREIGN KEY FK_32E0610EF5B7AF75');
$this->addSql('ALTER TABLE user_data DROP FOREIGN KEY FK_D772BFAAF5B7AF75');
$this->addSql('ALTER TABLE address DROP FOREIGN KEY FK_D4E6F81D0499537');
$this->addSql('ALTER TABLE rookie_address DROP FOREIGN KEY FK_FD285985D0499537');
$this->addSql('ALTER TABLE address_state DROP FOREIGN KEY FK_9436A5DB81B2B6EE');
$this->addSql('ALTER TABLE address_city DROP FOREIGN KEY FK_5017D2DFA74081B9');
$this->addSql('ALTER TABLE address_district DROP FOREIGN KEY FK_CF4EAA06FB57C240');
$this->addSql('ALTER TABLE address DROP FOREIGN KEY FK_D4E6F819EA97B0B');
$this->addSql('ALTER TABLE appointment_agreement_entry DROP FOREIGN KEY FK_99D39DDE5B533F9');
$this->addSql('ALTER TABLE appointment_individual_mapping DROP FOREIGN KEY FK_78359B99E5B533F9');
$this->addSql('ALTER TABLE booking DROP FOREIGN KEY FK_E00CEDDEE5B533F9');
$this->addSql('ALTER TABLE appointment DROP FOREIGN KEY FK_FE38F84430FCB709');
$this->addSql('ALTER TABLE appointment DROP FOREIGN KEY FK_FE38F844546FBEBB');
$this->addSql('ALTER TABLE bo_plan_week DROP FOREIGN KEY FK_9C0A3A5F4CB1CEC1');
$this->addSql('ALTER TABLE bo_plan_week DROP FOREIGN KEY FK_9C0A3A5F5FBBB4F2');
$this->addSql('ALTER TABLE bo_plan_week DROP FOREIGN KEY FK_9C0A3A5FA563B7E2');
$this->addSql('ALTER TABLE bo_plan DROP FOREIGN KEY FK_3EBAE346E3EB8173');
$this->addSql('ALTER TABLE bo_plan_week DROP FOREIGN KEY FK_9C0A3A5FCE50426D');
$this->addSql('ALTER TABLE bo_plan_subject DROP FOREIGN KEY FK_F77C9E13A2FE0107');
$this->addSql('ALTER TABLE bo_plan_week DROP FOREIGN KEY FK_9C0A3A5FB83EE2E8');
$this->addSql('ALTER TABLE bo_plan_week_changes DROP FOREIGN KEY FK_6110AB411A8F78AC');
$this->addSql('ALTER TABLE bo_plan_week DROP FOREIGN KEY FK_9C0A3A5F5C2A31C5');
$this->addSql('ALTER TABLE booking_additional_information DROP FOREIGN KEY FK_DFBF83AA3301C60');
$this->addSql('ALTER TABLE booking_proposal DROP FOREIGN KEY FK_84D10AFF3301C60');
$this->addSql('ALTER TABLE booking_school_custom_special_field_mapping DROP FOREIGN KEY FK_FF1C22943301C60');
$this->addSql('ALTER TABLE booking_additional_information DROP FOREIGN KEY FK_DFBF83AAD34E2FED');
$this->addSql('ALTER TABLE booking_proposal DROP FOREIGN KEY FK_84D10AFF7B02371D');
$this->addSql('ALTER TABLE booking DROP FOREIGN KEY FK_E00CEDDE3EECA24C');
$this->addSql('ALTER TABLE bookmark DROP FOREIGN KEY FK_DA62921DA894E7A8');
$this->addSql('ALTER TABLE bopartner_contact DROP FOREIGN KEY FK_85C65A0B731CCFFD');
$this->addSql('ALTER TABLE bopartner_location DROP FOREIGN KEY FK_E1874C61731CCFFD');
$this->addSql('ALTER TABLE bopartner_profile_search_tag_mapping DROP FOREIGN KEY FK_8567513E731CCFFD');
$this->addSql('ALTER TABLE bopartner_profile_event_mapping DROP FOREIGN KEY FK_A9B8ADDB731CCFFD');
$this->addSql('ALTER TABLE bopartner_profile_mapping DROP FOREIGN KEY FK_10475A0E731CCFFD');
$this->addSql('ALTER TABLE bopartner_profile_name_request DROP FOREIGN KEY FK_8A0DF279731CCFFD');
$this->addSql('ALTER TABLE bopartner_contact DROP FOREIGN KEY FK_85C65A0B1C2D1E0C');
$this->addSql('ALTER TABLE bopartner_profile DROP FOREIGN KEY FK_48F3163C1C2D1E0C');
$this->addSql('ALTER TABLE communication_entry DROP FOREIGN KEY FK_AAA05CC51C2D1E0C');
$this->addSql('ALTER TABLE company_contact DROP FOREIGN KEY FK_6C30FCEF1C2D1E0C');
$this->addSql('ALTER TABLE company_profile DROP FOREIGN KEY FK_A105B0D81C2D1E0C');
$this->addSql('ALTER TABLE contact DROP FOREIGN KEY FK_4C62E6381C2D1E0C');
$this->addSql('ALTER TABLE school DROP FOREIGN KEY FK_F99EDABB1C2D1E0C');
$this->addSql('ALTER TABLE school_contact DROP FOREIGN KEY FK_DE4DD4A01C2D1E0C');
$this->addSql('ALTER TABLE school_profile DROP FOREIGN KEY FK_137898971C2D1E0C');
$this->addSql('ALTER TABLE user_data DROP FOREIGN KEY FK_D772BFAA1C2D1E0C');
$this->addSql('ALTER TABLE communication_entry DROP FOREIGN KEY FK_AAA05CC5B09DA5C9');
$this->addSql('ALTER TABLE company_profile_benefit_mapping DROP FOREIGN KEY FK_43CCFDF2B6DF921F');
$this->addSql('ALTER TABLE company_profile_certificate_mapping DROP FOREIGN KEY FK_1B89EDF0B7EA105E');
$this->addSql('ALTER TABLE job_market DROP FOREIGN KEY FK_3BA8A84A5A2FCCDC');
$this->addSql('ALTER TABLE company_contact DROP FOREIGN KEY FK_6C30FCEF7174FB2E');
$this->addSql('ALTER TABLE company_location DROP FOREIGN KEY FK_46099CA67174FB2E');
$this->addSql('ALTER TABLE company_profile_certificate_mapping DROP FOREIGN KEY FK_1B89EDF07174FB2E');
$this->addSql('ALTER TABLE company_profile_job_mapping DROP FOREIGN KEY FK_9D7949957174FB2E');
$this->addSql('ALTER TABLE company_profile_sector_mapping DROP FOREIGN KEY FK_E65CDA1E7174FB2E');
$this->addSql('ALTER TABLE company_profile_benefit_mapping DROP FOREIGN KEY FK_43CCFDF27174FB2E');
$this->addSql('ALTER TABLE company_profile_search_tag_mapping DROP FOREIGN KEY FK_A10820BA7174FB2E');
$this->addSql('ALTER TABLE company_profile_event_mapping DROP FOREIGN KEY FK_FB8325E27174FB2E');
$this->addSql('ALTER TABLE company_profile_mapping DROP FOREIGN KEY FK_D5A9C86B7174FB2E');
$this->addSql('ALTER TABLE company_profile_name_request DROP FOREIGN KEY FK_D967FDCA7174FB2E');
$this->addSql('ALTER TABLE job_market DROP FOREIGN KEY FK_3BA8A84A7174FB2E');
$this->addSql('ALTER TABLE rookie_provider DROP FOREIGN KEY FK_9559D1B37174FB2E');
$this->addSql('ALTER TABLE company_profile DROP FOREIGN KEY FK_A105B0D869DFB2F0');
$this->addSql('ALTER TABLE appointment_individual_mapping DROP FOREIGN KEY FK_78359B99E7A1254A');
$this->addSql('ALTER TABLE contact_gallery_entry DROP FOREIGN KEY FK_EE240ED4E7A1254A');
$this->addSql('ALTER TABLE job_market DROP FOREIGN KEY FK_3BA8A84AE7A1254A');
$this->addSql('ALTER TABLE bopartner_profile DROP FOREIGN KEY FK_48F3163CC35EF618');
$this->addSql('ALTER TABLE company_profile DROP FOREIGN KEY FK_A105B0D8C35EF618');
$this->addSql('ALTER TABLE contact_gallery_entry DROP FOREIGN KEY FK_EE240ED4C35EF618');
$this->addSql('ALTER TABLE school_profile DROP FOREIGN KEY FK_13789897C35EF618');
$this->addSql('ALTER TABLE custom_variable DROP FOREIGN KEY FK_299F60E986CCF6A2');
$this->addSql('ALTER TABLE appointment DROP FOREIGN KEY FK_FE38F84471F7E88B');
$this->addSql('ALTER TABLE bo_plan_week DROP FOREIGN KEY FK_9C0A3A5F71F7E88B');
$this->addSql('ALTER TABLE bopartner_profile_event_mapping DROP FOREIGN KEY FK_A9B8ADDB71F7E88B');
$this->addSql('ALTER TABLE company_profile_event_mapping DROP FOREIGN KEY FK_FB8325E271F7E88B');
$this->addSql('ALTER TABLE event_job_mapping DROP FOREIGN KEY FK_7880489171F7E88B');
$this->addSql('ALTER TABLE event_search_tag_mapping DROP FOREIGN KEY FK_3A9E542A71F7E88B');
$this->addSql('ALTER TABLE event_feedback DROP FOREIGN KEY FK_94C5AD8871F7E88B');
$this->addSql('ALTER TABLE event_preparation DROP FOREIGN KEY FK_5279797471F7E88B');
$this->addSql('ALTER TABLE event_tag_mapping DROP FOREIGN KEY FK_D05ED2A071F7E88B');
$this->addSql('ALTER TABLE school_profile_event_mapping DROP FOREIGN KEY FK_B8D1B92571F7E88B');
$this->addSql('ALTER TABLE event_feedback_question DROP FOREIGN KEY FK_6C20B85D79C07B07');
$this->addSql('ALTER TABLE event_feedback_user DROP FOREIGN KEY FK_6C68876C79C07B07');
$this->addSql('ALTER TABLE event_feedback_answer DROP FOREIGN KEY FK_2E421A5B15577CC7');
$this->addSql('ALTER TABLE event_feedback_answer DROP FOREIGN KEY FK_2E421A5B102710FE');
$this->addSql('ALTER TABLE event_preparation_question DROP FOREIGN KEY FK_BED12848E29D0EC9');
$this->addSql('ALTER TABLE event_preparation_user DROP FOREIGN KEY FK_197E6342E29D0EC9');
$this->addSql('ALTER TABLE event_preparation_answer DROP FOREIGN KEY FK_82224000B441551E');
$this->addSql('ALTER TABLE event_preparation_answer DROP FOREIGN KEY FK_82224000EC32F8D8');
$this->addSql('ALTER TABLE event DROP FOREIGN KEY FK_3BAE0AA74334D511');
$this->addSql('ALTER TABLE event_tag_mapping DROP FOREIGN KEY FK_D05ED2A0884B1443');
$this->addSql('ALTER TABLE event_tag DROP FOREIGN KEY FK_12467250C75C8332');
$this->addSql('ALTER TABLE faq_subcategory DROP FOREIGN KEY FK_E9138971F689B0DB');
$this->addSql('ALTER TABLE faq_question DROP FOREIGN KEY FK_4A55B0595D8DA562');
$this->addSql('ALTER TABLE job_sector_image DROP FOREIGN KEY FK_1D852DE1820AEF50');
$this->addSql('ALTER TABLE job_workfield_image DROP FOREIGN KEY FK_7D2E8060820AEF50');
$this->addSql('ALTER TABLE misc_file DROP FOREIGN KEY FK_C0F9CF99820AEF50');
$this->addSql('ALTER TABLE game_jeopardy_question_school_class_mapping DROP FOREIGN KEY FK_5F8D9485E1F9AB61');
$this->addSql('ALTER TABLE game_jeopardy_question_school_class_mapping DROP FOREIGN KEY FK_5F8D948584104B01');
$this->addSql('ALTER TABLE game_memory_school_class_job_mapping DROP FOREIGN KEY FK_4089C446E297ECA9');
$this->addSql('ALTER TABLE game_quiz_question_profile_mapping DROP FOREIGN KEY FK_F5FF5322F102203');
$this->addSql('ALTER TABLE game_quiz_question_school_class_mapping DROP FOREIGN KEY FK_3FA5BBE3F102203');
$this->addSql('ALTER TABLE game_quiz_question DROP FOREIGN KEY FK_CAD72C60780B43E2');
$this->addSql('ALTER TABLE game_quiz_school_class DROP FOREIGN KEY FK_F17767F6780B43E2');
$this->addSql('ALTER TABLE game_quiz_question_school_class_mapping DROP FOREIGN KEY FK_3FA5BBE333D5D35C');
$this->addSql('ALTER TABLE info_section_subcategory DROP FOREIGN KEY FK_B527D64BAABDEFE1');
$this->addSql('ALTER TABLE info_section_entry DROP FOREIGN KEY FK_F4E911886076769F');
$this->addSql('ALTER TABLE info_section_category DROP FOREIGN KEY FK_BF12A6B3170B419C');
$this->addSql('ALTER TABLE company_profile_job_mapping DROP FOREIGN KEY FK_9D794995BE04EA9');
$this->addSql('ALTER TABLE event_job_mapping DROP FOREIGN KEY FK_78804891BE04EA9');
$this->addSql('ALTER TABLE game_memory_school_class_job_mapping DROP FOREIGN KEY FK_4089C446BE04EA9');
$this->addSql('ALTER TABLE game_quiz_question DROP FOREIGN KEY FK_CAD72C60BE04EA9');
$this->addSql('ALTER TABLE job_sector_mapping DROP FOREIGN KEY FK_7112EF68BE04EA9');
$this->addSql('ALTER TABLE job_educational_path_mapping DROP FOREIGN KEY FK_E5B4189CBE04EA9');
$this->addSql('ALTER TABLE job_workfield_mapping DROP FOREIGN KEY FK_FBEDF99CBE04EA9');
$this->addSql('ALTER TABLE job_search_tag_mapping DROP FOREIGN KEY FK_CD6D9CEDBE04EA9');
$this->addSql('ALTER TABLE job_ams DROP FOREIGN KEY FK_6BDEDEF8BE04EA9');
$this->addSql('ALTER TABLE job_daily_routine DROP FOREIGN KEY FK_3FC957EEBE04EA9');
$this->addSql('ALTER TABLE job_link_mapping DROP FOREIGN KEY FK_3BE3E350BE04EA9');
$this->addSql('ALTER TABLE job_market_job_mapping DROP FOREIGN KEY FK_AB53959BE04EA9');
$this->addSql('ALTER TABLE job_school DROP FOREIGN KEY FK_A99AF73ABE04EA9');
$this->addSql('ALTER TABLE rookie_offer DROP FOREIGN KEY FK_8A54E9ADBE04EA9');
$this->addSql('ALTER TABLE school_profile_job_mapping DROP FOREIGN KEY FK_86F4E9B5BE04EA9');
$this->addSql('ALTER TABLE shuttle_company_job_mapping DROP FOREIGN KEY FK_C2FA562CBE04EA9');
$this->addSql('ALTER TABLE game_quiz_school_class DROP FOREIGN KEY FK_F17767F6D27F8922');
$this->addSql('ALTER TABLE job_daily_routine_entry DROP FOREIGN KEY FK_23161BE4D27F8922');
$this->addSql('ALTER TABLE job_daily_routine DROP FOREIGN KEY FK_3FC957EEC9F81D25');
$this->addSql('ALTER TABLE job_educational_path_mapping DROP FOREIGN KEY FK_E5B4189C8421405E');
$this->addSql('ALTER TABLE job_link_mapping DROP FOREIGN KEY FK_3BE3E350374BB5EA');
$this->addSql('ALTER TABLE job_link_mapping DROP FOREIGN KEY FK_3BE3E350BEE658CB');
$this->addSql('ALTER TABLE job_link_mapping DROP FOREIGN KEY FK_3BE3E350904BC219');
$this->addSql('ALTER TABLE job_market_job_mapping DROP FOREIGN KEY FK_AB53959A59FD026');
$this->addSql('ALTER TABLE job_market DROP FOREIGN KEY FK_3BA8A84A45FC6BDC');
$this->addSql('ALTER TABLE job_market DROP FOREIGN KEY FK_3BA8A84A45E22644');
$this->addSql('ALTER TABLE job_market DROP FOREIGN KEY FK_3BA8A84A35F10E35');
$this->addSql('ALTER TABLE job_market DROP FOREIGN KEY FK_3BA8A84A3F56666');
$this->addSql('ALTER TABLE company_profile_sector_mapping DROP FOREIGN KEY FK_E65CDA1EDE95C867');
$this->addSql('ALTER TABLE job_sector_mapping DROP FOREIGN KEY FK_7112EF68DE95C867');
$this->addSql('ALTER TABLE tesis_picta_group_sector_mapping DROP FOREIGN KEY FK_3EEC0E7B19252776');
$this->addSql('ALTER TABLE job_sector DROP FOREIGN KEY FK_1BA7F46998051D95');
$this->addSql('ALTER TABLE job_workfield_mapping DROP FOREIGN KEY FK_FBEDF99CEAD7CBC0');
$this->addSql('ALTER TABLE job_workfield_image DROP FOREIGN KEY FK_7D2E8060EAD7CBC0');
$this->addSql('ALTER TABLE job_workfield DROP FOREIGN KEY FK_38A36B6AC9C39BE9');
$this->addSql('ALTER TABLE bopartner_profile DROP FOREIGN KEY FK_48F3163C4E7AF8F');
$this->addSql('ALTER TABLE bopartner_profile DROP FOREIGN KEY FK_48F3163C8440B739');
$this->addSql('ALTER TABLE bopartner_profile DROP FOREIGN KEY FK_48F3163CA52404D9');
$this->addSql('ALTER TABLE company_profile DROP FOREIGN KEY FK_A105B0D84E7AF8F');
$this->addSql('ALTER TABLE company_profile DROP FOREIGN KEY FK_A105B0D88440B739');
$this->addSql('ALTER TABLE company_profile DROP FOREIGN KEY FK_A105B0D8A52404D9');
$this->addSql('ALTER TABLE event DROP FOREIGN KEY FK_3BAE0AA74E7AF8F');
$this->addSql('ALTER TABLE event DROP FOREIGN KEY FK_3BAE0AA78440B739');
$this->addSql('ALTER TABLE event DROP FOREIGN KEY FK_3BAE0AA7A52404D9');
$this->addSql('ALTER TABLE event DROP FOREIGN KEY FK_3BAE0AA72D0254C5');
$this->addSql('ALTER TABLE job DROP FOREIGN KEY FK_FBD8E0F86E903F92');
$this->addSql('ALTER TABLE media__gallery_media DROP FOREIGN KEY FK_80D4C5414E7AF8F');
$this->addSql('ALTER TABLE school_profile DROP FOREIGN KEY FK_137898974E7AF8F');
$this->addSql('ALTER TABLE school_profile DROP FOREIGN KEY FK_137898978440B739');
$this->addSql('ALTER TABLE school_profile DROP FOREIGN KEY FK_13789897A52404D9');
$this->addSql('ALTER TABLE bopartner_contact DROP FOREIGN KEY FK_85C65A0B292E8AE2');
$this->addSql('ALTER TABLE bopartner_profile DROP FOREIGN KEY FK_48F3163C292E8AE2');
$this->addSql('ALTER TABLE company_contact DROP FOREIGN KEY FK_6C30FCEF292E8AE2');
$this->addSql('ALTER TABLE company_profile DROP FOREIGN KEY FK_A105B0D8292E8AE2');
$this->addSql('ALTER TABLE contact DROP FOREIGN KEY FK_4C62E638292E8AE2');
$this->addSql('ALTER TABLE event DROP FOREIGN KEY FK_3BAE0AA7EA9FDD75');
$this->addSql('ALTER TABLE info_section_category DROP FOREIGN KEY FK_BF12A6B3C85BEDC1');
$this->addSql('ALTER TABLE info_section_entry DROP FOREIGN KEY FK_F4E9118876EFF48D');
$this->addSql('ALTER TABLE job DROP FOREIGN KEY FK_FBD8E0F85AE28016');
$this->addSql('ALTER TABLE job DROP FOREIGN KEY FK_FBD8E0F81EF359A0');
$this->addSql('ALTER TABLE job_daily_routine DROP FOREIGN KEY FK_3FC957EEEA9FDD75');
$this->addSql('ALTER TABLE job_daily_routine DROP FOREIGN KEY FK_3FC957EE21212CC7');
$this->addSql('ALTER TABLE job_daily_routine_entry DROP FOREIGN KEY FK_23161BE474552888');
$this->addSql('ALTER TABLE job_daily_routine_entry DROP FOREIGN KEY FK_23161BE45BF64687');
$this->addSql('ALTER TABLE job_daily_routine_entry DROP FOREIGN KEY FK_23161BE47B8DD49A');
$this->addSql('ALTER TABLE job_daily_routine_entry DROP FOREIGN KEY FK_23161BE4E460732B');
$this->addSql('ALTER TABLE job_market DROP FOREIGN KEY FK_3BA8A84AEA9FDD75');
$this->addSql('ALTER TABLE job_market DROP FOREIGN KEY FK_3BA8A84A71672B6D');
$this->addSql('ALTER TABLE media__gallery_media DROP FOREIGN KEY FK_80D4C541EA9FDD75');
$this->addSql('ALTER TABLE school_contact DROP FOREIGN KEY FK_DE4DD4A0292E8AE2');
$this->addSql('ALTER TABLE school_profile DROP FOREIGN KEY FK_13789897292E8AE2');
$this->addSql('ALTER TABLE shuttle_company DROP FOREIGN KEY FK_32E0610E292E8AE2');
$this->addSql('ALTER TABLE slider_item DROP FOREIGN KEY FK_788595CEEA9FDD75');
$this->addSql('ALTER TABLE media__gallery DROP FOREIGN KEY FK_3C02B7F53F01A74C');
$this->addSql('ALTER TABLE news DROP FOREIGN KEY FK_1DD39950BF05C450');
$this->addSql('ALTER TABLE news DROP FOREIGN KEY FK_1DD3995092A89075');
$this->addSql('ALTER TABLE bopartner_contact DROP FOREIGN KEY FK_85C65A0B217BBB47');
$this->addSql('ALTER TABLE company_contact DROP FOREIGN KEY FK_6C30FCEF217BBB47');
$this->addSql('ALTER TABLE contact DROP FOREIGN KEY FK_4C62E638217BBB47');
$this->addSql('ALTER TABLE person_title_mapping DROP FOREIGN KEY FK_314263E217BBB47');
$this->addSql('ALTER TABLE school_contact DROP FOREIGN KEY FK_DE4DD4A0217BBB47');
$this->addSql('ALTER TABLE user_data DROP FOREIGN KEY FK_D772BFAA217BBB47');
$this->addSql('ALTER TABLE appointment_individual_mapping DROP FOREIGN KEY FK_78359B9916F2520F');
$this->addSql('ALTER TABLE contact DROP FOREIGN KEY FK_4C62E63816F2520F');
$this->addSql('ALTER TABLE event DROP FOREIGN KEY FK_3BAE0AA716F2520F');
$this->addSql('ALTER TABLE game_quiz_question_profile_mapping DROP FOREIGN KEY FK_F5FF532216F2520F');
$this->addSql('ALTER TABLE rookie_person_address_mapping DROP FOREIGN KEY FK_E0749A7FDF735241');
$this->addSql('ALTER TABLE rookie_provider_location DROP FOREIGN KEY FK_30E66DE5DF735241');
$this->addSql('ALTER TABLE rookie_person_communication_mapping DROP FOREIGN KEY FK_AD665736FF97753C');
$this->addSql('ALTER TABLE rookie_provider_contact_mapping DROP FOREIGN KEY FK_D3C53D60CD65D87E');
$this->addSql('ALTER TABLE rookie_school_contact_mapping DROP FOREIGN KEY FK_7E9F5451CD65D87E');
$this->addSql('ALTER TABLE rookie_contact DROP FOREIGN KEY FK_BC04D03C86038F9A');
$this->addSql('ALTER TABLE rookie_booking DROP FOREIGN KEY FK_106ADBDA9111923A');
$this->addSql('ALTER TABLE rookie_contact DROP FOREIGN KEY FK_BC04D03C9111923A');
$this->addSql('ALTER TABLE rookie_offer DROP FOREIGN KEY FK_8A54E9AD9111923A');
$this->addSql('ALTER TABLE rookie_provider DROP FOREIGN KEY FK_9559D1B39111923A');
$this->addSql('ALTER TABLE rookie_provider_register_time DROP FOREIGN KEY FK_3D83B02E9111923A');
$this->addSql('ALTER TABLE rookie_school DROP FOREIGN KEY FK_903B9A2B9111923A');
$this->addSql('ALTER TABLE rookie_time_slot DROP FOREIGN KEY FK_AA6589B19111923A');
$this->addSql('ALTER TABLE user_operator_rookie_district_mapping DROP FOREIGN KEY FK_7F9AC30D9111923A');
$this->addSql('ALTER TABLE rookie_offer_time_slot_mapping DROP FOREIGN KEY FK_2FF41139545BD6C1');
$this->addSql('ALTER TABLE rookie_booking DROP FOREIGN KEY FK_106ADBDAA4F20E15');
$this->addSql('ALTER TABLE rookie_booking DROP FOREIGN KEY FK_106ADBDA8AAD1BBC');
$this->addSql('ALTER TABLE rookie_contact DROP FOREIGN KEY FK_BC04D03C8AAD1BBC');
$this->addSql('ALTER TABLE rookie_person_address_mapping DROP FOREIGN KEY FK_E0749A7F8AAD1BBC');
$this->addSql('ALTER TABLE rookie_person_communication_mapping DROP FOREIGN KEY FK_AD6657368AAD1BBC');
$this->addSql('ALTER TABLE rookie_provider_contact_mapping DROP FOREIGN KEY FK_D3C53D602BCD98E2');
$this->addSql('ALTER TABLE rookie_provider_location DROP FOREIGN KEY FK_30E66DE52BCD98E2');
$this->addSql('ALTER TABLE rookie_offer DROP FOREIGN KEY FK_8A54E9ADAF707042');
$this->addSql('ALTER TABLE rookie_offer DROP FOREIGN KEY FK_8A54E9AD505285EC');
$this->addSql('ALTER TABLE rookie_school_class DROP FOREIGN KEY FK_4B97F81768FCE715');
$this->addSql('ALTER TABLE rookie_school_contact_mapping DROP FOREIGN KEY FK_7E9F545168FCE715');
$this->addSql('ALTER TABLE rookie_booking DROP FOREIGN KEY FK_106ADBDACD261DDC');
$this->addSql('ALTER TABLE rookie_school_contact_mapping DROP FOREIGN KEY FK_7E9F5451CD261DDC');
$this->addSql('ALTER TABLE rookie_offer_time_slot_mapping DROP FOREIGN KEY FK_2FF411397544E768');
$this->addSql('ALTER TABLE rookie_school DROP FOREIGN KEY FK_903B9A2B7544E768');
$this->addSql('ALTER TABLE rookie_time_slot DROP FOREIGN KEY FK_AA6589B1597A6244');
$this->addSql('ALTER TABLE job_school DROP FOREIGN KEY FK_A99AF73AC32A47EE');
$this->addSql('ALTER TABLE rookie_school DROP FOREIGN KEY FK_903B9A2BC32A47EE');
$this->addSql('ALTER TABLE school_type_mapping DROP FOREIGN KEY FK_AAF5F6C1C32A47EE');
$this->addSql('ALTER TABLE school_award_mapping DROP FOREIGN KEY FK_9A345F77C32A47EE');
$this->addSql('ALTER TABLE school_class DROP FOREIGN KEY FK_33B1AF85C32A47EE');
$this->addSql('ALTER TABLE school_custom_special_field DROP FOREIGN KEY FK_1B937E1CC32A47EE');
$this->addSql('ALTER TABLE school_director_mapping DROP FOREIGN KEY FK_45A6B5DEC32A47EE');
$this->addSql('ALTER TABLE school_profile DROP FOREIGN KEY FK_13789897C32A47EE');
$this->addSql('ALTER TABLE school_teacher_invitation DROP FOREIGN KEY FK_443D7FE8C32A47EE');
$this->addSql('ALTER TABLE school_teacher_mapping DROP FOREIGN KEY FK_1A817967C32A47EE');
$this->addSql('ALTER TABLE shuttle_booking DROP FOREIGN KEY FK_9D53859FC32A47EE');
$this->addSql('ALTER TABLE shuttle_school DROP FOREIGN KEY FK_A1682A34C32A47EE');
$this->addSql('ALTER TABLE shuttle_tour_school_mapping DROP FOREIGN KEY FK_4A8788D9C32A47EE');
$this->addSql('ALTER TABLE school_award_mapping DROP FOREIGN KEY FK_9A345F77C314B68B');
$this->addSql('ALTER TABLE school_profile_benefit_mapping DROP FOREIGN KEY FK_3ECE2046BEF0FB7B');
$this->addSql('ALTER TABLE bo_plan DROP FOREIGN KEY FK_3EBAE34614463F54');
$this->addSql('ALTER TABLE booking DROP FOREIGN KEY FK_E00CEDDE14463F54');
$this->addSql('ALTER TABLE game_jeopardy_school_class DROP FOREIGN KEY FK_52258E0B14463F54');
$this->addSql('ALTER TABLE game_memory_school_class DROP FOREIGN KEY FK_2424E3BD14463F54');
$this->addSql('ALTER TABLE game_quiz_school_class DROP FOREIGN KEY FK_F17767F614463F54');
$this->addSql('ALTER TABLE school_class_custom_special_field_mapping DROP FOREIGN KEY FK_748537E614463F54');
$this->addSql('ALTER TABLE school_class_teacher_mapping DROP FOREIGN KEY FK_4288B0BC14463F54');
$this->addSql('ALTER TABLE score DROP FOREIGN KEY FK_3299375114463F54');
$this->addSql('ALTER TABLE bo_plan_subject_category DROP FOREIGN KEY FK_A49417288B9A65FF');
$this->addSql('ALTER TABLE school_class DROP FOREIGN KEY FK_33B1AF858B9A65FF');
$this->addSql('ALTER TABLE school_class DROP FOREIGN KEY FK_33B1AF85705BF896');
$this->addSql('ALTER TABLE school_class DROP FOREIGN KEY FK_33B1AF85A9A63565');
$this->addSql('ALTER TABLE booking_school_custom_special_field_mapping DROP FOREIGN KEY FK_FF1C2294ABC709B9');
$this->addSql('ALTER TABLE school_class_custom_special_field_mapping DROP FOREIGN KEY FK_748537E6ABC709B9');
$this->addSql('ALTER TABLE school_custom_special_field_special_field_mapping DROP FOREIGN KEY FK_A2F4FD5CABC709B9');
$this->addSql('ALTER TABLE game_quiz_question DROP FOREIGN KEY FK_CAD72C60795B924A');
$this->addSql('ALTER TABLE job_daily_routine DROP FOREIGN KEY FK_3FC957EE795B924A');
$this->addSql('ALTER TABLE school_contact DROP FOREIGN KEY FK_DE4DD4A0795B924A');
$this->addSql('ALTER TABLE school_location DROP FOREIGN KEY FK_A0D8BD8F795B924A');
$this->addSql('ALTER TABLE school_profile_job_mapping DROP FOREIGN KEY FK_86F4E9B5795B924A');
$this->addSql('ALTER TABLE school_profile_benefit_mapping DROP FOREIGN KEY FK_3ECE2046795B924A');
$this->addSql('ALTER TABLE school_profile_search_tag_mapping DROP FOREIGN KEY FK_B9C7AC757174FB2E');
$this->addSql('ALTER TABLE school_profile_event_mapping DROP FOREIGN KEY FK_B8D1B925795B924A');
$this->addSql('ALTER TABLE school_profile_name_request DROP FOREIGN KEY FK_E21250A2795B924A');
$this->addSql('ALTER TABLE school_teacher_invitation_role_mapping DROP FOREIGN KEY FK_799B78B8442C1034');
$this->addSql('ALTER TABLE school_teacher_role_mapping DROP FOREIGN KEY FK_5B2A6BD442C1034');
$this->addSql('ALTER TABLE school_custom_special_field_special_field_mapping DROP FOREIGN KEY FK_A2F4FD5C1B74263C');
$this->addSql('ALTER TABLE bo_plan_week DROP FOREIGN KEY FK_9C0A3A5FB79F5C75');
$this->addSql('ALTER TABLE school_teacher_invitation_role_mapping DROP FOREIGN KEY FK_799B78B8317F6D44');
$this->addSql('ALTER TABLE school_teacher_invitation DROP FOREIGN KEY FK_443D7FE825CC445C');
$this->addSql('ALTER TABLE school_teacher_role_mapping DROP FOREIGN KEY FK_5B2A6BD4F9B6986');
$this->addSql('ALTER TABLE school_type_mapping DROP FOREIGN KEY FK_AAF5F6C15763BE0B');
$this->addSql('ALTER TABLE school_type DROP FOREIGN KEY FK_CDF688C486A10068');
$this->addSql('ALTER TABLE score DROP FOREIGN KEY FK_32993751A4C4A907');
$this->addSql('ALTER TABLE bopartner_profile_search_tag_mapping DROP FOREIGN KEY FK_8567513E63300C0E');
$this->addSql('ALTER TABLE company_profile_search_tag_mapping DROP FOREIGN KEY FK_A10820BA63300C0E');
$this->addSql('ALTER TABLE event_search_tag_mapping DROP FOREIGN KEY FK_3A9E542A63300C0E');
$this->addSql('ALTER TABLE job_search_tag_mapping DROP FOREIGN KEY FK_CD6D9CED63300C0E');
$this->addSql('ALTER TABLE school_profile_search_tag_mapping DROP FOREIGN KEY FK_B9C7AC7563300C0E');
$this->addSql('ALTER TABLE shuttle_company_job_mapping DROP FOREIGN KEY FK_C2FA562CB0335096');
$this->addSql('ALTER TABLE shuttle_company_date_mapping DROP FOREIGN KEY FK_287894ABB0335096');
$this->addSql('ALTER TABLE shuttle_contact DROP FOREIGN KEY FK_313D8E79B0335096');
$this->addSql('ALTER TABLE shuttle_booking DROP FOREIGN KEY FK_9D53859FC0096F0A');
$this->addSql('ALTER TABLE shuttle_company_date_mapping DROP FOREIGN KEY FK_287894ABC5C85E2A');
$this->addSql('ALTER TABLE shuttle_tour DROP FOREIGN KEY FK_B2DA676EC5C85E2A');
$this->addSql('ALTER TABLE shuttle_date DROP FOREIGN KEY FK_7295A97D64EC54D5');
$this->addSql('ALTER TABLE shuttle_company DROP FOREIGN KEY FK_32E0610E41426E02');
$this->addSql('ALTER TABLE shuttle_booking DROP FOREIGN KEY FK_9D53859F68B2E502');
$this->addSql('ALTER TABLE shuttle_company_date_mapping DROP FOREIGN KEY FK_287894AB68B2E502');
$this->addSql('ALTER TABLE shuttle_tour_school_mapping DROP FOREIGN KEY FK_4A8788D968B2E502');
$this->addSql('ALTER TABLE tesis_picta_group_sector_mapping DROP FOREIGN KEY FK_3EEC0E7BAB3D627A');
$this->addSql('ALTER TABLE person_title_mapping DROP FOREIGN KEY FK_314263EA9F87BD');
$this->addSql('ALTER TABLE title DROP FOREIGN KEY FK_2B36786B8730B5EA');
$this->addSql('ALTER TABLE bo_plan_week DROP FOREIGN KEY FK_9C0A3A5F8863C3A6');
$this->addSql('ALTER TABLE bo_plan_week DROP FOREIGN KEY FK_9C0A3A5F94759198');
$this->addSql('ALTER TABLE bo_plan_week DROP FOREIGN KEY FK_9C0A3A5F650F5579');
$this->addSql('ALTER TABLE bo_plan_week_changes DROP FOREIGN KEY FK_6110AB415B57C7EF');
$this->addSql('ALTER TABLE booking DROP FOREIGN KEY FK_E00CEDDEA76ED395');
$this->addSql('ALTER TABLE booking_proposal DROP FOREIGN KEY FK_84D10AFFA76ED395');
$this->addSql('ALTER TABLE booking_proposal DROP FOREIGN KEY FK_84D10AFF6C066AFE');
$this->addSql('ALTER TABLE bookmark DROP FOREIGN KEY FK_DA62921DA76ED395');
$this->addSql('ALTER TABLE bopartner_profile_mapping DROP FOREIGN KEY FK_10475A0EA76ED395');
$this->addSql('ALTER TABLE bopartner_profile_name_request DROP FOREIGN KEY FK_8A0DF279A76ED395');
$this->addSql('ALTER TABLE company_profile_mapping DROP FOREIGN KEY FK_D5A9C86BA76ED395');
$this->addSql('ALTER TABLE company_profile_name_request DROP FOREIGN KEY FK_D967FDCAA76ED395');
$this->addSql('ALTER TABLE event DROP FOREIGN KEY FK_3BAE0AA7A76ED395');
$this->addSql('ALTER TABLE event_feedback_user DROP FOREIGN KEY FK_6C68876CA76ED395');
$this->addSql('ALTER TABLE event_preparation_user DROP FOREIGN KEY FK_197E6342A76ED395');
$this->addSql('ALTER TABLE job_market DROP FOREIGN KEY FK_3BA8A84AA76ED395');
$this->addSql('ALTER TABLE news DROP FOREIGN KEY FK_1DD399502A98155E');
$this->addSql('ALTER TABLE news DROP FOREIGN KEY FK_1DD39950DA57E237');
$this->addSql('ALTER TABLE news_reminder DROP FOREIGN KEY FK_909EC11A76ED395');
$this->addSql('ALTER TABLE school_class DROP FOREIGN KEY FK_33B1AF854E091857');
$this->addSql('ALTER TABLE school_class_teacher_mapping DROP FOREIGN KEY FK_4288B0BCA76ED395');
$this->addSql('ALTER TABLE school_custom_special_field DROP FOREIGN KEY FK_1B937E1C6AAC5ED4');
$this->addSql('ALTER TABLE school_director_mapping DROP FOREIGN KEY FK_45A6B5DEA76ED395');
$this->addSql('ALTER TABLE school_profile_name_request DROP FOREIGN KEY FK_E21250A2A76ED395');
$this->addSql('ALTER TABLE school_teacher_invitation DROP FOREIGN KEY FK_443D7FE8899FB366');
$this->addSql('ALTER TABLE school_teacher_mapping DROP FOREIGN KEY FK_1A817967A76ED395');
$this->addSql('ALTER TABLE user_role_mapping DROP FOREIGN KEY FK_75E7F573A76ED395');
$this->addSql('ALTER TABLE user_activation_link DROP FOREIGN KEY FK_A932897CA76ED395');
$this->addSql('ALTER TABLE user_data DROP FOREIGN KEY FK_D772BFAAA76ED395');
$this->addSql('ALTER TABLE user_password_change DROP FOREIGN KEY FK_DF620397A76ED395');
$this->addSql('ALTER TABLE user_setting DROP FOREIGN KEY FK_C779A692A76ED395');
$this->addSql('ALTER TABLE rookie_offer DROP FOREIGN KEY FK_8A54E9ADCDBD5067');
$this->addSql('ALTER TABLE rookie_offer_time_slot_mapping DROP FOREIGN KEY FK_2FF41139CDBD5067');
$this->addSql('ALTER TABLE rookie_provider DROP FOREIGN KEY FK_9559D1B3CDBD5067');
$this->addSql('ALTER TABLE user_operator_role_mapping DROP FOREIGN KEY FK_BAE3E398F15E5136');
$this->addSql('ALTER TABLE user_operator_rookie_district_mapping DROP FOREIGN KEY FK_7F9AC30DF15E5136');
$this->addSql('ALTER TABLE user_operator_role_mapping DROP FOREIGN KEY FK_BAE3E3983653B812');
$this->addSql('ALTER TABLE user_role_mapping DROP FOREIGN KEY FK_75E7F5738E0E3CA6');
$this->addSql('ALTER TABLE user_setting DROP FOREIGN KEY FK_C779A6928AEC2E80');
$this->addSql('ALTER TABLE appointment_agreement_entry DROP FOREIGN KEY FK_99D39DD48516439');
$this->addSql('DROP TABLE address');
$this->addSql('DROP TABLE address_city');
$this->addSql('DROP TABLE address_country');
$this->addSql('DROP TABLE address_district');
$this->addSql('DROP TABLE address_lat_lon');
$this->addSql('DROP TABLE address_state');
$this->addSql('DROP TABLE address_type');
$this->addSql('DROP TABLE api_login_information');
$this->addSql('DROP TABLE appointment');
$this->addSql('DROP TABLE appointment_agreement_entry');
$this->addSql('DROP TABLE appointment_individual_mapping');
$this->addSql('DROP TABLE appointment_state');
$this->addSql('DROP TABLE appointment_type');
$this->addSql('DROP TABLE bo_plan');
$this->addSql('DROP TABLE bo_plan_activity_type');
$this->addSql('DROP TABLE bo_plan_reference');
$this->addSql('DROP TABLE bo_plan_state');
$this->addSql('DROP TABLE bo_plan_subject');
$this->addSql('DROP TABLE bo_plan_subject_category');
$this->addSql('DROP TABLE bo_plan_subject_custom');
$this->addSql('DROP TABLE bo_plan_week');
$this->addSql('DROP TABLE bo_plan_week_changes');
$this->addSql('DROP TABLE bo_plan_week_state');
$this->addSql('DROP TABLE booking');
$this->addSql('DROP TABLE booking_additional_information');
$this->addSql('DROP TABLE booking_additional_information_type');
$this->addSql('DROP TABLE booking_proposal');
$this->addSql('DROP TABLE booking_proposal_state');
$this->addSql('DROP TABLE booking_school_custom_special_field_mapping');
$this->addSql('DROP TABLE booking_state');
$this->addSql('DROP TABLE bookmark');
$this->addSql('DROP TABLE bookmark_type');
$this->addSql('DROP TABLE bopartner_contact');
$this->addSql('DROP TABLE bopartner_location');
$this->addSql('DROP TABLE bopartner_profile');
$this->addSql('DROP TABLE bopartner_profile_search_tag_mapping');
$this->addSql('DROP TABLE bopartner_profile_event_mapping');
$this->addSql('DROP TABLE bopartner_profile_mapping');
$this->addSql('DROP TABLE bopartner_profile_name_request');
$this->addSql('DROP TABLE communication');
$this->addSql('DROP TABLE communication_entry');
$this->addSql('DROP TABLE communication_type');
$this->addSql('DROP TABLE company_benefit');
$this->addSql('DROP TABLE company_certificate');
$this->addSql('DROP TABLE company_contact');
$this->addSql('DROP TABLE company_location');
$this->addSql('DROP TABLE company_profile');
$this->addSql('DROP TABLE company_profile_certificate_mapping');
$this->addSql('DROP TABLE company_profile_job_mapping');
$this->addSql('DROP TABLE company_profile_sector_mapping');
$this->addSql('DROP TABLE company_profile_benefit_mapping');
$this->addSql('DROP TABLE company_profile_search_tag_mapping');
$this->addSql('DROP TABLE company_profile_event_mapping');
$this->addSql('DROP TABLE company_profile_mapping');
$this->addSql('DROP TABLE company_profile_name_request');
$this->addSql('DROP TABLE company_size');
$this->addSql('DROP TABLE contact');
$this->addSql('DROP TABLE contact_gallery');
$this->addSql('DROP TABLE contact_gallery_entry');
$this->addSql('DROP TABLE custom_variable');
$this->addSql('DROP TABLE custom_variable_type');
$this->addSql('DROP TABLE event');
$this->addSql('DROP TABLE event_job_mapping');
$this->addSql('DROP TABLE event_search_tag_mapping');
$this->addSql('DROP TABLE event_feedback');
$this->addSql('DROP TABLE event_feedback_answer');
$this->addSql('DROP TABLE event_feedback_question');
$this->addSql('DROP TABLE event_feedback_user');
$this->addSql('DROP TABLE event_preparation');
$this->addSql('DROP TABLE event_preparation_answer');
$this->addSql('DROP TABLE event_preparation_question');
$this->addSql('DROP TABLE event_preparation_user');
$this->addSql('DROP TABLE event_state');
$this->addSql('DROP TABLE event_tag');
$this->addSql('DROP TABLE event_tag_category');
$this->addSql('DROP TABLE event_tag_mapping');
$this->addSql('DROP TABLE faq_category');
$this->addSql('DROP TABLE faq_question');
$this->addSql('DROP TABLE faq_subcategory');
$this->addSql('DROP TABLE file_path');
$this->addSql('DROP TABLE game_jeopardy_question');
$this->addSql('DROP TABLE game_jeopardy_question_school_class_mapping');
$this->addSql('DROP TABLE game_jeopardy_school_class');
$this->addSql('DROP TABLE game_memory_school_class');
$this->addSql('DROP TABLE game_memory_school_class_job_mapping');
$this->addSql('DROP TABLE game_quiz_question');
$this->addSql('DROP TABLE game_quiz_question_category');
$this->addSql('DROP TABLE game_quiz_question_profile_mapping');
$this->addSql('DROP TABLE game_quiz_question_school_class_mapping');
$this->addSql('DROP TABLE game_quiz_school_class');
$this->addSql('DROP TABLE hobby');
$this->addSql('DROP TABLE info_section_category');
$this->addSql('DROP TABLE info_section_entry');
$this->addSql('DROP TABLE info_section_subcategory');
$this->addSql('DROP TABLE info_section_type');
$this->addSql('DROP TABLE job');
$this->addSql('DROP TABLE job_sector_mapping');
$this->addSql('DROP TABLE job_educational_path_mapping');
$this->addSql('DROP TABLE job_workfield_mapping');
$this->addSql('DROP TABLE job_search_tag_mapping');
$this->addSql('DROP TABLE job_ams');
$this->addSql('DROP TABLE job_daily_routine');
$this->addSql('DROP TABLE job_daily_routine_category');
$this->addSql('DROP TABLE job_daily_routine_entry');
$this->addSql('DROP TABLE job_educational_path');
$this->addSql('DROP TABLE job_link');
$this->addSql('DROP TABLE job_link_mapping');
$this->addSql('DROP TABLE job_link_mapping_category');
$this->addSql('DROP TABLE job_link_mapping_type');
$this->addSql('DROP TABLE job_market');
$this->addSql('DROP TABLE job_market_job_mapping');
$this->addSql('DROP TABLE job_market_apply_type');
$this->addSql('DROP TABLE job_market_position_type');
$this->addSql('DROP TABLE job_market_start_type');
$this->addSql('DROP TABLE job_market_state');
$this->addSql('DROP TABLE job_school');
$this->addSql('DROP TABLE job_sector');
$this->addSql('DROP TABLE job_sector_image');
$this->addSql('DROP TABLE job_workfield');
$this->addSql('DROP TABLE job_workfield_image');
$this->addSql('DROP TABLE lebenslauf');
$this->addSql('DROP TABLE media__gallery');
$this->addSql('DROP TABLE media__gallery_media');
$this->addSql('DROP TABLE media__media');
$this->addSql('DROP TABLE media_gallery_category');
$this->addSql('DROP TABLE misc_file');
$this->addSql('DROP TABLE news');
$this->addSql('DROP TABLE news_message');
$this->addSql('DROP TABLE news_reminder');
$this->addSql('DROP TABLE news_type');
$this->addSql('DROP TABLE person');
$this->addSql('DROP TABLE person_title_mapping');
$this->addSql('DROP TABLE profile_type');
$this->addSql('DROP TABLE rookie_address');
$this->addSql('DROP TABLE rookie_booking');
$this->addSql('DROP TABLE rookie_communication');
$this->addSql('DROP TABLE rookie_contact');
$this->addSql('DROP TABLE rookie_contact_type');
$this->addSql('DROP TABLE rookie_district');
$this->addSql('DROP TABLE rookie_offer');
$this->addSql('DROP TABLE rookie_offer_time_slot_mapping');
$this->addSql('DROP TABLE rookie_person');
$this->addSql('DROP TABLE rookie_person_address_mapping');
$this->addSql('DROP TABLE rookie_person_communication_mapping');
$this->addSql('DROP TABLE rookie_provider');
$this->addSql('DROP TABLE rookie_provider_contact_mapping');
$this->addSql('DROP TABLE rookie_provider_location');
$this->addSql('DROP TABLE rookie_provider_register_time');
$this->addSql('DROP TABLE rookie_school');
$this->addSql('DROP TABLE rookie_school_class');
$this->addSql('DROP TABLE rookie_school_contact_mapping');
$this->addSql('DROP TABLE rookie_time_slot');
$this->addSql('DROP TABLE rookie_time_slot_state');
$this->addSql('DROP TABLE school');
$this->addSql('DROP TABLE school_type_mapping');
$this->addSql('DROP TABLE school_award_mapping');
$this->addSql('DROP TABLE school_award');
$this->addSql('DROP TABLE school_benefit');
$this->addSql('DROP TABLE school_class');
$this->addSql('DROP TABLE school_class_custom_special_field_mapping');
$this->addSql('DROP TABLE school_class_grade');
$this->addSql('DROP TABLE school_class_state');
$this->addSql('DROP TABLE school_class_teacher_mapping');
$this->addSql('DROP TABLE school_class_year');
$this->addSql('DROP TABLE school_contact');
$this->addSql('DROP TABLE school_custom_special_field');
$this->addSql('DROP TABLE school_custom_special_field_special_field_mapping');
$this->addSql('DROP TABLE school_director_mapping');
$this->addSql('DROP TABLE school_location');
$this->addSql('DROP TABLE school_profile');
$this->addSql('DROP TABLE school_profile_job_mapping');
$this->addSql('DROP TABLE school_profile_benefit_mapping');
$this->addSql('DROP TABLE school_profile_search_tag_mapping');
$this->addSql('DROP TABLE school_profile_event_mapping');
$this->addSql('DROP TABLE school_profile_name_request');
$this->addSql('DROP TABLE school_role');
$this->addSql('DROP TABLE school_special_field');
$this->addSql('DROP TABLE school_subject');
$this->addSql('DROP TABLE school_teacher_invitation');
$this->addSql('DROP TABLE school_teacher_invitation_role_mapping');
$this->addSql('DROP TABLE school_teacher_invitation_state');
$this->addSql('DROP TABLE school_teacher_mapping');
$this->addSql('DROP TABLE school_teacher_role_mapping');
$this->addSql('DROP TABLE school_type');
$this->addSql('DROP TABLE school_type_category');
$this->addSql('DROP TABLE score');
$this->addSql('DROP TABLE score_type');
$this->addSql('DROP TABLE search_tag');
$this->addSql('DROP TABLE shuttle_booking');
$this->addSql('DROP TABLE shuttle_company');
$this->addSql('DROP TABLE shuttle_company_job_mapping');
$this->addSql('DROP TABLE shuttle_company_date_mapping');
$this->addSql('DROP TABLE shuttle_contact');
$this->addSql('DROP TABLE shuttle_date');
$this->addSql('DROP TABLE shuttle_date_state');
$this->addSql('DROP TABLE shuttle_duration');
$this->addSql('DROP TABLE shuttle_school');
$this->addSql('DROP TABLE shuttle_tour');
$this->addSql('DROP TABLE shuttle_tour_school_mapping');
$this->addSql('DROP TABLE slider_item');
$this->addSql('DROP TABLE switch_user_token');
$this->addSql('DROP TABLE tesis_picta_group');
$this->addSql('DROP TABLE tesis_picta_group_sector_mapping');
$this->addSql('DROP TABLE tirol_tv_video');
$this->addSql('DROP TABLE title');
$this->addSql('DROP TABLE title_type');
$this->addSql('DROP TABLE user');
$this->addSql('DROP TABLE user_role_mapping');
$this->addSql('DROP TABLE user_activation_link');
$this->addSql('DROP TABLE user_data');
$this->addSql('DROP TABLE user_operator');
$this->addSql('DROP TABLE user_operator_role_mapping');
$this->addSql('DROP TABLE user_operator_role');
$this->addSql('DROP TABLE user_operator_rookie_district_mapping');
$this->addSql('DROP TABLE user_password_change');
$this->addSql('DROP TABLE user_role');
$this->addSql('DROP TABLE user_setting');
$this->addSql('DROP TABLE weekday');
}
}