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;