CREATE TABLE `shardkey_2` (
  `col_int_auto_not_null` int NOT NULL,
  `col_pk_char` char(120) CHARACTER SET cp1251 COLLATE cp1251_general_cs NOT NULL,
  `col_pk_varchar` varchar(60) CHARACTER SET cp1251 COLLATE cp1251_general_cs NOT NULL,
  `col_pk_date` date NOT NULL,
  `col_int` int DEFAULT NULL,
  `col_int__1` int DEFAULT NULL,
  `col_int_8` int DEFAULT NULL,
  `col_int_8__1` int DEFAULT NULL,
  `col_bigint` bigint DEFAULT NULL,
  `col_smallint` smallint DEFAULT NULL,
  `col_tinyint` tinyint DEFAULT NULL,
  `col_float` float DEFAULT NULL,
  `col_double` double DEFAULT NULL,
  `col_decimal` decimal(10,0) DEFAULT NULL,
  `col_bit` bit(1) DEFAULT NULL,
  `col_bit__1` bit(1) DEFAULT NULL,
  `col_enum` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_set` set('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_char_2` char(2) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_char_255` char(255) COLLATE utf8mb4_general_ci NOT NULL,
  `col_varchar_1` varchar(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_varchar_64` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_varchar_1024` varchar(1024) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_binary_8` binary(8) DEFAULT NULL,
  `col_varbinary_8` varbinary(8) DEFAULT NULL,
  `col_date` date NOT NULL,
  `col_time` time DEFAULT NULL,
  `col_datetime` datetime DEFAULT NULL,
  `col_timestamp` timestamp NULL,
  `col_year` year DEFAULT NULL,
  `col_text` text COLLATE utf8mb4_general_ci,
  `col_bool` tinyint(1) DEFAULT NULL,
  `col_boolean` tinyint(1) DEFAULT NULL,
  `col_longtext` longtext COLLATE utf8mb4_general_ci,
  `col_mediumtext` mediumtext COLLATE utf8mb4_general_ci,
  `col_tinyblob` tinyblob,
  `col_mediumblob` mediumblob,
  `col_longblob` longblob,
  `col_blob` blob,
  PRIMARY KEY (`col_int_auto_not_null`,`col_pk_varchar`,`col_pk_date`,`col_date`,`col_char_255`),
  KEY `k2` (`col_int`,`col_char_255`),
  KEY `k1` (`col_pk_varchar`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


CREATE TABLE `noshard_2` (
  `col_int_auto_not_null` int NOT NULL,
  `col_pk_char` char(120) CHARACTER SET cp1251 COLLATE cp1251_general_cs NOT NULL,
  `col_pk_varchar` varchar(60) CHARACTER SET cp1251 COLLATE cp1251_general_cs NOT NULL,
  `col_pk_date` date NOT NULL,
  `col_int` int DEFAULT NULL,
  `col_int__1` int DEFAULT NULL,
  `col_int_8` int DEFAULT NULL,
  `col_int_8__1` int DEFAULT NULL,
  `col_bigint` bigint DEFAULT NULL,
  `col_smallint` smallint DEFAULT NULL,
  `col_tinyint` tinyint DEFAULT NULL,
  `col_float` float DEFAULT NULL,
  `col_double` double DEFAULT NULL,
  `col_decimal` decimal(10,0) DEFAULT NULL,
  `col_bit` bit(1) DEFAULT NULL,
  `col_bit__1` bit(1) DEFAULT NULL,
  `col_enum` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_set` set('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_char_2` char(2) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_char_255` char(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_varchar_1` varchar(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_varchar_64` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_varchar_1024` varchar(1024) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_binary_8` binary(8) DEFAULT NULL,
  `col_varbinary_8` varbinary(8) DEFAULT NULL,
  `col_date` date NOT NULL,
  `col_time` time DEFAULT NULL,
  `col_datetime` datetime DEFAULT NULL,
  `col_timestamp` timestamp NULL,
  `col_year` year DEFAULT NULL,
  `col_text` text COLLATE utf8mb4_general_ci,
  `col_bool` tinyint(1) DEFAULT NULL,
  `col_boolean` tinyint(1) DEFAULT NULL,
  `col_longtext` longtext COLLATE utf8mb4_general_ci,
  `col_mediumtext` mediumtext COLLATE utf8mb4_general_ci,
  `col_tinyblob` tinyblob,
  `col_mediumblob` mediumblob,
  `col_longblob` longblob,
  `col_blob` blob,
  PRIMARY KEY (`col_int_auto_not_null`,`col_pk_varchar`,`col_pk_date`,`col_date`),
  KEY `k2` (`col_int`,`col_char_255`),
  KEY `k1` (`col_pk_varchar`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


CREATE TABLE `shardkey_list_1` (
  `col_int_auto_not_null` int NOT NULL,
  `col_pk_char` char(120) CHARACTER SET cp1251 COLLATE cp1251_general_cs NOT NULL,
  `col_pk_varchar` varchar(60) CHARACTER SET cp1251 COLLATE cp1251_general_cs NOT NULL,
  `col_pk_date` date NOT NULL,
  `col_int` int DEFAULT NULL,
  `col_int__1` int DEFAULT NULL,
  `col_int_8` int DEFAULT NULL,
  `col_int_8__1` int DEFAULT NULL,
  `col_bigint` bigint DEFAULT NULL,
  `col_smallint` smallint DEFAULT NULL,
  `col_tinyint` tinyint DEFAULT NULL,
  `col_float` float DEFAULT NULL,
  `col_double` double DEFAULT NULL,
  `col_decimal` decimal(10,0) DEFAULT NULL,
  `col_bit` bit(1) DEFAULT NULL,
  `col_bit__1` bit(1) DEFAULT NULL,
  `col_enum` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_set` set('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_char_2` char(2) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_char_255` char(255) COLLATE utf8mb4_general_ci NOT NULL,
  `col_varchar_1` varchar(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_varchar_64` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_varchar_1024` varchar(1024) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `col_binary_8` binary(8) DEFAULT NULL,
  `col_varbinary_8` varbinary(8) DEFAULT NULL,
  `col_date` date DEFAULT NULL,
  `col_time` time DEFAULT NULL,
  `col_datetime` datetime NOT NULL,
  `col_timestamp` timestamp NULL,
  `col_year` year DEFAULT NULL,
  `col_text` text COLLATE utf8mb4_general_ci,
  `col_bool` tinyint(1) DEFAULT NULL,
  `col_boolean` tinyint(1) DEFAULT NULL,
  `col_longtext` longtext COLLATE utf8mb4_general_ci,
  `col_mediumtext` mediumtext COLLATE utf8mb4_general_ci,
  `col_tinyblob` tinyblob,
  `col_mediumblob` mediumblob,
  `col_longblob` longblob,
  `col_blob` blob,
  PRIMARY KEY (`col_int_auto_not_null`,`col_char_255`,`col_datetime`,`col_pk_char`,`col_pk_date`),
  UNIQUE KEY `uk1` (`col_int_auto_not_null`,`col_char_255`,`col_datetime`,`col_pk_char`,`col_pk_date`),
  KEY `k2` (`col_int`,`col_char_255`),
  KEY `k1` (`col_pk_varchar`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;