.Indexed() and .Unique() do nothing

[ceilidhboy]

Working against SqlServer, adding .Indexed() or .Unique() when creating a table's columns don't do anything.

I'm surprised this bug got this far. Surely an index is a pretty common requirement?

[jsadeli]

I can confirm that UNIQUE column constraint not applied/created when working with SQLite. FluentMigrator v1.0

[pkrakowiak]

Same with PostgreSQL, .Unique() called in the create table method chain doesn't add any constraints in the generated SQL. This works as an alternative:

Create.Index("uq_category_name").OnTable(CATEGORIES_TABLE).OnColumn("name").Ascending().WithOptions().Unique();