<?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 Version20220501092021 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 accounting_account (id INT AUTO_INCREMENT NOT NULL, parent_id INT DEFAULT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, description LONGTEXT DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_44BEAB93727ACA70 (parent_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE accounting_expense (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, salary_id INT DEFAULT NULL, cash_register_id INT DEFAULT NULL, cash_movement_id INT DEFAULT NULL, account_id INT DEFAULT NULL, school_year_id INT NOT NULL, `label` VARCHAR(128) NOT NULL, amount DOUBLE PRECISION NOT NULL, is_submited TINYINT(1) NOT NULL, is_aproved TINYINT(1) NOT NULL, is_canceled TINYINT(1) NOT NULL, is_paid TINYINT(1) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_14B270918565851 (establishment_id), INDEX IDX_14B27091B0FDF16E (salary_id), INDEX IDX_14B27091A917CC69 (cash_register_id), UNIQUE INDEX UNIQ_14B27091C2FF77B0 (cash_movement_id), INDEX IDX_14B270919B6B5FBA (account_id), INDEX IDX_14B27091D2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE accounting_student_registration_fee (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, student_registration_id INT NOT NULL, fee_id INT NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, amount DOUBLE PRECISION NOT NULL, last_amount_paid DOUBLE PRECISION DEFAULT NULL, last_payment_id INT DEFAULT NULL, last_payment_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, amount_cancel DOUBLE PRECISION DEFAULT NULL, is_cancel TINYINT(1) NOT NULL, INDEX IDX_D7A54C468565851 (establishment_id), INDEX IDX_D7A54C46DF990765 (student_registration_id), INDEX IDX_D7A54C46AB45AECA (fee_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE accounting_student_registration_fee_shedul (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, student_registration_fee_id INT NOT NULL, order_num INT NOT NULL, date_due DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', amount DOUBLE PRECISION NOT NULL, amount_paid DOUBLE PRECISION DEFAULT NULL, last_amount_paid DOUBLE PRECISION DEFAULT NULL, last_payment_id INT DEFAULT NULL, last_payment_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, amount_cancel DOUBLE PRECISION DEFAULT NULL, is_cancel TINYINT(1) NOT NULL, INDEX IDX_656ADA5C8565851 (establishment_id), INDEX IDX_656ADA5CC7D2B0C8 (student_registration_fee_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE accounting_student_registration_fee_shedul_payment (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, student_registration_fee_id INT NOT NULL, student_registration_fee_shedul_id INT NOT NULL, cash_movement_id INT NOT NULL, cash_register_id INT NOT NULL, accounting_account_id INT DEFAULT NULL, student_registration_payment_id INT NOT NULL, amount DOUBLE PRECISION NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_ECE70BF38565851 (establishment_id), INDEX IDX_ECE70BF3C7D2B0C8 (student_registration_fee_id), INDEX IDX_ECE70BF39D932FE9 (student_registration_fee_shedul_id), UNIQUE INDEX UNIQ_ECE70BF3C2FF77B0 (cash_movement_id), INDEX IDX_ECE70BF3A917CC69 (cash_register_id), INDEX IDX_ECE70BF3F83E3874 (accounting_account_id), INDEX IDX_ECE70BF3C276D4E4 (student_registration_payment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE accounting_student_registration_payment (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, student_registration_id INT NOT NULL, cash_register_id INT NOT NULL, school_year_id INT NOT NULL, code VARCHAR(60) NOT NULL, method VARCHAR(60) DEFAULT NULL, memo VARCHAR(128) DEFAULT NULL, amount DOUBLE PRECISION NOT NULL, create_at DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_3CB5E7FA8565851 (establishment_id), INDEX IDX_3CB5E7FADF990765 (student_registration_id), INDEX IDX_3CB5E7FAA917CC69 (cash_register_id), INDEX IDX_3CB5E7FAD2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE canteen_dish (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_AA233F7C8565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE canteen_menu (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, date_start DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', date_end DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_425B89578565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE canteen_menu_item (id INT AUTO_INCREMENT NOT NULL, canteen_time_id INT NOT NULL, day_1_dish_id INT DEFAULT NULL, day_2_dish_id INT DEFAULT NULL, day_3_dish_id INT DEFAULT NULL, day_4_dish_id INT DEFAULT NULL, day_5_dish_id INT DEFAULT NULL, day_6_dish_id INT DEFAULT NULL, day_7_dish_id INT DEFAULT NULL, establishment_id INT NOT NULL, canteen_menu_id INT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_FAFA53B98B776210 (canteen_time_id), INDEX IDX_FAFA53B983173DD0 (day_1_dish_id), INDEX IDX_FAFA53B9BA9A0115 (day_2_dish_id), INDEX IDX_FAFA53B9ADE11556 (day_3_dish_id), INDEX IDX_FAFA53B9C980789F (day_4_dish_id), INDEX IDX_FAFA53B9DEFB6CDC (day_5_dish_id), INDEX IDX_FAFA53B9E7765019 (day_6_dish_id), INDEX IDX_FAFA53B9F00D445A (day_7_dish_id), INDEX IDX_FAFA53B98565851 (establishment_id), INDEX IDX_FAFA53B9194A5639 (canteen_menu_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE canteen_stock_movement (id INT AUTO_INCREMENT NOT NULL, canteen_utensil_id INT NOT NULL, establishment_id INT NOT NULL, type VARCHAR(30) NOT NULL, quantity DOUBLE PRECISION NOT NULL, pattern VARCHAR(255) DEFAULT NULL, create_date DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_A521A77935B8E784 (canteen_utensil_id), INDEX IDX_A521A7798565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE canteen_time (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_50CA2B818565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE canteen_utensil (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, name VARCHAR(128) NOT NULL, quantity DOUBLE PRECISION NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_4AB583978565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE communication_message (id INT AUTO_INCREMENT NOT NULL, establishment_id INT DEFAULT NULL, school_year_id INT DEFAULT NULL, communication_predefined_message_id INT DEFAULT NULL, code VARCHAR(255) NOT NULL, content LONGTEXT NOT NULL, type VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, contacts LONGTEXT NOT NULL COMMENT \'(DC2Type:array)\', resultats LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:array)\', is_sended TINYINT(1) DEFAULT NULL, size INT DEFAULT NULL, number_sms INT DEFAULT NULL, coast_sms DOUBLE PRECISION DEFAULT NULL, is_only_for_new_student TINYINT(1) NOT NULL, INDEX IDX_C36C19258565851 (establishment_id), INDEX IDX_C36C1925D2EECC3F (school_year_id), INDEX IDX_C36C1925A1B4F640 (communication_predefined_message_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE communication_message_registration_student_registration (communication_message_id INT NOT NULL, registration_student_registration_id INT NOT NULL, INDEX IDX_64B41D5687C3C593 (communication_message_id), INDEX IDX_64B41D56B0396129 (registration_student_registration_id), PRIMARY KEY(communication_message_id, registration_student_registration_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE communication_message_setting_classroom (communication_message_id INT NOT NULL, setting_classroom_id INT NOT NULL, INDEX IDX_1C276FC087C3C593 (communication_message_id), INDEX IDX_1C276FC07AF43AAE (setting_classroom_id), PRIMARY KEY(communication_message_id, setting_classroom_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE communication_message_setting_level (communication_message_id INT NOT NULL, setting_level_id INT NOT NULL, INDEX IDX_1354AE2387C3C593 (communication_message_id), INDEX IDX_1354AE23F138735D (setting_level_id), PRIMARY KEY(communication_message_id, setting_level_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE communication_message_transport_zone (communication_message_id INT NOT NULL, transport_zone_id INT NOT NULL, INDEX IDX_6197E07187C3C593 (communication_message_id), INDEX IDX_6197E071BFBFF5A (transport_zone_id), PRIMARY KEY(communication_message_id, transport_zone_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE communication_message_setting_fee (communication_message_id INT NOT NULL, setting_fee_id INT NOT NULL, INDEX IDX_27D16A087C3C593 (communication_message_id), INDEX IDX_27D16A091B957F7 (setting_fee_id), PRIMARY KEY(communication_message_id, setting_fee_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE communication_message_rh_salary (communication_message_id INT NOT NULL, rh_salary_id INT NOT NULL, INDEX IDX_55246A3E87C3C593 (communication_message_id), INDEX IDX_55246A3E4758967C (rh_salary_id), PRIMARY KEY(communication_message_id, rh_salary_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE communication_message_rh_department (communication_message_id INT NOT NULL, rh_department_id INT NOT NULL, INDEX IDX_FE45A4F487C3C593 (communication_message_id), INDEX IDX_FE45A4F4E9A1987D (rh_department_id), PRIMARY KEY(communication_message_id, rh_department_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE communication_message_rh_job (communication_message_id INT NOT NULL, rh_job_id INT NOT NULL, INDEX IDX_B1C86EB487C3C593 (communication_message_id), INDEX IDX_B1C86EB454ED32A7 (rh_job_id), PRIMARY KEY(communication_message_id, rh_job_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE communication_message_rh_statut (communication_message_id INT NOT NULL, rh_statut_id INT NOT NULL, INDEX IDX_245321F087C3C593 (communication_message_id), INDEX IDX_245321F01855F16 (rh_statut_id), PRIMARY KEY(communication_message_id, rh_statut_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE communication_predefined_message (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, code VARCHAR(60) NOT NULL, content LONGTEXT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_DB930C038565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE entre_test_report_card (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, level_id INT NOT NULL, school_year_id INT NOT NULL, create_at DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', `label` VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, average_on DOUBLE PRECISION DEFAULT NULL, INDEX IDX_C59B67338565851 (establishment_id), INDEX IDX_C59B67335FB14BA7 (level_id), INDEX IDX_C59B6733D2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE establishment (id INT AUTO_INCREMENT NOT NULL, establishment_group_id INT NOT NULL, code VARCHAR(60) NOT NULL, name VARCHAR(128) NOT NULL, type VARCHAR(128) NOT NULL, phone_number VARCHAR(128) DEFAULT NULL, mobile_number VARCHAR(128) DEFAULT NULL, email VARCHAR(128) DEFAULT NULL, website VARCHAR(128) DEFAULT NULL, address VARCHAR(128) DEFAULT NULL, location VARCHAR(128) DEFAULT NULL, under_supervision LONGTEXT DEFAULT NULL, main_activity LONGTEXT DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, image VARCHAR(255) DEFAULT NULL, INDEX IDX_DBEFB1EEB52D2A75 (establishment_group_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE establishment_group (id INT AUTO_INCREMENT NOT NULL, transportation_manager_id INT DEFAULT NULL, code VARCHAR(60) NOT NULL, name VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, phone_number VARCHAR(128) DEFAULT NULL, mobile_number VARCHAR(128) DEFAULT NULL, email VARCHAR(128) DEFAULT NULL, website VARCHAR(128) DEFAULT NULL, address VARCHAR(128) DEFAULT NULL, location VARCHAR(128) DEFAULT NULL, under_supervision LONGTEXT DEFAULT NULL, image VARCHAR(255) DEFAULT NULL, INDEX IDX_E9D178B0E4919C9B (transportation_manager_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE matter_average_pre_registration_entry_test (id INT AUTO_INCREMENT NOT NULL, matter_id INT NOT NULL, establishment_id INT NOT NULL, pre_registration_entre_test_report_card_id INT NOT NULL, note DOUBLE PRECISION NOT NULL, note_on DOUBLE PRECISION NOT NULL, order_num INT NOT NULL, coefficient DOUBLE PRECISION NOT NULL, `label` VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, INDEX IDX_4600CF30D614E59F (matter_id), INDEX IDX_4600CF308565851 (establishment_id), INDEX IDX_4600CF305A800598 (pre_registration_entre_test_report_card_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE pre_registration_entre_test_report_card (id INT AUTO_INCREMENT NOT NULL, registration_student_pre_registration_id INT NOT NULL, entre_test_report_card_id INT NOT NULL, establishment_id INT NOT NULL, level_id INT NOT NULL, school_year_id INT NOT NULL, create_at DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', `label` VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, total_note DOUBLE PRECISION DEFAULT NULL, average DOUBLE PRECISION DEFAULT NULL, final_decision VARCHAR(60) DEFAULT NULL, INDEX IDX_3FF2F412D7374135 (registration_student_pre_registration_id), INDEX IDX_3FF2F412D0D2990 (entre_test_report_card_id), INDEX IDX_3FF2F4128565851 (establishment_id), INDEX IDX_3FF2F4125FB14BA7 (level_id), INDEX IDX_3FF2F412D2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE registration_class_change (id INT AUTO_INCREMENT NOT NULL, student_registration_id INT NOT NULL, classroom_id INT NOT NULL, school_year_id INT NOT NULL, establishment_id INT NOT NULL, original_classroom_id INT NOT NULL, pattern LONGTEXT NOT NULL, doc VARCHAR(255) DEFAULT NULL, is_submit TINYINT(1) NOT NULL, is_validate TINYINT(1) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, INDEX IDX_29F5645CDF990765 (student_registration_id), INDEX IDX_29F5645C6278D5A8 (classroom_id), INDEX IDX_29F5645CD2EECC3F (school_year_id), INDEX IDX_29F5645C8565851 (establishment_id), INDEX IDX_29F5645CB934139E (original_classroom_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE registration_diet (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, registration_student_id INT NOT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_52DA72FC8565851 (establishment_id), INDEX IDX_52DA72FCF6AF8633 (registration_student_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE registration_student (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, entry_level_id INT DEFAULT NULL, medical_history_id INT DEFAULT NULL, learning_difficulty_id INT DEFAULT NULL, code VARCHAR(60) NOT NULL, last_name VARCHAR(128) NOT NULL, first_name VARCHAR(128) NOT NULL, notification_phone_number VARCHAR(60) DEFAULT NULL, notification_name VARCHAR(60) DEFAULT NULL, notification_watsapp_number VARCHAR(60) DEFAULT NULL, observation TINYTEXT DEFAULT NULL, location VARCHAR(128) DEFAULT NULL, gender VARCHAR(60) DEFAULT NULL, birthday DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', birth_location VARCHAR(128) DEFAULT NULL, birth_certificate_number VARCHAR(128) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, image VARCHAR(255) DEFAULT NULL, create_date DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', is_affected TINYINT(1) NOT NULL, is_redoubling TINYINT(1) NOT NULL, last_school_attended VARCHAR(128) DEFAULT NULL, last_school_attended_type VARCHAR(128) DEFAULT NULL, registration_number VARCHAR(60) NOT NULL, lv1 VARCHAR(60) DEFAULT NULL, lv2 VARCHAR(60) DEFAULT NULL, nationality VARCHAR(60) DEFAULT NULL, where_resides VARCHAR(60) DEFAULT NULL, parent_status VARCHAR(60) DEFAULT NULL, is_parntal_authority_father TINYINT(1) NOT NULL, is_father_call_to_emergency TINYINT(1) NOT NULL, father_last_name VARCHAR(60) DEFAULT NULL, father_first_name VARCHAR(60) DEFAULT NULL, father_address VARCHAR(128) DEFAULT NULL, father_phone_number VARCHAR(60) DEFAULT NULL, father_post VARCHAR(128) DEFAULT NULL, father_location VARCHAR(128) DEFAULT NULL, father_email VARCHAR(128) DEFAULT NULL, is_parntal_authority_mother TINYINT(1) NOT NULL, is_mother_call_to_emergency TINYINT(1) NOT NULL, mother_last_name VARCHAR(60) DEFAULT NULL, mother_first_name VARCHAR(60) DEFAULT NULL, mother_address VARCHAR(128) DEFAULT NULL, mother_phone_number VARCHAR(60) DEFAULT NULL, mother_post VARCHAR(128) DEFAULT NULL, mother_location VARCHAR(128) DEFAULT NULL, mother_email VARCHAR(128) DEFAULT NULL, responsible_of_schooling VARCHAR(60) DEFAULT NULL, responsible_of_schooling_last_name VARCHAR(60) DEFAULT NULL, responsible_of_schooling_first_name VARCHAR(60) DEFAULT NULL, responsible_of_schooling_address VARCHAR(128) DEFAULT NULL, responsible_of_schooling_phone_number VARCHAR(60) DEFAULT NULL, responsible_of_schooling_post VARCHAR(128) DEFAULT NULL, responsible_of_schooling_location VARCHAR(128) DEFAULT NULL, accompanying_person_name VARCHAR(128) DEFAULT NULL, accompanying_person_phone_number VARCHAR(128) DEFAULT NULL, accompanying_person_name_2 VARCHAR(128) DEFAULT NULL, accompanying_person_phone_number_2 VARCHAR(128) DEFAULT NULL, accompanying_person_name_3 VARCHAR(128) DEFAULT NULL, accompanying_person_phone_number_3 VARCHAR(128) DEFAULT NULL, doctor_name VARCHAR(128) DEFAULT NULL, doctor_phone_number VARCHAR(60) DEFAULT NULL, other_medical_history VARCHAR(128) DEFAULT NULL, other_learning_difficulty VARCHAR(128) DEFAULT NULL, teacher_observation LONGTEXT DEFAULT NULL, parent_observation LONGTEXT DEFAULT NULL, INDEX IDX_F752FA958565851 (establishment_id), INDEX IDX_F752FA9531F6ABEF (entry_level_id), INDEX IDX_F752FA953544AD9E (medical_history_id), INDEX IDX_F752FA95951AAEC (learning_difficulty_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE registration_student_abandonment (id INT AUTO_INCREMENT NOT NULL, registration_student_registration_id INT NOT NULL, establishment_id INT NOT NULL, pattern LONGTEXT NOT NULL, is_validated TINYINT(1) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_A4724247B0396129 (registration_student_registration_id), INDEX IDX_A47242478565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE registration_student_abandonment_line (id INT AUTO_INCREMENT NOT NULL, registration_student_abandonment_id INT NOT NULL, accounting_student_registration_fee_id INT NOT NULL, establishment_id INT NOT NULL, amount DOUBLE PRECISION NOT NULL, amount_paid DOUBLE PRECISION NOT NULL, amount_rest DOUBLE PRECISION NOT NULL, `label` VARCHAR(128) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_CAE115D16FD06346 (registration_student_abandonment_id), INDEX IDX_CAE115D1E82663FB (accounting_student_registration_fee_id), INDEX IDX_CAE115D18565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE registration_student_downgrade (id INT AUTO_INCREMENT NOT NULL, registration_student_registration_id INT NOT NULL, starting_classroom_id INT NOT NULL, destination_classroom_id INT NOT NULL, establishment_id INT NOT NULL, pattern LONGTEXT NOT NULL, is_validated TINYINT(1) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_B518F4EFB0396129 (registration_student_registration_id), INDEX IDX_B518F4EF61A68B7A (starting_classroom_id), INDEX IDX_B518F4EFD3560E67 (destination_classroom_id), INDEX IDX_B518F4EF8565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE registration_student_downgrade_line (id INT AUTO_INCREMENT NOT NULL, registration_student_downgrade_id INT NOT NULL, accounting_student_registration_fee_id INT NOT NULL, establishment_id INT NOT NULL, amount DOUBLE PRECISION NOT NULL, amount_paid DOUBLE PRECISION NOT NULL, amount_rest DOUBLE PRECISION NOT NULL, `label` VARCHAR(128) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_A436BD26A743EEF7 (registration_student_downgrade_id), INDEX IDX_A436BD26E82663FB (accounting_student_registration_fee_id), INDEX IDX_A436BD268565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE registration_student_pre_registration (id INT AUTO_INCREMENT NOT NULL, student_id INT DEFAULT NULL, establishment_id INT NOT NULL, entry_level_id INT DEFAULT NULL, school_year_id INT NOT NULL, code VARCHAR(60) NOT NULL, last_name VARCHAR(128) NOT NULL, first_name VARCHAR(128) NOT NULL, notification_phone_number VARCHAR(60) DEFAULT NULL, notification_name VARCHAR(60) DEFAULT NULL, notification_watsapp_number VARCHAR(60) DEFAULT NULL, observation TINYTEXT DEFAULT NULL, location VARCHAR(128) DEFAULT NULL, gender VARCHAR(60) DEFAULT NULL, birthday DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', birth_certificate_number VARCHAR(128) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT DEFAULT NULL, updated_by INT DEFAULT NULL, image VARCHAR(255) DEFAULT NULL, create_date DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', is_affected TINYINT(1) NOT NULL, is_redoubling TINYINT(1) NOT NULL, last_school_attended VARCHAR(128) DEFAULT NULL, last_school_attended_type VARCHAR(128) DEFAULT NULL, birth_location VARCHAR(128) DEFAULT NULL, is_subject_entry_test TINYINT(1) NOT NULL, is_entry_test_done TINYINT(1) NOT NULL, is_entry_test_performed TINYINT(1) NOT NULL, entry_test_result VARCHAR(128) DEFAULT NULL, is_subject_toxicological_test TINYINT(1) NOT NULL, is_toxicological_test_performed TINYINT(1) NOT NULL, toxicological_test_result VARCHAR(128) DEFAULT NULL, is_subject_psychological_test TINYINT(1) NOT NULL, is_psychological_test_performed TINYINT(1) NOT NULL, psychological_test_result VARCHAR(128) DEFAULT NULL, registration_number VARCHAR(60) NOT NULL, lv1 VARCHAR(60) DEFAULT NULL, lv2 VARCHAR(60) DEFAULT NULL, nationality VARCHAR(60) DEFAULT NULL, where_resides VARCHAR(60) DEFAULT NULL, parent_status VARCHAR(60) DEFAULT NULL, is_parntal_authority_father TINYINT(1) NOT NULL, is_father_call_to_emergency TINYINT(1) NOT NULL, father_last_name VARCHAR(60) DEFAULT NULL, father_first_name VARCHAR(60) DEFAULT NULL, father_address VARCHAR(128) DEFAULT NULL, father_phone_number VARCHAR(60) DEFAULT NULL, father_post VARCHAR(128) DEFAULT NULL, father_location VARCHAR(128) DEFAULT NULL, father_email VARCHAR(128) DEFAULT NULL, is_parntal_authority_mother TINYINT(1) NOT NULL, is_mother_call_to_emergency TINYINT(1) NOT NULL, mother_last_name VARCHAR(60) DEFAULT NULL, mother_first_name VARCHAR(60) DEFAULT NULL, mother_address VARCHAR(128) DEFAULT NULL, mother_phone_number VARCHAR(60) DEFAULT NULL, mother_post VARCHAR(128) DEFAULT NULL, mother_location VARCHAR(128) DEFAULT NULL, mother_email VARCHAR(128) DEFAULT NULL, responsible_of_schooling VARCHAR(60) DEFAULT NULL, responsible_of_schooling_last_name VARCHAR(60) DEFAULT NULL, responsible_of_schooling_first_name VARCHAR(60) DEFAULT NULL, responsible_of_schooling_address VARCHAR(128) DEFAULT NULL, responsible_of_schooling_phone_number VARCHAR(60) DEFAULT NULL, responsible_of_schooling_post VARCHAR(128) DEFAULT NULL, responsible_of_schooling_location VARCHAR(128) DEFAULT NULL, is_need_canteen TINYINT(1) NOT NULL, is_need_transport TINYINT(1) NOT NULL, is_need_keep TINYINT(1) NOT NULL, is_need_extrat_activity TINYINT(1) NOT NULL, hold_student_id INT DEFAULT NULL, accompanying_person_name VARCHAR(128) DEFAULT NULL, accompanying_person_phone_number VARCHAR(128) DEFAULT NULL, accompanying_person_name_2 VARCHAR(128) DEFAULT NULL, accompanying_person_phone_number_2 VARCHAR(128) DEFAULT NULL, accompanying_person_name_3 VARCHAR(128) DEFAULT NULL, accompanying_person_phone_number_3 VARCHAR(128) DEFAULT NULL, final_decision_note LONGTEXT DEFAULT NULL, INDEX IDX_FAA7D11CB944F1A (student_id), INDEX IDX_FAA7D118565851 (establishment_id), INDEX IDX_FAA7D1131F6ABEF (entry_level_id), INDEX IDX_FAA7D11D2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE registration_student_pre_registration_setting_level (registration_student_pre_registration_id INT NOT NULL, setting_level_id INT NOT NULL, INDEX IDX_7B4E1603D7374135 (registration_student_pre_registration_id), INDEX IDX_7B4E1603F138735D (setting_level_id), PRIMARY KEY(registration_student_pre_registration_id, setting_level_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE registration_student_registration (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, student_id INT NOT NULL, school_year_id INT NOT NULL, classroom_id INT NOT NULL, registration_student_pre_registration_id INT DEFAULT NULL, is_redoubling TINYINT(1) NOT NULL, is_diet TINYINT(1) NOT NULL, is_internal TINYINT(1) NOT NULL, is_affected TINYINT(1) NOT NULL, registered_at DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, last_amount_paid DOUBLE PRECISION DEFAULT NULL, last_payment_id INT DEFAULT NULL, last_payment_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', image VARCHAR(255) DEFAULT NULL, is_abandonned TINYINT(1) NOT NULL, as_food_restrictions TINYINT(1) NOT NULL, is_meatless_menu TINYINT(1) NOT NULL, is_menu_without_pork TINYINT(1) NOT NULL, is_can_eat_alone TINYINT(1) NOT NULL, is_can_do_his_business_alone TINYINT(1) NOT NULL, is_falls_sleep_easily TINYINT(1) NOT NULL, is_new TINYINT(1) NOT NULL, portal_login VARCHAR(60) DEFAULT NULL, portal_password VARCHAR(60) DEFAULT NULL, INDEX IDX_4D4900A08565851 (establishment_id), INDEX IDX_4D4900A0CB944F1A (student_id), INDEX IDX_4D4900A0D2EECC3F (school_year_id), INDEX IDX_4D4900A06278D5A8 (classroom_id), INDEX IDX_4D4900A0D7374135 (registration_student_pre_registration_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE registration_student_registration_setting_document_to_provide (registration_student_registration_id INT NOT NULL, setting_document_to_provide_id INT NOT NULL, INDEX IDX_E586E457B0396129 (registration_student_registration_id), INDEX IDX_E586E45723FCFF00 (setting_document_to_provide_id), PRIMARY KEY(registration_student_registration_id, setting_document_to_provide_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE registration_transport_checkpoint (id INT AUTO_INCREMENT NOT NULL, transport_zone_id INT NOT NULL, transport_vehicle_id INT NOT NULL, transport_zone_check_point_id INT NOT NULL, establishment_id INT NOT NULL, registration_student_registration_id INT NOT NULL, morning_schedule VARCHAR(30) DEFAULT NULL, evening_schedule VARCHAR(30) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_DE746844BFBFF5A (transport_zone_id), INDEX IDX_DE74684433189E9B (transport_vehicle_id), INDEX IDX_DE746844CDF7E6B1 (transport_zone_check_point_id), INDEX IDX_DE7468448565851 (establishment_id), INDEX IDX_DE746844B0396129 (registration_student_registration_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE report_card (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, school_year_periode_id INT NOT NULL, level_id INT NOT NULL, coefficient DOUBLE PRECISION NOT NULL, order_num INT NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_653875288565851 (establishment_id), INDEX IDX_65387528D2EECC3F (school_year_id), INDEX IDX_65387528D17A6B27 (school_year_periode_id), INDEX IDX_653875285FB14BA7 (level_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rh_department (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, code VARCHAR(60) NOT NULL, name VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_3E5335A58565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rh_job (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, code VARCHAR(60) NOT NULL, name VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_C99D17FB8565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rh_non_taxable_item (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, based DOUBLE PRECISION NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_D6D91C498565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rh_pay_slip (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_6990DECB8565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rh_pay_slip_non_taxable_item (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, rh_salary_pay_slip_id INT NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, based DOUBLE PRECISION NOT NULL, profit DOUBLE PRECISION NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, INDEX IDX_F7D693A08565851 (establishment_id), INDEX IDX_F7D693A03C290DE6 (rh_salary_pay_slip_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rh_pay_slip_retained_item (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, rh_salary_pay_slip_id INT NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, compute_method VARCHAR(128) NOT NULL, type VARCHAR(128) NOT NULL, based DOUBLE PRECISION NOT NULL, profit DOUBLE PRECISION NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_D84784AD8565851 (establishment_id), INDEX IDX_D84784AD3C290DE6 (rh_salary_pay_slip_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rh_pay_slip_taxable_item (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, rh_salary_pay_slip_id INT NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, compute_method VARCHAR(128) NOT NULL, based DOUBLE PRECISION NOT NULL, profit DOUBLE PRECISION NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_80A5899B8565851 (establishment_id), INDEX IDX_80A5899B3C290DE6 (rh_salary_pay_slip_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rh_retained_item (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, type VARCHAR(128) NOT NULL, compute_method VARCHAR(128) NOT NULL, based DOUBLE PRECISION NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_A984BEA88565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rh_salary (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, user_id INT NOT NULL, rh_job_id INT DEFAULT NULL, rh_department_id INT DEFAULT NULL, statut_id INT DEFAULT NULL, code VARCHAR(60) NOT NULL, last_name VARCHAR(128) NOT NULL, first_name VARCHAR(128) NOT NULL, gender VARCHAR(128) DEFAULT NULL, phone_number VARCHAR(128) DEFAULT NULL, mobile_number VARCHAR(128) DEFAULT NULL, email VARCHAR(128) DEFAULT NULL, address VARCHAR(128) DEFAULT NULL, location VARCHAR(128) DEFAULT NULL, birth_day DATE DEFAULT NULL COMMENT \'(DC2Type:date_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, image VARCHAR(255) DEFAULT NULL, hiring_date DATE DEFAULT NULL COMMENT \'(DC2Type:date_immutable)\', date_of_departure DATE DEFAULT NULL COMMENT \'(DC2Type:date_immutable)\', INDEX IDX_CB1EC77F8565851 (establishment_id), UNIQUE INDEX UNIQ_CB1EC77FA76ED395 (user_id), INDEX IDX_CB1EC77F54ED32A7 (rh_job_id), INDEX IDX_CB1EC77FE9A1987D (rh_department_id), INDEX IDX_CB1EC77FF6203804 (statut_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rh_salary_pay_slip (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, rh_salary_id INT NOT NULL, rh_pay_slip_id INT NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_93D79FF18565851 (establishment_id), INDEX IDX_93D79FF14758967C (rh_salary_id), INDEX IDX_93D79FF1140FC72D (rh_pay_slip_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rh_statut (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, name VARCHAR(128) NOT NULL, INDEX IDX_BA698CB18565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE rh_taxable_item (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, compute_method VARCHAR(128) NOT NULL, based DOUBLE PRECISION NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_F21A05DF8565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_absence_and_delay (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, school_year_periode_id INT NOT NULL, student_registration_id INT NOT NULL, create_date DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', situation VARCHAR(255) NOT NULL, duration INT NOT NULL, duration_type VARCHAR(255) NOT NULL, is_justify TINYINT(1) NOT NULL, observation LONGTEXT DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_AC0DAEB68565851 (establishment_id), INDEX IDX_AC0DAEB6D2EECC3F (school_year_id), INDEX IDX_AC0DAEB6D17A6B27 (school_year_periode_id), INDEX IDX_AC0DAEB6DF990765 (student_registration_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_absence_and_delay_notification (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, create_date DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_BCEC3D88565851 (establishment_id), INDEX IDX_BCEC3D8D2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_absence_and_delay_notification_line (id INT AUTO_INCREMENT NOT NULL, school_absence_and_delay_notification_id INT NOT NULL, school_absence_and_delay_id INT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, create_date DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, is_sms_sended TINYINT(1) NOT NULL, INDEX IDX_2989D31C79D0CA89 (school_absence_and_delay_notification_id), INDEX IDX_2989D31CE9A7AAE4 (school_absence_and_delay_id), INDEX IDX_2989D31C8565851 (establishment_id), INDEX IDX_2989D31CD2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_absence_and_delay_report_card_notification (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, create_date DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_180237618565851 (establishment_id), INDEX IDX_18023761D2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_absence_and_delay_report_card_notification_line (id INT AUTO_INCREMENT NOT NULL, school_absence_and_delay_report_card_notification_id INT NOT NULL, school_absence_and_delay_id INT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, create_date DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, is_sms_sended TINYINT(1) NOT NULL, INDEX IDX_C400163F515DA527 (school_absence_and_delay_report_card_notification_id), INDEX IDX_C400163FE9A7AAE4 (school_absence_and_delay_id), INDEX IDX_C400163F8565851 (establishment_id), INDEX IDX_C400163FD2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_absence_and_delay_setting (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, code VARCHAR(60) NOT NULL, is_automatic_send TINYINT(1) NOT NULL, is_observation_send TINYINT(1) NOT NULL, absence_threshold INT NOT NULL, message LONGTEXT DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_E5784FBF8565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_assessment_by_class (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, school_year_periode_id INT NOT NULL, school_year_id INT NOT NULL, student_registration_id INT NOT NULL, classroom_id INT NOT NULL, report_card_id INT NOT NULL, average DOUBLE PRECISION NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, order_num INT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_643B9C0B8565851 (establishment_id), INDEX IDX_643B9C0BD17A6B27 (school_year_periode_id), INDEX IDX_643B9C0BD2EECC3F (school_year_id), INDEX IDX_643B9C0BDF990765 (student_registration_id), INDEX IDX_643B9C0B6278D5A8 (classroom_id), INDEX IDX_643B9C0B2A55E720 (report_card_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_assessment_by_class_by_matter (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, school_year_periode_id INT NOT NULL, school_year_id INT NOT NULL, student_registration_id INT NOT NULL, classroom_id INT NOT NULL, report_card_id INT NOT NULL, matter_id INT NOT NULL, average DOUBLE PRECISION NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, order_num INT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_CD8158B88565851 (establishment_id), INDEX IDX_CD8158B8D17A6B27 (school_year_periode_id), INDEX IDX_CD8158B8D2EECC3F (school_year_id), INDEX IDX_CD8158B8DF990765 (student_registration_id), INDEX IDX_CD8158B86278D5A8 (classroom_id), INDEX IDX_CD8158B82A55E720 (report_card_id), INDEX IDX_CD8158B8D614E59F (matter_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_assessment_by_level (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, school_year_periode_id INT NOT NULL, school_year_id INT NOT NULL, student_registration_id INT NOT NULL, level_id INT NOT NULL, report_card_id INT NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, average DOUBLE PRECISION NOT NULL, order_num INT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_139A49878565851 (establishment_id), INDEX IDX_139A4987D17A6B27 (school_year_periode_id), INDEX IDX_139A4987D2EECC3F (school_year_id), INDEX IDX_139A4987DF990765 (student_registration_id), INDEX IDX_139A49875FB14BA7 (level_id), INDEX IDX_139A49872A55E720 (report_card_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_assessment_by_level_by_matter (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, school_year_periode_id INT NOT NULL, school_year_id INT NOT NULL, student_registration_id INT NOT NULL, level_id INT NOT NULL, report_card_id INT NOT NULL, matter_id INT NOT NULL, average DOUBLE PRECISION NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, order_num INT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_2000BCF68565851 (establishment_id), INDEX IDX_2000BCF6D17A6B27 (school_year_periode_id), INDEX IDX_2000BCF6D2EECC3F (school_year_id), INDEX IDX_2000BCF6DF990765 (student_registration_id), INDEX IDX_2000BCF65FB14BA7 (level_id), INDEX IDX_2000BCF62A55E720 (report_card_id), INDEX IDX_2000BCF6D614E59F (matter_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_average_report_card (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, school_year_periode_id INT NOT NULL, student_registration_id INT NOT NULL, classroom_id INT NOT NULL, report_card_id INT NOT NULL, matter_id INT NOT NULL, sub_matter_id INT DEFAULT NULL, average DOUBLE PRECISION NOT NULL, coefficient DOUBLE PRECISION NOT NULL, coefficient_x_average DOUBLE PRECISION NOT NULL, order_num INT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_7F4631F28565851 (establishment_id), INDEX IDX_7F4631F2D2EECC3F (school_year_id), INDEX IDX_7F4631F2D17A6B27 (school_year_periode_id), INDEX IDX_7F4631F2DF990765 (student_registration_id), INDEX IDX_7F4631F26278D5A8 (classroom_id), INDEX IDX_7F4631F22A55E720 (report_card_id), INDEX IDX_7F4631F2D614E59F (matter_id), INDEX IDX_7F4631F2C419A321 (sub_matter_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_matter (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, level_id INT NOT NULL, matter_type_id INT DEFAULT NULL, coefficient DOUBLE PRECISION NOT NULL, noted_on DOUBLE PRECISION NOT NULL, order_num INT NOT NULL, `label` VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, is_test_matter TINYINT(1) NOT NULL, lv2 VARCHAR(128) DEFAULT NULL, INDEX IDX_4D6298A38565851 (establishment_id), INDEX IDX_4D6298A35FB14BA7 (level_id), INDEX IDX_4D6298A36DF38874 (matter_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_matter_type (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, order_num INT NOT NULL, `label` VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_900C25398565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_note_appreciation (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, borne_inf INT NOT NULL, borne_sup INT NOT NULL, noted_on INT NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_4B9A27358565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_report_card (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, school_year_periode_id INT NOT NULL, student_registration_id INT NOT NULL, classroom_id INT NOT NULL, report_card_id INT NOT NULL, coefficient DOUBLE PRECISION NOT NULL, order_num INT NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_363E47988565851 (establishment_id), INDEX IDX_363E4798D2EECC3F (school_year_id), INDEX IDX_363E4798D17A6B27 (school_year_periode_id), INDEX IDX_363E4798DF990765 (student_registration_id), INDEX IDX_363E47986278D5A8 (classroom_id), INDEX IDX_363E47982A55E720 (report_card_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_sub_matter (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, level_id INT NOT NULL, matter_id INT NOT NULL, coefficient DOUBLE PRECISION NOT NULL, noted_on DOUBLE PRECISION NOT NULL, order_num INT NOT NULL, `label` VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_B72E54D18565851 (establishment_id), INDEX IDX_B72E54D15FB14BA7 (level_id), INDEX IDX_B72E54D1D614E59F (matter_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_teacher (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, salary_id INT NOT NULL, diploma VARCHAR(128) DEFAULT NULL, teaching_license VARCHAR(128) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_22D9944D8565851 (establishment_id), INDEX IDX_22D9944DD2EECC3F (school_year_id), INDEX IDX_22D9944DB0FDF16E (salary_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_teacher_setting_classroom (school_teacher_id INT NOT NULL, setting_classroom_id INT NOT NULL, INDEX IDX_26717AD7F421FEEF (school_teacher_id), INDEX IDX_26717AD77AF43AAE (setting_classroom_id), PRIMARY KEY(school_teacher_id, setting_classroom_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_teacher_school_matter (school_teacher_id INT NOT NULL, school_matter_id INT NOT NULL, INDEX IDX_DF408F17F421FEEF (school_teacher_id), INDEX IDX_DF408F17A75B2622 (school_matter_id), PRIMARY KEY(school_teacher_id, school_matter_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_year (id INT AUTO_INCREMENT NOT NULL, is_ongoing TINYINT(1) NOT NULL, is_archived TINYINT(1) NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, fiscal_year VARCHAR(60) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE school_year_periode (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, coefficient DOUBLE PRECISION NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', begin_at DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', end_at DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_4A5E65348565851 (establishment_id), INDEX IDX_4A5E6534D2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE setting_classroom (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, level_id INT NOT NULL, faculty_id INT DEFAULT NULL, round_id INT DEFAULT NULL, school_year_id INT NOT NULL, `label` VARCHAR(128) NOT NULL, capacity DOUBLE PRECISION NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_14BBA2A78565851 (establishment_id), INDEX IDX_14BBA2A75FB14BA7 (level_id), INDEX IDX_14BBA2A7680CAB68 (faculty_id), INDEX IDX_14BBA2A7A6005CA0 (round_id), INDEX IDX_14BBA2A7D2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE setting_cycle (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, studies_director_id INT DEFAULT NULL, `label` VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_F92E22F28565851 (establishment_id), INDEX IDX_F92E22F229C12A34 (studies_director_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE setting_document_to_provide (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, `label` VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_53B55FB58565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE setting_faculty (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, cycle_id INT DEFAULT NULL, `label` VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_4FC4D0AB8565851 (establishment_id), INDEX IDX_4FC4D0AB5EC1162 (cycle_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE setting_fee (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, accounting_account_id INT DEFAULT NULL, fee_provider_id INT DEFAULT NULL, school_year_id INT NOT NULL, `label` VARCHAR(128) NOT NULL, amount DOUBLE PRECISION NOT NULL, quantity_available INT DEFAULT NULL, is_for_affected TINYINT(1) NOT NULL, is_for_non_affected TINYINT(1) NOT NULL, is_for_all TINYINT(1) NOT NULL, category VARCHAR(128) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_4378298B8565851 (establishment_id), INDEX IDX_4378298BF83E3874 (accounting_account_id), INDEX IDX_4378298B838EC6C4 (fee_provider_id), INDEX IDX_4378298BD2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE setting_fee_setting_level (setting_fee_id INT NOT NULL, setting_level_id INT NOT NULL, INDEX IDX_E95E62AA91B957F7 (setting_fee_id), INDEX IDX_E95E62AAF138735D (setting_level_id), PRIMARY KEY(setting_fee_id, setting_level_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE setting_fee_provider (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, name VARCHAR(128) NOT NULL, phone_number VARCHAR(60) NOT NULL, email VARCHAR(128) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_E876379D8565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE setting_fee_shedul (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, fee_id INT NOT NULL, order_num INT NOT NULL, date_due DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', amount DOUBLE PRECISION NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_D3DE77E58565851 (establishment_id), INDEX IDX_D3DE77E5AB45AECA (fee_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE setting_learning_difficulty (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, `label` VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_D3E0ED78565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE setting_level (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, cycle_id INT DEFAULT NULL, `label` VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, is_student_entry_test_do TINYINT(1) NOT NULL, is_student_toxicological_test_do TINYINT(1) NOT NULL, is_student_psychological_test_do TINYINT(1) NOT NULL, INDEX IDX_D3423F728565851 (establishment_id), INDEX IDX_D3423F725EC1162 (cycle_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE setting_medical_history (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, `label` VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_58DDCC078565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE setting_round (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, cycle_id INT DEFAULT NULL, `label` VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_8C4619558565851 (establishment_id), INDEX IDX_8C4619555EC1162 (cycle_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE stock_kit_category (id INT AUTO_INCREMENT NOT NULL, fee_id INT NOT NULL, establishment_id INT NOT NULL, name VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_19C0F12AAB45AECA (fee_id), INDEX IDX_19C0F12A8565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE stock_kit_out (id INT AUTO_INCREMENT NOT NULL, registration_student_id INT NOT NULL, kit_category_id INT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, create_date DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, is_validated TINYINT(1) NOT NULL, INDEX IDX_FB176420F6AF8633 (registration_student_id), INDEX IDX_FB17642024F16FF2 (kit_category_id), INDEX IDX_FB1764208565851 (establishment_id), INDEX IDX_FB176420D2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE stock_kit_out_line (id INT AUTO_INCREMENT NOT NULL, stock_kit_out_id INT NOT NULL, stock_kit_product_id INT NOT NULL, product_id INT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, quantity DOUBLE PRECISION NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_1795063EDC4EA84F (stock_kit_out_id), INDEX IDX_1795063E56DF39BB (stock_kit_product_id), INDEX IDX_1795063E4584665A (product_id), INDEX IDX_1795063E8565851 (establishment_id), INDEX IDX_1795063ED2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE stock_kit_product (id INT AUTO_INCREMENT NOT NULL, stock_kit_category_id INT NOT NULL, product_id INT NOT NULL, establishment_id INT NOT NULL, quantity DOUBLE PRECISION NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, is_can_be_recovered TINYINT(1) NOT NULL, INDEX IDX_8521817EC5581453 (stock_kit_category_id), INDEX IDX_8521817E4584665A (product_id), INDEX IDX_8521817E8565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE stock_product (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, name VARCHAR(128) NOT NULL, sale_price DOUBLE PRECISION DEFAULT NULL, purchase_price DOUBLE PRECISION DEFAULT NULL, quantity_available_for_kit DOUBLE PRECISION DEFAULT NULL, quantity_available_for_out DOUBLE PRECISION DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_CAEC140E8565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE stock_product_entry (id INT AUTO_INCREMENT NOT NULL, fee_provider_id INT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, create_date DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, is_validated TINYINT(1) NOT NULL, code VARCHAR(128) NOT NULL, INDEX IDX_EE2CCC8838EC6C4 (fee_provider_id), INDEX IDX_EE2CCC88565851 (establishment_id), INDEX IDX_EE2CCC8D2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE stock_product_entry_line (id INT AUTO_INCREMENT NOT NULL, stock_product_entry_id INT NOT NULL, product_id INT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, quantity DOUBLE PRECISION NOT NULL, price DOUBLE PRECISION DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_5D2A1F09D0B619D0 (stock_product_entry_id), INDEX IDX_5D2A1F094584665A (product_id), INDEX IDX_5D2A1F098565851 (establishment_id), INDEX IDX_5D2A1F09D2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE stock_product_out (id INT AUTO_INCREMENT NOT NULL, product_id INT NOT NULL, salary_id INT DEFAULT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, create_date DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', quantity DOUBLE PRECISION NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_860B9FB24584665A (product_id), INDEX IDX_860B9FB2B0FDF16E (salary_id), INDEX IDX_860B9FB28565851 (establishment_id), INDEX IDX_860B9FB2D2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE stock_provider_kit_entry (id INT AUTO_INCREMENT NOT NULL, kit_category_id INT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, create_date DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', quanty DOUBLE PRECISION NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, is_validated TINYINT(1) NOT NULL, INDEX IDX_9D82004524F16FF2 (kit_category_id), INDEX IDX_9D8200458565851 (establishment_id), INDEX IDX_9D820045D2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE stock_provider_kit_entry_line (id INT AUTO_INCREMENT NOT NULL, stock_provider_kit_entry_id INT NOT NULL, product_id INT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, stock_kit_product_id INT NOT NULL, quantity DOUBLE PRECISION NOT NULL, price DOUBLE PRECISION DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_3A7C286D13A6688A (stock_provider_kit_entry_id), INDEX IDX_3A7C286D4584665A (product_id), INDEX IDX_3A7C286D8565851 (establishment_id), INDEX IDX_3A7C286DD2EECC3F (school_year_id), INDEX IDX_3A7C286D56DF39BB (stock_kit_product_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE stock_student_kit_entry (id INT AUTO_INCREMENT NOT NULL, registration_student_id INT NOT NULL, kit_category_id INT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, create_date DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_E8C29105F6AF8633 (registration_student_id), INDEX IDX_E8C2910524F16FF2 (kit_category_id), INDEX IDX_E8C291058565851 (establishment_id), INDEX IDX_E8C29105D2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE stock_student_kit_entry_line (id INT AUTO_INCREMENT NOT NULL, stock_student_kit_entry_id INT NOT NULL, stock_kit_product_id INT NOT NULL, product_id INT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, quantity DOUBLE PRECISION NOT NULL, price DOUBLE PRECISION DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_45A1F6967DBA1FF4 (stock_student_kit_entry_id), INDEX IDX_45A1F69656DF39BB (stock_kit_product_id), INDEX IDX_45A1F6964584665A (product_id), INDEX IDX_45A1F6968565851 (establishment_id), INDEX IDX_45A1F696D2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE transport_vehicle (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, driver_id INT DEFAULT NULL, conveyor_id INT DEFAULT NULL, model_id INT DEFAULT NULL, model_year VARCHAR(30) DEFAULT NULL, registration_number VARCHAR(60) DEFAULT NULL, chassis_number VARCHAR(60) DEFAULT NULL, number_of_places INT DEFAULT NULL, door_number INT DEFAULT NULL, color VARCHAR(60) DEFAULT NULL, last_mileage_report INT DEFAULT NULL, distance_unit VARCHAR(60) DEFAULT NULL, date_of_registration DATE DEFAULT NULL COMMENT \'(DC2Type:date_immutable)\', transmission VARCHAR(60) DEFAULT NULL, fuel_type VARCHAR(60) DEFAULT NULL, number_of_horses INT DEFAULT NULL, co2_emissions VARCHAR(60) DEFAULT NULL, image VARCHAR(255) DEFAULT NULL, denomination VARCHAR(128) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_8F5724778565851 (establishment_id), INDEX IDX_8F572477C3423909 (driver_id), INDEX IDX_8F572477CA3477EB (conveyor_id), INDEX IDX_8F5724777975B7E7 (model_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE transport_vehicle_administrative_document (id INT AUTO_INCREMENT NOT NULL, vehicle_id INT NOT NULL, establishment_id INT NOT NULL, name VARCHAR(128) NOT NULL, establishment_date DATE DEFAULT NULL COMMENT \'(DC2Type:date_immutable)\', expiration_date DATE DEFAULT NULL COMMENT \'(DC2Type:date_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_F60E39E4545317D1 (vehicle_id), INDEX IDX_F60E39E48565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE transport_vehicle_fuel_tracking (id INT AUTO_INCREMENT NOT NULL, vehicle_id INT NOT NULL, establishment_id INT NOT NULL, buyer_id INT DEFAULT NULL, provider_id INT DEFAULT NULL, quantity DOUBLE PRECISION NOT NULL, unit_price DOUBLE PRECISION NOT NULL, amount DOUBLE PRECISION NOT NULL, create_date DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', provider_name VARCHAR(128) DEFAULT NULL, ref_invoice VARCHAR(60) DEFAULT NULL, milage INT DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_68A952A1545317D1 (vehicle_id), INDEX IDX_68A952A18565851 (establishment_id), INDEX IDX_68A952A16C755722 (buyer_id), INDEX IDX_68A952A1A53A8AA (provider_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE transport_vehicle_maintenance (id INT AUTO_INCREMENT NOT NULL, vehicle_id INT NOT NULL, establishment_id INT NOT NULL, buyer_id INT DEFAULT NULL, provider_id INT DEFAULT NULL, description LONGTEXT NOT NULL, create_date DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', ref_invoice VARCHAR(128) DEFAULT NULL, price DOUBLE PRECISION NOT NULL, mileage INT DEFAULT NULL, provider_name VARCHAR(128) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_F58A8C96545317D1 (vehicle_id), INDEX IDX_F58A8C968565851 (establishment_id), INDEX IDX_F58A8C966C755722 (buyer_id), INDEX IDX_F58A8C96A53A8AA (provider_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE transport_vehicle_mechanical_piece (id INT AUTO_INCREMENT NOT NULL, vehicle_id INT NOT NULL, establishment_id INT NOT NULL, name VARCHAR(128) NOT NULL, quantity INT DEFAULT NULL, acquisition_date DATE DEFAULT NULL COMMENT \'(DC2Type:date_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_31FD5342545317D1 (vehicle_id), INDEX IDX_31FD53428565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE transport_vehicle_model (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, name VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_C378415E8565851 (establishment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE transport_zone (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, transport_vehicle_id INT NOT NULL, name VARCHAR(128) NOT NULL, target LONGTEXT DEFAULT NULL, departure_time VARCHAR(30) DEFAULT NULL, arrival_time VARCHAR(30) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_7D3B97828565851 (establishment_id), INDEX IDX_7D3B978233189E9B (transport_vehicle_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE transport_zone_setting_fee (transport_zone_id INT NOT NULL, setting_fee_id INT NOT NULL, INDEX IDX_F0EAD390BFBFF5A (transport_zone_id), INDEX IDX_F0EAD39091B957F7 (setting_fee_id), PRIMARY KEY(transport_zone_id, setting_fee_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE transport_zone_check_point (id INT AUTO_INCREMENT NOT NULL, zone_id INT NOT NULL, establishment_id INT NOT NULL, setting_fee_id INT DEFAULT NULL, order_num INT NOT NULL, code VARCHAR(60) NOT NULL, name VARCHAR(128) NOT NULL, morning_schedule VARCHAR(30) DEFAULT NULL, evening_schedule VARCHAR(30) DEFAULT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_9E6D3AFD9F2C3FAB (zone_id), INDEX IDX_9E6D3AFD8565851 (establishment_id), INDEX IDX_9E6D3AFD91B957F7 (setting_fee_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE treasury_cash_movement (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, cash_register_id INT NOT NULL, amount DOUBLE PRECISION NOT NULL, type VARCHAR(5) NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_18EEF5C48565851 (establishment_id), INDEX IDX_18EEF5C4A917CC69 (cash_register_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE treasury_cash_register (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, checkout_id INT NOT NULL, school_year_id INT NOT NULL, code VARCHAR(60) NOT NULL, is_closed TINYINT(1) NOT NULL, create_at DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, UNIQUE INDEX UNIQ_B3CA202777153098 (code), INDEX IDX_B3CA20278565851 (establishment_id), INDEX IDX_B3CA2027146D8724 (checkout_id), INDEX IDX_B3CA2027D2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE treasury_checkout (id INT AUTO_INCREMENT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, code VARCHAR(60) NOT NULL, `label` VARCHAR(128) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, UNIQUE INDEX UNIQ_96CAC40277153098 (code), INDEX IDX_96CAC4028565851 (establishment_id), INDEX IDX_96CAC402D2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE treasury_payment (id INT AUTO_INCREMENT NOT NULL, cash_register_id INT NOT NULL, establishment_id INT NOT NULL, school_year_id INT NOT NULL, discharge VARCHAR(255) NOT NULL, amount DOUBLE PRECISION NOT NULL, create_at DATE NOT NULL COMMENT \'(DC2Type:date_immutable)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_9C720AEEA917CC69 (cash_register_id), INDEX IDX_9C720AEE8565851 (establishment_id), INDEX IDX_9C720AEED2EECC3F (school_year_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, establishment_id INT DEFAULT NULL, establishment_group_id INT DEFAULT NULL, username VARCHAR(180) NOT NULL, roles LONGTEXT NOT NULL COMMENT \'(DC2Type:json)\', password VARCHAR(255) NOT NULL, is_enabled TINYINT(1) NOT NULL, is_password_changed TINYINT(1) NOT NULL, last_login_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', UNIQUE INDEX UNIQ_8D93D649F85E0677 (username), INDEX IDX_8D93D6498565851 (establishment_id), INDEX IDX_8D93D649B52D2A75 (establishment_group_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_establishment (user_id INT NOT NULL, establishment_id INT NOT NULL, INDEX IDX_35611CBEA76ED395 (user_id), INDEX IDX_35611CBE8565851 (establishment_id), PRIMARY KEY(user_id, establishment_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('ALTER TABLE accounting_account ADD CONSTRAINT FK_44BEAB93727ACA70 FOREIGN KEY (parent_id) REFERENCES accounting_account (id)');
$this->addSql('ALTER TABLE accounting_expense ADD CONSTRAINT FK_14B270918565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE accounting_expense ADD CONSTRAINT FK_14B27091B0FDF16E FOREIGN KEY (salary_id) REFERENCES rh_salary (id)');
$this->addSql('ALTER TABLE accounting_expense ADD CONSTRAINT FK_14B27091A917CC69 FOREIGN KEY (cash_register_id) REFERENCES treasury_cash_register (id)');
$this->addSql('ALTER TABLE accounting_expense ADD CONSTRAINT FK_14B27091C2FF77B0 FOREIGN KEY (cash_movement_id) REFERENCES treasury_cash_movement (id)');
$this->addSql('ALTER TABLE accounting_expense ADD CONSTRAINT FK_14B270919B6B5FBA FOREIGN KEY (account_id) REFERENCES accounting_account (id)');
$this->addSql('ALTER TABLE accounting_expense ADD CONSTRAINT FK_14B27091D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE accounting_student_registration_fee ADD CONSTRAINT FK_D7A54C468565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE accounting_student_registration_fee ADD CONSTRAINT FK_D7A54C46DF990765 FOREIGN KEY (student_registration_id) REFERENCES registration_student_registration (id)');
$this->addSql('ALTER TABLE accounting_student_registration_fee ADD CONSTRAINT FK_D7A54C46AB45AECA FOREIGN KEY (fee_id) REFERENCES setting_fee (id)');
$this->addSql('ALTER TABLE accounting_student_registration_fee_shedul ADD CONSTRAINT FK_656ADA5C8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE accounting_student_registration_fee_shedul ADD CONSTRAINT FK_656ADA5CC7D2B0C8 FOREIGN KEY (student_registration_fee_id) REFERENCES accounting_student_registration_fee (id)');
$this->addSql('ALTER TABLE accounting_student_registration_fee_shedul_payment ADD CONSTRAINT FK_ECE70BF38565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE accounting_student_registration_fee_shedul_payment ADD CONSTRAINT FK_ECE70BF3C7D2B0C8 FOREIGN KEY (student_registration_fee_id) REFERENCES accounting_student_registration_fee (id)');
$this->addSql('ALTER TABLE accounting_student_registration_fee_shedul_payment ADD CONSTRAINT FK_ECE70BF39D932FE9 FOREIGN KEY (student_registration_fee_shedul_id) REFERENCES accounting_student_registration_fee_shedul (id)');
$this->addSql('ALTER TABLE accounting_student_registration_fee_shedul_payment ADD CONSTRAINT FK_ECE70BF3C2FF77B0 FOREIGN KEY (cash_movement_id) REFERENCES treasury_cash_movement (id)');
$this->addSql('ALTER TABLE accounting_student_registration_fee_shedul_payment ADD CONSTRAINT FK_ECE70BF3A917CC69 FOREIGN KEY (cash_register_id) REFERENCES treasury_cash_register (id)');
$this->addSql('ALTER TABLE accounting_student_registration_fee_shedul_payment ADD CONSTRAINT FK_ECE70BF3F83E3874 FOREIGN KEY (accounting_account_id) REFERENCES accounting_account (id)');
$this->addSql('ALTER TABLE accounting_student_registration_fee_shedul_payment ADD CONSTRAINT FK_ECE70BF3C276D4E4 FOREIGN KEY (student_registration_payment_id) REFERENCES accounting_student_registration_payment (id)');
$this->addSql('ALTER TABLE accounting_student_registration_payment ADD CONSTRAINT FK_3CB5E7FA8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE accounting_student_registration_payment ADD CONSTRAINT FK_3CB5E7FADF990765 FOREIGN KEY (student_registration_id) REFERENCES registration_student_registration (id)');
$this->addSql('ALTER TABLE accounting_student_registration_payment ADD CONSTRAINT FK_3CB5E7FAA917CC69 FOREIGN KEY (cash_register_id) REFERENCES treasury_cash_register (id)');
$this->addSql('ALTER TABLE accounting_student_registration_payment ADD CONSTRAINT FK_3CB5E7FAD2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE canteen_dish ADD CONSTRAINT FK_AA233F7C8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE canteen_menu ADD CONSTRAINT FK_425B89578565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE canteen_menu_item ADD CONSTRAINT FK_FAFA53B98B776210 FOREIGN KEY (canteen_time_id) REFERENCES canteen_time (id)');
$this->addSql('ALTER TABLE canteen_menu_item ADD CONSTRAINT FK_FAFA53B983173DD0 FOREIGN KEY (day_1_dish_id) REFERENCES canteen_dish (id)');
$this->addSql('ALTER TABLE canteen_menu_item ADD CONSTRAINT FK_FAFA53B9BA9A0115 FOREIGN KEY (day_2_dish_id) REFERENCES canteen_dish (id)');
$this->addSql('ALTER TABLE canteen_menu_item ADD CONSTRAINT FK_FAFA53B9ADE11556 FOREIGN KEY (day_3_dish_id) REFERENCES canteen_dish (id)');
$this->addSql('ALTER TABLE canteen_menu_item ADD CONSTRAINT FK_FAFA53B9C980789F FOREIGN KEY (day_4_dish_id) REFERENCES canteen_dish (id)');
$this->addSql('ALTER TABLE canteen_menu_item ADD CONSTRAINT FK_FAFA53B9DEFB6CDC FOREIGN KEY (day_5_dish_id) REFERENCES canteen_dish (id)');
$this->addSql('ALTER TABLE canteen_menu_item ADD CONSTRAINT FK_FAFA53B9E7765019 FOREIGN KEY (day_6_dish_id) REFERENCES canteen_dish (id)');
$this->addSql('ALTER TABLE canteen_menu_item ADD CONSTRAINT FK_FAFA53B9F00D445A FOREIGN KEY (day_7_dish_id) REFERENCES canteen_dish (id)');
$this->addSql('ALTER TABLE canteen_menu_item ADD CONSTRAINT FK_FAFA53B98565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE canteen_menu_item ADD CONSTRAINT FK_FAFA53B9194A5639 FOREIGN KEY (canteen_menu_id) REFERENCES canteen_menu (id)');
$this->addSql('ALTER TABLE canteen_stock_movement ADD CONSTRAINT FK_A521A77935B8E784 FOREIGN KEY (canteen_utensil_id) REFERENCES canteen_utensil (id)');
$this->addSql('ALTER TABLE canteen_stock_movement ADD CONSTRAINT FK_A521A7798565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE canteen_time ADD CONSTRAINT FK_50CA2B818565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE canteen_utensil ADD CONSTRAINT FK_4AB583978565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE communication_message ADD CONSTRAINT FK_C36C19258565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE communication_message ADD CONSTRAINT FK_C36C1925D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE communication_message ADD CONSTRAINT FK_C36C1925A1B4F640 FOREIGN KEY (communication_predefined_message_id) REFERENCES communication_predefined_message (id)');
$this->addSql('ALTER TABLE communication_message_registration_student_registration ADD CONSTRAINT FK_64B41D5687C3C593 FOREIGN KEY (communication_message_id) REFERENCES communication_message (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE communication_message_registration_student_registration ADD CONSTRAINT FK_64B41D56B0396129 FOREIGN KEY (registration_student_registration_id) REFERENCES registration_student_registration (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE communication_message_setting_classroom ADD CONSTRAINT FK_1C276FC087C3C593 FOREIGN KEY (communication_message_id) REFERENCES communication_message (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE communication_message_setting_classroom ADD CONSTRAINT FK_1C276FC07AF43AAE FOREIGN KEY (setting_classroom_id) REFERENCES setting_classroom (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE communication_message_setting_level ADD CONSTRAINT FK_1354AE2387C3C593 FOREIGN KEY (communication_message_id) REFERENCES communication_message (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE communication_message_setting_level ADD CONSTRAINT FK_1354AE23F138735D FOREIGN KEY (setting_level_id) REFERENCES setting_level (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE communication_message_transport_zone ADD CONSTRAINT FK_6197E07187C3C593 FOREIGN KEY (communication_message_id) REFERENCES communication_message (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE communication_message_transport_zone ADD CONSTRAINT FK_6197E071BFBFF5A FOREIGN KEY (transport_zone_id) REFERENCES transport_zone (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE communication_message_setting_fee ADD CONSTRAINT FK_27D16A087C3C593 FOREIGN KEY (communication_message_id) REFERENCES communication_message (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE communication_message_setting_fee ADD CONSTRAINT FK_27D16A091B957F7 FOREIGN KEY (setting_fee_id) REFERENCES setting_fee (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE communication_message_rh_salary ADD CONSTRAINT FK_55246A3E87C3C593 FOREIGN KEY (communication_message_id) REFERENCES communication_message (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE communication_message_rh_salary ADD CONSTRAINT FK_55246A3E4758967C FOREIGN KEY (rh_salary_id) REFERENCES rh_salary (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE communication_message_rh_department ADD CONSTRAINT FK_FE45A4F487C3C593 FOREIGN KEY (communication_message_id) REFERENCES communication_message (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE communication_message_rh_department ADD CONSTRAINT FK_FE45A4F4E9A1987D FOREIGN KEY (rh_department_id) REFERENCES rh_department (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE communication_message_rh_job ADD CONSTRAINT FK_B1C86EB487C3C593 FOREIGN KEY (communication_message_id) REFERENCES communication_message (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE communication_message_rh_job ADD CONSTRAINT FK_B1C86EB454ED32A7 FOREIGN KEY (rh_job_id) REFERENCES rh_job (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE communication_message_rh_statut ADD CONSTRAINT FK_245321F087C3C593 FOREIGN KEY (communication_message_id) REFERENCES communication_message (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE communication_message_rh_statut ADD CONSTRAINT FK_245321F01855F16 FOREIGN KEY (rh_statut_id) REFERENCES rh_statut (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE communication_predefined_message ADD CONSTRAINT FK_DB930C038565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE entre_test_report_card ADD CONSTRAINT FK_C59B67338565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE entre_test_report_card ADD CONSTRAINT FK_C59B67335FB14BA7 FOREIGN KEY (level_id) REFERENCES setting_level (id)');
$this->addSql('ALTER TABLE entre_test_report_card ADD CONSTRAINT FK_C59B6733D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE establishment ADD CONSTRAINT FK_DBEFB1EEB52D2A75 FOREIGN KEY (establishment_group_id) REFERENCES establishment_group (id)');
$this->addSql('ALTER TABLE establishment_group ADD CONSTRAINT FK_E9D178B0E4919C9B FOREIGN KEY (transportation_manager_id) REFERENCES rh_salary (id)');
$this->addSql('ALTER TABLE matter_average_pre_registration_entry_test ADD CONSTRAINT FK_4600CF30D614E59F FOREIGN KEY (matter_id) REFERENCES school_matter (id)');
$this->addSql('ALTER TABLE matter_average_pre_registration_entry_test ADD CONSTRAINT FK_4600CF308565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE matter_average_pre_registration_entry_test ADD CONSTRAINT FK_4600CF305A800598 FOREIGN KEY (pre_registration_entre_test_report_card_id) REFERENCES pre_registration_entre_test_report_card (id)');
$this->addSql('ALTER TABLE pre_registration_entre_test_report_card ADD CONSTRAINT FK_3FF2F412D7374135 FOREIGN KEY (registration_student_pre_registration_id) REFERENCES registration_student_pre_registration (id)');
$this->addSql('ALTER TABLE pre_registration_entre_test_report_card ADD CONSTRAINT FK_3FF2F412D0D2990 FOREIGN KEY (entre_test_report_card_id) REFERENCES entre_test_report_card (id)');
$this->addSql('ALTER TABLE pre_registration_entre_test_report_card ADD CONSTRAINT FK_3FF2F4128565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE pre_registration_entre_test_report_card ADD CONSTRAINT FK_3FF2F4125FB14BA7 FOREIGN KEY (level_id) REFERENCES setting_level (id)');
$this->addSql('ALTER TABLE pre_registration_entre_test_report_card ADD CONSTRAINT FK_3FF2F412D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE registration_class_change ADD CONSTRAINT FK_29F5645CDF990765 FOREIGN KEY (student_registration_id) REFERENCES registration_student_registration (id)');
$this->addSql('ALTER TABLE registration_class_change ADD CONSTRAINT FK_29F5645C6278D5A8 FOREIGN KEY (classroom_id) REFERENCES setting_classroom (id)');
$this->addSql('ALTER TABLE registration_class_change ADD CONSTRAINT FK_29F5645CD2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE registration_class_change ADD CONSTRAINT FK_29F5645C8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE registration_class_change ADD CONSTRAINT FK_29F5645CB934139E FOREIGN KEY (original_classroom_id) REFERENCES setting_classroom (id)');
$this->addSql('ALTER TABLE registration_diet ADD CONSTRAINT FK_52DA72FC8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE registration_diet ADD CONSTRAINT FK_52DA72FCF6AF8633 FOREIGN KEY (registration_student_id) REFERENCES registration_student (id)');
$this->addSql('ALTER TABLE registration_student ADD CONSTRAINT FK_F752FA958565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE registration_student ADD CONSTRAINT FK_F752FA9531F6ABEF FOREIGN KEY (entry_level_id) REFERENCES setting_level (id)');
$this->addSql('ALTER TABLE registration_student ADD CONSTRAINT FK_F752FA953544AD9E FOREIGN KEY (medical_history_id) REFERENCES setting_medical_history (id)');
$this->addSql('ALTER TABLE registration_student ADD CONSTRAINT FK_F752FA95951AAEC FOREIGN KEY (learning_difficulty_id) REFERENCES setting_learning_difficulty (id)');
$this->addSql('ALTER TABLE registration_student_abandonment ADD CONSTRAINT FK_A4724247B0396129 FOREIGN KEY (registration_student_registration_id) REFERENCES registration_student_registration (id)');
$this->addSql('ALTER TABLE registration_student_abandonment ADD CONSTRAINT FK_A47242478565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE registration_student_abandonment_line ADD CONSTRAINT FK_CAE115D16FD06346 FOREIGN KEY (registration_student_abandonment_id) REFERENCES registration_student_abandonment (id)');
$this->addSql('ALTER TABLE registration_student_abandonment_line ADD CONSTRAINT FK_CAE115D1E82663FB FOREIGN KEY (accounting_student_registration_fee_id) REFERENCES accounting_student_registration_fee (id)');
$this->addSql('ALTER TABLE registration_student_abandonment_line ADD CONSTRAINT FK_CAE115D18565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE registration_student_downgrade ADD CONSTRAINT FK_B518F4EFB0396129 FOREIGN KEY (registration_student_registration_id) REFERENCES registration_student_registration (id)');
$this->addSql('ALTER TABLE registration_student_downgrade ADD CONSTRAINT FK_B518F4EF61A68B7A FOREIGN KEY (starting_classroom_id) REFERENCES setting_classroom (id)');
$this->addSql('ALTER TABLE registration_student_downgrade ADD CONSTRAINT FK_B518F4EFD3560E67 FOREIGN KEY (destination_classroom_id) REFERENCES setting_classroom (id)');
$this->addSql('ALTER TABLE registration_student_downgrade ADD CONSTRAINT FK_B518F4EF8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE registration_student_downgrade_line ADD CONSTRAINT FK_A436BD26A743EEF7 FOREIGN KEY (registration_student_downgrade_id) REFERENCES registration_student_downgrade (id)');
$this->addSql('ALTER TABLE registration_student_downgrade_line ADD CONSTRAINT FK_A436BD26E82663FB FOREIGN KEY (accounting_student_registration_fee_id) REFERENCES accounting_student_registration_fee (id)');
$this->addSql('ALTER TABLE registration_student_downgrade_line ADD CONSTRAINT FK_A436BD268565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE registration_student_pre_registration ADD CONSTRAINT FK_FAA7D11CB944F1A FOREIGN KEY (student_id) REFERENCES registration_student (id)');
$this->addSql('ALTER TABLE registration_student_pre_registration ADD CONSTRAINT FK_FAA7D118565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE registration_student_pre_registration ADD CONSTRAINT FK_FAA7D1131F6ABEF FOREIGN KEY (entry_level_id) REFERENCES setting_level (id)');
$this->addSql('ALTER TABLE registration_student_pre_registration ADD CONSTRAINT FK_FAA7D11D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE registration_student_pre_registration_setting_level ADD CONSTRAINT FK_7B4E1603D7374135 FOREIGN KEY (registration_student_pre_registration_id) REFERENCES registration_student_pre_registration (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE registration_student_pre_registration_setting_level ADD CONSTRAINT FK_7B4E1603F138735D FOREIGN KEY (setting_level_id) REFERENCES setting_level (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE registration_student_registration ADD CONSTRAINT FK_4D4900A08565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE registration_student_registration ADD CONSTRAINT FK_4D4900A0CB944F1A FOREIGN KEY (student_id) REFERENCES registration_student (id)');
$this->addSql('ALTER TABLE registration_student_registration ADD CONSTRAINT FK_4D4900A0D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE registration_student_registration ADD CONSTRAINT FK_4D4900A06278D5A8 FOREIGN KEY (classroom_id) REFERENCES setting_classroom (id)');
$this->addSql('ALTER TABLE registration_student_registration ADD CONSTRAINT FK_4D4900A0D7374135 FOREIGN KEY (registration_student_pre_registration_id) REFERENCES registration_student_pre_registration (id)');
$this->addSql('ALTER TABLE registration_student_registration_setting_document_to_provide ADD CONSTRAINT FK_E586E457B0396129 FOREIGN KEY (registration_student_registration_id) REFERENCES registration_student_registration (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE registration_student_registration_setting_document_to_provide ADD CONSTRAINT FK_E586E45723FCFF00 FOREIGN KEY (setting_document_to_provide_id) REFERENCES setting_document_to_provide (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE registration_transport_checkpoint ADD CONSTRAINT FK_DE746844BFBFF5A FOREIGN KEY (transport_zone_id) REFERENCES transport_zone (id)');
$this->addSql('ALTER TABLE registration_transport_checkpoint ADD CONSTRAINT FK_DE74684433189E9B FOREIGN KEY (transport_vehicle_id) REFERENCES transport_vehicle (id)');
$this->addSql('ALTER TABLE registration_transport_checkpoint ADD CONSTRAINT FK_DE746844CDF7E6B1 FOREIGN KEY (transport_zone_check_point_id) REFERENCES transport_zone_check_point (id)');
$this->addSql('ALTER TABLE registration_transport_checkpoint ADD CONSTRAINT FK_DE7468448565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE registration_transport_checkpoint ADD CONSTRAINT FK_DE746844B0396129 FOREIGN KEY (registration_student_registration_id) REFERENCES registration_student_registration (id)');
$this->addSql('ALTER TABLE report_card ADD CONSTRAINT FK_653875288565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE report_card ADD CONSTRAINT FK_65387528D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE report_card ADD CONSTRAINT FK_65387528D17A6B27 FOREIGN KEY (school_year_periode_id) REFERENCES school_year_periode (id)');
$this->addSql('ALTER TABLE report_card ADD CONSTRAINT FK_653875285FB14BA7 FOREIGN KEY (level_id) REFERENCES setting_level (id)');
$this->addSql('ALTER TABLE rh_department ADD CONSTRAINT FK_3E5335A58565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE rh_job ADD CONSTRAINT FK_C99D17FB8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE rh_non_taxable_item ADD CONSTRAINT FK_D6D91C498565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE rh_pay_slip ADD CONSTRAINT FK_6990DECB8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE rh_pay_slip_non_taxable_item ADD CONSTRAINT FK_F7D693A08565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE rh_pay_slip_non_taxable_item ADD CONSTRAINT FK_F7D693A03C290DE6 FOREIGN KEY (rh_salary_pay_slip_id) REFERENCES rh_salary_pay_slip (id)');
$this->addSql('ALTER TABLE rh_pay_slip_retained_item ADD CONSTRAINT FK_D84784AD8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE rh_pay_slip_retained_item ADD CONSTRAINT FK_D84784AD3C290DE6 FOREIGN KEY (rh_salary_pay_slip_id) REFERENCES rh_salary_pay_slip (id)');
$this->addSql('ALTER TABLE rh_pay_slip_taxable_item ADD CONSTRAINT FK_80A5899B8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE rh_pay_slip_taxable_item ADD CONSTRAINT FK_80A5899B3C290DE6 FOREIGN KEY (rh_salary_pay_slip_id) REFERENCES rh_salary_pay_slip (id)');
$this->addSql('ALTER TABLE rh_retained_item ADD CONSTRAINT FK_A984BEA88565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE rh_salary ADD CONSTRAINT FK_CB1EC77F8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE rh_salary ADD CONSTRAINT FK_CB1EC77FA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE rh_salary ADD CONSTRAINT FK_CB1EC77F54ED32A7 FOREIGN KEY (rh_job_id) REFERENCES rh_job (id)');
$this->addSql('ALTER TABLE rh_salary ADD CONSTRAINT FK_CB1EC77FE9A1987D FOREIGN KEY (rh_department_id) REFERENCES rh_department (id)');
$this->addSql('ALTER TABLE rh_salary ADD CONSTRAINT FK_CB1EC77FF6203804 FOREIGN KEY (statut_id) REFERENCES rh_statut (id)');
$this->addSql('ALTER TABLE rh_salary_pay_slip ADD CONSTRAINT FK_93D79FF18565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE rh_salary_pay_slip ADD CONSTRAINT FK_93D79FF14758967C FOREIGN KEY (rh_salary_id) REFERENCES rh_salary (id)');
$this->addSql('ALTER TABLE rh_salary_pay_slip ADD CONSTRAINT FK_93D79FF1140FC72D FOREIGN KEY (rh_pay_slip_id) REFERENCES rh_pay_slip (id)');
$this->addSql('ALTER TABLE rh_statut ADD CONSTRAINT FK_BA698CB18565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE rh_taxable_item ADD CONSTRAINT FK_F21A05DF8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE school_absence_and_delay ADD CONSTRAINT FK_AC0DAEB68565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE school_absence_and_delay ADD CONSTRAINT FK_AC0DAEB6D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE school_absence_and_delay ADD CONSTRAINT FK_AC0DAEB6D17A6B27 FOREIGN KEY (school_year_periode_id) REFERENCES school_year_periode (id)');
$this->addSql('ALTER TABLE school_absence_and_delay ADD CONSTRAINT FK_AC0DAEB6DF990765 FOREIGN KEY (student_registration_id) REFERENCES registration_student_registration (id)');
$this->addSql('ALTER TABLE school_absence_and_delay_notification ADD CONSTRAINT FK_BCEC3D88565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE school_absence_and_delay_notification ADD CONSTRAINT FK_BCEC3D8D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE school_absence_and_delay_notification_line ADD CONSTRAINT FK_2989D31C79D0CA89 FOREIGN KEY (school_absence_and_delay_notification_id) REFERENCES school_absence_and_delay_notification (id)');
$this->addSql('ALTER TABLE school_absence_and_delay_notification_line ADD CONSTRAINT FK_2989D31CE9A7AAE4 FOREIGN KEY (school_absence_and_delay_id) REFERENCES school_absence_and_delay (id)');
$this->addSql('ALTER TABLE school_absence_and_delay_notification_line ADD CONSTRAINT FK_2989D31C8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE school_absence_and_delay_notification_line ADD CONSTRAINT FK_2989D31CD2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE school_absence_and_delay_report_card_notification ADD CONSTRAINT FK_180237618565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE school_absence_and_delay_report_card_notification ADD CONSTRAINT FK_18023761D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE school_absence_and_delay_report_card_notification_line ADD CONSTRAINT FK_C400163F515DA527 FOREIGN KEY (school_absence_and_delay_report_card_notification_id) REFERENCES school_absence_and_delay_report_card_notification (id)');
$this->addSql('ALTER TABLE school_absence_and_delay_report_card_notification_line ADD CONSTRAINT FK_C400163FE9A7AAE4 FOREIGN KEY (school_absence_and_delay_id) REFERENCES school_absence_and_delay (id)');
$this->addSql('ALTER TABLE school_absence_and_delay_report_card_notification_line ADD CONSTRAINT FK_C400163F8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE school_absence_and_delay_report_card_notification_line ADD CONSTRAINT FK_C400163FD2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE school_absence_and_delay_setting ADD CONSTRAINT FK_E5784FBF8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE school_assessment_by_class ADD CONSTRAINT FK_643B9C0B8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE school_assessment_by_class ADD CONSTRAINT FK_643B9C0BD17A6B27 FOREIGN KEY (school_year_periode_id) REFERENCES school_year_periode (id)');
$this->addSql('ALTER TABLE school_assessment_by_class ADD CONSTRAINT FK_643B9C0BD2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE school_assessment_by_class ADD CONSTRAINT FK_643B9C0BDF990765 FOREIGN KEY (student_registration_id) REFERENCES registration_student_registration (id)');
$this->addSql('ALTER TABLE school_assessment_by_class ADD CONSTRAINT FK_643B9C0B6278D5A8 FOREIGN KEY (classroom_id) REFERENCES setting_classroom (id)');
$this->addSql('ALTER TABLE school_assessment_by_class ADD CONSTRAINT FK_643B9C0B2A55E720 FOREIGN KEY (report_card_id) REFERENCES school_report_card (id)');
$this->addSql('ALTER TABLE school_assessment_by_class_by_matter ADD CONSTRAINT FK_CD8158B88565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE school_assessment_by_class_by_matter ADD CONSTRAINT FK_CD8158B8D17A6B27 FOREIGN KEY (school_year_periode_id) REFERENCES school_year_periode (id)');
$this->addSql('ALTER TABLE school_assessment_by_class_by_matter ADD CONSTRAINT FK_CD8158B8D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE school_assessment_by_class_by_matter ADD CONSTRAINT FK_CD8158B8DF990765 FOREIGN KEY (student_registration_id) REFERENCES registration_student_registration (id)');
$this->addSql('ALTER TABLE school_assessment_by_class_by_matter ADD CONSTRAINT FK_CD8158B86278D5A8 FOREIGN KEY (classroom_id) REFERENCES setting_classroom (id)');
$this->addSql('ALTER TABLE school_assessment_by_class_by_matter ADD CONSTRAINT FK_CD8158B82A55E720 FOREIGN KEY (report_card_id) REFERENCES school_report_card (id)');
$this->addSql('ALTER TABLE school_assessment_by_class_by_matter ADD CONSTRAINT FK_CD8158B8D614E59F FOREIGN KEY (matter_id) REFERENCES school_matter (id)');
$this->addSql('ALTER TABLE school_assessment_by_level ADD CONSTRAINT FK_139A49878565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE school_assessment_by_level ADD CONSTRAINT FK_139A4987D17A6B27 FOREIGN KEY (school_year_periode_id) REFERENCES school_year_periode (id)');
$this->addSql('ALTER TABLE school_assessment_by_level ADD CONSTRAINT FK_139A4987D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE school_assessment_by_level ADD CONSTRAINT FK_139A4987DF990765 FOREIGN KEY (student_registration_id) REFERENCES registration_student_registration (id)');
$this->addSql('ALTER TABLE school_assessment_by_level ADD CONSTRAINT FK_139A49875FB14BA7 FOREIGN KEY (level_id) REFERENCES setting_level (id)');
$this->addSql('ALTER TABLE school_assessment_by_level ADD CONSTRAINT FK_139A49872A55E720 FOREIGN KEY (report_card_id) REFERENCES school_report_card (id)');
$this->addSql('ALTER TABLE school_assessment_by_level_by_matter ADD CONSTRAINT FK_2000BCF68565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE school_assessment_by_level_by_matter ADD CONSTRAINT FK_2000BCF6D17A6B27 FOREIGN KEY (school_year_periode_id) REFERENCES school_year_periode (id)');
$this->addSql('ALTER TABLE school_assessment_by_level_by_matter ADD CONSTRAINT FK_2000BCF6D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE school_assessment_by_level_by_matter ADD CONSTRAINT FK_2000BCF6DF990765 FOREIGN KEY (student_registration_id) REFERENCES registration_student_registration (id)');
$this->addSql('ALTER TABLE school_assessment_by_level_by_matter ADD CONSTRAINT FK_2000BCF65FB14BA7 FOREIGN KEY (level_id) REFERENCES setting_level (id)');
$this->addSql('ALTER TABLE school_assessment_by_level_by_matter ADD CONSTRAINT FK_2000BCF62A55E720 FOREIGN KEY (report_card_id) REFERENCES school_report_card (id)');
$this->addSql('ALTER TABLE school_assessment_by_level_by_matter ADD CONSTRAINT FK_2000BCF6D614E59F FOREIGN KEY (matter_id) REFERENCES school_matter (id)');
$this->addSql('ALTER TABLE school_average_report_card ADD CONSTRAINT FK_7F4631F28565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE school_average_report_card ADD CONSTRAINT FK_7F4631F2D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE school_average_report_card ADD CONSTRAINT FK_7F4631F2D17A6B27 FOREIGN KEY (school_year_periode_id) REFERENCES school_year_periode (id)');
$this->addSql('ALTER TABLE school_average_report_card ADD CONSTRAINT FK_7F4631F2DF990765 FOREIGN KEY (student_registration_id) REFERENCES registration_student_registration (id)');
$this->addSql('ALTER TABLE school_average_report_card ADD CONSTRAINT FK_7F4631F26278D5A8 FOREIGN KEY (classroom_id) REFERENCES setting_classroom (id)');
$this->addSql('ALTER TABLE school_average_report_card ADD CONSTRAINT FK_7F4631F22A55E720 FOREIGN KEY (report_card_id) REFERENCES school_report_card (id)');
$this->addSql('ALTER TABLE school_average_report_card ADD CONSTRAINT FK_7F4631F2D614E59F FOREIGN KEY (matter_id) REFERENCES school_matter (id)');
$this->addSql('ALTER TABLE school_average_report_card ADD CONSTRAINT FK_7F4631F2C419A321 FOREIGN KEY (sub_matter_id) REFERENCES school_sub_matter (id)');
$this->addSql('ALTER TABLE school_matter ADD CONSTRAINT FK_4D6298A38565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE school_matter ADD CONSTRAINT FK_4D6298A35FB14BA7 FOREIGN KEY (level_id) REFERENCES setting_level (id)');
$this->addSql('ALTER TABLE school_matter ADD CONSTRAINT FK_4D6298A36DF38874 FOREIGN KEY (matter_type_id) REFERENCES school_matter_type (id)');
$this->addSql('ALTER TABLE school_matter_type ADD CONSTRAINT FK_900C25398565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE school_note_appreciation ADD CONSTRAINT FK_4B9A27358565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE school_report_card ADD CONSTRAINT FK_363E47988565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE school_report_card ADD CONSTRAINT FK_363E4798D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE school_report_card ADD CONSTRAINT FK_363E4798D17A6B27 FOREIGN KEY (school_year_periode_id) REFERENCES school_year_periode (id)');
$this->addSql('ALTER TABLE school_report_card ADD CONSTRAINT FK_363E4798DF990765 FOREIGN KEY (student_registration_id) REFERENCES registration_student_registration (id)');
$this->addSql('ALTER TABLE school_report_card ADD CONSTRAINT FK_363E47986278D5A8 FOREIGN KEY (classroom_id) REFERENCES setting_classroom (id)');
$this->addSql('ALTER TABLE school_report_card ADD CONSTRAINT FK_363E47982A55E720 FOREIGN KEY (report_card_id) REFERENCES report_card (id)');
$this->addSql('ALTER TABLE school_sub_matter ADD CONSTRAINT FK_B72E54D18565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE school_sub_matter ADD CONSTRAINT FK_B72E54D15FB14BA7 FOREIGN KEY (level_id) REFERENCES setting_level (id)');
$this->addSql('ALTER TABLE school_sub_matter ADD CONSTRAINT FK_B72E54D1D614E59F FOREIGN KEY (matter_id) REFERENCES school_matter (id)');
$this->addSql('ALTER TABLE school_teacher ADD CONSTRAINT FK_22D9944D8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE school_teacher ADD CONSTRAINT FK_22D9944DD2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE school_teacher ADD CONSTRAINT FK_22D9944DB0FDF16E FOREIGN KEY (salary_id) REFERENCES rh_salary (id)');
$this->addSql('ALTER TABLE school_teacher_setting_classroom ADD CONSTRAINT FK_26717AD7F421FEEF FOREIGN KEY (school_teacher_id) REFERENCES school_teacher (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE school_teacher_setting_classroom ADD CONSTRAINT FK_26717AD77AF43AAE FOREIGN KEY (setting_classroom_id) REFERENCES setting_classroom (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE school_teacher_school_matter ADD CONSTRAINT FK_DF408F17F421FEEF FOREIGN KEY (school_teacher_id) REFERENCES school_teacher (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE school_teacher_school_matter ADD CONSTRAINT FK_DF408F17A75B2622 FOREIGN KEY (school_matter_id) REFERENCES school_matter (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE school_year_periode ADD CONSTRAINT FK_4A5E65348565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE school_year_periode ADD CONSTRAINT FK_4A5E6534D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE setting_classroom ADD CONSTRAINT FK_14BBA2A78565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE setting_classroom ADD CONSTRAINT FK_14BBA2A75FB14BA7 FOREIGN KEY (level_id) REFERENCES setting_level (id)');
$this->addSql('ALTER TABLE setting_classroom ADD CONSTRAINT FK_14BBA2A7680CAB68 FOREIGN KEY (faculty_id) REFERENCES setting_faculty (id)');
$this->addSql('ALTER TABLE setting_classroom ADD CONSTRAINT FK_14BBA2A7A6005CA0 FOREIGN KEY (round_id) REFERENCES setting_round (id)');
$this->addSql('ALTER TABLE setting_classroom ADD CONSTRAINT FK_14BBA2A7D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE setting_cycle ADD CONSTRAINT FK_F92E22F28565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE setting_cycle ADD CONSTRAINT FK_F92E22F229C12A34 FOREIGN KEY (studies_director_id) REFERENCES rh_salary (id)');
$this->addSql('ALTER TABLE setting_document_to_provide ADD CONSTRAINT FK_53B55FB58565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE setting_faculty ADD CONSTRAINT FK_4FC4D0AB8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE setting_faculty ADD CONSTRAINT FK_4FC4D0AB5EC1162 FOREIGN KEY (cycle_id) REFERENCES setting_cycle (id)');
$this->addSql('ALTER TABLE setting_fee ADD CONSTRAINT FK_4378298B8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE setting_fee ADD CONSTRAINT FK_4378298BF83E3874 FOREIGN KEY (accounting_account_id) REFERENCES accounting_account (id)');
$this->addSql('ALTER TABLE setting_fee ADD CONSTRAINT FK_4378298B838EC6C4 FOREIGN KEY (fee_provider_id) REFERENCES setting_fee_provider (id)');
$this->addSql('ALTER TABLE setting_fee ADD CONSTRAINT FK_4378298BD2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE setting_fee_setting_level ADD CONSTRAINT FK_E95E62AA91B957F7 FOREIGN KEY (setting_fee_id) REFERENCES setting_fee (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE setting_fee_setting_level ADD CONSTRAINT FK_E95E62AAF138735D FOREIGN KEY (setting_level_id) REFERENCES setting_level (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE setting_fee_provider ADD CONSTRAINT FK_E876379D8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE setting_fee_shedul ADD CONSTRAINT FK_D3DE77E58565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE setting_fee_shedul ADD CONSTRAINT FK_D3DE77E5AB45AECA FOREIGN KEY (fee_id) REFERENCES setting_fee (id)');
$this->addSql('ALTER TABLE setting_learning_difficulty ADD CONSTRAINT FK_D3E0ED78565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE setting_level ADD CONSTRAINT FK_D3423F728565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE setting_level ADD CONSTRAINT FK_D3423F725EC1162 FOREIGN KEY (cycle_id) REFERENCES setting_cycle (id)');
$this->addSql('ALTER TABLE setting_medical_history ADD CONSTRAINT FK_58DDCC078565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE setting_round ADD CONSTRAINT FK_8C4619558565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE setting_round ADD CONSTRAINT FK_8C4619555EC1162 FOREIGN KEY (cycle_id) REFERENCES setting_cycle (id)');
$this->addSql('ALTER TABLE stock_kit_category ADD CONSTRAINT FK_19C0F12AAB45AECA FOREIGN KEY (fee_id) REFERENCES setting_fee (id)');
$this->addSql('ALTER TABLE stock_kit_category ADD CONSTRAINT FK_19C0F12A8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE stock_kit_out ADD CONSTRAINT FK_FB176420F6AF8633 FOREIGN KEY (registration_student_id) REFERENCES registration_student_registration (id)');
$this->addSql('ALTER TABLE stock_kit_out ADD CONSTRAINT FK_FB17642024F16FF2 FOREIGN KEY (kit_category_id) REFERENCES stock_kit_category (id)');
$this->addSql('ALTER TABLE stock_kit_out ADD CONSTRAINT FK_FB1764208565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE stock_kit_out ADD CONSTRAINT FK_FB176420D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE stock_kit_out_line ADD CONSTRAINT FK_1795063EDC4EA84F FOREIGN KEY (stock_kit_out_id) REFERENCES stock_kit_out (id)');
$this->addSql('ALTER TABLE stock_kit_out_line ADD CONSTRAINT FK_1795063E56DF39BB FOREIGN KEY (stock_kit_product_id) REFERENCES stock_kit_product (id)');
$this->addSql('ALTER TABLE stock_kit_out_line ADD CONSTRAINT FK_1795063E4584665A FOREIGN KEY (product_id) REFERENCES stock_product (id)');
$this->addSql('ALTER TABLE stock_kit_out_line ADD CONSTRAINT FK_1795063E8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE stock_kit_out_line ADD CONSTRAINT FK_1795063ED2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE stock_kit_product ADD CONSTRAINT FK_8521817EC5581453 FOREIGN KEY (stock_kit_category_id) REFERENCES stock_kit_category (id)');
$this->addSql('ALTER TABLE stock_kit_product ADD CONSTRAINT FK_8521817E4584665A FOREIGN KEY (product_id) REFERENCES stock_product (id)');
$this->addSql('ALTER TABLE stock_kit_product ADD CONSTRAINT FK_8521817E8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE stock_product ADD CONSTRAINT FK_CAEC140E8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE stock_product_entry ADD CONSTRAINT FK_EE2CCC8838EC6C4 FOREIGN KEY (fee_provider_id) REFERENCES setting_fee_provider (id)');
$this->addSql('ALTER TABLE stock_product_entry ADD CONSTRAINT FK_EE2CCC88565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE stock_product_entry ADD CONSTRAINT FK_EE2CCC8D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE stock_product_entry_line ADD CONSTRAINT FK_5D2A1F09D0B619D0 FOREIGN KEY (stock_product_entry_id) REFERENCES stock_product_entry (id)');
$this->addSql('ALTER TABLE stock_product_entry_line ADD CONSTRAINT FK_5D2A1F094584665A FOREIGN KEY (product_id) REFERENCES stock_product (id)');
$this->addSql('ALTER TABLE stock_product_entry_line ADD CONSTRAINT FK_5D2A1F098565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE stock_product_entry_line ADD CONSTRAINT FK_5D2A1F09D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE stock_product_out ADD CONSTRAINT FK_860B9FB24584665A FOREIGN KEY (product_id) REFERENCES stock_product (id)');
$this->addSql('ALTER TABLE stock_product_out ADD CONSTRAINT FK_860B9FB2B0FDF16E FOREIGN KEY (salary_id) REFERENCES rh_salary (id)');
$this->addSql('ALTER TABLE stock_product_out ADD CONSTRAINT FK_860B9FB28565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE stock_product_out ADD CONSTRAINT FK_860B9FB2D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE stock_provider_kit_entry ADD CONSTRAINT FK_9D82004524F16FF2 FOREIGN KEY (kit_category_id) REFERENCES stock_kit_category (id)');
$this->addSql('ALTER TABLE stock_provider_kit_entry ADD CONSTRAINT FK_9D8200458565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE stock_provider_kit_entry ADD CONSTRAINT FK_9D820045D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE stock_provider_kit_entry_line ADD CONSTRAINT FK_3A7C286D13A6688A FOREIGN KEY (stock_provider_kit_entry_id) REFERENCES stock_provider_kit_entry (id)');
$this->addSql('ALTER TABLE stock_provider_kit_entry_line ADD CONSTRAINT FK_3A7C286D4584665A FOREIGN KEY (product_id) REFERENCES stock_product (id)');
$this->addSql('ALTER TABLE stock_provider_kit_entry_line ADD CONSTRAINT FK_3A7C286D8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE stock_provider_kit_entry_line ADD CONSTRAINT FK_3A7C286DD2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE stock_provider_kit_entry_line ADD CONSTRAINT FK_3A7C286D56DF39BB FOREIGN KEY (stock_kit_product_id) REFERENCES stock_kit_product (id)');
$this->addSql('ALTER TABLE stock_student_kit_entry ADD CONSTRAINT FK_E8C29105F6AF8633 FOREIGN KEY (registration_student_id) REFERENCES registration_student_registration (id)');
$this->addSql('ALTER TABLE stock_student_kit_entry ADD CONSTRAINT FK_E8C2910524F16FF2 FOREIGN KEY (kit_category_id) REFERENCES stock_kit_category (id)');
$this->addSql('ALTER TABLE stock_student_kit_entry ADD CONSTRAINT FK_E8C291058565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE stock_student_kit_entry ADD CONSTRAINT FK_E8C29105D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE stock_student_kit_entry_line ADD CONSTRAINT FK_45A1F6967DBA1FF4 FOREIGN KEY (stock_student_kit_entry_id) REFERENCES stock_student_kit_entry (id)');
$this->addSql('ALTER TABLE stock_student_kit_entry_line ADD CONSTRAINT FK_45A1F69656DF39BB FOREIGN KEY (stock_kit_product_id) REFERENCES stock_kit_product (id)');
$this->addSql('ALTER TABLE stock_student_kit_entry_line ADD CONSTRAINT FK_45A1F6964584665A FOREIGN KEY (product_id) REFERENCES stock_product (id)');
$this->addSql('ALTER TABLE stock_student_kit_entry_line ADD CONSTRAINT FK_45A1F6968565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE stock_student_kit_entry_line ADD CONSTRAINT FK_45A1F696D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE transport_vehicle ADD CONSTRAINT FK_8F5724778565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE transport_vehicle ADD CONSTRAINT FK_8F572477C3423909 FOREIGN KEY (driver_id) REFERENCES rh_salary (id)');
$this->addSql('ALTER TABLE transport_vehicle ADD CONSTRAINT FK_8F572477CA3477EB FOREIGN KEY (conveyor_id) REFERENCES rh_salary (id)');
$this->addSql('ALTER TABLE transport_vehicle ADD CONSTRAINT FK_8F5724777975B7E7 FOREIGN KEY (model_id) REFERENCES transport_vehicle_model (id)');
$this->addSql('ALTER TABLE transport_vehicle_administrative_document ADD CONSTRAINT FK_F60E39E4545317D1 FOREIGN KEY (vehicle_id) REFERENCES transport_vehicle (id)');
$this->addSql('ALTER TABLE transport_vehicle_administrative_document ADD CONSTRAINT FK_F60E39E48565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE transport_vehicle_fuel_tracking ADD CONSTRAINT FK_68A952A1545317D1 FOREIGN KEY (vehicle_id) REFERENCES transport_vehicle (id)');
$this->addSql('ALTER TABLE transport_vehicle_fuel_tracking ADD CONSTRAINT FK_68A952A18565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE transport_vehicle_fuel_tracking ADD CONSTRAINT FK_68A952A16C755722 FOREIGN KEY (buyer_id) REFERENCES rh_salary (id)');
$this->addSql('ALTER TABLE transport_vehicle_fuel_tracking ADD CONSTRAINT FK_68A952A1A53A8AA FOREIGN KEY (provider_id) REFERENCES setting_fee_provider (id)');
$this->addSql('ALTER TABLE transport_vehicle_maintenance ADD CONSTRAINT FK_F58A8C96545317D1 FOREIGN KEY (vehicle_id) REFERENCES transport_vehicle (id)');
$this->addSql('ALTER TABLE transport_vehicle_maintenance ADD CONSTRAINT FK_F58A8C968565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE transport_vehicle_maintenance ADD CONSTRAINT FK_F58A8C966C755722 FOREIGN KEY (buyer_id) REFERENCES rh_salary (id)');
$this->addSql('ALTER TABLE transport_vehicle_maintenance ADD CONSTRAINT FK_F58A8C96A53A8AA FOREIGN KEY (provider_id) REFERENCES setting_fee_provider (id)');
$this->addSql('ALTER TABLE transport_vehicle_mechanical_piece ADD CONSTRAINT FK_31FD5342545317D1 FOREIGN KEY (vehicle_id) REFERENCES transport_vehicle (id)');
$this->addSql('ALTER TABLE transport_vehicle_mechanical_piece ADD CONSTRAINT FK_31FD53428565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE transport_vehicle_model ADD CONSTRAINT FK_C378415E8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE transport_zone ADD CONSTRAINT FK_7D3B97828565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE transport_zone ADD CONSTRAINT FK_7D3B978233189E9B FOREIGN KEY (transport_vehicle_id) REFERENCES transport_vehicle (id)');
$this->addSql('ALTER TABLE transport_zone_setting_fee ADD CONSTRAINT FK_F0EAD390BFBFF5A FOREIGN KEY (transport_zone_id) REFERENCES transport_zone (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE transport_zone_setting_fee ADD CONSTRAINT FK_F0EAD39091B957F7 FOREIGN KEY (setting_fee_id) REFERENCES setting_fee (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE transport_zone_check_point ADD CONSTRAINT FK_9E6D3AFD9F2C3FAB FOREIGN KEY (zone_id) REFERENCES transport_zone (id)');
$this->addSql('ALTER TABLE transport_zone_check_point ADD CONSTRAINT FK_9E6D3AFD8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE transport_zone_check_point ADD CONSTRAINT FK_9E6D3AFD91B957F7 FOREIGN KEY (setting_fee_id) REFERENCES setting_fee (id)');
$this->addSql('ALTER TABLE treasury_cash_movement ADD CONSTRAINT FK_18EEF5C48565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE treasury_cash_movement ADD CONSTRAINT FK_18EEF5C4A917CC69 FOREIGN KEY (cash_register_id) REFERENCES treasury_cash_register (id)');
$this->addSql('ALTER TABLE treasury_cash_register ADD CONSTRAINT FK_B3CA20278565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE treasury_cash_register ADD CONSTRAINT FK_B3CA2027146D8724 FOREIGN KEY (checkout_id) REFERENCES treasury_checkout (id)');
$this->addSql('ALTER TABLE treasury_cash_register ADD CONSTRAINT FK_B3CA2027D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE treasury_checkout ADD CONSTRAINT FK_96CAC4028565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE treasury_checkout ADD CONSTRAINT FK_96CAC402D2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE treasury_payment ADD CONSTRAINT FK_9C720AEEA917CC69 FOREIGN KEY (cash_register_id) REFERENCES treasury_cash_register (id)');
$this->addSql('ALTER TABLE treasury_payment ADD CONSTRAINT FK_9C720AEE8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE treasury_payment ADD CONSTRAINT FK_9C720AEED2EECC3F FOREIGN KEY (school_year_id) REFERENCES school_year (id)');
$this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D6498565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id)');
$this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D649B52D2A75 FOREIGN KEY (establishment_group_id) REFERENCES establishment_group (id)');
$this->addSql('ALTER TABLE user_establishment ADD CONSTRAINT FK_35611CBEA76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE user_establishment ADD CONSTRAINT FK_35611CBE8565851 FOREIGN KEY (establishment_id) REFERENCES establishment (id) ON DELETE CASCADE');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE accounting_account DROP FOREIGN KEY FK_44BEAB93727ACA70');
$this->addSql('ALTER TABLE accounting_expense DROP FOREIGN KEY FK_14B270919B6B5FBA');
$this->addSql('ALTER TABLE accounting_student_registration_fee_shedul_payment DROP FOREIGN KEY FK_ECE70BF3F83E3874');
$this->addSql('ALTER TABLE setting_fee DROP FOREIGN KEY FK_4378298BF83E3874');
$this->addSql('ALTER TABLE accounting_student_registration_fee_shedul DROP FOREIGN KEY FK_656ADA5CC7D2B0C8');
$this->addSql('ALTER TABLE accounting_student_registration_fee_shedul_payment DROP FOREIGN KEY FK_ECE70BF3C7D2B0C8');
$this->addSql('ALTER TABLE registration_student_abandonment_line DROP FOREIGN KEY FK_CAE115D1E82663FB');
$this->addSql('ALTER TABLE registration_student_downgrade_line DROP FOREIGN KEY FK_A436BD26E82663FB');
$this->addSql('ALTER TABLE accounting_student_registration_fee_shedul_payment DROP FOREIGN KEY FK_ECE70BF39D932FE9');
$this->addSql('ALTER TABLE accounting_student_registration_fee_shedul_payment DROP FOREIGN KEY FK_ECE70BF3C276D4E4');
$this->addSql('ALTER TABLE canteen_menu_item DROP FOREIGN KEY FK_FAFA53B983173DD0');
$this->addSql('ALTER TABLE canteen_menu_item DROP FOREIGN KEY FK_FAFA53B9BA9A0115');
$this->addSql('ALTER TABLE canteen_menu_item DROP FOREIGN KEY FK_FAFA53B9ADE11556');
$this->addSql('ALTER TABLE canteen_menu_item DROP FOREIGN KEY FK_FAFA53B9C980789F');
$this->addSql('ALTER TABLE canteen_menu_item DROP FOREIGN KEY FK_FAFA53B9DEFB6CDC');
$this->addSql('ALTER TABLE canteen_menu_item DROP FOREIGN KEY FK_FAFA53B9E7765019');
$this->addSql('ALTER TABLE canteen_menu_item DROP FOREIGN KEY FK_FAFA53B9F00D445A');
$this->addSql('ALTER TABLE canteen_menu_item DROP FOREIGN KEY FK_FAFA53B9194A5639');
$this->addSql('ALTER TABLE canteen_menu_item DROP FOREIGN KEY FK_FAFA53B98B776210');
$this->addSql('ALTER TABLE canteen_stock_movement DROP FOREIGN KEY FK_A521A77935B8E784');
$this->addSql('ALTER TABLE communication_message_registration_student_registration DROP FOREIGN KEY FK_64B41D5687C3C593');
$this->addSql('ALTER TABLE communication_message_setting_classroom DROP FOREIGN KEY FK_1C276FC087C3C593');
$this->addSql('ALTER TABLE communication_message_setting_level DROP FOREIGN KEY FK_1354AE2387C3C593');
$this->addSql('ALTER TABLE communication_message_transport_zone DROP FOREIGN KEY FK_6197E07187C3C593');
$this->addSql('ALTER TABLE communication_message_setting_fee DROP FOREIGN KEY FK_27D16A087C3C593');
$this->addSql('ALTER TABLE communication_message_rh_salary DROP FOREIGN KEY FK_55246A3E87C3C593');
$this->addSql('ALTER TABLE communication_message_rh_department DROP FOREIGN KEY FK_FE45A4F487C3C593');
$this->addSql('ALTER TABLE communication_message_rh_job DROP FOREIGN KEY FK_B1C86EB487C3C593');
$this->addSql('ALTER TABLE communication_message_rh_statut DROP FOREIGN KEY FK_245321F087C3C593');
$this->addSql('ALTER TABLE communication_message DROP FOREIGN KEY FK_C36C1925A1B4F640');
$this->addSql('ALTER TABLE pre_registration_entre_test_report_card DROP FOREIGN KEY FK_3FF2F412D0D2990');
$this->addSql('ALTER TABLE accounting_expense DROP FOREIGN KEY FK_14B270918565851');
$this->addSql('ALTER TABLE accounting_student_registration_fee DROP FOREIGN KEY FK_D7A54C468565851');
$this->addSql('ALTER TABLE accounting_student_registration_fee_shedul DROP FOREIGN KEY FK_656ADA5C8565851');
$this->addSql('ALTER TABLE accounting_student_registration_fee_shedul_payment DROP FOREIGN KEY FK_ECE70BF38565851');
$this->addSql('ALTER TABLE accounting_student_registration_payment DROP FOREIGN KEY FK_3CB5E7FA8565851');
$this->addSql('ALTER TABLE canteen_dish DROP FOREIGN KEY FK_AA233F7C8565851');
$this->addSql('ALTER TABLE canteen_menu DROP FOREIGN KEY FK_425B89578565851');
$this->addSql('ALTER TABLE canteen_menu_item DROP FOREIGN KEY FK_FAFA53B98565851');
$this->addSql('ALTER TABLE canteen_stock_movement DROP FOREIGN KEY FK_A521A7798565851');
$this->addSql('ALTER TABLE canteen_time DROP FOREIGN KEY FK_50CA2B818565851');
$this->addSql('ALTER TABLE canteen_utensil DROP FOREIGN KEY FK_4AB583978565851');
$this->addSql('ALTER TABLE communication_message DROP FOREIGN KEY FK_C36C19258565851');
$this->addSql('ALTER TABLE communication_predefined_message DROP FOREIGN KEY FK_DB930C038565851');
$this->addSql('ALTER TABLE entre_test_report_card DROP FOREIGN KEY FK_C59B67338565851');
$this->addSql('ALTER TABLE matter_average_pre_registration_entry_test DROP FOREIGN KEY FK_4600CF308565851');
$this->addSql('ALTER TABLE pre_registration_entre_test_report_card DROP FOREIGN KEY FK_3FF2F4128565851');
$this->addSql('ALTER TABLE registration_class_change DROP FOREIGN KEY FK_29F5645C8565851');
$this->addSql('ALTER TABLE registration_diet DROP FOREIGN KEY FK_52DA72FC8565851');
$this->addSql('ALTER TABLE registration_student DROP FOREIGN KEY FK_F752FA958565851');
$this->addSql('ALTER TABLE registration_student_abandonment DROP FOREIGN KEY FK_A47242478565851');
$this->addSql('ALTER TABLE registration_student_abandonment_line DROP FOREIGN KEY FK_CAE115D18565851');
$this->addSql('ALTER TABLE registration_student_downgrade DROP FOREIGN KEY FK_B518F4EF8565851');
$this->addSql('ALTER TABLE registration_student_downgrade_line DROP FOREIGN KEY FK_A436BD268565851');
$this->addSql('ALTER TABLE registration_student_pre_registration DROP FOREIGN KEY FK_FAA7D118565851');
$this->addSql('ALTER TABLE registration_student_registration DROP FOREIGN KEY FK_4D4900A08565851');
$this->addSql('ALTER TABLE registration_transport_checkpoint DROP FOREIGN KEY FK_DE7468448565851');
$this->addSql('ALTER TABLE report_card DROP FOREIGN KEY FK_653875288565851');
$this->addSql('ALTER TABLE rh_department DROP FOREIGN KEY FK_3E5335A58565851');
$this->addSql('ALTER TABLE rh_job DROP FOREIGN KEY FK_C99D17FB8565851');
$this->addSql('ALTER TABLE rh_non_taxable_item DROP FOREIGN KEY FK_D6D91C498565851');
$this->addSql('ALTER TABLE rh_pay_slip DROP FOREIGN KEY FK_6990DECB8565851');
$this->addSql('ALTER TABLE rh_pay_slip_non_taxable_item DROP FOREIGN KEY FK_F7D693A08565851');
$this->addSql('ALTER TABLE rh_pay_slip_retained_item DROP FOREIGN KEY FK_D84784AD8565851');
$this->addSql('ALTER TABLE rh_pay_slip_taxable_item DROP FOREIGN KEY FK_80A5899B8565851');
$this->addSql('ALTER TABLE rh_retained_item DROP FOREIGN KEY FK_A984BEA88565851');
$this->addSql('ALTER TABLE rh_salary DROP FOREIGN KEY FK_CB1EC77F8565851');
$this->addSql('ALTER TABLE rh_salary_pay_slip DROP FOREIGN KEY FK_93D79FF18565851');
$this->addSql('ALTER TABLE rh_statut DROP FOREIGN KEY FK_BA698CB18565851');
$this->addSql('ALTER TABLE rh_taxable_item DROP FOREIGN KEY FK_F21A05DF8565851');
$this->addSql('ALTER TABLE school_absence_and_delay DROP FOREIGN KEY FK_AC0DAEB68565851');
$this->addSql('ALTER TABLE school_absence_and_delay_notification DROP FOREIGN KEY FK_BCEC3D88565851');
$this->addSql('ALTER TABLE school_absence_and_delay_notification_line DROP FOREIGN KEY FK_2989D31C8565851');
$this->addSql('ALTER TABLE school_absence_and_delay_report_card_notification DROP FOREIGN KEY FK_180237618565851');
$this->addSql('ALTER TABLE school_absence_and_delay_report_card_notification_line DROP FOREIGN KEY FK_C400163F8565851');
$this->addSql('ALTER TABLE school_absence_and_delay_setting DROP FOREIGN KEY FK_E5784FBF8565851');
$this->addSql('ALTER TABLE school_assessment_by_class DROP FOREIGN KEY FK_643B9C0B8565851');
$this->addSql('ALTER TABLE school_assessment_by_class_by_matter DROP FOREIGN KEY FK_CD8158B88565851');
$this->addSql('ALTER TABLE school_assessment_by_level DROP FOREIGN KEY FK_139A49878565851');
$this->addSql('ALTER TABLE school_assessment_by_level_by_matter DROP FOREIGN KEY FK_2000BCF68565851');
$this->addSql('ALTER TABLE school_average_report_card DROP FOREIGN KEY FK_7F4631F28565851');
$this->addSql('ALTER TABLE school_matter DROP FOREIGN KEY FK_4D6298A38565851');
$this->addSql('ALTER TABLE school_matter_type DROP FOREIGN KEY FK_900C25398565851');
$this->addSql('ALTER TABLE school_note_appreciation DROP FOREIGN KEY FK_4B9A27358565851');
$this->addSql('ALTER TABLE school_report_card DROP FOREIGN KEY FK_363E47988565851');
$this->addSql('ALTER TABLE school_sub_matter DROP FOREIGN KEY FK_B72E54D18565851');
$this->addSql('ALTER TABLE school_teacher DROP FOREIGN KEY FK_22D9944D8565851');
$this->addSql('ALTER TABLE school_year_periode DROP FOREIGN KEY FK_4A5E65348565851');
$this->addSql('ALTER TABLE setting_classroom DROP FOREIGN KEY FK_14BBA2A78565851');
$this->addSql('ALTER TABLE setting_cycle DROP FOREIGN KEY FK_F92E22F28565851');
$this->addSql('ALTER TABLE setting_document_to_provide DROP FOREIGN KEY FK_53B55FB58565851');
$this->addSql('ALTER TABLE setting_faculty DROP FOREIGN KEY FK_4FC4D0AB8565851');
$this->addSql('ALTER TABLE setting_fee DROP FOREIGN KEY FK_4378298B8565851');
$this->addSql('ALTER TABLE setting_fee_provider DROP FOREIGN KEY FK_E876379D8565851');
$this->addSql('ALTER TABLE setting_fee_shedul DROP FOREIGN KEY FK_D3DE77E58565851');
$this->addSql('ALTER TABLE setting_learning_difficulty DROP FOREIGN KEY FK_D3E0ED78565851');
$this->addSql('ALTER TABLE setting_level DROP FOREIGN KEY FK_D3423F728565851');
$this->addSql('ALTER TABLE setting_medical_history DROP FOREIGN KEY FK_58DDCC078565851');
$this->addSql('ALTER TABLE setting_round DROP FOREIGN KEY FK_8C4619558565851');
$this->addSql('ALTER TABLE stock_kit_category DROP FOREIGN KEY FK_19C0F12A8565851');
$this->addSql('ALTER TABLE stock_kit_out DROP FOREIGN KEY FK_FB1764208565851');
$this->addSql('ALTER TABLE stock_kit_out_line DROP FOREIGN KEY FK_1795063E8565851');
$this->addSql('ALTER TABLE stock_kit_product DROP FOREIGN KEY FK_8521817E8565851');
$this->addSql('ALTER TABLE stock_product DROP FOREIGN KEY FK_CAEC140E8565851');
$this->addSql('ALTER TABLE stock_product_entry DROP FOREIGN KEY FK_EE2CCC88565851');
$this->addSql('ALTER TABLE stock_product_entry_line DROP FOREIGN KEY FK_5D2A1F098565851');
$this->addSql('ALTER TABLE stock_product_out DROP FOREIGN KEY FK_860B9FB28565851');
$this->addSql('ALTER TABLE stock_provider_kit_entry DROP FOREIGN KEY FK_9D8200458565851');
$this->addSql('ALTER TABLE stock_provider_kit_entry_line DROP FOREIGN KEY FK_3A7C286D8565851');
$this->addSql('ALTER TABLE stock_student_kit_entry DROP FOREIGN KEY FK_E8C291058565851');
$this->addSql('ALTER TABLE stock_student_kit_entry_line DROP FOREIGN KEY FK_45A1F6968565851');
$this->addSql('ALTER TABLE transport_vehicle DROP FOREIGN KEY FK_8F5724778565851');
$this->addSql('ALTER TABLE transport_vehicle_administrative_document DROP FOREIGN KEY FK_F60E39E48565851');
$this->addSql('ALTER TABLE transport_vehicle_fuel_tracking DROP FOREIGN KEY FK_68A952A18565851');
$this->addSql('ALTER TABLE transport_vehicle_maintenance DROP FOREIGN KEY FK_F58A8C968565851');
$this->addSql('ALTER TABLE transport_vehicle_mechanical_piece DROP FOREIGN KEY FK_31FD53428565851');
$this->addSql('ALTER TABLE transport_vehicle_model DROP FOREIGN KEY FK_C378415E8565851');
$this->addSql('ALTER TABLE transport_zone DROP FOREIGN KEY FK_7D3B97828565851');
$this->addSql('ALTER TABLE transport_zone_check_point DROP FOREIGN KEY FK_9E6D3AFD8565851');
$this->addSql('ALTER TABLE treasury_cash_movement DROP FOREIGN KEY FK_18EEF5C48565851');
$this->addSql('ALTER TABLE treasury_cash_register DROP FOREIGN KEY FK_B3CA20278565851');
$this->addSql('ALTER TABLE treasury_checkout DROP FOREIGN KEY FK_96CAC4028565851');
$this->addSql('ALTER TABLE treasury_payment DROP FOREIGN KEY FK_9C720AEE8565851');
$this->addSql('ALTER TABLE user DROP FOREIGN KEY FK_8D93D6498565851');
$this->addSql('ALTER TABLE user_establishment DROP FOREIGN KEY FK_35611CBE8565851');
$this->addSql('ALTER TABLE establishment DROP FOREIGN KEY FK_DBEFB1EEB52D2A75');
$this->addSql('ALTER TABLE user DROP FOREIGN KEY FK_8D93D649B52D2A75');
$this->addSql('ALTER TABLE matter_average_pre_registration_entry_test DROP FOREIGN KEY FK_4600CF305A800598');
$this->addSql('ALTER TABLE registration_diet DROP FOREIGN KEY FK_52DA72FCF6AF8633');
$this->addSql('ALTER TABLE registration_student_pre_registration DROP FOREIGN KEY FK_FAA7D11CB944F1A');
$this->addSql('ALTER TABLE registration_student_registration DROP FOREIGN KEY FK_4D4900A0CB944F1A');
$this->addSql('ALTER TABLE registration_student_abandonment_line DROP FOREIGN KEY FK_CAE115D16FD06346');
$this->addSql('ALTER TABLE registration_student_downgrade_line DROP FOREIGN KEY FK_A436BD26A743EEF7');
$this->addSql('ALTER TABLE pre_registration_entre_test_report_card DROP FOREIGN KEY FK_3FF2F412D7374135');
$this->addSql('ALTER TABLE registration_student_pre_registration_setting_level DROP FOREIGN KEY FK_7B4E1603D7374135');
$this->addSql('ALTER TABLE registration_student_registration DROP FOREIGN KEY FK_4D4900A0D7374135');
$this->addSql('ALTER TABLE accounting_student_registration_fee DROP FOREIGN KEY FK_D7A54C46DF990765');
$this->addSql('ALTER TABLE accounting_student_registration_payment DROP FOREIGN KEY FK_3CB5E7FADF990765');
$this->addSql('ALTER TABLE communication_message_registration_student_registration DROP FOREIGN KEY FK_64B41D56B0396129');
$this->addSql('ALTER TABLE registration_class_change DROP FOREIGN KEY FK_29F5645CDF990765');
$this->addSql('ALTER TABLE registration_student_abandonment DROP FOREIGN KEY FK_A4724247B0396129');
$this->addSql('ALTER TABLE registration_student_downgrade DROP FOREIGN KEY FK_B518F4EFB0396129');
$this->addSql('ALTER TABLE registration_student_registration_setting_document_to_provide DROP FOREIGN KEY FK_E586E457B0396129');
$this->addSql('ALTER TABLE registration_transport_checkpoint DROP FOREIGN KEY FK_DE746844B0396129');
$this->addSql('ALTER TABLE school_absence_and_delay DROP FOREIGN KEY FK_AC0DAEB6DF990765');
$this->addSql('ALTER TABLE school_assessment_by_class DROP FOREIGN KEY FK_643B9C0BDF990765');
$this->addSql('ALTER TABLE school_assessment_by_class_by_matter DROP FOREIGN KEY FK_CD8158B8DF990765');
$this->addSql('ALTER TABLE school_assessment_by_level DROP FOREIGN KEY FK_139A4987DF990765');
$this->addSql('ALTER TABLE school_assessment_by_level_by_matter DROP FOREIGN KEY FK_2000BCF6DF990765');
$this->addSql('ALTER TABLE school_average_report_card DROP FOREIGN KEY FK_7F4631F2DF990765');
$this->addSql('ALTER TABLE school_report_card DROP FOREIGN KEY FK_363E4798DF990765');
$this->addSql('ALTER TABLE stock_kit_out DROP FOREIGN KEY FK_FB176420F6AF8633');
$this->addSql('ALTER TABLE stock_student_kit_entry DROP FOREIGN KEY FK_E8C29105F6AF8633');
$this->addSql('ALTER TABLE school_report_card DROP FOREIGN KEY FK_363E47982A55E720');
$this->addSql('ALTER TABLE communication_message_rh_department DROP FOREIGN KEY FK_FE45A4F4E9A1987D');
$this->addSql('ALTER TABLE rh_salary DROP FOREIGN KEY FK_CB1EC77FE9A1987D');
$this->addSql('ALTER TABLE communication_message_rh_job DROP FOREIGN KEY FK_B1C86EB454ED32A7');
$this->addSql('ALTER TABLE rh_salary DROP FOREIGN KEY FK_CB1EC77F54ED32A7');
$this->addSql('ALTER TABLE rh_salary_pay_slip DROP FOREIGN KEY FK_93D79FF1140FC72D');
$this->addSql('ALTER TABLE accounting_expense DROP FOREIGN KEY FK_14B27091B0FDF16E');
$this->addSql('ALTER TABLE communication_message_rh_salary DROP FOREIGN KEY FK_55246A3E4758967C');
$this->addSql('ALTER TABLE establishment_group DROP FOREIGN KEY FK_E9D178B0E4919C9B');
$this->addSql('ALTER TABLE rh_salary_pay_slip DROP FOREIGN KEY FK_93D79FF14758967C');
$this->addSql('ALTER TABLE school_teacher DROP FOREIGN KEY FK_22D9944DB0FDF16E');
$this->addSql('ALTER TABLE setting_cycle DROP FOREIGN KEY FK_F92E22F229C12A34');
$this->addSql('ALTER TABLE stock_product_out DROP FOREIGN KEY FK_860B9FB2B0FDF16E');
$this->addSql('ALTER TABLE transport_vehicle DROP FOREIGN KEY FK_8F572477C3423909');
$this->addSql('ALTER TABLE transport_vehicle DROP FOREIGN KEY FK_8F572477CA3477EB');
$this->addSql('ALTER TABLE transport_vehicle_fuel_tracking DROP FOREIGN KEY FK_68A952A16C755722');
$this->addSql('ALTER TABLE transport_vehicle_maintenance DROP FOREIGN KEY FK_F58A8C966C755722');
$this->addSql('ALTER TABLE rh_pay_slip_non_taxable_item DROP FOREIGN KEY FK_F7D693A03C290DE6');
$this->addSql('ALTER TABLE rh_pay_slip_retained_item DROP FOREIGN KEY FK_D84784AD3C290DE6');
$this->addSql('ALTER TABLE rh_pay_slip_taxable_item DROP FOREIGN KEY FK_80A5899B3C290DE6');
$this->addSql('ALTER TABLE communication_message_rh_statut DROP FOREIGN KEY FK_245321F01855F16');
$this->addSql('ALTER TABLE rh_salary DROP FOREIGN KEY FK_CB1EC77FF6203804');
$this->addSql('ALTER TABLE school_absence_and_delay_notification_line DROP FOREIGN KEY FK_2989D31CE9A7AAE4');
$this->addSql('ALTER TABLE school_absence_and_delay_report_card_notification_line DROP FOREIGN KEY FK_C400163FE9A7AAE4');
$this->addSql('ALTER TABLE school_absence_and_delay_notification_line DROP FOREIGN KEY FK_2989D31C79D0CA89');
$this->addSql('ALTER TABLE school_absence_and_delay_report_card_notification_line DROP FOREIGN KEY FK_C400163F515DA527');
$this->addSql('ALTER TABLE matter_average_pre_registration_entry_test DROP FOREIGN KEY FK_4600CF30D614E59F');
$this->addSql('ALTER TABLE school_assessment_by_class_by_matter DROP FOREIGN KEY FK_CD8158B8D614E59F');
$this->addSql('ALTER TABLE school_assessment_by_level_by_matter DROP FOREIGN KEY FK_2000BCF6D614E59F');
$this->addSql('ALTER TABLE school_average_report_card DROP FOREIGN KEY FK_7F4631F2D614E59F');
$this->addSql('ALTER TABLE school_sub_matter DROP FOREIGN KEY FK_B72E54D1D614E59F');
$this->addSql('ALTER TABLE school_teacher_school_matter DROP FOREIGN KEY FK_DF408F17A75B2622');
$this->addSql('ALTER TABLE school_matter DROP FOREIGN KEY FK_4D6298A36DF38874');
$this->addSql('ALTER TABLE school_assessment_by_class DROP FOREIGN KEY FK_643B9C0B2A55E720');
$this->addSql('ALTER TABLE school_assessment_by_class_by_matter DROP FOREIGN KEY FK_CD8158B82A55E720');
$this->addSql('ALTER TABLE school_assessment_by_level DROP FOREIGN KEY FK_139A49872A55E720');
$this->addSql('ALTER TABLE school_assessment_by_level_by_matter DROP FOREIGN KEY FK_2000BCF62A55E720');
$this->addSql('ALTER TABLE school_average_report_card DROP FOREIGN KEY FK_7F4631F22A55E720');
$this->addSql('ALTER TABLE school_average_report_card DROP FOREIGN KEY FK_7F4631F2C419A321');
$this->addSql('ALTER TABLE school_teacher_setting_classroom DROP FOREIGN KEY FK_26717AD7F421FEEF');
$this->addSql('ALTER TABLE school_teacher_school_matter DROP FOREIGN KEY FK_DF408F17F421FEEF');
$this->addSql('ALTER TABLE accounting_expense DROP FOREIGN KEY FK_14B27091D2EECC3F');
$this->addSql('ALTER TABLE accounting_student_registration_payment DROP FOREIGN KEY FK_3CB5E7FAD2EECC3F');
$this->addSql('ALTER TABLE communication_message DROP FOREIGN KEY FK_C36C1925D2EECC3F');
$this->addSql('ALTER TABLE entre_test_report_card DROP FOREIGN KEY FK_C59B6733D2EECC3F');
$this->addSql('ALTER TABLE pre_registration_entre_test_report_card DROP FOREIGN KEY FK_3FF2F412D2EECC3F');
$this->addSql('ALTER TABLE registration_class_change DROP FOREIGN KEY FK_29F5645CD2EECC3F');
$this->addSql('ALTER TABLE registration_student_pre_registration DROP FOREIGN KEY FK_FAA7D11D2EECC3F');
$this->addSql('ALTER TABLE registration_student_registration DROP FOREIGN KEY FK_4D4900A0D2EECC3F');
$this->addSql('ALTER TABLE report_card DROP FOREIGN KEY FK_65387528D2EECC3F');
$this->addSql('ALTER TABLE school_absence_and_delay DROP FOREIGN KEY FK_AC0DAEB6D2EECC3F');
$this->addSql('ALTER TABLE school_absence_and_delay_notification DROP FOREIGN KEY FK_BCEC3D8D2EECC3F');
$this->addSql('ALTER TABLE school_absence_and_delay_notification_line DROP FOREIGN KEY FK_2989D31CD2EECC3F');
$this->addSql('ALTER TABLE school_absence_and_delay_report_card_notification DROP FOREIGN KEY FK_18023761D2EECC3F');
$this->addSql('ALTER TABLE school_absence_and_delay_report_card_notification_line DROP FOREIGN KEY FK_C400163FD2EECC3F');
$this->addSql('ALTER TABLE school_assessment_by_class DROP FOREIGN KEY FK_643B9C0BD2EECC3F');
$this->addSql('ALTER TABLE school_assessment_by_class_by_matter DROP FOREIGN KEY FK_CD8158B8D2EECC3F');
$this->addSql('ALTER TABLE school_assessment_by_level DROP FOREIGN KEY FK_139A4987D2EECC3F');
$this->addSql('ALTER TABLE school_assessment_by_level_by_matter DROP FOREIGN KEY FK_2000BCF6D2EECC3F');
$this->addSql('ALTER TABLE school_average_report_card DROP FOREIGN KEY FK_7F4631F2D2EECC3F');
$this->addSql('ALTER TABLE school_report_card DROP FOREIGN KEY FK_363E4798D2EECC3F');
$this->addSql('ALTER TABLE school_teacher DROP FOREIGN KEY FK_22D9944DD2EECC3F');
$this->addSql('ALTER TABLE school_year_periode DROP FOREIGN KEY FK_4A5E6534D2EECC3F');
$this->addSql('ALTER TABLE setting_classroom DROP FOREIGN KEY FK_14BBA2A7D2EECC3F');
$this->addSql('ALTER TABLE setting_fee DROP FOREIGN KEY FK_4378298BD2EECC3F');
$this->addSql('ALTER TABLE stock_kit_out DROP FOREIGN KEY FK_FB176420D2EECC3F');
$this->addSql('ALTER TABLE stock_kit_out_line DROP FOREIGN KEY FK_1795063ED2EECC3F');
$this->addSql('ALTER TABLE stock_product_entry DROP FOREIGN KEY FK_EE2CCC8D2EECC3F');
$this->addSql('ALTER TABLE stock_product_entry_line DROP FOREIGN KEY FK_5D2A1F09D2EECC3F');
$this->addSql('ALTER TABLE stock_product_out DROP FOREIGN KEY FK_860B9FB2D2EECC3F');
$this->addSql('ALTER TABLE stock_provider_kit_entry DROP FOREIGN KEY FK_9D820045D2EECC3F');
$this->addSql('ALTER TABLE stock_provider_kit_entry_line DROP FOREIGN KEY FK_3A7C286DD2EECC3F');
$this->addSql('ALTER TABLE stock_student_kit_entry DROP FOREIGN KEY FK_E8C29105D2EECC3F');
$this->addSql('ALTER TABLE stock_student_kit_entry_line DROP FOREIGN KEY FK_45A1F696D2EECC3F');
$this->addSql('ALTER TABLE treasury_cash_register DROP FOREIGN KEY FK_B3CA2027D2EECC3F');
$this->addSql('ALTER TABLE treasury_checkout DROP FOREIGN KEY FK_96CAC402D2EECC3F');
$this->addSql('ALTER TABLE treasury_payment DROP FOREIGN KEY FK_9C720AEED2EECC3F');
$this->addSql('ALTER TABLE report_card DROP FOREIGN KEY FK_65387528D17A6B27');
$this->addSql('ALTER TABLE school_absence_and_delay DROP FOREIGN KEY FK_AC0DAEB6D17A6B27');
$this->addSql('ALTER TABLE school_assessment_by_class DROP FOREIGN KEY FK_643B9C0BD17A6B27');
$this->addSql('ALTER TABLE school_assessment_by_class_by_matter DROP FOREIGN KEY FK_CD8158B8D17A6B27');
$this->addSql('ALTER TABLE school_assessment_by_level DROP FOREIGN KEY FK_139A4987D17A6B27');
$this->addSql('ALTER TABLE school_assessment_by_level_by_matter DROP FOREIGN KEY FK_2000BCF6D17A6B27');
$this->addSql('ALTER TABLE school_average_report_card DROP FOREIGN KEY FK_7F4631F2D17A6B27');
$this->addSql('ALTER TABLE school_report_card DROP FOREIGN KEY FK_363E4798D17A6B27');
$this->addSql('ALTER TABLE communication_message_setting_classroom DROP FOREIGN KEY FK_1C276FC07AF43AAE');
$this->addSql('ALTER TABLE registration_class_change DROP FOREIGN KEY FK_29F5645C6278D5A8');
$this->addSql('ALTER TABLE registration_class_change DROP FOREIGN KEY FK_29F5645CB934139E');
$this->addSql('ALTER TABLE registration_student_downgrade DROP FOREIGN KEY FK_B518F4EF61A68B7A');
$this->addSql('ALTER TABLE registration_student_downgrade DROP FOREIGN KEY FK_B518F4EFD3560E67');
$this->addSql('ALTER TABLE registration_student_registration DROP FOREIGN KEY FK_4D4900A06278D5A8');
$this->addSql('ALTER TABLE school_assessment_by_class DROP FOREIGN KEY FK_643B9C0B6278D5A8');
$this->addSql('ALTER TABLE school_assessment_by_class_by_matter DROP FOREIGN KEY FK_CD8158B86278D5A8');
$this->addSql('ALTER TABLE school_average_report_card DROP FOREIGN KEY FK_7F4631F26278D5A8');
$this->addSql('ALTER TABLE school_report_card DROP FOREIGN KEY FK_363E47986278D5A8');
$this->addSql('ALTER TABLE school_teacher_setting_classroom DROP FOREIGN KEY FK_26717AD77AF43AAE');
$this->addSql('ALTER TABLE setting_faculty DROP FOREIGN KEY FK_4FC4D0AB5EC1162');
$this->addSql('ALTER TABLE setting_level DROP FOREIGN KEY FK_D3423F725EC1162');
$this->addSql('ALTER TABLE setting_round DROP FOREIGN KEY FK_8C4619555EC1162');
$this->addSql('ALTER TABLE registration_student_registration_setting_document_to_provide DROP FOREIGN KEY FK_E586E45723FCFF00');
$this->addSql('ALTER TABLE setting_classroom DROP FOREIGN KEY FK_14BBA2A7680CAB68');
$this->addSql('ALTER TABLE accounting_student_registration_fee DROP FOREIGN KEY FK_D7A54C46AB45AECA');
$this->addSql('ALTER TABLE communication_message_setting_fee DROP FOREIGN KEY FK_27D16A091B957F7');
$this->addSql('ALTER TABLE setting_fee_setting_level DROP FOREIGN KEY FK_E95E62AA91B957F7');
$this->addSql('ALTER TABLE setting_fee_shedul DROP FOREIGN KEY FK_D3DE77E5AB45AECA');
$this->addSql('ALTER TABLE stock_kit_category DROP FOREIGN KEY FK_19C0F12AAB45AECA');
$this->addSql('ALTER TABLE transport_zone_setting_fee DROP FOREIGN KEY FK_F0EAD39091B957F7');
$this->addSql('ALTER TABLE transport_zone_check_point DROP FOREIGN KEY FK_9E6D3AFD91B957F7');
$this->addSql('ALTER TABLE setting_fee DROP FOREIGN KEY FK_4378298B838EC6C4');
$this->addSql('ALTER TABLE stock_product_entry DROP FOREIGN KEY FK_EE2CCC8838EC6C4');
$this->addSql('ALTER TABLE transport_vehicle_fuel_tracking DROP FOREIGN KEY FK_68A952A1A53A8AA');
$this->addSql('ALTER TABLE transport_vehicle_maintenance DROP FOREIGN KEY FK_F58A8C96A53A8AA');
$this->addSql('ALTER TABLE registration_student DROP FOREIGN KEY FK_F752FA95951AAEC');
$this->addSql('ALTER TABLE communication_message_setting_level DROP FOREIGN KEY FK_1354AE23F138735D');
$this->addSql('ALTER TABLE entre_test_report_card DROP FOREIGN KEY FK_C59B67335FB14BA7');
$this->addSql('ALTER TABLE pre_registration_entre_test_report_card DROP FOREIGN KEY FK_3FF2F4125FB14BA7');
$this->addSql('ALTER TABLE registration_student DROP FOREIGN KEY FK_F752FA9531F6ABEF');
$this->addSql('ALTER TABLE registration_student_pre_registration DROP FOREIGN KEY FK_FAA7D1131F6ABEF');
$this->addSql('ALTER TABLE registration_student_pre_registration_setting_level DROP FOREIGN KEY FK_7B4E1603F138735D');
$this->addSql('ALTER TABLE report_card DROP FOREIGN KEY FK_653875285FB14BA7');
$this->addSql('ALTER TABLE school_assessment_by_level DROP FOREIGN KEY FK_139A49875FB14BA7');
$this->addSql('ALTER TABLE school_assessment_by_level_by_matter DROP FOREIGN KEY FK_2000BCF65FB14BA7');
$this->addSql('ALTER TABLE school_matter DROP FOREIGN KEY FK_4D6298A35FB14BA7');
$this->addSql('ALTER TABLE school_sub_matter DROP FOREIGN KEY FK_B72E54D15FB14BA7');
$this->addSql('ALTER TABLE setting_classroom DROP FOREIGN KEY FK_14BBA2A75FB14BA7');
$this->addSql('ALTER TABLE setting_fee_setting_level DROP FOREIGN KEY FK_E95E62AAF138735D');
$this->addSql('ALTER TABLE registration_student DROP FOREIGN KEY FK_F752FA953544AD9E');
$this->addSql('ALTER TABLE setting_classroom DROP FOREIGN KEY FK_14BBA2A7A6005CA0');
$this->addSql('ALTER TABLE stock_kit_out DROP FOREIGN KEY FK_FB17642024F16FF2');
$this->addSql('ALTER TABLE stock_kit_product DROP FOREIGN KEY FK_8521817EC5581453');
$this->addSql('ALTER TABLE stock_provider_kit_entry DROP FOREIGN KEY FK_9D82004524F16FF2');
$this->addSql('ALTER TABLE stock_student_kit_entry DROP FOREIGN KEY FK_E8C2910524F16FF2');
$this->addSql('ALTER TABLE stock_kit_out_line DROP FOREIGN KEY FK_1795063EDC4EA84F');
$this->addSql('ALTER TABLE stock_kit_out_line DROP FOREIGN KEY FK_1795063E56DF39BB');
$this->addSql('ALTER TABLE stock_provider_kit_entry_line DROP FOREIGN KEY FK_3A7C286D56DF39BB');
$this->addSql('ALTER TABLE stock_student_kit_entry_line DROP FOREIGN KEY FK_45A1F69656DF39BB');
$this->addSql('ALTER TABLE stock_kit_out_line DROP FOREIGN KEY FK_1795063E4584665A');
$this->addSql('ALTER TABLE stock_kit_product DROP FOREIGN KEY FK_8521817E4584665A');
$this->addSql('ALTER TABLE stock_product_entry_line DROP FOREIGN KEY FK_5D2A1F094584665A');
$this->addSql('ALTER TABLE stock_product_out DROP FOREIGN KEY FK_860B9FB24584665A');
$this->addSql('ALTER TABLE stock_provider_kit_entry_line DROP FOREIGN KEY FK_3A7C286D4584665A');
$this->addSql('ALTER TABLE stock_student_kit_entry_line DROP FOREIGN KEY FK_45A1F6964584665A');
$this->addSql('ALTER TABLE stock_product_entry_line DROP FOREIGN KEY FK_5D2A1F09D0B619D0');
$this->addSql('ALTER TABLE stock_provider_kit_entry_line DROP FOREIGN KEY FK_3A7C286D13A6688A');
$this->addSql('ALTER TABLE stock_student_kit_entry_line DROP FOREIGN KEY FK_45A1F6967DBA1FF4');
$this->addSql('ALTER TABLE registration_transport_checkpoint DROP FOREIGN KEY FK_DE74684433189E9B');
$this->addSql('ALTER TABLE transport_vehicle_administrative_document DROP FOREIGN KEY FK_F60E39E4545317D1');
$this->addSql('ALTER TABLE transport_vehicle_fuel_tracking DROP FOREIGN KEY FK_68A952A1545317D1');
$this->addSql('ALTER TABLE transport_vehicle_maintenance DROP FOREIGN KEY FK_F58A8C96545317D1');
$this->addSql('ALTER TABLE transport_vehicle_mechanical_piece DROP FOREIGN KEY FK_31FD5342545317D1');
$this->addSql('ALTER TABLE transport_zone DROP FOREIGN KEY FK_7D3B978233189E9B');
$this->addSql('ALTER TABLE transport_vehicle DROP FOREIGN KEY FK_8F5724777975B7E7');
$this->addSql('ALTER TABLE communication_message_transport_zone DROP FOREIGN KEY FK_6197E071BFBFF5A');
$this->addSql('ALTER TABLE registration_transport_checkpoint DROP FOREIGN KEY FK_DE746844BFBFF5A');
$this->addSql('ALTER TABLE transport_zone_setting_fee DROP FOREIGN KEY FK_F0EAD390BFBFF5A');
$this->addSql('ALTER TABLE transport_zone_check_point DROP FOREIGN KEY FK_9E6D3AFD9F2C3FAB');
$this->addSql('ALTER TABLE registration_transport_checkpoint DROP FOREIGN KEY FK_DE746844CDF7E6B1');
$this->addSql('ALTER TABLE accounting_expense DROP FOREIGN KEY FK_14B27091C2FF77B0');
$this->addSql('ALTER TABLE accounting_student_registration_fee_shedul_payment DROP FOREIGN KEY FK_ECE70BF3C2FF77B0');
$this->addSql('ALTER TABLE accounting_expense DROP FOREIGN KEY FK_14B27091A917CC69');
$this->addSql('ALTER TABLE accounting_student_registration_fee_shedul_payment DROP FOREIGN KEY FK_ECE70BF3A917CC69');
$this->addSql('ALTER TABLE accounting_student_registration_payment DROP FOREIGN KEY FK_3CB5E7FAA917CC69');
$this->addSql('ALTER TABLE treasury_cash_movement DROP FOREIGN KEY FK_18EEF5C4A917CC69');
$this->addSql('ALTER TABLE treasury_payment DROP FOREIGN KEY FK_9C720AEEA917CC69');
$this->addSql('ALTER TABLE treasury_cash_register DROP FOREIGN KEY FK_B3CA2027146D8724');
$this->addSql('ALTER TABLE rh_salary DROP FOREIGN KEY FK_CB1EC77FA76ED395');
$this->addSql('ALTER TABLE user_establishment DROP FOREIGN KEY FK_35611CBEA76ED395');
$this->addSql('DROP TABLE accounting_account');
$this->addSql('DROP TABLE accounting_expense');
$this->addSql('DROP TABLE accounting_student_registration_fee');
$this->addSql('DROP TABLE accounting_student_registration_fee_shedul');
$this->addSql('DROP TABLE accounting_student_registration_fee_shedul_payment');
$this->addSql('DROP TABLE accounting_student_registration_payment');
$this->addSql('DROP TABLE canteen_dish');
$this->addSql('DROP TABLE canteen_menu');
$this->addSql('DROP TABLE canteen_menu_item');
$this->addSql('DROP TABLE canteen_stock_movement');
$this->addSql('DROP TABLE canteen_time');
$this->addSql('DROP TABLE canteen_utensil');
$this->addSql('DROP TABLE communication_message');
$this->addSql('DROP TABLE communication_message_registration_student_registration');
$this->addSql('DROP TABLE communication_message_setting_classroom');
$this->addSql('DROP TABLE communication_message_setting_level');
$this->addSql('DROP TABLE communication_message_transport_zone');
$this->addSql('DROP TABLE communication_message_setting_fee');
$this->addSql('DROP TABLE communication_message_rh_salary');
$this->addSql('DROP TABLE communication_message_rh_department');
$this->addSql('DROP TABLE communication_message_rh_job');
$this->addSql('DROP TABLE communication_message_rh_statut');
$this->addSql('DROP TABLE communication_predefined_message');
$this->addSql('DROP TABLE entre_test_report_card');
$this->addSql('DROP TABLE establishment');
$this->addSql('DROP TABLE establishment_group');
$this->addSql('DROP TABLE matter_average_pre_registration_entry_test');
$this->addSql('DROP TABLE pre_registration_entre_test_report_card');
$this->addSql('DROP TABLE registration_class_change');
$this->addSql('DROP TABLE registration_diet');
$this->addSql('DROP TABLE registration_student');
$this->addSql('DROP TABLE registration_student_abandonment');
$this->addSql('DROP TABLE registration_student_abandonment_line');
$this->addSql('DROP TABLE registration_student_downgrade');
$this->addSql('DROP TABLE registration_student_downgrade_line');
$this->addSql('DROP TABLE registration_student_pre_registration');
$this->addSql('DROP TABLE registration_student_pre_registration_setting_level');
$this->addSql('DROP TABLE registration_student_registration');
$this->addSql('DROP TABLE registration_student_registration_setting_document_to_provide');
$this->addSql('DROP TABLE registration_transport_checkpoint');
$this->addSql('DROP TABLE report_card');
$this->addSql('DROP TABLE rh_department');
$this->addSql('DROP TABLE rh_job');
$this->addSql('DROP TABLE rh_non_taxable_item');
$this->addSql('DROP TABLE rh_pay_slip');
$this->addSql('DROP TABLE rh_pay_slip_non_taxable_item');
$this->addSql('DROP TABLE rh_pay_slip_retained_item');
$this->addSql('DROP TABLE rh_pay_slip_taxable_item');
$this->addSql('DROP TABLE rh_retained_item');
$this->addSql('DROP TABLE rh_salary');
$this->addSql('DROP TABLE rh_salary_pay_slip');
$this->addSql('DROP TABLE rh_statut');
$this->addSql('DROP TABLE rh_taxable_item');
$this->addSql('DROP TABLE school_absence_and_delay');
$this->addSql('DROP TABLE school_absence_and_delay_notification');
$this->addSql('DROP TABLE school_absence_and_delay_notification_line');
$this->addSql('DROP TABLE school_absence_and_delay_report_card_notification');
$this->addSql('DROP TABLE school_absence_and_delay_report_card_notification_line');
$this->addSql('DROP TABLE school_absence_and_delay_setting');
$this->addSql('DROP TABLE school_assessment_by_class');
$this->addSql('DROP TABLE school_assessment_by_class_by_matter');
$this->addSql('DROP TABLE school_assessment_by_level');
$this->addSql('DROP TABLE school_assessment_by_level_by_matter');
$this->addSql('DROP TABLE school_average_report_card');
$this->addSql('DROP TABLE school_matter');
$this->addSql('DROP TABLE school_matter_type');
$this->addSql('DROP TABLE school_note_appreciation');
$this->addSql('DROP TABLE school_report_card');
$this->addSql('DROP TABLE school_sub_matter');
$this->addSql('DROP TABLE school_teacher');
$this->addSql('DROP TABLE school_teacher_setting_classroom');
$this->addSql('DROP TABLE school_teacher_school_matter');
$this->addSql('DROP TABLE school_year');
$this->addSql('DROP TABLE school_year_periode');
$this->addSql('DROP TABLE setting_classroom');
$this->addSql('DROP TABLE setting_cycle');
$this->addSql('DROP TABLE setting_document_to_provide');
$this->addSql('DROP TABLE setting_faculty');
$this->addSql('DROP TABLE setting_fee');
$this->addSql('DROP TABLE setting_fee_setting_level');
$this->addSql('DROP TABLE setting_fee_provider');
$this->addSql('DROP TABLE setting_fee_shedul');
$this->addSql('DROP TABLE setting_learning_difficulty');
$this->addSql('DROP TABLE setting_level');
$this->addSql('DROP TABLE setting_medical_history');
$this->addSql('DROP TABLE setting_round');
$this->addSql('DROP TABLE stock_kit_category');
$this->addSql('DROP TABLE stock_kit_out');
$this->addSql('DROP TABLE stock_kit_out_line');
$this->addSql('DROP TABLE stock_kit_product');
$this->addSql('DROP TABLE stock_product');
$this->addSql('DROP TABLE stock_product_entry');
$this->addSql('DROP TABLE stock_product_entry_line');
$this->addSql('DROP TABLE stock_product_out');
$this->addSql('DROP TABLE stock_provider_kit_entry');
$this->addSql('DROP TABLE stock_provider_kit_entry_line');
$this->addSql('DROP TABLE stock_student_kit_entry');
$this->addSql('DROP TABLE stock_student_kit_entry_line');
$this->addSql('DROP TABLE transport_vehicle');
$this->addSql('DROP TABLE transport_vehicle_administrative_document');
$this->addSql('DROP TABLE transport_vehicle_fuel_tracking');
$this->addSql('DROP TABLE transport_vehicle_maintenance');
$this->addSql('DROP TABLE transport_vehicle_mechanical_piece');
$this->addSql('DROP TABLE transport_vehicle_model');
$this->addSql('DROP TABLE transport_zone');
$this->addSql('DROP TABLE transport_zone_setting_fee');
$this->addSql('DROP TABLE transport_zone_check_point');
$this->addSql('DROP TABLE treasury_cash_movement');
$this->addSql('DROP TABLE treasury_cash_register');
$this->addSql('DROP TABLE treasury_checkout');
$this->addSql('DROP TABLE treasury_payment');
$this->addSql('DROP TABLE user');
$this->addSql('DROP TABLE user_establishment');
}
}