public string Migrate_02_03_AlterTable_DropColumn(IDatabaseContext db)
{
var table = Helper.AlterTable("Table3")
.DeleteColumn("Date")
.DeleteColumn("Timestamp");
db.AlterTable(table);
table = Helper.AlterTable("Table1")
.DeleteColumn("Muciacia");
db.AlterTable(table);
return("203 - Alter table drop column");
}
public string Migrate_02_01_AlterTable_AddColumn(IDatabaseContext db)
{
var table = Helper.AlterTable("Table1")
.AddColumn("Muciacia", DbType.Byte, true)
.AddColumn("Senior", DbType.Boolean, false);
db.AlterTable(table);
table = Helper.AlterTable("Table1")
.AddAutoIncrementColumn("Id1", DbType.Int64);
db.AlterTable(table);
return("201 - Alter table add column");
}
public string Migrate_02_04_AlterTable_Combined(IDatabaseContext db)
{
var table = Helper.AlterTable("Table3")
.AddColumn("Date", DbType.Date, true)
.AddColumn("Razvan", DbType.Double, false)
.DeleteColumn("Id");
db.AlterTable(table);
table = Helper.AlterTable("Table1")
.DeleteColumn("Senior")
.AddColumn("Bunica", DbType.Decimal, false)
.AddColumn("Ion", DbType.StringFixedLength, 10, false)
.AlterColumn("Name", DbType.String, 500, true);
db.AlterTable(table);
return("203 - Alter table combined");
}
public string Migrate_4(IDatabaseContext db)
{
var table = Helper.AlterTable("Lucian")
.AddColumn("Razvan1", DbType.String, 23, true)
.AddColumn("Ok", DbType.Int64, false)
.DeleteColumn("Razvan");
db.AlterTable(table);
return("added razvan column");
}
public string Migrate_3(IDatabaseContext db)
{
var table = Helper.CreateTable("Lucian")
.AutoIncrementColumn("Id", DbType.Int64);
db.CreateTable(table);
var table1 = Helper.AlterTable("Lucian")
.AddColumn("Razvan", DbType.String, 423, true);
db.AlterTable(table1);
return("added razvan column");
}