Hi,
take a look at the source distribution.
its available via cvs.
-> /jakarta-turbine/src/dtd/database.dtd
the dtd will answers most of your 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>
>
a AKA field?
> 2) Is 'required=true' equivalent to 'NOT NULL' in SQL?
yup
>
> 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>
>
yup
> 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>
>
yup
> 5) Are primaryKeys which cross multiple columns allowed?
yup.
although i dont now how they are specified in schema.xml.;)
i did it manually.
hth,
heiko
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
