Symfony Profiler

<?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 Version20240828223302 extends AbstractMigration
{
public function getDescription(): string
{
return 'Migration à exécuter sur un dump de la DB du 29-08-2024';
}
public function up(Schema $schema): void
{
// this up() migration is auto-generated, please modify it to your needs
$this->addSql('
DELETE FROM abstract_option_reservation
WHERE extra_reservation_id IN (
SELECT id
FROM extra_reservation
WHERE reservation_id IS NOT NULL
AND reservation_id NOT IN (SELECT id FROM reservation)
);
');
$this->addSql('
DELETE FROM extra_reservation
WHERE reservation_id IS NOT NULL
AND reservation_id NOT IN (SELECT id FROM reservation);
');
$this->addSql('CREATE TABLE cancel_reservation_history (id INT NOT NULL, code_id INT DEFAULT NULL, reason LONGTEXT DEFAULT NULL, INDEX IDX_1D30DD5427DAFE17 (code_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE change_reservation (id INT AUTO_INCREMENT NOT NULL, update_reservation_history_id INT NOT NULL, field VARCHAR(255) NOT NULL, old_value VARCHAR(255) DEFAULT NULL, new_value VARCHAR(255) DEFAULT NULL, INDEX IDX_5AABF20FB69CFC70 (update_reservation_history_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE contact (id INT AUTO_INCREMENT NOT NULL, email VARCHAR(100) NOT NULL, nom VARCHAR(255) DEFAULT NULL, prenom VARCHAR(255) DEFAULT NULL, adresse VARCHAR(255) DEFAULT NULL, ville VARCHAR(255) DEFAULT NULL, code_postal VARCHAR(255) DEFAULT NULL, pays VARCHAR(255) DEFAULT NULL, telephone VARCHAR(255) DEFAULT NULL, newsletter TINYINT(1) DEFAULT NULL, UNIQUE INDEX UNIQ_4C62E638E7927C74 (email), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE create_reservation_history (id INT NOT NULL, code_id INT DEFAULT NULL, INDEX IDX_13B8AE7F27DAFE17 (code_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE payment_history (id INT AUTO_INCREMENT NOT NULL, payment_id INT NOT NULL, created_at DATETIME NOT NULL, modifier VARCHAR(255) DEFAULT NULL, INDEX IDX_3EF37EA14C3A3BB (payment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE reservation_history (id INT AUTO_INCREMENT NOT NULL, reservation_id INT DEFAULT NULL, created_at DATETIME NOT NULL, modifier VARCHAR(255) DEFAULT NULL, discr VARCHAR(255) NOT NULL, INDEX IDX_402FCBCEB83297E7 (reservation_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE send_confirmation_reservation_history (id INT NOT NULL, log_email_id INT NOT NULL, INDEX IDX_8A85701CC6610A16 (log_email_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE update_reservation_history (id INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('ALTER TABLE reservation CHANGE newsletter newsletter TINYINT(1) DEFAULT NULL');
$this->addSql('ALTER TABLE token ADD reservation_id INT DEFAULT NULL, ADD code_promo_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE token ADD CONSTRAINT FK_5F37A13BB83297E7 FOREIGN KEY (reservation_id) REFERENCES reservation (id)');
$this->addSql('ALTER TABLE token ADD CONSTRAINT FK_5F37A13B294102D4 FOREIGN KEY (code_promo_id) REFERENCES code (id)');
$this->addSql('
UPDATE extra_reservation er
JOIN token t ON er.token_id = t.id
SET er.reservation_id = t.reservation_id
WHERE er.token_id IS NOT NULL;
');
$this->addSql('ALTER TABLE code MODIFY value VARCHAR(64)');
$this->addSql('ALTER TABLE token MODIFY codepromo VARCHAR(64)');
$this->addSql('CREATE INDEX idx_value ON code(value)');
$this->addSql('CREATE INDEX idx_codepromo ON token(codepromo)');
$this->addSql('UPDATE token t
JOIN code c ON t.codepromo = c.value
SET t.code_promo_id = c.id;
');
$this->addSql('ALTER TABLE token DROP codepromo');
$this->addSql('ALTER TABLE reservation ADD contact_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE reservation ADD CONSTRAINT FK_42C84955E7A1254A FOREIGN KEY (contact_id) REFERENCES contact (id)');
$this->addSql('CREATE INDEX IDX_42C84955E7A1254A ON reservation (contact_id)');
$this->addSql('ALTER TABLE token ADD contact_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE token ADD CONSTRAINT FK_5F37A13BE7A1254A FOREIGN KEY (contact_id) REFERENCES contact (id)');
$this->addSql('CREATE INDEX IDX_5F37A13BE7A1254A ON token (contact_id)');
$this->addSql("
INSERT INTO contact (email, nom, prenom, adresse, ville, code_postal)
SELECT email, nom, prenom, adresse, ville, code_postal
FROM token
WHERE email IS NOT NULL
ON DUPLICATE KEY UPDATE
nom = VALUES(nom),
prenom = VALUES(prenom),
adresse = VALUES(adresse),
ville = VALUES(ville),
code_postal = VALUES(code_postal)
");
$this->addSql("
UPDATE token t
JOIN contact c ON t.email = c.email
SET t.contact_id = c.id
");
$this->addSql("
INSERT INTO contact (email, nom, prenom, adresse, ville, pays, telephone, newsletter)
SELECT email, nom, prenom, adresse, ville, pays, SUBSTRING(tel, 1, 20), newsletter
FROM reservation
WHERE email IS NOT NULL
ON DUPLICATE KEY UPDATE
nom = VALUES(nom),
prenom = VALUES(prenom),
adresse = VALUES(adresse),
ville = VALUES(ville),
pays = VALUES(pays),
telephone = VALUES(telephone),
newsletter = VALUES(newsletter)
");
$this->addSql("
UPDATE reservation r
JOIN contact c ON r.email = c.email
SET r.contact_id = c.id
");
$this->addSql('ALTER TABLE cancel_reservation_history ADD CONSTRAINT FK_1D30DD5427DAFE17 FOREIGN KEY (code_id) REFERENCES code (id)');
$this->addSql('ALTER TABLE cancel_reservation_history ADD CONSTRAINT FK_1D30DD54BF396750 FOREIGN KEY (id) REFERENCES reservation_history (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE change_reservation ADD CONSTRAINT FK_5AABF20FB69CFC70 FOREIGN KEY (update_reservation_history_id) REFERENCES update_reservation_history (id)');
$this->addSql('ALTER TABLE create_reservation_history ADD CONSTRAINT FK_13B8AE7F27DAFE17 FOREIGN KEY (code_id) REFERENCES code (id)');
$this->addSql('ALTER TABLE create_reservation_history ADD CONSTRAINT FK_13B8AE7FBF396750 FOREIGN KEY (id) REFERENCES reservation_history (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE payment_history ADD CONSTRAINT FK_3EF37EA14C3A3BB FOREIGN KEY (payment_id) REFERENCES abstract_payment (id)');
$this->addSql('ALTER TABLE reservation_history ADD CONSTRAINT FK_402FCBCEB83297E7 FOREIGN KEY (reservation_id) REFERENCES reservation (id)');
$this->addSql('ALTER TABLE send_confirmation_reservation_history ADD CONSTRAINT FK_8A85701CC6610A16 FOREIGN KEY (log_email_id) REFERENCES log_email (id)');
$this->addSql('ALTER TABLE send_confirmation_reservation_history ADD CONSTRAINT FK_8A85701CBF396750 FOREIGN KEY (id) REFERENCES reservation_history (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE update_reservation_history ADD CONSTRAINT FK_97776BCCBF396750 FOREIGN KEY (id) REFERENCES reservation_history (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE abstract_payment ADD reservation_id INT DEFAULT NULL, ADD numero_de_transaction VARCHAR(50) DEFAULT NULL, ADD cheque_number VARCHAR(7) DEFAULT NULL');
$this->addSql('ALTER TABLE abstract_payment ADD CONSTRAINT FK_CF9FE29DB83297E7 FOREIGN KEY (reservation_id) REFERENCES reservation (id)');
$this->addSql('CREATE INDEX IDX_CF9FE29DB83297E7 ON abstract_payment (reservation_id)');
$this->addSql('ALTER TABLE extra_reservation DROP FOREIGN KEY FK_D1359051B83297E7');
$this->addSql('ALTER TABLE extra_reservation ADD privatisation_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE extra_reservation ADD CONSTRAINT FK_D1359051CE4BE7FC FOREIGN KEY (privatisation_id) REFERENCES privatisation (id)');
$this->addSql('ALTER TABLE extra_reservation ADD CONSTRAINT IDX_D1359051B83297E7 FOREIGN KEY (reservation_id) REFERENCES reservation (id)');
$this->addSql('CREATE INDEX IDX_D1359051CE4BE7FC ON extra_reservation (privatisation_id)');
$this->addSql('ALTER TABLE log_email ADD file_path VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE participant ADD token_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE participant ADD reservation_id INT DEFAULT NULL');
$this->addSql('UPDATE participant SET reservation_id = reservation');
$this->addSql('ALTER TABLE participant DROP COLUMN reservation');
$this->addSql('
UPDATE participant
SET reservation_id = NULL
WHERE reservation_id NOT IN (SELECT id FROM reservation);
');
$this->addSql('ALTER TABLE participant ADD CONSTRAINT FK_D79F6B11B83297E7 FOREIGN KEY (reservation_id) REFERENCES reservation (id)');
$this->addSql('ALTER TABLE participant ADD CONSTRAINT FK_D79F6B1141DEE7B9 FOREIGN KEY (token_id) REFERENCES token (id)');
$this->addSql('CREATE INDEX IDX_D79F6B11B83297E7 ON participant (reservation_id)');
$this->addSql('CREATE INDEX IDX_D79F6B1141DEE7B9 ON participant (token_id)');
$this->addSql('ALTER TABLE reservation ADD offer VARCHAR(255) DEFAULT NULL');
$this->addSql('UPDATE reservation SET offer = offre');
$this->addSql('ALTER TABLE reservation ADD reste_apayer DOUBLE PRECISION DEFAULT NULL, DROP offre, DROP nom, DROP prenom, DROP adresse, DROP ville, DROP pays, DROP email, DROP tel, DROP remarque, DROP newsletter, CHANGE date date DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE token ADD date DATETIME DEFAULT NULL, DROP nom, DROP prenom, DROP adresse, DROP ville, DROP email, DROP code_postal');
$this->addSql('CREATE INDEX IDX_5F37A13BB83297E7 ON token (reservation_id)');
$this->addSql('CREATE INDEX IDX_5F37A13B294102D4 ON token (code_promo_id)');
$this->addSql('ALTER TABLE token MODIFY value VARCHAR(64)');
$this->addSql('CREATE INDEX idx_token_value ON token(value)');
$this->addSql('ALTER TABLE reservation MODIFY token VARCHAR(64)');
$this->addSql('CREATE INDEX idx_reservation_token ON reservation(token)');
$this->addSql('
UPDATE token t
JOIN reservation r ON t.value = r.token
SET t.reservation_id = r.id
');
$this->addSql('
UPDATE extra_reservation er
JOIN (
SELECT t.reservation_id, MAX(t.id) AS recent_token_id
FROM token t
GROUP BY t.reservation_id
) recent_tokens ON er.token_id = recent_tokens.recent_token_id
SET er.reservation_id = recent_tokens.reservation_id
');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE reservation DROP FOREIGN KEY FK_42C84955E7A1254A');
$this->addSql('ALTER TABLE token DROP FOREIGN KEY FK_5F37A13BE7A1254A');
$this->addSql('ALTER TABLE cancel_reservation_history DROP FOREIGN KEY FK_1D30DD5427DAFE17');
$this->addSql('ALTER TABLE cancel_reservation_history DROP FOREIGN KEY FK_1D30DD54BF396750');
$this->addSql('ALTER TABLE change_reservation DROP FOREIGN KEY FK_5AABF20FB69CFC70');
$this->addSql('ALTER TABLE create_reservation_history DROP FOREIGN KEY FK_13B8AE7F27DAFE17');
$this->addSql('ALTER TABLE create_reservation_history DROP FOREIGN KEY FK_13B8AE7FBF396750');
$this->addSql('ALTER TABLE payment_history DROP FOREIGN KEY FK_3EF37EA14C3A3BB');
$this->addSql('ALTER TABLE reservation_history DROP FOREIGN KEY FK_402FCBCEB83297E7');
$this->addSql('ALTER TABLE send_confirmation_reservation_history DROP FOREIGN KEY FK_8A85701CC6610A16');
$this->addSql('ALTER TABLE send_confirmation_reservation_history DROP FOREIGN KEY FK_8A85701CBF396750');
$this->addSql('ALTER TABLE update_reservation_history DROP FOREIGN KEY FK_97776BCCBF396750');
$this->addSql('DROP TABLE cancel_reservation_history');
$this->addSql('DROP TABLE change_reservation');
$this->addSql('DROP TABLE contact');
$this->addSql('DROP TABLE create_reservation_history');
$this->addSql('DROP TABLE payment_history');
$this->addSql('DROP TABLE reservation_history');
$this->addSql('DROP TABLE send_confirmation_reservation_history');
$this->addSql('DROP TABLE update_reservation_history');
$this->addSql('ALTER TABLE abstract_payment DROP FOREIGN KEY FK_CF9FE29DB83297E7');
$this->addSql('DROP INDEX IDX_CF9FE29DB83297E7 ON abstract_payment');
$this->addSql('ALTER TABLE abstract_payment DROP reservation_id, DROP numero_de_transaction, DROP cheque_number');
$this->addSql('ALTER TABLE extra_reservation DROP FOREIGN KEY FK_D1359051CE4BE7FC');
$this->addSql('ALTER TABLE extra_reservation DROP FOREIGN KEY IDX_D1359051B83297E7');
$this->addSql('DROP INDEX IDX_D1359051CE4BE7FC ON extra_reservation');
$this->addSql('ALTER TABLE extra_reservation DROP privatisation_id');
$this->addSql('ALTER TABLE extra_reservation ADD CONSTRAINT FK_D1359051B83297E7 FOREIGN KEY (reservation_id) REFERENCES privatisation (id)');
$this->addSql('ALTER TABLE log_email DROP file_path');
$this->addSql('ALTER TABLE participant DROP FOREIGN KEY FK_D79F6B11B83297E7');
$this->addSql('ALTER TABLE participant DROP FOREIGN KEY FK_D79F6B1141DEE7B9');
$this->addSql('DROP INDEX IDX_D79F6B11B83297E7 ON participant');
$this->addSql('DROP INDEX IDX_D79F6B1141DEE7B9 ON participant');
$this->addSql('ALTER TABLE participant ADD reservation INT NOT NULL, DROP reservation_id, DROP token_id');
$this->addSql('DROP INDEX IDX_42C84955E7A1254A ON reservation');
$this->addSql('ALTER TABLE reservation ADD offre VARCHAR(255) NOT NULL, ADD prenom VARCHAR(255) DEFAULT NULL, ADD adresse VARCHAR(255) DEFAULT NULL, ADD ville VARCHAR(255) DEFAULT NULL, ADD pays VARCHAR(255) DEFAULT NULL, ADD email VARCHAR(255) DEFAULT NULL, ADD tel VARCHAR(255) DEFAULT NULL, ADD remarque VARCHAR(255) DEFAULT NULL, ADD newsletter TINYINT(1) NOT NULL, DROP contact_id, DROP reste_apayer, CHANGE date date DATETIME NOT NULL, CHANGE offer nom VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE token DROP FOREIGN KEY FK_5F37A13BB83297E7');
$this->addSql('ALTER TABLE token DROP FOREIGN KEY FK_5F37A13B294102D4');
$this->addSql('DROP INDEX IDX_5F37A13BB83297E7 ON token');
$this->addSql('DROP INDEX IDX_5F37A13B294102D4 ON token');
$this->addSql('DROP INDEX IDX_5F37A13BE7A1254A ON token');
$this->addSql('ALTER TABLE token ADD codepromo VARCHAR(255) DEFAULT NULL, ADD nom VARCHAR(255) DEFAULT NULL, ADD prenom VARCHAR(255) DEFAULT NULL, ADD adresse VARCHAR(255) DEFAULT NULL, ADD ville VARCHAR(255) DEFAULT NULL, ADD email VARCHAR(255) DEFAULT NULL, ADD code_postal VARCHAR(255) DEFAULT NULL, DROP reservation_id, DROP code_promo_id, DROP contact_id, DROP date');
}
}

migrations/Version20240828223302.php line 1