<?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 Version20250107233906 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('ALTER TABLE dtb_base_info ADD invoice_registration_number VARCHAR(255) DEFAULT NULL, ADD option_mail_notifier TINYINT(1) DEFAULT 0 NOT NULL');
$this->addSql('ALTER TABLE dtb_cart CHANGE total_price total_price NUMERIC(12, 2) UNSIGNED DEFAULT \'0\' NOT NULL, CHANGE delivery_fee_total delivery_fee_total NUMERIC(12, 2) UNSIGNED DEFAULT \'0\' NOT NULL');
$this->addSql('ALTER TABLE dtb_cart_item CHANGE price price NUMERIC(12, 2) DEFAULT \'0\' NOT NULL');
$this->addSql('ALTER TABLE dtb_customer DROP plg_mailmagazine_flg, CHANGE buy_total buy_total NUMERIC(12, 2) UNSIGNED DEFAULT \'0\'');
$this->addSql('ALTER TABLE dtb_delivery_duration CHANGE duration duration SMALLINT DEFAULT 0 NOT NULL');
$this->addSql('ALTER TABLE dtb_member ADD two_factor_auth_key VARCHAR(255) DEFAULT NULL, ADD two_factor_auth_enabled TINYINT(1) DEFAULT 0 NOT NULL');
$this->addSql('ALTER TABLE dtb_order CHANGE subtotal subtotal NUMERIC(12, 2) UNSIGNED DEFAULT \'0\' NOT NULL, CHANGE discount discount NUMERIC(12, 2) UNSIGNED DEFAULT \'0\' NOT NULL, CHANGE delivery_fee_total delivery_fee_total NUMERIC(12, 2) UNSIGNED DEFAULT \'0\' NOT NULL, CHANGE charge charge NUMERIC(12, 2) UNSIGNED DEFAULT \'0\' NOT NULL, CHANGE tax tax NUMERIC(12, 2) UNSIGNED DEFAULT \'0\' NOT NULL, CHANGE total total NUMERIC(12, 2) UNSIGNED DEFAULT \'0\' NOT NULL, CHANGE payment_total payment_total NUMERIC(12, 2) UNSIGNED DEFAULT \'0\' NOT NULL');
$this->addSql('ALTER TABLE dtb_order_item CHANGE price price NUMERIC(12, 2) DEFAULT \'0\' NOT NULL');
$this->addSql('ALTER TABLE dtb_payment CHANGE charge charge NUMERIC(12, 2) UNSIGNED DEFAULT \'0\'');
$this->addSql('ALTER TABLE dtb_product CHANGE note note LONGTEXT DEFAULT NULL, CHANGE description_list description_list LONGTEXT DEFAULT NULL, CHANGE description_detail description_detail LONGTEXT DEFAULT NULL, CHANGE search_word search_word LONGTEXT DEFAULT NULL');
$this->addSql('ALTER TABLE dtb_tax_rule CHANGE tax_rate tax_rate NUMERIC(10, 0) UNSIGNED DEFAULT \'0\' NOT NULL');
$this->addSql('ALTER TABLE plg_coupon CHANGE discount_price discount_price NUMERIC(12, 2) UNSIGNED DEFAULT \'0\', CHANGE coupon_lower_limit coupon_lower_limit NUMERIC(12, 2) UNSIGNED DEFAULT \'0\'');
$this->addSql('ALTER TABLE plg_coupon_order CHANGE discount discount NUMERIC(12, 2) UNSIGNED DEFAULT \'0\' NOT NULL');
$this->addSql('ALTER TABLE plg_mailmaga_send_history CHANGE start_date start_date DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetimetz)\', CHANGE end_date end_date DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetimetz)\', CHANGE create_date create_date DATETIME NOT NULL COMMENT \'(DC2Type:datetimetz)\', CHANGE update_date update_date DATETIME NOT NULL COMMENT \'(DC2Type:datetimetz)\'');
$this->addSql('ALTER TABLE plg_mailmaga_template CHANGE html_body html_body LONGTEXT DEFAULT NULL, CHANGE create_date create_date DATETIME NOT NULL COMMENT \'(DC2Type:datetimetz)\', CHANGE update_date update_date DATETIME NOT NULL COMMENT \'(DC2Type:datetimetz)\'');
$this->addSql('ALTER TABLE plg_product_review DROP reply');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE plg_mailmaga_template CHANGE html_body html_body LONGTEXT NOT NULL, CHANGE create_date create_date DATETIME NOT NULL COMMENT \'(DC2Type:datetime)\', CHANGE update_date update_date DATETIME NOT NULL COMMENT \'(DC2Type:datetime)\'');
$this->addSql('ALTER TABLE dtb_order_item CHANGE price price NUMERIC(12, 2) DEFAULT \'0.00\' NOT NULL');
$this->addSql('ALTER TABLE dtb_order CHANGE subtotal subtotal NUMERIC(12, 2) UNSIGNED DEFAULT \'0.00\' NOT NULL, CHANGE discount discount NUMERIC(12, 2) UNSIGNED DEFAULT \'0.00\' NOT NULL, CHANGE delivery_fee_total delivery_fee_total NUMERIC(12, 2) UNSIGNED DEFAULT \'0.00\' NOT NULL, CHANGE charge charge NUMERIC(12, 2) UNSIGNED DEFAULT \'0.00\' NOT NULL, CHANGE tax tax NUMERIC(12, 2) UNSIGNED DEFAULT \'0.00\' NOT NULL, CHANGE total total NUMERIC(12, 2) UNSIGNED DEFAULT \'0.00\' NOT NULL, CHANGE payment_total payment_total NUMERIC(12, 2) UNSIGNED DEFAULT \'0.00\' NOT NULL');
$this->addSql('ALTER TABLE dtb_delivery_duration CHANGE duration duration SMALLINT UNSIGNED DEFAULT 0 NOT NULL');
$this->addSql('ALTER TABLE dtb_member DROP two_factor_auth_key, DROP two_factor_auth_enabled');
$this->addSql('ALTER TABLE plg_coupon_order CHANGE discount discount NUMERIC(12, 2) UNSIGNED DEFAULT \'0.00\' NOT NULL');
$this->addSql('ALTER TABLE dtb_product CHANGE note note VARCHAR(4000) DEFAULT NULL, CHANGE description_list description_list VARCHAR(4000) DEFAULT NULL, CHANGE description_detail description_detail VARCHAR(4000) DEFAULT NULL, CHANGE search_word search_word VARCHAR(4000) DEFAULT NULL');
$this->addSql('ALTER TABLE dtb_base_info DROP invoice_registration_number, DROP option_mail_notifier');
$this->addSql('ALTER TABLE dtb_customer ADD plg_mailmagazine_flg SMALLINT UNSIGNED DEFAULT 0, CHANGE buy_total buy_total NUMERIC(12, 2) UNSIGNED DEFAULT \'0.00\'');
$this->addSql('ALTER TABLE dtb_cart_item CHANGE price price NUMERIC(12, 2) DEFAULT \'0.00\' NOT NULL');
$this->addSql('ALTER TABLE dtb_tax_rule CHANGE tax_rate tax_rate NUMERIC(10, 0) UNSIGNED DEFAULT \'8\' NOT NULL');
$this->addSql('ALTER TABLE plg_product_review ADD reply LONGTEXT DEFAULT NULL');
$this->addSql('ALTER TABLE dtb_cart CHANGE total_price total_price NUMERIC(12, 2) UNSIGNED DEFAULT \'0.00\' NOT NULL, CHANGE delivery_fee_total delivery_fee_total NUMERIC(12, 2) UNSIGNED DEFAULT \'0.00\' NOT NULL');
$this->addSql('ALTER TABLE plg_coupon CHANGE discount_price discount_price NUMERIC(12, 2) UNSIGNED DEFAULT \'0.00\', CHANGE coupon_lower_limit coupon_lower_limit NUMERIC(12, 2) UNSIGNED DEFAULT \'0.00\'');
$this->addSql('ALTER TABLE dtb_payment CHANGE charge charge NUMERIC(12, 2) UNSIGNED DEFAULT \'0.00\'');
$this->addSql('ALTER TABLE plg_mailmaga_send_history CHANGE start_date start_date DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime)\', CHANGE end_date end_date DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime)\', CHANGE create_date create_date DATETIME NOT NULL COMMENT \'(DC2Type:datetime)\', CHANGE update_date update_date DATETIME NOT NULL COMMENT \'(DC2Type:datetime)\'');
}
}