migrations/Version20190528114835.php line 1

Open in your IDE?
  1. <?php declare(strict_types=1);
  3. namespace DoctrineMigrations;
  5. use Doctrine\DBAL\Schema\Schema;
  6. use Doctrine\Migrations\AbstractMigration;
  8. /**
  9. * Auto-generated Migration: Please modify to your needs!
  10. */
  11. final class Version20190528114835 extends AbstractMigration
  12. {
  13. public function up(Schema $schema) : void
  14. {
  15. // this up() migration is auto-generated, please modify it to your needs
  16. $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
  18. $this->addSql('CREATE TABLE vstyp (id INT AUTO_INCREMENT NOT NULL, typname VARCHAR(200) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB');
  19. $this->addSql('CREATE TABLE vsstatus (id INT AUTO_INCREMENT NOT NULL, statusname VARCHAR(200) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB');
  20. $this->addSql('CREATE TABLE vsrubrik (id INT AUTO_INCREMENT NOT NULL, rubrikname VARCHAR(200) DEFAULT NULL, beschreibung TINYTEXT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB');
  21. $this->addSql('CREATE TABLE vsregion (id INT AUTO_INCREMENT NOT NULL, regionname VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB');
  22. $this->addSql('CREATE TABLE vsbeginnauswahl (id INT AUTO_INCREMENT NOT NULL, beginn_auswahl VARCHAR(200) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB');
  23. $this->addSql('CREATE TABLE vs (id INT AUTO_INCREMENT NOT NULL, region_id INT DEFAULT NULL, rubrik_id INT DEFAULT NULL, status_id INT DEFAULT NULL, abo_id INT DEFAULT NULL, typ_id INT DEFAULT NULL, beginn_auswahl_id INT DEFAULT NULL, uuid VARCHAR(36) NOT NULL, titel VARCHAR(200) DEFAULT NULL, ort VARCHAR(200) DEFAULT NULL, beschreibung TEXT DEFAULT NULL, beginnzeit TIME DEFAULT NULL, endzeit TIME DEFAULT NULL, startdatum DATE DEFAULT NULL, enddatum DATE DEFAULT NULL, url VARCHAR(200) DEFAULT NULL, videolink VARCHAR(250) DEFAULT NULL, googlemaps VARCHAR(400) DEFAULT NULL, ticketsbestellen VARCHAR(200) DEFAULT NULL, anzeigedatum DATETIME DEFAULT NULL, export_uristier TINYINT(1) DEFAULT NULL, export_uw TINYINT(1) DEFAULT NULL, export_1_enddatum DATETIME DEFAULT NULL, kveranstalter VARCHAR(100) DEFAULT NULL, kname VARCHAR(100) DEFAULT NULL, kvorname VARCHAR(100) DEFAULT NULL, kstrasse VARCHAR(200) DEFAULT NULL, kplz VARCHAR(5) DEFAULT NULL, kort VARCHAR(200) DEFAULT NULL, ktel VARCHAR(200) DEFAULT NULL, kemail VARCHAR(200) DEFAULT NULL, kkontaktieren TINYINT(1) DEFAULT NULL, kbemerkung TINYTEXT DEFAULT NULL, lastupdate DATETIME DEFAULT NULL, vs_image JSON DEFAULT NULL COMMENT \'(DC2Type:json_array)\', INDEX IDX_F1B0EC0998260155 (region_id), INDEX IDX_F1B0EC09672AE813 (rubrik_id), INDEX IDX_F1B0EC096BF700BD (status_id), INDEX IDX_F1B0EC096BDDA206 (abo_id), INDEX IDX_F1B0EC09278CD074 (typ_id), INDEX IDX_F1B0EC095B13987 (beginn_auswahl_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB');
  24. $this->addSql('CREATE TABLE vsabo (id INT AUTO_INCREMENT NOT NULL, aboname VARCHAR(200) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB');
  25. $this->addSql('ALTER TABLE vs ADD CONSTRAINT FK_F1B0EC0998260155 FOREIGN KEY (region_id) REFERENCES vsregion (id)');
  26. $this->addSql('ALTER TABLE vs ADD CONSTRAINT FK_F1B0EC09672AE813 FOREIGN KEY (rubrik_id) REFERENCES vsrubrik (id)');
  27. $this->addSql('ALTER TABLE vs ADD CONSTRAINT FK_F1B0EC096BF700BD FOREIGN KEY (status_id) REFERENCES vsstatus (id)');
  28. $this->addSql('ALTER TABLE vs ADD CONSTRAINT FK_F1B0EC096BDDA206 FOREIGN KEY (abo_id) REFERENCES vsabo (id)');
  29. $this->addSql('ALTER TABLE vs ADD CONSTRAINT FK_F1B0EC09278CD074 FOREIGN KEY (typ_id) REFERENCES vstyp (id)');
  30. $this->addSql('ALTER TABLE vs ADD CONSTRAINT FK_F1B0EC095B13987 FOREIGN KEY (beginn_auswahl_id) REFERENCES vsbeginnauswahl (id)');
  31. }
  33. public function down(Schema $schema) : void
  34. {
  35. // this down() migration is auto-generated, please modify it to your needs
  36. $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
  38. $this->addSql('ALTER TABLE vs DROP FOREIGN KEY FK_F1B0EC09278CD074');
  39. $this->addSql('ALTER TABLE vs DROP FOREIGN KEY FK_F1B0EC096BF700BD');
  40. $this->addSql('ALTER TABLE vs DROP FOREIGN KEY FK_F1B0EC09672AE813');
  41. $this->addSql('ALTER TABLE vs DROP FOREIGN KEY FK_F1B0EC0998260155');
  42. $this->addSql('ALTER TABLE vs DROP FOREIGN KEY FK_F1B0EC095B13987');
  43. $this->addSql('ALTER TABLE vs DROP FOREIGN KEY FK_F1B0EC096BDDA206');
  44. $this->addSql('DROP TABLE vstyp');
  45. $this->addSql('DROP TABLE vsstatus');
  46. $this->addSql('DROP TABLE vsrubrik');
  47. $this->addSql('DROP TABLE vsregion');
  48. $this->addSql('DROP TABLE vsbeginnauswahl');
  49. $this->addSql('DROP TABLE vs');
  50. $this->addSql('DROP TABLE vsabo');
  51. }
  52. }