vitess.io/vitess@v0.16.2/go/test/endtoend/vtgate/queries/orderby/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 t4
    14  (
    15      id1 bigint,
    16      id2 varchar(10),
    17      primary key (id1)
    18  ) ENGINE = InnoDB
    19    DEFAULT charset = utf8mb4
    20    COLLATE = utf8mb4_general_ci;
    21  create table t4_id2_idx
    22  (
    23      id2         varchar(10),
    24      id1         bigint,
    25      keyspace_id varbinary(50),
    26      primary key (id2, id1)
    27  ) Engine = InnoDB
    28    DEFAULT charset = utf8mb4
    29    COLLATE = utf8mb4_general_ci;