dbml icon indicating copy to clipboard operation
dbml copied to clipboard

Comments exported to MySQL using wrong quote type

Open djpeach opened this issue 4 years ago • 1 comments

The table definition:

Table Account {
  ID "int unsigned" [pk, increment, not null]
  
  Username varchar(255) [not null]
  Password varchar [not null]
  
  Note: 'The necessary details to identify and authenticate users'
}

The exported comment syntax: ALTER TABLE `Account` COMMENT = "The necessary details to identify and authenticate users";

Notice the double quotes on the comment string. MySQL expects single quotes.

djpeach avatar Sep 22 '21 21:09 djpeach

I also noticed the wrong quote type is used for default enums:

`Status` ENUM ('Processing', 'Shipped', 'Delivered', 'Cancelled') NOT NULL DEFAULT "Processing";

djpeach avatar Sep 24 '21 01:09 djpeach