<?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 Version20220812100505 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 SEQUENCE abstract_collaborator_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE abstract_financial_margin_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE abstract_people_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE address_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE certificate_of_ownership_file_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE city_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE country_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE currency_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE gender_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE genealogy_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE identity_verification_image_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE language_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE mandate_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE margin_check_list_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE neighborhood_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE production_managerial_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE property_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE property_address_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE property_diffusion_mode_reference_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE property_images_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE property_visit_voucher_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE qualification_level_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_candidate_status_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_collaborator_state_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_collaborator_status_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_contact_type_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_financing_mode_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_mandate_status_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_mandate_type_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_person_marital_status_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_property_construction_type_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_property_contract_type_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_property_destination_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_property_domain_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_property_land_type_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_property_orientation_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_property_service_type_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_property_state_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_property_status_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_property_type_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_transaction_fees_payment_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_transaction_payment_method_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_transaction_rental_type_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_transaction_status_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reference_transaction_type_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE reset_password_request_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE sector_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE transaction_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE vat_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE TABLE abstract_collaborator (id INT NOT NULL, address_id INT NOT NULL, gender_id INT NOT NULL, reference_status_id INT DEFAULT NULL, reference_marital_status_id INT DEFAULT NULL, first_name VARCHAR(255) NOT NULL, last_name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, professional_email VARCHAR(255) NOT NULL, birth_day DATE DEFAULT NULL, phone VARCHAR(255) NOT NULL, main_phone VARCHAR(255) NOT NULL, roles JSON NOT NULL, password VARCHAR(255) NOT NULL, type VARCHAR(12) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_F306F14DE7927C74 ON abstract_collaborator (email)');
$this->addSql('CREATE UNIQUE INDEX UNIQ_F306F14DE713249B ON abstract_collaborator (main_phone)');
$this->addSql('CREATE UNIQUE INDEX UNIQ_F306F14DF5B7AF75 ON abstract_collaborator (address_id)');
$this->addSql('CREATE INDEX IDX_F306F14D708A0E0 ON abstract_collaborator (gender_id)');
$this->addSql('CREATE INDEX IDX_F306F14DAB95664B ON abstract_collaborator (reference_status_id)');
$this->addSql('CREATE INDEX IDX_F306F14D9812DB27 ON abstract_collaborator (reference_marital_status_id)');
$this->addSql('CREATE INDEX abstract_collaborator_search_idx ON abstract_collaborator (first_name, last_name, email, main_phone)');
$this->addSql('CREATE TABLE abstract_financial_margin (id INT NOT NULL, margin_check_list_id INT NOT NULL, input_agent_commission DOUBLE PRECISION DEFAULT NULL, output_agent_commission DOUBLE PRECISION DEFAULT NULL, input_prescriber_commission DOUBLE PRECISION DEFAULT NULL, output_prescriber_commission DOUBLE PRECISION DEFAULT NULL, input_recommendation DOUBLE PRECISION DEFAULT NULL, output_recommendation_commission DOUBLE PRECISION DEFAULT NULL, is_has_same_agent BOOLEAN DEFAULT NULL, is_has_same_recommendation BOOLEAN DEFAULT NULL, type VARCHAR(12) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_F5D6BCA3FB0B1CFA ON abstract_financial_margin (margin_check_list_id)');
$this->addSql('CREATE TABLE abstract_people (id INT NOT NULL, address_id INT DEFAULT NULL, gender_id INT NOT NULL, reference_marital_status_id INT DEFAULT NULL, first_name VARCHAR(255) NOT NULL, last_name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, birth_day DATE DEFAULT NULL, phone VARCHAR(255) DEFAULT NULL, main_phone VARCHAR(255) NOT NULL, roles JSON NOT NULL, company_name VARCHAR(255) DEFAULT NULL, created_at DATE NOT NULL, updated_at DATE NOT NULL, type VARCHAR(12) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_F8018805E7927C74 ON abstract_people (email)');
$this->addSql('CREATE UNIQUE INDEX UNIQ_F8018805E713249B ON abstract_people (main_phone)');
$this->addSql('CREATE UNIQUE INDEX UNIQ_F8018805F5B7AF75 ON abstract_people (address_id)');
$this->addSql('CREATE INDEX IDX_F8018805708A0E0 ON abstract_people (gender_id)');
$this->addSql('CREATE INDEX IDX_F80188059812DB27 ON abstract_people (reference_marital_status_id)');
$this->addSql('CREATE INDEX abstract_people_search_idx ON abstract_people (first_name, last_name, email, main_phone)');
$this->addSql('CREATE TABLE acquired_margin (id INT NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE address (id INT NOT NULL, city_id INT DEFAULT NULL, country_id INT DEFAULT NULL, first_address TEXT DEFAULT NULL, second_address TEXT DEFAULT NULL, contact_city TEXT DEFAULT NULL, zip_code VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_D4E6F818BAC62AF ON address (city_id)');
$this->addSql('CREATE INDEX IDX_D4E6F81F92F3E70 ON address (country_id)');
$this->addSql('CREATE TABLE agent (id INT NOT NULL, qualification_level_id INT DEFAULT NULL, sector_id INT DEFAULT NULL, manager_id INT DEFAULT NULL, status_id INT DEFAULT NULL, sponsor_id INT DEFAULT NULL, cin VARCHAR(255) NOT NULL, is_recommender BOOLEAN NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_268B9C9D9916C7D ON agent (qualification_level_id)');
$this->addSql('CREATE UNIQUE INDEX UNIQ_268B9C9DDE95C867 ON agent (sector_id)');
$this->addSql('CREATE INDEX IDX_268B9C9D783E3463 ON agent (manager_id)');
$this->addSql('CREATE INDEX IDX_268B9C9D6BF700BD ON agent (status_id)');
$this->addSql('CREATE INDEX IDX_268B9C9D12F7FB51 ON agent (sponsor_id)');
$this->addSql('CREATE TABLE candidate (id INT NOT NULL, sponsor_id INT NOT NULL, reference_status_id INT NOT NULL, sector_id INT DEFAULT NULL, cin TEXT NOT NULL, refuse_reason TEXT DEFAULT NULL, common_company_identifier VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_C8B28E44ABE530DA ON candidate (cin)');
$this->addSql('CREATE INDEX IDX_C8B28E4412F7FB51 ON candidate (sponsor_id)');
$this->addSql('CREATE INDEX IDX_C8B28E44AB95664B ON candidate (reference_status_id)');
$this->addSql('CREATE UNIQUE INDEX UNIQ_C8B28E44DE95C867 ON candidate (sector_id)');
$this->addSql('CREATE TABLE certificate_of_ownership_file (id INT NOT NULL, property_id INT NOT NULL, file_path VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_81B3387C549213EC ON certificate_of_ownership_file (property_id)');
$this->addSql('CREATE TABLE city (id INT NOT NULL, country_id INT NOT NULL, name VARCHAR(255) NOT NULL, latitude NUMERIC(20, 16) DEFAULT NULL, longitude NUMERIC(20, 16) DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_2D5B0234F92F3E70 ON city (country_id)');
$this->addSql('CREATE TABLE contact (id INT NOT NULL, collaborator_id INT NOT NULL, contact_type_reference_id INT NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_4C62E63830098C8C ON contact (collaborator_id)');
$this->addSql('CREATE INDEX IDX_4C62E63866A5C9FB ON contact (contact_type_reference_id)');
$this->addSql('CREATE TABLE country (id INT NOT NULL, language_id INT DEFAULT NULL, currency_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_5373C96682F1BAF4 ON country (language_id)');
$this->addSql('CREATE INDEX IDX_5373C96638248176 ON country (currency_id)');
$this->addSql('CREATE TABLE currency (id INT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE gender (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE genealogy (id INT NOT NULL, tutor_id INT DEFAULT NULL, collaborator_id INT NOT NULL, tree_left INT NOT NULL, level INT NOT NULL, tree_right INT NOT NULL, root INT DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_50FC51EE208F64F1 ON genealogy (tutor_id)');
$this->addSql('CREATE INDEX IDX_50FC51EE30098C8C ON genealogy (collaborator_id)');
$this->addSql('CREATE TABLE identity_verification_image (id INT NOT NULL, candidate_id INT DEFAULT NULL, file_path VARCHAR(255) DEFAULT NULL, type VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_E05364D591BD8781 ON identity_verification_image (candidate_id)');
$this->addSql('CREATE TABLE language (id INT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE lead_recruitment (uuid UUID NOT NULL, city_id INT DEFAULT NULL, first_name VARCHAR(255) DEFAULT NULL, last_name VARCHAR(255) DEFAULT NULL, email VARCHAR(255) DEFAULT NULL, phone VARCHAR(255) DEFAULT NULL, zip_code VARCHAR(255) DEFAULT NULL, PRIMARY KEY(uuid))');
$this->addSql('CREATE INDEX IDX_3EB2C81A8BAC62AF ON lead_recruitment (city_id)');
$this->addSql('COMMENT ON COLUMN lead_recruitment.uuid IS \'(DC2Type:ulid)\'');
$this->addSql('CREATE TABLE lead_recruitment_request (uuid UUID NOT NULL, agent_id INT DEFAULT NULL, lead_uuid UUID DEFAULT NULL, request_token VARCHAR(255) DEFAULT NULL, response INT DEFAULT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, PRIMARY KEY(uuid))');
$this->addSql('CREATE INDEX IDX_144526743414710B ON lead_recruitment_request (agent_id)');
$this->addSql('CREATE INDEX IDX_144526743089157C ON lead_recruitment_request (lead_uuid)');
$this->addSql('COMMENT ON COLUMN lead_recruitment_request.uuid IS \'(DC2Type:ulid)\'');
$this->addSql('COMMENT ON COLUMN lead_recruitment_request.lead_uuid IS \'(DC2Type:ulid)\'');
$this->addSql('CREATE TABLE manager (id INT NOT NULL, count_agent_assignment_number INT NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE manager_back_office (id INT NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE manager_it (id INT NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE mandate (id INT NOT NULL, property_id INT DEFAULT NULL, reference_mandate_type_id INT NOT NULL, reference_mandate_status_id INT NOT NULL, reference_property_type_id INT DEFAULT NULL, maximum_price DOUBLE PRECISION DEFAULT NULL, minimal_area DOUBLE PRECISION DEFAULT NULL, maximal_area DOUBLE PRECISION DEFAULT NULL, key VARCHAR(255) DEFAULT NULL, commission DOUBLE PRECISION DEFAULT NULL, created_at DATE NOT NULL, updated_at DATE NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_197D0FEE549213EC ON mandate (property_id)');
$this->addSql('CREATE INDEX IDX_197D0FEEDE631099 ON mandate (reference_mandate_type_id)');
$this->addSql('CREATE INDEX IDX_197D0FEE68A12C77 ON mandate (reference_mandate_status_id)');
$this->addSql('CREATE INDEX IDX_197D0FEED03DEF64 ON mandate (reference_property_type_id)');
$this->addSql('CREATE TABLE margin_check_list (id INT NOT NULL, transaction_id INT NOT NULL, total_commission DOUBLE PRECISION NOT NULL, paid_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, created_at DATE NOT NULL, updated_at DATE NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_99D6F5CE2FC0CB0F ON margin_check_list (transaction_id)');
$this->addSql('CREATE TABLE margin_provisional (id INT NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE neighborhood (id INT NOT NULL, city_id INT DEFAULT NULL, name VARCHAR(150) DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_FEF1E9EE8BAC62AF ON neighborhood (city_id)');
$this->addSql('CREATE TABLE prescriber (id INT NOT NULL, collaborator_id INT NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_289384BA30098C8C ON prescriber (collaborator_id)');
$this->addSql('CREATE TABLE production_managerial (id INT NOT NULL, margin_check_list_id INT NOT NULL, agent_id INT NOT NULL, acquired_commission DOUBLE PRECISION DEFAULT NULL, previsional_commission DOUBLE PRECISION DEFAULT NULL, date DATE DEFAULT NULL, type_es VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_F87B0BE0FB0B1CFA ON production_managerial (margin_check_list_id)');
$this->addSql('CREATE INDEX IDX_F87B0BE03414710B ON production_managerial (agent_id)');
$this->addSql('CREATE TABLE property (id INT NOT NULL, property_address_id INT NOT NULL, collaborator_id INT DEFAULT NULL, contact_id INT DEFAULT NULL, prescriber_id INT DEFAULT NULL, manager_id INT DEFAULT NULL, reference_property_domain_id INT DEFAULT NULL, refrence_property_state_id INT DEFAULT NULL, reference_property_contract_type_id INT DEFAULT NULL, reference_property_land_type_id INT DEFAULT NULL, reference_property_destination_id INT DEFAULT NULL, reference_property_construction_type_id INT DEFAULT NULL, reference_property_orientation_type_id INT DEFAULT NULL, reference_property_status_id INT NOT NULL, reference_service_type_id INT DEFAULT NULL, reference_property_type_id INT DEFAULT NULL, recommendation_id INT DEFAULT NULL, maximal_area DOUBLE PRECISION DEFAULT NULL, minimal_area DOUBLE PRECISION DEFAULT NULL, minimal_price DOUBLE PRECISION DEFAULT NULL, maximum_price DOUBLE PRECISION NOT NULL, rooms_number INT DEFAULT NULL, is_available BOOLEAN DEFAULT NULL, date_availability DATE DEFAULT NULL, construction_year DATE DEFAULT NULL, floors_number INT DEFAULT NULL, is_furnished BOOLEAN NOT NULL, has_guardian BOOLEAN DEFAULT NULL, has_intercom BOOLEAN DEFAULT NULL, has_elevator BOOLEAN DEFAULT NULL, has_terrace BOOLEAN DEFAULT NULL, has_balcony BOOLEAN DEFAULT NULL, has_garage BOOLEAN DEFAULT NULL, has_park_car BOOLEAN DEFAULT NULL, has_park_car_outside BOOLEAN DEFAULT NULL, has_cellar BOOLEAN DEFAULT NULL, has_basement BOOLEAN NOT NULL, description TEXT NOT NULL, archived_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, property_title_number VARCHAR(255) DEFAULT NULL, booking_number VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_8BF21CDE40168F46 ON property (property_address_id)');
$this->addSql('CREATE INDEX IDX_8BF21CDE30098C8C ON property (collaborator_id)');
$this->addSql('CREATE INDEX IDX_8BF21CDEE7A1254A ON property (contact_id)');
$this->addSql('CREATE INDEX IDX_8BF21CDE9861216F ON property (prescriber_id)');
$this->addSql('CREATE INDEX IDX_8BF21CDE783E3463 ON property (manager_id)');
$this->addSql('CREATE INDEX IDX_8BF21CDE9E195C0C ON property (reference_property_domain_id)');
$this->addSql('CREATE INDEX IDX_8BF21CDE11C699D1 ON property (refrence_property_state_id)');
$this->addSql('CREATE INDEX IDX_8BF21CDE78EAB0E7 ON property (reference_property_contract_type_id)');
$this->addSql('CREATE INDEX IDX_8BF21CDE6C51C821 ON property (reference_property_land_type_id)');
$this->addSql('CREATE INDEX IDX_8BF21CDEDA07631 ON property (reference_property_destination_id)');
$this->addSql('CREATE INDEX IDX_8BF21CDEBC6F194B ON property (reference_property_construction_type_id)');
$this->addSql('CREATE INDEX IDX_8BF21CDE8A466047 ON property (reference_property_orientation_type_id)');
$this->addSql('CREATE INDEX IDX_8BF21CDEE4B15254 ON property (reference_property_status_id)');
$this->addSql('CREATE INDEX IDX_8BF21CDEDFF10F2E ON property (reference_service_type_id)');
$this->addSql('CREATE INDEX IDX_8BF21CDED03DEF64 ON property (reference_property_type_id)');
$this->addSql('CREATE INDEX IDX_8BF21CDED173940B ON property (recommendation_id)');
$this->addSql('COMMENT ON COLUMN property.date_availability IS \'(DC2Type:date_immutable)\'');
$this->addSql('COMMENT ON COLUMN property.construction_year IS \'(DC2Type:date_immutable)\'');
$this->addSql('CREATE TABLE property_property_diffusion_mode_reference (property_id INT NOT NULL, property_diffusion_mode_reference_id INT NOT NULL, PRIMARY KEY(property_id, property_diffusion_mode_reference_id))');
$this->addSql('CREATE INDEX IDX_B13C424E549213EC ON property_property_diffusion_mode_reference (property_id)');
$this->addSql('CREATE INDEX IDX_B13C424E37FDE162 ON property_property_diffusion_mode_reference (property_diffusion_mode_reference_id)');
$this->addSql('CREATE TABLE property_address (id INT NOT NULL, city_id INT NOT NULL, neighborhood_id INT DEFAULT NULL, first_address TEXT DEFAULT NULL, second_address TEXT DEFAULT NULL, zip_code VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_548325F98BAC62AF ON property_address (city_id)');
$this->addSql('CREATE INDEX IDX_548325F9803BB24B ON property_address (neighborhood_id)');
$this->addSql('CREATE TABLE property_diffusion_mode_reference (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE property_images (id INT NOT NULL, property_id INT NOT NULL, file_path VARCHAR(255) DEFAULT NULL, archived BOOLEAN DEFAULT NULL, position INT DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_9E68D116549213EC ON property_images (property_id)');
$this->addSql('CREATE TABLE property_matching (uuid UUID NOT NULL, property_id INT DEFAULT NULL, agent_id INT DEFAULT NULL, specs_uuid UUID DEFAULT NULL, matching_type VARCHAR(255) NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, PRIMARY KEY(uuid))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_8297C6CD549213EC ON property_matching (property_id)');
$this->addSql('CREATE INDEX IDX_8297C6CD3414710B ON property_matching (agent_id)');
$this->addSql('CREATE UNIQUE INDEX UNIQ_8297C6CDEBCCC550 ON property_matching (specs_uuid)');
$this->addSql('COMMENT ON COLUMN property_matching.uuid IS \'(DC2Type:ulid)\'');
$this->addSql('COMMENT ON COLUMN property_matching.specs_uuid IS \'(DC2Type:ulid)\'');
$this->addSql('COMMENT ON COLUMN property_matching.created_at IS \'(DC2Type:datetime_immutable)\'');
$this->addSql('CREATE TABLE property_matching_specs (uuid UUID NOT NULL, living_surface DOUBLE PRECISION DEFAULT NULL, number_of_rooms INT DEFAULT NULL, number_of_pieces INT DEFAULT NULL, price DOUBLE PRECISION DEFAULT NULL, property_types TEXT DEFAULT NULL, sectors TEXT DEFAULT NULL, features TEXT DEFAULT NULL, PRIMARY KEY(uuid))');
$this->addSql('COMMENT ON COLUMN property_matching_specs.uuid IS \'(DC2Type:ulid)\'');
$this->addSql('COMMENT ON COLUMN property_matching_specs.property_types IS \'(DC2Type:array)\'');
$this->addSql('COMMENT ON COLUMN property_matching_specs.sectors IS \'(DC2Type:array)\'');
$this->addSql('COMMENT ON COLUMN property_matching_specs.features IS \'(DC2Type:array)\'');
$this->addSql('CREATE TABLE property_visit_voucher (id INT NOT NULL, transaction_id INT DEFAULT NULL, created_by INT NOT NULL, created_at DATE NOT NULL, updated_at DATE NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_57634DBF2FC0CB0F ON property_visit_voucher (transaction_id)');
$this->addSql('CREATE TABLE qualification_level (id INT NOT NULL, level INT NOT NULL, recurrence DOUBLE PRECISION NOT NULL, label VARCHAR(255) NOT NULL, qualification_level_goal INT NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_candidate_status (id INT NOT NULL, code VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_collaborator_state (id INT NOT NULL, code VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_collaborator_status (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_contact_type (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_financing_mode (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_mandate_status (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_mandate_type (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_person_marital_status (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_property_construction_type (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_property_contract_type (id INT NOT NULL, name VARCHAR(100) NOT NULL, code INT NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_property_destination (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_property_domain (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_property_land_type (id INT NOT NULL, name VARCHAR(100) NOT NULL, code INT NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_property_orientation (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_property_service_type (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_property_state (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_property_status (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_property_type (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_transaction_fees_payment (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_transaction_payment_method (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_transaction_rental_type (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_transaction_status (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reference_transaction_type (id INT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE reset_password_request (id INT NOT NULL, user_id INT NOT NULL, selector VARCHAR(20) NOT NULL, hashed_token VARCHAR(100) NOT NULL, requested_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, expires_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_7CE748AA76ED395 ON reset_password_request (user_id)');
$this->addSql('COMMENT ON COLUMN reset_password_request.requested_at IS \'(DC2Type:datetime_immutable)\'');
$this->addSql('COMMENT ON COLUMN reset_password_request.expires_at IS \'(DC2Type:datetime_immutable)\'');
$this->addSql('CREATE TABLE sector (id INT NOT NULL, city_id INT NOT NULL, neighborhood_id INT DEFAULT NULL, zip_code VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_4BA3D9E88BAC62AF ON sector (city_id)');
$this->addSql('CREATE INDEX IDX_4BA3D9E8803BB24B ON sector (neighborhood_id)');
$this->addSql('CREATE TABLE transaction (id INT NOT NULL, mandate_id INT NOT NULL, reference_transaction_status_id INT NOT NULL, reference_payment_method_id INT NOT NULL, reference_rental_type_id INT DEFAULT NULL, reference_commission_paid_by_id INT DEFAULT NULL, input_agent_id INT NOT NULL, output_agent_id INT NOT NULL, vat_id INT DEFAULT NULL, input_recommendation_id INT DEFAULT NULL, output_recommendation_id INT DEFAULT NULL, input_prescriber_id INT DEFAULT NULL, output_prescriber_id INT DEFAULT NULL, contact_id INT DEFAULT NULL, reference_financing_mode_id INT DEFAULT NULL, buyer_commission DOUBLE PRECISION DEFAULT NULL, seller_commission DOUBLE PRECISION DEFAULT NULL, total DOUBLE PRECISION DEFAULT NULL, sell_price_with_tax DOUBLE PRECISION NOT NULL, fees_with_tax DOUBLE PRECISION DEFAULT NULL, fees_without_tax DOUBLE PRECISION DEFAULT NULL, under_comprise_at DATE NOT NULL, valide_at DATE DEFAULT NULL, rental_start_date DATE DEFAULT NULL, rental_end_date DATE DEFAULT NULL, rental_price DOUBLE PRECISION DEFAULT NULL, recorded_at DATE DEFAULT NULL, paid_at DATE DEFAULT NULL, canceled_at DATE DEFAULT NULL, expected_date_of_compromise DATE DEFAULT NULL, invoice_number VARCHAR(255) DEFAULT NULL, invoice_date DATE DEFAULT NULL, property_value DOUBLE PRECISION NOT NULL, advance DOUBLE PRECISION DEFAULT NULL, apport DOUBLE PRECISION DEFAULT NULL, created_at DATE NOT NULL, updated_at DATE NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_723705D16C1129CD ON transaction (mandate_id)');
$this->addSql('CREATE INDEX IDX_723705D156D45B74 ON transaction (reference_transaction_status_id)');
$this->addSql('CREATE INDEX IDX_723705D127EA34D7 ON transaction (reference_payment_method_id)');
$this->addSql('CREATE INDEX IDX_723705D14F3A935E ON transaction (reference_rental_type_id)');
$this->addSql('CREATE INDEX IDX_723705D1728B4176 ON transaction (reference_commission_paid_by_id)');
$this->addSql('CREATE INDEX IDX_723705D1AF65A522 ON transaction (input_agent_id)');
$this->addSql('CREATE INDEX IDX_723705D17DA434C1 ON transaction (output_agent_id)');
$this->addSql('CREATE INDEX IDX_723705D1B5B63A6B ON transaction (vat_id)');
$this->addSql('CREATE INDEX IDX_723705D140C8E50A ON transaction (input_recommendation_id)');
$this->addSql('CREATE INDEX IDX_723705D195C5C550 ON transaction (output_recommendation_id)');
$this->addSql('CREATE INDEX IDX_723705D13A001362 ON transaction (input_prescriber_id)');
$this->addSql('CREATE INDEX IDX_723705D173EB7346 ON transaction (output_prescriber_id)');
$this->addSql('CREATE INDEX IDX_723705D1E7A1254A ON transaction (contact_id)');
$this->addSql('CREATE INDEX IDX_723705D12B3320E8 ON transaction (reference_financing_mode_id)');
$this->addSql('CREATE TABLE vat (id INT NOT NULL, tax VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('ALTER TABLE abstract_collaborator ADD CONSTRAINT FK_F306F14DF5B7AF75 FOREIGN KEY (address_id) REFERENCES address (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE abstract_collaborator ADD CONSTRAINT FK_F306F14D708A0E0 FOREIGN KEY (gender_id) REFERENCES gender (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE abstract_collaborator ADD CONSTRAINT FK_F306F14DAB95664B FOREIGN KEY (reference_status_id) REFERENCES reference_collaborator_status (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE abstract_collaborator ADD CONSTRAINT FK_F306F14D9812DB27 FOREIGN KEY (reference_marital_status_id) REFERENCES reference_person_marital_status (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE abstract_financial_margin ADD CONSTRAINT FK_F5D6BCA3FB0B1CFA FOREIGN KEY (margin_check_list_id) REFERENCES margin_check_list (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE abstract_people ADD CONSTRAINT FK_F8018805F5B7AF75 FOREIGN KEY (address_id) REFERENCES address (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE abstract_people ADD CONSTRAINT FK_F8018805708A0E0 FOREIGN KEY (gender_id) REFERENCES gender (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE abstract_people ADD CONSTRAINT FK_F80188059812DB27 FOREIGN KEY (reference_marital_status_id) REFERENCES reference_person_marital_status (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE acquired_margin ADD CONSTRAINT FK_CB6F016DBF396750 FOREIGN KEY (id) REFERENCES abstract_financial_margin (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE address ADD CONSTRAINT FK_D4E6F818BAC62AF FOREIGN KEY (city_id) REFERENCES city (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE address ADD CONSTRAINT FK_D4E6F81F92F3E70 FOREIGN KEY (country_id) REFERENCES country (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE agent ADD CONSTRAINT FK_268B9C9D9916C7D FOREIGN KEY (qualification_level_id) REFERENCES qualification_level (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE agent ADD CONSTRAINT FK_268B9C9DDE95C867 FOREIGN KEY (sector_id) REFERENCES sector (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE agent ADD CONSTRAINT FK_268B9C9D783E3463 FOREIGN KEY (manager_id) REFERENCES manager (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE agent ADD CONSTRAINT FK_268B9C9D6BF700BD FOREIGN KEY (status_id) REFERENCES reference_collaborator_state (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE agent ADD CONSTRAINT FK_268B9C9D12F7FB51 FOREIGN KEY (sponsor_id) REFERENCES agent (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE agent ADD CONSTRAINT FK_268B9C9DBF396750 FOREIGN KEY (id) REFERENCES abstract_collaborator (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE candidate ADD CONSTRAINT FK_C8B28E4412F7FB51 FOREIGN KEY (sponsor_id) REFERENCES agent (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE candidate ADD CONSTRAINT FK_C8B28E44AB95664B FOREIGN KEY (reference_status_id) REFERENCES reference_candidate_status (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE candidate ADD CONSTRAINT FK_C8B28E44DE95C867 FOREIGN KEY (sector_id) REFERENCES sector (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE candidate ADD CONSTRAINT FK_C8B28E44BF396750 FOREIGN KEY (id) REFERENCES abstract_people (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE certificate_of_ownership_file ADD CONSTRAINT FK_81B3387C549213EC FOREIGN KEY (property_id) REFERENCES property (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE city ADD CONSTRAINT FK_2D5B0234F92F3E70 FOREIGN KEY (country_id) REFERENCES country (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE contact ADD CONSTRAINT FK_4C62E63830098C8C FOREIGN KEY (collaborator_id) REFERENCES agent (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE contact ADD CONSTRAINT FK_4C62E63866A5C9FB FOREIGN KEY (contact_type_reference_id) REFERENCES reference_contact_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE contact ADD CONSTRAINT FK_4C62E638BF396750 FOREIGN KEY (id) REFERENCES abstract_people (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE country ADD CONSTRAINT FK_5373C96682F1BAF4 FOREIGN KEY (language_id) REFERENCES language (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE country ADD CONSTRAINT FK_5373C96638248176 FOREIGN KEY (currency_id) REFERENCES currency (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE genealogy ADD CONSTRAINT FK_50FC51EE208F64F1 FOREIGN KEY (tutor_id) REFERENCES genealogy (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE genealogy ADD CONSTRAINT FK_50FC51EE30098C8C FOREIGN KEY (collaborator_id) REFERENCES agent (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE identity_verification_image ADD CONSTRAINT FK_E05364D591BD8781 FOREIGN KEY (candidate_id) REFERENCES candidate (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE lead_recruitment ADD CONSTRAINT FK_3EB2C81A8BAC62AF FOREIGN KEY (city_id) REFERENCES city (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE lead_recruitment_request ADD CONSTRAINT FK_144526743414710B FOREIGN KEY (agent_id) REFERENCES manager (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE lead_recruitment_request ADD CONSTRAINT FK_144526743089157C FOREIGN KEY (lead_uuid) REFERENCES lead_recruitment (uuid) ON DELETE SET NULL NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE manager ADD CONSTRAINT FK_FA2425B9BF396750 FOREIGN KEY (id) REFERENCES abstract_collaborator (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE manager_back_office ADD CONSTRAINT FK_A024BB98BF396750 FOREIGN KEY (id) REFERENCES abstract_collaborator (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE manager_it ADD CONSTRAINT FK_65892407BF396750 FOREIGN KEY (id) REFERENCES abstract_collaborator (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE mandate ADD CONSTRAINT FK_197D0FEE549213EC FOREIGN KEY (property_id) REFERENCES property (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE mandate ADD CONSTRAINT FK_197D0FEEDE631099 FOREIGN KEY (reference_mandate_type_id) REFERENCES reference_mandate_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE mandate ADD CONSTRAINT FK_197D0FEE68A12C77 FOREIGN KEY (reference_mandate_status_id) REFERENCES reference_mandate_status (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE mandate ADD CONSTRAINT FK_197D0FEED03DEF64 FOREIGN KEY (reference_property_type_id) REFERENCES reference_property_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE margin_check_list ADD CONSTRAINT FK_99D6F5CE2FC0CB0F FOREIGN KEY (transaction_id) REFERENCES transaction (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE margin_provisional ADD CONSTRAINT FK_659F2F79BF396750 FOREIGN KEY (id) REFERENCES abstract_financial_margin (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE neighborhood ADD CONSTRAINT FK_FEF1E9EE8BAC62AF FOREIGN KEY (city_id) REFERENCES city (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE prescriber ADD CONSTRAINT FK_289384BA30098C8C FOREIGN KEY (collaborator_id) REFERENCES agent (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE prescriber ADD CONSTRAINT FK_289384BABF396750 FOREIGN KEY (id) REFERENCES abstract_people (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE production_managerial ADD CONSTRAINT FK_F87B0BE0FB0B1CFA FOREIGN KEY (margin_check_list_id) REFERENCES margin_check_list (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE production_managerial ADD CONSTRAINT FK_F87B0BE03414710B FOREIGN KEY (agent_id) REFERENCES agent (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property ADD CONSTRAINT FK_8BF21CDE40168F46 FOREIGN KEY (property_address_id) REFERENCES property_address (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property ADD CONSTRAINT FK_8BF21CDE30098C8C FOREIGN KEY (collaborator_id) REFERENCES agent (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property ADD CONSTRAINT FK_8BF21CDEE7A1254A FOREIGN KEY (contact_id) REFERENCES contact (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property ADD CONSTRAINT FK_8BF21CDE9861216F FOREIGN KEY (prescriber_id) REFERENCES prescriber (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property ADD CONSTRAINT FK_8BF21CDE783E3463 FOREIGN KEY (manager_id) REFERENCES manager (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property ADD CONSTRAINT FK_8BF21CDE9E195C0C FOREIGN KEY (reference_property_domain_id) REFERENCES reference_property_domain (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property ADD CONSTRAINT FK_8BF21CDE11C699D1 FOREIGN KEY (refrence_property_state_id) REFERENCES reference_property_state (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property ADD CONSTRAINT FK_8BF21CDE78EAB0E7 FOREIGN KEY (reference_property_contract_type_id) REFERENCES reference_property_contract_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property ADD CONSTRAINT FK_8BF21CDE6C51C821 FOREIGN KEY (reference_property_land_type_id) REFERENCES reference_property_land_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property ADD CONSTRAINT FK_8BF21CDEDA07631 FOREIGN KEY (reference_property_destination_id) REFERENCES reference_property_destination (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property ADD CONSTRAINT FK_8BF21CDEBC6F194B FOREIGN KEY (reference_property_construction_type_id) REFERENCES reference_property_construction_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property ADD CONSTRAINT FK_8BF21CDE8A466047 FOREIGN KEY (reference_property_orientation_type_id) REFERENCES reference_property_orientation (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property ADD CONSTRAINT FK_8BF21CDEE4B15254 FOREIGN KEY (reference_property_status_id) REFERENCES reference_property_status (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property ADD CONSTRAINT FK_8BF21CDEDFF10F2E FOREIGN KEY (reference_service_type_id) REFERENCES reference_property_service_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property ADD CONSTRAINT FK_8BF21CDED03DEF64 FOREIGN KEY (reference_property_type_id) REFERENCES reference_property_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property ADD CONSTRAINT FK_8BF21CDED173940B FOREIGN KEY (recommendation_id) REFERENCES agent (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property_property_diffusion_mode_reference ADD CONSTRAINT FK_B13C424E549213EC FOREIGN KEY (property_id) REFERENCES property (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property_property_diffusion_mode_reference ADD CONSTRAINT FK_B13C424E37FDE162 FOREIGN KEY (property_diffusion_mode_reference_id) REFERENCES property_diffusion_mode_reference (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property_address ADD CONSTRAINT FK_548325F98BAC62AF FOREIGN KEY (city_id) REFERENCES city (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property_address ADD CONSTRAINT FK_548325F9803BB24B FOREIGN KEY (neighborhood_id) REFERENCES neighborhood (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property_images ADD CONSTRAINT FK_9E68D116549213EC FOREIGN KEY (property_id) REFERENCES property (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property_matching ADD CONSTRAINT FK_8297C6CD549213EC FOREIGN KEY (property_id) REFERENCES property (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property_matching ADD CONSTRAINT FK_8297C6CD3414710B FOREIGN KEY (agent_id) REFERENCES agent (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property_matching ADD CONSTRAINT FK_8297C6CDEBCCC550 FOREIGN KEY (specs_uuid) REFERENCES property_matching_specs (uuid) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE property_visit_voucher ADD CONSTRAINT FK_57634DBF2FC0CB0F FOREIGN KEY (transaction_id) REFERENCES transaction (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE reset_password_request ADD CONSTRAINT FK_7CE748AA76ED395 FOREIGN KEY (user_id) REFERENCES abstract_collaborator (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE sector ADD CONSTRAINT FK_4BA3D9E88BAC62AF FOREIGN KEY (city_id) REFERENCES city (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE sector ADD CONSTRAINT FK_4BA3D9E8803BB24B FOREIGN KEY (neighborhood_id) REFERENCES neighborhood (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D16C1129CD FOREIGN KEY (mandate_id) REFERENCES mandate (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D156D45B74 FOREIGN KEY (reference_transaction_status_id) REFERENCES reference_transaction_status (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D127EA34D7 FOREIGN KEY (reference_payment_method_id) REFERENCES reference_transaction_payment_method (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D14F3A935E FOREIGN KEY (reference_rental_type_id) REFERENCES reference_transaction_rental_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D1728B4176 FOREIGN KEY (reference_commission_paid_by_id) REFERENCES reference_transaction_fees_payment (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D1AF65A522 FOREIGN KEY (input_agent_id) REFERENCES agent (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D17DA434C1 FOREIGN KEY (output_agent_id) REFERENCES agent (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D1B5B63A6B FOREIGN KEY (vat_id) REFERENCES vat (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D140C8E50A FOREIGN KEY (input_recommendation_id) REFERENCES agent (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D195C5C550 FOREIGN KEY (output_recommendation_id) REFERENCES agent (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D13A001362 FOREIGN KEY (input_prescriber_id) REFERENCES prescriber (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D173EB7346 FOREIGN KEY (output_prescriber_id) REFERENCES prescriber (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D1E7A1254A FOREIGN KEY (contact_id) REFERENCES contact (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D12B3320E8 FOREIGN KEY (reference_financing_mode_id) REFERENCES reference_financing_mode (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('CREATE SCHEMA public');
$this->addSql('ALTER TABLE agent DROP CONSTRAINT FK_268B9C9DBF396750');
$this->addSql('ALTER TABLE manager DROP CONSTRAINT FK_FA2425B9BF396750');
$this->addSql('ALTER TABLE manager_back_office DROP CONSTRAINT FK_A024BB98BF396750');
$this->addSql('ALTER TABLE manager_it DROP CONSTRAINT FK_65892407BF396750');
$this->addSql('ALTER TABLE reset_password_request DROP CONSTRAINT FK_7CE748AA76ED395');
$this->addSql('ALTER TABLE acquired_margin DROP CONSTRAINT FK_CB6F016DBF396750');
$this->addSql('ALTER TABLE margin_provisional DROP CONSTRAINT FK_659F2F79BF396750');
$this->addSql('ALTER TABLE candidate DROP CONSTRAINT FK_C8B28E44BF396750');
$this->addSql('ALTER TABLE contact DROP CONSTRAINT FK_4C62E638BF396750');
$this->addSql('ALTER TABLE prescriber DROP CONSTRAINT FK_289384BABF396750');
$this->addSql('ALTER TABLE abstract_collaborator DROP CONSTRAINT FK_F306F14DF5B7AF75');
$this->addSql('ALTER TABLE abstract_people DROP CONSTRAINT FK_F8018805F5B7AF75');
$this->addSql('ALTER TABLE agent DROP CONSTRAINT FK_268B9C9D12F7FB51');
$this->addSql('ALTER TABLE candidate DROP CONSTRAINT FK_C8B28E4412F7FB51');
$this->addSql('ALTER TABLE contact DROP CONSTRAINT FK_4C62E63830098C8C');
$this->addSql('ALTER TABLE genealogy DROP CONSTRAINT FK_50FC51EE30098C8C');
$this->addSql('ALTER TABLE prescriber DROP CONSTRAINT FK_289384BA30098C8C');
$this->addSql('ALTER TABLE production_managerial DROP CONSTRAINT FK_F87B0BE03414710B');
$this->addSql('ALTER TABLE property DROP CONSTRAINT FK_8BF21CDE30098C8C');
$this->addSql('ALTER TABLE property DROP CONSTRAINT FK_8BF21CDED173940B');
$this->addSql('ALTER TABLE property_matching DROP CONSTRAINT FK_8297C6CD3414710B');
$this->addSql('ALTER TABLE transaction DROP CONSTRAINT FK_723705D1AF65A522');
$this->addSql('ALTER TABLE transaction DROP CONSTRAINT FK_723705D17DA434C1');
$this->addSql('ALTER TABLE transaction DROP CONSTRAINT FK_723705D140C8E50A');
$this->addSql('ALTER TABLE transaction DROP CONSTRAINT FK_723705D195C5C550');
$this->addSql('ALTER TABLE identity_verification_image DROP CONSTRAINT FK_E05364D591BD8781');
$this->addSql('ALTER TABLE address DROP CONSTRAINT FK_D4E6F818BAC62AF');
$this->addSql('ALTER TABLE lead_recruitment DROP CONSTRAINT FK_3EB2C81A8BAC62AF');
$this->addSql('ALTER TABLE neighborhood DROP CONSTRAINT FK_FEF1E9EE8BAC62AF');
$this->addSql('ALTER TABLE property_address DROP CONSTRAINT FK_548325F98BAC62AF');
$this->addSql('ALTER TABLE sector DROP CONSTRAINT FK_4BA3D9E88BAC62AF');
$this->addSql('ALTER TABLE property DROP CONSTRAINT FK_8BF21CDEE7A1254A');
$this->addSql('ALTER TABLE transaction DROP CONSTRAINT FK_723705D1E7A1254A');
$this->addSql('ALTER TABLE address DROP CONSTRAINT FK_D4E6F81F92F3E70');
$this->addSql('ALTER TABLE city DROP CONSTRAINT FK_2D5B0234F92F3E70');
$this->addSql('ALTER TABLE country DROP CONSTRAINT FK_5373C96638248176');
$this->addSql('ALTER TABLE abstract_collaborator DROP CONSTRAINT FK_F306F14D708A0E0');
$this->addSql('ALTER TABLE abstract_people DROP CONSTRAINT FK_F8018805708A0E0');
$this->addSql('ALTER TABLE genealogy DROP CONSTRAINT FK_50FC51EE208F64F1');
$this->addSql('ALTER TABLE country DROP CONSTRAINT FK_5373C96682F1BAF4');
$this->addSql('ALTER TABLE lead_recruitment_request DROP CONSTRAINT FK_144526743089157C');
$this->addSql('ALTER TABLE agent DROP CONSTRAINT FK_268B9C9D783E3463');
$this->addSql('ALTER TABLE lead_recruitment_request DROP CONSTRAINT FK_144526743414710B');
$this->addSql('ALTER TABLE property DROP CONSTRAINT FK_8BF21CDE783E3463');
$this->addSql('ALTER TABLE transaction DROP CONSTRAINT FK_723705D16C1129CD');
$this->addSql('ALTER TABLE abstract_financial_margin DROP CONSTRAINT FK_F5D6BCA3FB0B1CFA');
$this->addSql('ALTER TABLE production_managerial DROP CONSTRAINT FK_F87B0BE0FB0B1CFA');
$this->addSql('ALTER TABLE property_address DROP CONSTRAINT FK_548325F9803BB24B');
$this->addSql('ALTER TABLE sector DROP CONSTRAINT FK_4BA3D9E8803BB24B');
$this->addSql('ALTER TABLE property DROP CONSTRAINT FK_8BF21CDE9861216F');
$this->addSql('ALTER TABLE transaction DROP CONSTRAINT FK_723705D13A001362');
$this->addSql('ALTER TABLE transaction DROP CONSTRAINT FK_723705D173EB7346');
$this->addSql('ALTER TABLE certificate_of_ownership_file DROP CONSTRAINT FK_81B3387C549213EC');
$this->addSql('ALTER TABLE mandate DROP CONSTRAINT FK_197D0FEE549213EC');
$this->addSql('ALTER TABLE property_property_diffusion_mode_reference DROP CONSTRAINT FK_B13C424E549213EC');
$this->addSql('ALTER TABLE property_images DROP CONSTRAINT FK_9E68D116549213EC');
$this->addSql('ALTER TABLE property_matching DROP CONSTRAINT FK_8297C6CD549213EC');
$this->addSql('ALTER TABLE property DROP CONSTRAINT FK_8BF21CDE40168F46');
$this->addSql('ALTER TABLE property_property_diffusion_mode_reference DROP CONSTRAINT FK_B13C424E37FDE162');
$this->addSql('ALTER TABLE property_matching DROP CONSTRAINT FK_8297C6CDEBCCC550');
$this->addSql('ALTER TABLE agent DROP CONSTRAINT FK_268B9C9D9916C7D');
$this->addSql('ALTER TABLE candidate DROP CONSTRAINT FK_C8B28E44AB95664B');
$this->addSql('ALTER TABLE agent DROP CONSTRAINT FK_268B9C9D6BF700BD');
$this->addSql('ALTER TABLE abstract_collaborator DROP CONSTRAINT FK_F306F14DAB95664B');
$this->addSql('ALTER TABLE contact DROP CONSTRAINT FK_4C62E63866A5C9FB');
$this->addSql('ALTER TABLE transaction DROP CONSTRAINT FK_723705D12B3320E8');
$this->addSql('ALTER TABLE mandate DROP CONSTRAINT FK_197D0FEE68A12C77');
$this->addSql('ALTER TABLE mandate DROP CONSTRAINT FK_197D0FEEDE631099');
$this->addSql('ALTER TABLE abstract_collaborator DROP CONSTRAINT FK_F306F14D9812DB27');
$this->addSql('ALTER TABLE abstract_people DROP CONSTRAINT FK_F80188059812DB27');
$this->addSql('ALTER TABLE property DROP CONSTRAINT FK_8BF21CDEBC6F194B');
$this->addSql('ALTER TABLE property DROP CONSTRAINT FK_8BF21CDE78EAB0E7');
$this->addSql('ALTER TABLE property DROP CONSTRAINT FK_8BF21CDEDA07631');
$this->addSql('ALTER TABLE property DROP CONSTRAINT FK_8BF21CDE9E195C0C');
$this->addSql('ALTER TABLE property DROP CONSTRAINT FK_8BF21CDE6C51C821');
$this->addSql('ALTER TABLE property DROP CONSTRAINT FK_8BF21CDE8A466047');
$this->addSql('ALTER TABLE property DROP CONSTRAINT FK_8BF21CDEDFF10F2E');
$this->addSql('ALTER TABLE property DROP CONSTRAINT FK_8BF21CDE11C699D1');
$this->addSql('ALTER TABLE property DROP CONSTRAINT FK_8BF21CDEE4B15254');
$this->addSql('ALTER TABLE mandate DROP CONSTRAINT FK_197D0FEED03DEF64');
$this->addSql('ALTER TABLE property DROP CONSTRAINT FK_8BF21CDED03DEF64');
$this->addSql('ALTER TABLE transaction DROP CONSTRAINT FK_723705D1728B4176');
$this->addSql('ALTER TABLE transaction DROP CONSTRAINT FK_723705D127EA34D7');
$this->addSql('ALTER TABLE transaction DROP CONSTRAINT FK_723705D14F3A935E');
$this->addSql('ALTER TABLE transaction DROP CONSTRAINT FK_723705D156D45B74');
$this->addSql('ALTER TABLE agent DROP CONSTRAINT FK_268B9C9DDE95C867');
$this->addSql('ALTER TABLE candidate DROP CONSTRAINT FK_C8B28E44DE95C867');
$this->addSql('ALTER TABLE margin_check_list DROP CONSTRAINT FK_99D6F5CE2FC0CB0F');
$this->addSql('ALTER TABLE property_visit_voucher DROP CONSTRAINT FK_57634DBF2FC0CB0F');
$this->addSql('ALTER TABLE transaction DROP CONSTRAINT FK_723705D1B5B63A6B');
$this->addSql('DROP SEQUENCE abstract_collaborator_id_seq CASCADE');
$this->addSql('DROP SEQUENCE abstract_financial_margin_id_seq CASCADE');
$this->addSql('DROP SEQUENCE abstract_people_id_seq CASCADE');
$this->addSql('DROP SEQUENCE address_id_seq CASCADE');
$this->addSql('DROP SEQUENCE certificate_of_ownership_file_id_seq CASCADE');
$this->addSql('DROP SEQUENCE city_id_seq CASCADE');
$this->addSql('DROP SEQUENCE country_id_seq CASCADE');
$this->addSql('DROP SEQUENCE currency_id_seq CASCADE');
$this->addSql('DROP SEQUENCE gender_id_seq CASCADE');
$this->addSql('DROP SEQUENCE genealogy_id_seq CASCADE');
$this->addSql('DROP SEQUENCE identity_verification_image_id_seq CASCADE');
$this->addSql('DROP SEQUENCE language_id_seq CASCADE');
$this->addSql('DROP SEQUENCE mandate_id_seq CASCADE');
$this->addSql('DROP SEQUENCE margin_check_list_id_seq CASCADE');
$this->addSql('DROP SEQUENCE neighborhood_id_seq CASCADE');
$this->addSql('DROP SEQUENCE production_managerial_id_seq CASCADE');
$this->addSql('DROP SEQUENCE property_id_seq CASCADE');
$this->addSql('DROP SEQUENCE property_address_id_seq CASCADE');
$this->addSql('DROP SEQUENCE property_diffusion_mode_reference_id_seq CASCADE');
$this->addSql('DROP SEQUENCE property_images_id_seq CASCADE');
$this->addSql('DROP SEQUENCE property_visit_voucher_id_seq CASCADE');
$this->addSql('DROP SEQUENCE qualification_level_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_candidate_status_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_collaborator_state_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_collaborator_status_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_contact_type_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_financing_mode_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_mandate_status_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_mandate_type_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_person_marital_status_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_property_construction_type_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_property_contract_type_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_property_destination_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_property_domain_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_property_land_type_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_property_orientation_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_property_service_type_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_property_state_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_property_status_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_property_type_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_transaction_fees_payment_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_transaction_payment_method_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_transaction_rental_type_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_transaction_status_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reference_transaction_type_id_seq CASCADE');
$this->addSql('DROP SEQUENCE reset_password_request_id_seq CASCADE');
$this->addSql('DROP SEQUENCE sector_id_seq CASCADE');
$this->addSql('DROP SEQUENCE transaction_id_seq CASCADE');
$this->addSql('DROP SEQUENCE vat_id_seq CASCADE');
$this->addSql('DROP TABLE abstract_collaborator');
$this->addSql('DROP TABLE abstract_financial_margin');
$this->addSql('DROP TABLE abstract_people');
$this->addSql('DROP TABLE acquired_margin');
$this->addSql('DROP TABLE address');
$this->addSql('DROP TABLE agent');
$this->addSql('DROP TABLE candidate');
$this->addSql('DROP TABLE certificate_of_ownership_file');
$this->addSql('DROP TABLE city');
$this->addSql('DROP TABLE contact');
$this->addSql('DROP TABLE country');
$this->addSql('DROP TABLE currency');
$this->addSql('DROP TABLE gender');
$this->addSql('DROP TABLE genealogy');
$this->addSql('DROP TABLE identity_verification_image');
$this->addSql('DROP TABLE language');
$this->addSql('DROP TABLE lead_recruitment');
$this->addSql('DROP TABLE lead_recruitment_request');
$this->addSql('DROP TABLE manager');
$this->addSql('DROP TABLE manager_back_office');
$this->addSql('DROP TABLE manager_it');
$this->addSql('DROP TABLE mandate');
$this->addSql('DROP TABLE margin_check_list');
$this->addSql('DROP TABLE margin_provisional');
$this->addSql('DROP TABLE neighborhood');
$this->addSql('DROP TABLE prescriber');
$this->addSql('DROP TABLE production_managerial');
$this->addSql('DROP TABLE property');
$this->addSql('DROP TABLE property_property_diffusion_mode_reference');
$this->addSql('DROP TABLE property_address');
$this->addSql('DROP TABLE property_diffusion_mode_reference');
$this->addSql('DROP TABLE property_images');
$this->addSql('DROP TABLE property_matching');
$this->addSql('DROP TABLE property_matching_specs');
$this->addSql('DROP TABLE property_visit_voucher');
$this->addSql('DROP TABLE qualification_level');
$this->addSql('DROP TABLE reference_candidate_status');
$this->addSql('DROP TABLE reference_collaborator_state');
$this->addSql('DROP TABLE reference_collaborator_status');
$this->addSql('DROP TABLE reference_contact_type');
$this->addSql('DROP TABLE reference_financing_mode');
$this->addSql('DROP TABLE reference_mandate_status');
$this->addSql('DROP TABLE reference_mandate_type');
$this->addSql('DROP TABLE reference_person_marital_status');
$this->addSql('DROP TABLE reference_property_construction_type');
$this->addSql('DROP TABLE reference_property_contract_type');
$this->addSql('DROP TABLE reference_property_destination');
$this->addSql('DROP TABLE reference_property_domain');
$this->addSql('DROP TABLE reference_property_land_type');
$this->addSql('DROP TABLE reference_property_orientation');
$this->addSql('DROP TABLE reference_property_service_type');
$this->addSql('DROP TABLE reference_property_state');
$this->addSql('DROP TABLE reference_property_status');
$this->addSql('DROP TABLE reference_property_type');
$this->addSql('DROP TABLE reference_transaction_fees_payment');
$this->addSql('DROP TABLE reference_transaction_payment_method');
$this->addSql('DROP TABLE reference_transaction_rental_type');
$this->addSql('DROP TABLE reference_transaction_status');
$this->addSql('DROP TABLE reference_transaction_type');
$this->addSql('DROP TABLE reset_password_request');
$this->addSql('DROP TABLE sector');
$this->addSql('DROP TABLE transaction');
$this->addSql('DROP TABLE vat');
}
}