qimall/console/migrations/M230518115235CreateQimallSystemVersionSlb.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Class M230518115235CreateQimallSystemVersionSlb
 */
class M230518115235CreateQimallSystemVersionSlb extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            $sql = "
ALTER TABLE `qimall_system_version_log` ADD COLUMN `upgrade_params` longtext NULL COMMENT 'mq传输的参数' AFTER `upgrade_addons_version`;
CREATE TABLE `qimall_system_version_slb` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `version_id` int(10) DEFAULT '0' COMMENT '最新更新成功版本ID',
  `ip` varchar(32) DEFAULT '' COMMENT '服务器ip',
  `upgrade_status` tinyint(3) DEFAULT '0' COMMENT '更新状态[-1=更新失败，0=更新中，1=更新完成]',
  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态：0禁用，1正常',
  `created_at` int(11) NOT NULL DEFAULT '0',
  `updated_at` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `version_id+ip` (`version_id`,`ip`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='负载均衡更新记录表';
";
            $this->execute($sql);
        }catch (\Exception $e){

        }
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}