migrations/Delete/Version20240923152803_InvoicingInvoice.php line 1

  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations\Delete;
  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 Version20240923152803_InvoicingInvoice extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return 'Add invoicing invoice';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         $this->addSql("CREATE TABLE invoicing_invoice (
  23.             id                              SERIAL PRIMARY KEY,
  24.             batch_id                        INTEGER                     NOT NULL REFERENCES public.invoicing_batch (id),
  26.             slug                            CHARACTER VARYING           NOT NULL,
  27.             reference                       CHARACTER VARYING           NOT NULL,
  28.             version                         INTEGER,
  29.             order_number                    CHARACTER VARYING           NOT NULL,
  30.             origin                          CHARACTER VARYING           NOT NULL,
  31.             pickup_place                    CHARACTER VARYING           NOT NULL,
  32.             pickup_country_code             CHARACTER VARYING           NOT NULL,
  33.             tariff_zone                     CHARACTER VARYING           NOT NULL,
  34.             boxes_count                     INTEGER                     NOT NULL,
  35.             weight                          DECIMAL(18, 5)              NOT NULL,
  36.             volume                          DECIMAL(18, 5)              NOT NULL,
  37.             value                           DECIMAL(18, 5),
  38.             europe                          BOOLEAN                     NOT NULL,
  39.             combined                        BOOLEAN                     NOT NULL,
  40.             invoiced                        BOOLEAN                     NOT NULL,
  41.             data                            JSON                        NOT NULL,
  42.             atc                             DATE,
  44.             created_by                      INTEGER                              REFERENCES public.user (id),
  45.             updated_by                      INTEGER                              REFERENCES public.user (id),
  46.             created_at                      TIMESTAMP(0) WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP,
  47.             updated_at                      TIMESTAMP(0) WITH TIME ZONE,
  48.             deleted_at                      TIMESTAMP(0) WITH TIME ZONE
  49.         )");
  50.     }
  52.     public function down(Schema $schema): void
  53.     {
  54.         $this->addSql("DROP TABLE IF EXISTS invoicing_invoice");
  55.     }
  56. }