
--
-- Table structure for table `data_tutorial_data`
--

CREATE TABLE `data_tutorial_data` (
  `general_type_code` int(11) DEFAULT NULL,
  `quest_type` int(11) DEFAULT NULL,
  `group_index` int(11) DEFAULT NULL,
  `complete_index` int(11) DEFAULT NULL,
  `quest_need_level` int(11) DEFAULT NULL,
  `previous_tutorial_step_code` int(11) DEFAULT NULL,
  `reward_item_info` int(11) DEFAULT NULL,
  `reward_item_count` int(11) DEFAULT NULL,
  `skip_state` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `data_tutorial_data`
--

INSERT INTO `data_tutorial_data` VALUES (1000001,1,1001,-1,1,-1,-1,0,-1),(1000002,1,1001,-1,1,1000001,-1,0,-1),(1000003,1,1001,-1,1,1000002,-1,0,-1),(1000004,1,1001,-1,1,1000003,-1,0,-1),(1000005,1,1001,-1,1,1000004,-1,0,-1),(1000006,1,1001,-1,1,1000005,-1,0,-1),(1000007,1,1001,1001,1,1000006,-1,0,-1),(1000008,1,1001,-1,1,1000007,-1,0,-1),(1000009,1,1001,-1,1,1000008,-1,0,-1),(1000010,1,1002,-1,1,1000009,-1,0,-1),(1000011,1,1002,-1,1,1000010,-1,0,-1),(1000012,1,1002,-1,1,1000011,-1,0,-1),(1000013,1,1002,-1,1,1000012,-1,0,-1),(1000014,1,1002,-1,1,1000013,-1,0,-1),(1000015,1,1002,-1,1,1000014,-1,0,-1),(1000016,1,1002,-1,1,1000015,-1,0,-1),(1000017,1,1002,-1,1,1000016,-1,0,-1),(1000018,1,1002,-1,1,1000017,-1,0,-1),(1000019,1,1002,-1,1,1000018,-1,0,-1),(1000020,1,1002,-1,1,1000019,-1,0,-1),(1000021,1,1002,-1,1,1000020,-1,0,-1),(1000022,1,1002,-1,1,1000021,-1,0,-1),(1000023,1,1002,-1,1,1000022,-1,0,-1),(1000024,1,1002,1002,1,1000023,-1,0,-1),(1000025,1,1002,-1,1,1000024,-1,0,-1),(1000026,1,1003,1003,1,1000025,156101000,1,1),(1000027,1,1004,-1,1,1000026,-1,0,-1),(1000028,1,1004,-1,1,1000027,-1,0,1),(1000029,1,1004,1004,1,1000028,-1,0,-1),(1000030,1,1004,-1,1,1000029,-1,0,-1),(1000031,1,1005,-1,1,1000030,-1,0,1),(1000032,1,1005,-1,1,1000031,-1,0,-1),(1000033,1,1005,-1,1,1000032,-1,0,-1),(1000034,1,1005,-1,1,1000033,-1,0,-1),(1000035,1,1005,-1,1,1000034,-1,0,-1),(1000036,1,1005,1005,1,1000035,-1,0,-1),(1000037,1,1005,-1,1,1000036,-1,0,-1),(1000038,1,1006,-1,1,1000037,-1,0,-1),(1000039,1,1006,-1,1,1000038,-1,0,-1),(1000040,1,1006,-1,1,1000039,-1,0,-1),(1000041,1,1006,-1,1,1000040,-1,0,-1),(1000042,1,1006,-1,1,1000041,-1,0,-1),(1000043,1,1006,-1,1,1000042,-1,0,-1),(1000044,1,1006,-1,1,1000043,-1,0,-1),(1000045,1,1006,-1,1,1000044,-1,0,-1),(1000046,1,1006,-1,1,1000045,-1,0,-1),(1000047,1,1006,-1,1,1000046,-1,0,-1),(1000048,1,1006,-1,1,1000047,-1,0,-1),(1000049,1,1006,-1,1,1000048,-1,0,-1),(1000050,1,1006,-1,1,1000049,-1,0,-1),(1000051,1,1006,-1,1,1000050,-1,0,-1),(1000052,1,1006,-1,1,1000051,-1,0,-1),(1000053,1,1006,-1,1,1000052,-1,0,-1),(1000054,1,1006,1006,1,1000053,-1,0,-1),(1000055,1,1006,-1,1,1000054,-1,0,-1),(1000056,1,1007,1007,1,1000055,-1,0,-1);

--
-- Table structure for table `data_weekly_stage`
--

CREATE TABLE `data_weekly_stage` (
  `general_type_code` int(11) DEFAULT NULL,
  `stage_type` int(11) DEFAULT NULL,
  `act_number` int(11) DEFAULT NULL,
  `stage_number_in_act` int(11) DEFAULT NULL,
  `day_of_week` int(11) DEFAULT NULL,
  `recommend_atk` int(11) DEFAULT NULL,
  `atk_ratio` float(20,3) DEFAULT NULL,
  `def_ratio` float(20,3) DEFAULT NULL,
  `stage_exp` int(11) DEFAULT NULL,
  `guardian_exp` int(11) DEFAULT NULL,
  `stage_gold` int(11) DEFAULT NULL,
  `auto_connection_skill_gold` int(11) DEFAULT NULL,
  `limit_time_second` float(20,3) DEFAULT NULL,
  `recommend_level` int(11) DEFAULT NULL,
  `reward_general_code` int(11) DEFAULT NULL,
  `reward_count_min` int(11) DEFAULT NULL,
  `reward_count_max` int(11) DEFAULT NULL,
  `entry_cost_type` int(11) DEFAULT NULL,
  `entry_cost_amount` int(11) DEFAULT NULL,
  `entry_limit_type` tinyint(1) DEFAULT NULL,
  `entry_limit_count` int(11) DEFAULT NULL,
  `boss_monster_code` int(11) DEFAULT NULL,
  `monster_level` int(11) DEFAULT NULL,
  `auto_skill_cost` int(11) DEFAULT NULL,
  `image_code` int(11) DEFAULT NULL,
  `add_reward_group_code` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `data_weekly_stage`
--

INSERT INTO `data_weekly_stage` VALUES (120501001,5,0,1,1,1315,1.000,1.000,225,225,0,100,90.000,10,3001,1,1,0,0,1,3,101000001,20,-1,544001004,9101001),(120501002,5,0,2,1,2274,1.030,1.030,274,274,0,100,90.000,15,3002,1,1,0,0,1,3,101000001,30,-1,544001004,9101002),(120501003,5,0,3,1,3934,1.060,1.060,334,334,0,100,90.000,20,3003,1,1,0,0,1,3,101000001,42,-1,544001004,9101003),(120501004,5,0,4,1,6805,1.090,1.090,407,407,0,100,90.000,30,3004,1,1,0,0,1,3,101000001,60,-1,544001004,9101004),(120501005,5,0,5,1,11772,1.120,1.120,496,496,0,100,90.000,40,3005,1,1,0,0,1,3,101000001,85,-1,544001004,9101005),(120501006,5,0,6,1,20365,1.150,1.150,605,605,0,100,90.000,50,3006,1,1,0,0,1,3,101000001,115,-1,544001004,9101006),(120502001,5,0,1,2,1315,1.000,1.000,225,225,0,100,90.000,10,3011,1,1,0,0,1,3,101000001,20,-1,544001002,9101001),(120502002,5,0,2,2,2274,1.030,1.030,274,274,0,100,90.000,15,3012,1,1,0,0,1,3,101000001,30,-1,544001002,9101002),(120502003,5,0,3,2,3934,1.060,1.060,334,334,0,100,90.000,20,3013,1,2,0,0,1,3,101000001,42,-1,544001002,9101003),(120502004,5,0,4,2,6805,1.090,1.090,407,407,0,100,90.000,30,3014,1,2,0,0,1,3,101000001,60,-1,544001002,9101004),(120502005,5,0,5,2,11772,1.120,1.120,496,496,0,100,90.000,40,3015,1,3,0,0,1,3,101000001,85,-1,544001002,9101005),(120502006,5,0,6,2,20365,1.150,1.150,605,605,0,100,90.000,50,3016,2,3,0,0,1,3,101000001,115,-1,544001002,9101006),(120503001,5,0,1,3,1315,1.000,1.000,225,225,0,100,90.000,10,3021,1,1,0,0,1,3,101000001,20,-1,544001005,9101001),(120503002,5,0,2,3,2274,1.030,1.030,274,274,0,100,90.000,15,3022,1,1,0,0,1,3,101000001,30,-1,544001005,9101002),(120503003,5,0,3,3,3934,1.060,1.060,334,334,0,100,90.000,20,3023,1,1,0,0,1,3,101000001,42,-1,544001005,9101003),(120503004,5,0,4,3,6805,1.090,1.090,407,407,0,100,90.000,30,3024,1,1,0,0,1,3,101000001,60,-1,544001005,9101004),(120503005,5,0,5,3,11772,1.120,1.120,496,496,0,100,90.000,40,3025,1,1,0,0,1,3,101000001,85,-1,544001005,9101005),(120503006,5,0,6,3,20365,1.150,1.150,605,605,0,100,90.000,50,3026,1,1,0,0,1,3,101000001,115,-1,544001005,9101006),(120504001,5,0,1,4,1315,1.000,1.000,225,225,0,100,90.000,10,3031,1,1,0,0,1,3,101000001,20,-1,544001001,9101001),(120504002,5,0,2,4,2274,1.030,1.030,274,274,0,100,90.000,15,3032,1,1,0,0,1,3,101000001,30,-1,544001001,9101002),(120504003,5,0,3,4,3934,1.060,1.060,334,334,0,100,90.000,20,3033,1,1,0,0,1,3,101000001,42,-1,544001001,9101003),(120504004,5,0,4,4,6805,1.090,1.090,407,407,0,100,90.000,30,3034,1,1,0,0,1,3,101000001,60,-1,544001001,9101004),(120504005,5,0,5,4,11772,1.120,1.120,496,496,0,100,90.000,40,3035,1,1,0,0,1,3,101000001,85,-1,544001001,9101005),(120504006,5,0,6,4,20365,1.150,1.150,605,605,0,100,90.000,50,3036,1,1,0,0,1,3,101000001,115,-1,544001001,9101006),(120505001,5,0,1,5,1315,1.000,1.000,225,225,0,100,90.000,10,3041,1,1,0,0,1,3,101000001,20,-1,544001004,9101001),(120505002,5,0,2,5,2274,1.030,1.030,274,274,0,100,90.000,15,3042,1,1,0,0,1,3,101000001,30,-1,544001004,9101002),(120505003,5,0,3,5,3934,1.060,1.060,334,334,0,100,90.000,20,3043,1,1,0,0,1,3,101000001,42,-1,544001004,9101003),(120505004,5,0,4,5,6805,1.090,1.090,407,407,0,100,90.000,30,3044,1,1,0,0,1,3,101000001,60,-1,544001004,9101004),(120505005,5,0,5,5,11772,1.120,1.120,496,496,0,100,90.000,40,3045,1,1,0,0,1,3,101000001,85,-1,544001004,9101005),(120505006,5,0,6,5,20365,1.150,1.150,605,605,0,100,90.000,50,3046,1,1,0,0,1,3,101000001,115,-1,544001004,9101006),(120506001,5,0,1,6,1315,1.000,1.000,225,225,0,100,90.000,10,3051,1,1,0,0,1,3,101000001,20,-1,544001002,9101001),(120506002,5,0,2,6,2274,1.030,1.030,274,274,0,100,90.000,15,3052,1,1,0,0,1,3,101000001,30,-1,544001002,9101002),(120506003,5,0,3,6,3934,1.060,1.060,334,334,0,100,90.000,20,3053,1,2,0,0,1,3,101000001,42,-1,544001002,9101003),(120506004,5,0,4,6,6805,1.090,1.090,407,407,0,100,90.000,30,3054,1,2,0,0,1,3,101000001,60,-1,544001002,9101004),(120506005,5,0,5,6,11772,1.120,1.120,496,496,0,100,90.000,40,3055,1,3,0,0,1,3,101000001,85,-1,544001002,9101005),(120506006,5,0,6,6,20365,1.150,1.150,605,605,0,100,90.000,50,3056,2,3,0,0,1,3,101000001,115,-1,544001002,9101006),(120507001,5,0,1,0,1315,1.000,1.000,225,225,0,100,90.000,10,3061,1,1,0,0,1,3,101000001,20,-1,544001003,9101001),(120507002,5,0,2,0,2274,1.030,1.030,274,274,0,100,90.000,15,3062,1,1,0,0,1,3,101000001,30,-1,544001003,9101002),(120507003,5,0,3,0,3934,1.060,1.060,334,334,0,100,90.000,20,3063,1,1,0,0,1,3,101000001,42,-1,544001003,9101003),(120507004,5,0,4,0,6805,1.090,1.090,407,407,0,100,90.000,30,3064,1,1,0,0,1,3,101000001,60,-1,544001003,9101004),(120507005,5,0,5,0,11772,1.120,1.120,496,496,0,100,90.000,40,3065,1,1,0,0,1,3,101000001,85,-1,544001003,9101005),(120507006,5,0,6,0,20365,1.150,1.150,605,605,0,100,90.000,50,3066,1,1,0,0,1,3,101000001,115,-1,544001003,9101006);

--
-- Table structure for table `data_weekly_stage_reward`
--

CREATE TABLE `data_weekly_stage_reward` (
  `reward_general_code` int(11) DEFAULT NULL,
  `stage_general_code` int(11) DEFAULT NULL,
  `required_class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `act` int(11) DEFAULT NULL,
  `stage_no` int(11) DEFAULT NULL,
  `general_type_code` int(11) DEFAULT NULL,
  `item_min_count` int(11) DEFAULT NULL,
  `item_max_count` int(11) DEFAULT NULL,
  `drop_rate` int(11) DEFAULT NULL,
  `equip_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `grade` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `data_weekly_stage_reward`
--

INSERT INTO `data_weekly_stage_reward` VALUES (5010101,3001,'All',0,1,160000602,1,1,100,'PromotionG','Invalid'),(5010102,3002,'All',0,2,160000602,2,2,100,'PromotionG','Invalid'),(5010103,3003,'All',0,3,160000602,3,3,100,'PromotionG','Invalid'),(5010104,3004,'All',0,4,160000602,4,4,100,'PromotionG','Invalid'),(5010105,3005,'All',0,5,160000602,5,5,100,'PromotionG','Invalid'),(5010106,3006,'All',0,6,160000602,6,6,100,'PromotionG','Invalid'),(5020101,3011,'All',0,1,160000101,2,3,25,'RuneStoneA','Normal'),(5020102,3011,'All',0,1,160000201,2,3,25,'RuneStoneD','Normal'),(5020103,3011,'All',0,1,160000301,2,3,25,'RuneStoneU','Normal'),(5020104,3011,'All',0,1,160000401,2,3,25,'RuneStoneS','Normal'),(5020201,3012,'All',0,2,160000101,2,3,18,'RuneStoneA','Normal'),(5020202,3012,'All',0,2,160000102,2,2,7,'RuneStoneA','Superior'),(5020203,3012,'All',0,2,160000201,2,3,18,'RuneStoneD','Normal'),(5020204,3012,'All',0,2,160000202,2,2,7,'RuneStoneD','Superior'),(5020205,3012,'All',0,2,160000301,2,3,18,'RuneStoneU','Normal'),(5020206,3012,'All',0,2,160000302,2,2,7,'RuneStoneU','Superior'),(5020207,3012,'All',0,2,160000401,2,3,18,'RuneStoneS','Normal'),(5020208,3012,'All',0,2,160000402,2,2,7,'RuneStoneS','Superior'),(5020301,3013,'All',0,3,160000102,2,3,10,'RuneStoneA','Superior'),(5020302,3013,'All',0,3,160000103,2,3,15,'RuneStoneA','Rare'),(5020303,3013,'All',0,3,160000202,2,3,10,'RuneStoneD','Superior'),(5020304,3013,'All',0,3,160000203,2,3,15,'RuneStoneD','Rare'),(5020305,3013,'All',0,3,160000302,2,3,10,'RuneStoneU','Superior'),(5020306,3013,'All',0,3,160000303,2,3,15,'RuneStoneU','Rare'),(5020307,3013,'All',0,3,160000402,2,3,10,'RuneStoneS','Superior'),(5020308,3013,'All',0,3,160000403,2,3,15,'RuneStoneS','Rare'),(5020401,3014,'All',0,4,160000102,3,4,8,'RuneStoneA','Superior'),(5020402,3014,'All',0,4,160000103,3,4,13,'RuneStoneA','Rare'),(5020403,3014,'All',0,4,160000104,3,3,4,'RuneStoneA','Unique'),(5020404,3014,'All',0,4,160000202,3,4,8,'RuneStoneD','Superior'),(5020405,3014,'All',0,4,160000203,3,4,13,'RuneStoneD','Rare'),(5020406,3014,'All',0,4,160000204,3,3,4,'RuneStoneD','Unique'),(5020407,3014,'All',0,4,160000302,3,4,8,'RuneStoneU','Superior'),(5020408,3014,'All',0,4,160000303,3,4,13,'RuneStoneU','Rare'),(5020409,3014,'All',0,4,160000304,3,3,4,'RuneStoneU','Unique'),(5020410,3014,'All',0,4,160000402,3,4,8,'RuneStoneS','Superior'),(5020411,3014,'All',0,4,160000403,3,4,13,'RuneStoneS','Rare'),(5020412,3014,'All',0,4,160000404,3,3,4,'RuneStoneS','Unique'),(5020501,3015,'All',0,5,160000102,3,4,8,'RuneStoneA','Superior'),(5020502,3015,'All',0,5,160000103,3,4,13,'RuneStoneA','Rare'),(5020503,3015,'All',0,5,160000104,3,3,4,'RuneStoneA','Unique'),(5020504,3015,'All',0,5,160000202,3,4,8,'RuneStoneD','Superior'),(5020505,3015,'All',0,5,160000203,3,4,13,'RuneStoneD','Rare'),(5020506,3015,'All',0,5,160000204,3,3,4,'RuneStoneD','Unique'),(5020507,3015,'All',0,5,160000302,3,4,8,'RuneStoneU','Superior'),(5020508,3015,'All',0,5,160000303,3,4,13,'RuneStoneU','Rare'),(5020509,3015,'All',0,5,160000304,3,3,4,'RuneStoneU','Unique'),(5020510,3015,'All',0,5,160000402,3,4,8,'RuneStoneS','Superior'),(5020511,3015,'All',0,5,160000403,3,4,13,'RuneStoneS','Rare'),(5020512,3015,'All',0,5,160000404,3,3,4,'RuneStoneS','Unique'),(5020601,3016,'All',0,6,160000103,3,4,4,'RuneStoneA','Rare'),(5020602,3016,'All',0,6,160000104,3,4,13,'RuneStoneA','Unique'),(5020603,3016,'All',0,6,160000105,3,3,8,'RuneStoneA','Heroic'),(5020604,3016,'All',0,6,160000203,3,4,4,'RuneStoneD','Rare'),(5020605,3016,'All',0,6,160000204,3,4,13,'RuneStoneD','Unique'),(5020606,3016,'All',0,6,160000205,3,3,8,'RuneStoneD','Heroic'),(5020607,3016,'All',0,6,160000303,3,4,4,'RuneStoneU','Rare'),(5020608,3016,'All',0,6,160000304,3,4,13,'RuneStoneU','Unique'),(5020609,3016,'All',0,6,160000305,3,3,8,'RuneStoneU','Heroic'),(5020610,3016,'All',0,6,160000403,3,4,4,'RuneStoneS','Rare'),(5020611,3016,'All',0,6,160000404,3,4,13,'RuneStoneS','Unique'),(5020612,3016,'All',0,6,160000405,3,3,8,'RuneStoneS','Heroic'),(5030101,3021,'All',0,1,160000603,1,1,100,'PromotionA','Invalid'),(5030102,3022,'All',0,2,160000603,2,2,100,'PromotionA','Invalid'),(5030103,3023,'All',0,3,160000603,3,3,100,'PromotionA','Invalid'),(5030104,3024,'All',0,4,160000603,4,4,100,'PromotionA','Invalid'),(5030105,3025,'All',0,5,160000603,5,5,100,'PromotionA','Invalid'),(5030106,3026,'All',0,6,160000603,6,6,100,'PromotionA','Invalid'),(5040101,3031,'All',0,1,160001001,2150,2257,100,'Gold','Invalid'),(5040102,3032,'All',0,2,160001001,4300,4515,100,'Gold','Invalid'),(5040103,3033,'All',0,3,160001001,8600,9030,100,'Gold','Invalid'),(5040104,3034,'All',0,4,160001001,17200,18060,100,'Gold','Invalid'),(5040105,3035,'All',0,5,160001001,34400,36120,100,'Gold','Invalid'),(5040106,3036,'All',0,6,160001001,68800,72240,100,'Gold','Invalid'),(5050101,3041,'All',0,1,160000602,1,1,100,'PromotionG','Invalid'),(5050102,3042,'All',0,2,160000602,2,2,100,'PromotionG','Invalid'),(5050103,3043,'All',0,3,160000602,3,3,100,'PromotionG','Invalid'),(5050104,3044,'All',0,4,160000602,4,4,100,'PromotionG','Invalid'),(5050105,3045,'All',0,5,160000602,5,5,100,'PromotionG','Invalid'),(5050106,3046,'All',0,6,160000602,6,6,100,'PromotionG','Invalid'),(5060101,3051,'All',0,1,160000101,2,3,25,'RuneStoneA','Normal'),(5060102,3051,'All',0,1,160000201,2,3,25,'RuneStoneD','Normal'),(5060103,3051,'All',0,1,160000301,2,3,25,'RuneStoneU','Normal'),(5060104,3051,'All',0,1,160000401,2,3,25,'RuneStoneS','Normal'),(5060201,3052,'All',0,2,160000101,2,3,18,'RuneStoneA','Normal'),(5060202,3052,'All',0,2,160000102,2,2,7,'RuneStoneA','Superior'),(5060203,3052,'All',0,2,160000201,2,3,18,'RuneStoneD','Normal'),(5060204,3052,'All',0,2,160000202,2,2,7,'RuneStoneD','Superior'),(5060205,3052,'All',0,2,160000301,2,3,18,'RuneStoneU','Normal'),(5060206,3052,'All',0,2,160000302,2,2,7,'RuneStoneU','Superior'),(5060207,3052,'All',0,2,160000401,2,3,18,'RuneStoneS','Normal'),(5060208,3052,'All',0,2,160000402,2,2,7,'RuneStoneS','Superior'),(5060301,3053,'All',0,3,160000102,2,3,10,'RuneStoneA','Superior'),(5060302,3053,'All',0,3,160000103,2,3,15,'RuneStoneA','Rare'),(5060303,3053,'All',0,3,160000202,2,3,10,'RuneStoneD','Superior'),(5060304,3053,'All',0,3,160000203,2,3,15,'RuneStoneD','Rare'),(5060305,3053,'All',0,3,160000302,2,3,10,'RuneStoneU','Superior'),(5060306,3053,'All',0,3,160000303,2,3,15,'RuneStoneU','Rare'),(5060307,3053,'All',0,3,160000402,2,3,10,'RuneStoneS','Superior'),(5060308,3053,'All',0,3,160000403,2,3,15,'RuneStoneS','Rare'),(5060401,3054,'All',0,4,160000102,3,4,8,'RuneStoneA','Superior'),(5060402,3054,'All',0,4,160000103,3,4,13,'RuneStoneA','Rare'),(5060403,3054,'All',0,4,160000104,3,3,4,'RuneStoneA','Unique'),(5060404,3054,'All',0,4,160000202,3,4,8,'RuneStoneD','Superior'),(5060405,3054,'All',0,4,160000203,3,4,13,'RuneStoneD','Rare'),(5060406,3054,'All',0,4,160000204,3,3,4,'RuneStoneD','Unique'),(5060407,3054,'All',0,4,160000302,3,4,8,'RuneStoneU','Superior'),(5060408,3054,'All',0,4,160000303,3,4,13,'RuneStoneU','Rare'),(5060409,3054,'All',0,4,160000304,3,3,4,'RuneStoneU','Unique'),(5060410,3054,'All',0,4,160000402,3,4,8,'RuneStoneS','Superior'),(5060411,3054,'All',0,4,160000403,3,4,13,'RuneStoneS','Rare'),(5060412,3054,'All',0,4,160000404,3,3,4,'RuneStoneS','Unique'),(5060501,3055,'All',0,5,160000102,3,4,8,'RuneStoneA','Superior'),(5060502,3055,'All',0,5,160000103,3,4,13,'RuneStoneA','Rare'),(5060503,3055,'All',0,5,160000104,3,3,4,'RuneStoneA','Unique'),(5060504,3055,'All',0,5,160000202,3,4,8,'RuneStoneD','Superior'),(5060505,3055,'All',0,5,160000203,3,4,13,'RuneStoneD','Rare'),(5060506,3055,'All',0,5,160000204,3,3,4,'RuneStoneD','Unique'),(5060507,3055,'All',0,5,160000302,3,4,8,'RuneStoneU','Superior'),(5060508,3055,'All',0,5,160000303,3,4,13,'RuneStoneU','Rare'),(5060509,3055,'All',0,5,160000304,3,3,4,'RuneStoneU','Unique'),(5060510,3055,'All',0,5,160000402,3,4,8,'RuneStoneS','Superior'),(5060511,3055,'All',0,5,160000403,3,4,13,'RuneStoneS','Rare'),(5060512,3055,'All',0,5,160000404,3,3,4,'RuneStoneS','Unique'),(5060601,3056,'All',0,6,160000103,3,4,4,'RuneStoneA','Rare'),(5060602,3056,'All',0,6,160000104,3,4,13,'RuneStoneA','Unique'),(5060603,3056,'All',0,6,160000105,3,3,8,'RuneStoneA','Heroic'),(5060604,3056,'All',0,6,160000203,3,4,4,'RuneStoneD','Rare'),(5060605,3056,'All',0,6,160000204,3,4,13,'RuneStoneD','Unique'),(5060606,3056,'All',0,6,160000205,3,3,8,'RuneStoneD','Heroic'),(5060607,3056,'All',0,6,160000303,3,4,4,'RuneStoneU','Rare'),(5060608,3056,'All',0,6,160000304,3,4,13,'RuneStoneU','Unique'),(5060609,3056,'All',0,6,160000305,3,3,8,'RuneStoneU','Heroic'),(5060610,3056,'All',0,6,160000403,3,4,4,'RuneStoneS','Rare'),(5060611,3056,'All',0,6,160000404,3,4,13,'RuneStoneS','Unique'),(5060612,3056,'All',0,6,160000405,3,3,8,'RuneStoneS','Heroic'),(5070101,3061,'All',0,1,160000601,1,1,100,'PromotionW','Invalid'),(5070102,3062,'All',0,2,160000601,2,2,100,'PromotionW','Invalid'),(5070103,3063,'All',0,3,160000601,3,3,100,'PromotionW','Invalid'),(5070104,3064,'All',0,4,160000601,4,4,100,'PromotionW','Invalid'),(5070105,3065,'All',0,5,160000601,5,5,100,'PromotionW','Invalid'),(5070106,3066,'All',0,6,160000601,6,6,100,'PromotionW','Invalid');

--
-- Table structure for table `data_west_area_stage`
--

CREATE TABLE `data_west_area_stage` (
  `general_type_code` int(11) DEFAULT NULL,
  `stage_type` int(11) DEFAULT NULL,
  `act_number` int(11) DEFAULT NULL,
  `stage_number_in_act` int(11) DEFAULT NULL,
  `recommend_atk` int(11) DEFAULT NULL,
  `atk_ratio` float(20,3) DEFAULT NULL,
  `def_ratio` float(20,3) DEFAULT NULL,
  `stage_exp` int(11) DEFAULT NULL,
  `guardian_exp` int(11) DEFAULT NULL,
  `stage_gold` int(11) DEFAULT NULL,
  `auto_connection_skill_gold` int(11) DEFAULT NULL,
  `bonus_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bonus_value` float(20,3) DEFAULT NULL,
  `limit_time_second` float(20,3) DEFAULT NULL,
  `recommend_level_min` int(11) DEFAULT NULL,
  `recommend_level_max` int(11) DEFAULT NULL,
  `previous_stage_code` int(11) DEFAULT NULL,
  `next_stage_code` int(11) DEFAULT NULL,
  `reward_general_code` int(11) DEFAULT NULL,
  `reward_count_min` int(11) DEFAULT NULL,
  `reward_count_max` int(11) DEFAULT NULL,
  `entry_cost_type` int(11) DEFAULT NULL,
  `entry_cost_amount` int(11) DEFAULT NULL,
  `entry_limit_type` tinyint(1) DEFAULT NULL,
  `entry_limit_count` int(11) DEFAULT NULL,
  `boss_monster_code` int(11) DEFAULT NULL,
  `monster_level` int(11) DEFAULT NULL,
  `auto_skill_cost` int(11) DEFAULT NULL,
  `add_reward_group_code` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `data_west_area_stage`
--

INSERT INTO `data_west_area_stage` VALUES (121401001,14,1,1,1566,1.000,1.000,353,353,236,30,'None',0.000,180.000,1,50,0,121401002,6001,1,3,160002003,18,0,-1,101000001,27,-1,9105001),(121401002,14,1,2,4377,2.000,2.000,564,564,426,60,'None',0.000,180.000,1,50,121401001,121401003,6002,1,3,160002003,18,0,-1,101000001,49,-1,9105001),(121401003,14,1,3,9487,3.000,3.000,848,848,664,90,'None',0.000,180.000,1,50,121401002,121401004,6003,1,3,160002003,18,0,-1,101000001,71,-1,9105001),(121401004,14,1,4,16226,4.000,4.000,1063,1063,893,120,'None',0.000,180.000,1,50,121401003,121401005,6004,1,3,160002003,20,0,-1,101000001,109,-1,9105002),(121401005,14,1,5,23292,5.000,5.000,1220,1220,1035,150,'None',0.000,180.000,1,50,121401004,121401006,6005,1,3,160002003,20,0,-1,101000001,126,-1,9105002),(121401006,14,1,6,31102,6.000,6.000,1412,1412,1165,180,'None',0.000,180.000,1,50,121401005,121401007,6006,1,3,160002003,20,0,-1,101000001,141,-1,9105002),(121401007,14,1,7,65967,7.000,7.000,1736,1736,1391,210,'None',0.000,180.000,1,50,121401006,121401008,6007,1,3,160002003,22,0,-1,101000001,157,-1,9105003),(121401008,14,1,8,90207,8.000,8.000,2478,2478,1920,240,'None',0.000,180.000,1,50,121401007,121401009,6008,1,3,160002003,22,0,-1,101000001,160,-1,9105003),(121401009,14,1,9,115717,9.000,9.000,3616,3616,2506,270,'None',0.000,180.000,1,50,121401008,121401010,6009,1,3,160002003,22,0,-1,101000001,164,-1,9105003),(121401010,14,1,10,139722,10.000,10.000,4824,4824,3191,300,'None',0.000,180.000,1,50,121401009,0,6010,1,3,160002003,25,0,-1,101000001,170,-1,9105004);

--
-- Table structure for table `data_west_area_stage_reward`
--

CREATE TABLE `data_west_area_stage_reward` (
  `reward_general_code` int(11) DEFAULT NULL,
  `stage_general_code` int(11) DEFAULT NULL,
  `required_class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `act` int(11) DEFAULT NULL,
  `stage_no` int(11) DEFAULT NULL,
  `general_type_code` int(11) DEFAULT NULL,
  `item_min_count` int(11) DEFAULT NULL,
  `item_max_count` int(11) DEFAULT NULL,
  `drop_rate` float(20,3) DEFAULT NULL,
  `equip_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `grade` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `data_west_area_stage_reward`
--

INSERT INTO `data_west_area_stage_reward` VALUES (3101101,6001,'Berserker',1,1,151103001,1,1,25.000,'Head','Normal'),(3101102,6001,'Berserker',1,1,151203001,1,1,15.000,'Head','Superior'),(3101103,6001,'Berserker',1,1,151303001,1,1,5.000,'Head','Rare'),(3101104,6001,'Berserker',1,1,151102001,1,1,25.000,'Body','Normal'),(3101105,6001,'Berserker',1,1,151202001,1,1,15.000,'Body','Superior'),(3101106,6001,'Berserker',1,1,151302001,1,1,5.000,'Body','Rare'),(3101201,6001,'DemonHunter',1,1,152103001,1,1,25.000,'Head','Normal'),(3101202,6001,'DemonHunter',1,1,152203001,1,1,15.000,'Head','Superior'),(3101203,6001,'DemonHunter',1,1,152303001,1,1,5.000,'Head','Rare'),(3101204,6001,'DemonHunter',1,1,152102001,1,1,25.000,'Body','Normal'),(3101205,6001,'DemonHunter',1,1,152202001,1,1,15.000,'Body','Superior'),(3101206,6001,'DemonHunter',1,1,152302001,1,1,5.000,'Body','Rare'),(3101301,6001,'Archon',1,1,153103001,1,1,25.000,'Head','Normal'),(3101302,6001,'Archon',1,1,153203001,1,1,15.000,'Head','Superior'),(3101303,6001,'Archon',1,1,153303001,1,1,5.000,'Head','Rare'),(3101304,6001,'Archon',1,1,153102001,1,1,25.000,'Body','Normal'),(3101305,6001,'Archon',1,1,153202001,1,1,15.000,'Body','Superior'),(3101306,6001,'Archon',1,1,153302001,1,1,5.000,'Body','Rare'),(3101401,6001,'Knight',1,1,154103001,1,1,25.000,'Head','Normal'),(3101402,6001,'Knight',1,1,154203001,1,1,15.000,'Head','Superior'),(3101403,6001,'Knight',1,1,154303001,1,1,5.000,'Head','Rare'),(3101404,6001,'Knight',1,1,154102001,1,1,25.000,'Body','Normal'),(3101405,6001,'Knight',1,1,154202001,1,1,15.000,'Body','Superior'),(3101406,6001,'Knight',1,1,154302001,1,1,5.000,'Body','Rare'),(3101501,6001,'All',1,1,160004001,1,1,3.000,'ItemIncreaseTicket','Invalid'),(3101502,6001,'All',1,1,160004002,1,1,2.000,'ExpIncreaseTicket','Invalid'),(3101503,6001,'All',1,1,160004003,1,1,4.000,'GoldIncreaseTicket','Invalid'),(3101504,6001,'All',1,1,160004004,1,1,1.000,'ImmediatelyClearTicket','Invalid'),(3102101,6002,'Berserker',1,2,151106001,1,1,25.000,'Pants','Normal'),(3102102,6002,'Berserker',1,2,151206001,1,1,15.000,'Pants','Superior'),(3102103,6002,'Berserker',1,2,151306001,1,1,5.000,'Pants','Rare'),(3102104,6002,'Berserker',1,2,151107001,1,1,25.000,'Shoes','Normal'),(3102105,6002,'Berserker',1,2,151207001,1,1,15.000,'Shoes','Superior'),(3102106,6002,'Berserker',1,2,151307001,1,1,5.000,'Shoes','Rare'),(3102201,6002,'DemonHunter',1,2,152106001,1,1,25.000,'Pants','Normal'),(3102202,6002,'DemonHunter',1,2,152206001,1,1,15.000,'Pants','Superior'),(3102203,6002,'DemonHunter',1,2,152306001,1,1,5.000,'Pants','Rare'),(3102204,6002,'DemonHunter',1,2,152107001,1,1,25.000,'Shoes','Normal'),(3102205,6002,'DemonHunter',1,2,152207001,1,1,15.000,'Shoes','Superior'),(3102206,6002,'DemonHunter',1,2,152307001,1,1,5.000,'Shoes','Rare'),(3102301,6002,'Archon',1,2,153106001,1,1,25.000,'Pants','Normal'),(3102302,6002,'Archon',1,2,153206001,1,1,15.000,'Pants','Superior'),(3102303,6002,'Archon',1,2,153306001,1,1,5.000,'Pants','Rare'),(3102304,6002,'Archon',1,2,153107001,1,1,25.000,'Shoes','Normal'),(3102305,6002,'Archon',1,2,153207001,1,1,15.000,'Shoes','Superior'),(3102306,6002,'Archon',1,2,153307001,1,1,5.000,'Shoes','Rare'),(3102401,6002,'Knight',1,2,154106001,1,1,25.000,'Pants','Normal'),(3102402,6002,'Knight',1,2,154206001,1,1,15.000,'Pants','Superior'),(3102403,6002,'Knight',1,2,154306001,1,1,5.000,'Pants','Rare'),(3102404,6002,'Knight',1,2,154107001,1,1,25.000,'Shoes','Normal'),(3102405,6002,'Knight',1,2,154207001,1,1,15.000,'Shoes','Superior'),(3102406,6002,'Knight',1,2,154307001,1,1,5.000,'Shoes','Rare'),(3102501,6002,'All',1,2,160004001,1,1,3.000,'ItemIncreaseTicket','Invalid'),(3102502,6002,'All',1,2,160004002,1,1,2.000,'ExpIncreaseTicket','Invalid'),(3102503,6002,'All',1,2,160004003,1,1,4.000,'GoldIncreaseTicket','Invalid'),(3102504,6002,'All',1,2,160004004,1,1,1.000,'ImmediatelyClearTicket','Invalid'),(3103101,6003,'Berserker',1,3,151105001,1,1,25.000,'Glove','Normal'),(3103102,6003,'Berserker',1,3,151205001,1,1,15.000,'Glove','Superior'),(3103103,6003,'Berserker',1,3,151305001,1,1,5.000,'Glove','Rare'),(3103104,6003,'Berserker',1,3,151103002,1,1,25.000,'Head','Normal'),(3103105,6003,'Berserker',1,3,151203002,1,1,15.000,'Head','Superior'),(3103106,6003,'Berserker',1,3,151303002,1,1,5.000,'Head','Rare'),(3103201,6003,'DemonHunter',1,3,152105001,1,1,25.000,'Glove','Normal'),(3103202,6003,'DemonHunter',1,3,152205001,1,1,15.000,'Glove','Superior'),(3103203,6003,'DemonHunter',1,3,152305001,1,1,5.000,'Glove','Rare'),(3103204,6003,'DemonHunter',1,3,152103002,1,1,25.000,'Head','Normal'),(3103205,6003,'DemonHunter',1,3,152203002,1,1,15.000,'Head','Superior'),(3103206,6003,'DemonHunter',1,3,152303002,1,1,5.000,'Head','Rare'),(3103301,6003,'Archon',1,3,153105001,1,1,25.000,'Glove','Normal'),(3103302,6003,'Archon',1,3,153205001,1,1,15.000,'Glove','Superior'),(3103303,6003,'Archon',1,3,153305001,1,1,5.000,'Glove','Rare'),(3103304,6003,'Archon',1,3,153103002,1,1,25.000,'Head','Normal'),(3103305,6003,'Archon',1,3,153203002,1,1,15.000,'Head','Superior'),(3103306,6003,'Archon',1,3,153303002,1,1,5.000,'Head','Rare'),(3103401,6003,'Knight',1,3,154105001,1,1,25.000,'Glove','Normal'),(3103402,6003,'Knight',1,3,154205001,1,1,15.000,'Glove','Superior'),(3103403,6003,'Knight',1,3,154305001,1,1,5.000,'Glove','Rare'),(3103404,6003,'Knight',1,3,154103002,1,1,25.000,'Head','Normal'),(3103405,6003,'Knight',1,3,154203002,1,1,15.000,'Head','Superior'),(3103406,6003,'Knight',1,3,154303002,1,1,5.000,'Head','Rare'),(3103501,6003,'All',1,3,160004001,1,1,3.000,'ItemIncreaseTicket','Invalid'),(3103502,6003,'All',1,3,160004002,1,1,2.000,'ExpIncreaseTicket','Invalid'),(3103503,6003,'All',1,3,160004003,1,1,4.000,'GoldIncreaseTicket','Invalid'),(3103504,6003,'All',1,3,160004004,1,1,1.000,'ImmediatelyClearTicket','Invalid'),(3104102,6004,'Berserker',1,4,151202002,1,1,20.000,'Body','Superior'),(3104103,6004,'Berserker',1,4,151302002,1,1,5.000,'Body','Rare'),(3104105,6004,'Berserker',1,4,151206002,1,1,20.000,'Pants','Superior'),(3104106,6004,'Berserker',1,4,151306002,1,1,5.000,'Pants','Rare'),(3104108,6004,'Berserker',1,4,151207002,1,1,20.000,'Shoes','Superior'),(3104109,6004,'Berserker',1,4,151307002,1,1,5.000,'Shoes','Rare'),(3104111,6004,'Berserker',1,4,151101002,1,1,15.000,'Weapon','Superior'),(3104202,6004,'DemonHunter',1,4,152202002,1,1,20.000,'Body','Superior'),(3104203,6004,'DemonHunter',1,4,152302002,1,1,5.000,'Body','Rare'),(3104205,6004,'DemonHunter',1,4,152206002,1,1,20.000,'Pants','Superior'),(3104206,6004,'DemonHunter',1,4,152306002,1,1,5.000,'Pants','Rare'),(3104208,6004,'DemonHunter',1,4,152207002,1,1,20.000,'Shoes','Superior'),(3104209,6004,'DemonHunter',1,4,152307002,1,1,5.000,'Shoes','Rare'),(3104211,6004,'DemonHunter',1,4,152101002,1,1,15.000,'Weapon','Superior'),(3104302,6004,'Archon',1,4,153202002,1,1,20.000,'Body','Superior'),(3104303,6004,'Archon',1,4,153302002,1,1,5.000,'Body','Rare'),(3104305,6004,'Archon',1,4,153206002,1,1,20.000,'Pants','Superior'),(3104306,6004,'Archon',1,4,153306002,1,1,5.000,'Pants','Rare'),(3104308,6004,'Archon',1,4,153207002,1,1,20.000,'Shoes','Superior'),(3104309,6004,'Archon',1,4,153307002,1,1,5.000,'Shoes','Rare'),(3104311,6004,'Archon',1,4,153101002,1,1,15.000,'Weapon','Superior'),(3104402,6004,'Knight',1,4,154202002,1,1,20.000,'Body','Superior'),(3104403,6004,'Knight',1,4,154302002,1,1,5.000,'Body','Rare'),(3104405,6004,'Knight',1,4,154206002,1,1,20.000,'Pants','Superior'),(3104406,6004,'Knight',1,4,154306002,1,1,5.000,'Pants','Rare'),(3104408,6004,'Knight',1,4,154207002,1,1,20.000,'Shoes','Superior'),(3104409,6004,'Knight',1,4,154307002,1,1,5.000,'Shoes','Rare'),(3104411,6004,'Knight',1,4,154101002,1,1,15.000,'Weapon','Superior'),(3104501,6004,'All',1,4,160004001,1,1,3.000,'ItemIncreaseTicket','Invalid'),(3104502,6004,'All',1,4,160004002,1,1,2.000,'ExpIncreaseTicket','Invalid'),(3104503,6004,'All',1,4,160004003,1,1,4.000,'GoldIncreaseTicket','Invalid'),(3104504,6004,'All',1,4,160004004,1,1,1.000,'ImmediatelyClearTicket','Invalid'),(3105102,6005,'Berserker',1,5,151205002,1,1,20.000,'Glove','Superior'),(3105103,6005,'Berserker',1,5,151305002,1,1,5.000,'Glove','Rare'),(3105105,6005,'Berserker',1,5,151203003,1,1,20.000,'Head','Superior'),(3105106,6005,'Berserker',1,5,151303003,1,1,5.000,'Head','Rare'),(3105108,6005,'Berserker',1,5,151202002,1,1,20.000,'Body','Superior'),(3105109,6005,'Berserker',1,5,151302002,1,1,5.000,'Body','Rare'),(3105111,6005,'Berserker',1,5,151201002,1,1,15.000,'Weapon','Superior'),(3105202,6005,'DemonHunter',1,5,152205002,1,1,20.000,'Glove','Superior'),(3105203,6005,'DemonHunter',1,5,152305002,1,1,5.000,'Glove','Rare'),(3105205,6005,'DemonHunter',1,5,152203003,1,1,20.000,'Head','Superior'),(3105206,6005,'DemonHunter',1,5,152303003,1,1,5.000,'Head','Rare'),(3105208,6005,'DemonHunter',1,5,152202002,1,1,20.000,'Body','Superior'),(3105209,6005,'DemonHunter',1,5,152302002,1,1,5.000,'Body','Rare'),(3105211,6005,'DemonHunter',1,5,152201002,1,1,15.000,'Weapon','Superior'),(3105302,6005,'Archon',1,5,153205002,1,1,20.000,'Glove','Superior'),(3105303,6005,'Archon',1,5,153305002,1,1,5.000,'Glove','Rare'),(3105305,6005,'Archon',1,5,153203003,1,1,20.000,'Head','Superior'),(3105306,6005,'Archon',1,5,153303003,1,1,5.000,'Head','Rare'),(3105308,6005,'Archon',1,5,153202002,1,1,20.000,'Body','Superior'),(3105309,6005,'Archon',1,5,153302002,1,1,5.000,'Body','Rare'),(3105311,6005,'Archon',1,5,153201002,1,1,15.000,'Weapon','Superior'),(3105402,6005,'Knight',1,5,154205002,1,1,20.000,'Glove','Superior'),(3105403,6005,'Knight',1,5,154305002,1,1,5.000,'Glove','Rare'),(3105405,6005,'Knight',1,5,154203003,1,1,20.000,'Head','Superior'),(3105406,6005,'Knight',1,5,154303003,1,1,5.000,'Head','Rare'),(3105408,6005,'Knight',1,5,154202002,1,1,20.000,'Body','Superior'),(3105409,6005,'Knight',1,5,154302002,1,1,5.000,'Body','Rare'),(3105411,6005,'Knight',1,5,154201002,1,1,15.000,'Weapon','Superior'),(3105501,6005,'All',1,5,160004001,1,1,3.000,'ItemIncreaseTicket','Invalid'),(3105502,6005,'All',1,5,160004002,1,1,2.000,'ExpIncreaseTicket','Invalid'),(3105503,6005,'All',1,5,160004003,1,1,4.000,'GoldIncreaseTicket','Invalid'),(3105504,6005,'All',1,5,160004004,1,1,1.000,'ImmediatelyClearTicket','Invalid'),(3106102,6006,'Berserker',1,6,151206003,1,1,20.000,'Pants','Superior'),(3106103,6006,'Berserker',1,6,151306003,1,1,5.000,'Pants','Rare'),(3106105,6006,'Berserker',1,6,151207003,1,1,20.000,'Shoes','Superior'),(3106106,6006,'Berserker',1,6,151307003,1,1,5.000,'Shoes','Rare'),(3106108,6006,'Berserker',1,6,151205003,1,1,20.000,'Glove','Superior'),(3106109,6006,'Berserker',1,6,151305003,1,1,5.000,'Glove','Rare'),(3106111,6006,'Berserker',1,6,151201003,1,1,15.000,'Weapon','Superior'),(3106202,6006,'DemonHunter',1,6,152206003,1,1,20.000,'Pants','Superior'),(3106203,6006,'DemonHunter',1,6,152306003,1,1,5.000,'Pants','Rare'),(3106205,6006,'DemonHunter',1,6,152207003,1,1,20.000,'Shoes','Superior'),(3106206,6006,'DemonHunter',1,6,152307003,1,1,5.000,'Shoes','Rare'),(3106208,6006,'DemonHunter',1,6,152205003,1,1,20.000,'Glove','Superior'),(3106209,6006,'DemonHunter',1,6,152305003,1,1,5.000,'Glove','Rare'),(3106211,6006,'DemonHunter',1,6,152201003,1,1,15.000,'Weapon','Superior'),(3106302,6006,'Archon',1,6,153206003,1,1,20.000,'Pants','Superior'),(3106303,6006,'Archon',1,6,153306003,1,1,5.000,'Pants','Rare'),(3106305,6006,'Archon',1,6,153207003,1,1,20.000,'Shoes','Superior'),(3106306,6006,'Archon',1,6,153307003,1,1,5.000,'Shoes','Rare'),(3106308,6006,'Archon',1,6,153205003,1,1,20.000,'Glove','Superior'),(3106309,6006,'Archon',1,6,153305003,1,1,5.000,'Glove','Rare'),(3106311,6006,'Archon',1,6,153201003,1,1,15.000,'Weapon','Superior'),(3106402,6006,'Knight',1,6,154206003,1,1,20.000,'Pants','Superior'),(3106403,6006,'Knight',1,6,154306003,1,1,5.000,'Pants','Rare'),(3106405,6006,'Knight',1,6,154207003,1,1,20.000,'Shoes','Superior'),(3106406,6006,'Knight',1,6,154307003,1,1,5.000,'Shoes','Rare'),(3106408,6006,'Knight',1,6,154205003,1,1,20.000,'Glove','Superior'),(3106409,6006,'Knight',1,6,154305003,1,1,5.000,'Glove','Rare'),(3106411,6006,'Knight',1,6,154201003,1,1,15.000,'Weapon','Superior'),(3106501,6006,'All',1,6,160004001,1,1,3.000,'ItemIncreaseTicket','Invalid'),(3106502,6006,'All',1,6,160004002,1,1,2.000,'ExpIncreaseTicket','Invalid'),(3106503,6006,'All',1,6,160004003,1,1,4.000,'GoldIncreaseTicket','Invalid'),(3106504,6006,'All',1,6,160004004,1,1,1.000,'ImmediatelyClearTicket','Invalid'),(3107102,6007,'Berserker',1,7,151203004,1,1,19.000,'Head','Superior'),(3107103,6007,'Berserker',1,7,151303004,1,1,5.000,'Head','Rare'),(3107105,6007,'Berserker',1,7,151202004,1,1,19.000,'Body','Superior'),(3107106,6007,'Berserker',1,7,151302004,1,1,5.000,'Body','Rare'),(3107108,6007,'Berserker',1,7,151206004,1,1,19.000,'Pants','Superior'),(3107109,6007,'Berserker',1,7,151306004,1,1,5.000,'Pants','Rare'),(3107111,6007,'Berserker',1,7,151201004,1,1,15.000,'Weapon','Superior'),(3107112,6007,'Berserker',1,7,151301004,1,1,3.000,'Weapon','Rare'),(3107202,6007,'DemonHunter',1,7,152203004,1,1,19.000,'Head','Superior'),(3107203,6007,'DemonHunter',1,7,152303004,1,1,5.000,'Head','Rare'),(3107205,6007,'DemonHunter',1,7,152202004,1,1,19.000,'Body','Superior'),(3107206,6007,'DemonHunter',1,7,152302004,1,1,5.000,'Body','Rare'),(3107208,6007,'DemonHunter',1,7,152206004,1,1,19.000,'Pants','Superior'),(3107209,6007,'DemonHunter',1,7,152306004,1,1,5.000,'Pants','Rare'),(3107211,6007,'DemonHunter',1,7,152201004,1,1,15.000,'Weapon','Superior'),(3107212,6007,'DemonHunter',1,7,152301004,1,1,3.000,'Weapon','Rare'),(3107302,6007,'Archon',1,7,153203004,1,1,19.000,'Head','Superior'),(3107303,6007,'Archon',1,7,153303004,1,1,5.000,'Head','Rare'),(3107305,6007,'Archon',1,7,153202004,1,1,19.000,'Body','Superior'),(3107306,6007,'Archon',1,7,153302004,1,1,5.000,'Body','Rare'),(3107308,6007,'Archon',1,7,153206004,1,1,19.000,'Pants','Superior'),(3107309,6007,'Archon',1,7,153306004,1,1,5.000,'Pants','Rare'),(3107311,6007,'Archon',1,7,153201004,1,1,15.000,'Weapon','Superior'),(3107312,6007,'Archon',1,7,153301004,1,1,3.000,'Weapon','Rare'),(3107402,6007,'Knight',1,7,154203004,1,1,19.000,'Head','Superior'),(3107403,6007,'Knight',1,7,154303004,1,1,5.000,'Head','Rare'),(3107405,6007,'Knight',1,7,154202004,1,1,19.000,'Body','Superior'),(3107406,6007,'Knight',1,7,154302004,1,1,5.000,'Body','Rare'),(3107408,6007,'Knight',1,7,154206004,1,1,19.000,'Pants','Superior'),(3107409,6007,'Knight',1,7,154306004,1,1,5.000,'Pants','Rare'),(3107411,6007,'Knight',1,7,154201004,1,1,15.000,'Weapon','Superior'),(3107412,6007,'Knight',1,7,154301004,1,1,3.000,'Weapon','Rare'),(3107501,6007,'All',1,7,160004001,1,1,3.000,'ItemIncreaseTicket','Invalid'),(3107502,6007,'All',1,7,160004002,1,1,2.000,'ExpIncreaseTicket','Invalid'),(3107503,6007,'All',1,7,160004003,1,1,4.000,'GoldIncreaseTicket','Invalid'),(3107504,6007,'All',1,7,160004004,1,1,1.000,'ImmediatelyClearTicket','Invalid'),(3108102,6008,'Berserker',1,8,151207004,1,1,19.000,'Shoes','Superior'),(3108103,6008,'Berserker',1,8,151307004,1,1,5.000,'Shoes','Rare'),(3108105,6008,'Berserker',1,8,151205004,1,1,19.000,'Glove','Superior'),(3108106,6008,'Berserker',1,8,151305004,1,1,5.000,'Glove','Rare'),(3108108,6008,'Berserker',1,8,151203005,1,1,19.000,'Head','Superior'),(3108109,6008,'Berserker',1,8,151303005,1,1,5.000,'Head','Rare'),(3108111,6008,'Berserker',1,8,151201005,1,1,15.000,'Weapon','Superior'),(3108112,6008,'Berserker',1,8,151301005,1,1,3.000,'Weapon','Rare'),(3108202,6008,'DemonHunter',1,8,152207004,1,1,19.000,'Shoes','Superior'),(3108203,6008,'DemonHunter',1,8,152307004,1,1,5.000,'Shoes','Rare'),(3108205,6008,'DemonHunter',1,8,152205004,1,1,19.000,'Glove','Superior'),(3108206,6008,'DemonHunter',1,8,152305004,1,1,5.000,'Glove','Rare'),(3108208,6008,'DemonHunter',1,8,152203005,1,1,19.000,'Head','Superior'),(3108209,6008,'DemonHunter',1,8,152303005,1,1,5.000,'Head','Rare'),(3108211,6008,'DemonHunter',1,8,152201005,1,1,15.000,'Weapon','Superior'),(3108212,6008,'DemonHunter',1,8,152301005,1,1,3.000,'Weapon','Rare'),(3108302,6008,'Archon',1,8,153207004,1,1,19.000,'Shoes','Superior'),(3108303,6008,'Archon',1,8,153307004,1,1,5.000,'Shoes','Rare'),(3108305,6008,'Archon',1,8,153205004,1,1,19.000,'Glove','Superior'),(3108306,6008,'Archon',1,8,153305004,1,1,5.000,'Glove','Rare'),(3108308,6008,'Archon',1,8,153203005,1,1,19.000,'Head','Superior'),(3108309,6008,'Archon',1,8,153303005,1,1,5.000,'Head','Rare'),(3108311,6008,'Archon',1,8,153201005,1,1,15.000,'Weapon','Superior'),(3108312,6008,'Archon',1,8,153301005,1,1,3.000,'Weapon','Rare'),(3108402,6008,'Knight',1,8,154207004,1,1,19.000,'Shoes','Superior'),(3108403,6008,'Knight',1,8,154307004,1,1,5.000,'Shoes','Rare'),(3108405,6008,'Knight',1,8,154205004,1,1,19.000,'Glove','Superior'),(3108406,6008,'Knight',1,8,154305004,1,1,5.000,'Glove','Rare'),(3108408,6008,'Knight',1,8,154203005,1,1,19.000,'Head','Superior'),(3108409,6008,'Knight',1,8,154303005,1,1,5.000,'Head','Rare'),(3108411,6008,'Knight',1,8,154201005,1,1,15.000,'Weapon','Superior'),(3108412,6008,'Knight',1,8,154301005,1,1,3.000,'Weapon','Rare'),(3018501,6008,'All',1,8,160004001,1,1,3.000,'ItemIncreaseTicket','Invalid'),(3018502,6008,'All',1,8,160004002,1,1,2.000,'ExpIncreaseTicket','Invalid'),(3018503,6008,'All',1,8,160004003,1,1,4.000,'GoldIncreaseTicket','Invalid'),(3018504,6008,'All',1,8,160004004,1,1,1.000,'ImmediatelyClearTicket','Invalid'),(3109102,6009,'Berserker',1,9,151202005,1,1,14.000,'Body','Superior'),(3109103,6009,'Berserker',1,9,151302005,1,1,3.000,'Body','Rare'),(3109105,6009,'Berserker',1,9,151206005,1,1,14.000,'Pants','Superior'),(3109106,6009,'Berserker',1,9,151306005,1,1,3.000,'Pants','Rare'),(3109108,6009,'Berserker',1,9,151207005,1,1,14.000,'Shoes','Superior'),(3109109,6009,'Berserker',1,9,151307005,1,1,3.000,'Shoes','Rare'),(3109111,6009,'Berserker',1,9,151205005,1,1,14.000,'Glove','Superior'),(3109112,6009,'Berserker',1,9,151305005,1,1,3.000,'Glove','Rare'),(3109114,6009,'Berserker',1,9,151201006,1,1,19.000,'Weapon','Superior'),(3109115,6009,'Berserker',1,9,151301006,1,1,3.000,'Weapon','Rare'),(3109202,6009,'DemonHunter',1,9,152202005,1,1,14.000,'Body','Superior'),(3109203,6009,'DemonHunter',1,9,152302005,1,1,3.000,'Body','Rare'),(3109205,6009,'DemonHunter',1,9,152206005,1,1,14.000,'Pants','Superior'),(3109206,6009,'DemonHunter',1,9,152306005,1,1,3.000,'Pants','Rare'),(3109208,6009,'DemonHunter',1,9,152207005,1,1,14.000,'Shoes','Superior'),(3109209,6009,'DemonHunter',1,9,152307005,1,1,3.000,'Shoes','Rare'),(3109211,6009,'DemonHunter',1,9,152205005,1,1,14.000,'Glove','Superior'),(3109212,6009,'DemonHunter',1,9,152305005,1,1,3.000,'Glove','Rare'),(3109214,6009,'DemonHunter',1,9,152201006,1,1,19.000,'Weapon','Superior'),(3109215,6009,'DemonHunter',1,9,152301006,1,1,3.000,'Weapon','Rare'),(3109302,6009,'Archon',1,9,153202005,1,1,14.000,'Body','Superior'),(3109303,6009,'Archon',1,9,153302005,1,1,3.000,'Body','Rare'),(3109305,6009,'Archon',1,9,153206005,1,1,14.000,'Pants','Superior'),(3109306,6009,'Archon',1,9,153306005,1,1,3.000,'Pants','Rare'),(3109308,6009,'Archon',1,9,153207005,1,1,14.000,'Shoes','Superior'),(3109309,6009,'Archon',1,9,153307005,1,1,3.000,'Shoes','Rare'),(3109311,6009,'Archon',1,9,153205005,1,1,14.000,'Glove','Superior'),(3109312,6009,'Archon',1,9,153305005,1,1,3.000,'Glove','Rare'),(3109314,6009,'Archon',1,9,153201006,1,1,19.000,'Weapon','Superior'),(3109315,6009,'Archon',1,9,153301006,1,1,3.000,'Weapon','Rare'),(3109402,6009,'Knight',1,9,154202005,1,1,14.000,'Body','Superior'),(3109403,6009,'Knight',1,9,154302005,1,1,3.000,'Body','Rare'),(3109405,6009,'Knight',1,9,154206005,1,1,14.000,'Pants','Superior'),(3109406,6009,'Knight',1,9,154306005,1,1,3.000,'Pants','Rare'),(3109408,6009,'Knight',1,9,154207005,1,1,14.000,'Shoes','Superior'),(3109409,6009,'Knight',1,9,154307005,1,1,3.000,'Shoes','Rare'),(3109411,6009,'Knight',1,9,154205005,1,1,14.000,'Glove','Superior'),(3109412,6009,'Knight',1,9,154305005,1,1,3.000,'Glove','Rare'),(3109414,6009,'Knight',1,9,154201006,1,1,19.000,'Weapon','Superior'),(3109415,6009,'Knight',1,9,154301006,1,1,3.000,'Weapon','Rare'),(3109501,6009,'All',1,9,160004001,1,1,3.000,'ItemIncreaseTicket','Invalid'),(3109502,6009,'All',1,9,160004002,1,1,2.000,'ExpIncreaseTicket','Invalid'),(3109503,6009,'All',1,9,160004003,1,1,4.000,'GoldIncreaseTicket','Invalid'),(3109504,6009,'All',1,9,160004004,1,1,1.000,'ImmediatelyClearTicket','Invalid'),(3110101,6010,'Berserker',1,10,151201006,1,1,70.000,'Weapon','Superior'),(3110102,6010,'Berserker',1,10,151301006,1,1,15.000,'Weapon','Rare'),(3110103,6010,'Berserker',1,10,151401006,1,1,5.000,'Weapon','Unique'),(3110201,6010,'DemonHunter',1,10,152201006,1,1,70.000,'Weapon','Superior'),(3110202,6010,'DemonHunter',1,10,152301006,1,1,15.000,'Weapon','Rare'),(3110203,6010,'DemonHunter',1,10,152401006,1,1,5.000,'Weapon','Unique'),(3110301,6010,'Archon',1,10,153201006,1,1,70.000,'Weapon','Superior'),(3110302,6010,'Archon',1,10,153301006,1,1,15.000,'Weapon','Rare'),(3110303,6010,'Archon',1,10,153401006,1,1,5.000,'Weapon','Unique'),(3110401,6010,'Knight',1,10,154201006,1,1,70.000,'Weapon','Superior'),(3110402,6010,'Knight',1,10,154301006,1,1,15.000,'Weapon','Rare'),(3110403,6010,'Knight',1,10,154401006,1,1,5.000,'Weapon','Unique'),(3110501,6010,'All',1,10,160004001,1,1,3.000,'ItemIncreaseTicket','Invalid'),(3110502,6010,'All',1,10,160004002,1,1,2.000,'ExpIncreaseTicket','Invalid'),(3110503,6010,'All',1,10,160004003,1,1,4.000,'GoldIncreaseTicket','Invalid'),(3110504,6010,'All',1,10,160004004,1,1,1.000,'ImmediatelyClearTicket','Invalid');

--
-- Table structure for table `table_chatting_server`
--

CREATE TABLE `table_chatting_server` (
  `server_id` smallint(6) unsigned NOT NULL COMMENT '게임 서버의 ID\n\n- 게임 서버는 게임 DB 서버 당 254개까지 할당 가능하다. (1 ~ 255)\n\n- 게임 서버 ID를 표기할 경우에는 2바이트 정수를 사용하여 [DB 서버 ID | 서버 ID]와 같은 방식으로 표기해야 한다.',
  `url` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '* 접속할 URL\n\n- 다른 ID를 가진 게임 서버도 동일한 URL을 가질 수 있다.\n: 하나의 웹 서버 기계에 여러 프로세스의 웹 사이트를 띄우는 방식으로 운용할 경우에 그렇다. 이 때는 보통 포트 번호로 구분을 하게 된다.\n\n- 일반적인 웹 URL의 최대 길이 제한이 2000바이트 남짓이다.\n  : 현재는 utf8 인코딩을 쓰기 때문에 1글자당 최대 3바이트로 잡으면 최대 666.6666... 이므로 안전하게 665글자로 제한하면 된다.\n\n- 이에 대한 관련 근거는 다음을 참조\n : http://stackoverflow.com/questions/417142/what-is-the-maximum-length-of-a-url-in-different-browsers\n   http://www.boutell.com/newfaq/misc/urllength.html\n\n- 다만, 여기에서는 MySQL 5.7.7 이전의 기본 인덱스 제한 크기(767 byte)를 고려하여 글자수를 128자로 제한하였다. \n: MySQL 5.7.7 이후의 기본 인덱스 제한 크기는 3072byte임.\n  딱히 128자가 넘는 URL을 사용해야 할 이유도 없다.',
  `port` smallint(6) unsigned NOT NULL DEFAULT '80',
  PRIMARY KEY (`server_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='채팅 서버 접속 정보';

--
-- Dumping data for table `table_chatting_server`
--

INSERT INTO `table_chatting_server` VALUES (1,'175.124.227.25',31000);

--
-- Table structure for table `table_game_data_link`
--

CREATE TABLE `table_game_data_link` (
  `game_data_link_id` int(11) NOT NULL COMMENT '사용자가 다운로드 해야 할 게임 데이터가 존재하는 URL',
  `url` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '* 접속할 URL\n\n- 일반적인 웹 URL의 최대 길이 제한이 2000바이트 남짓이다.\n  : 현재는 utf8 인코딩을 쓰기 때문에 1글자당 최대 3바이트로 잡으면 최대 666.6666... 이므로 안전하게 665글자로 제한하면 된다.\n\n- 이에 대한 관련 근거는 다음을 참조\n : http://stackoverflow.com/questions/417142/what-is-the-maximum-length-of-a-url-in-different-browsers\n   http://www.boutell.com/newfaq/misc/urllength.html\n\n- 다만, 여기에서는 MySQL 5.7.7 이전의 기본 인덱스 제한 크기(767 byte)를 고려하여 글자수를 128자로 제한하였다. \n: MySQL 5.7.7 이후의 기본 인덱스 제한 크기는 3072byte임.\n  딱히 128자가 넘는 URL을 사용해야 할 이유도 없다.',
  PRIMARY KEY (`game_data_link_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='[Deprecated] 게임 데이터 다운로드 링크 정보';

--
-- Dumping data for table `table_game_data_link`
--


--
-- Table structure for table `table_game_database`
--

CREATE TABLE `table_game_database` (
  `database_id` tinyint(3) unsigned NOT NULL COMMENT '데이터베이스의 ID\n\n- eod_game 스키마의 데이터를 담당하는 데이터베이스 서버들을 구분하는 ID이다.\n\n- 데이터베이스 ID는 서비스 지역(service_code로 구분하는)에서 유일하다.\n\n- 6비트의 부호없는 정수로 할당한다. (1 ~ 64)\n: 1바이트(=8비트) 정수형으로 할당하기는 하지만, 63개를 넘지 않도록 주의할 것)',
  `url` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '데이터베이스에 연결할 URL\n\n- 웹 서버가 아니다! 데이터베이스가 설치된 서버의 URL을 말한다.\n\n- 일반적인 웹 URL의 최대 길이 제한이 2000바이트 남짓이다.\n  : 현재는 utf8 인코딩을 쓰기 때문에 1글자당 최대 3바이트로 잡으면 최대 666.6666... 이므로 안전하게 665글자로 제한하면 된다.\n\n- 이에 대한 관련 근거는 다음을 참조\n : http://stackoverflow.com/questions/417142/what-is-the-maximum-length-of-a-url-in-different-browsers\n   http://www.boutell.com/newfaq/misc/urllength.html\n\n- 다만, 여기에서는 MySQL 5.7.7 이전의 기본 인덱스 제한 크기(767 byte)를 고려하여 글자수를 128자로 제한하였다. \n: MySQL 5.7.7 이후의 기본 인덱스 제한 크기는 3072byte임.\n  딱히 128자가 넘는 URL을 사용해야 할 이유도 없다.',
  `port` smallint(6) unsigned NOT NULL DEFAULT '80' COMMENT '포트 번호',
  `username` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '데이터베이스 계정 ',
  `password` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '데이터베이스 계정의 암호 ',
  `allocated_max_id_player` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '현재까지 할당한 가장 큰 값의 캐릭터 ID\n\n- 최대 50비트 부호없는 정수값까지 할당할 수 있다. (약 7.2경 개)\n: 앞 14비트는 게임 DB 번호 + 게임 서버 번호이다. \n\n- ID를 한 번 부여하고 이 필드의 값이 증가하면, 이를 다시는 되돌리지 않는다.\n\n- 더 이상 사용하지 않게 된 ID의 재활용은 가능하나, 이는 어디까지나 게임 서버 상에서만 관리하는 문제이며, 이곳을 통해서는 무조건 1 증가시킨 값의 새로운 고유 번호만을 부여받을 수 있다.',
  `allocated_max_id_character` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '현재까지 할당한 가장 큰 값의 캐릭터 ID\n\n- 최대 48비트 부호없는 정수값까지 할당할 수 있다.\n\n- ID를 한 번 부여하고 이 필드의 값이 증가하면, 이를 다시는 되돌리지 않는다.\n\n- 더 이상 사용하지 않게 된 ID의 재활용은 가능하나, 이는 어디까지나 게임 서버 상에서만 관리하는 문제이며, 이곳을 통해서는 무조건 1 증가시킨 값의 새로운 고유 번호만을 부여받을 수 있다.',
  `allocated_max_id_item` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '현재까지 할당한 가장 큰 값의 아이템 ID\n\n- 최대 48비트 부호없는 정수값까지 할당할 수 있다.\n\n- ID를 한 번 부여하고 이 필드의 값이 증가하면, 이를 다시는 되돌리지 않는다.\n\n- 더 이상 사용하지 않게 된 ID의 재활용은 가능하나, 이는 어디까지나 게임 서버 상에서만 관리하는 문제이며, 이곳을 통해서는 무조건 1 증가시킨 값의 새로운 고유 번호만을 부여받을 수 있다.',
  `allocated_max_id_post` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`database_id`),
  KEY `url_port_idx` (`url`,`port`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='게임 데이터베이스 접속 정보';

--
-- Dumping data for table `table_game_database`
--

INSERT INTO `table_game_database` VALUES (1,'175.124.227.25',33066,'GameUser','Nox1q2w3e4r',0,0,0,0);

--
-- Table structure for table `table_game_event`
--

CREATE TABLE `table_game_event` (
  `event_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '이벤트 식별 ID',
  `event_type` smallint(6) NOT NULL DEFAULT '0' COMMENT '이벤트의 타입\n\n- 경험치 2배 이벤트이든, 과금 상품 구매시 추가 증정이든 이런 이벤트 종류를 뜻한다.',
  `event_parameters` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'event_type에 의거해서 정하는 이벤트의 구체적인 매개변수들\n\n- JSON 텍스트 형식으로 저장한다.\n\n- event_type의 값에 따라, 내용을 해석하는 방식이 다르다.\n\n- 해석의 책임은 꺼내서 쓰는 서버 애플리케이션이 가진다.',
  `target_service_code` int(11) NOT NULL DEFAULT '0' COMMENT '어느 서비스를 대상으로 하는 이벤트인지 지정하기 위함이다.',
  `begin_datetime` datetime NOT NULL DEFAULT '1000-01-01 00:00:00' COMMENT '이벤트를 시작할 일시 ',
  `end_datetime` datetime NOT NULL DEFAULT '1000-01-01 00:00:00' COMMENT '이벤트를 종료할 일시 ',
  PRIMARY KEY (`event_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='[Deprecated] 게임 이벤트 목록';

--
-- Dumping data for table `table_game_event`
--


--
-- Table structure for table `table_game_server`
--

CREATE TABLE `table_game_server` (
  `database_id` tinyint(3) unsigned NOT NULL COMMENT '게임 데이터베이스의 ID\n\n- eod_game 스키마의 데이터를 담당하는 데이터베이스 서버들을 구분하는 ID이다.\n\n- 데이터베이스 ID는 서비스 지역(service_code로 구분하는)에서 유일하다.\n\n- 6비트의 부호없는 정수로 할당한다. (1 ~ 64)\n: 1바이트(=8비트) 정수형으로 할당하기는 하지만, 63개를 넘지 않도록 주의할 것)',
  `server_number` tinyint(4) unsigned NOT NULL COMMENT '게임 서버 번호\n\n- 게임 서버는 게임 DB 서버 당 254개까지 할당 가능하다. (1 ~ 255)\n\n- 게임 서버 ID로 표기할 경우에는 2바이트 정수를 사용하여 [DB 서버 ID | 서버 ID]와 같은 방식으로 표기해야 한다.',
  `url` varchar(128) COLLATE utf8_unicode_ci NOT NULL COMMENT '* 접속할 URL\n\n- 일반적인 웹 URL의 최대 길이 제한이 2000바이트 남짓이다.\n  : 현재는 utf8 인코딩을 쓰기 때문에 1글자당 최대 3바이트로 잡으면 최대 666.6666... 이므로 안전하게 665글자로 제한하면 된다.\n\n- 이에 대한 관련 근거는 다음을 참조\n : http://stackoverflow.com/questions/417142/what-is-the-maximum-length-of-a-url-in-different-browsers\n   http://www.boutell.com/newfaq/misc/urllength.html\n\n- 다만, 여기에서는 MySQL 5.7.7 이전의 기본 인덱스 제한 크기(767 byte)를 고려하여 글자수를 128자로 제한하였다. \n: MySQL 5.7.7 이후의 기본 인덱스 제한 크기는 3072byte임.\n  딱히 128자가 넘는 URL을 사용해야 할 이유도 없다.',
  `port` smallint(6) unsigned NOT NULL DEFAULT '80',
  `recently_access_count` int(11) NOT NULL DEFAULT '0' COMMENT '최근 접속한 횟수',
  PRIMARY KEY (`server_number`,`database_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='게임 서버 목록';

--
-- Dumping data for table `table_game_server`
--

INSERT INTO `table_game_server` VALUES (1,1,'http://175.124.227.25:7200/Game/Index',7200,0);

--
-- Table structure for table `table_notice`
--

CREATE TABLE `table_notice` (
  `notice_code` int(11) NOT NULL AUTO_INCREMENT COMMENT '공지사항 코드 번호\n\n- 공지사항 하나가 하나의 웹 페이지 URL 서비스 한 개이다.',
  `location_code` smallint(6) NOT NULL COMMENT '서비스 대상 지역 코드 번호\n\n- 서비스 지역마다 다른 URL이 필요할 수 있다.\n : 특히 언어 문제 때문에... 제공해야 하는 컨텐츠도 다를 수 있다. ',
  `notice_link_id` int(11) NOT NULL DEFAULT '0' COMMENT '웹 페이지 링크 URL을 맵핑한 ID\n\n- data_notice_link.notice_link_id의 값이다.',
  `target_service_code` int(11) NOT NULL DEFAULT '0' COMMENT '어느 서비스를 대상으로 하는 이벤트인지 지정하기 위함이다.',
  `begin_datetime` datetime NOT NULL DEFAULT '1000-01-01 00:00:00' COMMENT '공지를 시작할 일시 ',
  `end_datetime` datetime NOT NULL DEFAULT '1000-01-01 00:00:00' COMMENT '공지를 종료할 일시 ',
  PRIMARY KEY (`notice_code`,`location_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='[Deprecated] 공지사항 정보 목록';

--
-- Dumping data for table `table_notice`
--


--
-- Table structure for table `table_notice_link`
--

CREATE TABLE `table_notice_link` (
  `notice_link_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '웹 페이지 링크마다 고유한 ID를 부여한다. ',
  `url` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '* 접속할 URL\n\n- 일반적인 웹 URL의 최대 길이 제한이 2000바이트 남짓이다.\n  : 현재는 utf8 인코딩을 쓰기 때문에 1글자당 최대 3바이트로 잡으면 최대 666.6666... 이므로 안전하게 665글자로 제한하면 된다.\n\n- 이에 대한 관련 근거는 다음을 참조\n : http://stackoverflow.com/questions/417142/what-is-the-maximum-length-of-a-url-in-different-browsers\n   http://www.boutell.com/newfaq/misc/urllength.html\n\n- 다만, 여기에서는 MySQL 5.7.7 이전의 기본 인덱스 제한 크기(767 byte)를 고려하여 글자수를 128자로 제한하였다. \n: MySQL 5.7.7 이후의 기본 인덱스 제한 크기는 3072byte임.\n  딱히 128자가 넘는 URL을 사용해야 할 이유도 없다.',
  PRIMARY KEY (`notice_link_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='[Deprecated] 공지사항 링크 URL 목록';

--
-- Dumping data for table `table_notice_link`
--


--
-- Table structure for table `table_occupation_war_season`
--

CREATE TABLE `table_occupation_war_season` (
  `mode` tinyint(4) NOT NULL COMMENT '점령전 모드의 종류\n: eOccupationWarMode의 값과 같다.',
  `season_number` int(11) NOT NULL COMMENT '시즌 번호\n: 시즌 번호는 점령전 모드 별로 따로 매긴다.',
  `start_datetime` datetime NOT NULL DEFAULT '1000-01-01 00:00:00' COMMENT '시즌의 시작일시',
  `end_datetime` datetime NOT NULL DEFAULT '1000-01-01 00:00:00' COMMENT '시즌의 종료일시',
  `update_datetime` datetime NOT NULL DEFAULT '1000-01-01 00:00:00' COMMENT '갱신일시',
  PRIMARY KEY (`mode`,`season_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='점령전 시즌 정보';

--
-- Dumping data for table `table_occupation_war_season`
--


--
-- Table structure for table `table_occupation_war_server`
--

CREATE TABLE `table_occupation_war_server` (
  `server_id` smallint(6) unsigned NOT NULL COMMENT '게임 서버의 ID\n\n- 게임 서버는 게임 DB 서버 당 254개까지 할당 가능하다. (1 ~ 255)\n\n- 게임 서버 ID를 표기할 경우에는 2바이트 정수를 사용하여 [DB 서버 ID | 서버 ID]와 같은 방식으로 표기해야 한다.',
  `url` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '* 접속할 URL\n\n- 다른 ID를 가진 게임 서버도 동일한 URL을 가질 수 있다.\n: 하나의 웹 서버 기계에 여러 프로세스의 웹 사이트를 띄우는 방식으로 운용할 경우에 그렇다. 이 때는 보통 포트 번호로 구분을 하게 된다.\n\n- 일반적인 웹 URL의 최대 길이 제한이 2000바이트 남짓이다.\n  : 현재는 utf8 인코딩을 쓰기 때문에 1글자당 최대 3바이트로 잡으면 최대 666.6666... 이므로 안전하게 665글자로 제한하면 된다.\n\n- 이에 대한 관련 근거는 다음을 참조\n : http://stackoverflow.com/questions/417142/what-is-the-maximum-length-of-a-url-in-different-browsers\n   http://www.boutell.com/newfaq/misc/urllength.html\n\n- 다만, 여기에서는 MySQL 5.7.7 이전의 기본 인덱스 제한 크기(767 byte)를 고려하여 글자수를 128자로 제한하였다. \n: MySQL 5.7.7 이후의 기본 인덱스 제한 크기는 3072byte임.\n  딱히 128자가 넘는 URL을 사용해야 할 이유도 없다.',
  `port` smallint(6) unsigned NOT NULL DEFAULT '80',
  PRIMARY KEY (`server_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='점령전 서버 접속 정보';

--
-- Dumping data for table `table_occupation_war_server`
--

INSERT INTO `table_occupation_war_server` VALUES (1,'175.124.227.25',34000);

--
-- Table structure for table `table_party_server`
--

CREATE TABLE `table_party_server` (
  `server_id` smallint(6) unsigned NOT NULL COMMENT '게임 서버의 ID\n\n- 게임 서버는 게임 DB 서버 당 254개까지 할당 가능하다. (1 ~ 255)\n\n- 게임 서버 ID를 표기할 경우에는 2바이트 정수를 사용하여 [DB 서버 ID | 서버 ID]와 같은 방식으로 표기해야 한다.',
  `url` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '* 접속할 URL\n\n- 다른 ID를 가진 게임 서버도 동일한 URL을 가질 수 있다.\n: 하나의 웹 서버 기계에 여러 프로세스의 웹 사이트를 띄우는 방식으로 운용할 경우에 그렇다. 이 때는 보통 포트 번호로 구분을 하게 된다.\n\n- 일반적인 웹 URL의 최대 길이 제한이 2000바이트 남짓이다.\n  : 현재는 utf8 인코딩을 쓰기 때문에 1글자당 최대 3바이트로 잡으면 최대 666.6666... 이므로 안전하게 665글자로 제한하면 된다.\n\n- 이에 대한 관련 근거는 다음을 참조\n : http://stackoverflow.com/questions/417142/what-is-the-maximum-length-of-a-url-in-different-browsers\n   http://www.boutell.com/newfaq/misc/urllength.html\n\n- 다만, 여기에서는 MySQL 5.7.7 이전의 기본 인덱스 제한 크기(767 byte)를 고려하여 글자수를 128자로 제한하였다. \n: MySQL 5.7.7 이후의 기본 인덱스 제한 크기는 3072byte임.\n  딱히 128자가 넘는 URL을 사용해야 할 이유도 없다.',
  `port` smallint(6) unsigned NOT NULL DEFAULT '80',
  PRIMARY KEY (`server_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='파티 서버 접속 정보';

--
-- Dumping data for table `table_party_server`
--

INSERT INTO `table_party_server` VALUES (1,'175.124.227.25',32000);

--
-- Table structure for table `table_ranking_server`
--

CREATE TABLE `table_ranking_server` (
  `server_id` smallint(6) unsigned NOT NULL COMMENT '게임 서버의 ID\n\n- 게임 서버는 게임 DB 서버 당 254개까지 할당 가능하다. (1 ~ 255)\n\n- 게임 서버 ID를 표기할 경우에는 2바이트 정수를 사용하여 [DB 서버 ID | 서버 ID]와 같은 방식으로 표기해야 한다.',
  `url` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '* 접속할 URL\n\n- 다른 ID를 가진 게임 서버도 동일한 URL을 가질 수 있다.\n: 하나의 웹 서버 기계에 여러 프로세스의 웹 사이트를 띄우는 방식으로 운용할 경우에 그렇다. 이 때는 보통 포트 번호로 구분을 하게 된다.\n\n- 일반적인 웹 URL의 최대 길이 제한이 2000바이트 남짓이다.\n  : 현재는 utf8 인코딩을 쓰기 때문에 1글자당 최대 3바이트로 잡으면 최대 666.6666... 이므로 안전하게 665글자로 제한하면 된다.\n\n- 이에 대한 관련 근거는 다음을 참조\n : http://stackoverflow.com/questions/417142/what-is-the-maximum-length-of-a-url-in-different-browsers\n   http://www.boutell.com/newfaq/misc/urllength.html\n\n- 다만, 여기에서는 MySQL 5.7.7 이전의 기본 인덱스 제한 크기(767 byte)를 고려하여 글자수를 128자로 제한하였다. \n: MySQL 5.7.7 이후의 기본 인덱스 제한 크기는 3072byte임.\n  딱히 128자가 넘는 URL을 사용해야 할 이유도 없다.',
  `port` smallint(6) unsigned NOT NULL DEFAULT '80',
  PRIMARY KEY (`server_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='랭킹 서버 접속 정보';

--
-- Dumping data for table `table_ranking_server`
--

INSERT INTO `table_ranking_server` VALUES (1,'175.124.227.25',33000);

--
-- Table structure for table `table_service`
--

CREATE TABLE `table_service` (
  `service_code` int(11) NOT NULL COMMENT '서비스 코드 번호\n\n- date_service.service_code의 값이다.\n\n- 출시 지역, 마켓을 구분하기 위해 존재한다.',
  `service_step` tinyint(4) NOT NULL COMMENT '출시 단계 구분 (eServiceRelease의 타입과 같다.)\n\n  0 = LocalMachine: 개발자 테스트(개인 테스트)\n  1 = Development: 비공개 테스트(개발 단계)\n  2 = Private: 공개 테스트\n  3 = Publish: 검수 대기\n\n - 출시 단계에 따라 다른 DB, 다른 서버에 연결하게 만들어야 할 경우가 있다.\n  : 현재 서비스 중인 구 버전의 사용자들에게 영향을 주지 않게 하거나, 새로운 게임 데이터 포맷 등을 적용할 수 있게 하기 위해서다.',
  `application_version` int(11) NOT NULL DEFAULT '0' COMMENT 'service_code + publish_step에 적용할 애플리케이션의 버전\n\n- 버전 값은 32비트 정수형으로 변환한 값을 사용해야 한다.',
  `application_access_link_id` int(11) NOT NULL DEFAULT '0' COMMENT 'service_code + publish_step에 적용할 애플리케이션의 서버 액세스 링크 ID\n\n- data_access_link.access_link_id의 값과 같다.\n\n- 여러 개의 서비스 코드와 출시 상태가 같은 액세스 링크를 가질 수 있기 때문에, 중복 문자열 저장을 피하고자 액세스 링크에 대한 테이블을 별도로 두고, 그 ID를 지정하게 하였다.',
  `game_data_version` int(11) NOT NULL DEFAULT '0' COMMENT 'service_code + publish_step에 적용할 다운로드 데이터의 버전\n\n- 애플리케이션 버전과 별도로 다운로드 데이터의 버전을 지정한다.\n\n- 애플리케이션의 패치 없이 데이터만 다시 가져오는 것으로 게임 내용을 변경해야 할 경우가 있다. 이렇게 할 수 있는 여지가 많을수록 중단 없이 서비스를 할 수 있다.',
  `game_data_link_id` int(11) NOT NULL DEFAULT '0' COMMENT 'service_code + publish_step에 적용할 데이터 다운로드 액세스 링크 ID\n\n- data_patch_link.patch_link_id의 값과 같다.\n\n- 여러 개의 서비스 코드와 출시 상태가 같은 액세스 링크를 가질 수 있기 때문에, 중복 문자열 저장을 피하고자 액세스 링크에 대한 테이블을 별도로 두고, 그 ID를 지정하게 하였다.',
  PRIMARY KEY (`service_code`,`service_step`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='[Deprecated] 게임 서비스 정보';

--
-- Dumping data for table `table_service`
--


--
-- Dumping events for database 'eod_configuration'
--

--
-- Dumping routines for database 'eod_configuration'
--
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_achievement` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_achievement`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `previous_achieve_code` AS `previousAchieveCode`, 

        `next_achieve_code` AS `nextAchieveCode`, 

        `achievement_type` AS `achievementType`, 

        `mission_type` AS `missionType`, 

        `sub_mission_type` AS `subMissionType`, 

        `clear_type` AS `clearType`, 

        `clear_value` AS `clearValue`, 

        `reward_type_code` AS `rewardTypeCode`, 

        `reward_count` AS `rewardCount`, 

        `equip_type` AS `equipType`

    FROM `eod_configuration`.`data_achievement`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_act_clear_grade_reward` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_act_clear_grade_reward`()
BEGIN

    SELECT

        `act_general_code` AS `actGeneralCode`, 

        `act_no` AS `actNo`, 

        `need_star_count1` AS `needStarCount1`, 

        `general_type_code1` AS `generalTypeCode1`, 

        `item_count1` AS `itemCount1`, 

        `need_star_count2` AS `needStarCount2`, 

        `general_type_code2` AS `generalTypeCode2`, 

        `item_count2` AS `itemCount2`, 

        `need_star_count3` AS `needStarCount3`, 

        `general_type_code3` AS `generalTypeCode3`, 

        `item_count3` AS `itemCount3`, 

        `need_star_count4` AS `needStarCount4`, 

        `general_type_code4` AS `generalTypeCode4`, 

        `item_count4` AS `itemCount4`

    FROM `eod_configuration`.`data_act_clear_grade_reward`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_act_reward_info` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_act_reward_info`()
BEGIN

    SELECT

        `act_general_code` AS `actGeneralCode`, 

        `e_stage_type` AS `eStageType`, 

        `act_no` AS `actNo`, 

        `first_reward_gem_code` AS `firstRewardGemCode`, 

        `gem_repetition_count` AS `gemRepetitionCount`, 

        `gem_count` AS `gemCount`, 

        `reward_gold_code` AS `rewardGoldCode`, 

        `gold_repetition_count` AS `goldRepetitionCount`, 

        `gold_count` AS `goldCount`

    FROM `eod_configuration`.`data_act_reward_info`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_add_reward` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_add_reward`()
BEGIN

    SELECT

        `add_reward_group_code` AS `addRewardGroupCode`, 

        `group_type` AS `groupType`, 

        `drop_rate_type` AS `dropRateType`, 

        `required_class` AS `requiredClass`, 

        `general_type_code` AS `generalTypeCode`, 

        `drop_rate` AS `dropRate`, 

        `drop_item_count_min` AS `dropItemCountMin`, 

        `drop_item_count_max` AS `dropItemCountMax`, 

        `acquisition_route_text_code` AS `acquisitionRouteTextCode`

    FROM `eod_configuration`.`data_add_reward`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_alchemy_data` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_alchemy_data`()
BEGIN

    SELECT

        `alchemy_id` AS `alchemyId`, 

        `alchemy_type` AS `alchemyType`, 

        `possible_conversion_type` AS `possibleConversionType`, 

        `item_division` AS `itemDivision`, 

        `equip_type` AS `equipType`, 

        `item_set_type` AS `itemSetType`, 

        `inventory_type` AS `inventoryType`, 

        `nox_item` AS `noxItem`, 

        `grade` AS `grade`, 

        `item_upgrade_level` AS `itemUpgradeLevel`, 

        `alchemy_gold_cost` AS `alchemyGoldCost`, 

        `alchemy_material_group_id` AS `alchemyMaterialGroupId`, 

        `need_guardian_stone_count` AS `needGuardianStoneCount`, 

        `guardian_stone_lv` AS `guardianStoneLv`, 

        `result_item_group_id` AS `resultItemGroupId`

    FROM `eod_configuration`.`data_alchemy_data`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_alchemy_material` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_alchemy_material`()
BEGIN

    SELECT

        `alchemy_material_group_id` AS `alchemyMaterialGroupId`, 

        `material_item_type_code` AS `materialItemTypeCode`, 

        `material_item_count` AS `materialItemCount`

    FROM `eod_configuration`.`data_alchemy_material`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_alchemy_result_item_group` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_alchemy_result_item_group`()
BEGIN

    SELECT

        `gacha_item_group_code` AS `gachaItemGroupCode`, 

        `item_code` AS `itemCode`, 

        `item_count` AS `itemCount`, 

        `required_class` AS `requiredClass`, 

        `equip_type` AS `equipType`, 

        `group_rate` AS `groupRate`

    FROM `eod_configuration`.`data_alchemy_result_item_group`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_attendance_event` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_attendance_event`()
BEGIN

    SELECT

        `event_group_code` AS `eventGroupCode`, 

        `data_target` AS `dataTarget`, 

        `rounds` AS `rounds`, 

        `reward_item_code1` AS `rewardItemCode1`, 

        `reward_item_count1` AS `rewardItemCount1`, 

        `reward_item_code2` AS `rewardItemCode2`, 

        `reward_item_count2` AS `rewardItemCount2`

    FROM `eod_configuration`.`data_attendance_event`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_attendance_event_group` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_attendance_event_group`()
BEGIN

    SELECT

        `event_group_code` AS `eventGroupCode`, 

        `start_date` AS `startDate`, 

        `end_date` AS `endDate`

    FROM `eod_configuration`.`data_attendance_event_group`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_attendance_reward` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_attendance_reward`()
BEGIN

    SELECT

        `reward_general_code` AS `rewardGeneralCode`, 

        `required_class` AS `requiredClass`, 

        `attendance_type` AS `attendanceType`, 

        `attendance_num` AS `attendanceNum`, 

        `general_type_code` AS `generalTypeCode`, 

        `item_count` AS `itemCount`, 

        `equip_type` AS `equipType`, 

        `grade` AS `grade`

    FROM `eod_configuration`.`data_attendance_reward`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_avatar` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_avatar`()
BEGIN

    SELECT

        `avatar_index` AS `avatarIndex`, 

        `class_type` AS `classType`, 

        `equip_type` AS `equipType`, 

        `avatar_parts_general_code` AS `avatarPartsGeneralCode`, 

        `price_type` AS `priceType`, 

        `price` AS `price`, 

        `avatar_upgrade_group_id` AS `avatarUpgradeGroupId`, 

        `avatar_upgrade_level` AS `avatarUpgradeLevel`, 

        `avatar_level_limit` AS `avatarLevelLimit`, 

        `avatar_option_division` AS `avatarOptionDivision`, 

        `avatar_option_ability` AS `avatarOptionAbility`

    FROM `eod_configuration`.`data_avatar`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_avatar_enchant_type` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_avatar_enchant_type`()
BEGIN

    SELECT

        `avatar_enchant_index` AS `avatarEnchantIndex`, 

        `avatar_enchant_type` AS `avatarEnchantType`, 

        `current_enchant_level` AS `currentEnchantLevel`, 

        `next_enchant_level` AS `nextEnchantLevel`, 

        `enchant_success_ratio` AS `enchantSuccessRatio`, 

        `material_needs_count` AS `materialNeedsCount`, 

        `success_enchant_min` AS `successEnchantMin`, 

        `success_enchant_max` AS `successEnchantMax`, 

        `avatar_weapon_ability` AS `avatarWeaponAbility`, 

        `avatar_helm_ability` AS `avatarHelmAbility`, 

        `avatar_amor_ability` AS `avatarAmorAbility`, 

        `avatar_special_ability` AS `avatarSpecialAbility`

    FROM `eod_configuration`.`data_avatar_enchant_type`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_avatar_set` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_avatar_set`()
BEGIN

    SELECT

        `avatar_set_index` AS `avatarSetIndex`, 

        `set_number` AS `setNumber`, 

        `class_type` AS `classType`, 

        `avatar_index_head` AS `avatarIndexHead`, 

        `avatar_index_body` AS `avatarIndexBody`, 

        `avatar_index_special` AS `avatarIndexSpecial`, 

        `avatar_index_weapon` AS `avatarIndexWeapon`

    FROM `eod_configuration`.`data_avatar_set`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_avatar_upgrade` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_avatar_upgrade`()
BEGIN

    SELECT

        `avatar_upgrade_group_id` AS `avatarUpgradeGroupId`, 

        `avatar_enchant_type` AS `avatarEnchantType`, 

        `material_item_code1` AS `materialItemCode1`, 

        `material_weight` AS `materialWeight`

    FROM `eod_configuration`.`data_avatar_upgrade`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_ban_filter_text` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_ban_filter_text`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `filtering_type` AS `filteringType`, 

        `adjust_name` AS `adjustName`, 

        `adjust_chat` AS `adjustChat`, 

        `text` AS `text`

    FROM `eod_configuration`.`data_ban_filter_text`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_bombbit` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_bombbit`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `monster_grade_type` AS `monsterGradeType`, 

        `bombbit_balse_ability` AS `bombbitBalseAbility`, 

        `level_per_bombbit_ability` AS `levelPerBombbitAbility`, 

        `limit_bombbit_ability` AS `limitBombbitAbility`, 

        `damage_range` AS `damageRange`, 

        `search_range` AS `searchRange`, 

        `damage_target_count` AS `damageTargetCount`, 

        `move_speed` AS `moveSpeed`

    FROM `eod_configuration`.`data_bombbit`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_character` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_character`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `class_type` AS `classType`, 

        `class_type_number` AS `classTypeNumber`, 

        `slot_open` AS `slotOpen`, 

        `slot_open_level` AS `slotOpenLevel`, 

        `create_level` AS `createLevel`

    FROM `eod_configuration`.`data_character`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_character_guardian_level` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_character_guardian_level`()
BEGIN

    SELECT

        `guardianlevel` AS `guardianlevel`, 

        `g_accumulation_exp` AS `gAccumulationExp`, 

        `g_need_next_exp` AS `gNeedNextExp`, 

        `g_skill_dision` AS `gSkillDision`, 

        `g_reward_skill_point` AS `gRewardSkillPoint`, 

        `add_hp` AS `addHp`, 

        `add_def` AS `addDef`

    FROM `eod_configuration`.`data_character_guardian_level`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_consume_item` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_consume_item`()
BEGIN

    SELECT

        `result_item_id` AS `resultItemId`, 

        `stage_type_able_group_id` AS `stageTypeAbleGroupId`

    FROM `eod_configuration`.`data_consume_item`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_consume_map` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_consume_map`()
BEGIN

    SELECT

        `stage_type_able_group_id` AS `stageTypeAbleGroupId`, 

        `stage_type_able_group` AS `stageTypeAbleGroup`, 

        `consume_count_limit` AS `consumeCountLimit`

    FROM `eod_configuration`.`data_consume_map`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_craft_item` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_craft_item`()
BEGIN

    SELECT

        `craft_id` AS `craftId`, 

        `result_item_id` AS `resultItemId`, 

        `craft_rate` AS `craftRate`, 

        `craft_set_limit` AS `craftSetLimit`, 

        `result_item_count_min` AS `resultItemCountMin`, 

        `result_item_count_max` AS `resultItemCountMax`, 

        `craft_material_group_id` AS `craftMaterialGroupId`, 

        `craft_cost` AS `craftCost`, 

        `craft_materia_need_type` AS `craftMateriaNeedType`

    FROM `eod_configuration`.`data_craft_item`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_craft_material` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_craft_material`()
BEGIN

    SELECT

        `craft_material_group_id` AS `craftMaterialGroupId`, 

        `craft_material_num` AS `craftMaterialNum`, 

        `craft_materia_need_type` AS `craftMateriaNeedType`, 

        `material_item_id` AS `materialItemId`, 

        `material_item_count` AS `materialItemCount`

    FROM `eod_configuration`.`data_craft_material`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_default_value` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_default_value`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `value` AS `value`

    FROM `eod_configuration`.`data_default_value`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_elite_stage` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_elite_stage`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `stage_type` AS `stageType`, 

        `act_number` AS `actNumber`, 

        `stage_number_in_act` AS `stageNumberInAct`, 

        `recommend_atk` AS `recommendAtk`, 

        `atk_ratio` AS `atkRatio`, 

        `def_ratio` AS `defRatio`, 

        `stage_exp` AS `stageExp`, 

        `guardian_exp` AS `guardianExp`, 

        `stage_gold` AS `stageGold`, 

        `auto_connection_skill_gold` AS `autoConnectionSkillGold`, 

        `bonus_type` AS `bonusType`, 

        `bonus_value` AS `bonusValue`, 

        `limit_time_second` AS `limitTimeSecond`, 

        `recommend_level_min` AS `recommendLevelMin`, 

        `recommend_level_max` AS `recommendLevelMax`, 

        `previous_stage_code` AS `previousStageCode`, 

        `next_stage_code` AS `nextStageCode`, 

        `reward_general_code` AS `rewardGeneralCode`, 

        `reward_count_min` AS `rewardCountMin`, 

        `reward_count_max` AS `rewardCountMax`, 

        `reward_general_code1` AS `rewardGeneralCode1`, 

        `reward_count_min1` AS `rewardCountMin1`, 

        `reward_count_max1` AS `rewardCountMax1`, 

        `entry_cost_type` AS `entryCostType`, 

        `entry_cost_amount` AS `entryCostAmount`, 

        `entry_limit_type` AS `entryLimitType`, 

        `entry_limit_count` AS `entryLimitCount`, 

        `boss_monster_code` AS `bossMonsterCode`, 

        `monster_level` AS `monsterLevel`, 

        `auto_skill_cost` AS `autoSkillCost`, 

        `add_reward_group_code` AS `addRewardGroupCode`

    FROM `eod_configuration`.`data_elite_stage`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_elite_stage_reward` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_elite_stage_reward`()
BEGIN

    SELECT

        `reward_general_code` AS `rewardGeneralCode`, 

        `stage_general_code` AS `stageGeneralCode`, 

        `required_class` AS `requiredClass`, 

        `act` AS `act`, 

        `stage_no` AS `stageNo`, 

        `general_type_code` AS `generalTypeCode`, 

        `item_min_count` AS `itemMinCount`, 

        `item_max_count` AS `itemMaxCount`, 

        `drop_rate` AS `dropRate`, 

        `equip_type` AS `equipType`, 

        `grade` AS `grade`

    FROM `eod_configuration`.`data_elite_stage_reward`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_event_coupon_reward` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_event_coupon_reward`()
BEGIN

    SELECT

        `coupon_reward_group` AS `couponRewardGroup`, 

        `item_gtc` AS `itemGtc`, 

        `item_count` AS `itemCount`

    FROM `eod_configuration`.`data_event_coupon_reward`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_fixed_option_group` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_fixed_option_group`()
BEGIN

    SELECT

        `fixed_option_group_id` AS `fixedOptionGroupId`, 

        `option_division` AS `optionDivision`, 

        `option_rank` AS `optionRank`, 

        `option_adjust_type` AS `optionAdjustType`, 

        `option_data_type` AS `optionDataType`, 

        `option_value_min` AS `optionValueMin`, 

        `option_value_max` AS `optionValueMax`, 

        `interval` AS `interval`, 

        `option_rate` AS `optionRate`

    FROM `eod_configuration`.`data_fixed_option_group`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_gacha_reward` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_gacha_reward`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `count` AS `count`, 

        `product1_type_code` AS `product1TypeCode`, 

        `product1_amount` AS `product1Amount`, 

        `product2_type_code` AS `product2TypeCode`, 

        `product2_amount` AS `product2Amount`, 

        `product3_type_code` AS `product3TypeCode`, 

        `product3_amount` AS `product3Amount`, 

        `product4_type_code` AS `product4TypeCode`, 

        `product4_amount` AS `product4Amount`

    FROM `eod_configuration`.`data_gacha_reward`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_gd_stone_upgrade` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_gd_stone_upgrade`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `difference_step_min` AS `differenceStepMin`, 

        `difference_step_max` AS `differenceStepMax`, 

        `upgrade_rate` AS `upgradeRate`

    FROM `eod_configuration`.`data_gd_stone_upgrade`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_guardian_raid` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_guardian_raid`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `stage_type` AS `stageType`, 

        `stage_number_in_act` AS `stageNumberInAct`, 

        `atk_ratio` AS `atkRatio`, 

        `def_ratio` AS `defRatio`, 

        `stage_exp` AS `stageExp`, 

        `guardian_exp` AS `guardianExp`, 

        `stage_gold` AS `stageGold`, 

        `auto_connection_skill_gold` AS `autoConnectionSkillGold`, 

        `bgm_index` AS `bgmIndex`, 

        `limit_time_second` AS `limitTimeSecond`, 

        `recommend_level` AS `recommendLevel`, 

        `reward_general_code` AS `rewardGeneralCode`, 

        `icon_image_code` AS `iconImageCode`, 

        `reward_count_min` AS `rewardCountMin`, 

        `reward_count_max` AS `rewardCountMax`, 

        `party_reward_group_code` AS `partyRewardGroupCode`, 

        `entry_cost_type` AS `entryCostType`, 

        `entry_cost_amount` AS `entryCostAmount`, 

        `entry_limit_type` AS `entryLimitType`, 

        `entry_limit_count` AS `entryLimitCount`, 

        `monster_level` AS `monsterLevel`, 

        `add_reward_group_code` AS `addRewardGroupCode`

    FROM `eod_configuration`.`data_guardian_raid`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_guardian_raid_reward` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_guardian_raid_reward`()
BEGIN

    SELECT

        `reward_general_code` AS `rewardGeneralCode`, 

        `stage_general_code` AS `stageGeneralCode`, 

        `required_class` AS `requiredClass`, 

        `act` AS `act`, 

        `stage_no` AS `stageNo`, 

        `general_type_code` AS `generalTypeCode`, 

        `item_min_count` AS `itemMinCount`, 

        `item_max_count` AS `itemMaxCount`, 

        `drop_rate` AS `dropRate`, 

        `equip_type` AS `equipType`, 

        `grade` AS `grade`

    FROM `eod_configuration`.`data_guardian_raid_reward`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_guardian_stone` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_guardian_stone`()
BEGIN

    SELECT

        `index` AS `index`, 

        `precondition_dext_code` AS `preconditionDextCode`, 

        `guardian_stone_kind` AS `guardianStoneKind`, 

        `affiliation_type` AS `affiliationType`, 

        `precondition_ability_level` AS `preconditionAbilityLevel`, 

        `ability_type` AS `abilityType`, 

        `precondition_ability_type` AS `preconditionAbilityType`, 

        `base_ability` AS `baseAbility`, 

        `precondition_ability` AS `preconditionAbility`, 

        `base_ability_invoke_rate` AS `baseAbilityInvokeRate`, 

        `level_per_base_invoke_rate` AS `levelPerBaseInvokeRate`, 

        `precondition_ability_invoke_rate` AS `preconditionAbilityInvokeRate`, 

        `base_duration` AS `baseDuration`, 

        `level_per_base_duration` AS `levelPerBaseDuration`, 

        `level_per_base_ability` AS `levelPerBaseAbility`, 

        `limit_base_ability` AS `limitBaseAbility`, 

        `param1` AS `param1`, 

        `param2` AS `param2`, 

        `param3` AS `param3`, 

        `param4` AS `param4`, 

        `param5` AS `param5`, 

        `prefab` AS `prefab`, 

        `base_ignore_option_group` AS `baseIgnoreOptionGroup`, 

        `base_remove_option_group` AS `baseRemoveOptionGroup`, 

        `precon_ignore_option_group` AS `preconIgnoreOptionGroup`, 

        `precon_remove_option_group` AS `preconRemoveOptionGroup`, 

        `occupation_gstone_setting_lv` AS `occupationGstoneSettingLv`

    FROM `eod_configuration`.`data_guardian_stone`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_guardian_stone_immune_opt_group` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_guardian_stone_immune_opt_group`()
BEGIN

    SELECT

        `immune_option_group` AS `immuneOptionGroup`, 

        `option_division` AS `optionDivision`, 

        `tec_desc` AS `tecDesc`

    FROM `eod_configuration`.`data_guardian_stone_immune_opt_group`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_guardian_stone_remove_option_group` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_guardian_stone_remove_option_group`()
BEGIN

    SELECT

        `remove_option_group` AS `removeOptionGroup`, 

        `option_division` AS `optionDivision`, 

        `tec_desc` AS `tecDesc`

    FROM `eod_configuration`.`data_guardian_stone_remove_option_group`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_guild_level_experience` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_guild_level_experience`()
BEGIN

    SELECT

        `level` AS `level`, 

        `need_experience` AS `needExperience`, 

        `need_experience_to_next_level` AS `needExperienceToNextLevel`

    FROM `eod_configuration`.`data_guild_level_experience`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_guild_shop` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_guild_shop`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `use_time` AS `useTime`, 

        `equip_type` AS `equipType`, 

        `price` AS `price`

    FROM `eod_configuration`.`data_guild_shop`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_guild_skill` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_guild_skill`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `skill_enchant` AS `skillEnchant`, 

        `recommend_guild_level` AS `recommendGuildLevel`, 

        `use_guildl_skill_point` AS `useGuildlSkillPoint`, 

        `option_code` AS `optionCode`, 

        `data_type` AS `dataType`, 

        `option_value` AS `optionValue`

    FROM `eod_configuration`.`data_guild_skill`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_guild_war_ranking` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_guild_war_ranking`()
BEGIN

    SELECT

        `reward_general_code` AS `rewardGeneralCode`, 

        `reward_type` AS `rewardType`, 

        `rank_grade` AS `rankGrade`, 

        `require_point_min` AS `requirePointMin`, 

        `require_point_max` AS `requirePointMax`, 

        `min_count` AS `minCount`, 

        `max_count` AS `maxCount`, 

        `min_rate` AS `minRate`, 

        `max_rate` AS `maxRate`, 

        `season_item_reward_gtc` AS `seasonItemRewardGtc`, 

        `season_item_reward_count` AS `seasonItemRewardCount`, 

        `season_item_reward2gtc` AS `seasonItemReward2gtc`, 

        `season_item_reward2_count` AS `seasonItemReward2Count`, 

        `season_item_reward3gtc` AS `seasonItemReward3gtc`, 

        `season_item_reward3_count` AS `seasonItemReward3Count`, 

        `season_item_reward4gtc` AS `seasonItemReward4gtc`, 

        `season_item_reward4_count` AS `seasonItemReward4Count`, 

        `season_item_reward5gtc` AS `seasonItemReward5gtc`, 

        `season_item_reward5_count` AS `seasonItemReward5Count`, 

        `icon_image_code` AS `iconImageCode`

    FROM `eod_configuration`.`data_guild_war_ranking`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_guild_war_reward` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_guild_war_reward`()
BEGIN

    SELECT

        `reward_type` AS `rewardType`, 

        `reward_general_code` AS `rewardGeneralCode`, 

        `stage_general_code` AS `stageGeneralCode`, 

        `rank_grade` AS `rankGrade`, 

        `required_class` AS `requiredClass`, 

        `general_type_code` AS `generalTypeCode`, 

        `item_min_count` AS `itemMinCount`, 

        `item_max_count` AS `itemMaxCount`, 

        `drop_rate` AS `dropRate`

    FROM `eod_configuration`.`data_guild_war_reward`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_immune_option_group` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_immune_option_group`()
BEGIN

    SELECT

        `immune_option_group` AS `immuneOptionGroup`, 

        `option_division` AS `optionDivision`, 

        `tec_desc` AS `tecDesc`

    FROM `eod_configuration`.`data_immune_option_group`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_inven_extend` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_inven_extend`()
BEGIN

    SELECT

        `extend_grade` AS `extendGrade`, 

        `increase_value` AS `increaseValue`, 

        `accumulate_value` AS `accumulateValue`, 

        `equip_type` AS `equipType`, 

        `inven_extend_price` AS `invenExtendPrice`

    FROM `eod_configuration`.`data_inven_extend`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_item` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_item`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `equipable` AS `equipable`, 

        `required_class` AS `requiredClass`, 

        `item_set_type` AS `itemSetType`, 

        `item_enable` AS `itemEnable`, 

        `need_class` AS `needClass`, 

        `item_grade` AS `itemGrade`, 

        `grade` AS `grade`, 

        `item_group` AS `itemGroup`, 

        `item_division` AS `itemDivision`, 

        `weapon_type` AS `weaponType`, 

        `equip_type` AS `equipType`, 

        `equip_slot` AS `equipSlot`, 

        `decomposition_state` AS `decompositionState`, 

        `decomposition_code` AS `decompositionCode`, 

        `upgrade_enable` AS `upgradeEnable`, 

        `upgrade_limit` AS `upgradeLimit`, 

        `required_level` AS `requiredLevel`, 

        `option_division` AS `optionDivision`, 

        `ib_attk_pow_constant` AS `ibAttkPowConstant`, 

        `ib_dfs_pow_constant` AS `ibDfsPowConstant`, 

        `ib_hp_constant` AS `ibHpConstant`, 

        `ib_st_reg` AS `ibStReg`, 

        `item_value` AS `itemValue`, 

        `target_inventory_type` AS `targetInventoryType`, 

        `enable_to_sell` AS `enableToSell`, 

        `store_sale_price` AS `storeSalePrice`, 

        `storable` AS `storable`, 

        `stack_type` AS `stackType`, 

        `stack_limit_per_slot` AS `stackLimitPerSlot`, 

        `possesion_count_limit` AS `possesionCountLimit`, 

        `item_stack` AS `itemStack`, 

        `consumable` AS `consumable`, 

        `consume_unit` AS `consumeUnit`, 

        `cooldown_time` AS `cooldownTime`, 

        `skill_link_id` AS `skillLinkId`, 

        `random_option_group` AS `randomOptionGroup`, 

        `random_option_count` AS `randomOptionCount`, 

        `set_group_id` AS `setGroupId`, 

        `fixed_option_group` AS `fixedOptionGroup`, 

        `trans_group_id` AS `transGroupId`, 

        `socket_count` AS `socketCount`, 

        `promotion_item_code` AS `promotionItemCode`, 

        `fusion_group_id` AS `fusionGroupId`, 

        `rune_option_group_id` AS `runeOptionGroupId`, 

        `nox_item` AS `noxItem`

    FROM `eod_configuration`.`data_item`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_item_choice_ticket` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_item_choice_ticket`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `item_choice_group_id` AS `itemChoiceGroupId`, 

        `required_class` AS `requiredClass`, 

        `item_list_code` AS `itemListCode`

    FROM `eod_configuration`.`data_item_choice_ticket`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_item_combine` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_item_combine`()
BEGIN

    SELECT

        `combine_group_id` AS `combineGroupId`, 

        `combine_rank` AS `combineRank`, 

        `con_item_division` AS `conItemDivision`, 

        `item_count` AS `itemCount`, 

        `need_echant_level` AS `needEchantLevel`, 

        `trans_item` AS `transItem`

    FROM `eod_configuration`.`data_item_combine`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_item_decompose` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_item_decompose`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `item_type_code` AS `itemTypeCode`, 

        `decomposition_item_code` AS `decompositionItemCode`, 

        `calculation_type` AS `calculationType`, 

        `item_count` AS `itemCount`

    FROM `eod_configuration`.`data_item_decompose`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_item_fusion` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_item_fusion`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `fusion_group_id` AS `fusionGroupId`, 

        `fusion_item_code` AS `fusionItemCode`, 

        `drop_rate` AS `dropRate`

    FROM `eod_configuration`.`data_item_fusion`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_item_nox_enchant` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_item_nox_enchant`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `nox_item` AS `noxItem`, 

        `equip_type` AS `equipType`, 

        `grade` AS `grade`, 

        `value_flag` AS `valueFlag`, 

        `value_recalculate` AS `valueRecalculate`, 

        `value_pencentage` AS `valuePencentage`, 

        `nox_grade_enchant_rate` AS `noxGradeEnchantRate`, 

        `enchant_material_gtc` AS `enchantMaterialGtc`, 

        `enchant_material_counts` AS `enchantMaterialCounts`

    FROM `eod_configuration`.`data_item_nox_enchant`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_item_set` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_item_set`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `set_count1` AS `setCount1`, 

        `option_division1` AS `optionDivision1`, 

        `option_value1` AS `optionValue1`, 

        `set_count2` AS `setCount2`, 

        `option_division2` AS `optionDivision2`, 

        `option_value2` AS `optionValue2`, 

        `set_count3` AS `setCount3`, 

        `option_division3` AS `optionDivision3`, 

        `option_value3` AS `optionValue3`

    FROM `eod_configuration`.`data_item_set`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_item_trans` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_item_trans`()
BEGIN

    SELECT

        `trans_group_id` AS `transGroupId`, 

        `trans_type` AS `transType`, 

        `con_item_id` AS `conItemId`, 

        `item_count` AS `itemCount`, 

        `get_rate` AS `getRate`, 

        `get_rank` AS `getRank`

    FROM `eod_configuration`.`data_item_trans`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_item_upgrade` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_item_upgrade`()
BEGIN

    SELECT

        `upgrade_group_id` AS `upgradeGroupId`, 

        `item_upgrade_level` AS `itemUpgradeLevel`, 

        `success_rate` AS `successRate`, 

        `improvement` AS `improvement`, 

        `upgrade_cost` AS `upgradeCost`, 

        `revision_item_id` AS `revisionItemId`, 

        `revision_rate` AS `revisionRate`, 

        `material_item_code1` AS `materialItemCode1`, 

        `item_count_1` AS `itemCount1`, 

        `material_item_code2` AS `materialItemCode2`, 

        `item_count_2` AS `itemCount2`

    FROM `eod_configuration`.`data_item_upgrade`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_mission` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_mission`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `period_type` AS `periodType`, 

        `mission_type` AS `missionType`, 

        `sub_mission_type` AS `subMissionType`, 

        `clear_type` AS `clearType`, 

        `clear_value` AS `clearValue`, 

        `reward_type_code` AS `rewardTypeCode`, 

        `reward_count` AS `rewardCount`, 

        `equip_type` AS `equipType`

    FROM `eod_configuration`.`data_mission`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_monster` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_monster`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `target_type_code` AS `targetTypeCode`, 

        `monster_grade_type` AS `monsterGradeType`, 

        `random_monster_level_part` AS `randomMonsterLevelPart`, 

        `hp` AS `hp`, 

        `hp_regeneration_per5_sec` AS `hpRegenerationPer5Sec`, 

        `stm_chrg` AS `stmChrg`, 

        `attk_pow` AS `attkPow`, 

        `attk_spd` AS `attkSpd`, 

        `crt_rt` AS `crtRt`, 

        `ctr_pow` AS `ctrPow`, 

        `crt_pow_decr` AS `crtPowDecr`, 

        `dmg_decr` AS `dmgDecr`, 

        `dfs_pow` AS `dfsPow`, 

        `avd_rt` AS `avdRt`, 

        `accr` AS `accr`, 

        `st_reg` AS `stReg`, 

        `mv_spd` AS `mvSpd`, 

        `dk_frc` AS `dkFrc`

    FROM `eod_configuration`.`data_monster`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_monster_spawn` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_monster_spawn`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `monster_code` AS `monsterCode`, 

        `level_select_type` AS `levelSelectType`, 

        `level_select_static_value` AS `levelSelectStaticValue`, 

        `level_offset_min` AS `levelOffsetMin`, 

        `level_offset_max` AS `levelOffsetMax`, 

        `spawn_min_radius` AS `spawnMinRadius`, 

        `spawn_max_radius` AS `spawnMaxRadius`, 

        `count` AS `count`

    FROM `eod_configuration`.`data_monster_spawn`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_monster_standard_status` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_monster_standard_status`()
BEGIN

    SELECT

        `level` AS `level`, 

        `hp` AS `hp`, 

        `hp_regeneration_per5_sec` AS `hpRegenerationPer5Sec`, 

        `stm_chrg` AS `stmChrg`, 

        `attk_pow` AS `attkPow`, 

        `attk_spd` AS `attkSpd`, 

        `crt_rt` AS `crtRt`, 

        `ctr_pow` AS `ctrPow`, 

        `crt_pow_decr` AS `crtPowDecr`, 

        `dmg_decr` AS `dmgDecr`, 

        `dfs_pow` AS `dfsPow`, 

        `avd_rt` AS `avdRt`, 

        `accr` AS `accr`, 

        `st_reg` AS `stReg`, 

        `mv_spd` AS `mvSpd`, 

        `dk_frc` AS `dkFrc`

    FROM `eod_configuration`.`data_monster_standard_status`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_needs_g_stone_group` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_needs_g_stone_group`()
BEGIN

    SELECT

        `g_stone_type_code` AS `gStoneTypeCode`, 

        `g_stone_upgrade_level` AS `gStoneUpgradeLevel`

    FROM `eod_configuration`.`data_needs_g_stone_group`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_occupation_reward` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_occupation_reward`()
BEGIN

    SELECT

        `reward_general_code` AS `rewardGeneralCode`, 

        `occupation_type` AS `occupationType`, 

        `win_count` AS `winCount`, 

        `win_count_min_range` AS `winCountMinRange`, 

        `win_count_max_range` AS `winCountMaxRange`, 

        `season_gem_reward` AS `seasonGemReward`, 

        `season_item_reward_gtc` AS `seasonItemRewardGtc`, 

        `season_item_reward_count` AS `seasonItemRewardCount`

    FROM `eod_configuration`.`data_occupation_reward`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_occupation_skill_setting` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_occupation_skill_setting`()
BEGIN

    SELECT

        `skill_code` AS `skillCode`, 

        `skill_type` AS `skillType`, 

        `required_class` AS `requiredClass`, 

        `occupation_skill_setting_lv` AS `occupationSkillSettingLv`

    FROM `eod_configuration`.`data_occupation_skill_setting`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_occupation_stage` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_occupation_stage`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `stage_type` AS `stageType`, 

        `party_user_count` AS `partyUserCount`, 

        `occupation_type` AS `occupationType`, 

        `atk_ratio` AS `atkRatio`, 

        `def_ratio` AS `defRatio`, 

        `stage_exp` AS `stageExp`, 

        `guardian_exp` AS `guardianExp`, 

        `stage_gold` AS `stageGold`, 

        `stage_reward_code` AS `stageRewardCode`, 

        `reward_item_count` AS `rewardItemCount`, 

        `auto_connection_skill_gold` AS `autoConnectionSkillGold`, 

        `occupation_open_hour` AS `occupationOpenHour`, 

        `occupation_close_hour` AS `occupationCloseHour`, 

        `start_delay` AS `startDelay`, 

        `limit_time_second` AS `limitTimeSecond`, 

        `recommend_level_min` AS `recommendLevelMin`, 

        `recommend_level_max` AS `recommendLevelMax`, 

        `party_reward_group_code` AS `partyRewardGroupCode`, 

        `entry_cost_type` AS `entryCostType`, 

        `entry_cost_amount` AS `entryCostAmount`, 

        `auto_skill_cost` AS `autoSkillCost`

    FROM `eod_configuration`.`data_occupation_stage`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_option_attribute` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_option_attribute`()
BEGIN

    SELECT

        `option_attribute_id` AS `optionAttributeId`, 

        `option_division` AS `optionDivision`, 

        `option_condition` AS `optionCondition`, 

        `option_overlab` AS `optionOverlab`, 

        `ignore_option_group` AS `ignoreOptionGroup`, 

        `remove_option_group` AS `removeOptionGroup`, 

        `option_apply_rate` AS `optionApplyRate`, 

        `opt_delay` AS `optDelay`, 

        `opt_timer` AS `optTimer`, 

        `option_adjust_type` AS `optionAdjustType`, 

        `option_value_type` AS `optionValueType`, 

        `option_value_min` AS `optionValueMin`, 

        `option_value_max` AS `optionValueMax`, 

        `appply_hit_times` AS `appplyHitTimes`

    FROM `eod_configuration`.`data_option_attribute`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_option_base` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_option_base`()
BEGIN

    SELECT

        `option_code` AS `optionCode`, 

        `data_type` AS `dataType`, 

        `option_group_code` AS `optionGroupCode`

    FROM `eod_configuration`.`data_option_base`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_option_group` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_option_group`()
BEGIN

    SELECT

        `option_group_id` AS `optionGroupId`, 

        `option_division` AS `optionDivision`, 

        `option_attribute_id` AS `optionAttributeId`, 

        `option_numbers` AS `optionNumbers`, 

        `option_target_group` AS `optionTargetGroup`, 

        `option_target_count` AS `optionTargetCount`, 

        `option_target_cons` AS `optionTargetCons`

    FROM `eod_configuration`.`data_option_group`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_option_item_random` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_option_item_random`()
BEGIN

    SELECT

        `option_random_group_id` AS `optionRandomGroupId`, 

        `option_division` AS `optionDivision`, 

        `option_rank` AS `optionRank`, 

        `option_adjust_type` AS `optionAdjustType`, 

        `option_data_type` AS `optionDataType`, 

        `option_value_min` AS `optionValueMin`, 

        `option_value_max` AS `optionValueMax`, 

        `interval` AS `interval`, 

        `option_rate` AS `optionRate`

    FROM `eod_configuration`.`data_option_item_random`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_option_parameter` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_option_parameter`()
BEGIN

    SELECT

        `option_division` AS `optionDivision`, 

        `option_parts` AS `optionParts`, 

        `calculate_limit` AS `calculateLimit`, 

        `option_data_type` AS `optionDataType`, 

        `option_sort` AS `optionSort`

    FROM `eod_configuration`.`data_option_parameter`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_party_contributiveness_reward` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_party_contributiveness_reward`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `party_reward_group_code` AS `partyRewardGroupCode`, 

        `party_user_count` AS `partyUserCount`, 

        `party_play_rank_type` AS `partyPlayRankType`, 

        `combat_rank` AS `combatRank`, 

        `add_exp_rate` AS `addExpRate`, 

        `reward_code` AS `rewardCode`, 

        `item_min_count` AS `itemMinCount`, 

        `item_max_count` AS `itemMaxCount`

    FROM `eod_configuration`.`data_party_contributiveness_reward`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_passive_skill` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_passive_skill`()
BEGIN

    SELECT

        `skill_code` AS `skillCode`, 

        `character_code` AS `characterCode`, 

        `open_level` AS `openLevel`, 

        `skill_level_limit` AS `skillLevelLimit`, 

        `need_skill_point_type` AS `needSkillPointType`, 

        `need_skill_point` AS `needSkillPoint`, 

        `option_code` AS `optionCode`, 

        `option_base_value` AS `optionBaseValue`, 

        `option_up_add` AS `optionUpAdd`

    FROM `eod_configuration`.`data_passive_skill`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_player_base_status` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_player_base_status`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `class_type` AS `classType`, 

        `level` AS `level`, 

        `hp` AS `hp`, 

        `stm` AS `stm`, 

        `matrix_use_stm` AS `matrixUseStm`, 

        `matrix_maintain_time` AS `matrixMaintainTime`, 

        `matrix_slow_pecent` AS `matrixSlowPecent`, 

        `matrix_cool_time` AS `matrixCoolTime`, 

        `hp_regeneration_per5_sec` AS `hpRegenerationPer5Sec`, 

        `stm_chrg` AS `stmChrg`, 

        `attk_pow_min` AS `attkPowMin`, 

        `attk_pow_max` AS `attkPowMax`, 

        `attk_spd` AS `attkSpd`, 

        `crt_rt` AS `crtRt`, 

        `ctr_pow` AS `ctrPow`, 

        `crt_pow_decr` AS `crtPowDecr`, 

        `dmg_decr` AS `dmgDecr`, 

        `dfs_pow` AS `dfsPow`, 

        `avd_rt` AS `avdRt`, 

        `accr` AS `accr`, 

        `st_reg` AS `stReg`, 

        `cool_decr` AS `coolDecr`, 

        `mv_spd` AS `mvSpd`, 

        `dv_frc` AS `dvFrc`

    FROM `eod_configuration`.`data_player_base_status`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_player_level_experience` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_player_level_experience`()
BEGIN

    SELECT

        `level` AS `level`, 

        `need_experience` AS `needExperience`, 

        `need_experience_to_next_level` AS `needExperienceToNextLevel`, 

        `skill_point` AS `skillPoint`, 

        `key_save` AS `keySave`, 

        `key_regen_time` AS `keyRegenTime`, 

        `key_gift` AS `keyGift`

    FROM `eod_configuration`.`data_player_level_experience`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_pvp_ranking` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_pvp_ranking`()
BEGIN

    SELECT

        `reward_general_code` AS `rewardGeneralCode`, 

        `rank_grade` AS `rankGrade`, 

        `min_count` AS `minCount`, 

        `max_count` AS `maxCount`, 

        `min_rate` AS `minRate`, 

        `max_rate` AS `maxRate`, 

        `season_gem_reward` AS `seasonGemReward`, 

        `season_item_reward_gtc` AS `seasonItemRewardGtc`, 

        `season_item_reward_count` AS `seasonItemRewardCount`

    FROM `eod_configuration`.`data_pvp_ranking`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_quest_data` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_quest_data`()
BEGIN

    SELECT

        `quest_group_id` AS `questGroupId`, 

        `general_type_code` AS `generalTypeCode`, 

        `condition_count` AS `conditionCount`

    FROM `eod_configuration`.`data_quest_data`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_quest_title_info` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_quest_title_info`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `reward_item_info` AS `rewardItemInfo`, 

        `reward_item_count` AS `rewardItemCount`, 

        `reward_item2_info` AS `rewardItem2Info`, 

        `reward_item2_count` AS `rewardItem2Count`, 

        `quest_level` AS `questLevel`, 

        `quest_level_condition` AS `questLevelCondition`

    FROM `eod_configuration`.`data_quest_title_info`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_random_option_change` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_random_option_change`()
BEGIN

    SELECT

        `random_option_change_code` AS `randomOptionChangeCode`, 

        `option_random_group_id` AS `optionRandomGroupId`, 

        `equip_type` AS `equipType`, 

        `item_division` AS `itemDivision`, 

        `item_grade` AS `itemGrade`, 

        `grade` AS `grade`, 

        `gem_need_item1` AS `gemNeedItem1`, 

        `gem_item_count1` AS `gemItemCount1`, 

        `charge_cost` AS `chargeCost`, 

        `rune_need_item1` AS `runeNeedItem1`, 

        `rune_item_count1` AS `runeItemCount1`, 

        `rune_need_item2` AS `runeNeedItem2`, 

        `rune_item_count2` AS `runeItemCount2`, 

        `rune_need_item3` AS `runeNeedItem3`, 

        `rune_item_count3` AS `runeItemCount3`

    FROM `eod_configuration`.`data_random_option_change`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_remove_option_group` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_remove_option_group`()
BEGIN

    SELECT

        `remove_option_group` AS `removeOptionGroup`, 

        `option_division` AS `optionDivision`, 

        `tec_desc` AS `tecDesc`

    FROM `eod_configuration`.`data_remove_option_group`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_rift_stage` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_rift_stage`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `stage_type` AS `stageType`, 

        `grade` AS `grade`, 

        `wave_number_lv` AS `waveNumberLv`, 

        `atk_ratio` AS `atkRatio`, 

        `def_ratio` AS `defRatio`, 

        `stage_exp` AS `stageExp`, 

        `guardian_exp` AS `guardianExp`, 

        `stage_gold` AS `stageGold`, 

        `auto_connection_skill_gold` AS `autoConnectionSkillGold`, 

        `bgm_index` AS `bgmIndex`, 

        `limit_time_second` AS `limitTimeSecond`, 

        `recommend_level` AS `recommendLevel`, 

        `next_stage_code` AS `nextStageCode`, 

        `reward_general_code` AS `rewardGeneralCode`, 

        `reward_count_min` AS `rewardCountMin`, 

        `reward_count_max` AS `rewardCountMax`, 

        `reward_general_code1` AS `rewardGeneralCode1`, 

        `reward_count_min1` AS `rewardCountMin1`, 

        `reward_count_max1` AS `rewardCountMax1`, 

        `entry_cost_type` AS `entryCostType`, 

        `entry_cost_amount` AS `entryCostAmount`, 

        `entry_limit_type` AS `entryLimitType`, 

        `entry_limit_count` AS `entryLimitCount`, 

        `boss_monster_code` AS `bossMonsterCode`, 

        `monster_level` AS `monsterLevel`, 

        `auto_skill_cost` AS `autoSkillCost`, 

        `add_reward_group_code` AS `addRewardGroupCode`

    FROM `eod_configuration`.`data_rift_stage`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_rift_stage_reward` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_rift_stage_reward`()
BEGIN

    SELECT

        `reward_general_code` AS `rewardGeneralCode`, 

        `stage_general_code` AS `stageGeneralCode`, 

        `required_class` AS `requiredClass`, 

        `act` AS `act`, 

        `stage_no` AS `stageNo`, 

        `general_type_code` AS `generalTypeCode`, 

        `item_min_count` AS `itemMinCount`, 

        `item_max_count` AS `itemMaxCount`, 

        `drop_rate` AS `dropRate`, 

        `equip_type` AS `equipType`, 

        `grade` AS `grade`

    FROM `eod_configuration`.`data_rift_stage_reward`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_rift_stage_rift_stone_reward` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_rift_stage_rift_stone_reward`()
BEGIN

    SELECT

        `reward_general_code` AS `rewardGeneralCode`, 

        `stage_general_code` AS `stageGeneralCode`, 

        `required_class` AS `requiredClass`, 

        `act` AS `act`, 

        `stage_no` AS `stageNo`, 

        `general_type_code` AS `generalTypeCode`, 

        `item_min_count` AS `itemMinCount`, 

        `item_max_count` AS `itemMaxCount`, 

        `drop_rate` AS `dropRate`, 

        `equip_type` AS `equipType`, 

        `grade` AS `grade`

    FROM `eod_configuration`.`data_rift_stage_rift_stone_reward`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_rune_option_group` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_rune_option_group`()
BEGIN

    SELECT

        `rune_option_group_id` AS `runeOptionGroupId`, 

        `option_division` AS `optionDivision`, 

        `equip_type` AS `equipType`, 

        `option_adjust_type` AS `optionAdjustType`, 

        `option_data_type` AS `optionDataType`, 

        `option_value_min` AS `optionValueMin`, 

        `option_value_max` AS `optionValueMax`, 

        `interval` AS `interval`, 

        `option_rate` AS `optionRate`

    FROM `eod_configuration`.`data_rune_option_group`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_servant` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_servant`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `piece_type_code` AS `pieceTypeCode`, 

        `piece_gain_root` AS `pieceGainRoot`, 

        `summon_grade` AS `summonGrade`, 

        `cool_time` AS `coolTime`, 

        `summon_count` AS `summonCount`, 

        `max_grade` AS `maxGrade`, 

        `hp` AS `hp`, 

        `hp_regeneration_per5_sec` AS `hpRegenerationPer5Sec`, 

        `stm_chrg` AS `stmChrg`, 

        `attk_pow` AS `attkPow`, 

        `attk_spd` AS `attkSpd`, 

        `crt_rt` AS `crtRt`, 

        `ctr_pow` AS `ctrPow`, 

        `crt_pow_decr` AS `crtPowDecr`, 

        `dmg_decr` AS `dmgDecr`, 

        `dfs_pow` AS `dfsPow`, 

        `avd_rt` AS `avdRt`, 

        `accr` AS `accr`, 

        `st_reg` AS `stReg`, 

        `mv_spd` AS `mvSpd`, 

        `dk_frc` AS `dkFrc`

    FROM `eod_configuration`.`data_servant`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_servant_achievement` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_servant_achievement`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `summon_grade` AS `summonGrade`, 

        `summon_count` AS `summonCount`, 

        `reward_type_code` AS `rewardTypeCode`, 

        `reward_count` AS `rewardCount`, 

        `equip_type` AS `equipType`, 

        `item_grade` AS `itemGrade`

    FROM `eod_configuration`.`data_servant_achievement`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_servant_level_experience` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_servant_level_experience`()
BEGIN

    SELECT

        `level` AS `level`, 

        `need_experience` AS `needExperience`, 

        `need_experience_to_next_level` AS `needExperienceToNextLevel`

    FROM `eod_configuration`.`data_servant_level_experience`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_servant_level_up_status` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_servant_level_up_status`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `hp` AS `hp`, 

        `hp_regeneration_per5_sec` AS `hpRegenerationPer5Sec`, 

        `stm_chrg` AS `stmChrg`, 

        `attk_pow` AS `attkPow`, 

        `attk_spd` AS `attkSpd`, 

        `crt_rt` AS `crtRt`, 

        `ctr_pow` AS `ctrPow`, 

        `crt_pow_decr` AS `crtPowDecr`, 

        `dmg_decr` AS `dmgDecr`, 

        `dfs_pow` AS `dfsPow`, 

        `avd_rt` AS `avdRt`, 

        `accr` AS `accr`, 

        `st_reg` AS `stReg`, 

        `mv_spd` AS `mvSpd`, 

        `dk_frc` AS `dkFrc`

    FROM `eod_configuration`.`data_servant_level_up_status`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_servant_piece_store_product` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_servant_piece_store_product`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `product_slot` AS `productSlot`, 

        `drop_rate` AS `dropRate`, 

        `item_type_code` AS `itemTypeCode`, 

        `item_count` AS `itemCount`, 

        `buy_type` AS `buyType`, 

        `price` AS `price`

    FROM `eod_configuration`.`data_servant_piece_store_product`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_server_tag_n_state` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_server_tag_n_state`()
BEGIN

    SELECT

        `tag_state_group_id` AS `tagStateGroupId`, 

        `tag_n_state_type` AS `tagNStateType`, 

        `state_min` AS `stateMin`, 

        `state_max` AS `stateMax`, 

        `tag_n_state_type_des` AS `tagNStateTypeDes`

    FROM `eod_configuration`.`data_server_tag_n_state`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_shop_admission_buy` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_shop_admission_buy`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `price_type` AS `priceType`, 

        `price` AS `price`, 

        `exchage_type_code` AS `exchageTypeCode`, 

        `exchage_amount` AS `exchageAmount`, 

        `mileage_type_code` AS `mileageTypeCode`, 

        `mileage_amount` AS `mileageAmount`, 

        `free_gacha_delay_time` AS `freeGachaDelayTime`, 

        `free_gacha_max_count` AS `freeGachaMaxCount`

    FROM `eod_configuration`.`data_shop_admission_buy`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_shop_event_package` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_shop_event_package`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `product_id` AS `productId`, 

        `market_type` AS `marketType`, 

        `price_type` AS `priceType`, 

        `price` AS `price`, 

        `limited_num` AS `limitedNum`, 

        `mileage_type_code` AS `mileageTypeCode`, 

        `mileage_amount` AS `mileageAmount`, 

        `product1_type_code` AS `product1TypeCode`, 

        `product1_amount` AS `product1Amount`, 

        `product2_type_code` AS `product2TypeCode`, 

        `product2_amount` AS `product2Amount`, 

        `product3_type_code` AS `product3TypeCode`, 

        `product3_amount` AS `product3Amount`, 

        `product4_type_code` AS `product4TypeCode`, 

        `product4_amount` AS `product4Amount`, 

        `product5_type_code` AS `product5TypeCode`, 

        `product5_amount` AS `product5Amount`, 

        `product6_type_code` AS `product6TypeCode`, 

        `product6_amount` AS `product6Amount`

    FROM `eod_configuration`.`data_shop_event_package`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_shop_gacha` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_shop_gacha`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `icon_image_code` AS `iconImageCode`, 

        `pull_count` AS `pullCount`, 

        `gacha_reward_code` AS `gachaRewardCode`, 

        `re_purchase_count` AS `rePurchaseCount`, 

        `gacha_type` AS `gachaType`, 

        `price_type` AS `priceType`, 

        `price` AS `price`, 

        `mileage_type_code` AS `mileageTypeCode`, 

        `mileage_amount` AS `mileageAmount`, 

        `gacha_grade_group_code` AS `gachaGradeGroupCode`, 

        `bonus_gacha_grade_group_code` AS `bonusGachaGradeGroupCode`, 

        `add_reward_item_code` AS `addRewardItemCode`, 

        `add_reward_item_count` AS `addRewardItemCount`, 

        `free_gacha_delay_time` AS `freeGachaDelayTime`, 

        `free_gacha_max_count` AS `freeGachaMaxCount`

    FROM `eod_configuration`.`data_shop_gacha`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_shop_gacha_grade_group` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_shop_gacha_grade_group`()
BEGIN

    SELECT

        `gacha_grade_group_code` AS `gachaGradeGroupCode`, 

        `gacha_item_group_code` AS `gachaItemGroupCode`, 

        `group_rate` AS `groupRate`

    FROM `eod_configuration`.`data_shop_gacha_grade_group`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_shop_gacha_item_group` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_shop_gacha_item_group`()
BEGIN

    SELECT

        `gacha_item_group_code` AS `gachaItemGroupCode`, 

        `item_code` AS `itemCode`, 

        `item_count` AS `itemCount`, 

        `required_class` AS `requiredClass`, 

        `group_rate` AS `groupRate`

    FROM `eod_configuration`.`data_shop_gacha_item_group`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_shop_gem_charge` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_shop_gem_charge`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `product_id` AS `productId`, 

        `market_type` AS `marketType`, 

        `price_type` AS `priceType`, 

        `price` AS `price`, 

        `charge_type_code` AS `chargeTypeCode`, 

        `charge_amount` AS `chargeAmount`, 

        `add_amount` AS `addAmount`, 

        `charge_type_code2` AS `chargeTypeCode2`, 

        `charge_amount2` AS `chargeAmount2`, 

        `add_amount2` AS `addAmount2`, 

        `mileage_type_code` AS `mileageTypeCode`, 

        `mileage_amount` AS `mileageAmount`, 

        `bonus1_type_code` AS `bonus1TypeCode`, 

        `bonus1_amount` AS `bonus1Amount`, 

        `bonus2_type_code` AS `bonus2TypeCode`, 

        `bonus2_amount` AS `bonus2Amount`, 

        `bonus3_type_code` AS `bonus3TypeCode`, 

        `bonus3_amount` AS `bonus3Amount`, 

        `bonus4_type_code` AS `bonus4TypeCode`, 

        `bonus4_amount` AS `bonus4Amount`, 

        `bonus5_type_code` AS `bonus5TypeCode`, 

        `bonus5_amount` AS `bonus5Amount`

    FROM `eod_configuration`.`data_shop_gem_charge`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_shop_gold_exchange` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_shop_gold_exchange`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `price_type` AS `priceType`, 

        `price` AS `price`, 

        `exchage_type_code` AS `exchageTypeCode`, 

        `exchage_amount` AS `exchageAmount`, 

        `mileage_type_code` AS `mileageTypeCode`, 

        `mileage_amount` AS `mileageAmount`

    FROM `eod_configuration`.`data_shop_gold_exchange`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_shop_guild` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_shop_guild`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `price_type` AS `priceType`, 

        `price` AS `price`, 

        `exchage_type_code` AS `exchageTypeCode`, 

        `exchage_amount` AS `exchageAmount`

    FROM `eod_configuration`.`data_shop_guild`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_shop_levelup_package` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_shop_levelup_package`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `product_id` AS `productId`, 

        `market_type` AS `marketType`, 

        `character_lv` AS `characterLv`, 

        `guardian_lv` AS `guardianLv`, 

        `price_type` AS `priceType`, 

        `price` AS `price`, 

        `limited_num` AS `limitedNum`, 

        `mileage_type_code` AS `mileageTypeCode`, 

        `mileage_amount` AS `mileageAmount`, 

        `product1_type_code` AS `product1TypeCode`, 

        `product1_amount` AS `product1Amount`, 

        `product2_type_code` AS `product2TypeCode`, 

        `product2_amount` AS `product2Amount`, 

        `product3_type_code` AS `product3TypeCode`, 

        `product3_amount` AS `product3Amount`, 

        `product4_type_code` AS `product4TypeCode`, 

        `product4_amount` AS `product4Amount`, 

        `product5_type_code` AS `product5TypeCode`, 

        `product5_amount` AS `product5Amount`, 

        `product6_type_code` AS `product6TypeCode`, 

        `product6_amount` AS `product6Amount`

    FROM `eod_configuration`.`data_shop_levelup_package`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_shop_mileage_exchnage` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_shop_mileage_exchnage`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `price_type` AS `priceType`, 

        `price` AS `price`, 

        `exchage_type_code` AS `exchageTypeCode`, 

        `exchage_amount` AS `exchageAmount`

    FROM `eod_configuration`.`data_shop_mileage_exchnage`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_shop_package` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_shop_package`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `product_id` AS `productId`, 

        `market_type` AS `marketType`, 

        `price_type` AS `priceType`, 

        `price` AS `price`, 

        `limited_num` AS `limitedNum`, 

        `mileage_type_code` AS `mileageTypeCode`, 

        `mileage_amount` AS `mileageAmount`, 

        `product1_type_code` AS `product1TypeCode`, 

        `product1_amount` AS `product1Amount`, 

        `product2_type_code` AS `product2TypeCode`, 

        `product2_amount` AS `product2Amount`, 

        `product3_type_code` AS `product3TypeCode`, 

        `product3_amount` AS `product3Amount`, 

        `product4_type_code` AS `product4TypeCode`, 

        `product4_amount` AS `product4Amount`, 

        `product5_type_code` AS `product5TypeCode`, 

        `product5_amount` AS `product5Amount`, 

        `product6_type_code` AS `product6TypeCode`, 

        `product6_amount` AS `product6Amount`

    FROM `eod_configuration`.`data_shop_package`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_shop_premium_package` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_shop_premium_package`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `product_id` AS `productId`, 

        `market_type` AS `marketType`, 

        `next_step_code` AS `nextStepCode`, 

        `price_type` AS `priceType`, 

        `price` AS `price`, 

        `limited_num` AS `limitedNum`, 

        `mileage_type_code` AS `mileageTypeCode`, 

        `mileage_amount` AS `mileageAmount`, 

        `product1_type_code` AS `product1TypeCode`, 

        `product1_amount` AS `product1Amount`, 

        `product2_type_code` AS `product2TypeCode`, 

        `product2_amount` AS `product2Amount`, 

        `product3_type_code` AS `product3TypeCode`, 

        `product3_amount` AS `product3Amount`, 

        `product4_type_code` AS `product4TypeCode`, 

        `product4_amount` AS `product4Amount`, 

        `product5_type_code` AS `product5TypeCode`, 

        `product5_amount` AS `product5Amount`, 

        `product6_type_code` AS `product6TypeCode`, 

        `product6_amount` AS `product6Amount`

    FROM `eod_configuration`.`data_shop_premium_package`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_skill_levelup` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_skill_levelup`()
BEGIN

    SELECT

        `skill_code` AS `skillCode`, 

        `projectile_division_index` AS `projectileDivisionIndex`, 

        `skill_level` AS `skillLevel`, 

        `need_skill_point_type` AS `needSkillPointType`, 

        `need_skill_point` AS `needSkillPoint`

    FROM `eod_configuration`.`data_skill_levelup`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_skill_type` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_skill_type`()
BEGIN

    SELECT

        `skill_code` AS `skillCode`, 

        `skill_type` AS `skillType`, 

        `required_class` AS `requiredClass`, 

        `skill_level_limit` AS `skillLevelLimit`, 

        `debuff_state_skill` AS `debuffStateSkill`, 

        `add_skill_combo` AS `addSkillCombo`

    FROM `eod_configuration`.`data_skill_type`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_stage` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_stage`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `stage_type` AS `stageType`, 

        `act_number` AS `actNumber`, 

        `stage_number_in_act` AS `stageNumberInAct`, 

        `recommend_atk` AS `recommendAtk`, 

        `atk_ratio` AS `atkRatio`, 

        `def_ratio` AS `defRatio`, 

        `stage_exp` AS `stageExp`, 

        `guardian_exp` AS `guardianExp`, 

        `stage_gold` AS `stageGold`, 

        `auto_connection_skill_gold` AS `autoConnectionSkillGold`, 

        `bonus_type` AS `bonusType`, 

        `bonus_value` AS `bonusValue`, 

        `limit_time_second` AS `limitTimeSecond`, 

        `recommend_level_min` AS `recommendLevelMin`, 

        `recommend_level_max` AS `recommendLevelMax`, 

        `previous_stage_code` AS `previousStageCode`, 

        `next_stage_code` AS `nextStageCode`, 

        `reward_general_code` AS `rewardGeneralCode`, 

        `reward_count_min` AS `rewardCountMin`, 

        `reward_count_max` AS `rewardCountMax`, 

        `entry_cost_type` AS `entryCostType`, 

        `entry_cost_amount` AS `entryCostAmount`, 

        `entry_limit_type` AS `entryLimitType`, 

        `entry_limit_count` AS `entryLimitCount`, 

        `boss_monster_code` AS `bossMonsterCode`, 

        `monster_level` AS `monsterLevel`, 

        `auto_skill_cost` AS `autoSkillCost`, 

        `add_reward_group_code` AS `addRewardGroupCode`

    FROM `eod_configuration`.`data_stage`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_stage_reward` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_stage_reward`()
BEGIN

    SELECT

        `reward_general_code` AS `rewardGeneralCode`, 

        `stage_general_code` AS `stageGeneralCode`, 

        `required_class` AS `requiredClass`, 

        `act` AS `act`, 

        `stage_no` AS `stageNo`, 

        `general_type_code` AS `generalTypeCode`, 

        `item_min_count` AS `itemMinCount`, 

        `item_max_count` AS `itemMaxCount`, 

        `drop_rate` AS `dropRate`, 

        `equip_type` AS `equipType`, 

        `grade` AS `grade`

    FROM `eod_configuration`.`data_stage_reward`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_story_cutscene` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_story_cutscene`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `required_class_type` AS `requiredClassType`, 

        `need_char_level` AS `needCharLevel`, 

        `reward_item_code` AS `rewardItemCode`, 

        `reward_item_count` AS `rewardItemCount`

    FROM `eod_configuration`.`data_story_cutscene`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_succession_skill` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_succession_skill`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `open_condition` AS `openCondition`, 

        `open_level` AS `openLevel`, 

        `skill_level_limit` AS `skillLevelLimit`, 

        `link_skill_upgrade_item` AS `linkSkillUpgradeItem`, 

        `upgrad_item_code` AS `upgradItemCode`, 

        `upgrad_item_count` AS `upgradItemCount`

    FROM `eod_configuration`.`data_succession_skill`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_town` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_town`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `stage_type` AS `stageType`, 

        `limit_time_second` AS `limitTimeSecond`

    FROM `eod_configuration`.`data_town`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_transcendent_guardian_stone_reward` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_transcendent_guardian_stone_reward`()
BEGIN

    SELECT

        `reward_general_code` AS `rewardGeneralCode`, 

        `stage_general_code` AS `stageGeneralCode`, 

        `required_class` AS `requiredClass`, 

        `act` AS `act`, 

        `stage_no` AS `stageNo`, 

        `general_type_code` AS `generalTypeCode`, 

        `item_min_count` AS `itemMinCount`, 

        `item_max_count` AS `itemMaxCount`, 

        `drop_rate` AS `dropRate`, 

        `equip_type` AS `equipType`, 

        `grade` AS `grade`

    FROM `eod_configuration`.`data_transcendent_guardian_stone_reward`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_transcendent_stage` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_transcendent_stage`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `stage_type` AS `stageType`, 

        `stage_number_in_act` AS `stageNumberInAct`, 

        `atk_ratio` AS `atkRatio`, 

        `def_ratio` AS `defRatio`, 

        `stage_exp` AS `stageExp`, 

        `guardian_exp` AS `guardianExp`, 

        `boss_spawn_hp_amount` AS `bossSpawnHpAmount`, 

        `stage_gold` AS `stageGold`, 

        `auto_connection_skill_gold` AS `autoConnectionSkillGold`, 

        `bgm_index` AS `bgmIndex`, 

        `limit_time_second` AS `limitTimeSecond`, 

        `recommend_level` AS `recommendLevel`, 

        `reward_general_code` AS `rewardGeneralCode`, 

        `reward_count_min` AS `rewardCountMin`, 

        `reward_count_max` AS `rewardCountMax`, 

        `first_reward_general_code` AS `firstRewardGeneralCode`, 

        `reward_general_code1` AS `rewardGeneralCode1`, 

        `reward_count_min1` AS `rewardCountMin1`, 

        `reward_count_max1` AS `rewardCountMax1`, 

        `party_reward_group_code` AS `partyRewardGroupCode`, 

        `entry_cost_type` AS `entryCostType`, 

        `entry_cost_amount` AS `entryCostAmount`, 

        `entry_limit_type` AS `entryLimitType`, 

        `entry_limit_count` AS `entryLimitCount`, 

        `boss_monster_code` AS `bossMonsterCode`, 

        `monster_level` AS `monsterLevel`, 

        `auto_skill_cost` AS `autoSkillCost`, 

        `add_reward_group_code` AS `addRewardGroupCode`

    FROM `eod_configuration`.`data_transcendent_stage`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_transcendent_stage_reward` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_transcendent_stage_reward`()
BEGIN

    SELECT

        `reward_general_code` AS `rewardGeneralCode`, 

        `stage_general_code` AS `stageGeneralCode`, 

        `required_class` AS `requiredClass`, 

        `act` AS `act`, 

        `stage_no` AS `stageNo`, 

        `general_type_code` AS `generalTypeCode`, 

        `item_min_count` AS `itemMinCount`, 

        `item_max_count` AS `itemMaxCount`, 

        `drop_rate` AS `dropRate`, 

        `equip_type` AS `equipType`, 

        `grade` AS `grade`

    FROM `eod_configuration`.`data_transcendent_stage_reward`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_tutorial_data` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_tutorial_data`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `quest_type` AS `questType`, 

        `group_index` AS `groupIndex`, 

        `complete_index` AS `completeIndex`, 

        `quest_need_level` AS `questNeedLevel`, 

        `previous_tutorial_step_code` AS `previousTutorialStepCode`, 

        `reward_item_info` AS `rewardItemInfo`, 

        `reward_item_count` AS `rewardItemCount`, 

        `skip_state` AS `skipState`

    FROM `eod_configuration`.`data_tutorial_data`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_weekly_stage` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_weekly_stage`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `stage_type` AS `stageType`, 

        `act_number` AS `actNumber`, 

        `stage_number_in_act` AS `stageNumberInAct`, 

        `day_of_week` AS `dayOfWeek`, 

        `recommend_atk` AS `recommendAtk`, 

        `atk_ratio` AS `atkRatio`, 

        `def_ratio` AS `defRatio`, 

        `stage_exp` AS `stageExp`, 

        `guardian_exp` AS `guardianExp`, 

        `stage_gold` AS `stageGold`, 

        `auto_connection_skill_gold` AS `autoConnectionSkillGold`, 

        `limit_time_second` AS `limitTimeSecond`, 

        `recommend_level` AS `recommendLevel`, 

        `reward_general_code` AS `rewardGeneralCode`, 

        `reward_count_min` AS `rewardCountMin`, 

        `reward_count_max` AS `rewardCountMax`, 

        `entry_cost_type` AS `entryCostType`, 

        `entry_cost_amount` AS `entryCostAmount`, 

        `entry_limit_type` AS `entryLimitType`, 

        `entry_limit_count` AS `entryLimitCount`, 

        `boss_monster_code` AS `bossMonsterCode`, 

        `monster_level` AS `monsterLevel`, 

        `auto_skill_cost` AS `autoSkillCost`, 

        `image_code` AS `imageCode`, 

        `add_reward_group_code` AS `addRewardGroupCode`

    FROM `eod_configuration`.`data_weekly_stage`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_weekly_stage_reward` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_weekly_stage_reward`()
BEGIN

    SELECT

        `reward_general_code` AS `rewardGeneralCode`, 

        `stage_general_code` AS `stageGeneralCode`, 

        `required_class` AS `requiredClass`, 

        `act` AS `act`, 

        `stage_no` AS `stageNo`, 

        `general_type_code` AS `generalTypeCode`, 

        `item_min_count` AS `itemMinCount`, 

        `item_max_count` AS `itemMaxCount`, 

        `drop_rate` AS `dropRate`, 

        `equip_type` AS `equipType`, 

        `grade` AS `grade`

    FROM `eod_configuration`.`data_weekly_stage_reward`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_west_area_stage` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_west_area_stage`()
BEGIN

    SELECT

        `general_type_code` AS `generalTypeCode`, 

        `stage_type` AS `stageType`, 

        `act_number` AS `actNumber`, 

        `stage_number_in_act` AS `stageNumberInAct`, 

        `recommend_atk` AS `recommendAtk`, 

        `atk_ratio` AS `atkRatio`, 

        `def_ratio` AS `defRatio`, 

        `stage_exp` AS `stageExp`, 

        `guardian_exp` AS `guardianExp`, 

        `stage_gold` AS `stageGold`, 

        `auto_connection_skill_gold` AS `autoConnectionSkillGold`, 

        `bonus_type` AS `bonusType`, 

        `bonus_value` AS `bonusValue`, 

        `limit_time_second` AS `limitTimeSecond`, 

        `recommend_level_min` AS `recommendLevelMin`, 

        `recommend_level_max` AS `recommendLevelMax`, 

        `previous_stage_code` AS `previousStageCode`, 

        `next_stage_code` AS `nextStageCode`, 

        `reward_general_code` AS `rewardGeneralCode`, 

        `reward_count_min` AS `rewardCountMin`, 

        `reward_count_max` AS `rewardCountMax`, 

        `entry_cost_type` AS `entryCostType`, 

        `entry_cost_amount` AS `entryCostAmount`, 

        `entry_limit_type` AS `entryLimitType`, 

        `entry_limit_count` AS `entryLimitCount`, 

        `boss_monster_code` AS `bossMonsterCode`, 

        `monster_level` AS `monsterLevel`, 

        `auto_skill_cost` AS `autoSkillCost`, 

        `add_reward_group_code` AS `addRewardGroupCode`

    FROM `eod_configuration`.`data_west_area_stage`;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_load_data_table_west_area_stage_reward` */;
DELIMITER ;;
CREATE DEFINER=`GameManager`@`61.73.126.90` PROCEDURE `sp_load_data_table_west_area_stage_reward`()
BEGIN

    SELECT

        `reward_general_code` AS `rewardGeneralCode`, 

        `stage_general_code` AS `stageGeneralCode`, 

        `required_class` AS `requiredClass`, 

        `act` AS `act`, 

        `stage_no` AS `stageNo`, 

        `general_type_code` AS `generalTypeCode`, 

        `item_min_count` AS `itemMinCount`, 

        `item_max_count` AS `itemMaxCount`, 

        `drop_rate` AS `dropRate`, 

        `equip_type` AS `equipType`, 

        `grade` AS `grade`

    FROM `eod_configuration`.`data_west_area_stage_reward`;

END ;;
DELIMITER ;

--
-- Current Database: `eod_global`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `eod_global` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;

USE `eod_global`;

--
-- Table structure for table `table_account_user_serial_codes`
--

CREATE TABLE `table_account_user_serial_codes` (
  `serial_code` varchar(24) COLLATE utf8_unicode_ci NOT NULL COMMENT '계정마다 부여하는 시리얼 코드\n\n- 각 글자마다 [A-Z], [0-9]인 16글자로 구성한다.\n: 영문자는 대문자만 사용한다.\n\n- 각 계정들은 반드시 하나의 시리얼 코드를 보유해야 한다.',
  `generate_datetime` datetime NOT NULL DEFAULT '1000-01-01 00:00:00' COMMENT '생성 일시',
  PRIMARY KEY (`serial_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='사용자 계정 시리얼 코드 등록 정보';

--
-- Dumping data for table `table_account_user_serial_codes`
--


--
-- Table structure for table `table_application_contract`
--

CREATE TABLE `table_application_contract` (
  `application_identifier` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT '애플리케이션 식별 키',
  `sign_key` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '인증키',
  `used` tinyint(4) NOT NULL DEFAULT '0' COMMENT '사용 여부',
  PRIMARY KEY (`application_identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='애플리케이션 키 등록 정보';

--
-- Dumping data for table `table_application_contract`
--

INSERT INTO `table_application_contract` VALUES ('nox','20170510',1);

--
-- Table structure for table `table_guild_names`
--

CREATE TABLE `table_guild_names` (
  `application_identifier` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT '애플리케이션 식별 키',
  `category_code` int(11) NOT NULL DEFAULT '0' COMMENT '마켓 분류 코드',
  `name` varbinary(256) NOT NULL COMMENT '이름',
  `name_description` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '`Name` 필드의 이름을 사람이 알아볼 수 있도록 저장하는 필드',
  `register_key` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '사전등록 키',
  `fixed` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0 : 비확정\n1 : 확정',
  `time_seconds` bigint(20) NOT NULL DEFAULT '0' COMMENT '재사용 대기시간(초)',
  `generate_datetime` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '등록시간',
  PRIMARY KEY (`application_identifier`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='등록한 길드 이름';

--
-- Dumping data for table `table_guild_names`
--


--
-- Table structure for table `table_igaworks_coupon`
--

CREATE TABLE `table_igaworks_coupon` (
  `campaign_key` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '캠페인 키',
  `valid_nickname_creation_date` date NOT NULL,
  `reward1` int(11) NOT NULL DEFAULT '0' COMMENT '보상 아이템의 식별 코드-1',
  `count1` int(11) NOT NULL DEFAULT '0' COMMENT '보상 아이템의 수량-1',
  `is_lotto1` tinyint(1) NOT NULL DEFAULT '0' COMMENT '보상 아이템이 소환권인지 여부-1',
  `reward2` int(11) NOT NULL DEFAULT '0' COMMENT '보상 아이템의 식별 코드-2',
  `count2` int(11) NOT NULL DEFAULT '0' COMMENT '보상 아이템의 수량-1',
  `is_lotto2` tinyint(1) NOT NULL DEFAULT '0' COMMENT '보상 아이템이 소환권인지 여부-2',
  `reward3` int(11) NOT NULL DEFAULT '0' COMMENT '보상 아이템의 식별 코드-3',
  `count3` int(11) NOT NULL DEFAULT '0' COMMENT '보상 아이템의 수량-1',
  `is_lotto3` tinyint(1) NOT NULL DEFAULT '0' COMMENT '보상 아이템이 소환권인지 여부-3',
  `reward4` int(11) NOT NULL DEFAULT '0' COMMENT '보상 아이템의 식별 코드-4',
  `count4` int(11) NOT NULL DEFAULT '0' COMMENT '보상 아이템의 수량-1',
  `is_lotto4` tinyint(1) NOT NULL DEFAULT '0' COMMENT '보상 아이템이 소환권인지 여부-4',
  `reward5` int(11) NOT NULL DEFAULT '0' COMMENT '보상 아이템의 식별 코드-5',
  `count5` int(11) NOT NULL DEFAULT '0' COMMENT '보상 아이템의 수량-1',
  `is_lotto5` tinyint(1) NOT NULL DEFAULT '0' COMMENT '보상 아이템이 소환권인지 여부-5',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '삭제 여부',
  `deleted_administrator` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '삭제한 운영자의 계정',
  `deleted_datetime` datetime NOT NULL COMMENT '삭제한 일시',
  `disposer` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '폐기한 사람',
  `reason_text` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '폐기한 사유',
  `creation_datetime` datetime NOT NULL COMMENT '생성한 일시',
  PRIMARY KEY (`campaign_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='IGAWorks 쿠폰 지급 내역';

--
-- Dumping data for table `table_igaworks_coupon`
--


--
-- Table structure for table `table_player_nicknames`
--

CREATE TABLE `table_player_nicknames` (
  `application_identifier` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT '애플리케이션 식별 키',
  `category_code` int(11) NOT NULL DEFAULT '0' COMMENT '마켓 분류 코드',
  `name` varbinary(256) NOT NULL COMMENT '이름',
  `name_description` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '`Name` 필드의 이름을 사람이 알아볼 수 있도록 저장하는 필드',
  `register_key` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '사전등록 키',
  `fixed` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0 : 비확정\n1 : 확정',
  `time_seconds` bigint(20) NOT NULL DEFAULT '0' COMMENT '재사용 대기시간(초)',
  `generate_datetime` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '등록시간',
  PRIMARY KEY (`application_identifier`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='등록한 플레이어 별명';

--
-- Dumping data for table `table_player_nicknames`
--


--
-- Table structure for table `table_promotion_data`
--

CREATE TABLE `table_promotion_data` (
  `user_id` bigint(20) unsigned NOT NULL,
  `server_code` int(11) NOT NULL,
  `unique_key` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `character_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `event_application` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `reward_info` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `content_data` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `generate_datetime` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '생성일시',
  PRIMARY KEY (`user_id`,`server_code`,`unique_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='프로모션 데이터';

--
-- Dumping data for table `table_promotion_data`
--


--
-- Table structure for table `table_promotion_log`
--

CREATE TABLE `table_promotion_log` (
  `server_code` int(11) NOT NULL DEFAULT '0' COMMENT '서버 코드',
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '사용자 ID',
  `reward_key` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '보상 키',
  `generate_datetime` datetime DEFAULT CURRENT_TIMESTAMP,
  KEY `idx_table_promotion_log_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='프로모션 보상 지급 로그';

--
-- Dumping data for table `table_promotion_log`
--


--
-- Dumping events for database 'eod_global'
--

--
-- Dumping routines for database 'eod_global'
--
/*!50003 DROP PROCEDURE IF EXISTS `sp_promotion_reward` */;
DELIMITER ;;
CREATE DEFINER=`Administrator`@`211.41.204.39` PROCEDURE `sp_promotion_reward`(IN inUserId BIGINT(20),

                                       IN inServerCode INT(11),

                                       IN inUniqueKey VARCHAR(256),

                                       IN inRewardInfo VARCHAR(256),

                                       IN inSignValue VARCHAR(256),

                                       IN inCharacterId BIGINT(20),

                                       IN inEventApplication VARCHAR(256))
BEGIN

    -- 성공(Eod.Result.Common.Success)

    DECLARE ResultSuccess INT DEFAULT 0;



    -- 실패(Eod.Result.Common.Failed)

    DECLARE ResultFailed INT DEFAULT -1;



    -- 보상을 이미 수령함.(Eod.Result.Common.RewardAlready)

    DECLARE ResultRewardAlready INT DEFAULT 3102;





    DECLARE EXIT HANDLER FOR SQLEXCEPTION

    BEGIN

        SELECT ResultRewardAlready;

        ROLLBACK;

    END;





    SET AutoCommit = 0;



    START TRANSACTION;



        IF(SELECT `user_id`

           FROM `eod_global`.`table_promotion_data`

           WHERE (`user_id` = inUserId) AND

                 (`unique_key` = inUniqueKey) AND

                 (`event_application` = inEventApplication)) THEN

            -- 보상을 이미 수령함.(Eod.Result.Common.RewardAlready)

            SELECT ResultRewardAlready;

        ELSE

            INSERT INTO `eod_global`.`table_promotion_data`

                (`user_id`,

                 `server_code`,

                 `unique_key`,

                 `character_id`,

                 `event_application`,

                 `reward_info`,

                 `content_data`)

            VALUES

                (inUserId,

                 inServerCode,

                 inUniqueKey,

                 inCharacterId,

                 inEventApplication,

                 inRewardInfo,

                 inSignValue);

            SELECT ResultSuccess;

        END IF;



    COMMIT;



    SET AutoCommit = 1;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_register_account_user_serial_code` */;
DELIMITER ;;
CREATE DEFINER=`Administrator`@`211.41.204.39` PROCEDURE `sp_register_account_user_serial_code`(IN inSerialCode VARCHAR(24),

                                                        IN inGenerateDateTime DATETIME)
BEGIN

    -- 성공(Eod.Result.Common.Success)

    DECLARE ResultSuccess INT DEFAULT 0;



    -- 실패(Eod.Result.Common.Failed)

    DECLARE ResultFailed INT DEFAULT -1;



    -- 해당 계정이 이미 존재함.(Eod.Result.Common.SerialCodeExistAlready)

    DECLARE ResultSerialCodeExistAlready INT DEFAULT 1052;





    -- 개수를 측정하는 변수

    DECLARE existanceCount INT DEFAULT 0;





    DECLARE EXIT HANDLER FOR SQLEXCEPTION

    BEGIN

        SELECT ResultSerialCodeExistAlready;

        ROLLBACK;

    END;





    START TRANSACTION;



        SELECT COUNT(1)

        INTO existanceCount

        FROM `eod_global`.`table_account_user_serial_codes`

        WHERE (`serial_code` = inSerialCode);



        IF (existanceCount <= 0) THEN

            INSERT INTO `eod_global`.`table_account_user_serial_codes`

            VALUES (inSerialCode, inGenerateDateTime);

            SELECT ResultSuccess;

        ELSE

            SELECT ResultSerialCodeExistAlready;

        END IF;



    COMMIT;



    SET AutoCommit = 1;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_register_guild_name` */;
DELIMITER ;;
CREATE DEFINER=`Administrator`@`211.41.204.39` PROCEDURE `sp_register_guild_name`(IN inAppName VARCHAR(64),

                                          IN inCategory INT,

                                          IN inInputName VARCHAR(64),

                                          IN inRegisterKey VARCHAR(256),

                                          IN inTimeSeconds BIGINT,

                                          IN inIsFixed TINYINT)
BEGIN

    -- 성공(Eod.Result.Common.Success)

    DECLARE ResultSuccess INT DEFAULT 0;



    -- 실패(Eod.Result.Common.Failed)

    DECLARE ResultFailed INT DEFAULT -1;



    -- 해당 이름이 이미 존재함.(Eod.Result.Common.SameNameExistAlready)

    DECLARE ResultRewardAlready INT DEFAULT 1106;





    DECLARE EXIT HANDLER FOR SQLEXCEPTION

    BEGIN

        SELECT ResultRewardAlready;

        ROLLBACK;

    END;





    SET AutoCommit = 0;



    START TRANSACTION;



        SET @LimitTimeSeconds = 0;



        SELECT `time_seconds`, `fixed`

        INTO @LimitTimeSeconds, @IsFixed

        FROM `eod_global`.`table_guild_names`

        WHERE (`application_identifier` = inAppName) AND (`name` = inInputName);



        IF (@LimitTimeSeconds <> 0) THEN

            IF (@LimitTimeSeconds >= inTimeSeconds) OR (@IsFixed = 1) THEN

                SELECT ResultRewardAlready;

            ELSE

                UPDATE `eod_global`.`table_guild_names`

                SET

                    `application_identifier` = inAppName,

                    `category_code` = inCategory,

                    `name` = inInputName,

                    `name_description` = inInputName,

                    `time_seconds` = inTimeSeconds - 1,

                    `fixed` = inIsFixed,

                    `register_key` = inRegisterKey,

                    `generate_datetime` = NOW()

                WHERE (`application_identifier` = inAppName) AND (`name` = inInputName);

                SELECT ResultSuccess;

            END IF;

        ELSE

            INSERT INTO `eod_global`.`table_guild_names`

                (`application_identifier`,

                 `category_code`,

                 `name`,

                 `name_description`,

                 `register_key`,

                 `time_seconds`,

                 `fixed`)

            VALUES

                (inAppName,

                 inCategory,

                 inInputName,

                 inInputName,

                 inRegisterKey,

                 (inTimeSeconds - 1),

                 inIsFixed);

            SELECT ResultSuccess;

        END IF;



    COMMIT;



    SET AutoCommit = 1;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_register_player_nickname` */;
DELIMITER ;;
CREATE DEFINER=`Administrator`@`211.41.204.39` PROCEDURE `sp_register_player_nickname`(IN inAppName VARCHAR(64),

                                               IN inCategory INT,

                                               IN inInputName VARCHAR(64),

                                               IN inRegisterKey VARCHAR(256),

                                               IN inTimeSeconds BIGINT,

                                               IN inIsFixed TINYINT)
BEGIN

    -- 성공(Eod.Result.Common.Success)

    DECLARE ResultSuccess INT DEFAULT 0;



    -- 실패(Eod.Result.Common.Failed)

    DECLARE ResultFailed INT DEFAULT -1;



    -- 해당 이름이 이미 존재함.(Eod.Result.Common.SameNameExistAlready)

    DECLARE ResultRewardAlready INT DEFAULT 1106;





    DECLARE EXIT HANDLER FOR SQLEXCEPTION

    BEGIN

        SELECT ResultRewardAlready;

        ROLLBACK;

    END;





    SET AutoCommit = 0;



    START TRANSACTION;



        SET @LimitTimeSeconds = 0;



        SELECT `time_seconds`, `fixed`

        INTO @LimitTimeSeconds, @IsFixed

        FROM `eod_global`.`table_player_nicknames`

        WHERE (`application_identifier` = inAppName) AND (`name` = inInputName);



        IF (@LimitTimeSeconds <> 0) THEN

            IF (@LimitTimeSeconds >= inTimeSeconds) OR (@IsFixed = 1) THEN

                SELECT ResultRewardAlready;

            ELSE

                UPDATE `eod_global`.`table_player_nicknames`

                SET

                    `application_identifier` = `inAppName`,

                    `category_code` = inCategory,

                    `name` = inInputName,

                    `name_description` = inInputName,

                    `time_seconds` = inTimeSeconds + 1,

                    `fixed` = inIsFixed,

                    `register_key` = inRegisterKey,

                    `generate_datetime` = NOW()

                WHERE (`application_identifier` = inAppName) AND (`name` = inInputName);

                SELECT ResultSuccess;

            END IF;

        ELSE

            INSERT INTO `eod_global`.`table_player_nicknames`

                (`application_identifier`,

                 `category_code`,

                 `name`,

                 `name_description`,

                 `register_key`,

                 `time_seconds`,

                 `fixed`)

            VALUES

                (inAppName,

                 inCategory,

                 inInputName,

                 inInputName,

                 inRegisterKey,

                 (inTimeSeconds + 1),

                 inIsFixed);

            SELECT ResultSuccess;

        END IF;



    COMMIT;



    SET AutoCommit = 1;

END ;;
DELIMITER ;

--
-- Current Database: `eod_log`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `eod_log` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;

USE `eod_log`;

--
-- Table structure for table `table_achievement`
--

CREATE TABLE `table_achievement` (
  `log_no` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '로그 번호',
  `log_time` datetime NOT NULL DEFAULT '1000-01-01 00:00:00' COMMENT '로그 일시',
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '플레이어 ID',
  `character_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '플레이어 캐릭터 ID',
  `character_level` int(11) NOT NULL DEFAULT '0' COMMENT '플레이어 캐릭터의 레벨',
  `general_type_code` int(11) NOT NULL DEFAULT '0' COMMENT '로그 대상이 되는 일반 타입 식별 코드',
  `is_clear` tinyint(1) NOT NULL DEFAULT '0' COMMENT '완료 여부',
  `get_reward` tinyint(1) NOT NULL DEFAULT '0' COMMENT '보상을 지급 받았는지 여부',
  PRIMARY KEY (`log_no`),
  KEY `idx_table_achievement_log_time` (`log_time`),
  KEY `idx_table_achievement_user_id_character_id` (`user_id`,`character_id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='업적 정보 로그';

--
-- Dumping data for table `table_achievement`
--

INSERT INTO `table_achievement` VALUES (1,'2020-09-19 12:49:50',1,1,1,914020201,1,0),(2,'2020-09-19 13:03:27',1,1,3,914020201,1,1),(3,'2020-09-19 13:05:25',1,1,3,905121001,1,0),(4,'2020-09-19 14:29:01',3,3,50,904111001,1,0),(5,'2020-09-19 14:29:01',3,3,50,904111002,1,0),(6,'2020-09-19 14:29:01',3,3,50,904111003,1,0),(7,'2020-09-19 14:29:01',3,3,50,904111004,1,0),(8,'2020-09-19 14:29:01',3,3,50,904111005,1,0),(9,'2020-09-19 14:29:01',3,3,50,904111006,1,0),(10,'2020-09-19 14:29:01',3,3,50,904111007,1,0),(11,'2020-09-19 14:29:01',3,3,50,904111008,1,0),(12,'2020-09-19 14:29:01',3,3,50,904111009,1,0),(13,'2020-09-19 14:29:01',3,3,50,904111010,1,0),(14,'2020-09-19 14:29:15',3,3,50,913010101,1,0),(15,'2020-09-19 14:29:25',2,2,5,904111001,1,0),(16,'2020-09-19 14:29:53',3,3,50,913020301,1,0),(17,'2020-09-19 14:30:11',2,2,50,904111002,1,0),(18,'2020-09-19 14:30:11',2,2,50,904111003,1,0),(19,'2020-09-19 14:30:11',2,2,50,904111004,1,0),(20,'2020-09-19 14:30:11',2,2,50,904111005,1,0),(21,'2020-09-19 14:30:11',2,2,50,904111006,1,0),(22,'2020-09-19 14:30:11',2,2,50,904111007,1,0),(23,'2020-09-19 14:30:11',2,2,50,904111008,1,0),(24,'2020-09-19 14:30:11',2,2,50,904111009,1,0),(25,'2020-09-19 14:30:11',2,2,50,904111010,1,0),(26,'2020-09-19 14:30:20',2,2,50,913010101,1,0),(27,'2020-09-19 14:31:02',3,3,50,913020302,1,0),(28,'2020-09-19 14:31:30',3,3,50,913020303,1,0),(29,'2020-09-19 15:36:09',2,5,37,904111001,1,0),(30,'2020-09-19 15:36:09',2,5,37,904111002,1,0),(31,'2020-09-19 15:36:09',2,5,37,904111003,1,0),(32,'2020-09-19 15:36:09',2,5,37,904111004,1,0),(33,'2020-09-19 15:36:09',2,5,37,904111005,1,0),(34,'2020-09-19 15:36:09',2,5,37,904111006,1,0),(35,'2020-09-19 15:36:09',2,5,37,904111007,1,0),(36,'2020-09-19 17:25:43',4,4,43,904111001,1,0),(37,'2020-09-19 17:25:43',4,4,43,904111002,1,0),(38,'2020-09-19 17:25:43',4,4,43,904111003,1,0),(39,'2020-09-19 17:25:43',4,4,43,904111004,1,0),(40,'2020-09-19 17:25:43',4,4,43,904111005,1,0),(41,'2020-09-19 17:25:43',4,4,43,904111006,1,0),(42,'2020-09-19 17:25:43',4,4,43,904111007,1,0),(43,'2020-09-19 17:25:43',4,4,43,904111008,1,0),(44,'2020-09-20 17:26:07',5,7,5,904111001,1,0),(45,'2020-09-20 17:29:58',5,7,6,905111001,1,0),(46,'2020-09-20 18:53:48',5,7,8,905121001,1,0),(47,'2020-09-20 18:53:51',5,7,8,905111002,1,0),(48,'2020-09-20 18:59:32',5,7,8,905111003,1,0),(49,'2020-09-20 22:56:38',5,7,10,904111002,1,0),(50,'2020-09-20 23:46:22',5,7,12,905111004,1,0),(51,'2020-09-21 11:04:14',4,4,43,914010201,1,0),(52,'2020-09-21 11:04:14',4,4,43,914010202,1,0),(53,'2020-09-21 11:04:14',4,4,43,914010203,1,0),(54,'2020-09-21 11:04:14',4,4,43,914010204,1,0),(55,'2020-09-21 11:04:14',4,4,43,914010205,1,0),(56,'2020-09-21 11:04:14',4,4,43,914010206,1,0),(57,'2020-09-21 11:04:14',4,4,43,914010207,1,0),(58,'2020-09-21 11:04:14',4,4,43,914010208,1,0),(59,'2020-09-21 11:04:14',4,4,43,914010209,1,0),(60,'2020-09-21 11:04:14',4,4,43,914010210,1,0),(61,'2020-09-21 11:04:14',4,4,43,914010211,1,0),(62,'2020-09-21 11:04:14',4,4,43,914010212,1,0),(63,'2020-09-21 11:04:14',4,4,43,914010213,1,0),(64,'2020-09-21 11:04:14',4,4,43,914010214,1,0),(65,'2020-09-21 11:04:14',4,4,43,914010215,1,0),(66,'2020-09-21 11:04:14',4,4,43,914010216,1,0),(67,'2020-09-21 11:04:14',4,4,43,914010217,1,0),(68,'2020-09-21 11:04:14',4,4,43,914010218,1,0),(69,'2020-09-21 11:04:14',4,4,43,914010219,1,0),(70,'2020-09-21 11:04:14',4,4,43,914010220,1,0),(71,'2020-09-21 11:04:14',4,4,43,914010221,1,0),(72,'2020-09-21 11:04:14',4,4,43,914010222,1,0),(73,'2020-09-21 11:04:14',4,4,43,914010223,1,0),(74,'2020-09-21 11:04:33',2,5,37,914010201,1,0),(75,'2020-09-21 11:04:33',2,5,37,914010202,1,0),(76,'2020-09-21 11:04:33',2,5,37,914010203,1,0),(77,'2020-09-21 11:04:33',2,5,37,914010204,1,0),(78,'2020-09-21 11:04:33',2,5,37,914010205,1,0),(79,'2020-09-21 11:04:33',2,5,37,914010206,1,0),(80,'2020-09-21 11:04:33',2,5,37,914010207,1,0),(81,'2020-09-21 11:04:33',2,5,37,914010208,1,0),(82,'2020-09-21 11:04:33',2,5,37,914010209,1,0),(83,'2020-09-21 11:04:33',2,5,37,914010210,1,0),(84,'2020-09-21 11:04:33',2,5,37,914010211,1,0),(85,'2020-09-21 11:04:33',2,5,37,914010212,1,0),(86,'2020-09-21 11:04:33',2,5,37,914010213,1,0),(87,'2020-09-21 11:04:33',2,5,37,914010214,1,0),(88,'2020-09-21 11:04:33',2,5,37,914010215,1,0),(89,'2020-09-21 11:04:33',2,5,37,914010216,1,0),(90,'2020-09-21 11:04:33',2,5,37,914010217,1,0),(91,'2020-09-21 11:04:33',2,5,37,914010218,1,0),(92,'2020-09-21 11:04:33',2,5,37,914010219,1,0),(93,'2020-09-21 11:04:33',2,5,37,914010220,1,0),(94,'2020-09-21 11:04:33',2,5,37,914010221,1,0),(95,'2020-09-21 11:04:33',2,5,37,914010222,1,0),(96,'2020-09-21 11:04:33',2,5,37,914010223,1,0),(97,'2020-09-21 18:59:54',2,11,32,904111001,1,0),(98,'2020-09-21 18:59:54',2,11,32,904111002,1,0),(99,'2020-09-21 18:59:54',2,11,32,904111003,1,0),(100,'2020-09-21 18:59:54',2,11,32,904111004,1,0),(101,'2020-09-21 18:59:54',2,11,32,904111005,1,0),(102,'2020-09-21 18:59:54',2,11,32,904111006,1,0),(103,'2020-09-21 19:49:38',5,14,5,904111001,1,0),(104,'2020-09-21 20:02:07',5,7,13,905111005,1,0),(105,'2020-09-21 20:29:01',9,15,3,905121001,1,0),(106,'2020-09-22 00:39:32',1,1,5,904111001,1,0);

--
-- Table structure for table `table_admission`
--

CREATE TABLE `table_admission` (
  `log_no` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '로그 번호',
  `log_time` datetime NOT NULL DEFAULT '1000-01-01 00:00:00' COMMENT '로그 일시',
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '플레이어 ID',
  `character_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '플레이어 캐릭터 ID',
  `character_level` int(11) NOT NULL DEFAULT '0' COMMENT '플레이어 캐릭터의 레벨',
  `general_type_code` int(11) NOT NULL DEFAULT '0' COMMENT '로그 대상이 되는 일반 타입 식별 코드',
  `amount` int(11) NOT NULL DEFAULT '0' COMMENT '변화량',
  `after_amount` int(11) NOT NULL DEFAULT '0' COMMENT '처리 이후의 보유량',
  `get_route` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '획득 경로\n: eRoute의 값과 같다.',
  `consume_route` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '소비 경로\n: eRoute의 값과 같다.',
  PRIMARY KEY (`log_no`),
  KEY `idx_table_admission_log_time` (`log_time`),
  KEY `idx_table_admission_user_id_character_id` (`user_id`,`character_id`)
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='입장권 획득 / 소모 내역 로그';

--
-- Dumping data for table `table_admission`
--

INSERT INTO `table_admission` VALUES (1,'2020-09-19 13:00:18',1,1,1,160002003,3,47,0,28),(2,'2020-09-19 13:01:26',1,1,2,160002003,4,51,39,0),(3,'2020-09-19 13:01:51',1,1,2,160002003,3,48,0,28),(4,'2020-09-19 13:02:57',1,1,3,160002003,4,52,39,0),(5,'2020-09-19 13:11:01',2,2,1,160002003,3,47,0,28),(6,'2020-09-19 13:12:55',2,2,2,160002003,4,51,39,0),(7,'2020-09-19 13:14:01',2,2,2,160002003,3,48,0,28),(8,'2020-09-19 13:15:09',2,2,3,160002003,4,52,39,0),(9,'2020-09-19 13:16:02',2,2,3,160002003,3,49,0,28),(10,'2020-09-19 13:18:08',2,2,3,160002003,3,46,0,28),(11,'2020-09-19 14:19:51',3,3,1,160002003,3,47,0,28),(12,'2020-09-19 14:24:33',3,3,2,160002003,4,51,39,0),(13,'2020-09-19 14:25:05',3,3,2,160002003,3,48,0,28),(14,'2020-09-19 14:27:10',3,3,3,160002003,4,52,39,0),(15,'2020-09-19 14:27:12',2,2,4,160002003,1,53,39,0),(16,'2020-09-19 14:27:49',3,3,3,160002003,3,49,0,28),(17,'2020-09-19 14:28:10',2,2,4,160002003,3,50,0,28),(18,'2020-09-19 14:29:01',3,3,50,160002003,50,99,39,0),(19,'2020-09-19 14:29:25',2,2,5,160002003,4,54,39,0),(20,'2020-09-19 14:30:11',2,2,50,160002003,45,99,39,0),(21,'2020-09-19 14:40:12',4,4,1,160002003,3,47,0,28),(22,'2020-09-19 14:41:46',4,4,2,160002003,4,51,39,0),(23,'2020-09-19 14:42:31',4,4,2,160002003,3,48,0,28),(24,'2020-09-19 15:36:09',2,5,37,160002003,36,86,39,0),(25,'2020-09-19 15:43:58',4,4,2,160002003,3,48,0,28),(26,'2020-09-19 16:43:08',4,4,3,160002003,1,52,39,0),(27,'2020-09-19 16:43:56',4,4,3,160002003,3,49,0,28),(28,'2020-09-19 17:25:43',4,4,43,160002003,40,92,39,0),(29,'2020-09-20 17:10:08',5,7,1,160002003,3,47,0,28),(30,'2020-09-20 17:11:41',5,7,2,160002003,4,51,39,0),(31,'2020-09-20 17:12:17',5,7,2,160002003,3,48,0,28),(32,'2020-09-20 17:13:32',5,7,3,160002003,4,52,39,0),(33,'2020-09-20 17:14:20',5,7,3,160002003,3,49,0,28),(34,'2020-09-20 17:16:09',5,7,3,160002003,3,46,0,28),(35,'2020-09-20 17:17:26',5,7,4,160002003,7,53,39,0),(36,'2020-09-20 17:24:57',5,7,4,160002003,3,50,0,28),(37,'2020-09-20 17:26:07',5,7,5,160002003,4,54,39,0),(38,'2020-09-20 17:26:36',5,7,5,160002003,6,48,0,28),(39,'2020-09-20 17:28:11',5,7,5,160002003,3,45,0,28),(40,'2020-09-20 17:29:26',5,7,6,160002003,10,55,39,0),(41,'2020-09-20 17:30:50',5,7,6,160002003,6,49,0,28),(42,'2020-09-20 17:35:45',5,7,6,160002003,6,43,0,28),(43,'2020-09-20 17:36:48',5,7,7,160002003,13,56,39,0),(44,'2020-09-20 17:55:36',5,7,7,160002003,3,53,0,28),(45,'2020-09-20 17:58:56',5,7,7,160002003,3,50,0,28),(46,'2020-09-20 18:07:39',5,7,7,160002003,3,49,0,28),(47,'2020-09-20 18:09:04',5,7,8,160002003,8,57,39,0),(48,'2020-09-20 18:20:28',6,8,1,160002003,3,47,0,28),(49,'2020-09-20 18:22:02',6,8,2,160002003,4,51,39,0),(50,'2020-09-20 18:23:24',6,8,2,160002003,3,48,0,28),(51,'2020-09-20 18:24:56',6,8,3,160002003,4,52,39,0),(52,'2020-09-20 18:35:47',5,7,8,160002003,3,54,0,28),(53,'2020-09-20 18:53:23',5,7,8,160002003,50,106,2,0),(54,'2020-09-20 18:53:28',5,7,8,160002003,10,116,16,0),(55,'2020-09-20 18:55:01',5,7,8,160002003,3,113,0,28),(56,'2020-09-20 18:56:12',5,7,8,160002003,3,110,0,28),(57,'2020-09-20 18:57:39',5,7,8,160002003,3,107,0,28),(58,'2020-09-20 19:01:08',5,7,8,160002003,3,104,0,28),(59,'2020-09-20 19:04:36',5,7,9,160002003,3,101,0,28),(60,'2020-09-20 19:15:15',5,7,9,160002003,3,98,0,28),(61,'2020-09-20 19:17:02',5,7,9,160002003,3,95,0,28),(62,'2020-09-20 19:21:06',5,7,9,160002003,3,92,0,28),(63,'2020-09-20 19:25:51',5,7,9,160002003,3,89,0,28),(64,'2020-09-20 22:54:49',5,7,9,160002003,3,86,0,28),(65,'2020-09-20 23:01:04',5,7,10,160002003,4,82,0,28),(66,'2020-09-20 23:05:05',5,7,10,160002003,4,78,0,28),(67,'2020-09-20 23:08:04',5,7,11,160002003,90,168,16,0),(68,'2020-09-20 23:08:56',5,7,11,160002003,50,218,2,0),(69,'2020-09-20 23:09:26',5,7,11,160002003,4,214,0,28),(70,'2020-09-20 23:11:31',5,7,11,160002003,20,194,0,28),(71,'2020-09-20 23:13:41',5,7,11,160002003,4,190,0,28),(72,'2020-09-20 23:17:27',5,7,12,160002003,4,186,0,28),(73,'2020-09-20 23:23:33',5,7,12,160002003,4,182,0,28),(74,'2020-09-20 23:26:59',5,7,12,160002003,4,178,0,28),(75,'2020-09-20 23:29:59',5,7,12,160002003,4,174,0,28),(76,'2020-09-20 23:34:00',5,7,12,160002003,4,170,0,28),(77,'2020-09-20 23:38:41',5,7,12,160002003,4,166,0,28),(78,'2020-09-20 23:46:53',5,7,12,160002003,4,162,0,28),(79,'2020-09-21 10:54:57',7,9,1,160002003,3,47,0,28),(80,'2020-09-21 12:28:59',6,10,1,160002003,3,47,0,28),(81,'2020-09-21 12:30:25',6,10,2,160002003,4,51,39,0),(82,'2020-09-21 12:31:01',6,10,2,160002003,3,48,0,28),(83,'2020-09-21 12:33:09',6,10,3,160002003,4,52,39,0),(84,'2020-09-21 15:29:55',4,4,43,160002003,3,89,0,28),(85,'2020-09-21 18:59:54',2,11,32,160002003,31,81,39,0),(86,'2020-09-21 19:04:54',8,13,1,160002003,3,47,0,28),(87,'2020-09-21 19:06:03',8,13,2,160002003,4,51,39,0),(88,'2020-09-21 19:06:33',8,13,2,160002003,3,48,0,28),(89,'2020-09-21 19:07:33',8,13,3,160002003,4,52,39,0),(90,'2020-09-21 19:08:07',8,13,3,160002003,3,49,0,28),(91,'2020-09-21 19:24:55',8,13,3,160002003,3,48,0,28),(92,'2020-09-21 19:35:50',5,7,12,160002003,4,158,0,28),(93,'2020-09-21 19:39:10',5,7,12,160002003,110,268,16,0),(94,'2020-09-21 19:41:25',5,14,1,160002003,3,47,0,28),(95,'2020-09-21 19:42:20',5,14,2,160002003,4,51,39,0),(96,'2020-09-21 19:42:30',5,14,2,160002003,3,48,0,28),(97,'2020-09-21 19:43:26',5,14,3,160002003,4,52,39,0),(98,'2020-09-21 19:44:00',5,14,3,160002003,3,49,0,28),(99,'2020-09-21 19:45:25',5,14,3,160002003,3,46,0,28),(100,'2020-09-21 19:46:59',5,14,4,160002003,7,53,39,0),(101,'2020-09-21 19:48:08',5,14,4,160002003,3,50,0,28),(102,'2020-09-21 19:49:38',5,14,5,160002003,4,54,39,0),(103,'2020-09-21 19:49:53',5,14,5,160002003,3,51,0,28),(104,'2020-09-21 19:55:38',5,7,12,160002003,3,265,0,28),(105,'2020-09-21 19:56:44',5,7,13,160002003,3,262,0,28),(106,'2020-09-21 19:57:12',9,15,1,160002003,3,47,0,28),(107,'2020-09-21 19:58:04',5,7,13,160002003,3,259,0,28),(108,'2020-09-21 19:59:11',5,7,13,160002003,3,256,0,28),(109,'2020-09-21 20:02:46',5,7,13,160002003,50,306,2,0),(110,'2020-09-21 20:03:01',5,7,13,160002003,4,302,0,28),(111,'2020-09-21 20:05:21',5,7,13,160002003,4,298,0,28),(112,'2020-09-21 20:11:02',5,7,13,160002003,4,294,0,28),(113,'2020-09-21 20:15:39',5,16,1,160002003,3,47,0,28),(114,'2020-09-21 20:16:31',5,16,2,160002003,4,51,39,0),(115,'2020-09-21 20:20:44',10,17,1,160002003,3,47,0,28),(116,'2020-09-21 20:22:03',10,17,2,160002003,4,51,39,0),(117,'2020-09-21 20:24:18',9,15,1,160002003,3,47,0,28),(118,'2020-09-21 20:24:50',10,17,2,160002003,3,48,0,28),(119,'2020-09-21 20:25:26',9,15,2,160002003,4,51,39,0),(120,'2020-09-21 20:25:50',9,15,2,160002003,3,48,0,28),(121,'2020-09-21 20:26:02',10,17,3,160002003,4,52,39,0),(122,'2020-09-21 20:26:47',9,15,3,160002003,4,52,39,0),(123,'2020-09-21 20:27:33',9,15,3,160002003,50,102,2,0),(124,'2020-09-22 00:26:49',1,1,3,160002003,50,102,2,0),(125,'2020-09-22 00:27:31',1,1,3,160002003,3,99,0,28),(126,'2020-09-22 00:31:28',1,1,3,160002003,3,96,0,28),(127,'2020-09-22 00:38:28',1,1,4,160002003,3,93,0,28),(128,'2020-09-22 00:40:38',1,1,5,160002003,3,90,0,28),(129,'2020-09-22 00:57:02',1,1,5,160002003,3,87,0,28),(130,'2020-09-22 16:52:38',11,18,1,160002003,3,47,0,28),(131,'2020-09-22 16:55:54',11,18,1,160002003,3,44,0,28),(132,'2020-09-22 17:01:33',11,18,2,160002003,7,51,39,0),(133,'2020-09-22 17:03:44',11,18,2,160002003,3,48,0,28),(134,'2020-09-22 17:04:42',11,18,3,160002003,4,52,39,0);

--
