Because we can do it!
This package is under development. Do not use it on production!
First, you should write a migration;
public class MyMigration: Migration, IMigration {
public void Up()
{
migrator.Table("users");
migrator.AddColumn(new Int("id"))
.PrimaryKey()
.AutoIncrement()
.Unique()
.NotNull();
migrator.AddColumn(new VarChar("email", 100))
.Unique()
.NotNull();
migrator.AddColumn(new VarChar("nickname", 100))
.Unique()
.NotNull();
migrator.AddColumn(new VarChar("name", 100));
migrator.Create();
}
public void Down()
{
migrator.Table("users").Drop();
}
}
Then, you should run all migrations. Thats all!
IAdaptor adaptor = new MySQLAdaptor("my_connection_string");
Migrator migrator = new Migrator(adaptor);
migrator.SetMigrationList(new List<IMigration>() {
new MyMigration()
});
migrator.Migrate();