<project name="ea2ddl" default="dist" basedir=".">\r
\r
- <property name="version" value="0.0.1"/>\r
+ <property name="version" value="0.0.2"/>\r
\r
- <!-- ================================= \r
- target: clean \r
+ <!-- =================================\r
+ target: clean\r
================================= -->\r
<target name="clean" depends="" description="clean">\r
<delete dir="dist/ea2ddl/lib"/>\r
<delete dir="dist/ea2ddl-${version}.zip"/>\r
</target>\r
\r
- <!-- ================================= \r
- target: dist \r
+ <!-- =================================\r
+ target: dist\r
================================= -->\r
<target name="dist" depends="clean" description="dist">\r
<mkdir dir="dist/ea2ddl/lib"/>\r
--- /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