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

     1  exec
     2  CREATE TABLE `typestable` (
     3    `id` bigint NOT NULL,
     4    `i8` tinyint,
     5    `i16` smallint,
     6    `i32` int,
     7    `i64` bigint,
     8    `u8` tinyint unsigned,
     9    `u16` smallint unsigned,
    10    `u32` int unsigned,
    11    `u64` bigint unsigned,
    12    `f32` float,
    13    `f64` double,
    14    `ti` timestamp,
    15    `da` date,
    16    `te` varchar(20),
    17    `bo` tinyint,
    18    `js` json,
    19    `bl` blob,
    20    `e1` enum('', 'v1', 'v2'),
    21    `s1` set('', 'v1', 'v2'),
    22    PRIMARY KEY (`id`)
    23  )
    24  ----
    25  
    26  exec
    27  insert into typestable values
    28      (1,2,3,4,5,6,7,8,9,10.0,11.0,'2019-12-31T12:00:00Z','2019-12-31T00:00:00Z','fourteen', 0,null,null, '', '')
    29  ----