| Conditions | 1 |
| Paths | 1 |
| Total Lines | 16 |
| Code Lines | 15 |
| Lines | 0 |
| Ratio | 0 % |
| Changes | 1 | ||
| Bugs | 0 | Features | 0 |
| 1 | <?php |
||
| 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 |
||
| 42 | SQL); |
||
| 43 | $this->addSql(<<<'SQL' |
||
| 44 | DROP TABLE __temp__descriptions |
||
| 48 |