// create an autonamed index
HsqlName indexname = database.nameManager.newAutoName("IDX",
name.name, table.getSchemaName(), table.getName(),
SchemaObject.INDEX);
Index exprIndex = table.createIndexStructure(indexname, cols, null, null, true, true, false);
exprIndex = exprIndex.withExpressions(indexExprs);
Constraint constraint = new Constraint(name, table, exprIndex, Constraint.UNIQUE).setAssumeUnique(assumeUnique);
Table tn = table.moveDefinition(session, table.tableType, null,
constraint, exprIndex, -1, 0, emptySet, emptySet);
tn.moveData(session, table, -1, 0);
database.persistentStoreCollection.releaseStore(table);