mirror of
https://gitee.com/ShopeX/ECShopX
synced 2026-08-05 19:55:51 +08:00
41 lines
1.6 KiB
PHP
41 lines
1.6 KiB
PHP
<?php
|
|
|
|
namespace Database\Migrations;
|
|
|
|
use Doctrine\Migrations\AbstractMigration;
|
|
use Doctrine\DBAL\Schema\Schema as Schema;
|
|
|
|
class Version20250826143000 extends AbstractMigration
|
|
{
|
|
/**
|
|
* @param Schema $schema
|
|
*/
|
|
public function up(Schema $schema): void
|
|
{
|
|
$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
|
|
|
|
// 添加运费使用的积分字段到 orders_normal_orders 表
|
|
$this->addSql('ALTER TABLE orders_normal_orders ADD COLUMN freight_point INT DEFAULT 0 COMMENT "运费使用的积分"');
|
|
|
|
// 添加运费使用的积分抵扣的金额字段到 orders_normal_orders 表
|
|
$this->addSql('ALTER TABLE orders_normal_orders ADD COLUMN freight_point_fee INT DEFAULT 0 COMMENT "运费使用的积分抵扣的金额，以分为单位"');
|
|
|
|
// // 为现有数据初始化新字段值
|
|
// $this->addSql('UPDATE orders_normal_orders SET freight_point = 0, freight_point_fee = point_fee - WHERE freight_point IS NULL OR freight_point_fee IS NULL');
|
|
}
|
|
|
|
/**
|
|
* @param Schema $schema
|
|
*/
|
|
public function down(Schema $schema): void
|
|
{
|
|
$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
|
|
|
|
// 删除运费使用的积分抵扣的金额字段
|
|
$this->addSql('ALTER TABLE orders_normal_orders DROP COLUMN freight_point_fee');
|
|
|
|
// 删除运费使用的积分字段
|
|
$this->addSql('ALTER TABLE orders_normal_orders DROP COLUMN freight_point');
|
|
}
|
|
}
|