search

dineug / vuerd-vscode

ERD Editor vscode extension
https://marketplace.visualstudio.com/items?itemName=dineug.vuerd-vscode
MIT License
115 stars 14 forks source link

MySQL/MariaSQL Query Generation #107

Open xyco1210 opened 3 years ago

xyco1210 commented 3 years ago

Hi, there is an issue with the genreated SQL Queries for Foreign Keys. On Mysql and MariaSQL the constrain can only be created when both columns have an index. The index is not created, so all constrains which are not PrimaryForeignKeys won't work.

dineug commented 3 years ago

If you give me the wrong example data you mentioned, it will be very helpful to solve the problem.