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

     1  create table t3
     2  (
     3      id5 bigint,
     4      id6 bigint,
     5      id7 bigint,
     6      primary key (id5)
     7  ) Engine = InnoDB;
     8  
     9  create table t3_id7_idx
    10  (
    11      id  bigint not null auto_increment,
    12      id7 bigint,
    13      id6 bigint,
    14      primary key (id)
    15  ) Engine = InnoDB;
    16  
    17  create table t9
    18  (
    19      id1 bigint,
    20      id2 varchar(10),
    21      id3 varchar(10),
    22      primary key (id1)
    23  ) ENGINE = InnoDB
    24    DEFAULT charset = utf8mb4
    25    COLLATE = utf8mb4_general_ci;
    26  
    27  create table aggr_test
    28  (
    29      id   bigint,
    30      val1 varchar(16),
    31      val2 bigint,
    32      primary key (id)
    33  ) Engine = InnoDB;
    34  
    35  create table aggr_test_dates
    36  (
    37      id   bigint,
    38      val1 datetime default current_timestamp,
    39      val2 datetime default current_timestamp,
    40      primary key (id)
    41  ) Engine = InnoDB;
    42  
    43  create table t7_xxhash
    44  (
    45      uid   varchar(50),
    46      phone bigint,
    47      msg   varchar(100),
    48      primary key (uid)
    49  ) Engine = InnoDB;
    50  
    51  create table t7_xxhash_idx
    52  (
    53      phone       bigint,
    54      keyspace_id varbinary(50),
    55      primary key (phone, keyspace_id)
    56  ) Engine = InnoDB;
    57  
    58  CREATE TABLE t1 (
    59      t1_id bigint unsigned NOT NULL,
    60      `name` varchar(20) NOT NULL,
    61      `value` varchar(50),
    62      shardKey bigint,
    63      PRIMARY KEY (t1_id),
    64      UNIQUE KEY `t1id_name` (t1_id, `name`),
    65      KEY `IDX_TA_ValueName` (`value`(20), `name`(10))
    66  ) ENGINE InnoDB;
    67  
    68  CREATE TABLE t2 (
    69      id bigint NOT NULL,
    70      shardKey bigint,
    71      PRIMARY KEY (id)
    72  ) ENGINE InnoDB;
    73  
    74  CREATE TABLE t10 (
    75     k BIGINT PRIMARY KEY,
    76     a INT,
    77     b INT
    78  );