migrations/Version20240726045328.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 Version20240726045328 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         $this->addSql("CREATE TABLE `dp_workorder_ship_history` (
  23.             `id` int NOT NULL AUTO_INCREMENT,
  24.             `workorder_id` int NOT NULL,
  25.             `product_id` int NOT NULL,
  26.             `product_var_id` int DEFAULT NULL,
  27.             `company_id` int NOT NULL,
  28.             `quantity` int NOT NULL,
  29.             `ship_date` datetime NOT NULL,
  30.             `created_at` datetime NOT NULL,
  31.             `created_by` int NOT NULL,
  32.             PRIMARY KEY (`id`),
  33.             KEY `work_order_id` (`workorder_id`),
  34.             KEY `created_by` (`created_by`),
  35.             KEY `company_id` (`company_id`),
  36.             KEY `workorder_id` (`workorder_id`),
  37.             KEY `product_id` (`product_id`),
  38.             KEY `product_var_id` (`product_var_id`),
  39.             CONSTRAINT `dp_workorder_ship_history_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  40.             CONSTRAINT `dp_workorder_ship_history_ibfk_2` FOREIGN KEY (`workorder_id`) REFERENCES `dp_workorder` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  41.             CONSTRAINT `dp_workorder_ship_history_ibfk_3` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  42.             CONSTRAINT `dp_workorder_ship_history_ibfk_4` FOREIGN KEY (`product_id`) REFERENCES `dp_products` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  43.             CONSTRAINT `dp_workorder_ship_history_ibfk_5` FOREIGN KEY (`product_var_id`) REFERENCES `dp_product_variants` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  44.             ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"
  45.             );
  46.     
  47.             $this->addSql(
  48.                 "CREATE TABLE `dp_workorder_allocated_quantity` (
  49.                     `id` int NOT NULL AUTO_INCREMENT,
  50.                     `level_id` int NOT NULL,
  51.                     `company_id` int NOT NULL,
  52.                     `workorder_id` int NOT NULL,
  53.                     `product_id` int DEFAULT NULL,
  54.                     `product_var_id` int DEFAULT NULL,
  55.                     `total_allocated_qty` int NOT NULL DEFAULT '0',
  56.                     `allocated_qty` int NOT NULL DEFAULT '0',
  57.                     `created_by` int NOT NULL,
  58.                     `created_at` datetime NOT NULL,
  59.                     `updated_by` int DEFAULT NULL,
  60.                     `updated_at` datetime DEFAULT NULL,
  61.                     PRIMARY KEY (`id`),
  62.                     KEY `work_order_id` (`workorder_id`),
  63.                     KEY `created_by` (`created_by`),
  64.                     KEY `updated_by` (`updated_by`),
  65.                     KEY `company_id` (`company_id`),
  66.                     KEY `level_id` (`level_id`),
  67.                     KEY `product_id` (`product_id`),
  68.                     KEY `product_var_id` (`product_var_id`),
  69.                     CONSTRAINT `dp_workorder_allocated_quantity_ibfk_1` FOREIGN KEY (`workorder_id`) REFERENCES `dp_workorder` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  70.                     CONSTRAINT `dp_workorder_allocated_quantity_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  71.                     CONSTRAINT `dp_workorder_allocated_quantity_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  72.                     CONSTRAINT `dp_workorder_allocated_quantity_ibfk_4` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  73.                     CONSTRAINT `dp_workorder_allocated_quantity_ibfk_5` FOREIGN KEY (`level_id`) REFERENCES `dp_levels` (`level_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  74.                     CONSTRAINT `dp_workorder_allocated_quantity_ibfk_6` FOREIGN KEY (`product_id`) REFERENCES `dp_products` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  75.                     CONSTRAINT `dp_workorder_allocated_quantity_ibfk_7` FOREIGN KEY (`product_var_id`) REFERENCES `dp_product_variants` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  76.                     ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4"
  77.                 );
  78.     
  79.             $this->addSql(
  80.                 "CREATE TABLE `dp_workorder_ship_quantity` (
  81.                 `id` int NOT NULL AUTO_INCREMENT,
  82.                 `workorder_id` int NOT NULL,
  83.                 `company_id` int NOT NULL,
  84.                 `product_id` int NOT NULL,
  85.                 `product_var_id` int DEFAULT NULL,
  86.                 `shipped_qty` int NOT NULL,
  87.                 `last_shipped_date` int NOT NULL,
  88.                 `fully_shipped` int NOT NULL,
  89.                 `created_by` int NOT NULL,
  90.                 `created_at` int NOT NULL,
  91.                 `updated_by` int DEFAULT NULL,
  92.                 `updated_at` int DEFAULT NULL,
  93.                 PRIMARY KEY (`id`),
  94.                 KEY `work_order_id` (`workorder_id`),
  95.                 KEY `created_by` (`created_by`),
  96.                 KEY `updated_by` (`updated_by`),
  97.                 KEY `company_id` (`company_id`),
  98.                 KEY `product_id` (`product_id`),
  99.                 KEY `product_var_id` (`product_var_id`),
  100.                 CONSTRAINT `dp_workorder_ship_quantity_ibfk_1` FOREIGN KEY (`workorder_id`) REFERENCES `dp_workorder` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  101.                 CONSTRAINT `dp_workorder_ship_quantity_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  102.                 CONSTRAINT `dp_workorder_ship_quantity_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  103.                 CONSTRAINT `dp_workorder_ship_quantity_ibfk_4` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  104.                 CONSTRAINT `dp_workorder_ship_quantity_ibfk_5` FOREIGN KEY (`product_id`) REFERENCES `dp_products` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  105.                 CONSTRAINT `dp_workorder_ship_quantity_ibfk_6` FOREIGN KEY (`product_var_id`) REFERENCES `dp_product_variants` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  106.                 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"
  107.                 );
  109.             $this->addSql(
  110.                 "CREATE TABLE `dp_scrap_reasons` (
  111.                 `id` int NOT NULL AUTO_INCREMENT,
  112.                 `comment` text NOT NULL,
  113.                 `company_id` int NOT NULL,
  114.                 `created_by` int NOT NULL,
  115.                 `created_at` datetime NOT NULL,
  116.                 PRIMARY KEY (`id`),
  117.                 KEY `company_id` (`company_id`),
  118.                 KEY `created_by` (`created_by`),
  119.                 CONSTRAINT `dp_scrap_reasons_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  120.                 CONSTRAINT `dp_scrap_reasons_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  121.                 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4"
  122.                 );
  123.             
  124.     
  125.             $this->addSql("ALTER TABLE tc_production_history ADD scrap_reason_id INT");
  126.             $this->addSql("ALTER TABLE tc_production_history ADD CONSTRAINT tc_production_history_ibfk_6 FOREIGN KEY (scrap_reason_id) REFERENCES dp_scrap_reasons(id)");
  127.             $this->addSql("ALTER TABLE `tc_production_history` CHANGE `action` `action` ENUM('qty_added','move_to_stock','scrap_qty') CHARACTER SET utf8mb4");
  129.             $this->addSql("ALTER TABLE tc_production_history ADD company_id INT");
  130.             $this->addSql("ALTER TABLE `tc_production_history` ADD FOREIGN KEY (`company_id`) REFERENCES `company`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT");
  132.             $this->addSql("ALTER TABLE `tc_stock_quantity` ADD `company_id` INT NULL AFTER `total_stock`");
  133.             $this->addSql("ALTER TABLE `tc_stock_quantity` ADD FOREIGN KEY (`company_id`) REFERENCES `company`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT");
  135.             $this->addSql("ALTER TABLE `tc_production_history` ADD `product_id` INT DEFAULT NULL AFTER `company_id`");
  136.             $this->addSql("ALTER TABLE `tc_production_history` ADD FOREIGN KEY (`product_id`) REFERENCES `dp_products` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT");
  137.             $this->addSql("ALTER TABLE `tc_production_history` ADD `product_var_id` INT DEFAULT NULL AFTER `product_id`");
  138.             $this->addSql("ALTER TABLE `tc_production_history` ADD FOREIGN KEY (`product_var_id`) REFERENCES `dp_product_variants` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT");
  139.             $this->addSql("INSERT INTO dp_scrap_reasons (id, comment, company_id, created_by, created_at) VALUES
  140.             (1, 'reason no 1', 1, 1, '2024-07-26 10:22:11'),
  141.             (2, 'reason no 2', 1, 1, '2024-07-26 07:06:48'),
  142.             (3, 'missing ', 1, 1, '2024-07-30 09:39:55')");
  143.     }   
  145.     public function down(Schema $schema): void
  146.     {
  147.         $this->addSql('DROP TABLE dp_workorder_ship_history');
  148.         $this->addSql('DROP TABLE dp_workorder_allocated_quantity');
  149.         $this->addSql('DROP TABLE dp_workorder_ship_quantity');
  150.         $this->addSql('ALTER TABLE tc_production_history DROP FOREIGN KEY tc_production_history_ibfk_6');
  151.         $this->addSql('ALTER TABLE tc_production_history DROP COLUMN scrap_reason_id');
  152.         $this->addSql("ALTER TABLE `tc_production_history` CHANGE `action` `action` ENUM('qty_added','move_to_stock') CHARACTER SET utf8mb4");
  154.         $this->addSql("ALTER TABLE `tc_production_history` DROP FOREIGN KEY `tc_production_history_ibfk_7`");
  155.         $this->addSql("ALTER TABLE `tc_production_history` DROP COLUMN `company_id`");
  156.         
  157.         $this->addSql("ALTER TABLE `tc_stock_quantity` DROP FOREIGN KEY `fk_company_id`");
  158.         $this->addSql("ALTER TABLE `tc_stock_quantity` DROP COLUMN `company_id`");
  160.     }
  161. }