Re: Foreign keys & inability to control CREATE TABLE order cause errors MySQL

[Thomas Dudziak]

The DdlUtils website is slightly out of date (should be fixed this
week), here's how you'd use it in your Ant build file (with PostgreSQL
in this example, but it is similar with MySQL):

    <taskdef name="ddlToDatabase"
            classname="org.apache.ddlutils.task.DdlToDatabaseTask">
     <classpath refid="runtime-classpath"/>
   </taskdef>

   <ddlToDatabase>
     <database url="jdbc:postgresql://localhost/test"
               driverClassName="org.postgresql.Driver"
               username="admin"
               password="superDuperPassword"/>
     <fileset dir="${build.database.dir}" includes="*-schema.xml"/>

     <createdatabase failonerror="false"/>
     <writeschematodatabase alterdatabase="false"/>
   </ddlToDatabase>

Tom

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]