| View previous topic :: View next topic |
| Author |
Message |
ykrylov
Joined: 06 Dec 2004
Posts: 1
|
|
Posted: Wed Dec 08, 2004 7:01 pm Post subject: Diagram to MySQL sql schemas
|
|
|
Hi,
I noticed that:
1) checking the auto_increment toggle in the table view will not be reflected in the sql schema that is generated from the diagrams via the wizard
2) there is not support for extra type modifiers such as "unsigned" typically used with primary keys
am I missing something? Thank you for your time and attention!
_________________
Best Regards,
Yuriy Krylov
|
|
| Back to top |
|
|
xavier
Site Admin
Joined: 14 Mar 2003
Posts: 81
|
|
Posted: Fri Dec 10, 2004 9:18 am Post subject:
|
|
|
Hi,
1 - Take a look in the documentation about the templates structure.
1.1 - In the MySQL db.props file you will see the JDBC SQL Types to MySQL SQL Types mapping. There is something about the Autoincrement.
1.2 - In the columns.vm template you could see that you need to set your Table IdMethod to native if you want to have a generated Autoincrement
2 - You can't set an unsigned attribute to a numeric MySQL column.
To do so, you need to manually patch your generated SQL script or you can set the db.props file.
For example for MySQL :
INTEGER = INTEGER UNSIGNED ZEROFILL
This setting will affect all the defined Integer.
Regards.
|
|
| Back to top |
|
|
|
|