| 12345678910111213 |
- <<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>>
|
