CREATE code wrong

Tadas's profile image Tadas posted 7 years ago in General Permalink

I notice that Table Basic tab doesn't show properly column default value, if it's now() (MariaDB). And therefore it generates wrong code in "CREATE code" tab. That's why I have two suggestions:

  1. try to implement now() or similar default column values in columns editor form;
  2. because it always could be some unsupported by HeidiSQL (yet) new keywords, could you please output in "CREATE code" the output from server command "show create table ..." (which is absolutely correct) in case there no modifications were done from form; and in case when table structure created or modified interactively by clicking form elements - leave the current way of "CREATE code" forming.

Please login to leave a reply, or register at first.