NewAISBuilder builder = AISBBasedBuilder.create(SCHEMA, typesTranslator());
builder.table("parent").colInt("pid", false).colString("v", 32).pk("pid").key("v", "v");
builder.table("child").colInt("cid", false).colInt("pid").pk("pid").joinTo("parent").on("pid", "pid");
builder.groupIndex("v_cid", Index.JoinType.LEFT).on("parent", "v").and("child", "cid");
AkibanInformationSchema inAIS = builder.ais();
Table inParent = inAIS.getTable(SCHEMA, "parent");
inParent.getGroup().setStorageDescription(new TestStorageDescription(inParent.getGroup(), GROUP_TREENAME, identifier));
inParent.getGroup().getIndex("v_cid").setStorageDescription(new TestStorageDescription(inParent.getGroup().getIndex("v_cid"), GROUP_INDEX_TREENAME, identifier));
inParent.getIndex("PRIMARY").setStorageDescription(new TestStorageDescription(inParent.getIndex("PRIMARY"), PARENT_PK_TREENAME, identifier));