mirror of
https://gitee.com/ShopeX/ECShopX
synced 2026-08-05 11:45:51 +08:00
44 lines
2.5 KiB
PHP
44 lines
2.5 KiB
PHP
<?php
|
|
|
|
namespace Database\Migrations;
|
|
|
|
use Doctrine\Migrations\AbstractMigration;
|
|
use Doctrine\DBAL\Schema\Schema as Schema;
|
|
|
|
class Version00000000000003 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\'.');
|
|
|
|
$this->addSql('CREATE TABLE distribution_distributor_sales_count (id BIGINT AUTO_INCREMENT NOT NULL, company_id BIGINT NOT NULL COMMENT \'公司id\', distributor_id BIGINT NOT NULL COMMENT \'店铺id\', order_item_count BIGINT DEFAULT 0 NOT NULL COMMENT \'已经关闭售后的订单的商品数量\', aftersales_item_count BIGINT DEFAULT 0 NOT NULL COMMENT \'已经关闭售后的订单的商品数量\', year_month_time BIGINT NOT NULL COMMENT \'统计的年月时间\', INDEX ix_company_id_distributor_id_time (company_id, distributor_id, year_month_time), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = \'店铺销量表\' ');
|
|
$this->addSql('DROP INDEX idx_card_no ON adapay_corp_member');
|
|
$this->addSql('CREATE INDEX idx_card_no ON adapay_corp_member (card_no(64))');
|
|
$this->addSql('DROP INDEX idx_user_name ON adapay_member');
|
|
$this->addSql('DROP INDEX idx_cert_id ON adapay_member');
|
|
$this->addSql('DROP INDEX idx_tel_no ON adapay_member');
|
|
$this->addSql('CREATE INDEX idx_user_name ON adapay_member (user_name(64))');
|
|
$this->addSql('CREATE INDEX idx_cert_id ON adapay_member (cert_id(64))');
|
|
$this->addSql('CREATE INDEX idx_tel_no ON adapay_member (tel_no(64))');
|
|
$this->addSql('DROP INDEX idx_card_id ON adapay_settle_account');
|
|
$this->addSql('DROP INDEX idx_cert_id ON adapay_settle_account');
|
|
$this->addSql('CREATE INDEX idx_card_id ON adapay_settle_account (card_id(64))');
|
|
$this->addSql('CREATE INDEX idx_cert_id ON adapay_settle_account (cert_id(64))');
|
|
$this->addSql('ALTER TABLE items DROP item_en_name');
|
|
$this->addSql('DROP INDEX idx_mobile ON members');
|
|
$this->addSql('CREATE INDEX idx_mobile ON members (mobile(64))');
|
|
$this->addSql('DROP INDEX idx_mobile ON members_whitelist');
|
|
$this->addSql('CREATE INDEX idx_mobile ON members_whitelist (mobile(64))');
|
|
}
|
|
|
|
/**
|
|
* @param Schema $schema
|
|
*/
|
|
public function down(Schema $schema): void
|
|
{
|
|
}
|
|
}
|