qimall/console/migrations/M240429010746QimallAiTool.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Class M240429010746QimallAiTool
 */
class M240429010746QimallAiTool extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $table = 'qimall_ai_tool';
        $sql="select * from information_schema.TABLES where TABLE_NAME = '{$table}';";
        $res = $this->db->createCommand($sql)->execute();
        if(!empty($res)) return '';
        $sql="CREATE TABLE `qimall_ai_tool` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(20) NOT NULL DEFAULT '' COMMENT '中文名',
  `url` varchar(500) DEFAULT NULL COMMENT '跳转链接',
  `cover` varchar(255) DEFAULT '' COMMENT 'logo',
  `is_docking` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否对接：1：是；0：否',
  `brief_introduction` varchar(255) NOT NULL DEFAULT '' COMMENT '介绍',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用;]',
  `created_at` int(10) unsigned DEFAULT '0' COMMENT '创建时间',
  `updated_at` int(10) unsigned DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='ai工具表';";
        $this->execute($sql);
        $sql="
        INSERT INTO `qimall_ai_tool` ( `title`, `url`, `cover`, `is_docking`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ( '豆包', 'https://www.doubao.com/chat', '/static/addons/icon/aiTool/doubao.png', 0, '豆包“豆包”是基于抖音云雀模...', 1, 0, 0);
INSERT INTO `qimall_ai_tool` ( `title`, `url`, `cover`, `is_docking`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ( '文心一言', 'https://yiyan.baidu.com', '/static/addons/icon/aiTool/wenxinyiyan.png', 0, '百度全新一代知识增强大语言模型', 1, 0, 0);
INSERT INTO `qimall_ai_tool` ( `title`, `url`, `cover`, `is_docking`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ( 'kimi', 'https://kimi.moonshot.cn', '/static/addons/icon/aiTool/kimi.png', 0, '支持长达20万字的上下文处理，Kimi Chat官网入口网址', 1, 0, 0);
INSERT INTO `qimall_ai_tool` ( `title`, `url`, `cover`, `is_docking`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ( '通义千问', 'https://tongyi.aliyun.com/qianwen', '/static/addons/icon/aiTool/tongyiqianwen.png', 0, '阿里巴巴旗下的一款智能问答机器人，它利用自然语言处理技术，为用户提供智能化的语音交互服务，通义千问官网入口网址。', 1, 0, 0);
INSERT INTO `qimall_ai_tool` ( `title`, `url`, `cover`, `is_docking`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ( '通义万相', 'https://tongyi.aliyun.com/wanxiang', '/static/addons/icon/aiTool/tongyiwangxaing.png', 0, '阿里最新推出的AI绘画创作模型', 1, 0, 0);
INSERT INTO `qimall_ai_tool` ( `title`, `url`, `cover`, `is_docking`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ( '创客贴', 'https://www.chuangkit.com', '/static/addons/icon/aiTool/chaungketie.png', 0, '创客贴是一款多平台（Web、Mobile、Mac 、Windows）图形编辑和平面设计工具', 1, 0, 0);
INSERT INTO `qimall_ai_tool` ( `title`, `url`, `cover`, `is_docking`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ( '百川大模型', 'https://www.baichuan-ai.com/home', '/static/addons/icon/aiTool/baichuang.png', 0, '百川大模型宣布开放公众服务 ...', 1, 0, 0);
INSERT INTO `qimall_ai_tool` ( `title`, `url`, `cover`, `is_docking`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ( '文心一格', 'https://yige.baidu.com', '/static/addons/icon/aiTool/wenxinyige.png', 0, '百度出品的AI绘画网站文心一格', 1, 0, 0);
INSERT INTO `qimall_ai_tool` ( `title`, `url`, `cover`, `is_docking`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ( '讯飞星火', 'https://xinghuo.xfyun.cn', '/static/addons/icon/aiTool/xunfeixinghuo.png', 0, '讯飞星火大模型官网入口网址...', 1, 0, 0);
INSERT INTO `qimall_ai_tool` ( `title`, `url`, `cover`, `is_docking`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ( '天工AI', 'https://www.tiangong.cn', '/static/addons/icon/aiTool/tiangeai.png', 0, '昆仑万维与奇点智源联合研发', 1, 0, 0);
INSERT INTO `qimall_ai_tool` ( `title`, `url`, `cover`, `is_docking`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ( '美图AI', 'https://www.x-design.com', '/static/addons/icon/aiTool/meituai.png', 0, '美图推出的AI文本生成图片的工具', 1, 0, 0);
INSERT INTO `qimall_ai_tool` ( `title`, `url`, `cover`, `is_docking`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ( 'AI改图', 'https://img.logosc.cn', '/static/addons/icon/aiTool/aigaitu.png', 0, '万能图片在线编辑器；AI,EPS,PSD,SVG全格式支持。一键修改照片颜色大小尺寸，自定义尺寸图片裁剪，智能抠图添加水印文字...', 1, 0, 0);
INSERT INTO `qimall_ai_tool` ( `title`, `url`, `cover`, `is_docking`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ( '网易AI创意工坊', 'https://sd.study.163.com/artWorks/painting', '/static/addons/icon/aiTool/wangyiaichuangyi.png', 0, '网易云课堂推出的AI作画平台，在线使用Stable Diffusion出图', 1, 0, 0);
INSERT INTO `qimall_ai_tool` ( `title`, `url`, `cover`, `is_docking`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ( 'AI模特', 'https://mote.openi.cn/#/dashboard/index', '/static/addons/icon/aiTool/aimote.png', 0, '专业的电商服装商拍AI，无需模特拍摄，降低拍摄时间，缩短上架时间，AI模特，电商商拍官网入口地址', 1, 0, 0);
INSERT INTO `qimall_ai_tool` ( `title`, `url`, `cover`, `is_docking`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ( '智谱清言', 'https://chatglm.cn', '/static/addons/icon/aiTool/zhipuqingyan.png', 0, '智谱清言 ChatGLM官网入口网...', 1, 0, 0);
INSERT INTO `qimall_ai_tool` ( `title`, `url`, `cover`, `is_docking`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ( '360智绘', 'https://aigc.360.com', '/static/addons/icon/aiTool/360zhihui.png', 0, '360公司研发的AI绘画工具', 1, 0, 0);
INSERT INTO `qimall_ai_tool` ( `title`, `url`, `cover`, `is_docking`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ( '腾讯混元助手', 'https://hunyuan.tencent.com', '/static/addons/icon/aiTool/texunhunyuan.png', 0, '基于腾讯新发布的混元大模型开发的应用', 1, 0, 0);
INSERT INTO `qimall_ai_tool` ( `title`, `url`, `cover`, `is_docking`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ( '美图miraclevision', 'https://www.miraclevision.com', '/static/addons/icon/aiTool/miraclevision.png', 0, '美图自研的一款懂美学的AI视觉大模型', 1, 0, 0);
INSERT INTO `qimall_ai_tool` ( `title`, `url`, `cover`, `is_docking`, `brief_introduction`, `status`, `created_at`, `updated_at`) VALUES ( '源沅财管', 'http://www.gzyycg.com/Content/2753708.html', '/static/addons/icon/aiTool/yuanyuancaiguan.png', 0, '专业为各类企业提供财税业务、工商业务、审计业务、财税咨询、商标注册等等业务', 1, 0, 0);
        ";
        $this->execute($sql);

    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}