migrations/Version20200609102733.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace Application\Migrations;
  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 Version20200609102733 extends AbstractMigration
  14. {
  15.     public function up(Schema $schema): void
  16.     {
  17.         $this->addSql('RENAME TABLE non_member_billing_company  TO legal_entity_billing_company');
  18.         $this->addSql('RENAME TABLE non_member_billing_contact_person TO legal_entity_billing_contact_person');
  19.         $this->addSql('RENAME TABLE non_member_contract TO legal_entity_contract');
  20.         $this->addSql('RENAME TABLE non_member_license_agreement TO legal_entity_license_agreement');
  21.         $this->addSql('RENAME TABLE non_member_order_invoice_item TO legal_entity_order_invoice_item');
  22.         $this->addSql('RENAME TABLE non_member_order_invoice_manual TO legal_entity_order_invoice_manual');
  23.         $this->addSql('RENAME TABLE non_member_order_invoice_manual_item TO legal_entity_order_invoice_manual_item');
  24.         $this->addSql('RENAME TABLE non_member_order_invoice_reminder TO legal_entity_order_invoice_reminder');
  25.         $this->addSql('RENAME TABLE non_member_order_invoice TO legal_entity_order_invoice');
  26.         $this->addSql('RENAME TABLE non_member_order TO legal_entity_order');
  27.         $this->addSql('RENAME TABLE non_member_order_line_dossiers TO legal_entity_order_line_dossiers');
  28.         $this->addSql('RENAME TABLE non_member_order_line_dossiers_pending TO legal_entity_order_line_dossiers_pending');
  29.         $this->addSql('RENAME TABLE non_member_order_line TO legal_entity_order_line');
  30.         $this->addSql('RENAME TABLE non_member_order_line_status TO legal_entity_order_line_status');
  31.         $this->addSql('RENAME TABLE non_member_order_reinvoicing_line TO legal_entity_order_reinvoicing_line');
  32.         $this->addSql('RENAME TABLE non_member_active_definition TO legal_entity_active_definition');
  33.         $this->addSql('RENAME TABLE non_member_cart_line TO legal_entity_cart_line');
  34.         $this->addSql('RENAME TABLE member_company_remark TO legal_entity_member_company_remark');
  35.         $this->addSql('RENAME TABLE member_company TO legal_entity_member_company');
  36.         $this->addSql('ALTER TABLE legal_entity ADD COLUMN member TINYINT(1)');
  37.         $this->addSql('ALTER TABLE `legal_entity` CHANGE `company_id` `member_company_id` INT(11) NULL DEFAULT NULL;');
  38.         $this->addSql('UPDATE legal_entity SET member = 1 WHERE _discr = :member', ['member' => 'member']);
  39.         $this->addSql('UPDATE legal_entity SET member = 0 WHERE _discr != :member', ['member' => 'member']);
  40.         $this->addSql('UPDATE legal_entity SET active_definition_id = null');
  41.         $this->addSql('ALTER TABLE `legal_entity` DROP COLUMN `_discr`');
  42.         $this->addSql('ALTER TABLE `legal_entity_order` CHANGE `number` `number` INT(11) NULL;');
  43.     }
  45.     public function down(Schema $schema): void
  46.     {
  47.         $this->addSql('RENAME TABLE legal_entity_billing_company  TO non_member_billing_company');
  48.         $this->addSql('RENAME TABLE legal_entity_billing_contact_person TO non_member_billing_contact_person');
  49.         $this->addSql('RENAME TABLE legal_entity_contract TO non_member_contract');
  50.         $this->addSql('RENAME TABLE legal_entity_license_agreement TO non_member_license_agreement');
  51.         $this->addSql('RENAME TABLE legal_entity_order_invoice_item TO non_member_order_invoice_item');
  52.         $this->addSql('RENAME TABLE legal_entity_order_invoice_manual TO non_member_order_invoice_manual');
  53.         $this->addSql('RENAME TABLE legal_entity_order_invoice_manual_item TO non_member_order_invoice_manual_item');
  54.         $this->addSql('RENAME TABLE legal_entity_order_invoice_reminder TO non_member_order_invoice_reminder');
  55.         $this->addSql('RENAME TABLE legal_entity_order_invoice TO non_member_order_invoice');
  56.         $this->addSql('RENAME TABLE legal_entity_order TO non_member_order');
  57.         $this->addSql('RENAME TABLE legal_entity_order_line_dossiers TO non_member_order_line_dossiers');
  58.         $this->addSql('RENAME TABLE legal_entity_order_line_dossiers_pending TO non_member_order_line_dossiers_pending');
  59.         $this->addSql('RENAME TABLE legal_entity_order_line TO non_member_order_line');
  60.         $this->addSql('RENAME TABLE legal_entity_order_line_status TO non_member_order_line_status');
  61.         $this->addSql('RENAME TABLE legal_entity_order_reinvoicing_line TO non_member_order_reinvoicing_line');
  62.         $this->addSql('RENAME TABLE legal_entity_active_definition TO non_member_active_definition');
  63.         $this->addSql('RENAME TABLE legal_entity_cart_line TO non_member_cart_line');
  64.         $this->addSql('RENAME TABLE legal_entity_member_company_remark TO member_company_remark');
  65.         $this->addSql('RENAME TABLE legal_entity_member_company TO member_company');
  66.         $this->addSql('ALTER TABLE legal_entity ADD COLUMN _discr VARCHAR(255)');
  67.         $this->addSql('UPDATE legal_entity SET _discr = "member" WHERE member = 1', ['member' => 'member']);
  68.         $this->addSql('UPDATE legal_entity SET _discr = "nonmember" WHERE member = 0', ['member' => 'member']);
  69.         $this->addSql('ALTER TABLE legal_entity DROP COLUMN member');
  70.         $this->addSql('ALTER TABLE `legal_entity` CHANGE `member_company_id` `company_id` INT(11) NULL DEFAULT NULL;');
  71.         $this->addSql('ALTER TABLE `non_member_order` CHANGE `number` `number` INT(11) NOT NULL;');
  72.     }
  73. }