Skip to content

efak-ai-5.0.0版本初始化数据库脚本优化 #729

@raohj1987

Description

@raohj1987

当前版本初始化数据库代码如下:

-- 创建数据库
CREATE DATABASE IF NOT EXISTS efak_ai;

-- 创建告警渠道表
CREATE TABLE `ke_alert_channels` (
...

INSERT INTO `ke_task_scheduler`
...

对于新手来说不太优化,如果不仔细看sql内容,直接拿脚本执行,大概率创建表会失败。建议改成如下的模式:

-- 创建数据库
CREATE DATABASE IF NOT EXISTS efak_ai;
use efak_ai;

-- 创建告警渠道表
CREATE TABLE if not exists efak_ai.`ke_alert_channels` (
...

INSERT INTO efak_ai.`ke_task_scheduler` (

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions