Hi,
I wanted to fix the problems that people were having
with INDEX, and UNIQUE. Fanyun noticed that you couldn't
make multiple indices, the same is true for unique indices.
I want to add something like this so you could:
<index name="MyFirstIndex">
<index-column name="column1"/>
<index-column name="column2"/>
</index>
<index name="MySecondIndex">
<index-column name="column3"/>
</index>
...
INDEX MyFirstIndex (column1, column2)
INDEX MySecondIndex (column3)
And,
<unique>
<unique-column name="column1"/>
<unique-column name="column2"/>
</unique>
...
UNIQUE (column1, column2)
And technially a foreign key can map multiple
columns in one table to another so does the
current DTD work? It looks like it to me, but
I'm not sure.
<foreign-key foreignTable="ForeignTable">
<reference local="local1" foreign="foreign1"/>
<reference local="local2" foreign="foreign2"/>
</foreign-key>
is meant to produce
FOREIGN KEY (local1, local2) REFERENCES ForeignTable(foreign1, foreign2)
?
Can someone please correct me if any of this is wrong so
I don't add something silly to Torque.
jvz.
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
