First off is there any full documentation of what syntax turbine does does not
allow? Maybe a Schema manual?
Alright, now on with the questions at hand. I have an existing mysql database.
Running the Ant task JDBC-->XML does not handle all aspects of the schema
generation. Thus some questions:
1) Is the equivelent of a AKA field created by the following:
<column default="" name="Name" required = "true" size="10"
type="VARCHAR"/>
<unique>
<unique-column name="Name"/>
</unique>
2) Is 'required=true' equivalent to 'NOT NULL' in SQL?
3) How to define UNIQUE constraints across multiple columns? Will this work:
<unique>
<unique-column name="Relation 1"/>
<unique-column name="Relation 2"/>
<unique-column name="Date"/>
</unique>
4) Can you define multiple Foreign key mappings as follows:
<foreign-key foreignTable="address">
<reference
local="address_id"
foreign="id"/>
<reference
local="address_type"
foreign="type"/>
</foreign-key>
5) Are primaryKeys which cross multiple columns allowed?
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
