migrations/Version20210609084514.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. /**
  11. * Auto-generated Migration: Please modify to your needs!
  12. */
  13. final class Version20210609084514 extends AbstractMigration
  14. {
  15. public function getDescription(): string
  16. {
  17. return '';
  18. }
  20. public function up(Schema $schema): void
  21. {
  22. // this up() migration is auto-generated, please modify it to your needs
  23. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `internalComment` , `to_display`) VALUES ('1', '1', '45', '','1')");
  24. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('2', '2', '90','1')");
  25. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('3', '3', '135','1')");
  26. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('4', '4', '180','1')");
  27. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('5', '5', '225','1')");
  28. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('6', '6', '270','1')");
  29. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('7', '7', '315','1')");
  30. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('8', '8', '360','1')");
  31. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('9', '9', '405','1')");
  32. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('10', '10', '450','1')");
  33. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('11', '11', '495','1')");
  34. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('12', '12', '540','1')");
  35. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('13', '13', '585','1')");
  36. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('14', '14', '630','1')");
  37. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('15', '15', '675','1')");
  38. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('16', '16', '720','1')");
  39. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('17', '17', '765','1')");
  40. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('18', '18', '810','1')");
  41. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('19', '19', '855','1')");
  42. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('20', '20', '900','1')");
  43. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('21', '21', '945','1')");
  44. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('22', '22', '990','1')");
  45. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('23', '23', '1035','1')");
  46. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('24', '24', '1080','1')");
  47. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('25', '25', '1125','1')");
  48. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('26', '26', '1150','1')");
  49. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('27', '27', '1195','1')");
  50. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('28', '28', '1240','1')");
  51. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `to_display`) VALUES ('29', '29', '1285','1')");
  52. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `internalComment`, `to_display`) VALUES ('30 credits', '30', '1290', '$43 a credit','1')");
  53. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `internalComment`, `to_display`) VALUES ('45 credits', '45', '1935', '$43 a credit','1')");
  54. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `internalComment`, `to_display`) VALUES ('60 credist', '60', '2460', '$41 a credit','1')");
  55. $this->addSql("INSERT INTO `pck_packagetypes` (`displayName`, `numberOfCredits`, `purchasePrice`, `internalComment`, `to_display`) VALUES ('90 credits', '90', '3510', '$39 a credit','1')");
  57. }
  59. public function down(Schema $schema): void
  60. {
  61. // this down() migration is auto-generated, please modify it to your needs
  62. $this->addSql('delete from pck_packagetypes');
  63. }
  64. }