api/src/Migrations/Version20191217100312.php
<?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 Version20191217100312 extends AbstractMigration
{
public function up(Schema $schema) : void
{
// this up() migration is auto-generated, please modify it to your needs
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
$this->addSql('ALTER TABLE action CHANGE in_log in_log TINYINT(1) DEFAULT NULL, CHANGE in_diary in_diary TINYINT(1) DEFAULT NULL, CHANGE progression progression INT DEFAULT NULL, CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE log CHANGE admin_id admin_id INT DEFAULT NULL, CHANGE proposal_id proposal_id INT DEFAULT NULL, CHANGE matching_id matching_id INT DEFAULT NULL, CHANGE ask_id ask_id INT DEFAULT NULL, CHANGE article_id article_id INT DEFAULT NULL, CHANGE event_id event_id INT DEFAULT NULL, CHANGE community_id community_id INT DEFAULT NULL, CHANGE solidary_id solidary_id INT DEFAULT NULL, CHANGE territory_id territory_id INT DEFAULT NULL, CHANGE car_id car_id INT DEFAULT NULL, CHANGE user_related_id user_related_id INT DEFAULT NULL, CHANGE message_id message_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE app CHANGE password password VARCHAR(100) DEFAULT NULL, CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE article CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE paragraph CHANGE section_id section_id INT DEFAULT NULL, CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE section CHANGE article_id article_id INT DEFAULT NULL, CHANGE title title VARCHAR(255) DEFAULT NULL, CHANGE sub_title sub_title VARCHAR(255) DEFAULT NULL, CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE criteria DROP FOREIGN KEY FK_B61F9B818044A959');
$this->addSql('ALTER TABLE criteria DROP FOREIGN KEY FK_B61F9B81A862FD7E');
$this->addSql('ALTER TABLE criteria CHANGE car_id car_id INT DEFAULT NULL, CHANGE direction_driver_id direction_driver_id INT DEFAULT NULL, CHANGE direction_passenger_id direction_passenger_id INT DEFAULT NULL, CHANGE ptjourney_id ptjourney_id INT DEFAULT NULL, CHANGE from_time from_time TIME DEFAULT NULL, CHANGE to_date to_date DATE DEFAULT NULL, CHANGE mon_check mon_check TINYINT(1) DEFAULT NULL, CHANGE tue_check tue_check TINYINT(1) DEFAULT NULL, CHANGE wed_check wed_check TINYINT(1) DEFAULT NULL, CHANGE thu_check thu_check TINYINT(1) DEFAULT NULL, CHANGE fri_check fri_check TINYINT(1) DEFAULT NULL, CHANGE sat_check sat_check TINYINT(1) DEFAULT NULL, CHANGE sun_check sun_check TINYINT(1) DEFAULT NULL, CHANGE mon_time mon_time TIME DEFAULT NULL, CHANGE tue_time tue_time TIME DEFAULT NULL, CHANGE wed_time wed_time TIME DEFAULT NULL, CHANGE thu_time thu_time TIME DEFAULT NULL, CHANGE fri_time fri_time TIME DEFAULT NULL, CHANGE sat_time sat_time TIME DEFAULT NULL, CHANGE sun_time sun_time TIME DEFAULT NULL, CHANGE any_route_as_passenger any_route_as_passenger TINYINT(1) DEFAULT NULL, CHANGE multi_transport_mode multi_transport_mode TINYINT(1) DEFAULT NULL, CHANGE price_km price_km NUMERIC(4, 2) DEFAULT NULL, CHANGE strict_date strict_date TINYINT(1) DEFAULT NULL, CHANGE max_detour_duration max_detour_duration INT DEFAULT NULL, CHANGE max_detour_distance max_detour_distance INT DEFAULT NULL, CHANGE min_time min_time TIME DEFAULT NULL, CHANGE max_time max_time TIME DEFAULT NULL, CHANGE mon_min_time mon_min_time TIME DEFAULT NULL, CHANGE mon_max_time mon_max_time TIME DEFAULT NULL, CHANGE tue_min_time tue_min_time TIME DEFAULT NULL, CHANGE tue_max_time tue_max_time TIME DEFAULT NULL, CHANGE wed_min_time wed_min_time TIME DEFAULT NULL, CHANGE wed_max_time wed_max_time TIME DEFAULT NULL, CHANGE thu_min_time thu_min_time TIME DEFAULT NULL, CHANGE thu_max_time thu_max_time TIME DEFAULT NULL, CHANGE fri_min_time fri_min_time TIME DEFAULT NULL, CHANGE fri_max_time fri_max_time TIME DEFAULT NULL, CHANGE sat_min_time sat_min_time TIME DEFAULT NULL, CHANGE sat_max_time sat_max_time TIME DEFAULT NULL, CHANGE sun_min_time sun_min_time TIME DEFAULT NULL, CHANGE sun_max_time sun_max_time TIME DEFAULT NULL, CHANGE margin_duration margin_duration INT DEFAULT NULL, CHANGE mon_margin_duration mon_margin_duration INT DEFAULT NULL, CHANGE tue_margin_duration tue_margin_duration INT DEFAULT NULL, CHANGE wed_margin_duration wed_margin_duration INT DEFAULT NULL, CHANGE thu_margin_duration thu_margin_duration INT DEFAULT NULL, CHANGE fri_margin_duration fri_margin_duration INT DEFAULT NULL, CHANGE sat_margin_duration sat_margin_duration INT DEFAULT NULL, CHANGE sun_margin_duration sun_margin_duration INT DEFAULT NULL, CHANGE driver driver TINYINT(1) DEFAULT NULL, CHANGE passenger passenger TINYINT(1) DEFAULT NULL, CHANGE luggage luggage TINYINT(1) DEFAULT NULL, CHANGE bike bike TINYINT(1) DEFAULT NULL, CHANGE back_seats back_seats TINYINT(1) DEFAULT NULL, CHANGE solidary solidary TINYINT(1) DEFAULT NULL, CHANGE solidary_exclusive solidary_exclusive TINYINT(1) DEFAULT NULL, CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL, CHANGE strict_punctual strict_punctual TINYINT(1) DEFAULT NULL, CHANGE strict_regular strict_regular TINYINT(1) DEFAULT NULL, CHANGE avoid_motorway avoid_motorway TINYINT(1) DEFAULT NULL, CHANGE avoid_toll avoid_toll TINYINT(1) DEFAULT NULL, CHANGE driver_price driver_price NUMERIC(6, 2) DEFAULT NULL, CHANGE driver_computed_price driver_computed_price NUMERIC(6, 2) DEFAULT NULL, CHANGE driver_computed_rounded_price driver_computed_rounded_price NUMERIC(6, 2) DEFAULT NULL, CHANGE passenger_price passenger_price NUMERIC(6, 2) DEFAULT NULL, CHANGE passenger_computed_price passenger_computed_price NUMERIC(6, 2) DEFAULT NULL, CHANGE passenger_computed_rounded_price passenger_computed_rounded_price NUMERIC(6, 2) DEFAULT NULL');
$this->addSql('ALTER TABLE criteria ADD CONSTRAINT FK_B61F9B818044A959 FOREIGN KEY (direction_passenger_id) REFERENCES direction (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE criteria ADD CONSTRAINT FK_B61F9B81A862FD7E FOREIGN KEY (direction_driver_id) REFERENCES direction (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE ask CHANGE ask_linked_id ask_linked_id INT DEFAULT NULL, CHANGE user_delegate_id user_delegate_id INT DEFAULT NULL, CHANGE user_related_id user_related_id INT DEFAULT NULL, CHANGE ask_id ask_id INT DEFAULT NULL, CHANGE ask_opposite_id ask_opposite_id INT DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE ask_history CHANGE ask_id ask_id INT DEFAULT NULL, CHANGE message_id message_id INT DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE individual_stop CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE matching CHANGE matching_linked_id matching_linked_id INT DEFAULT NULL, CHANGE matching_opposite_id matching_opposite_id INT DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE proposal CHANGE user_id user_id INT DEFAULT NULL, CHANGE proposal_linked_id proposal_linked_id INT DEFAULT NULL, CHANGE criteria_id criteria_id INT DEFAULT NULL, CHANGE user_delegate_id user_delegate_id INT DEFAULT NULL, CHANGE event_id event_id INT DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL, CHANGE private private TINYINT(1) DEFAULT NULL, CHANGE paused paused TINYINT(1) DEFAULT NULL');
$this->addSql('ALTER TABLE waypoint CHANGE proposal_id proposal_id INT DEFAULT NULL, CHANGE matching_id matching_id INT DEFAULT NULL, CHANGE ask_id ask_id INT DEFAULT NULL, CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE medium CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE message CHANGE message_id message_id INT DEFAULT NULL, CHANGE title title VARCHAR(255) DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE notification CHANGE template_title template_title VARCHAR(255) DEFAULT NULL, CHANGE active active TINYINT(1) DEFAULT NULL, CHANGE template_body template_body VARCHAR(255) DEFAULT NULL, CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL, CHANGE user_active_default user_active_default TINYINT(1) DEFAULT NULL, CHANGE user_editable user_editable TINYINT(1) DEFAULT NULL');
$this->addSql('ALTER TABLE notified CHANGE proposal_id proposal_id INT DEFAULT NULL, CHANGE matching_id matching_id INT DEFAULT NULL, CHANGE ask_history_id ask_history_id INT DEFAULT NULL, CHANGE recipient_id recipient_id INT DEFAULT NULL, CHANGE sent_date sent_date DATETIME DEFAULT NULL, CHANGE received_date received_date DATETIME DEFAULT NULL, CHANGE read_date read_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE recipient CHANGE read_date read_date DATETIME DEFAULT NULL, CHANGE sent_date sent_date DATETIME DEFAULT NULL, CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE community CHANGE address_id address_id INT DEFAULT NULL, CHANGE members_hidden members_hidden TINYINT(1) DEFAULT NULL, CHANGE proposals_hidden proposals_hidden TINYINT(1) DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL, CHANGE domain domain VARCHAR(255) DEFAULT NULL, CHANGE status status SMALLINT DEFAULT NULL');
$this->addSql('ALTER TABLE community_user CHANGE admin_id admin_id INT DEFAULT NULL, CHANGE accepted_date accepted_date DATETIME DEFAULT NULL, CHANGE refused_date refused_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE event CHANGE url url VARCHAR(255) DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE address CHANGE user_id user_id INT DEFAULT NULL, CHANGE street_address street_address VARCHAR(255) DEFAULT NULL, CHANGE postal_code postal_code VARCHAR(15) DEFAULT NULL, CHANGE address_locality address_locality VARCHAR(100) DEFAULT NULL, CHANGE address_country address_country VARCHAR(100) DEFAULT NULL, CHANGE latitude latitude NUMERIC(10, 6) DEFAULT NULL, CHANGE longitude longitude NUMERIC(10, 6) DEFAULT NULL, CHANGE elevation elevation INT DEFAULT NULL, CHANGE name name VARCHAR(45) DEFAULT NULL, CHANGE house_number house_number VARCHAR(45) DEFAULT NULL, CHANGE street street VARCHAR(255) DEFAULT NULL, CHANGE sub_locality sub_locality VARCHAR(100) DEFAULT NULL, CHANGE local_admin local_admin VARCHAR(100) DEFAULT NULL, CHANGE county county VARCHAR(100) DEFAULT NULL, CHANGE macro_county macro_county VARCHAR(100) DEFAULT NULL, CHANGE region region VARCHAR(100) DEFAULT NULL, CHANGE macro_region macro_region VARCHAR(100) DEFAULT NULL, CHANGE country_code country_code VARCHAR(10) DEFAULT NULL, CHANGE geo_json geo_json POINT DEFAULT NULL COMMENT \'(DC2Type:point)\', CHANGE home home TINYINT(1) DEFAULT NULL, CHANGE venue venue VARCHAR(255) DEFAULT NULL, CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE direction CHANGE ascend ascend INT DEFAULT NULL, CHANGE descend descend INT DEFAULT NULL, CHANGE bbox_min_lon bbox_min_lon NUMERIC(10, 6) DEFAULT NULL, CHANGE bbox_min_lat bbox_min_lat NUMERIC(10, 6) DEFAULT NULL, CHANGE bbox_max_lon bbox_max_lon NUMERIC(10, 6) DEFAULT NULL, CHANGE bbox_max_lat bbox_max_lat NUMERIC(10, 6) DEFAULT NULL, CHANGE bearing bearing INT DEFAULT NULL, CHANGE geo_json_bbox geo_json_bbox POLYGON DEFAULT NULL COMMENT \'(DC2Type:polygon)\', CHANGE geo_json_detail geo_json_detail LINESTRING DEFAULT NULL COMMENT \'(DC2Type:linestring)\', CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE territory CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE icon CHANGE private_icon_linked_id private_icon_linked_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE image CHANGE event_id event_id INT DEFAULT NULL, CHANGE community_id community_id INT DEFAULT NULL, CHANGE relay_point_id relay_point_id INT DEFAULT NULL, CHANGE relay_point_type_id relay_point_type_id INT DEFAULT NULL, CHANGE user_id user_id INT DEFAULT NULL, CHANGE title title VARCHAR(255) DEFAULT NULL, CHANGE alt alt VARCHAR(255) DEFAULT NULL, CHANGE crop_x1 crop_x1 INT DEFAULT NULL, CHANGE crop_y1 crop_y1 INT DEFAULT NULL, CHANGE crop_x2 crop_x2 INT DEFAULT NULL, CHANGE crop_y2 crop_y2 INT DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE user_import CHANGE user_id user_id INT DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL, CHANGE treatment_user_start_date treatment_user_start_date DATETIME DEFAULT NULL, CHANGE treatment_user_end_date treatment_user_end_date DATETIME DEFAULT NULL, CHANGE treatment_journey_start_date treatment_journey_start_date DATETIME DEFAULT NULL, CHANGE treatment_journey_end_date treatment_journey_end_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE mass CHANGE calculation_date calculation_date DATETIME DEFAULT NULL, CHANGE analyzing_date analyzing_date DATETIME DEFAULT NULL, CHANGE analyzed_date analyzed_date DATETIME DEFAULT NULL, CHANGE calculated_date calculated_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE mass_matching CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE mass_person CHANGE given_name given_name VARCHAR(255) DEFAULT NULL, CHANGE family_name family_name VARCHAR(255) DEFAULT NULL, CHANGE outward_time outward_time TIME DEFAULT NULL, CHANGE return_time return_time TIME DEFAULT NULL, CHANGE distance distance INT DEFAULT NULL, CHANGE duration duration INT DEFAULT NULL, CHANGE bbox_min_lon bbox_min_lon NUMERIC(10, 6) DEFAULT NULL, CHANGE bbox_min_lat bbox_min_lat NUMERIC(10, 6) DEFAULT NULL, CHANGE bbox_max_lon bbox_max_lon NUMERIC(10, 6) DEFAULT NULL, CHANGE bbox_max_lat bbox_max_lat NUMERIC(10, 6) DEFAULT NULL, CHANGE bearing bearing INT DEFAULT NULL, CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE ptarrival CHANGE individual_stop_id individual_stop_id INT DEFAULT NULL, CHANGE name name VARCHAR(100) DEFAULT NULL');
$this->addSql('ALTER TABLE ptdeparture CHANGE individual_stop_id individual_stop_id INT DEFAULT NULL, CHANGE name name VARCHAR(100) DEFAULT NULL');
$this->addSql('ALTER TABLE ptjourney CHANGE distance distance INT DEFAULT NULL, CHANGE duration duration VARCHAR(100) DEFAULT NULL, CHANGE price price NUMERIC(4, 2) DEFAULT NULL');
$this->addSql('ALTER TABLE ptleg CHANGE ptjourney_id ptjourney_id INT DEFAULT NULL, CHANGE ptdeparture_id ptdeparture_id INT DEFAULT NULL, CHANGE ptarrival_id ptarrival_id INT DEFAULT NULL, CHANGE travel_mode_id travel_mode_id INT DEFAULT NULL, CHANGE ptline_id ptline_id INT DEFAULT NULL, CHANGE distance distance INT DEFAULT NULL, CHANGE duration duration INT DEFAULT NULL, CHANGE magnetic_direction magnetic_direction VARCHAR(10) DEFAULT NULL, CHANGE relative_direction relative_direction VARCHAR(10) DEFAULT NULL, CHANGE direction direction VARCHAR(45) DEFAULT NULL');
$this->addSql('ALTER TABLE ptline CHANGE ptcompany_id ptcompany_id INT DEFAULT NULL, CHANGE travel_mode_id travel_mode_id INT DEFAULT NULL, CHANGE number number VARCHAR(10) DEFAULT NULL, CHANGE origin origin VARCHAR(100) DEFAULT NULL, CHANGE destination destination VARCHAR(100) DEFAULT NULL, CHANGE direction direction VARCHAR(255) DEFAULT NULL, CHANGE transport_mode transport_mode INT DEFAULT NULL, CHANGE color color VARCHAR(10) DEFAULT NULL');
$this->addSql('ALTER TABLE ptstep CHANGE ptleg_id ptleg_id INT DEFAULT NULL, CHANGE ptdeparture_id ptdeparture_id INT DEFAULT NULL, CHANGE ptarrival_id ptarrival_id INT DEFAULT NULL, CHANGE distance distance INT DEFAULT NULL, CHANGE duration duration INT DEFAULT NULL, CHANGE magnetic_direction magnetic_direction VARCHAR(10) DEFAULT NULL, CHANGE relative_direction relative_direction VARCHAR(10) DEFAULT NULL');
$this->addSql('ALTER TABLE relay_point CHANGE community_id community_id INT DEFAULT NULL, CHANGE private private TINYINT(1) DEFAULT NULL, CHANGE places places SMALLINT DEFAULT NULL, CHANGE places_disabled places_disabled SMALLINT DEFAULT NULL, CHANGE free free TINYINT(1) DEFAULT NULL, CHANGE secured secured TINYINT(1) DEFAULT NULL, CHANGE official official TINYINT(1) DEFAULT NULL, CHANGE suggested suggested TINYINT(1) DEFAULT NULL, CHANGE permalink permalink VARCHAR(255) DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE relay_point_type CHANGE icon_id icon_id INT DEFAULT NULL, CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE uright CHANGE parent_id parent_id INT DEFAULT NULL, CHANGE description description VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE role CHANGE parent_id parent_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE user_right CHANGE territory_id territory_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE user_role CHANGE territory_id territory_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE solidary CHANGE assisted assisted TINYINT(1) DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE solidary_matching CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE structure CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE subject CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE travel_mode CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE car CHANGE color color VARCHAR(45) DEFAULT NULL, CHANGE siv siv VARCHAR(45) DEFAULT NULL, CHANGE price_km price_km NUMERIC(4, 2) DEFAULT NULL, CHANGE created_date created_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE diary CHANGE solidary_id solidary_id INT DEFAULT NULL, CHANGE solidary_matching_id solidary_matching_id INT DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE user CHANGE given_name given_name VARCHAR(100) DEFAULT NULL, CHANGE family_name family_name VARCHAR(100) DEFAULT NULL, CHANGE password password VARCHAR(100) DEFAULT NULL, CHANGE nationality nationality VARCHAR(100) DEFAULT NULL, CHANGE birth_date birth_date DATE DEFAULT NULL, CHANGE telephone telephone VARCHAR(100) DEFAULT NULL, CHANGE any_route_as_passenger any_route_as_passenger TINYINT(1) DEFAULT NULL, CHANGE multi_transport_mode multi_transport_mode TINYINT(1) DEFAULT NULL, CHANGE max_detour_duration max_detour_duration INT DEFAULT NULL, CHANGE max_detour_distance max_detour_distance INT DEFAULT NULL, CHANGE pwd_token pwd_token VARCHAR(100) DEFAULT NULL, CHANGE geo_token geo_token VARCHAR(100) DEFAULT NULL, CHANGE language language VARCHAR(10) DEFAULT NULL, CHANGE pwd_token_date pwd_token_date DATETIME DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL, CHANGE validated_date validated_date DATETIME DEFAULT NULL, CHANGE validated_date_token validated_date_token VARCHAR(100) DEFAULT NULL, CHANGE facebook_id facebook_id VARCHAR(100) DEFAULT NULL, CHANGE smoke smoke INT DEFAULT NULL, CHANGE music music TINYINT(1) DEFAULT NULL, CHANGE music_favorites music_favorites VARCHAR(255) DEFAULT NULL, CHANGE chat chat TINYINT(1) DEFAULT NULL, CHANGE chat_favorites chat_favorites VARCHAR(255) DEFAULT NULL, CHANGE news_subscription news_subscription TINYINT(1) DEFAULT NULL, CHANGE phone_token phone_token VARCHAR(100) DEFAULT NULL, CHANGE ios_app_id ios_app_id VARCHAR(100) DEFAULT NULL, CHANGE android_app_id android_app_id VARCHAR(100) DEFAULT NULL, CHANGE phone_validated_date phone_validated_date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE user_notification CHANGE active active TINYINT(1) DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT NULL');
}
public function down(Schema $schema) : void
{
// this down() migration is auto-generated, please modify it to your needs
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
$this->addSql('ALTER TABLE action CHANGE in_log in_log TINYINT(1) DEFAULT \'NULL\', CHANGE in_diary in_diary TINYINT(1) DEFAULT \'NULL\', CHANGE progression progression INT DEFAULT NULL, CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE address CHANGE user_id user_id INT DEFAULT NULL, CHANGE house_number house_number VARCHAR(45) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE street street VARCHAR(255) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE street_address street_address VARCHAR(255) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE postal_code postal_code VARCHAR(15) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE sub_locality sub_locality VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE address_locality address_locality VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE local_admin local_admin VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE county county VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE macro_county macro_county VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE region region VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE macro_region macro_region VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE address_country address_country VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE country_code country_code VARCHAR(10) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE latitude latitude NUMERIC(10, 6) DEFAULT \'NULL\', CHANGE longitude longitude NUMERIC(10, 6) DEFAULT \'NULL\', CHANGE elevation elevation INT DEFAULT NULL, CHANGE geo_json geo_json POINT DEFAULT \'NULL\' COMMENT \'(DC2Type:point)\', CHANGE name name VARCHAR(45) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE venue venue VARCHAR(255) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE home home TINYINT(1) DEFAULT \'NULL\', CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE app CHANGE password password VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE article CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE ask CHANGE user_related_id user_related_id INT DEFAULT NULL, CHANGE user_delegate_id user_delegate_id INT DEFAULT NULL, CHANGE ask_id ask_id INT DEFAULT NULL, CHANGE ask_linked_id ask_linked_id INT DEFAULT NULL, CHANGE ask_opposite_id ask_opposite_id INT DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE ask_history CHANGE ask_id ask_id INT DEFAULT NULL, CHANGE message_id message_id INT DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE car CHANGE color color VARCHAR(45) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE siv siv VARCHAR(45) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE price_km price_km NUMERIC(4, 2) DEFAULT \'NULL\', CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE community CHANGE address_id address_id INT DEFAULT NULL, CHANGE status status SMALLINT DEFAULT NULL, CHANGE members_hidden members_hidden TINYINT(1) DEFAULT \'NULL\', CHANGE proposals_hidden proposals_hidden TINYINT(1) DEFAULT \'NULL\', CHANGE domain domain VARCHAR(255) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE community_user CHANGE admin_id admin_id INT DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\', CHANGE accepted_date accepted_date DATETIME DEFAULT \'NULL\', CHANGE refused_date refused_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE criteria DROP FOREIGN KEY FK_B61F9B81A862FD7E');
$this->addSql('ALTER TABLE criteria DROP FOREIGN KEY FK_B61F9B818044A959');
$this->addSql('ALTER TABLE criteria CHANGE car_id car_id INT DEFAULT NULL, CHANGE direction_driver_id direction_driver_id INT DEFAULT NULL, CHANGE direction_passenger_id direction_passenger_id INT DEFAULT NULL, CHANGE ptjourney_id ptjourney_id INT DEFAULT NULL, CHANGE driver driver TINYINT(1) DEFAULT \'NULL\', CHANGE passenger passenger TINYINT(1) DEFAULT \'NULL\', CHANGE from_time from_time TIME DEFAULT \'NULL\', CHANGE min_time min_time TIME DEFAULT \'NULL\', CHANGE max_time max_time TIME DEFAULT \'NULL\', CHANGE margin_duration margin_duration INT DEFAULT NULL, CHANGE strict_date strict_date TINYINT(1) DEFAULT \'NULL\', CHANGE strict_punctual strict_punctual TINYINT(1) DEFAULT \'NULL\', CHANGE strict_regular strict_regular TINYINT(1) DEFAULT \'NULL\', CHANGE to_date to_date DATE DEFAULT \'NULL\', CHANGE mon_check mon_check TINYINT(1) DEFAULT \'NULL\', CHANGE tue_check tue_check TINYINT(1) DEFAULT \'NULL\', CHANGE wed_check wed_check TINYINT(1) DEFAULT \'NULL\', CHANGE thu_check thu_check TINYINT(1) DEFAULT \'NULL\', CHANGE fri_check fri_check TINYINT(1) DEFAULT \'NULL\', CHANGE sat_check sat_check TINYINT(1) DEFAULT \'NULL\', CHANGE sun_check sun_check TINYINT(1) DEFAULT \'NULL\', CHANGE mon_time mon_time TIME DEFAULT \'NULL\', CHANGE mon_min_time mon_min_time TIME DEFAULT \'NULL\', CHANGE mon_max_time mon_max_time TIME DEFAULT \'NULL\', CHANGE tue_time tue_time TIME DEFAULT \'NULL\', CHANGE tue_min_time tue_min_time TIME DEFAULT \'NULL\', CHANGE tue_max_time tue_max_time TIME DEFAULT \'NULL\', CHANGE wed_time wed_time TIME DEFAULT \'NULL\', CHANGE wed_min_time wed_min_time TIME DEFAULT \'NULL\', CHANGE wed_max_time wed_max_time TIME DEFAULT \'NULL\', CHANGE thu_time thu_time TIME DEFAULT \'NULL\', CHANGE thu_min_time thu_min_time TIME DEFAULT \'NULL\', CHANGE thu_max_time thu_max_time TIME DEFAULT \'NULL\', CHANGE fri_time fri_time TIME DEFAULT \'NULL\', CHANGE fri_min_time fri_min_time TIME DEFAULT \'NULL\', CHANGE fri_max_time fri_max_time TIME DEFAULT \'NULL\', CHANGE sat_time sat_time TIME DEFAULT \'NULL\', CHANGE sat_min_time sat_min_time TIME DEFAULT \'NULL\', CHANGE sat_max_time sat_max_time TIME DEFAULT \'NULL\', CHANGE sun_time sun_time TIME DEFAULT \'NULL\', CHANGE sun_min_time sun_min_time TIME DEFAULT \'NULL\', CHANGE sun_max_time sun_max_time TIME DEFAULT \'NULL\', CHANGE mon_margin_duration mon_margin_duration INT DEFAULT NULL, CHANGE tue_margin_duration tue_margin_duration INT DEFAULT NULL, CHANGE wed_margin_duration wed_margin_duration INT DEFAULT NULL, CHANGE thu_margin_duration thu_margin_duration INT DEFAULT NULL, CHANGE fri_margin_duration fri_margin_duration INT DEFAULT NULL, CHANGE sat_margin_duration sat_margin_duration INT DEFAULT NULL, CHANGE sun_margin_duration sun_margin_duration INT DEFAULT NULL, CHANGE max_detour_duration max_detour_duration INT DEFAULT NULL, CHANGE max_detour_distance max_detour_distance INT DEFAULT NULL, CHANGE any_route_as_passenger any_route_as_passenger TINYINT(1) DEFAULT \'NULL\', CHANGE multi_transport_mode multi_transport_mode TINYINT(1) DEFAULT \'NULL\', CHANGE price_km price_km NUMERIC(4, 2) DEFAULT \'NULL\', CHANGE driver_price driver_price NUMERIC(6, 2) DEFAULT \'NULL\', CHANGE driver_computed_price driver_computed_price NUMERIC(6, 2) DEFAULT \'NULL\', CHANGE driver_computed_rounded_price driver_computed_rounded_price NUMERIC(6, 2) DEFAULT \'NULL\', CHANGE passenger_price passenger_price NUMERIC(6, 2) DEFAULT \'NULL\', CHANGE passenger_computed_price passenger_computed_price NUMERIC(6, 2) DEFAULT \'NULL\', CHANGE passenger_computed_rounded_price passenger_computed_rounded_price NUMERIC(6, 2) DEFAULT \'NULL\', CHANGE luggage luggage TINYINT(1) DEFAULT \'NULL\', CHANGE bike bike TINYINT(1) DEFAULT \'NULL\', CHANGE back_seats back_seats TINYINT(1) DEFAULT \'NULL\', CHANGE solidary solidary TINYINT(1) DEFAULT \'NULL\', CHANGE solidary_exclusive solidary_exclusive TINYINT(1) DEFAULT \'NULL\', CHANGE avoid_motorway avoid_motorway TINYINT(1) DEFAULT \'NULL\', CHANGE avoid_toll avoid_toll TINYINT(1) DEFAULT \'NULL\', CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE criteria ADD CONSTRAINT FK_B61F9B81A862FD7E FOREIGN KEY (direction_driver_id) REFERENCES direction (id)');
$this->addSql('ALTER TABLE criteria ADD CONSTRAINT FK_B61F9B818044A959 FOREIGN KEY (direction_passenger_id) REFERENCES direction (id)');
$this->addSql('ALTER TABLE diary CHANGE solidary_id solidary_id INT DEFAULT NULL, CHANGE solidary_matching_id solidary_matching_id INT DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE direction CHANGE ascend ascend INT DEFAULT NULL, CHANGE descend descend INT DEFAULT NULL, CHANGE bbox_min_lon bbox_min_lon NUMERIC(10, 6) DEFAULT \'NULL\', CHANGE bbox_min_lat bbox_min_lat NUMERIC(10, 6) DEFAULT \'NULL\', CHANGE bbox_max_lon bbox_max_lon NUMERIC(10, 6) DEFAULT \'NULL\', CHANGE bbox_max_lat bbox_max_lat NUMERIC(10, 6) DEFAULT \'NULL\', CHANGE geo_json_bbox geo_json_bbox POLYGON DEFAULT \'NULL\' COMMENT \'(DC2Type:polygon)\', CHANGE bearing bearing INT DEFAULT NULL, CHANGE geo_json_detail geo_json_detail LINESTRING DEFAULT \'NULL\' COMMENT \'(DC2Type:linestring)\', CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE event CHANGE url url VARCHAR(255) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE icon CHANGE private_icon_linked_id private_icon_linked_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE image CHANGE event_id event_id INT DEFAULT NULL, CHANGE community_id community_id INT DEFAULT NULL, CHANGE user_id user_id INT DEFAULT NULL, CHANGE relay_point_id relay_point_id INT DEFAULT NULL, CHANGE relay_point_type_id relay_point_type_id INT DEFAULT NULL, CHANGE title title VARCHAR(255) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE alt alt VARCHAR(255) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE crop_x1 crop_x1 INT DEFAULT NULL, CHANGE crop_y1 crop_y1 INT DEFAULT NULL, CHANGE crop_x2 crop_x2 INT DEFAULT NULL, CHANGE crop_y2 crop_y2 INT DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE individual_stop CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE log CHANGE admin_id admin_id INT DEFAULT NULL, CHANGE proposal_id proposal_id INT DEFAULT NULL, CHANGE matching_id matching_id INT DEFAULT NULL, CHANGE ask_id ask_id INT DEFAULT NULL, CHANGE article_id article_id INT DEFAULT NULL, CHANGE event_id event_id INT DEFAULT NULL, CHANGE community_id community_id INT DEFAULT NULL, CHANGE solidary_id solidary_id INT DEFAULT NULL, CHANGE territory_id territory_id INT DEFAULT NULL, CHANGE car_id car_id INT DEFAULT NULL, CHANGE user_related_id user_related_id INT DEFAULT NULL, CHANGE message_id message_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE mass CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\', CHANGE analyzing_date analyzing_date DATETIME DEFAULT \'NULL\', CHANGE analyzed_date analyzed_date DATETIME DEFAULT \'NULL\', CHANGE calculation_date calculation_date DATETIME DEFAULT \'NULL\', CHANGE calculated_date calculated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE mass_matching CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE mass_person CHANGE given_name given_name VARCHAR(255) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE family_name family_name VARCHAR(255) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE distance distance INT DEFAULT NULL, CHANGE duration duration INT DEFAULT NULL, CHANGE bbox_min_lon bbox_min_lon NUMERIC(10, 6) DEFAULT \'NULL\', CHANGE bbox_min_lat bbox_min_lat NUMERIC(10, 6) DEFAULT \'NULL\', CHANGE bbox_max_lon bbox_max_lon NUMERIC(10, 6) DEFAULT \'NULL\', CHANGE bbox_max_lat bbox_max_lat NUMERIC(10, 6) DEFAULT \'NULL\', CHANGE bearing bearing INT DEFAULT NULL, CHANGE outward_time outward_time TIME DEFAULT \'NULL\', CHANGE return_time return_time TIME DEFAULT \'NULL\', CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE matching CHANGE matching_linked_id matching_linked_id INT DEFAULT NULL, CHANGE matching_opposite_id matching_opposite_id INT DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE medium CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE message CHANGE message_id message_id INT DEFAULT NULL, CHANGE title title VARCHAR(255) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE notification CHANGE template_title template_title VARCHAR(255) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE template_body template_body VARCHAR(255) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE active active TINYINT(1) DEFAULT \'NULL\', CHANGE user_active_default user_active_default TINYINT(1) DEFAULT \'NULL\', CHANGE user_editable user_editable TINYINT(1) DEFAULT \'NULL\', CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE notified CHANGE proposal_id proposal_id INT DEFAULT NULL, CHANGE matching_id matching_id INT DEFAULT NULL, CHANGE ask_history_id ask_history_id INT DEFAULT NULL, CHANGE recipient_id recipient_id INT DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\', CHANGE sent_date sent_date DATETIME DEFAULT \'NULL\', CHANGE received_date received_date DATETIME DEFAULT \'NULL\', CHANGE read_date read_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE paragraph CHANGE section_id section_id INT DEFAULT NULL, CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE proposal CHANGE proposal_linked_id proposal_linked_id INT DEFAULT NULL, CHANGE user_id user_id INT DEFAULT NULL, CHANGE user_delegate_id user_delegate_id INT DEFAULT NULL, CHANGE criteria_id criteria_id INT DEFAULT NULL, CHANGE event_id event_id INT DEFAULT NULL, CHANGE private private TINYINT(1) DEFAULT \'NULL\', CHANGE paused paused TINYINT(1) DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE ptarrival CHANGE individual_stop_id individual_stop_id INT DEFAULT NULL, CHANGE name name VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci');
$this->addSql('ALTER TABLE ptdeparture CHANGE individual_stop_id individual_stop_id INT DEFAULT NULL, CHANGE name name VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci');
$this->addSql('ALTER TABLE ptjourney CHANGE distance distance INT DEFAULT NULL, CHANGE duration duration VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE price price NUMERIC(4, 2) DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE ptleg CHANGE ptjourney_id ptjourney_id INT DEFAULT NULL, CHANGE ptdeparture_id ptdeparture_id INT DEFAULT NULL, CHANGE ptarrival_id ptarrival_id INT DEFAULT NULL, CHANGE travel_mode_id travel_mode_id INT DEFAULT NULL, CHANGE ptline_id ptline_id INT DEFAULT NULL, CHANGE distance distance INT DEFAULT NULL, CHANGE duration duration INT DEFAULT NULL, CHANGE magnetic_direction magnetic_direction VARCHAR(10) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE relative_direction relative_direction VARCHAR(10) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE direction direction VARCHAR(45) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci');
$this->addSql('ALTER TABLE ptline CHANGE ptcompany_id ptcompany_id INT DEFAULT NULL, CHANGE travel_mode_id travel_mode_id INT DEFAULT NULL, CHANGE number number VARCHAR(10) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE origin origin VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE destination destination VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE direction direction VARCHAR(255) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE transport_mode transport_mode INT DEFAULT NULL, CHANGE color color VARCHAR(10) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci');
$this->addSql('ALTER TABLE ptstep CHANGE ptleg_id ptleg_id INT DEFAULT NULL, CHANGE ptdeparture_id ptdeparture_id INT DEFAULT NULL, CHANGE ptarrival_id ptarrival_id INT DEFAULT NULL, CHANGE distance distance INT DEFAULT NULL, CHANGE duration duration INT DEFAULT NULL, CHANGE magnetic_direction magnetic_direction VARCHAR(10) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE relative_direction relative_direction VARCHAR(10) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci');
$this->addSql('ALTER TABLE recipient CHANGE sent_date sent_date DATETIME DEFAULT \'NULL\', CHANGE read_date read_date DATETIME DEFAULT \'NULL\', CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE relay_point CHANGE community_id community_id INT DEFAULT NULL, CHANGE private private TINYINT(1) DEFAULT \'NULL\', CHANGE places places SMALLINT DEFAULT NULL, CHANGE places_disabled places_disabled SMALLINT DEFAULT NULL, CHANGE free free TINYINT(1) DEFAULT \'NULL\', CHANGE secured secured TINYINT(1) DEFAULT \'NULL\', CHANGE official official TINYINT(1) DEFAULT \'NULL\', CHANGE suggested suggested TINYINT(1) DEFAULT \'NULL\', CHANGE permalink permalink VARCHAR(255) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE relay_point_type CHANGE icon_id icon_id INT DEFAULT NULL, CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE role CHANGE parent_id parent_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE section CHANGE article_id article_id INT DEFAULT NULL, CHANGE title title VARCHAR(255) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE sub_title sub_title VARCHAR(255) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE solidary CHANGE assisted assisted TINYINT(1) DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE solidary_matching CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE structure CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE subject CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE territory CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE travel_mode CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE uright CHANGE parent_id parent_id INT DEFAULT NULL, CHANGE description description VARCHAR(255) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci');
$this->addSql('ALTER TABLE user CHANGE given_name given_name VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE family_name family_name VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE password password VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE nationality nationality VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE birth_date birth_date DATE DEFAULT \'NULL\', CHANGE telephone telephone VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE max_detour_duration max_detour_duration INT DEFAULT NULL, CHANGE max_detour_distance max_detour_distance INT DEFAULT NULL, CHANGE any_route_as_passenger any_route_as_passenger TINYINT(1) DEFAULT \'NULL\', CHANGE multi_transport_mode multi_transport_mode TINYINT(1) DEFAULT \'NULL\', CHANGE smoke smoke INT DEFAULT NULL, CHANGE music music TINYINT(1) DEFAULT \'NULL\', CHANGE music_favorites music_favorites VARCHAR(255) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE chat chat TINYINT(1) DEFAULT \'NULL\', CHANGE chat_favorites chat_favorites VARCHAR(255) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE news_subscription news_subscription TINYINT(1) DEFAULT \'NULL\', CHANGE validated_date validated_date DATETIME DEFAULT \'NULL\', CHANGE validated_date_token validated_date_token VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\', CHANGE pwd_token_date pwd_token_date DATETIME DEFAULT \'NULL\', CHANGE pwd_token pwd_token VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE geo_token geo_token VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE phone_token phone_token VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE phone_validated_date phone_validated_date DATETIME DEFAULT \'NULL\', CHANGE ios_app_id ios_app_id VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE android_app_id android_app_id VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE language language VARCHAR(10) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci, CHANGE facebook_id facebook_id VARCHAR(100) DEFAULT \'NULL\' COLLATE utf8mb4_unicode_ci');
$this->addSql('ALTER TABLE user_import CHANGE user_id user_id INT DEFAULT NULL, CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\', CHANGE treatment_user_start_date treatment_user_start_date DATETIME DEFAULT \'NULL\', CHANGE treatment_user_end_date treatment_user_end_date DATETIME DEFAULT \'NULL\', CHANGE treatment_journey_start_date treatment_journey_start_date DATETIME DEFAULT \'NULL\', CHANGE treatment_journey_end_date treatment_journey_end_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE user_notification CHANGE active active TINYINT(1) DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
$this->addSql('ALTER TABLE user_right CHANGE territory_id territory_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE user_role CHANGE territory_id territory_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE waypoint CHANGE proposal_id proposal_id INT DEFAULT NULL, CHANGE matching_id matching_id INT DEFAULT NULL, CHANGE ask_id ask_id INT DEFAULT NULL, CHANGE created_date created_date DATETIME DEFAULT \'NULL\', CHANGE updated_date updated_date DATETIME DEFAULT \'NULL\'');
}
}