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

     1  create table t1
     2  (
     3      id1 bigint,
     4      id2 bigint,
     5      primary key (id1)
     6  ) Engine = InnoDB;
     7  
     8  create table t1_id2_idx
     9  (
    10      id2         bigint,
    11      keyspace_id varbinary(10),
    12      primary key (id2)
    13  ) Engine = InnoDB;
    14  
    15  create table t7_xxhash
    16  (
    17      uid   varchar(50),
    18      phone bigint,
    19      msg   varchar(100),
    20      primary key (uid)
    21  ) Engine = InnoDB;
    22  
    23  create table t7_xxhash_idx
    24  (
    25      phone       bigint,
    26      keyspace_id varbinary(50),
    27      primary key (phone, keyspace_id)
    28  ) Engine = InnoDB;
    29  
    30  create table t7_fk
    31  (
    32      id     bigint,
    33      t7_uid varchar(50),
    34      primary key (id),
    35      CONSTRAINT t7_fk_ibfk_1 foreign key (t7_uid) references t7_xxhash (uid)
    36          on delete set null on update cascade
    37  ) Engine = InnoDB;