How do I add an index onto a regular property? I've looked through most of the documentation, found nothing at first, went through the dtd, found what the attribute should be, and checked the docs again, found minor mention in chapter 15 (toolset).

<property name="creationTime" access="field">
<column name="creation_time" not-null="true"
index="true" sql-type="timestamp" />
</property>

(Yes, I have tried values apart from 'true', assuming that it forms a composite index.)

I cleared the database, restarted the app, and then did a database dump:

`creation_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

is the only part that mentions "creation_time".


Could someone please tell me why there appears to be no sign of the index, or direct me to some documentation (that I certainly have had no luck finding) that deals with index/unique-key?