MySQL and Comments for Columns - ddl-generation

[AxelM]

Hello,

i want set comments for each column in a table. Ok, if i have default values than i can add the comment like this "comment 'x'" for the column in the initial field after the default value.

but i have not everytime a default value.

For example, i want this from the generator:

CREATE TABLE foo
(
   X int COMMENT 'description',
);

and not this one:

CREATE TABLE foo
(
   X int DEFAULT COMMENT 'description'  //
);

i try to set the comment with a tagged value for a column, but this will not working.

what can i do?

Thanks Axel

[AxelM]

Hello,
this problem is solved.
In the Dialog "Genereate DDL" ComboBox "Comment Level" the defaultvalue is Table. The choice now is Column an will work now fine without hacks.


Now, i have an other problem with generating FK.

Example:

Table 1: (Stereotype <<Table>>)

id	int (Primarykey)
typeid	int (Foreignkey)

Table 2: (Stereotype <<Table>>)

id	int (Primarykey) is Foreignkey for Table 1

The Output sql for table 1 is wrong for mySql:

Code: [Select]


DROP TABLE IF EXISTS foo ;
CREATE TABLE foo
(

id INTEGER NOT NULL AUTO_INCREMENT COMMENT 'ID',

typeid INTEGER NOT NULL COMMENT 'Typeid',

PRIMARY KEY (id),

KEY (typeid) // this one will NOT work
)  ;


ALTER TABLE foo ADD CONSTRAINT FK_typeid

FOREIGN KEY (typeid) REFERENCES footpye (id) ;

O.k. I thing i must change the Transformationtemplate for DDL. It sems that i work on the false template, because i can change everything, delete for example completly the classtemplate  and  i will get the same output or it has no effect. It's happen also i restart EA.

My Question is now:

Where and what for a template must i change,so it produce this output:

Code: [Select]


CREATE TABLE foo
(

id INTEGER NOT NULL AUTO_INCREMENT COMMENT 'ID',

typeid INTEGER NOT NULL COMMENT 'Typeid',

PRIMARY KEY (id),

FOREIGN KEY (typeid) REFERENCES footpye (id) ; // so is it ok
)  ;


Thanks for any idea.