migrations/Version20241011163447.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 Version20241011163447 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 courier (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(50) NOT NULL, deleted DATETIME DEFAULT NULL, deleted_by VARCHAR(255) DEFAULT NULL, created DATETIME NOT NULL, creator VARCHAR(255) NOT NULL, modified DATETIME NOT NULL, modified_by VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  24. $this->addSql('CREATE TABLE courier_translations (translatable_id INT NOT NULL, language_id INT NOT NULL, title VARCHAR(255) DEFAULT NULL, INDEX IDX_376B70C62C2AC5D3 (translatable_id), INDEX IDX_376B70C682F1BAF4 (language_id), PRIMARY KEY(translatable_id, language_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  25. $this->addSql('CREATE TABLE shipping_time (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(45) NOT NULL, number_of_delivery_days INT DEFAULT 0, deleted TINYINT(1) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  26. $this->addSql('CREATE TABLE shipping_time_translation (translatable_id INT NOT NULL, language_id INT NOT NULL, name VARCHAR(255) DEFAULT NULL, INDEX IDX_FEE7D9C42C2AC5D3 (translatable_id), INDEX IDX_FEE7D9C482F1BAF4 (language_id), PRIMARY KEY(translatable_id, language_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  27. $this->addSql('CREATE TABLE shipping_zone (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(50) NOT NULL, deleted DATETIME DEFAULT NULL, deleted_by VARCHAR(255) DEFAULT NULL, created DATETIME NOT NULL, creator VARCHAR(255) NOT NULL, modified DATETIME NOT NULL, modified_by VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  28. $this->addSql('CREATE TABLE shipping_zone_zone (shipping_zone_id INT NOT NULL, zone_id INT NOT NULL, INDEX IDX_74E650957964396F (shipping_zone_id), INDEX IDX_74E650959F2C3FAB (zone_id), PRIMARY KEY(shipping_zone_id, zone_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  29. $this->addSql('CREATE TABLE shipping_zone_price (id INT AUTO_INCREMENT NOT NULL, source_shipping_zone_id INT DEFAULT NULL, target_shipping_zone_id INT DEFAULT NULL, shipping_time_id INT DEFAULT NULL, currency_id INT DEFAULT NULL, courier_id INT DEFAULT NULL, calculator VARCHAR(45) NOT NULL, has_rates TINYINT(1) NOT NULL, configuration JSON NOT NULL COMMENT \'(DC2Type:json)\', created DATETIME NOT NULL, creator VARCHAR(255) NOT NULL, modified DATETIME NOT NULL, modified_by VARCHAR(255) NOT NULL, INDEX IDX_D41DDD21EE10FFC9 (source_shipping_zone_id), INDEX IDX_D41DDD21AD9D076F (target_shipping_zone_id), INDEX IDX_D41DDD21B8A2DBFF (shipping_time_id), INDEX IDX_D41DDD2138248176 (currency_id), INDEX IDX_D41DDD21E3D8151C (courier_id), UNIQUE INDEX shipping_zone_unique (source_shipping_zone_id, target_shipping_zone_id, shipping_time_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  30. $this->addSql('CREATE TABLE shipping_zone_price_specific_weight (id INT AUTO_INCREMENT NOT NULL, shipping_zone_price_id INT DEFAULT NULL, weight DOUBLE PRECISION NOT NULL, rate DOUBLE PRECISION NOT NULL, deleted DATETIME DEFAULT NULL, deleted_by VARCHAR(255) DEFAULT NULL, created DATETIME NOT NULL, creator VARCHAR(255) NOT NULL, modified DATETIME NOT NULL, modified_by VARCHAR(255) NOT NULL, INDEX IDX_1C56A91185E3EB8 (shipping_zone_price_id), UNIQUE INDEX shipping_zone_price_specific_weight_unique (shipping_zone_price_id, weight), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  31. $this->addSql('CREATE TABLE zone (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(50) NOT NULL, tarteb SMALLINT DEFAULT NULL, deleted DATETIME DEFAULT NULL, deleted_by VARCHAR(255) DEFAULT NULL, created DATETIME NOT NULL, creator VARCHAR(255) NOT NULL, modified DATETIME NOT NULL, modified_by VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  32. $this->addSql('CREATE TABLE zone_translations (translatable_id INT NOT NULL, language_id INT NOT NULL, title VARCHAR(255) DEFAULT NULL, INDEX IDX_1C7748542C2AC5D3 (translatable_id), INDEX IDX_1C77485482F1BAF4 (language_id), PRIMARY KEY(translatable_id, language_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  33. $this->addSql('ALTER TABLE courier_translations ADD CONSTRAINT FK_376B70C62C2AC5D3 FOREIGN KEY (translatable_id) REFERENCES courier (id)');
  34. $this->addSql('ALTER TABLE courier_translations ADD CONSTRAINT FK_376B70C682F1BAF4 FOREIGN KEY (language_id) REFERENCES language (id)');
  35. $this->addSql('ALTER TABLE shipping_time_translation ADD CONSTRAINT FK_FEE7D9C42C2AC5D3 FOREIGN KEY (translatable_id) REFERENCES shipping_time (id)');
  36. $this->addSql('ALTER TABLE shipping_time_translation ADD CONSTRAINT FK_FEE7D9C482F1BAF4 FOREIGN KEY (language_id) REFERENCES language (id)');
  37. $this->addSql('ALTER TABLE shipping_zone_zone ADD CONSTRAINT FK_74E650957964396F FOREIGN KEY (shipping_zone_id) REFERENCES shipping_zone (id) ON DELETE CASCADE');
  38. $this->addSql('ALTER TABLE shipping_zone_zone ADD CONSTRAINT FK_74E650959F2C3FAB FOREIGN KEY (zone_id) REFERENCES zone (id) ON DELETE CASCADE');
  39. $this->addSql('ALTER TABLE shipping_zone_price ADD CONSTRAINT FK_D41DDD21EE10FFC9 FOREIGN KEY (source_shipping_zone_id) REFERENCES shipping_zone (id)');
  40. $this->addSql('ALTER TABLE shipping_zone_price ADD CONSTRAINT FK_D41DDD21AD9D076F FOREIGN KEY (target_shipping_zone_id) REFERENCES shipping_zone (id)');
  41. $this->addSql('ALTER TABLE shipping_zone_price ADD CONSTRAINT FK_D41DDD21B8A2DBFF FOREIGN KEY (shipping_time_id) REFERENCES shipping_time (id)');
  42. $this->addSql('ALTER TABLE shipping_zone_price ADD CONSTRAINT FK_D41DDD2138248176 FOREIGN KEY (currency_id) REFERENCES currency (id)');
  43. $this->addSql('ALTER TABLE shipping_zone_price ADD CONSTRAINT FK_D41DDD21E3D8151C FOREIGN KEY (courier_id) REFERENCES courier (id)');
  44. $this->addSql('ALTER TABLE shipping_zone_price_specific_weight ADD CONSTRAINT FK_1C56A91185E3EB8 FOREIGN KEY (shipping_zone_price_id) REFERENCES shipping_zone_price (id)');
  45. $this->addSql('ALTER TABLE zone_translations ADD CONSTRAINT FK_1C7748542C2AC5D3 FOREIGN KEY (translatable_id) REFERENCES zone (id)');
  46. $this->addSql('ALTER TABLE zone_translations ADD CONSTRAINT FK_1C77485482F1BAF4 FOREIGN KEY (language_id) REFERENCES language (id)');
  47. $this->addSql('ALTER TABLE store_address ADD zone_id INT DEFAULT NULL');
  48. $this->addSql('ALTER TABLE store_address ADD CONSTRAINT FK_14464E669F2C3FAB FOREIGN KEY (zone_id) REFERENCES zone (id)');
  49. $this->addSql('CREATE INDEX IDX_14464E669F2C3FAB ON store_address (zone_id)');
  50. $this->addSql('ALTER TABLE order_shipping_address DROP FOREIGN KEY FK_89107D599F2C3FAB');
  51. $this->addSql('ALTER TABLE order_shipping_address ADD CONSTRAINT FK_89107D599F2C3FAB FOREIGN KEY (zone_id) REFERENCES zone (id)');
  52. $this->addSql('ALTER TABLE shipping_address DROP FOREIGN KEY FK_EB0669459F2C3FAB');
  53. $this->addSql('ALTER TABLE shipping_address ADD CONSTRAINT FK_EB0669459F2C3FAB FOREIGN KEY (zone_id) REFERENCES zone (id)');
  54. }
  56. public function down(Schema $schema): void
  57. {
  58. // this down() migration is auto-generated, please modify it to your needs
  59. $this->addSql('ALTER TABLE store_address DROP FOREIGN KEY FK_14464E669F2C3FAB');
  60. $this->addSql('ALTER TABLE courier_translations DROP FOREIGN KEY FK_376B70C62C2AC5D3');
  61. $this->addSql('ALTER TABLE courier_translations DROP FOREIGN KEY FK_376B70C682F1BAF4');
  62. $this->addSql('ALTER TABLE shipping_time_translation DROP FOREIGN KEY FK_FEE7D9C42C2AC5D3');
  63. $this->addSql('ALTER TABLE shipping_time_translation DROP FOREIGN KEY FK_FEE7D9C482F1BAF4');
  64. $this->addSql('ALTER TABLE shipping_zone_zone DROP FOREIGN KEY FK_74E650957964396F');
  65. $this->addSql('ALTER TABLE shipping_zone_zone DROP FOREIGN KEY FK_74E650959F2C3FAB');
  66. $this->addSql('ALTER TABLE shipping_zone_price DROP FOREIGN KEY FK_D41DDD21EE10FFC9');
  67. $this->addSql('ALTER TABLE shipping_zone_price DROP FOREIGN KEY FK_D41DDD21AD9D076F');
  68. $this->addSql('ALTER TABLE shipping_zone_price DROP FOREIGN KEY FK_D41DDD21B8A2DBFF');
  69. $this->addSql('ALTER TABLE shipping_zone_price DROP FOREIGN KEY FK_D41DDD2138248176');
  70. $this->addSql('ALTER TABLE shipping_zone_price DROP FOREIGN KEY FK_D41DDD21E3D8151C');
  71. $this->addSql('ALTER TABLE shipping_zone_price_specific_weight DROP FOREIGN KEY FK_1C56A91185E3EB8');
  72. $this->addSql('ALTER TABLE zone_translations DROP FOREIGN KEY FK_1C7748542C2AC5D3');
  73. $this->addSql('ALTER TABLE zone_translations DROP FOREIGN KEY FK_1C77485482F1BAF4');
  74. $this->addSql('DROP TABLE courier');
  75. $this->addSql('DROP TABLE courier_translations');
  76. $this->addSql('DROP TABLE shipping_time');
  77. $this->addSql('DROP TABLE shipping_time_translation');
  78. $this->addSql('DROP TABLE shipping_zone');
  79. $this->addSql('DROP TABLE shipping_zone_zone');
  80. $this->addSql('DROP TABLE shipping_zone_price');
  81. $this->addSql('DROP TABLE shipping_zone_price_specific_weight');
  82. $this->addSql('DROP TABLE zone');
  83. $this->addSql('DROP TABLE zone_translations');
  84. $this->addSql('DROP INDEX IDX_14464E669F2C3FAB ON store_address');
  85. $this->addSql('ALTER TABLE store_address DROP zone_id');
  86. $this->addSql('ALTER TABLE order_shipping_address DROP FOREIGN KEY FK_89107D599F2C3FAB');
  87. $this->addSql('ALTER TABLE order_shipping_address ADD CONSTRAINT FK_89107D599F2C3FAB FOREIGN KEY (zone_id) REFERENCES city (id)');
  88. $this->addSql('ALTER TABLE shipping_address DROP FOREIGN KEY FK_EB0669459F2C3FAB');
  89. $this->addSql('ALTER TABLE shipping_address ADD CONSTRAINT FK_EB0669459F2C3FAB FOREIGN KEY (zone_id) REFERENCES city (id)');
  90. }
  91. }