local SqlUrl ={}

--中心服
SqlUrl.selectClusterConfig = "select *  from cluster_config"                    --集群配置
SqlUrl.selectServerConfig = "select *  from server_config"
SqlUrl.insertServerConfig = "insert into server_config(ServerName,Config) value('%s','%s')"
SqlUrl.updateServerConfig = "update server_config set Config = '%s' where ServerName = '%s'"
SqlUrl.selectPlatform = "select * from platform"    --获取所有平台信息
SqlUrl.insertPlatform = "insert into platform(Name , Status ) values('%s' , %d )"          --插入平台类型
SqlUrl.updatePlatformStatus = "update platform set Status = %d where Name = '%s'"      --更新平台状态
SqlUrl.insertErrorInfoToCenter = "insert into server_error_info(ServerID , ErrorCode , ErrorText) values(%d , %d ,  '%s')"
SqlUrl.insertClusterInfoToCenter = "insert into record_cluster_info(ClusterInfo) values('%s')"
SqlUrl.queryClusterInfo = "select JSON_EXTRACT(record_cluster_info.ClusterInfo,'$[*].serverInfo.playerCount') from record_cluster_info where record_cluster_info.CreateTime >= '%s' and record_cluster_info.CreateTime <= '%s'"     --查询集群信息

--游戏服
--错误记录
SqlUrl.insertErrorInfo = "insert into error( UserID , ErrorCode , ErrorInfo ) values ( %d , %d , \"%s\" )"

--管理员
SqlUrl.selectAdminFromAdministrators = "select * from administrators where Account = '%s' and Pwd = '%s'"

--活动
SqlUrl.selectInfoFromActivity = "select * from activity"
SqlUrl.insertInfoToActivity = "insert into activity(ID , Type , StartTime , EndTime , Status) values(%d , %d , %d , %d , %d)"     --插入游戏数据
SqlUrl.updateStatusToActivity = "update activity set Status = %d where ID = %d"             --更新状态
SqlUrl.deleteInfoFromActivity = "delete from activity where ID =%d"             --删除活动

--兑换列表
SqlUrl.selectInfoFromRedeemList = "select * from redeem_list where Status <= %d"
SqlUrl.insertInfoToRedeemList = "insert into redeem_list(Code , Status , Data) values('%s' , %d , '%s')"     --插入兑换列表
SqlUrl.updateDataToRedeemList = "update redeem_list set Data = '%s' where Code = '%s'"             --更新兑换列表
SqlUrl.updateStatusToRedeemList = "update redeem_list set Status = %d , BonusPlayerCount = %d where Code = '%s'"             --更新兑换列表
SqlUrl.deleteInfoFromRedeemList = "delete from redeem_list where Code ='%s'"             --删除兑换列表
SqlUrl.insertInfoToRedeemBonusRecord = "insert into redeem_bonus_record(UserID , RedeemCode , Bonus) values(%d , '%s' , '%s')"

--邮件模版
SqlUrl.selectInfoFromMailTemplate = "select * from mail_template"
SqlUrl.insertInfoToMailTemplate = "insert into mail_template(ID , Name , Data) values(%d , '%s' , '%s')"     --插入邮件模板
SqlUrl.updateDataToMailTemplate = "update mail_template set Data = '%s' where Name = '%s'"             --更新邮件模板
SqlUrl.deleteInfoFromMailTemplate = "delete from mail_template where  Name = '%s'"             --删除邮件模板

--邮件列表
SqlUrl.selectInfoFromMailList = "select * from mail_list where Status <= %d"
SqlUrl.insertInfoToMailList = "insert into mail_list(ID , Status , Data) values(%d , %d , '%s')"     --插入邮件列表
SqlUrl.updateDataToMailList = "update mail_list set Data = '%s' where ID = %d"             --更新邮件列表
SqlUrl.updateStatusToMailList = "update mail_list set Status = %d , BonusPlayerCount = %d where ID = %d"             --更新邮件列表
SqlUrl.deleteInfoFromMailList = "delete from mail_list where ID =%d"             --删除邮件列表
SqlUrl.insertInfoToMailBonusRecord = "insert into mail_bonus_record(UserID , MailID , Bonus) values(%d , %d , '%s')"

--玩家数据记录
SqlUrl.createPlayerRecord = "create table  if not exists  `data_record_%04d_%02d_%02d`  (`UserID` int(11) not null comment '玩家id',`Type` int(11) not null,  \
                                                `Data` json null,`RecordTime` datetime(0) null default current_timestamp(0) on update current_timestamp(0) comment '记录时间',index `indexuserid`(`UserID`) using btree  \
                                                 ) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;"    --创建玩家记录表  
SqlUrl.dropPlayerRecord = "drop table `data_record_%04d_%02d_%02d`"                         --删除玩家记录表
SqlUrl.insertRecordToPlayerRecord1= "insert into data_record_%04d_%02d_%02d(UserID , Type , Data) values"          --插入记录到玩家记录1
SqlUrl.insertRecordToPlayerRecord2= "(%d , %d , '%s') ,"                    --插入记录到玩家记录2

--帐号服
SqlUrl.insertUserDBIndexToUser = "insert into user( UserID , Platform , Account , DBIndex ) value(%d , '%s', '%s', %d)"
SqlUrl.deleteUserDBIndexToUser = "delete from user where UserID =%d"
--SqlUrl.queryAccountFromPlayer = "select * from player where Platform = '%s' and Account = '%s'"                                                                              --查询用户表的帐号
SqlUrl.queryAccountFromPlayer = "select * from player where UserID =%d"                                                                              --查询用户表的帐号
SqlUrl.insertAccountToPlayer = "insert into player( UserID , Account , Platform , BasicInfo , GameData , ArchiveData) values(%d , '%s' , '%s' , '%s' , '%s', '%s')"                                         --新增用户到玩家表
SqlUrl.saveAccountToPlayer = "update player set BasicInfo ='%s' , GameData ='%s'  , ArchiveData ='%s' where UserID = %d"                            --保存用户数据
 
--榜单服
SqlUrl.updateScoreToPersonalRank = "insert into PersonalRank(UserID , Score) value(%d , %d) on duplicate key update score = %d"          --更新分数到个人榜
SqlUrl.updateScoreToPrestigeRank = "insert into PrestigeRank(UserID , Score) value(%d , %d) on duplicate key update score = %d"          --更新分数到声望榜
SqlUrl.updateScoreToCountryRank = "insert into CountryRank(UserID , Type, Score) value(%d  , %d , %d) on duplicate key update score = %d"          --更新分数到国家榜
return SqlUrl