qimall/addons/BusinessCard/console/migrations/M241217071505AlterQiamllAddonsBusinessCard.php

<?php

namespace addons\BusinessCard\console\migrations;

use yii\db\Migration;

/**
 * Class M241217071505AlterQiamllAddonsBusinessCard
 */
class M241217071505AlterQiamllAddonsBusinessCard extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $this->execute("ALTER TABLE `qimall_addons_business_card` 
        ADD COLUMN `sex` tinyint(1) NULL COMMENT '性别' AFTER `lng`,
        ADD COLUMN `zodiac` tinyint(1) NULL COMMENT '生肖' AFTER `sex`,
        ADD COLUMN `marry_status` tinyint(1) NULL COMMENT '结婚状态' AFTER `zodiac`,
        ADD COLUMN `active_city` varchar(255) NULL COMMENT '活跃城市' AFTER `marry_status`,
        ADD COLUMN `wechat_code` varchar(255) NULL COMMENT '微信二维码' AFTER `active_city`,
        ADD COLUMN `province_id` int(11) NULL COMMENT '省份id' AFTER `wechat_code`,
        ADD COLUMN `city_id` int(11) NULL COMMENT '城市id' AFTER `province_id`,
        ADD COLUMN `education_id` int(11) NULL COMMENT '最高学历' AFTER `city_id`;");
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}