I'm using SchemaExport to create file based databases when the user wants to start a new database.

Can database indexes be specified in mapping files such that SchemaExport automatically builds them? It looks like it should be possible according to nhibernate-mapping-2.0.xsd, which states that property tags may contain an "index" attribute of type string. However this attribute doesn't seem to be documented so I'm not sure if it refers to database or collection indexing.

What about multi column indexes? Based on this post http://forum.hibernate.org/viewtopic.php?t=944578, it sounds like I probably need to manually create them after SchemaExport.

On a slightly different topic, is it work adding indexes to all my foreign key columns when using SQLite?