mirror of
https://gitee.com/ShopeX/ECShopX
synced 2026-08-03 10:56:16 +08:00
46 lines
1.7 KiB
PHP
46 lines
1.7 KiB
PHP
<?php declare(strict_types=1);
|
||
|
||
namespace Database\Migrations;
|
||
|
||
use Doctrine\DBAL\Schema\Schema;
|
||
use Doctrine\Migrations\AbstractMigration;
|
||
|
||
/**
|
||
* Migration: Add fp_salesperson and has_fp fields to members table
|
||
*
|
||
* 添加分配导购相关字段到会员表
|
||
* - fp_salesperson: 分配的导购ID
|
||
* - has_fp: 是否有分配导购（0:否，1:是）
|
||
*/
|
||
final class Version20250126120000 extends AbstractMigration
|
||
{
|
||
public function up(Schema $schema) : void
|
||
{
|
||
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
|
||
|
||
// Add fp_salesperson field (分配的导购ID)
|
||
$this->addSql('ALTER TABLE members ADD fp_salesperson INT DEFAULT 0 COMMENT \'分配的导购ID\'');
|
||
|
||
// Add has_fp field (是否有分配导购)
|
||
$this->addSql('ALTER TABLE members ADD has_fp TINYINT(1) DEFAULT 0 COMMENT \'是否有分配导购。0:否；1:是\'');
|
||
|
||
// Add index for better query performance
|
||
$this->addSql('CREATE INDEX idx_fp_salesperson ON members (fp_salesperson)');
|
||
$this->addSql('CREATE INDEX idx_has_fp ON members (has_fp)');
|
||
}
|
||
|
||
public function down(Schema $schema) : void
|
||
{
|
||
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
|
||
|
||
// Drop indexes
|
||
$this->addSql('DROP INDEX idx_fp_salesperson ON members');
|
||
$this->addSql('DROP INDEX idx_has_fp ON members');
|
||
|
||
// Drop columns
|
||
$this->addSql('ALTER TABLE members DROP fp_salesperson');
|
||
$this->addSql('ALTER TABLE members DROP has_fp');
|
||
}
|
||
}
|
||
|