ALTER TABLE `baiduutil`.`file_download_log_ex_0` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_0` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_1` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_1` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_2` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_2` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_3` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_3` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_4` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_4` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_5` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_5` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_6` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_6` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_7` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_7` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_8` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_8` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_9` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_9` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_10` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_10` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_11` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_11` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_12` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_12` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_13` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_13` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_14` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_14` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_15` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_15` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_16` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_16` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_17` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_17` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_18` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_18` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_19` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_19` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_20` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_20` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_21` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_21` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_22` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_22` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_23` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_23` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_24` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_24` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_25` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_25` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_26` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_26` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_27` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_27` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_28` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_28` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_29` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_29` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_30` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_30` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_31` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_31` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_32` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_32` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_33` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_33` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_34` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_34` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_35` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_35` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_36` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_36` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_37` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_37` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_38` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_38` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_39` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_39` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_40` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_40` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_41` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_41` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_42` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_42` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_43` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_43` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_44` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_44` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_45` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_45` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_46` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_46` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_47` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_47` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_48` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_48` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';
ALTER TABLE `baiduutil`.`file_download_log_ex_49` ADD COLUMN `requestId` VARCHAR(255) NULL COMMENT '请求id';
ALTER TABLE `baiduutil`.`file_download_log_ex_49` ADD COLUMN `regionCode` VARCHAR(255) NULL COMMENT '区域代码';

-- 添加索引优化查询性能
-- 1. fileUrl字段索引（主要查询字段）
ALTER TABLE `baiduutil`.`file_download_log_ex_0` ADD INDEX `idx_fileUrl_0`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_1` ADD INDEX `idx_fileUrl_1`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_2` ADD INDEX `idx_fileUrl_2`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_3` ADD INDEX `idx_fileUrl_3`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_4` ADD INDEX `idx_fileUrl_4`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_5` ADD INDEX `idx_fileUrl_5`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_6` ADD INDEX `idx_fileUrl_6`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_7` ADD INDEX `idx_fileUrl_7`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_8` ADD INDEX `idx_fileUrl_8`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_9` ADD INDEX `idx_fileUrl_9`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_10` ADD INDEX `idx_fileUrl_10`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_11` ADD INDEX `idx_fileUrl_11`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_12` ADD INDEX `idx_fileUrl_12`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_13` ADD INDEX `idx_fileUrl_13`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_14` ADD INDEX `idx_fileUrl_14`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_15` ADD INDEX `idx_fileUrl_15`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_16` ADD INDEX `idx_fileUrl_16`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_17` ADD INDEX `idx_fileUrl_17`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_18` ADD INDEX `idx_fileUrl_18`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_19` ADD INDEX `idx_fileUrl_19`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_20` ADD INDEX `idx_fileUrl_20`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_21` ADD INDEX `idx_fileUrl_21`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_22` ADD INDEX `idx_fileUrl_22`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_23` ADD INDEX `idx_fileUrl_23`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_24` ADD INDEX `idx_fileUrl_24`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_25` ADD INDEX `idx_fileUrl_25`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_26` ADD INDEX `idx_fileUrl_26`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_27` ADD INDEX `idx_fileUrl_27`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_28` ADD INDEX `idx_fileUrl_28`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_29` ADD INDEX `idx_fileUrl_29`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_30` ADD INDEX `idx_fileUrl_30`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_31` ADD INDEX `idx_fileUrl_31`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_32` ADD INDEX `idx_fileUrl_32`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_33` ADD INDEX `idx_fileUrl_33`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_34` ADD INDEX `idx_fileUrl_34`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_35` ADD INDEX `idx_fileUrl_35`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_36` ADD INDEX `idx_fileUrl_36`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_37` ADD INDEX `idx_fileUrl_37`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_38` ADD INDEX `idx_fileUrl_38`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_39` ADD INDEX `idx_fileUrl_39`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_40` ADD INDEX `idx_fileUrl_40`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_41` ADD INDEX `idx_fileUrl_41`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_42` ADD INDEX `idx_fileUrl_42`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_43` ADD INDEX `idx_fileUrl_43`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_44` ADD INDEX `idx_fileUrl_44`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_45` ADD INDEX `idx_fileUrl_45`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_46` ADD INDEX `idx_fileUrl_46`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_47` ADD INDEX `idx_fileUrl_47`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_48` ADD INDEX `idx_fileUrl_48`(`fileUrl`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_49` ADD INDEX `idx_fileUrl_49`(`fileUrl`) USING BTREE;

