enterprise architect 12生成DDL问题

enterprise architect 12设计mysql数据库

如果表中有datetime字段的话,它默认的长度会给个0,去也去不掉

这样生成DDL会出现 DATETIME(0)

解决办法是修改DDL模板

在右边替换下面的模板代码,保存即可

%PI=""% $Type = %columnProperty:"TYPE"% $DBMS = %ddlTableDBMS% $Size = %DDL_DATATYPE_SIZE($DBMS, $Type)% $LENGTH = %columnProperty:"LENGTH"% $Type %if $Size=="1" and $LENGTH != "0" and $LENGTH != ""% ( $LENGTH ) %elseIf $Size=="2"% ( %if columnProperty:"PRECISION"==""% 0 %else% %columnProperty:"PRECISION"% %endIf% %if columnProperty:"SCALE" != ""% ,%columnProperty:"SCALE"% %endIf% ) %endIf%