mirror of
https://gitee.com/ShopeX/ECShopX
synced 2026-08-04 19:26:23 +08:00
28 lines
1.2 KiB
PHP
28 lines
1.2 KiB
PHP
<?php
|
|
|
|
namespace Database\Migrations;
|
|
|
|
use Doctrine\Migrations\AbstractMigration;
|
|
use Doctrine\DBAL\Schema\Schema as Schema;
|
|
|
|
class Version00000000000046 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_white_list (id BIGINT AUTO_INCREMENT NOT NULL, distributor_id BIGINT DEFAULT 1 NOT NULL COMMENT \'店铺id\', company_id BIGINT NOT NULL COMMENT \'公司id\', mobile VARCHAR(50) NOT NULL COMMENT \'店铺手机号\', username VARCHAR(255) DEFAULT NULL COMMENT \'名称\', created bigint NOT NULL, updated bigint NOT NULL, INDEX ix_distributor_id (distributor_id), INDEX ix_mobile (mobile), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = \'店铺表\' ');
|
|
$this->addSql('ALTER TABLE distribution_distributor ADD open_divided BIGINT DEFAULT 0 NOT NULL COMMENT \'是否开启店铺隔离\'');
|
|
}
|
|
|
|
/**
|
|
* @param Schema $schema
|
|
*/
|
|
public function down(Schema $schema): void
|
|
{
|
|
}
|
|
}
|