mirror of
https://gitlab.aliens-lyon.fr/encartes/backend.git
synced 2026-03-17 14:41:03 +01:00
54 lines
2.6 KiB
PHP
54 lines
2.6 KiB
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 Version20230216154419 extends AbstractMigration
|
|
{
|
|
public function getDescription(): string
|
|
{
|
|
return 'Complétion des données d\'édition, ajout du nom des batiments, étages et sites';
|
|
}
|
|
|
|
public function up(Schema $schema): void
|
|
{
|
|
// this up() migration is auto-generated, please modify it to your needs
|
|
$this->addSql('ALTER TABLE building ADD name VARCHAR(255) NOT NULL DEFAULT \'Unknown\'');
|
|
$this->addSql('ALTER TABLE building ALTER COLUMN name DROP DEFAULT');
|
|
$this->addSql('ALTER TABLE edition ADD edited_place_id INT DEFAULT NULL');
|
|
$this->addSql('ALTER TABLE edition DROP name_place');
|
|
$this->addSql('ALTER TABLE edition ADD CONSTRAINT FK_A891181FA1D1FF27 FOREIGN KEY (edited_place_id) REFERENCES place (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
|
|
$this->addSql('CREATE INDEX IDX_A891181FA1D1FF27 ON edition (edited_place_id)');
|
|
$this->addSql('ALTER TABLE floor ADD name VARCHAR(255) NOT NULL DEFAULT \'Unknown\'');
|
|
$this->addSql('ALTER TABLE FLOOR ALTER COLUMN name DROP DEFAULT');
|
|
$this->addSql('ALTER TABLE place DROP CONSTRAINT fk_741d53cd6bd6e9cc');
|
|
$this->addSql('DROP INDEX idx_741d53cd6bd6e9cc');
|
|
$this->addSql('ALTER TABLE place DROP editions_id');
|
|
$this->addSql('ALTER TABLE site ADD name VARCHAR(255) NOT NULL DEFAULT \'Unknown\'');
|
|
$this->addSql('ALTER TABLE site ALTER COLUMN name DROP DEFAULT');
|
|
}
|
|
|
|
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 site DROP name');
|
|
$this->addSql('ALTER TABLE building DROP name');
|
|
$this->addSql('ALTER TABLE floor DROP name');
|
|
$this->addSql('ALTER TABLE place ADD editions_id INT DEFAULT NULL');
|
|
$this->addSql('ALTER TABLE place ADD CONSTRAINT fk_741d53cd6bd6e9cc FOREIGN KEY (editions_id) REFERENCES edition (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
|
|
$this->addSql('CREATE INDEX idx_741d53cd6bd6e9cc ON place (editions_id)');
|
|
$this->addSql('ALTER TABLE edition DROP CONSTRAINT FK_A891181FA1D1FF27');
|
|
$this->addSql('DROP INDEX IDX_A891181FA1D1FF27');
|
|
$this->addSql('ALTER TABLE edition ADD name_place VARCHAR(255) NOT NULL');
|
|
$this->addSql('ALTER TABLE edition DROP edited_place_id');
|
|
}
|
|
}
|