I love this software but I encountered an annoying bug and figured I should report it. I created a somewhat basic MySQL relational database which contains three tables which have only two foreign keys each, artist_groups, group_songs, and artist_songs
next I exported the SQL script
now all three of these tables should not contain any primary key,. but only two columns that are foreign keys, but there are lines of code which reference a primary key in only two of these tables at lines 100 and 118. The lines are also bad syntax and throwing errors shown below in SQL workbench
however when I delete those lines the errors go away and my SQL code executes
anyway I just thought that is was odd that it seemed to be attempting to put primary keys on two of my tables, artist_songs, and artist_groups, but not on the third table, group_songs. none of those tables contain primary keys, only two foreign keys.
Customer support service by UserEcho