<?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 Version20240818210505 extends AbstractMigration
{
public function getDescription(): string
{
return '';
}
public function up(Schema $schema): void
{
// this up() migration is auto-generated, please modify it to your needs
$this->addSql('CREATE TABLE nature_piece (id INT AUTO_INCREMENT NOT NULL, designation VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE problems (id INT AUTO_INCREMENT NOT NULL, gaccentry_id_id INT NOT NULL, description VARCHAR(255) NOT NULL, INDEX IDX_8E66624563126334 (gaccentry_id_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE ua_technique_det (id INT AUTO_INCREMENT NOT NULL, quantite DOUBLE PRECISION DEFAULT NULL, prix_unitaire DOUBLE PRECISION DEFAULT NULL, tva DOUBLE PRECISION DEFAULT NULL, remise DOUBLE PRECISION DEFAULT NULL, article VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE messenger_messages (id BIGINT AUTO_INCREMENT NOT NULL, body LONGTEXT NOT NULL, headers LONGTEXT NOT NULL, queue_name VARCHAR(190) NOT NULL, created_at DATETIME NOT NULL, available_at DATETIME NOT NULL, delivered_at DATETIME DEFAULT NULL, INDEX IDX_75EA56E0FB7336F0 (queue_name), INDEX IDX_75EA56E0E3BD61CE (available_at), INDEX IDX_75EA56E016BA31DB (delivered_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('ALTER TABLE problems ADD CONSTRAINT FK_8E66624563126334 FOREIGN KEY (gaccentry_id_id) REFERENCES gaccentry (id)');
$this->addSql('ALTER TABLE compte_tier DROP accdat');
$this->addSql('DROP INDEX accdat ON gaccentry');
$this->addSql('DROP INDEX code ON gaccentry');
$this->addSql('DROP INDEX cpy1 ON gaccentry');
$this->addSql('DROP INDEX desvcr ON gaccentry');
$this->addSql('DROP INDEX fcy1 ON gaccentry');
$this->addSql('DROP INDEX fcz_flag1 ON gaccentry');
$this->addSql('DROP INDEX fcz_flag2 ON gaccentry');
$this->addSql('DROP INDEX fcz_flag3 ON gaccentry');
$this->addSql('DROP INDEX fcz_flag5 ON gaccentry');
$this->addSql('DROP INDEX fcz_flag6 ON gaccentry');
$this->addSql('DROP INDEX fcz_id_doc1_asso ON gaccentry');
$this->addSql('DROP INDEX jou ON gaccentry');
$this->addSql('DROP INDEX num ON gaccentry');
$this->addSql('DROP INDEX numx30 ON gaccentry');
$this->addSql('DROP INDEX observation_fcz_flag6 ON gaccentry');
$this->addSql('DROP INDEX ref ON gaccentry');
$this->addSql('DROP INDEX source ON gaccentry');
$this->addSql('DROP INDEX typ ON gaccentry');
$this->addSql('DROP INDEX typ1 ON gaccentry');
$this->addSql('ALTER TABLE gaccentry CHANGE fcz_flag1 fcz_flag1 INT NOT NULL, CHANGE upddattim0 upddattim0 DATETIME NOT NULL');
$this->addSql('DROP INDEX acc ON gaccentryd');
$this->addSql('DROP INDEX amtcur ON gaccentryd');
$this->addSql('DROP INDEX bpr ON gaccentryd');
$this->addSql('DROP INDEX num ON gaccentryd');
$this->addSql('DROP INDEX pca ON gaccentryd');
$this->addSql('DROP INDEX sac ON gaccentryd');
$this->addSql('DROP INDEX sns ON gaccentryd');
$this->addSql('DROP INDEX typ0 ON gaccentryd');
$this->addSql('DROP INDEX typ_ug ON gaccentryd');
$this->addSql('ALTER TABLE gaccentryd DROP pca, DROP pcg');
$this->addSql('ALTER TABLE journal CHANGE id id INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (id)');
$this->addSql('ALTER TABLE partenaire CHANGE id id INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (id)');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE cab DROP FOREIGN KEY FK_6A8AF6F932AE6AB8');
$this->addSql('DROP TABLE nature_piece');
$this->addSql('DROP TABLE problems');
$this->addSql('DROP TABLE ua_technique_det');
$this->addSql('DROP TABLE messenger_messages');
$this->addSql('ALTER TABLE compte_tier ADD accdat DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE gaccentry CHANGE fcz_flag1 fcz_flag1 INT DEFAULT NULL, CHANGE upddattim0 upddattim0 DATETIME DEFAULT NULL');
$this->addSql('CREATE INDEX accdat ON gaccentry (accdat)');
$this->addSql('CREATE INDEX code ON gaccentry (code)');
$this->addSql('CREATE INDEX cpy1 ON gaccentry (cpy1)');
$this->addSql('CREATE INDEX desvcr ON gaccentry (desvcr)');
$this->addSql('CREATE INDEX fcy1 ON gaccentry (fcy1)');
$this->addSql('CREATE INDEX fcz_flag1 ON gaccentry (fcz_flag1)');
$this->addSql('CREATE INDEX fcz_flag2 ON gaccentry (fcz_flag2)');
$this->addSql('CREATE INDEX fcz_flag3 ON gaccentry (fcz_flag3)');
$this->addSql('CREATE INDEX fcz_flag5 ON gaccentry (fcz_flag5)');
$this->addSql('CREATE INDEX fcz_flag6 ON gaccentry (fcz_flag6)');
$this->addSql('CREATE INDEX fcz_id_doc1_asso ON gaccentry (fcz_id_doc1_asso)');
$this->addSql('CREATE INDEX jou ON gaccentry (jou)');
$this->addSql('CREATE INDEX num ON gaccentry (num)');
$this->addSql('CREATE INDEX numx30 ON gaccentry (numx30)');
$this->addSql('CREATE INDEX observation_fcz_flag6 ON gaccentry (observation_fcz_flag6)');
$this->addSql('CREATE INDEX ref ON gaccentry (ref)');
$this->addSql('CREATE INDEX source ON gaccentry (source)');
$this->addSql('CREATE INDEX typ ON gaccentry (typ)');
$this->addSql('CREATE INDEX typ1 ON gaccentry (typ1)');
$this->addSql('ALTER TABLE gaccentryd ADD pca VARCHAR(255) DEFAULT NULL, ADD pcg VARCHAR(255) DEFAULT NULL');
$this->addSql('CREATE INDEX acc ON gaccentryd (acc)');
$this->addSql('CREATE INDEX amtcur ON gaccentryd (amtcur)');
$this->addSql('CREATE INDEX bpr ON gaccentryd (bpr)');
$this->addSql('CREATE INDEX num ON gaccentryd (num)');
$this->addSql('CREATE INDEX pca ON gaccentryd (pca)');
$this->addSql('CREATE INDEX sac ON gaccentryd (sac)');
$this->addSql('CREATE INDEX sns ON gaccentryd (sns)');
$this->addSql('CREATE INDEX typ0 ON gaccentryd (typ0)');
$this->addSql('CREATE INDEX typ_ug ON gaccentryd (typ_ug)');
$this->addSql('ALTER TABLE journal MODIFY id INT NOT NULL');
$this->addSql('ALTER TABLE journal DROP PRIMARY KEY');
$this->addSql('ALTER TABLE journal CHANGE id id VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE partenaire MODIFY id INT NOT NULL');
$this->addSql('ALTER TABLE partenaire DROP PRIMARY KEY');
$this->addSql('ALTER TABLE partenaire CHANGE id id VARCHAR(255) DEFAULT NULL');
}
}