public string Migrate_04_02_AddColumn2(IDatabaseContext db)
{
db.AddColumn("Table2", "AddColumn1", DbType.String, 30, false);
db.AddColumn("Table2", "AddColumn2", DbType.Time, false);
db.AddColumn("Table2", "AddColumn3", DbType.AnsiStringFixedLength, 20, "default value", true);
return("402");
}
public string Migrate_04_01_AddColumn1(IDatabaseContext db)
{
db.AddColumn("Table1", "AddColumn1", DbType.Int32, false);
db.AddColumn("Table1", "AddColumn2", DbType.DateTime, false);
db.AddColumn("Table1", "AddColumn3", DbType.Currency, (object)3, true);
return("401");
}
public string Migrate_11_02(IDatabaseContext db)
{
db.AddColumn("Table3", "Table11ID", DbType.Int64, false);
db.AddColumn("Table3", "Table12ID", DbType.Int64, false);
var fk = Helper.ForeignKey("Table3", "Table1")
.MapColumn("Table11ID", "Id")
.MapColumn("Table12ID", "Id");
db.CreateForeignKey(fk);
return("1002");
}
