vitess.io/vitess@v0.16.2/go/test/endtoend/vtgate/gen4/sharded_schema.sql (about)

     1  create table t1
     2  (
     3      id  bigint,
     4      col bigint,
     5      primary key (id)
     6  ) Engine = InnoDB;
     7  
     8  create table t2
     9  (
    10      id    bigint,
    11      tcol1 varchar(50),
    12      tcol2 varchar(50),
    13      primary key (id)
    14  ) Engine = InnoDB;
    15  
    16  create table t3
    17  (
    18      id    bigint,
    19      tcol1 varchar(50),
    20      tcol2 varchar(50),
    21      primary key (id)
    22  ) Engine = InnoDB;
    23  
    24  create table user_region
    25  (
    26      id   bigint,
    27      cola bigint,
    28      colb bigint,
    29      primary key (id)
    30  ) Engine = InnoDB;
    31  
    32  create table region_tbl
    33  (
    34      rg  bigint,
    35      uid bigint,
    36      msg varchar(50),
    37      primary key (uid)
    38  ) Engine = InnoDB;
    39  
    40  create table multicol_tbl
    41  (
    42      cola bigint,
    43      colb varbinary(50),
    44      colc varchar(50),
    45      msg  varchar(50),
    46      primary key (cola, colb, colc)
    47  ) Engine = InnoDB;
    48  
    49  create table team(
    50       id     int,
    51       name   varchar(64),
    52       primary key (id)
    53  ) Engine = InnoDB;
    54  
    55  create table team_fact(
    56      id   int,
    57      team int,
    58      fact char,
    59      primary key (id)
    60  ) Engine = InnoDB;
    61  
    62  create table team_member(
    63      team int,
    64      user int,
    65      primary key (team, user)
    66  ) Engine = InnoDB;