<?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 Version20221128112931 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 UNIQUE INDEX UNIQ_23A0E66CAC822D9 ON article (price)');
$this->addSql('ALTER TABLE article RENAME INDEX fk_article_site1_idx TO IDX_23A0E66F6BD1646');
$this->addSql('DROP INDEX tel_UNIQUE ON client');
$this->addSql('ALTER TABLE client CHANGE type_client_id type_client_id INT DEFAULT NULL, CHANGE photo_recto photo_recto VARCHAR(45) DEFAULT NULL, CHANGE photo_verso photo_verso VARCHAR(45) DEFAULT NULL, CHANGE filename_photo_recto filename_photo_recto VARCHAR(160) DEFAULT NULL, CHANGE filename_photo_verso filename_photo_verso VARCHAR(160) DEFAULT NULL');
$this->addSql('ALTER TABLE client RENAME INDEX fk_client_type_client1_idx TO IDX_C7440455AD2D2831');
$this->addSql('ALTER TABLE colis CHANGE transaction_id transaction_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE commande DROP FOREIGN KEY FK_6EEAA67D8BF5C2E6');
$this->addSql('DROP INDEX IDX_6EEAA67D8BF5C2E6 ON commande');
$this->addSql('ALTER TABLE commande DROP commandes_id, CHANGE orderNumber orderNumber VARCHAR(100) DEFAULT NULL');
$this->addSql('ALTER TABLE commande RENAME INDEX clientid TO fk_commande_client1_idx');
$this->addSql('ALTER TABLE commande RENAME INDEX session_id TO fk_commande_session1_idx');
$this->addSql('ALTER TABLE commande_article DROP price');
$this->addSql('ALTER TABLE commande_article ADD CONSTRAINT FK_F4817CC67294869C FOREIGN KEY (article_id) REFERENCES article (id)');
$this->addSql('ALTER TABLE commande_article ADD CONSTRAINT FK_F4817CC682EA2E54 FOREIGN KEY (commande_id) REFERENCES commande (id)');
$this->addSql('ALTER TABLE commande_article RENAME INDEX article_id TO fk_commande_article_article1_idx');
$this->addSql('ALTER TABLE commande_article RENAME INDEX commande_id TO fk_commande_article_commande1_idx');
$this->addSql('ALTER TABLE commande_service_bag CHANGE commande_id commande_id INT DEFAULT NULL, CHANGE service_bag_id service_bag_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE commande_service_bag ADD CONSTRAINT FK_70839E57519A87A1 FOREIGN KEY (service_bag_id) REFERENCES service_bag (id)');
$this->addSql('ALTER TABLE commande_service_bag ADD CONSTRAINT FK_70839E5782EA2E54 FOREIGN KEY (commande_id) REFERENCES commande (id)');
$this->addSql('ALTER TABLE devis CHANGE `from` `begin` VARCHAR(10) DEFAULT NULL, CHANGE `to` `arrived` VARCHAR(10) DEFAULT NULL');
$this->addSql('ALTER TABLE formule ADD CONSTRAINT FK_605C9C9877E5854A FOREIGN KEY (mode_id) REFERENCES mode (id)');
$this->addSql('ALTER TABLE invoice CHANGE tva tva DOUBLE PRECISION DEFAULT NULL, CHANGE transaction_id transaction_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE invoice ADD CONSTRAINT FK_906517442FC0CB0F FOREIGN KEY (transaction_id) REFERENCES transaction (id)');
$this->addSql('ALTER TABLE invoice_details CHANGE invoice_id invoice_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE invoice_details ADD CONSTRAINT FK_80FF3D592989F1FD FOREIGN KEY (invoice_id) REFERENCES invoice (id)');
$this->addSql('ALTER TABLE session CHANGE start_at start_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE session ADD CONSTRAINT FK_D044D5D4A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE sms ADD CONSTRAINT FK_B0A93A7719EB6921 FOREIGN KEY (client_id) REFERENCES client (id)');
$this->addSql('ALTER TABLE sms ADD CONSTRAINT FK_B0A93A77A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE statistique_statut CHANGE TOTAL TOTAL VARCHAR(45) DEFAULT NULL, CHANGE STATUT STATUT INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (STATUT)');
$this->addSql('ALTER TABLE supply ADD initial_quantity INT DEFAULT NULL');
$this->addSql('ALTER TABLE temoignage CHANGE titre titre VARCHAR(45) DEFAULT NULL');
$this->addSql('ALTER TABLE transaction CHANGE mode_id mode_id INT DEFAULT NULL, CHANGE ville_exp ville_exp INT DEFAULT NULL, CHANGE ville_rec ville_rec INT DEFAULT NULL, CHANGE tva tva DOUBLE PRECISION DEFAULT NULL, CHANGE type_facturation_id type_facturation_id INT DEFAULT NULL, CHANGE payment_type_id payment_type_id INT DEFAULT NULL, CHANGE expediteur expediteur INT DEFAULT NULL, CHANGE recepteur recepteur INT DEFAULT NULL, CHANGE payment_from_id payment_from_id INT DEFAULT NULL, CHANGE agent agent INT DEFAULT NULL, CHANGE is_payed is_payed TINYINT(1) DEFAULT NULL');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D1ABA4CF8E FOREIGN KEY (expediteur) REFERENCES client (id)');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D1FDE0DADF FOREIGN KEY (recepteur) REFERENCES client (id)');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D16187D7E1 FOREIGN KEY (payment_from_id) REFERENCES payment_from (id)');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D177E5854A FOREIGN KEY (mode_id) REFERENCES mode (id)');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D1DC058279 FOREIGN KEY (payment_type_id) REFERENCES payment_type (id)');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D18D06DB10 FOREIGN KEY (type_facturation_id) REFERENCES type_facturation (id)');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D1A2779011 FOREIGN KEY (ville_exp) REFERENCES ville (id)');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D1C0CC0826 FOREIGN KEY (ville_rec) REFERENCES ville (id)');
$this->addSql('ALTER TABLE transaction ADD CONSTRAINT FK_723705D1268B9C9D FOREIGN KEY (agent) REFERENCES user (id)');
$this->addSql('ALTER TABLE transaction RENAME INDEX fk_transaction_client2_idx TO IDX_723705D1FDE0DADF');
$this->addSql('ALTER TABLE transaction RENAME INDEX fk_transaction_user1_idx TO IDX_723705D1268B9C9D');
$this->addSql('ALTER TABLE user CHANGE password password VARCHAR(500) DEFAULT NULL, CHANGE roles roles JSON DEFAULT NULL');
$this->addSql('ALTER TABLE versement CHANGE transaction_id transaction_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE versement ADD CONSTRAINT FK_716E93672FC0CB0F FOREIGN KEY (transaction_id) REFERENCES transaction (id)');
$this->addSql('ALTER TABLE versement ADD CONSTRAINT FK_716E93672989F1FD FOREIGN KEY (invoice_id) REFERENCES invoice (id)');
$this->addSql('ALTER TABLE versement RENAME INDEX fk_versement_transaction1_idx TO IDX_716E93672FC0CB0F');
$this->addSql('ALTER TABLE versement RENAME INDEX fk_versement_invoice1_idx TO IDX_716E93672989F1FD');
$this->addSql('ALTER TABLE ville ADD CONSTRAINT FK_43C3D9C3A6E44244 FOREIGN KEY (pays_id) REFERENCES pays (id)');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('DROP INDEX UNIQ_23A0E66CAC822D9 ON article');
$this->addSql('ALTER TABLE article RENAME INDEX idx_23a0e66f6bd1646 TO fk_article_site1_idx');
$this->addSql('ALTER TABLE client CHANGE type_client_id type_client_id INT NOT NULL, CHANGE photo_recto photo_recto VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_general_ci`, CHANGE photo_verso photo_verso VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_general_ci`, CHANGE filename_photo_recto filename_photo_recto VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_general_ci`, CHANGE filename_photo_verso filename_photo_verso VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_general_ci`');
$this->addSql('CREATE UNIQUE INDEX tel_UNIQUE ON client (tel)');
$this->addSql('ALTER TABLE client RENAME INDEX idx_c7440455ad2d2831 TO fk_client_type_client1_idx');
$this->addSql('ALTER TABLE colis CHANGE transaction_id transaction_id INT NOT NULL');
$this->addSql('ALTER TABLE commande ADD commandes_id INT DEFAULT NULL, CHANGE orderNumber orderNumber VARCHAR(45) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`');
$this->addSql('ALTER TABLE commande ADD CONSTRAINT FK_6EEAA67D8BF5C2E6 FOREIGN KEY (commandes_id) REFERENCES commande (id) ON UPDATE NO ACTION ON DELETE NO ACTION');
$this->addSql('CREATE INDEX IDX_6EEAA67D8BF5C2E6 ON commande (commandes_id)');
$this->addSql('ALTER TABLE commande RENAME INDEX fk_commande_client1_idx TO clientid');
$this->addSql('ALTER TABLE commande RENAME INDEX fk_commande_session1_idx TO session_id');
$this->addSql('ALTER TABLE commande_article DROP FOREIGN KEY FK_F4817CC67294869C');
$this->addSql('ALTER TABLE commande_article DROP FOREIGN KEY FK_F4817CC682EA2E54');
$this->addSql('ALTER TABLE commande_article ADD price INT DEFAULT NULL');
$this->addSql('ALTER TABLE commande_article RENAME INDEX fk_commande_article_article1_idx TO article_id');
$this->addSql('ALTER TABLE commande_article RENAME INDEX fk_commande_article_commande1_idx TO commande_id');
$this->addSql('ALTER TABLE commande_service_bag DROP FOREIGN KEY FK_70839E57519A87A1');
$this->addSql('ALTER TABLE commande_service_bag DROP FOREIGN KEY FK_70839E5782EA2E54');
$this->addSql('ALTER TABLE commande_service_bag CHANGE service_bag_id service_bag_id INT NOT NULL, CHANGE commande_id commande_id INT NOT NULL');
$this->addSql('ALTER TABLE devis CHANGE `from` `from` VARCHAR(120) CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_general_ci`, CHANGE `to` `to` VARCHAR(120) CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_general_ci`');
$this->addSql('ALTER TABLE formule DROP FOREIGN KEY FK_605C9C9877E5854A');
$this->addSql('ALTER TABLE invoice DROP FOREIGN KEY FK_906517442FC0CB0F');
$this->addSql('ALTER TABLE invoice CHANGE transaction_id transaction_id INT NOT NULL, CHANGE tva tva DOUBLE PRECISION DEFAULT \'0\'');
$this->addSql('ALTER TABLE invoice_details DROP FOREIGN KEY FK_80FF3D592989F1FD');
$this->addSql('ALTER TABLE invoice_details CHANGE invoice_id invoice_id INT NOT NULL');
$this->addSql('ALTER TABLE session DROP FOREIGN KEY FK_D044D5D4A76ED395');
$this->addSql('ALTER TABLE session CHANGE start_at start_at DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE sms DROP FOREIGN KEY FK_B0A93A7719EB6921');
$this->addSql('ALTER TABLE sms DROP FOREIGN KEY FK_B0A93A77A76ED395');
$this->addSql('ALTER TABLE statistique_statut MODIFY STATUT INT NOT NULL');
$this->addSql('ALTER TABLE statistique_statut DROP PRIMARY KEY');
$this->addSql('ALTER TABLE statistique_statut CHANGE STATUT STATUT VARCHAR(45) CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_general_ci`, CHANGE TOTAL TOTAL BIGINT DEFAULT NULL');
$this->addSql('ALTER TABLE supply DROP initial_quantity');
$this->addSql('ALTER TABLE temoignage CHANGE titre titre VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_general_ci`');
$this->addSql('ALTER TABLE transaction DROP FOREIGN KEY FK_723705D1ABA4CF8E');
$this->addSql('ALTER TABLE transaction DROP FOREIGN KEY FK_723705D1FDE0DADF');
$this->addSql('ALTER TABLE transaction DROP FOREIGN KEY FK_723705D16187D7E1');
$this->addSql('ALTER TABLE transaction DROP FOREIGN KEY FK_723705D177E5854A');
$this->addSql('ALTER TABLE transaction DROP FOREIGN KEY FK_723705D1DC058279');
$this->addSql('ALTER TABLE transaction DROP FOREIGN KEY FK_723705D18D06DB10');
$this->addSql('ALTER TABLE transaction DROP FOREIGN KEY FK_723705D1A2779011');
$this->addSql('ALTER TABLE transaction DROP FOREIGN KEY FK_723705D1C0CC0826');
$this->addSql('ALTER TABLE transaction DROP FOREIGN KEY FK_723705D1268B9C9D');
$this->addSql('ALTER TABLE transaction CHANGE expediteur expediteur INT NOT NULL, CHANGE recepteur recepteur INT NOT NULL, CHANGE payment_from_id payment_from_id INT NOT NULL, CHANGE mode_id mode_id INT NOT NULL, CHANGE payment_type_id payment_type_id INT NOT NULL, CHANGE type_facturation_id type_facturation_id INT NOT NULL, CHANGE ville_exp ville_exp INT NOT NULL, CHANGE ville_rec ville_rec INT NOT NULL, CHANGE agent agent INT NOT NULL, CHANGE tva tva DOUBLE PRECISION DEFAULT \'0\', CHANGE is_payed is_payed TINYINT(1) DEFAULT \'0\'');
$this->addSql('ALTER TABLE transaction RENAME INDEX idx_723705d1fde0dadf TO fk_transaction_client2_idx');
$this->addSql('ALTER TABLE transaction RENAME INDEX idx_723705d1268b9c9d TO fk_transaction_user1_idx');
$this->addSql('ALTER TABLE user CHANGE password password VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_general_ci`, CHANGE roles roles JSON CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_general_ci`');
$this->addSql('ALTER TABLE versement DROP FOREIGN KEY FK_716E93672FC0CB0F');
$this->addSql('ALTER TABLE versement DROP FOREIGN KEY FK_716E93672989F1FD');
$this->addSql('ALTER TABLE versement CHANGE transaction_id transaction_id INT NOT NULL');
$this->addSql('ALTER TABLE versement RENAME INDEX idx_716e93672989f1fd TO fk_versement_invoice1_idx');
$this->addSql('ALTER TABLE versement RENAME INDEX idx_716e93672fc0cb0f TO fk_versement_transaction1_idx');
$this->addSql('ALTER TABLE ville DROP FOREIGN KEY FK_43C3D9C3A6E44244');
}
}