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

     1  exec
     2  CREATE TABLE `people` (
     3    `dob` date NOT NULL,
     4    `first_name` varchar(20) NOT NULL,
     5    `last_name` varchar(20) NOT NULL,
     6    `middle_name` varchar(20) NOT NULL,
     7    `height_inches` bigint NOT NULL,
     8    `gender` bigint NOT NULL,
     9    PRIMARY KEY (`dob`,`first_name`,`last_name`,`middle_name`)
    10  )
    11  ----
    12  
    13  exec
    14  insert into people values
    15      ('1970-12-1', 'jon', 'smith', '', 72, 0),
    16      ('1980-1-11', 'jon', 'smith', '', 67, 0),
    17      ('1990-2-21', 'jane', 'doe', '', 68, 1),
    18      ('2000-12-31', 'frank', 'franklin', '', 70, 2),
    19      ('2010-3-15', 'jane', 'doe', '', 69, 1)
    20  ----
    21  
    22  exec
    23  create index people_l_f on people (last_name,first_name)
    24  ----