addSql('ALTER TABLE devis_line ADD price_ht_sup DOUBLE PRECISION DEFAULT NULL'); $this->addSql('ALTER TABLE devis_line ADD day INT NOT NULL'); $this->addSql('ALTER TABLE devis_line ADD start_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL'); $this->addSql('ALTER TABLE devis_line ADD end_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL'); $this->addSql('ALTER TABLE devis_line DROP content'); $this->addSql('COMMENT ON COLUMN devis_line.start_at IS \'(DC2Type:datetime_immutable)\''); $this->addSql('COMMENT ON COLUMN devis_line.end_at IS \'(DC2Type:datetime_immutable)\''); } 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 devis_line ADD content TEXT NOT NULL'); $this->addSql('ALTER TABLE devis_line DROP price_ht_sup'); $this->addSql('ALTER TABLE devis_line DROP day'); $this->addSql('ALTER TABLE devis_line DROP start_at'); $this->addSql('ALTER TABLE devis_line DROP end_at'); } }