Symfony Profiler

<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
final class Version20221013005129 extends AbstractMigration
{
public function getDescription(): string
{
return '';
}
public function up(Schema $schema): void
{
// this up() migration is auto-generated, please modify it to your needs
// $this->addSql('CREATE TABLE appropriate (id INT AUTO_INCREMENT NOT NULL, no VARCHAR(100) NOT NULL, name VARCHAR(100) NOT NULL, sort_no SMALLINT UNSIGNED DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
// $this->addSql('CREATE TABLE delivery_fee_check (id INT NOT NULL, name VARCHAR(100) NOT NULL, sort_no SMALLINT UNSIGNED DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
// $this->addSql('CREATE TABLE delivery_time (id INT NOT NULL, name VARCHAR(100) NOT NULL, sort_no SMALLINT UNSIGNED DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
// $this->addSql('CREATE TABLE order_item (id INT AUTO_INCREMENT NOT NULL, partner_id INT DEFAULT NULL, type_id INT DEFAULT NULL, appropriate_id INT DEFAULT NULL, user_id INT DEFAULT NULL, order_item_shipping_id INT DEFAULT NULL, no VARCHAR(100) DEFAULT NULL, src VARCHAR(100) NOT NULL, order_date DATETIME DEFAULT NULL, shipping_date DATETIME DEFAULT NULL, sender_code VARCHAR(100) DEFAULT NULL, sender_name VARCHAR(100) DEFAULT NULL, sender_zip VARCHAR(100) DEFAULT NULL, sender_addr VARCHAR(100) DEFAULT NULL, sender_tel VARCHAR(100) DEFAULT NULL, sender_fax VARCHAR(100) DEFAULT NULL, orderer_name VARCHAR(100) DEFAULT NULL, orderer_kana VARCHAR(100) DEFAULT NULL, orderer_zip VARCHAR(100) DEFAULT NULL, orderer_addr VARCHAR(100) DEFAULT NULL, orderer_tel VARCHAR(100) DEFAULT NULL, orderer_email VARCHAR(100) DEFAULT NULL, orderer_shipping_preferred_date VARCHAR(100) DEFAULT NULL, orderer_shipping_preferred_time VARCHAR(100) DEFAULT NULL, memo VARCHAR(200) DEFAULT NULL, remarks LONGTEXT DEFAULT NULL, remarks_1 LONGTEXT DEFAULT NULL, remarks_2 LONGTEXT DEFAULT NULL, remarks_3 LONGTEXT DEFAULT NULL, delivery_remarks_1 LONGTEXT DEFAULT NULL, delivery_remarks_2 LONGTEXT DEFAULT NULL, delivery_remarks_3 LONGTEXT DEFAULT NULL, create_date DATETIME NOT NULL, update_date DATETIME DEFAULT NULL, delete_date DATETIME DEFAULT NULL, INDEX IDX_52EA1F099393F8FE (partner_id), INDEX IDX_52EA1F09C54C8C93 (type_id), INDEX IDX_52EA1F09828F83CA (appropriate_id), INDEX IDX_52EA1F09A76ED395 (user_id), UNIQUE INDEX UNIQ_52EA1F09CAF9BFD2 (order_item_shipping_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
// $this->addSql('CREATE TABLE order_item_detail (id INT AUTO_INCREMENT NOT NULL, order_item_id INT DEFAULT NULL, product_id INT DEFAULT NULL, no VARCHAR(100) DEFAULT NULL, name VARCHAR(100) DEFAULT NULL, price INT DEFAULT NULL, qty INT DEFAULT NULL, create_date DATETIME NOT NULL, update_date DATETIME DEFAULT NULL, delete_date DATETIME DEFAULT NULL, INDEX IDX_B34D75DAE415FB15 (order_item_id), INDEX IDX_B34D75DA4584665A (product_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
// $this->addSql('CREATE TABLE order_item_material (id INT AUTO_INCREMENT NOT NULL, delivery_fee_check INT DEFAULT NULL, order_item_id INT DEFAULT NULL, material_id INT DEFAULT NULL, no VARCHAR(100) NOT NULL, name VARCHAR(255) NOT NULL, price INT DEFAULT NULL, qty INT DEFAULT NULL, class_pot VARCHAR(10) DEFAULT NULL, class_h VARCHAR(10) DEFAULT NULL, class_c VARCHAR(10) DEFAULT NULL, class_w VARCHAR(10) DEFAULT NULL, class_l VARCHAR(10) DEFAULT NULL, class_medate VARCHAR(10) DEFAULT NULL, unit VARCHAR(10) DEFAULT NULL, delivery_fee INT DEFAULT NULL, create_date DATETIME DEFAULT NULL, update_date DATETIME DEFAULT NULL, delete_date DATETIME DEFAULT NULL, INDEX IDX_BDD0F58CCBE48CA3 (delivery_fee_check), INDEX IDX_BDD0F58CE415FB15 (order_item_id), INDEX IDX_BDD0F58CE308AC6F (material_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
// $this->addSql('CREATE TABLE order_item_other (id INT AUTO_INCREMENT NOT NULL, order_item_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, total INT DEFAULT NULL, create_date DATETIME DEFAULT NULL, update_date DATETIME DEFAULT NULL, delete_date DATETIME DEFAULT NULL, INDEX IDX_4025D3A5E415FB15 (order_item_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
// $this->addSql('CREATE TABLE order_item_send_request (id INT AUTO_INCREMENT NOT NULL, order_item_id INT DEFAULT NULL, order_item_shipping_id INT DEFAULT NULL, supplier_id INT DEFAULT NULL, pdf_filename VARCHAR(100) NOT NULL, tracking_no VARCHAR(100) DEFAULT NULL, print_date DATETIME DEFAULT NULL, revision INT NOT NULL, create_date DATETIME NOT NULL, delete_date DATETIME DEFAULT NULL, INDEX IDX_36E74D6BE415FB15 (order_item_id), INDEX IDX_36E74D6BCAF9BFD2 (order_item_shipping_id), INDEX IDX_36E74D6B2ADD6D8C (supplier_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE order_item_shipping (id INT AUTO_INCREMENT NOT NULL, delivery INT DEFAULT NULL, delivery_type INT DEFAULT NULL, delivery_time INT DEFAULT NULL, order_item_id INT DEFAULT NULL, no VARCHAR(100) NOT NULL, name VARCHAR(100) DEFAULT NULL, kana VARCHAR(100) DEFAULT NULL, zip VARCHAR(100) DEFAULT NULL, addr VARCHAR(100) DEFAULT NULL, tel VARCHAR(100) DEFAULT NULL, delivery_remarks VARCHAR(100) DEFAULT NULL, delivery_date DATETIME DEFAULT NULL, shipping_preferred_date DATETIME DEFAULT NULL, create_date DATETIME NOT NULL, update_date DATETIME DEFAULT NULL, delete_date DATETIME DEFAULT NULL, INDEX IDX_EC72973D3781EC10 (delivery), INDEX IDX_EC72973D5D429FB3 (delivery_type), INDEX IDX_EC72973DBE0850DF (delivery_time), UNIQUE INDEX UNIQ_EC72973DE415FB15 (order_item_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
// $this->addSql('CREATE TABLE order_item_status_history (id INT AUTO_INCREMENT NOT NULL, order_item_id INT DEFAULT NULL, status_id INT DEFAULT NULL, user_id INT DEFAULT NULL, message LONGTEXT DEFAULT NULL, create_date DATETIME NOT NULL, delete_date DATETIME DEFAULT NULL, INDEX IDX_F1C19848E415FB15 (order_item_id), INDEX IDX_F1C198486BF700BD (status_id), INDEX IDX_F1C19848A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE order_item_supply (id INT AUTO_INCREMENT NOT NULL, order_item_id INT DEFAULT NULL, order_item_shipping_id INT DEFAULT NULL, order_item_material_id INT DEFAULT NULL, supplier_id INT DEFAULT NULL, delivery INT DEFAULT NULL, delivery_type INT DEFAULT NULL, delivery_fee_check INT DEFAULT NULL, supplier_no INT DEFAULT NULL, supplier_name VARCHAR(255) DEFAULT NULL, supplier_short_name VARCHAR(255) DEFAULT NULL, supplier_zip VARCHAR(8) DEFAULT NULL, supplier_address VARCHAR(255) DEFAULT NULL, supplier_tel_no VARCHAR(14) DEFAULT NULL, supplier_fax_no VARCHAR(14) DEFAULT NULL, supplier_email VARCHAR(180) DEFAULT NULL, supplier_invoice INT DEFAULT NULL, price INT DEFAULT NULL, qty INT DEFAULT NULL, unit VARCHAR(10) DEFAULT NULL, delivery_fee INT DEFAULT NULL, tracking VARCHAR(30) DEFAULT NULL, create_date DATETIME DEFAULT NULL, update_date DATETIME DEFAULT NULL, delete_date DATETIME DEFAULT NULL, INDEX IDX_4F529EC5E415FB15 (order_item_id), INDEX IDX_4F529EC5CAF9BFD2 (order_item_shipping_id), INDEX IDX_4F529EC56176E045 (order_item_material_id), INDEX IDX_4F529EC52ADD6D8C (supplier_id), INDEX IDX_4F529EC53781EC10 (delivery), INDEX IDX_4F529EC55D429FB3 (delivery_type), INDEX IDX_4F529EC5CBE48CA3 (delivery_fee_check), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
// $this->addSql('CREATE TABLE status_order_item (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(100) NOT NULL, path_name VARCHAR(100) DEFAULT NULL, color VARCHAR(100) DEFAULT NULL, sort_no SMALLINT UNSIGNED DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
// $this->addSql('ALTER TABLE order_item ADD CONSTRAINT FK_52EA1F099393F8FE FOREIGN KEY (partner_id) REFERENCES partner (id)');
// $this->addSql('ALTER TABLE order_item ADD CONSTRAINT FK_52EA1F09C54C8C93 FOREIGN KEY (type_id) REFERENCES type (id)');
// $this->addSql('ALTER TABLE order_item ADD CONSTRAINT FK_52EA1F09828F83CA FOREIGN KEY (appropriate_id) REFERENCES appropriate (id)');
// $this->addSql('ALTER TABLE order_item ADD CONSTRAINT FK_52EA1F09A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
// $this->addSql('ALTER TABLE order_item ADD CONSTRAINT FK_52EA1F09CAF9BFD2 FOREIGN KEY (order_item_shipping_id) REFERENCES order_item_shipping (id)');
// $this->addSql('ALTER TABLE order_item_detail ADD CONSTRAINT FK_B34D75DAE415FB15 FOREIGN KEY (order_item_id) REFERENCES order_item (id)');
// $this->addSql('ALTER TABLE order_item_detail ADD CONSTRAINT FK_B34D75DA4584665A FOREIGN KEY (product_id) REFERENCES product (id) ON DELETE SET NULL');
// $this->addSql('ALTER TABLE order_item_material ADD CONSTRAINT FK_BDD0F58CCBE48CA3 FOREIGN KEY (delivery_fee_check) REFERENCES delivery_fee_check (id)');
// $this->addSql('ALTER TABLE order_item_material ADD CONSTRAINT FK_BDD0F58CE415FB15 FOREIGN KEY (order_item_id) REFERENCES order_item (id)');
// $this->addSql('ALTER TABLE order_item_material ADD CONSTRAINT FK_BDD0F58CE308AC6F FOREIGN KEY (material_id) REFERENCES material (id) ON DELETE SET NULL');
// $this->addSql('ALTER TABLE order_item_other ADD CONSTRAINT FK_4025D3A5E415FB15 FOREIGN KEY (order_item_id) REFERENCES order_item (id)');
// $this->addSql('ALTER TABLE order_item_send_request ADD CONSTRAINT FK_36E74D6BE415FB15 FOREIGN KEY (order_item_id) REFERENCES order_item (id)');
// $this->addSql('ALTER TABLE order_item_send_request ADD CONSTRAINT FK_36E74D6BCAF9BFD2 FOREIGN KEY (order_item_shipping_id) REFERENCES order_item_shipping (id)');
// $this->addSql('ALTER TABLE order_item_send_request ADD CONSTRAINT FK_36E74D6B2ADD6D8C FOREIGN KEY (supplier_id) REFERENCES partner (id)');
$this->addSql('ALTER TABLE order_item_shipping ADD CONSTRAINT FK_EC72973D3781EC10 FOREIGN KEY (delivery) REFERENCES delivery (id)');
$this->addSql('ALTER TABLE order_item_shipping ADD CONSTRAINT FK_EC72973D5D429FB3 FOREIGN KEY (delivery_type) REFERENCES delivery_type (id)');
$this->addSql('ALTER TABLE order_item_shipping ADD CONSTRAINT FK_EC72973DBE0850DF FOREIGN KEY (delivery_time) REFERENCES delivery_time (id)');
$this->addSql('ALTER TABLE order_item_shipping ADD CONSTRAINT FK_EC72973DE415FB15 FOREIGN KEY (order_item_id) REFERENCES order_item (id)');
// $this->addSql('ALTER TABLE order_item_status_history ADD CONSTRAINT FK_F1C19848E415FB15 FOREIGN KEY (order_item_id) REFERENCES order_item (id)');
// $this->addSql('ALTER TABLE order_item_status_history ADD CONSTRAINT FK_F1C198486BF700BD FOREIGN KEY (status_id) REFERENCES status_order_item (id)');
// $this->addSql('ALTER TABLE order_item_status_history ADD CONSTRAINT FK_F1C19848A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE order_item_supply ADD CONSTRAINT FK_4F529EC5E415FB15 FOREIGN KEY (order_item_id) REFERENCES order_item (id)');
$this->addSql('ALTER TABLE order_item_supply ADD CONSTRAINT FK_4F529EC5CAF9BFD2 FOREIGN KEY (order_item_shipping_id) REFERENCES order_item_shipping (id)');
$this->addSql('ALTER TABLE order_item_supply ADD CONSTRAINT FK_4F529EC56176E045 FOREIGN KEY (order_item_material_id) REFERENCES order_item_material (id)');
$this->addSql('ALTER TABLE order_item_supply ADD CONSTRAINT FK_4F529EC52ADD6D8C FOREIGN KEY (supplier_id) REFERENCES partner (id)');
$this->addSql('ALTER TABLE order_item_supply ADD CONSTRAINT FK_4F529EC53781EC10 FOREIGN KEY (delivery) REFERENCES delivery (id)');
$this->addSql('ALTER TABLE order_item_supply ADD CONSTRAINT FK_4F529EC55D429FB3 FOREIGN KEY (delivery_type) REFERENCES delivery_type (id)');
$this->addSql('ALTER TABLE order_item_supply ADD CONSTRAINT FK_4F529EC5CBE48CA3 FOREIGN KEY (delivery_fee_check) REFERENCES delivery_fee_check (id)');
// $this->addSql('ALTER TABLE orders DROP FOREIGN KEY FK_E52FFDEEC54C8C93');
// $this->addSql('ALTER TABLE orders DROP FOREIGN KEY FK_E52FFDEE9393F8FE');
// $this->addSql('ALTER TABLE orders DROP FOREIGN KEY FK_E52FFDEEA76ED395');
// $this->addSql('ALTER TABLE orders_detail DROP FOREIGN KEY FK_8F964642CFFE9AD6');
// $this->addSql('ALTER TABLE orders_detail DROP FOREIGN KEY FK_8F9646424584665A');
// $this->addSql('ALTER TABLE orders_detail DROP FOREIGN KEY FK_8F9646424887F3F8');
// $this->addSql('ALTER TABLE orders_material DROP FOREIGN KEY FK_BB98A853AA1042E3');
// $this->addSql('ALTER TABLE orders_material DROP FOREIGN KEY FK_BB98A853E308AC6F');
// $this->addSql('ALTER TABLE orders_other_fee DROP FOREIGN KEY FK_A61D097E4887F3F8');
// $this->addSql('ALTER TABLE orders_other_fee DROP FOREIGN KEY FK_A61D097EB3C719BE');
// $this->addSql('ALTER TABLE orders_other_fee DROP FOREIGN KEY FK_A61D097ECFFE9AD6');
// $this->addSql('ALTER TABLE orders_send_request DROP FOREIGN KEY FK_FD77397F2ADD6D8C');
// $this->addSql('ALTER TABLE orders_send_request DROP FOREIGN KEY FK_FD77397F4887F3F8');
// $this->addSql('ALTER TABLE orders_send_request DROP FOREIGN KEY FK_FD77397FCFFE9AD6');
// $this->addSql('ALTER TABLE shipping DROP FOREIGN KEY FK_2D1C1724CFFE9AD6');
// $this->addSql('ALTER TABLE shipping DROP FOREIGN KEY FK_2D1C17243781EC10');
// $this->addSql('ALTER TABLE shipping DROP FOREIGN KEY FK_2D1C17245D429FB3');
// $this->addSql('ALTER TABLE status_history DROP FOREIGN KEY FK_2F6A07CECFFE9AD6');
// $this->addSql('ALTER TABLE status_history DROP FOREIGN KEY FK_2F6A07CE6BF700BD');
// $this->addSql('ALTER TABLE status_history DROP FOREIGN KEY FK_2F6A07CEA76ED395');
// $this->addSql('ALTER TABLE supply DROP FOREIGN KEY FK_D219948C4887F3F8');
// $this->addSql('ALTER TABLE supply DROP FOREIGN KEY FK_D219948CCFFE9AD6');
// $this->addSql('ALTER TABLE supply DROP FOREIGN KEY FK_D219948C2ADD6D8C');
// $this->addSql('ALTER TABLE supply DROP FOREIGN KEY FK_D219948CAA1042E3');
// $this->addSql('ALTER TABLE supply DROP FOREIGN KEY FK_D219948CE308AC6F');
// $this->addSql('ALTER TABLE supply DROP FOREIGN KEY FK_D219948C4584665A');
// $this->addSql('ALTER TABLE supply DROP FOREIGN KEY FK_D219948CCDF7C0C5');
// $this->addSql('DROP TABLE orders');
// $this->addSql('DROP TABLE orders_detail');
// $this->addSql('DROP TABLE orders_material');
// $this->addSql('DROP TABLE orders_other_fee');
// $this->addSql('DROP TABLE orders_send_request');
// $this->addSql('DROP TABLE post');
// $this->addSql('DROP TABLE shipping');
// $this->addSql('DROP TABLE status_history');
// $this->addSql('DROP TABLE status_orders');
// $this->addSql('DROP TABLE supply');
// $this->addSql('ALTER TABLE delivery CHANGE id id INT NOT NULL');
// $this->addSql('ALTER TABLE delivery_type CHANGE id id INT NOT NULL');
// $this->addSql('ALTER TABLE type CHANGE id id INT NOT NULL');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('CREATE TABLE orders (id INT AUTO_INCREMENT NOT NULL, partner_id INT DEFAULT NULL, type_id INT DEFAULT NULL, user_id INT DEFAULT NULL, no VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, src VARCHAR(100) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, create_date DATETIME NOT NULL, update_date DATETIME DEFAULT NULL, delete_date DATETIME DEFAULT NULL, sender_name VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, sender_zip VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, sender_addr VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, sender_tel VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, sender_fax VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, sender_code VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, orderer_name VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, orderer_kana VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, orderer_zip VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, orderer_addr VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, orderer_tel VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, orderer_email VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, order_date DATETIME DEFAULT NULL, approval_date DATETIME DEFAULT NULL, shipping_date DATETIME DEFAULT NULL, memo VARCHAR(200) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, remarks LONGTEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, INDEX IDX_E52FFDEEC54C8C93 (type_id), INDEX IDX_E52FFDEE9393F8FE (partner_id), INDEX IDX_E52FFDEEA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = \'\' ');
$this->addSql('CREATE TABLE orders_detail (id INT AUTO_INCREMENT NOT NULL, orders_id INT DEFAULT NULL, shipping_id INT DEFAULT NULL, product_id INT DEFAULT NULL, no VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, create_date DATETIME NOT NULL, update_date DATETIME DEFAULT NULL, delete_date DATETIME DEFAULT NULL, name VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, price VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, qty INT DEFAULT NULL, INDEX IDX_8F9646424887F3F8 (shipping_id), INDEX IDX_8F964642CFFE9AD6 (orders_id), INDEX IDX_8F9646424584665A (product_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = \'\' ');
$this->addSql('CREATE TABLE orders_material (id INT AUTO_INCREMENT NOT NULL, material_id INT DEFAULT NULL, orders_detail_id INT DEFAULT NULL, no VARCHAR(100) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, name VARCHAR(255) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, price VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, qty INT DEFAULT NULL, class_pot VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, class_h VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, class_c VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, class_w VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, class_l VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, class_medate VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, create_date DATETIME DEFAULT NULL, update_date DATETIME DEFAULT NULL, delete_date DATETIME DEFAULT NULL, unit VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, INDEX IDX_BB98A853AA1042E3 (orders_detail_id), INDEX IDX_BB98A853E308AC6F (material_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = \'\' ');
$this->addSql('CREATE TABLE orders_other_fee (id INT AUTO_INCREMENT NOT NULL, orders_id INT DEFAULT NULL, shipping_id INT DEFAULT NULL, name VARCHAR(100) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, price INT NOT NULL, entity VARCHAR(100) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, enabled TINYINT(1) NOT NULL, create_date DATETIME NOT NULL, update_date DATETIME DEFAULT NULL, delete_date DATETIME DEFAULT NULL, ordersDetail_id INT DEFAULT NULL, INDEX IDX_A61D097ECFFE9AD6 (orders_id), INDEX IDX_A61D097EB3C719BE (ordersDetail_id), INDEX IDX_A61D097E4887F3F8 (shipping_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = \'\' ');
$this->addSql('CREATE TABLE orders_send_request (id INT AUTO_INCREMENT NOT NULL, orders_id INT DEFAULT NULL, shipping_id INT DEFAULT NULL, supplier_id INT DEFAULT NULL, pdf_filename VARCHAR(100) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, create_date DATETIME NOT NULL, delete_date DATETIME DEFAULT NULL, print_date DATETIME DEFAULT NULL, tracking_no VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, shipping_date DATETIME DEFAULT NULL, delivery_date DATETIME DEFAULT NULL, INDEX IDX_FD77397FCFFE9AD6 (orders_id), INDEX IDX_FD77397F2ADD6D8C (supplier_id), INDEX IDX_FD77397F4887F3F8 (shipping_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = \'\' ');
$this->addSql('CREATE TABLE post (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(100) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, content LONGTEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, delete_date DATETIME DEFAULT NULL, create_date DATETIME NOT NULL, update_date DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = \'\' ');
$this->addSql('CREATE TABLE shipping (id INT AUTO_INCREMENT NOT NULL, orders_id INT DEFAULT NULL, delivery INT DEFAULT NULL, delivery_type INT DEFAULT NULL, no VARCHAR(100) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, create_date DATETIME NOT NULL, update_date DATETIME DEFAULT NULL, delete_date DATETIME DEFAULT NULL, name VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, kana VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, zip VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, addr VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, tel VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, delivery_date DATETIME DEFAULT NULL, INDEX IDX_2D1C17243781EC10 (delivery), INDEX IDX_2D1C1724CFFE9AD6 (orders_id), INDEX IDX_2D1C17245D429FB3 (delivery_type), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = \'\' ');
$this->addSql('CREATE TABLE status_history (id INT AUTO_INCREMENT NOT NULL, orders_id INT DEFAULT NULL, status_id INT DEFAULT NULL, user_id INT DEFAULT NULL, message LONGTEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, create_date DATETIME NOT NULL, delete_date DATETIME DEFAULT NULL, INDEX IDX_2F6A07CE6BF700BD (status_id), INDEX IDX_2F6A07CEA76ED395 (user_id), INDEX IDX_2F6A07CECFFE9AD6 (orders_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = \'\' ');
$this->addSql('CREATE TABLE status_orders (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(100) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, sort_no SMALLINT UNSIGNED DEFAULT NULL, path_name VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, color VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = \'\' ');
$this->addSql('CREATE TABLE supply (id INT AUTO_INCREMENT NOT NULL, orders_id INT DEFAULT NULL, shipping_id INT DEFAULT NULL, orders_detail_id INT DEFAULT NULL, product_id INT DEFAULT NULL, material_id INT DEFAULT NULL, supplier_id INT DEFAULT NULL, price VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, qty INT DEFAULT NULL, create_date DATETIME DEFAULT NULL, update_date DATETIME DEFAULT NULL, delete_date DATETIME DEFAULT NULL, Orders_material_id INT DEFAULT NULL, supplier_no INT DEFAULT NULL, supplier_name VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, supplier_short_name VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, supplier_zip VARCHAR(8) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, supplier_address VARCHAR(255) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, supplier_tel_no VARCHAR(14) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, supplier_fax_no VARCHAR(14) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, supplier_email VARCHAR(180) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, supplier_invoice INT DEFAULT NULL, INDEX IDX_D219948CCFFE9AD6 (orders_id), INDEX IDX_D219948CAA1042E3 (orders_detail_id), INDEX IDX_D219948CE308AC6F (material_id), INDEX IDX_D219948C90B178F5 (Orders_material_id), INDEX IDX_D219948C4887F3F8 (shipping_id), INDEX IDX_D219948C4584665A (product_id), INDEX IDX_D219948C2ADD6D8C (supplier_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = \'\' ');
$this->addSql('ALTER TABLE orders ADD CONSTRAINT FK_E52FFDEEC54C8C93 FOREIGN KEY (type_id) REFERENCES type (id)');
$this->addSql('ALTER TABLE orders ADD CONSTRAINT FK_E52FFDEE9393F8FE FOREIGN KEY (partner_id) REFERENCES partner (id)');
$this->addSql('ALTER TABLE orders ADD CONSTRAINT FK_E52FFDEEA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE orders_detail ADD CONSTRAINT FK_8F964642CFFE9AD6 FOREIGN KEY (orders_id) REFERENCES orders (id)');
$this->addSql('ALTER TABLE orders_detail ADD CONSTRAINT FK_8F9646424584665A FOREIGN KEY (product_id) REFERENCES product (id) ON DELETE SET NULL');
$this->addSql('ALTER TABLE orders_detail ADD CONSTRAINT FK_8F9646424887F3F8 FOREIGN KEY (shipping_id) REFERENCES shipping (id)');
$this->addSql('ALTER TABLE orders_material ADD CONSTRAINT FK_BB98A853AA1042E3 FOREIGN KEY (orders_detail_id) REFERENCES orders_detail (id)');
$this->addSql('ALTER TABLE orders_material ADD CONSTRAINT FK_BB98A853E308AC6F FOREIGN KEY (material_id) REFERENCES material (id) ON DELETE SET NULL');
$this->addSql('ALTER TABLE orders_other_fee ADD CONSTRAINT FK_A61D097E4887F3F8 FOREIGN KEY (shipping_id) REFERENCES shipping (id)');
$this->addSql('ALTER TABLE orders_other_fee ADD CONSTRAINT FK_A61D097EB3C719BE FOREIGN KEY (ordersDetail_id) REFERENCES orders_detail (id)');
$this->addSql('ALTER TABLE orders_other_fee ADD CONSTRAINT FK_A61D097ECFFE9AD6 FOREIGN KEY (orders_id) REFERENCES orders (id)');
$this->addSql('ALTER TABLE orders_send_request ADD CONSTRAINT FK_FD77397F2ADD6D8C FOREIGN KEY (supplier_id) REFERENCES partner (id)');
$this->addSql('ALTER TABLE orders_send_request ADD CONSTRAINT FK_FD77397F4887F3F8 FOREIGN KEY (shipping_id) REFERENCES shipping (id)');
$this->addSql('ALTER TABLE orders_send_request ADD CONSTRAINT FK_FD77397FCFFE9AD6 FOREIGN KEY (orders_id) REFERENCES orders (id)');
$this->addSql('ALTER TABLE shipping ADD CONSTRAINT FK_2D1C1724CFFE9AD6 FOREIGN KEY (orders_id) REFERENCES orders (id)');
$this->addSql('ALTER TABLE shipping ADD CONSTRAINT FK_2D1C17243781EC10 FOREIGN KEY (delivery) REFERENCES delivery (id)');
$this->addSql('ALTER TABLE shipping ADD CONSTRAINT FK_2D1C17245D429FB3 FOREIGN KEY (delivery_type) REFERENCES delivery_type (id)');
$this->addSql('ALTER TABLE status_history ADD CONSTRAINT FK_2F6A07CECFFE9AD6 FOREIGN KEY (orders_id) REFERENCES orders (id)');
$this->addSql('ALTER TABLE status_history ADD CONSTRAINT FK_2F6A07CE6BF700BD FOREIGN KEY (status_id) REFERENCES status_orders (id)');
$this->addSql('ALTER TABLE status_history ADD CONSTRAINT FK_2F6A07CEA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
$this->addSql('ALTER TABLE supply ADD CONSTRAINT FK_D219948C4887F3F8 FOREIGN KEY (shipping_id) REFERENCES shipping (id)');
$this->addSql('ALTER TABLE supply ADD CONSTRAINT FK_D219948CCFFE9AD6 FOREIGN KEY (orders_id) REFERENCES orders (id)');
$this->addSql('ALTER TABLE supply ADD CONSTRAINT FK_D219948C2ADD6D8C FOREIGN KEY (supplier_id) REFERENCES partner (id)');
$this->addSql('ALTER TABLE supply ADD CONSTRAINT FK_D219948CAA1042E3 FOREIGN KEY (orders_detail_id) REFERENCES orders_detail (id)');
$this->addSql('ALTER TABLE supply ADD CONSTRAINT FK_D219948CE308AC6F FOREIGN KEY (material_id) REFERENCES material (id) ON DELETE SET NULL');
$this->addSql('ALTER TABLE supply ADD CONSTRAINT FK_D219948C4584665A FOREIGN KEY (product_id) REFERENCES product (id) ON DELETE SET NULL');
$this->addSql('ALTER TABLE supply ADD CONSTRAINT FK_D219948CCDF7C0C5 FOREIGN KEY (Orders_material_id) REFERENCES orders_material (id)');
$this->addSql('ALTER TABLE order_item DROP FOREIGN KEY FK_52EA1F099393F8FE');
$this->addSql('ALTER TABLE order_item DROP FOREIGN KEY FK_52EA1F09C54C8C93');
$this->addSql('ALTER TABLE order_item DROP FOREIGN KEY FK_52EA1F09828F83CA');
$this->addSql('ALTER TABLE order_item DROP FOREIGN KEY FK_52EA1F09A76ED395');
$this->addSql('ALTER TABLE order_item DROP FOREIGN KEY FK_52EA1F09CAF9BFD2');
$this->addSql('ALTER TABLE order_item_detail DROP FOREIGN KEY FK_B34D75DAE415FB15');
$this->addSql('ALTER TABLE order_item_detail DROP FOREIGN KEY FK_B34D75DA4584665A');
$this->addSql('ALTER TABLE order_item_material DROP FOREIGN KEY FK_BDD0F58CCBE48CA3');
$this->addSql('ALTER TABLE order_item_material DROP FOREIGN KEY FK_BDD0F58CE415FB15');
$this->addSql('ALTER TABLE order_item_material DROP FOREIGN KEY FK_BDD0F58CE308AC6F');
$this->addSql('ALTER TABLE order_item_other DROP FOREIGN KEY FK_4025D3A5E415FB15');
$this->addSql('ALTER TABLE order_item_send_request DROP FOREIGN KEY FK_36E74D6BE415FB15');
$this->addSql('ALTER TABLE order_item_send_request DROP FOREIGN KEY FK_36E74D6BCAF9BFD2');
$this->addSql('ALTER TABLE order_item_send_request DROP FOREIGN KEY FK_36E74D6B2ADD6D8C');
$this->addSql('ALTER TABLE order_item_shipping DROP FOREIGN KEY FK_EC72973D3781EC10');
$this->addSql('ALTER TABLE order_item_shipping DROP FOREIGN KEY FK_EC72973D5D429FB3');
$this->addSql('ALTER TABLE order_item_shipping DROP FOREIGN KEY FK_EC72973DBE0850DF');
$this->addSql('ALTER TABLE order_item_shipping DROP FOREIGN KEY FK_EC72973DE415FB15');
$this->addSql('ALTER TABLE order_item_status_history DROP FOREIGN KEY FK_F1C19848E415FB15');
$this->addSql('ALTER TABLE order_item_status_history DROP FOREIGN KEY FK_F1C198486BF700BD');
$this->addSql('ALTER TABLE order_item_status_history DROP FOREIGN KEY FK_F1C19848A76ED395');
$this->addSql('ALTER TABLE order_item_supply DROP FOREIGN KEY FK_4F529EC5E415FB15');
$this->addSql('ALTER TABLE order_item_supply DROP FOREIGN KEY FK_4F529EC5CAF9BFD2');
$this->addSql('ALTER TABLE order_item_supply DROP FOREIGN KEY FK_4F529EC56176E045');
$this->addSql('ALTER TABLE order_item_supply DROP FOREIGN KEY FK_4F529EC52ADD6D8C');
$this->addSql('ALTER TABLE order_item_supply DROP FOREIGN KEY FK_4F529EC53781EC10');
$this->addSql('ALTER TABLE order_item_supply DROP FOREIGN KEY FK_4F529EC55D429FB3');
$this->addSql('ALTER TABLE order_item_supply DROP FOREIGN KEY FK_4F529EC5CBE48CA3');
// $this->addSql('DROP TABLE appropriate');
$this->addSql('DROP TABLE delivery_fee_check');
$this->addSql('DROP TABLE delivery_time');
$this->addSql('DROP TABLE order_item');
$this->addSql('DROP TABLE order_item_detail');
$this->addSql('DROP TABLE order_item_material');
$this->addSql('DROP TABLE order_item_other');
$this->addSql('DROP TABLE order_item_send_request');
$this->addSql('DROP TABLE order_item_shipping');
$this->addSql('DROP TABLE order_item_status_history');
$this->addSql('DROP TABLE order_item_supply');
$this->addSql('DROP TABLE status_order_item');
$this->addSql('ALTER TABLE delivery CHANGE id id INT AUTO_INCREMENT NOT NULL');
$this->addSql('ALTER TABLE delivery_type CHANGE id id INT AUTO_INCREMENT NOT NULL');
$this->addSql('ALTER TABLE type CHANGE id id INT AUTO_INCREMENT NOT NULL');
}
}

migrations/Version20221013005129.php line 1