Issues with MySQL code generation

[yorweb]

I am just coming to the end of the 30 day trial period of EA (I'm using the professional version) and I'm 50/50 whether to purchase or not. I am looking for a single tool to design databases that utilise the MySQL engine  and while EA has a number of advantages, other aspects I find a bit disappointing.

1. After drawing an ERD with all the Foreign Keys, it does not then specify the tables should InnoDB.

2. There's no way to specify the length of integers. Unfortunately I am a right awkward bugger because I like to work at int(10).

3. Also with integers, I have found no way of specifying them as unsigned.

OK I can then do the above manually but I know that anyhow and surely really defeats the purpose of having software like your's in the first place.

Cheers

Tim

[thomaskilian]

1. You need to define a Tag "Type" with value "InnoDB" for the table
Not sure about the rest. Sparx?

[hd]

2. There's no way to specify the length of integers. Unfortunately I am a right awkward bugger because I like to work at int(10).

Add a new MySQL datatype...

INT - and give it length 10.

3. Also with integers, I have found no way of specifying them as unsigned.

Add a new MySQL datatype...

UNSIGNED INTEGER

You can do this from Settings | Database Datatypes...

HTH...

Henk

[yorweb]

1. You need to define a Tag "Type" with value "InnoDB" for the table
Not sure about the rest. Sparx?

Oh.. like it. Do you have to set this tag for each table or can you set it once and just call it?

Cheers

Tim

[yorweb]

Add a new MySQL datatype...

INT - and give it length 10.

Add a new MySQL datatype...

UNSIGNED INTEGER

You can do this from Settings | Database Datatypes...

HTH...

Henk

Ah.. yes excellent, just what I needed.  Are these settings inbuilt or can they be imported and exported? For example if 3 people were working on the same project specs.

Cheers

Tim

[hd]

You can export/import datatypes as follows...

Tools | Export Reference Data...

and select "Model Data Types - Code and DDL".

[yorweb]

Add a new MySQL datatype...

UNSIGNED INTEGER

You can do this from Settings | Database Datatypes...

HTH...

Henk

Just a note but I think you have to specify the data type first before what attributes it has.

I simply added the type: INT(10) UNSIGNED

However many thanks for your assistence. Think I might just buy it.  

Cheers

Tim

[thomaskilian]

Oh.. like it. Do you have to set this tag for each table or can you set it once and just call it?

Cheers
 
Tim

I create my tables with a transformation. So I put it right in the template. I don't know of any other way to default this Tag for table creations.