public AddTable ( string name, Action |
||
name | string | |
definition | Action |
|
return |
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_all_types_1", t => { t.AddString("string1").WithSize(123); t.AddInt32("int1"); }); }
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"); }); }