vitess.io/vitess@v0.16.2/go/test/endtoend/vtgate/queries/subquery/schema.sql (about)

     1  create table t1
     2  (
     3      id1 bigint,
     4      id2 bigint,
     5      primary key (id1)
     6  ) Engine = InnoDB;
     7  create table t1_id2_idx
     8  (
     9      id2         bigint,
    10      keyspace_id varbinary(10),
    11      primary key (id2)
    12  ) Engine = InnoDB;
    13  create table t2
    14  (
    15      id3 bigint,
    16      id4 bigint,
    17      primary key (id3)
    18  ) Engine = InnoDB;
    19  create table t2_id4_idx
    20  (
    21      id  bigint not null auto_increment,
    22      id4 bigint,
    23      id3 bigint,
    24      primary key (id),
    25      key idx_id4 (id4)
    26  ) Engine = InnoDB;