-- 2. md5字段索引（用于去重查询）
ALTER TABLE `baiduutil`.`file_download_log_ex_0` ADD INDEX `idx_md5_0`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_1` ADD INDEX `idx_md5_1`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_2` ADD INDEX `idx_md5_2`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_3` ADD INDEX `idx_md5_3`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_4` ADD INDEX `idx_md5_4`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_5` ADD INDEX `idx_md5_5`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_6` ADD INDEX `idx_md5_6`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_7` ADD INDEX `idx_md5_7`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_8` ADD INDEX `idx_md5_8`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_9` ADD INDEX `idx_md5_9`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_10` ADD INDEX `idx_md5_10`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_11` ADD INDEX `idx_md5_11`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_12` ADD INDEX `idx_md5_12`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_13` ADD INDEX `idx_md5_13`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_14` ADD INDEX `idx_md5_14`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_15` ADD INDEX `idx_md5_15`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_16` ADD INDEX `idx_md5_16`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_17` ADD INDEX `idx_md5_17`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_18` ADD INDEX `idx_md5_18`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_19` ADD INDEX `idx_md5_19`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_20` ADD INDEX `idx_md5_20`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_21` ADD INDEX `idx_md5_21`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_22` ADD INDEX `idx_md5_22`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_23` ADD INDEX `idx_md5_23`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_24` ADD INDEX `idx_md5_24`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_25` ADD INDEX `idx_md5_25`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_26` ADD INDEX `idx_md5_26`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_27` ADD INDEX `idx_md5_27`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_28` ADD INDEX `idx_md5_28`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_29` ADD INDEX `idx_md5_29`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_30` ADD INDEX `idx_md5_30`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_31` ADD INDEX `idx_md5_31`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_32` ADD INDEX `idx_md5_32`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_33` ADD INDEX `idx_md5_33`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_34` ADD INDEX `idx_md5_34`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_35` ADD INDEX `idx_md5_35`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_36` ADD INDEX `idx_md5_36`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_37` ADD INDEX `idx_md5_37`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_38` ADD INDEX `idx_md5_38`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_39` ADD INDEX `idx_md5_39`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_40` ADD INDEX `idx_md5_40`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_41` ADD INDEX `idx_md5_41`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_42` ADD INDEX `idx_md5_42`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_43` ADD INDEX `idx_md5_43`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_44` ADD INDEX `idx_md5_44`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_45` ADD INDEX `idx_md5_45`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_46` ADD INDEX `idx_md5_46`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_47` ADD INDEX `idx_md5_47`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_48` ADD INDEX `idx_md5_48`(`md5`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_49` ADD INDEX `idx_md5_49`(`md5`) USING BTREE;

-- 3. requestId和regionCode字段索引
ALTER TABLE `baiduutil`.`file_download_log_ex_0` ADD INDEX `idx_requestId_0`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_0` ADD INDEX `idx_regionCode_0`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_1` ADD INDEX `idx_requestId_1`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_1` ADD INDEX `idx_regionCode_1`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_2` ADD INDEX `idx_requestId_2`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_2` ADD INDEX `idx_regionCode_2`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_3` ADD INDEX `idx_requestId_3`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_3` ADD INDEX `idx_regionCode_3`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_4` ADD INDEX `idx_requestId_4`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_4` ADD INDEX `idx_regionCode_4`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_5` ADD INDEX `idx_requestId_5`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_5` ADD INDEX `idx_regionCode_5`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_6` ADD INDEX `idx_requestId_6`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_6` ADD INDEX `idx_regionCode_6`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_7` ADD INDEX `idx_requestId_7`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_7` ADD INDEX `idx_regionCode_7`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_8` ADD INDEX `idx_requestId_8`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_8` ADD INDEX `idx_regionCode_8`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_9` ADD INDEX `idx_requestId_9`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_9` ADD INDEX `idx_regionCode_9`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_10` ADD INDEX `idx_requestId_10`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_10` ADD INDEX `idx_regionCode_10`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_11` ADD INDEX `idx_requestId_11`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_11` ADD INDEX `idx_regionCode_11`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_12` ADD INDEX `idx_requestId_12`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_12` ADD INDEX `idx_regionCode_12`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_13` ADD INDEX `idx_requestId_13`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_13` ADD INDEX `idx_regionCode_13`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_14` ADD INDEX `idx_requestId_14`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_14` ADD INDEX `idx_regionCode_14`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_15` ADD INDEX `idx_requestId_15`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_15` ADD INDEX `idx_regionCode_15`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_16` ADD INDEX `idx_requestId_16`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_16` ADD INDEX `idx_regionCode_16`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_17` ADD INDEX `idx_requestId_17`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_17` ADD INDEX `idx_regionCode_17`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_18` ADD INDEX `idx_requestId_18`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_18` ADD INDEX `idx_regionCode_18`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_19` ADD INDEX `idx_requestId_19`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_19` ADD INDEX `idx_regionCode_19`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_20` ADD INDEX `idx_requestId_20`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_20` ADD INDEX `idx_regionCode_20`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_21` ADD INDEX `idx_requestId_21`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_21` ADD INDEX `idx_regionCode_21`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_22` ADD INDEX `idx_requestId_22`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_22` ADD INDEX `idx_regionCode_22`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_23` ADD INDEX `idx_requestId_23`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_23` ADD INDEX `idx_regionCode_23`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_24` ADD INDEX `idx_requestId_24`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_24` ADD INDEX `idx_regionCode_24`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_25` ADD INDEX `idx_requestId_25`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_25` ADD INDEX `idx_regionCode_25`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_26` ADD INDEX `idx_requestId_26`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_26` ADD INDEX `idx_regionCode_26`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_27` ADD INDEX `idx_requestId_27`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_27` ADD INDEX `idx_regionCode_27`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_28` ADD INDEX `idx_requestId_28`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_28` ADD INDEX `idx_regionCode_28`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_29` ADD INDEX `idx_requestId_29`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_29` ADD INDEX `idx_regionCode_29`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_30` ADD INDEX `idx_requestId_30`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_30` ADD INDEX `idx_regionCode_30`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_31` ADD INDEX `idx_requestId_31`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_31` ADD INDEX `idx_regionCode_31`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_32` ADD INDEX `idx_requestId_32`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_32` ADD INDEX `idx_regionCode_32`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_33` ADD INDEX `idx_requestId_33`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_33` ADD INDEX `idx_regionCode_33`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_34` ADD INDEX `idx_requestId_34`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_34` ADD INDEX `idx_regionCode_34`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_35` ADD INDEX `idx_requestId_35`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_35` ADD INDEX `idx_regionCode_35`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_36` ADD INDEX `idx_requestId_36`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_36` ADD INDEX `idx_regionCode_36`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_37` ADD INDEX `idx_requestId_37`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_37` ADD INDEX `idx_regionCode_37`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_38` ADD INDEX `idx_requestId_38`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_38` ADD INDEX `idx_regionCode_38`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_39` ADD INDEX `idx_requestId_39`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_39` ADD INDEX `idx_regionCode_39`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_40` ADD INDEX `idx_requestId_40`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_40` ADD INDEX `idx_regionCode_40`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_41` ADD INDEX `idx_requestId_41`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_41` ADD INDEX `idx_regionCode_41`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_42` ADD INDEX `idx_requestId_42`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_42` ADD INDEX `idx_regionCode_42`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_43` ADD INDEX `idx_requestId_43`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_43` ADD INDEX `idx_regionCode_43`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_44` ADD INDEX `idx_requestId_44`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_44` ADD INDEX `idx_regionCode_44`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_45` ADD INDEX `idx_requestId_45`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_45` ADD INDEX `idx_regionCode_45`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_46` ADD INDEX `idx_requestId_46`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_46` ADD INDEX `idx_regionCode_46`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_47` ADD INDEX `idx_requestId_47`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_47` ADD INDEX `idx_regionCode_47`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_48` ADD INDEX `idx_requestId_48`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_48` ADD INDEX `idx_regionCode_48`(`regionCode`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_49` ADD INDEX `idx_requestId_49`(`requestId`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_49` ADD INDEX `idx_regionCode_49`(`regionCode`) USING BTREE;

-- 4. 组合索引(md5, createTime)用于优化带时间条件的md5查询
ALTER TABLE `baiduutil`.`file_download_log_ex_0` ADD INDEX `idx_md5_createTime_0`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_1` ADD INDEX `idx_md5_createTime_1`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_2` ADD INDEX `idx_md5_createTime_2`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_3` ADD INDEX `idx_md5_createTime_3`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_4` ADD INDEX `idx_md5_createTime_4`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_5` ADD INDEX `idx_md5_createTime_5`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_6` ADD INDEX `idx_md5_createTime_6`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_7` ADD INDEX `idx_md5_createTime_7`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_8` ADD INDEX `idx_md5_createTime_8`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_9` ADD INDEX `idx_md5_createTime_9`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_10` ADD INDEX `idx_md5_createTime_10`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_11` ADD INDEX `idx_md5_createTime_11`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_12` ADD INDEX `idx_md5_createTime_12`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_13` ADD INDEX `idx_md5_createTime_13`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_14` ADD INDEX `idx_md5_createTime_14`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_15` ADD INDEX `idx_md5_createTime_15`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_16` ADD INDEX `idx_md5_createTime_16`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_17` ADD INDEX `idx_md5_createTime_17`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_18` ADD INDEX `idx_md5_createTime_18`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_19` ADD INDEX `idx_md5_createTime_19`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_20` ADD INDEX `idx_md5_createTime_20`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_21` ADD INDEX `idx_md5_createTime_21`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_22` ADD INDEX `idx_md5_createTime_22`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_23` ADD INDEX `idx_md5_createTime_23`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_24` ADD INDEX `idx_md5_createTime_24`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_25` ADD INDEX `idx_md5_createTime_25`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_26` ADD INDEX `idx_md5_createTime_26`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_27` ADD INDEX `idx_md5_createTime_27`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_28` ADD INDEX `idx_md5_createTime_28`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_29` ADD INDEX `idx_md5_createTime_29`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_30` ADD INDEX `idx_md5_createTime_30`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_31` ADD INDEX `idx_md5_createTime_31`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_32` ADD INDEX `idx_md5_createTime_32`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_33` ADD INDEX `idx_md5_createTime_33`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_34` ADD INDEX `idx_md5_createTime_34`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_35` ADD INDEX `idx_md5_createTime_35`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_36` ADD INDEX `idx_md5_createTime_36`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_37` ADD INDEX `idx_md5_createTime_37`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_38` ADD INDEX `idx_md5_createTime_38`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_39` ADD INDEX `idx_md5_createTime_39`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_40` ADD INDEX `idx_md5_createTime_40`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_41` ADD INDEX `idx_md5_createTime_41`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_42` ADD INDEX `idx_md5_createTime_42`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_43` ADD INDEX `idx_md5_createTime_43`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_44` ADD INDEX `idx_md5_createTime_44`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_45` ADD INDEX `idx_md5_createTime_45`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_46` ADD INDEX `idx_md5_createTime_46`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_47` ADD INDEX `idx_md5_createTime_47`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_48` ADD INDEX `idx_md5_createTime_48`(`md5`,`createTime`) USING BTREE;
ALTER TABLE `baiduutil`.`file_download_log_ex_49` ADD INDEX `idx_md5_createTime_49`(`md5`,`createTime`) USING BTREE;

-- 更新视图，添加requestId和regionCode字段
DROP VIEW IF EXISTS `baiduutil`.`v_file_download_log_all`;

CREATE ALGORITHM=UNDEFINED DEFINER=`bcx`@`%` SQL SECURITY DEFINER VIEW `baiduutil`.`v_file_download_log_all` AS 
select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_0` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_1` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_2` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_3` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_4` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_5` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_6` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_7` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_8` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_9` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_10` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_11` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_12` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_13` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_14` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_15` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_16` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_17` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_18` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_19` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_20` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_21` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_22` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_23` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_24` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_25` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_26` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_27` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_28` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_29` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_30` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_31` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_32` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_33` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_34` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_35` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_36` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_37` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_38` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_39` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_40` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_41` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_42` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_43` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_44` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_45` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_46` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_47` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_48` 
union all select id, createTime, md5, fileUrl, requestId, regionCode from `baiduutil`.`file_download_log_ex_49`;

-- 为pull_record表添加updateTime字段
ALTER TABLE `baiduutil`.`pull_record` ADD COLUMN `update_time` DATETIME NULL COMMENT '更新时间' AFTER `create_time`;

