migrations/Version20230926123640.php line 1

Open in your IDE?
  1. <?php
  3. /* @noinspection PhpUnused */
  5. declare(strict_types=1);
  7. namespace DoctrineMigrations;
  9. use Doctrine\DBAL\Schema\Schema;
  10. use Doctrine\Migrations\AbstractMigration;
  12. /**
  13.  * Auto-generated Migration: Please modify to your needs!
  14.  *
  15.  * @package API
  16.  * @internal
  17.  */
  18. final class Version20230926123640 extends AbstractMigration
  19. {
  21.     public function down(Schema $schema): void
  22.     {
  23.         // this down() migration is auto-generated, please modify it to your needs
  24.         $this->addSql('ALTER TABLE ta_report DROP FOREIGN KEY FK_F777692B16D8554C');
  25.         $this->addSql('ALTER TABLE ta_report DROP FOREIGN KEY FK_F777692B7D182D95');
  26.         $this->addSql('ALTER TABLE ta_report DROP FOREIGN KEY FK_F777692BF3340201');
  27.         $this->addSql('ALTER TABLE ta_report DROP FOREIGN KEY FK_F777692BD669FA40');
  28.         $this->addSql('ALTER TABLE ta_report DROP FOREIGN KEY FK_F777692B468FF4C');
  29.         $this->addSql('DROP TABLE ta_report');
  30.     }
  32.     public function getDescription(): string
  33.     {
  34.         return
  35.             "- Introduces TA report table.";
  36.     }
  38.     public function up(Schema $schema): void
  39.     {
  40.         // this up() migration is auto-generated, please modify it to your needs
  41.         $this->addSql(
  42.             '
  43.                 CREATE TABLE ta_report (
  44.                     id INT AUTO_INCREMENT NOT NULL COMMENT \'Internal ID\',
  45.                     accident_id INT NOT NULL COMMENT \'Internal ID\',
  46.                     created_by_user_id INT NOT NULL COMMENT \'Internal ID\',
  47.                     insured_person_employee_legal_state_id VARCHAR(32) DEFAULT NULL
  48.                         COMMENT \'Internal employee legal state ID\',
  49.                     insured_person_gender_id VARCHAR(1) NOT NULL COMMENT \'Internal gender ID\',
  50.                     insured_person_nationality_id VARCHAR(2) DEFAULT NULL
  51.                         COMMENT \'Country code in upper case (ISO 3166-1 Alpha-2)\',
  52.                     created INT NOT NULL COMMENT \'Entity creation date as UNIX timestamp\',
  53.                     active SMALLINT DEFAULT 1 NOT NULL COMMENT \'Indicator if entity is active\',
  54.                     last_active_date DATE DEFAULT NULL COMMENT \'Last active date\',
  55.                     accident_date_time DATETIME NOT NULL COMMENT \'Accident date and time\',
  56.                     authorized_person_representative_full_name VARCHAR(500) NOT NULL
  57.                         COMMENT \'Full name of approving authorized person representative\',
  58.                     company_full_address VARCHAR(1000) NOT NULL COMMENT \'Company full address\',
  59.                     company_name VARCHAR(225) NOT NULL COMMENT \'Company name\',
  60.                     company_number VARCHAR(11) NOT NULL COMMENT \'Company number\',
  61.                     company_phone VARCHAR(225) DEFAULT NULL COMMENT \'Company phone number\',
  62.                     description TEXT NOT NULL COMMENT \'Description\',
  63.                     description_issuer_insured_person SMALLINT NOT NULL
  64.                         COMMENT \'Flag if description issuer was the insured person\',
  65.                     fatal SMALLINT NOT NULL COMMENT \'Flag if accident was fatal\',
  66.                     first_aid_full_address VARCHAR(1000) NOT NULL COMMENT \'First aid full address\',
  67.                     first_person_to_recognize_eyewitness SMALLINT DEFAULT NULL
  68.                         COMMENT \'Flag if first person to recognize was an eyewitness\',
  69.                     first_person_to_recognize_full_address VARCHAR(1000) DEFAULT NULL
  70.                         COMMENT \'First person to recognize full address\',
  71.                     injured_body_parts VARCHAR(2000) NOT NULL COMMENT \'Translated list of injured body parts\',
  72.                     injury_types VARCHAR(2000) NOT NULL COMMENT \'Translated list of injury types\',
  73.                     insured_person_address VARCHAR(225) NOT NULL COMMENT \'Postal address for insured person\',
  74.                     insured_person_birthday DATE NOT NULL COMMENT \'Insured person birthday\',
  75.                     insured_person_city VARCHAR(225) NOT NULL COMMENT \'City of address for insured person\',
  76.                     insured_person_external_worker SMALLINT NOT NULL
  77.                         COMMENT \'Flag if insured person is an external worker\',
  78.                     insured_person_full_name VARCHAR(500) NOT NULL COMMENT \'Insured person full name\',
  79.                     insured_person_health_insurance_provider_full_address VARCHAR(1000) NOT NULL
  80.                         COMMENT \'Insured person health insurance provider full address\',
  81.                     insured_person_job_entry_date DATE DEFAULT NULL COMMENT \'Insured person job entry date\',
  82.                     insured_person_job_title VARCHAR(225) DEFAULT NULL COMMENT \'Insured person job title\',
  83.                     insured_person_org_unit_name VARCHAR(225) NOT NULL COMMENT \'Insured person org unit name\',
  84.                     insured_person_restarted_working_date DATE DEFAULT NULL
  85.                         COMMENT \'Date when insured person restarted working\',
  86.                     insured_person_stopped_working SMALLINT NOT NULL
  87.                         COMMENT \'Flag if insured person stopped working after accident\',
  88.                     insured_person_stopped_working_date_time DATETIME DEFAULT NULL
  89.                         COMMENT \'Date and time when insured person stopped working\',
  90.                     insured_person_trainee SMALLINT NOT NULL COMMENT \'Flag if insured person is a trainee\',
  91.                     insured_person_weeks_sick_leave INT NOT NULL COMMENT \'Weeks of sick leave for insured person\',
  92.                     insured_person_work_ending_time TIME NOT NULL COMMENT \'Work ending time of insured person\',
  93.                     insured_person_work_starting_time TIME NOT NULL COMMENT \'Work starting time of insured person\',
  94.                     insured_person_zip_code VARCHAR(16) NOT NULL COMMENT \'Zip code of address for insured person\',
  95.                     place VARCHAR(1000) NOT NULL COMMENT \'Place\',
  96.                     receiver_full_address VARCHAR(1000) NOT NULL COMMENT \'Receiver full address\',
  97.                     receiver_name VARCHAR(225) NOT NULL COMMENT \'Receiver name\',
  98.                     work_council_representative_full_name VARCHAR(500) DEFAULT NULL
  99.                         COMMENT \'Full name of approving work council representative\',
  100.                     UNIQUE INDEX UNIQ_F777692B16D8554C (accident_id),
  101.                     INDEX IDX_F777692B7D182D95 (created_by_user_id),
  102.                     INDEX IDX_F777692BF3340201 (insured_person_employee_legal_state_id),
  103.                     INDEX IDX_F777692BD669FA40 (insured_person_gender_id),
  104.                     INDEX IDX_F777692B468FF4C (insured_person_nationality_id),
  105.                     PRIMARY KEY(id)
  106.                 ) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB
  107.             '
  108.         );
  109.         $this->addSql(
  110.             '
  111.                 ALTER TABLE ta_report ADD CONSTRAINT FK_F777692B16D8554C
  112.                     FOREIGN KEY (accident_id) REFERENCES accident (id) ON DELETE CASCADE
  113.             '
  114.         );
  115.         $this->addSql(
  116.             '
  117.                 ALTER TABLE ta_report ADD CONSTRAINT FK_F777692B7D182D95
  118.                     FOREIGN KEY (created_by_user_id) REFERENCES user (id)
  119.             '
  120.         );
  121.         $this->addSql(
  122.             '
  123.                 ALTER TABLE ta_report ADD CONSTRAINT FK_F777692BF3340201
  124.                     FOREIGN KEY (insured_person_employee_legal_state_id) REFERENCES employee_legal_state (id)
  125.             '
  126.         );
  127.         $this->addSql(
  128.             '
  129.                 ALTER TABLE ta_report ADD CONSTRAINT FK_F777692BD669FA40
  130.                     FOREIGN KEY (insured_person_gender_id) REFERENCES gender (id)
  131.             '
  132.         );
  133.         $this->addSql(
  134.             '
  135.                 ALTER TABLE ta_report ADD CONSTRAINT FK_F777692B468FF4C
  136.                     FOREIGN KEY (insured_person_nationality_id) REFERENCES country (id)
  137.             '
  138.         );
  139.     }
  141. }