qimall/addons/ReservationService/console/migrations/M240926081348AlterQimallAddonsReservationServiceOrder.php

<?php

namespace addons\ReservationService\console\migrations;

use yii\db\Migration;

/**
 * Class M240926081348AlterQimallAddonsReservationServiceOrder
 */
class M240926081348AlterQimallAddonsReservationServiceOrder extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = "
                alter table qimall_addons_reservation_service_order add server_status tinyint(1) not null default 0 comment'1:已预约；2：已到店；3：待验收；4：已完成；5：已取消';
                alter table qimall_addons_reservation_service_order add at_store_time int(11) not null default 0 comment'预约到店时间';
                alter table qimall_addons_reservation_service_order add service_type int(1) not null default 0 comment'预约服务类型:1:上门；2：到店';
                alter table qimall_addons_reservation_service_order add create_type int(1) not null default 1 comment'创建方式:1:线上下单；2：系统创建';
                alter table qimall_addons_reservation_service_order add goods_reserve_sku_id int(11) not null default 0 comment'服务sku_id';
                alter table qimall_addons_store_order_reserve add create_type int(1) not null default 1 comment'创建方式:1:线上下单；2：系统创建';

";
        $this->execute($sql);

    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}