テンプレート修正

git-svn-id: http://svn.sourceforge.jp/svnroot/ea2ddl/trunk/ea2ddl@58 136db618-7844-41ca-8ac1-fb3fd040db1d

diff --git a/ea2ddl-parent/dist/ea2ddl/templates/ddl.ftl b/ea2ddl-parent/dist/ea2ddl/templates/ddl.ftl
index 72da61f..1ae4af5 100644 (file)
--- a/ea2ddl-parent/dist/ea2ddl/templates/ddl.ftl
+++ b/ea2ddl-parent/dist/ea2ddl/templates/ddl.ftl
@@ -13,6 +13,13 @@ DROP TABLE ${table.name};
 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   VARCHAR2(20)    NOT NULL\r
+       , CREATE_DATETIME       DATE    NOT NULL\r
+       , UPDATE_USER   VARCHAR2(20)    NOT NULL\r
+       , UPDATE_DATETIME       DATE    NOT NULL\r
+       , VERSION_NO    NUMBER(8)       NOT NULL\r
+</#if>\r
 )\r
 ;\r
 <#if table.primaryKey??>ALTER TABLE ${table.name} ADD CONSTRAINT ${table.primaryKey.name}\r
@@ -23,6 +30,10 @@ CREATE TABLE ${table.name} (
        UNIQUE (<#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
 <#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