migrations/Version20181213073513.php line 1

Open in your IDE?
  1. <?php
  3. namespace DoctrineMigrations;
  5. use Doctrine\Migrations\AbstractMigration;
  6. use Doctrine\DBAL\Schema\Schema;
  8. /**
  9. * Auto-generated Migration: Please modify to your needs!
  10. */
  11. class Version20181213073513 extends AbstractMigration
  12. {
  13. /**
  14. * @param Schema $schema
  15. */
  16. public function up(Schema $schema): void
  17. {
  18. // this up() migration is auto-generated, please modify it to your needs
  19. $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
  21. $this->addSql('ALTER TABLE gemeinde ADD bfs_nr INT DEFAULT NULL');
  23. $this->addSql('UPDATE gemeinde SET bfs_nr = 1372 WHERE id = 1');
  24. $this->addSql('UPDATE gemeinde SET bfs_nr = 1374 WHERE id = 2');
  25. $this->addSql('UPDATE gemeinde SET bfs_nr = 1367 WHERE id = 3');
  26. $this->addSql('UPDATE gemeinde SET bfs_nr = 1362 WHERE id = 4');
  27. $this->addSql('UPDATE gemeinde SET bfs_nr = 1344 WHERE id = 5');
  28. $this->addSql('UPDATE gemeinde SET bfs_nr = 1301 WHERE id = 7');
  29. $this->addSql('UPDATE gemeinde SET bfs_nr = 1331 WHERE id = 8');
  30. $this->addSql('UPDATE gemeinde SET bfs_nr = 1371 WHERE id = 9');
  31. $this->addSql('UPDATE gemeinde SET bfs_nr = 1364 WHERE id = 10');
  32. $this->addSql('UPDATE gemeinde SET bfs_nr = 1373 WHERE id = 11');
  33. $this->addSql('UPDATE gemeinde SET bfs_nr = 1368 WHERE id = 12');
  34. $this->addSql('UPDATE gemeinde SET bfs_nr = 1375 WHERE id = 13');
  35. $this->addSql('UPDATE gemeinde SET bfs_nr = 1365 WHERE id = 14');
  36. $this->addSql('UPDATE gemeinde SET bfs_nr = 1366 WHERE id = 15');
  37. $this->addSql('UPDATE gemeinde SET bfs_nr = 1361 WHERE id = 16');
  38. $this->addSql('UPDATE gemeinde SET bfs_nr = 1363 WHERE id = 17');
  39. $this->addSql('UPDATE gemeinde SET bfs_nr = 1369 WHERE id = 18');
  40. $this->addSql('UPDATE gemeinde SET bfs_nr = 1311 WHERE id = 19');
  41. $this->addSql('UPDATE gemeinde SET bfs_nr = 1341 WHERE id = 21');
  42. $this->addSql('UPDATE gemeinde SET bfs_nr = 1342 WHERE id = 22');
  43. $this->addSql('UPDATE gemeinde SET bfs_nr = 1348 WHERE id = 23');
  44. $this->addSql('UPDATE gemeinde SET bfs_nr = 1343 WHERE id = 24');
  45. $this->addSql('UPDATE gemeinde SET bfs_nr = 1346 WHERE id = 25');
  46. $this->addSql('UPDATE gemeinde SET bfs_nr = 1347 WHERE id = 26');
  47. $this->addSql('UPDATE gemeinde SET bfs_nr = 1349 WHERE id = 27');
  48. $this->addSql('UPDATE gemeinde SET bfs_nr = 1345 WHERE id = 28');
  49. $this->addSql('UPDATE gemeinde SET bfs_nr = 1323 WHERE id = 31');
  50. $this->addSql('UPDATE gemeinde SET bfs_nr = 1322 WHERE id = 32');
  51. $this->addSql('UPDATE gemeinde SET bfs_nr = 1321 WHERE id = 33');
  52. $this->addSql('UPDATE gemeinde SET bfs_nr = 1370 WHERE id = 34');
  53. }
  55. /**
  56. * @param Schema $schema
  57. */
  58. public function down(Schema $schema): void
  59. {
  60. // this down() migration is auto-generated, please modify it to your needs
  61. $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
  63. $this->addSql('ALTER TABLE gemeinde DROP bfs_nr');
  64. }
  65. }