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;