github.com/dolthub/go-mysql-server@v0.18.0/enginetest/scriptgen/setup/scripts/pk_tables (about)

     1  exec
     2  create table one_pk (pk smallint primary key, c1 smallint, c2 smallint, c3 smallint, c4 smallint, c5 smallint)
     3  ----
     4  
     5  exec
     6  insert into one_pk values
     7      (0,0,1,2,3,4),
     8      (1,10,11,12,13,14),
     9      (2,20,21,22,23,24),
    10      (3,30,31,32,33,34)
    11  ----
    12  
    13  exec
    14  create table two_pk (
    15      pk1 tinyint,
    16      pk2 tinyint,
    17      c1 tinyint NOT NULL,
    18      c2 tinyint NOT NULL,
    19      c3 tinyint NOT NULL,
    20      c4 tinyint NOT NULL,
    21      c5 tinyint NOT NULL,
    22      primary key (pk1, pk2)
    23  )
    24  ----
    25  
    26  exec
    27  insert into two_pk values
    28      (0,0,0,1,2,3,4),
    29      (0,1,10,11,12,13,14),
    30      (1,0,20,21,22,23,24),
    31      (1,1,30,31,32,33,34)
    32  ----
    33  
    34  exec
    35  create table one_pk_two_idx (
    36      pk bigint primary key,
    37      v1 bigint,
    38      v2 bigint
    39  )
    40  ----
    41  
    42  exec
    43  insert into one_pk_two_idx values
    44      (0,0,0),
    45      (1,1,1),
    46      (2,2,2),
    47      (3,3,3),
    48      (4,4,4),
    49      (5,5,5),
    50      (6,6,6),
    51      (7,7,7)
    52  ----
    53  
    54  exec
    55  create table one_pk_three_idx (
    56      pk bigint primary key,
    57      v1 bigint,
    58      v2 bigint,
    59      v3 bigint
    60  )
    61  ----
    62  
    63  exec
    64  insert into one_pk_three_idx values
    65      (0,0,0,0),
    66      (1,0,0,1),
    67      (2,0,1,0),
    68      (3,0,2,2),
    69      (4,1,0,0),
    70      (5,2,0,3),
    71      (6,3,3,0),
    72      (7,4,4,4)
    73  ----
    74  
    75  exec
    76  create index one_pk_two_idx_1 on one_pk_two_idx (v1)
    77  ----
    78  
    79  exec
    80  create index one_pk_two_idx_2 on one_pk_two_idx (v1, v2)
    81  ----
    82  
    83  exec
    84  create index one_pk_three_idx_idx on one_pk_three_idx (v1, v2, v3)
    85  ----