public override void Up(SchemaAction schema)
{
schema.AddTable("t_all_types_1", t =>
{
t.AddString("string1").WithSize(123);
t.AddInt32("int1");
});
}
public override void Up(SchemaAction schema)
{
schema.ChangeTable("t_change_table", t =>
{
t.RemoveColumn("string1");
t.RemoveColumn("int1");
t.AddString("whatever").WithSize(1000);
});
}
public override void Down(SchemaAction schema)
{
schema.ChangeTable("t_simple_fk_2", t =>
{
t.RemoveColumn("auto_fk");
});
schema.RemoveTable("t_simple_fk_2");
schema.RemoveTable("t_simple_fk_1");
}
public override void Up(SchemaAction schema)
{
schema.AddTable("t_simple_fk_1", t =>
{
t.AddDateTime("field1");
});
schema.AddTable("t_simple_fk_2", t =>
{
t.AddInt32("auto_fk").Indexed().Default(1).AutoForeignKey("t_simple_fk_1");
});
}
public override void Up(SchemaAction schema)
{
schema.AddTable("t_change_column", t =>
{
t.AddString("string1").WithSize(123);
t.AddInt32("int1");
});
schema.ChangeTable("t_change_column", t =>
{
t.ChangeString("string1").WithSize(42);
});
}
public override void Up(SchemaAction schema)
{
schema.AddTable("t_all_types_1", false, t =>
{
t.AddAnsiString("fieldAnsiString").PrimaryKey();
t.AddBinary("fieldBinary").PrimaryKey();
t.AddByte("fieldByte").PrimaryKey();
t.AddBoolean("fieldBoolean").PrimaryKey();
t.AddCurrency("fieldCurrency").PrimaryKey();
t.AddDateTime("fieldDateTime").PrimaryKey();
t.AddDecimal("fieldDecimal").PrimaryKey();
t.AddDouble("fieldDouble").PrimaryKey();
t.AddInt16("fieldInt16").PrimaryKey();
t.AddInt32("fieldInt32").PrimaryKey();
t.AddInt64("fieldInt64").PrimaryKey();
t.AddSingle("fieldSingle").PrimaryKey();
t.AddString("fieldString").PrimaryKey();
});
schema.AddTable("t_all_types_2", false, t =>
{
t.AutoForeignKey("t_all_types_1"
, t.AddAnsiString("fieldAnsiString").PrimaryKey()
, t.AddBinary("fieldBinary").PrimaryKey()
, t.AddByte("fieldByte").PrimaryKey()
, t.AddBoolean("fieldBoolean").PrimaryKey()
, t.AddCurrency("fieldCurrency").PrimaryKey()
, t.AddDateTime("fieldDateTime").PrimaryKey()
, t.AddDecimal("fieldDecimal").PrimaryKey()
, t.AddDouble("fieldDouble").PrimaryKey()
, t.AddInt16("fieldInt16").PrimaryKey()
, t.AddInt32("fieldInt32").PrimaryKey()
, t.AddInt64("fieldInt64").PrimaryKey()
, t.AddSingle("fieldSingle").PrimaryKey()
, t.AddString("fieldString").PrimaryKey()
);
});
}
public override void Up(SchemaAction schema)
{
schema.AddTable("t_double_fk_1", false, t =>
{
t.AddInt32("id1").PrimaryKey();
t.AddString("id2").PrimaryKey();
t.AddDateTime("field1");
});
schema.AddTable("t_double_fk_2", false, t =>
{
t.AutoForeignKey("t_double_fk_1",
t.AddInt32("id1").PrimaryKey().LinkedTo("id1"),
t.AddString("id2").PrimaryKey().LinkedTo("id2")).OnConflict(ForeignKeyConstraint.Cascade);
t.UniqueColumns("uk_teste",
t.AddInt32("unique_field_1"),
t.AddSingle("unique_field_2"));
t.AddDateTime("field2");
});
}
public abstract void Up(SchemaAction schema);
public virtual void ExecuteSchema(SchemaAction action)
{
action.Execute(Database);
}
public abstract void Down(SchemaAction schema);
public override void Down(SchemaAction schema)
{
schema.RemoveTable("t_change_column");
}
public TableAddAction(SchemaAction database, string name)
: base(database, name)
{
}
public override void Down(SchemaAction schema)
{
schema.RemoveTable("t_all_types_1");
}
public TableAction(SchemaAction database, string name)
{
Name = name;
Database = database;
Actions = new List<IAction>();
}
public override void Down(SchemaAction schema)
{
schema.RemoveTable("t_double_fk_2");
schema.RemoveTable("t_double_fk_1");
}
