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