omega-make/Template/Sql/dbTable.sql

<<ym-item:databaseTable>>
DROP TABLE IF EXISTS <<tableName>>;
CREATE table <<tableName>>(
<<ym-loop:databaseField>>
<<fieldName>> <<fieldType>><<ym-if:!isEmpty(<<fieldLength>>)>>(<<fieldLength>>)<</ym-if>><<ym-if:<<notNull>>="1">> not null<</ym-if>><<ym-if:<<autoIncrement>>="1">> AUTO_INCREMENT<</ym-if>><<ym-if:!isEmpty(<<fieldDefaultValue>>)>> default <<fieldDefaultValue>><</ym-if>> COMMENT <<fieldTitle>><<fieldDetail>>,
<</ym-loop:databaseField>>
PRIMARY KEY(
<<ym-loop:databaseField removeEnd=",">>
<<fieldName>>,
<</ym-loop:databaseField>>
)
) COMMENT '<<tableTitle>>' ENGINE=InnoDB DEFAULT charset=utf8mb4 COLLATE utf8mb4_general_ci;
<</ym-item:databaseTable>>