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"); }