+++ /dev/null
-<#comment>\r
-<#list tableList as table>\r
-<#list table.foreignKeyList as fk>ALTER TABLE ${table.name} DROP CONSTRAINT ${fk.name}\r
-;\r
-</#list>\r
-</#list>\r
-<#list tableList as table>\r
-DROP TABLE ${table.name};\r
-</#list>\r
-</#comment>\r
-\r
-<#list tableList as table>\r
-CREATE TABLE ${table.name} (\r
-<#list table.columnList as column> ${column.name} ${column.definition}<#if column_has_next>,</#if>\r
-</#list>\r
-<#if !table.suppressCommonColumn>\r
- , create_user VARCHAR(20) NOT NULL\r
- , create_datetime DATETIME NOT NULL\r
- , update_user VARCHAR(20) NOT NULL\r
- , update_datetime DATETIME NOT NULL\r
- , version_no INTEGER NOT NULL\r
-</#if>\r
-)\r
-;\r
-<#if table.primaryKey??>ALTER TABLE ${table.name} ADD CONSTRAINT PRIMARY KEY\r
- (<#list table.primaryKey.columnNameList as columnName>${columnName}<#if columnName_has_next>,</#if></#list>)\r
-;\r
-</#if>\r
-<#list table.uniqueList as unique>ALTER TABLE ${table.name} ADD CONSTRAINT UNIQUE ${unique.name}\r
- (<#list unique.columnNameList as columnName>${columnName}<#if columnName_has_next>,</#if></#list>)\r
-;\r
-</#list>\r
-<#list table.indexList as index>CREATE INDEX ${index.name} ON ${table.name}\r
- (<#list index.columnList as columnName>${columnName}<#if columnName_has_next>,</#if></#list>)\r
-;\r
-</#list>\r
-\r
-<#if table.alias?? || table.note??>\r
-COMMENT ON TABLE ${table.name} IS '<#if table.alias??>${table.alias}:</#if><#if table.note??>${table.note}</#if>'\r
-;\r
-</#if>\r
-<#list table.columnList as column>\r
-<#if column.alias?? || column.note??>\r
-COMMENT ON COLUMN ${table.name}.${column.name} IS '<#if column.alias??>${column.alias}:</#if><#if column.note??>${column.note}</#if>'\r
-;\r
-</#if>\r
-</#list>\r
-\r
-</#list>\r
-\r
-<#list tableList as table>\r
-<#list table.foreignKeyList as fk>ALTER TABLE ${table.name} ADD CONSTRAINT ${fk.name}\r
- FOREIGN KEY (<#list fk.columnNameList as columnName>${columnName}<#if columnName_has_next>,</#if></#list>)\r
- REFERENCES ${fk.targetTable} (<#list fk.targetColumnNameList as columnName>${columnName}<#if columnName_has_next>,</#if></#list>)\r
-;\r
-</#list>\r
-</#list>
\ No newline at end of file