How to create a composite index in a fluid

Question

How to create a composite index using Liquibase?

This is what I still have:

<createIndex indexName="idx_value" tableName="test"> <column name="value"/> </createIndex> 

I mean the following, but I just need to confirm.

 <createIndex indexName="idx_value" tableName="test"> <column name="value0"/> <column name="value1"/> </createIndex> 

Answer 1

I would be amazed if:

 <createIndex indexName="idx_value" tableName="test"> <column name="value" type="varchar(255)"/> <column name="othercolumn" type="varchar(255)"/> </createIndex> 

does not work...