qimall/addons/Area/console/migrations/M240601072153CreateAreaRegional.php

<?php

namespace addons\Area\console\migrations;

use yii\db\Migration;

/**
 * Class M240601072153CreateAreaRegional
 */
class M240601072153CreateAreaRegional extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = <<<SQL
            CREATE TABLE `qimall_addons_area_regional`  (
              `id` int(11) NOT NULL AUTO_INCREMENT,
              `mall_id` int(11) NOT NULL COMMENT '所属商城ID',
              `regional_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '大区名称',
              `province_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '大区所辖省份id集合',
              `area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省份名称备份集合',
              `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态',
              `created_at` int(10) NOT NULL DEFAULT 0 COMMENT '创建时间',
              `updated_at` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间',
              PRIMARY KEY (`id`) USING BTREE,
              INDEX `mall_id`(`mall_id`, `status`) USING BTREE
            ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '区域管理->大区管理表' ROW_FORMAT = Dynamic;
            ALTER TABLE `qimall_addons_area_agent`
                ADD COLUMN `realname` varchar(64) NULL COMMENT '代理真实姓名' AFTER `user_id`,
                ADD COLUMN `mobile` varchar(64) NULL COMMENT '代理手机号码' AFTER `realname`,
                ADD COLUMN `regional_id` INT(11) NOT NULL DEFAULT '0' COMMENT '大区ID' AFTER `level`;
            ALTER TABLE `qimall_addons_area_apply` ADD COLUMN `regional_id` INT(11) NOT NULL DEFAULT '0' COMMENT '大区ID' AFTER `level`;
SQL;
        $this->execute($sql);
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        echo "M240601072153CreateAreaRegional cannot be reverted.\n";

        return false;
    }

    /*
    // Use up()/down() to run migration code without a transaction.
    public function up()
    {

    }

    public function down()
    {
        echo "M240601072153CreateAreaRegional cannot be reverted.\n";

        return false;
    }
    */
}