YES8

use p1_game_oc;
drop table if exists game_oc_agent_prize_info;
create table game_oc_agent_prize_info(
id bigint auto_increment primary key,
agent_info_pkid bigint,
turnover_rank int,
prize_info varchar(500),
prize_code varchar(50),
month varchar(10),
index query_idx(agent_info_pkid, month),
unique prize_info_uk(agent_info_pkid, turnover_rank)
);

drop table if exists game_oc_agent_prize_style;
create table game_oc_agent_prize_style(
id bigint auto_increment primary key,
agent_info_pkid bigint,
style_info text,
index agent_info_pkid_idx(agent_info_pkid),
unique agent_info_uk(agent_info_pkid)
);

drop table if exists game_oc_turnover_month_info;
create table game_oc_turnover_month_info(
agent_info_pkid bigint,
month varchar(50),
index turnover_month_info_idx(month)
unique turnover_month_info_uk(agent_info_pkid, month)
);