hej,

Want to generate a unique index with the SchemaExportTask. For example, a table like:

--- Resource ---
id: long
type: String
name: String

has a primary key consisting of the ID column (taken care of by the id element in the mapping document). What would like to produce (with SchemaExportTask) is a unique index made up of "name,type" pairs. No idea how this is represented in the mapping XML. But the result would be something like:

CREATE UNIQUE INDEX index_name
ON RESOURCE (type,name)


Thanks / matthew