CREATE TABLE `t1` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '',
`u` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
`p` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
`k` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
`c` date NOT NULL DEFAULT '0001-01-01' COMMENT '',
PRIMARY KEY (`id`,`c`) NONCLUSTERED,
KEY `idx_userid` (`u`,`c`),
KEY `idx_user_keyword` (`c`,`u`,`k`),
KEY `idx_user_plan` (`c`,`u`,`p`)
) SHARD_ROW_ID_BITS = 2 PRE_SPLIT_REGIONS=2 ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=113838548138 COMMENT=''
PARTITION BY RANGE COLUMNS(`c`)
(PARTITION `p20250409` VALUES LESS THAN ('20250410'),
PARTITION `p20250410` VALUES LESS THAN ('20250411'),
PARTITION `p20250411` VALUES LESS THAN ('20250412'),
PARTITION `p20250412` VALUES LESS THAN ('20250413'),
PARTITION `p20250413` VALUES LESS THAN ('20250414'),
PARTITION `p20250414` VALUES LESS THAN ('20250415'),
PARTITION `p20250415` VALUES LESS THAN ('20250416'),
PARTITION `p20250416` VALUES LESS THAN ('20250417'),
PARTITION `p20250417` VALUES LESS THAN ('20250418'),
PARTITION `p20250418` VALUES LESS THAN ('20250419'),
PARTITION `p20250419` VALUES LESS THAN ('20250420'),
PARTITION `p20250420` VALUES LESS THAN ('20250421'),
PARTITION `p20250421` VALUES LESS THAN ('20250422'),
PARTITION `p20250422` VALUES LESS THAN ('20250423'),
PARTITION `p20250423` VALUES LESS THAN ('20250424'),
PARTITION `p20250424` VALUES LESS THAN ('20250425'),
PARTITION `p20250425` VALUES LESS THAN ('20250426'),
PARTITION `p20250426` VALUES LESS THAN ('20250427'),
PARTITION `p20250427` VALUES LESS THAN ('20250428'),
PARTITION `p20250428` VALUES LESS THAN ('20250429'));
