2 <#list tableList as table>
\r
3 <#list table.foreignKeyList as fk>ALTER TABLE ${table.name} DROP CONSTRAINT ${fk.name}
\r
7 <#list tableList as table>
\r
8 DROP TABLE ${table.name};
\r
12 <#list tableList as table>
\r
13 CREATE TABLE ${table.name} (
\r
14 <#list table.columnList as column> ${column.name} ${column.definition}<#if column.alias?? || column.note??> COMMENT '<#if column.alias??>${column.alias}:</#if><#if column.note??>${column.note}</#if>'</#if><#if column_has_next>,</#if>
\r
16 <#if !table.suppressCommonColumn>
\r
17 , create_user VARCHAR(20) NOT NULL
\r
18 , create_datetime DATETIME NOT NULL
\r
19 , update_user VARCHAR(20) NOT NULL
\r
20 , update_datetime DATETIME NOT NULL
\r
21 , version_no INTEGER NOT NULL
\r
23 <#if table.primaryKey??>
\r
24 , CONSTRAINT PRIMARY KEY (<#list table.primaryKey.columnNameList as columnName>${columnName}<#if columnName_has_next>,</#if></#list>)
\r
26 <#list table.uniqueList as unique>
\r
27 , CONSTRAINT UNIQUE KEY$ {unique.name} (<#list unique.columnNameList as columnName>${columnName}<#if columnName_has_next>,</#if></#list>)
\r
29 <#list table.indexList as index>
\r
30 , INDEX ${index.name} (<#list index.columnList as columnName>${columnName}<#if columnName_has_next>,</#if></#list>)
\r
32 ) ENGINE=InnoDB<#if table.alias?? || table.note??> COMMENT='<#if table.alias??>${table.alias}:</#if><#if table.note??>${table.note}</#if>'</#if>
\r
37 <#list tableList as table>
\r
38 <#list table.foreignKeyList as fk>ALTER TABLE ${table.name} ADD CONSTRAINT ${fk.name}
\r
39 FOREIGN KEY (<#list fk.columnNameList as columnName>${columnName}<#if columnName_has_next>,</#if></#list>)
\r
40 REFERENCES ${fk.targetTable} (<#list fk.targetColumnNameList as columnName>${columnName}<#if columnName_has_next>,</#if></#list>)
\r