Created
June 18, 2012 02:16
-
-
Save 1900/2946434 to your computer and use it in GitHub Desktop.
Revisions
-
1900 revised this gist
Jun 18, 2012 . 1 changed file with 47 additions and 198 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,203 +1,52 @@ CREATE TABLE IF NOT EXISTS `comds` ( `id` int(11) NOT NULL COMMENT 'lookup', `TotalExp` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TotalExp', `FirstLoginTime` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'FirstLoginTime', `FirstLogin` date DEFAULT NULL COMMENT 'lookup', `TotalDollorGet` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TotalDollorGet', `TodayGameTime` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TodayGameTime', `TodayTCrystalLose` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TodayTCrystalLose', `Crystal` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'Crystal', `TodayGoldGet` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TodayGoldGet', `TodayGoldLose` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TodayGoldLose', `Cracked` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'Cracked', `WeaponList` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'WeaponList', `TodayExp` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TodayExp', `TodayIapInfo` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TodayIapInfo', `099cents1` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `099cents2` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `new499cents1` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `new499cents2` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `new999cents1` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `new999cents2` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `new1999cents1` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `new1999cents2` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `new4999cents1` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `new4999cents2` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `ChoosePointsUI` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'ChoosePointsUI', `ShopUI_Weapon` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'ShopUI_Weapon', `ShopUI_Avatar` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'ShopUI_Avatar', `ShopUI_PowerUPS` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'ShopUI_PowerUPS', `ShopUI_Bank` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'ShopUI_Bank', `BoostUI_Skill` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'BoostUI_Skill', `TeamUI_Friend` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TeamUI_Friend', `TeamUI_MERC` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TeamUI_MERC', `MERC_UI` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'MERC_UI', `OptionUI` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'OptionUI', `BattleUI_Pause` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'BattleUI_Pause', `BattleUI_Item` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'BattleUI_Item', `BattleUI_Dead` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'BattleUI_Dead', `ExchangeUI` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'ExchangeUI', `Gold` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'Gold', `Level` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `GameActiveTime` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'GameActiveTime', `TotalGoldGet` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TotalGoldGet', `UILastId` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'UILastId', `HireoutSelfTimes` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'HireoutSelfTimes', `TotalGameTime` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TotalGameTime', `TodayTCrystalGet` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TodayTCrystalGet', `deviceid` varchar(128) COLLATE utf8_bin DEFAULT '0' COMMENT 'lookup', `gamename` varchar(24) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'gamename', `createdate` datetime DEFAULT NULL COMMENT 'createdate', `date` date NOT NULL COMMENT 'lookup' ) ENGINE=BRIGHTHOUSE DEFAULT CHARSET=utf8 ; -
Jun 18, 2012 .There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,203 @@ CREATE TABLE IF NOT EXISTS `hero` ( `id` int(11) NOT NULL COMMENT 'lookup', `cents099` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `Cents1999` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `Cents499` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `Cents4999` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `Cents9999` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `IAPMoney` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `allGameTime` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'allGameTime', `allGetMoney` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'allGetMoney', `ruleInfos_107` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'ruleInfos_107', `battleGroundLevelInfos_3` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'battleGroundLevelInfos_3', `equipInfos_level` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '装备等级', `equipInfos` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '装备索引', `roleClassInfos_battleTimes` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '此职业参战次数', `roleClassInfos_count` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '拥有此职业数量', `roleClassInfos_roleClass` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '职业名称', `heroData_0_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_0_level` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `heroData_0_todayGetExp` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色今日获得经验', `heroData_0` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色索引', `heroData_1_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_1_level` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `heroData_1_todayGetExp` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色今日获得经验', `heroData_1` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色索引', `heroData_2_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_2_level` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `heroData_2_todayGetExp` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色今日获得经验', `heroData_2` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色索引', `heroData_3_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_3_level` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `heroData_3_todayGetExp` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色今日获得经验', `heroData_3` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色索引', `heroData_4_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_4_level` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup', `heroData_4_todayGetExp` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色今日获得经验', `heroData_4` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色索引', `heroData_5_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_5_level` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色当前等级', `heroData_5_todayGetExp` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色今日获得经验', `heroData_5` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色索引', `heroData_6_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_6_level` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色当前等级', `heroData_6_todayGetExp` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色今日获得经验', `heroData_6` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色索引', `heroData_7_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_7_level` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色当前等级', `heroData_7_todayGetExp` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色今日获得经验', `heroData_7` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色索引', `heroData_8_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_8_level` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色当前等级', `heroData_8_todayGetExp` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色今日获得经验', `heroData_8` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色索引', `heroData_9_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_9_level` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色当前等级', `heroData_9_todayGetExp` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色今日获得经验', `heroData_9` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色索引', `heroData_10_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_10_level` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色当前等级', `heroData_10_todayGetExp` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色今日获得经验', `heroData_10` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色索引', `heroData_11_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_11_level` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '角色当前等级', `heroData_11_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_11` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_12_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_12_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_12_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_12` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_13_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_13_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_13_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_13` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_14_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_14_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_14_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_14` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_15_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_15_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_15_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_15` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_16_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_16_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_16_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_16` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_17_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_17_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_17_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_17` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_18_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_18_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_18_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_18` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_19_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_19_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_19_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_19` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_20_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_20_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_20_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_20` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_21_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_21_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_21_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_21` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_22_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_22_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_22_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_22` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_23_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_23_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_23_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_23` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_24_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_24_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_24_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_24` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_25_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_25_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_25_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_25` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_26_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_26_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_26_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_26` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_27_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_27_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_27_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_27` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_28_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_28_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_28_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_28` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_29_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_29_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_29_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_29` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_30_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_30_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_30_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_30` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_31_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_31_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_31_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_31` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `heroData_32_currentEquips` text COLLATE utf8_bin NOT NULL COMMENT '角色当前穿着装备', `heroData_32_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色当前等级', `heroData_32_todayGetExp` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色今日获得经验', `heroData_32` char(12) COLLATE utf8_bin NOT NULL COMMENT '角色索引', `roleClassData_Barbarian_roleClass` char(12) COLLATE utf8_bin NOT NULL COMMENT '职业名称', `roleClassData_Barbarian_count` char(12) COLLATE utf8_bin NOT NULL COMMENT '拥有此职业数量', `roleClassData_Barbarian_battleTimes` char(12) COLLATE utf8_bin NOT NULL COMMENT '此职业参战次数', `roleClassData_Fighter_roleClass` char(12) COLLATE utf8_bin NOT NULL COMMENT '职业名称', `roleClassData_Fighter_count` char(12) COLLATE utf8_bin NOT NULL COMMENT '拥有此职业数量', `roleClassData_Fighter_battleTimes` char(12) COLLATE utf8_bin NOT NULL COMMENT '此职业参战次数', `roleClassData_Paladin_roleClass` char(12) COLLATE utf8_bin NOT NULL COMMENT '职业名称', `roleClassData_Paladin_count` char(12) COLLATE utf8_bin NOT NULL COMMENT '拥有此职业数量', `roleClassData_Paladin_battleTimes` char(12) COLLATE utf8_bin NOT NULL COMMENT '此职业参战次数', `battleInfos_retreatTimes` char(12) COLLATE utf8_bin NOT NULL COMMENT '今日被挑战关卡中途退出次数', `battleInfos_faildTimes` char(12) COLLATE utf8_bin NOT NULL COMMENT '今日被挑战关卡失败次数', `battleInfos_winTimes` char(12) COLLATE utf8_bin NOT NULL COMMENT '今日被挑战关卡成功次数', `battleInfos_totalTimes` char(12) COLLATE utf8_bin NOT NULL COMMENT '今日被挑战关卡总次数', `battleInfos_level` char(12) COLLATE utf8_bin NOT NULL COMMENT '今日被挑战关卡等级', `battleInfos` char(12) COLLATE utf8_bin NOT NULL COMMENT '今日被挑战关卡', `wavesEachTime` char(12) COLLATE utf8_bin NOT NULL COMMENT 'wavesEachTime', `survivalBattleTimes` char(12) COLLATE utf8_bin NOT NULL COMMENT 'survivalBattleTimes', `hireHeroCost` char(12) COLLATE utf8_bin NOT NULL COMMENT 'hireHeroCost', `hireHeroTimes` char(12) COLLATE utf8_bin NOT NULL COMMENT 'hireHeroTimes', `upgradeCost` char(12) COLLATE utf8_bin NOT NULL COMMENT 'upgradeCost', `upgradeTimes` char(12) COLLATE utf8_bin NOT NULL COMMENT 'upgradeTimes', `shopRefreshCost` char(12) COLLATE utf8_bin NOT NULL COMMENT 'shopRefreshCost', `shopRefreshTimes` char(12) COLLATE utf8_bin NOT NULL COMMENT 'shopRefreshTimes', `buyEquipCost` char(12) COLLATE utf8_bin NOT NULL COMMENT 'buyEquipCost', `buyEquipTimes` char(12) COLLATE utf8_bin NOT NULL COMMENT 'buyEquipTimes', `resetSkillCost` char(12) COLLATE utf8_bin NOT NULL COMMENT 'resetSkillCost', `resetSkillTimes` char(12) COLLATE utf8_bin NOT NULL COMMENT 'resetSkillTimes', `todaySaleEquips` char(12) COLLATE utf8_bin NOT NULL COMMENT 'todaySaleEquips', `todayBuyEquips` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'todayBuyEquips', `teamMemberClass` varchar(52) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'teamMemberClass', `launchFromNotification` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'launchFromNotification', `exitWhichBattleGround` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'exitWhichBattleGround', `exitWhichScreen` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'exitWhichScreen', `todayOpenTimes` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'todayOpenTimes', `openTimes` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'openTimes', `arenaTotalOpenTimes` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '竞技场开启总次数', `arenaTodayOpenTimes` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '今日竞技场启动次数', `arenaTotalGameTime` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '竞技场总游戏时间', `arenaTodayGameTime` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '今日竞技场游戏时间', `arenaTodayLobbyChallengeTimes` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '今日竞技场主页面发起挑战次数', `arenaTodayLobbyChallengeWinTimes` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '今日竞技场主页面发起挑战胜利次数', `arenaTodayReportChallengeTimes` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '今日昨日挑战页面发起挑战次数', `arenaTodayReportChallengeWinTimes` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '今日昨日挑战页面发起挑战胜利次数', `arenaTodayScoutTimes` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '今日侦查次数', `arenaTotalGetBadges` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '令牌总获得数', `arenaTodayGetBadges` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '今日令牌获得数', `todayGameTime` char(12) COLLATE utf8_bin NOT NULL COMMENT 'todayGameTime', `registerDate` date NOT NULL COMMENT 'lookup', `versionNum` char(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'versionNum', `deviceid` varchar(128) COLLATE utf8_bin DEFAULT '0' COMMENT 'lookup', `gamename` varchar(12) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'gamename', `createdate` datetime DEFAULT NULL COMMENT 'createdate', `date` date NOT NULL COMMENT 'lookup' ) ENGINE=BRIGHTHOUSE DEFAULT CHARSET=utf8 ;