FluentMigrator primjer indexa i key-eva

201201311710.cs

[Migration(2)]
// Može se postaviti i timestamp umijesto rednog broja
// [Migration(201201311710)]
public class CreateUserTable : Migration
{
    public override void Up()
    {
        Create.ForeignKey("fk_tag_user")
		.FromTable("Tag").ForeignColumn("CreatorId")
		.ToTable("User").PrimaryColumn("Id")
		.OnDeleteOrUpdate(Rule.Cascade);

	Create.Index("idx_tag_url").OnTable("Tag")
		.OnColumn("ShortUrl").Ascending()
		.WithOptions().NonClustered().Unique();
    }

    public override void Down()
    {
	Delete.ForeignKey("fk_tag_user");
	Delete.Index("idx_tag_url");
    }    
}