addSql('ALTER TABLE contrats ADD type VARCHAR(255) NOT NULL'); $this->addSql('ALTER TABLE contrats ADD details TEXT NOT NULL'); $this->addSql('ALTER TABLE contrats ADD type_sol VARCHAR(255) NOT NULL'); $this->addSql('ALTER TABLE contrats ADD pente VARCHAR(255) NOT NULL'); $this->addSql('ALTER TABLE contrats ADD access TEXT NOT NULL'); $this->addSql('ALTER TABLE contrats ADD distance_power DOUBLE PRECISION NOT NULL'); $this->addSql('ALTER TABLE contrats ADD notes TEXT NOT NULL'); } 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 contrats DROP type'); $this->addSql('ALTER TABLE contrats DROP details'); $this->addSql('ALTER TABLE contrats DROP type_sol'); $this->addSql('ALTER TABLE contrats DROP pente'); $this->addSql('ALTER TABLE contrats DROP access'); $this->addSql('ALTER TABLE contrats DROP distance_power'); $this->addSql('ALTER TABLE contrats DROP notes'); } }