qimall/console/migrations/M20240507155532AddSystemMenu.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Class M20240507155532AddSystemMenu
 */
class M20240507155532AddSystemMenu extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            $sql = <<<SQL
            INSERT INTO `qimall_menu` (`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (675519, '系统管理', 'backend', 1, '', 0, 0, '', 'el-icon-s-operation', 1, 0, 999, '[]', 'tr_0', 1, 1715069718, 1715069718);
            INSERT INTO `qimall_menu` (`id`, `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`) VALUES (675520, '过期提醒', 'backend', 1, '', 0, 675519, '', '', 1, 0, 999, 'null', '', 1, 1715069718, 1715069718);
SQL;
            $this->execute($sql);
        } catch (\Exception $e) {

        }
    }

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

        return false;
    }
}