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

     1  create table s_tbl
     2  (
     3      id  bigint,
     4      num bigint,
     5      primary key (id)
     6  ) Engine = InnoDB;
     7  
     8  create table num_vdx_tbl
     9  (
    10      num         bigint,
    11      keyspace_id varbinary(20),
    12      primary key (num)
    13  ) Engine = InnoDB;
    14  
    15  create table user_tbl
    16  (
    17      id        bigint,
    18      region_id bigint,
    19      name      varchar(50),
    20      primary key (id)
    21  ) Engine = InnoDB;
    22  
    23  create table order_tbl
    24  (
    25      oid       bigint,
    26      region_id bigint,
    27      cust_no   bigint unique key,
    28      primary key (oid, region_id)
    29  ) Engine = InnoDB;
    30  
    31  create table oid_vdx_tbl
    32  (
    33      oid         bigint,
    34      keyspace_id varbinary(20),
    35      primary key (oid)
    36  ) Engine = InnoDB;
    37  
    38  create table oevent_tbl
    39  (
    40      oid   bigint,
    41      ename varchar(20),
    42      primary key (oid, ename)
    43  ) Engine = InnoDB;
    44  
    45  create table oextra_tbl
    46  (
    47      id  bigint,
    48      oid varchar(20),
    49      primary key (id)
    50  ) Engine = InnoDB;
    51  
    52  create table auto_tbl
    53  (
    54      id         bigint,
    55      unq_col    bigint,
    56      nonunq_col bigint,
    57      primary key (id),
    58      unique (unq_col)
    59  ) Engine = InnoDB;
    60  
    61  create table unq_idx
    62  (
    63      unq_col     bigint,
    64      keyspace_id varbinary(20),
    65      primary key (unq_col)
    66  ) Engine = InnoDB;
    67  
    68  create table nonunq_idx
    69  (
    70      nonunq_col  bigint,
    71      id          bigint,
    72      keyspace_id varbinary(20),
    73      primary key (nonunq_col, id)
    74  ) Engine = InnoDB;