dbml
dbml copied to clipboard
Comments exported to MySQL using wrong quote type
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.
I also noticed the wrong quote type is used for default enums:
`Status` ENUM ('Processing', 'Shipped', 'Delivered', 'Cancelled') NOT NULL DEFAULT "Processing";