* Auto-generated Migration: Please modify to your needs!
12
*/
13
final class Version20251026221212 extends AbstractMigration
14
{
15
public function getDescription(): string
16
{
17
return '';
18
}
19
20
public function up(Schema $schema): void
21
{
22
// this up() migration is auto-generated, please modify it to your needs
23
$this->addSql(<<<'SQL'
24
ALTER TABLE descriptions ADD COLUMN target VARCHAR(255) DEFAULT NULL
25
SQL);
26
}
27
28
public function down(Schema $schema): void
29
{
30
// this down() migration is auto-generated, please modify it to your needs
31
$this->addSql(<<<'SQL'
32
CREATE TEMPORARY TABLE __temp__descriptions AS SELECT id, indicator, series_description, source FROM descriptions
33
SQL);
34
$this->addSql(<<<'SQL'
35
DROP TABLE descriptions
36
SQL);
37
$this->addSql(<<<'SQL'
38
CREATE TABLE descriptions (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, indicator VARCHAR(255) NOT NULL, series_description VARCHAR(255) NOT NULL, source VARCHAR(255) NOT NULL)
39
SQL);
40
$this->addSql(<<<'SQL'
41
INSERT INTO descriptions (id, indicator, series_description, source) SELECT id, indicator, series_description, source FROM __temp__descriptions
busigbil /
MVC2025
