game-sdk/data/sql/update_20210816.sql

ALTER TABLE `h_mem_game`
    ADD INDEX `mg_createtime_index`(`create_time`);

ALTER TABLE `h_mg_role`
    ADD INDEX `mgr_createtime_index`(`create_time`);

ALTER TABLE `h_mem_game`
    ADD INDEX `mg_guidedagent_index`(`guided_agent_id`);

ALTER TABLE `h_mem_ext`
    ADD INDEX `me_summoney_index`(`sum_money`),
ADD INDEX `me_logintime_index`(`last_login_time`);


ALTER TABLE `h_log_mem_login_202108`
    ADD INDEX `lml_mem_index`(`mem_id`);


ALTER TABLE `h_mem_game`
    ADD COLUMN `sum_money` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '累计充值' AFTER `status`;

ALTER TABLE `h_mem_game`
    ADD INDEX `mg_summoney_index`(`sum_money`);