OSDN Git Service

maven3でビルドできるよう修正
authortaktos9 <taktos9@136db618-7844-41ca-8ac1-fb3fd040db1d>
Thu, 1 Sep 2011 16:25:02 +0000 (16:25 +0000)
committertaktos9 <taktos9@136db618-7844-41ca-8ac1-fb3fd040db1d>
Thu, 1 Sep 2011 16:25:02 +0000 (16:25 +0000)
git-svn-id: http://svn.sourceforge.jp/svnroot/ea2ddl/trunk/ea2ddl@117 136db618-7844-41ca-8ac1-fb3fd040db1d

ea2ddl-comment/pom.xml
ea2ddl-common/pom.xml
ea2ddl-dao/pom.xml
ea2ddl-ddl/pom.xml
ea2ddl-parent/build.xml
ea2ddl-parent/dist/ea2ddl/templates/ddl-mysql.ftl [new file with mode: 0644]

index 1144804..ab28757 100644 (file)
@@ -4,6 +4,7 @@
                <artifactId>ea2ddl-parent</artifactId>\r
                <groupId>jp.sourceforge.ea2ddl</groupId>\r
                <version>0.0.2-SNAPSHOT</version>\r
+               <relativePath>../ea2ddl-parent</relativePath>\r
        </parent>\r
        <modelVersion>4.0.0</modelVersion>\r
        <artifactId>ea2ddl-comment</artifactId>\r
index 317f18b..d3b05c8 100644 (file)
@@ -4,6 +4,7 @@
                <artifactId>ea2ddl-parent</artifactId>\r
                <groupId>jp.sourceforge.ea2ddl</groupId>\r
                <version>0.0.2-SNAPSHOT</version>\r
+               <relativePath>../ea2ddl-parent</relativePath>\r
        </parent>\r
        <modelVersion>4.0.0</modelVersion>\r
        <artifactId>ea2ddl-common</artifactId>\r
index 3d70a72..1172e5a 100644 (file)
@@ -5,6 +5,7 @@
                <artifactId>ea2ddl-parent</artifactId>
                <groupId>jp.sourceforge.ea2ddl</groupId>
                <version>0.0.2-SNAPSHOT</version>
+               <relativePath>../ea2ddl-parent</relativePath>
        </parent>
        <modelVersion>4.0.0</modelVersion>
        <artifactId>ea2ddl-dao</artifactId>
index 08e2243..66ff50b 100644 (file)
@@ -4,6 +4,7 @@
                <artifactId>ea2ddl-parent</artifactId>\r
                <groupId>jp.sourceforge.ea2ddl</groupId>\r
                <version>0.0.2-SNAPSHOT</version>\r
+               <relativePath>../ea2ddl-parent</relativePath>\r
        </parent>\r
        <modelVersion>4.0.0</modelVersion>\r
        <artifactId>ea2ddl-ddl</artifactId>\r
index 7c9fb5c..1a62f60 100644 (file)
@@ -1,17 +1,17 @@
 <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
diff --git a/ea2ddl-parent/dist/ea2ddl/templates/ddl-mysql.ftl b/ea2ddl-parent/dist/ea2ddl/templates/ddl-mysql.ftl
new file mode 100644 (file)
index 0000000..4d03831
--- /dev/null
@@ -0,0 +1,57 @@
+<#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