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

     1  exec
     2   CREATE TABLE `sbtest1` (
     3    `id` int NOT NULL,
     4    `tiny_int_col` tinyint NOT NULL,
     5    `unsigned_tiny_int_col` tinyint unsigned NOT NULL,
     6    `small_int_col` smallint NOT NULL,
     7    `unsigned_small_int_col` smallint unsigned NOT NULL,
     8    `medium_int_col` mediumint NOT NULL,
     9    `unsigned_medium_int_col` mediumint unsigned NOT NULL,
    10    `int_col` int NOT NULL,
    11    `unsigned_int_col` int unsigned NOT NULL,
    12    `big_int_col` bigint NOT NULL,
    13    `unsigned_big_int_col` bigint unsigned NOT NULL,
    14    `decimal_col` decimal(10,0) NOT NULL,
    15    `float_col` float NOT NULL,
    16    `double_col` double NOT NULL,
    17    `bit_col` bit(1) NOT NULL,
    18    `char_col` char(1) NOT NULL,
    19    `var_char_col` varchar(64) NOT NULL,
    20    `enum_col` enum('val0','val1','val2') NOT NULL,
    21    `set_col` set('val0','val1','val2') NOT NULL,
    22    `date_col` date NOT NULL,
    23    `time_col` time(6) NOT NULL,
    24    `datetime_col` datetime NOT NULL,
    25    `timestamp_col` timestamp NOT NULL,
    26    `year_col` year NOT NULL,
    27    PRIMARY KEY (`id`),
    28    KEY `big_int_col` (`big_int_col`)
    29  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin
    30  ---
    31  
    32  exec
    33  CREATE TABLE `sbtest2` (
    34    `id` int NOT NULL,
    35    `int_col` int NOT NULL,
    36    `unsigned_int_col` int unsigned NOT NULL,
    37    `char_col` char(1) NOT NULL,
    38    `var_char_col` varchar(64) NOT NULL,
    39    PRIMARY KEY (`id`)
    40  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin
    41  ----
    42  
    43  exec
    44  analyze table sbtest1 update histogram on id using data '{\"row_count\": 10000}';
    45  ----
    46  
    47  exec
    48  analyze table sbtest2 update histogram on id using data '{\"row_count\": 10000}';
    49  ----