FluentMigrator primjer migracijskih skripti

201201311705.cs

[Migration(1)]
// Može se postaviti i timestamp umijesto rednog broja
// [Migration(201201311705)]
public class CreateUserTable : Migration
{
    public override void Up()
    {
        Create.Table("User")
            .WithColumn("Id").AsInt32().NotNullable().PrimaryKey().Identity();
            .WithColumn("Username").AsString(50).NotNullable()
            .WithColumn("Password").AsString(100)
            .WithColumn("Name").AsString(100).Nullable()
            .WithColumn("Lastloged").AsDateTime().Nullable()
            .WithColumn("Registered").AsDateTime().Nullable();
    }

    public override void Down()
    {
            Delete.Table("User");
    }    
}