Skip to content

Instantly share code, notes, and snippets.

@jcteague
Created July 23, 2013 15:24
Show Gist options
  • Save jcteague/6063263 to your computer and use it in GitHub Desktop.
Save jcteague/6063263 to your computer and use it in GitHub Desktop.
using FluentMigrator;
using ViewSourceMigrations.CustomMigrations;
using ViewSourceMigrations.Extensions;
namespace ViewSourceMigrations.Migrations {
[ Migration( 20121206112020 ) ]
public class Migration20121206112020CreateVendorTable : HiLoMigration {
public override void Up( ) {
Create.Table(ProgramConstants.Tables.Vendor)
.WithIdColumn()
.WithColumn("MunicipalityVendorId").AsInt64().Nullable()
.WithColumn("LocalVendorId").AsInt64().Nullable()
.WithColumn("RegistrationWorkOrderNumber").AsInt64().Nullable()
.WithColumn("SignWorkOrderNumber").AsInt64().Nullable()
.WithColumn("MunicipalityVendorEmail").AsString(50).Nullable()
.WithColumn("MunicipalityVendorPhone").AsString(50).Nullable()
.WithColumn("LocalVendorName").AsString(50).Nullable()
.WithColumn("MunicipalityVendorName").AsString(50).Nullable()
.WithColumn("DocumentsUploaded").AsBoolean().Nullable();
}
public override void Down( ) {
Delete.Table(ProgramConstants.Tables.Vendor);
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment