[Bug] [api] The table UNIQUE INDEX is duplicated

[liu-hai]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

在将执行V1.1.0__DDL.sql 文件中的 DDL语句的时候发现建表语句的 UNIQUE INDEX 重复，如下图：

What you expected to happen

mysql8中去创建该表的时候会有警告产生

How to reproduce

有可能是数据库里面重复定义了 然后脚本里面的sql语句是从数据库直接导出生成导致的，需要重新导出替换

Anything else

No response

Version

dev

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[github-actions]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

When the DDL statement in the V1.1.0__DDL.sql file is executed, it is found that the UNIQUE INDEX of the table creation statement is repeated, as shown in the following figure:

What you expected to happen

There will be a warning when creating the table in mysql8

How to reproduce

It may be that the database is repeatedly defined, and the sql statement in the script is directly exported and generated from the database, which needs to be re-exported and replaced

Anything else

No response

Version

dev

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct