private static void CreateTestTables(IQuery context)
{
var tn1 = ObjectName.Parse("APP.test_table1");
context.Access().CreateTable(table => table
.Named(tn1)
.WithColumn("id", PrimitiveTypes.Integer())
.WithColumn("name", PrimitiveTypes.String())
.WithColumn("date", PrimitiveTypes.DateTime()));
context.Session.Access().AddPrimaryKey(tn1, "id");
var tn2 = ObjectName.Parse("APP.test_table2");
context.Access().CreateTable(table => table
.Named(tn2)
.WithColumn("id", PrimitiveTypes.Integer())
.WithColumn("other_id", PrimitiveTypes.Integer())
.WithColumn("count", PrimitiveTypes.Integer()));
context.Session.Access().AddPrimaryKey(tn2, "id");
context.Session.Access().AddForeignKey(tn2, new[] { "other_id" }, tn1, new[] { "id" }, ForeignKeyAction.Cascade,
ForeignKeyAction.Cascade, null);
}