Fix foreign key comparison case sensitive

drawdb-io / drawdb

Free, simple, and intuitive online database diagram editor and SQL generator.

https://drawdb.app

GNU Affero General Public License v3.0

22.7k stars 1.58k forks source link

Fix foreign key comparison case sensitive #282

Closed ruizhiii closed 3 weeks ago

ruizhiii commented 3 weeks ago

SQL keywords are case insensitive although they are often written in all caps. Object return from node-sql-parser is actually case sensitive based on the imported sql, thus "foreign key" doesn't work as expected.

Fix #276

vercel[bot] commented 3 weeks ago

@bitlab-ruizhi is attempting to deploy a commit to the dottle's projects Team on Vercel.

A member of the Team first needs to authorize it.

ruizhiii commented 3 weeks ago

No worries, below are all fixed

mariadb
mssql
mysql
postgres
sqlite

vercel[bot] commented 3 weeks ago

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
drawdb	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Oct 27, 2024 1:44pm

1ilit commented 3 weeks ago

Perfect, thank you!