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%