* Auto-generated Migration: Please modify to your needs!
12
*/
13
final class Version20251026215938 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
CREATE TEMPORARY TABLE __temp__descriptions AS SELECT id, indicator, series_description, source FROM descriptions
25
SQL);
26
$this->addSql(<<<'SQL'
27
DROP TABLE descriptions
28
SQL);
29
$this->addSql(<<<'SQL'
30
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)
31
SQL);
32
$this->addSql(<<<'SQL'
33
INSERT INTO descriptions (id, indicator, series_description, source) SELECT id, indicator, series_description, source FROM __temp__descriptions
34
SQL);
35
$this->addSql(<<<'SQL'
36
DROP TABLE __temp__descriptions
37
SQL);
38
}
39
40
public function down(Schema $schema): void
41
{
42
// this down() migration is auto-generated, please modify it to your needs
43
$this->addSql(<<<'SQL'
44
ALTER TABLE descriptions ADD COLUMN target CLOB DEFAULT NULL
busigbil /
MVC2025
