migrations/Version20251102121337.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 Version20251102121337 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("CREATE TABLE `registration_billing_detail` (
  24. `id` int NOT NULL AUTO_INCREMENT,
  25. `registration_id` int NOT NULL,
  26. `billing_category_id` int NOT NULL,
  27. `billing_invoice_month` varchar(7) NOT NULL,
  28. `cheshbon_for` varchar(45) NOT NULL,
  29. `billing_date` datetime NOT NULL,
  30. `exam_vendor_id` int NOT NULL,
  31. `exam_credits` int NOT NULL,
  32. `exam_additional_charge` float NOT NULL,
  33. `billing_category_credits` int NOT NULL,
  34. `rate_per_credit` decimal(8,2) NOT NULL,
  35. `charge_additional_grading_fee` tinyint(1) NOT NULL,
  36. `credits_fee` decimal(8,2) NOT NULL,
  37. `grading_fee` decimal(8,2) NOT NULL,
  38. `processing_fee` decimal(8,2) NOT NULL,
  39. `info_allpackages` varchar(255) NOT NULL,
  40. `info_seminarystudent` varchar(255) NOT NULL,
  41. `create_date` datetime NOT NULL,
  42. PRIMARY KEY (`id`),
  43. UNIQUE (`registration_id`,`billing_category_id`),
  44. FOREIGN KEY (`registration_id`) REFERENCES registrations(`id`),
  45. FOREIGN KEY (`billing_category_id`) REFERENCES billing_categories(`id`),
  46. FOREIGN KEY (`exam_vendor_id`) REFERENCES vendors(`id`)
  47. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ");
  48. }
  50. public function down(Schema $schema): void
  51. {
  52. // this down() migration is auto-generated, please modify it to your needs
  53. $this->addSql("DROP TABLE registration_billing_detail");
  54. }
  55. }