-- -----------------------------------------------------------------------------
--
--  데이터베이스 초기화(테스트 용 DB)
--
--   경고WARNING!
--  : 이 질의문은 데이터베이스에 존재하는 모든 데이터를 삭제한다.
--   반드시 필요한 작업인지 점검하고, 이 질의문을 수행해야 한다.
--
--   실수로 질의문을 수행하는 사고의 방지를 위해, 각 구문 앞에는 #으로 주석 처리
--  가 되어 있다.
--   사용할 때는 # 주석을 풀고 사용하고, 사용이 끝난 뒤에는 반드시 원래대로 # 주석
--  을 다시 살려야 한다.
--
-- -----------------------------------------------------------------------------



---- -----------------------------------------------------------------------------
----  `eod_global`
---- -----------------------------------------------------------------------------
--
-- TRUNCATE TABLE `eod_global`.`table_account_user_serial_codes`;
-- -- TRUNCATE TABLE `eod_global`.`table_application_contract`;
-- TRUNCATE TABLE `eod_global`.`table_guild_names`;
-- TRUNCATE TABLE `eod_global`.`table_igaworks_coupon`;
-- TRUNCATE TABLE `eod_global`.`table_player_nicknames`;
-- TRUNCATE TABLE `eod_global`.`table_promotion_data`;
-- TRUNCATE TABLE `eod_global`.`table_promotion_log`;
--
--
---- -----------------------------------------------------------------------------
----  `eod_configuration`
---- -----------------------------------------------------------------------------
--
---- 특별한 경우가 아니라면, 구성 DB는 건드리지 않음.
--
--
---- -----------------------------------------------------------------------------
----  `eod_authentication`
---- -----------------------------------------------------------------------------
--
-- TRUNCATE TABLE `eod_authentication`.`table_account_relationship`;
-- TRUNCATE TABLE `eod_authentication`.`table_account_user`;
--
--
---- -----------------------------------------------------------------------------
----  `eod_game`
---- -----------------------------------------------------------------------------
--
-- TRUNCATE TABLE `eod_game`.`table_achievement`;
-- TRUNCATE TABLE `eod_game`.`table_achievement_record`;
-- TRUNCATE TABLE `eod_game`.`table_attendance_record`;
-- TRUNCATE TABLE `eod_game`.`table_avatar_item`;
-- TRUNCATE TABLE `eod_game`.`table_avatar_item_equipped`;
-- TRUNCATE TABLE `eod_game`.`table_equipment_item`;
-- TRUNCATE TABLE `eod_game`.`table_equipment_item_equipped`;
-- TRUNCATE TABLE `eod_game`.`table_guardian_stone`;
-- TRUNCATE TABLE `eod_game`.`table_guardian_stone_equipped`;
-- TRUNCATE TABLE `eod_game`.`table_mission`;
-- TRUNCATE TABLE `eod_game`.`table_monthly_product`;
-- TRUNCATE TABLE `eod_game`.`table_occupation_war_record`;
-- TRUNCATE TABLE `eod_game`.`table_occupation_war_reward`;
-- TRUNCATE TABLE `eod_game`.`table_player`;
-- TRUNCATE TABLE `eod_game`.`table_player_character`;
-- TRUNCATE TABLE `eod_game`.`table_post`;
-- TRUNCATE TABLE `eod_game`.`table_quest`;
-- TRUNCATE TABLE `eod_game`.`table_re_purchase_count`;
-- TRUNCATE TABLE `eod_game`.`table_servant`;
-- TRUNCATE TABLE `eod_game`.`table_servant_collection_reward`;
-- TRUNCATE TABLE `eod_game`.`table_servant_equipped`;
-- TRUNCATE TABLE `eod_game`.`table_shop_buy_count`;
-- TRUNCATE TABLE `eod_game`.`table_shop_servant_piece`;
-- TRUNCATE TABLE `eod_game`.`table_skill`;
-- TRUNCATE TABLE `eod_game`.`table_skill_equipped`;
-- TRUNCATE TABLE `eod_game`.`table_stage_elite_accomplishment`;
-- TRUNCATE TABLE `eod_game`.`table_stage_elite_act_record`;
-- TRUNCATE TABLE `eod_game`.`table_stage_guardian_raid_accomplishment`;
-- TRUNCATE TABLE `eod_game`.`table_stage_normal_accomplishment`;
-- TRUNCATE TABLE `eod_game`.`table_stage_normal_act_record`;
-- TRUNCATE TABLE `eod_game`.`table_stage_occupation_war_accomplishment`;
-- TRUNCATE TABLE `eod_game`.`table_stage_record`;
-- TRUNCATE TABLE `eod_game`.`table_stage_rift_accomplishment`;
-- TRUNCATE TABLE `eod_game`.`table_stage_transcendence_accomplishment`;
-- TRUNCATE TABLE `eod_game`.`table_stage_weekly_accomplishment`;
-- TRUNCATE TABLE `eod_game`.`table_stage_west_accomplishment`;
-- TRUNCATE TABLE `eod_game`.`table_stage_west_act_record`;
-- TRUNCATE TABLE `eod_game`.`table_story`;
-- TRUNCATE TABLE `eod_game`.`table_tutorial`;
-- TRUNCATE TABLE `eod_game`.`table_worth`;
--
--
---- -----------------------------------------------------------------------------
----  `eod_community`
---- -----------------------------------------------------------------------------
--
-- TRUNCATE TABLE `eod_community`.`table_connect_event`;
-- TRUNCATE TABLE `eod_community`.`table_connect_event_log`;
-- TRUNCATE TABLE `eod_community`.`table_coupon`;
-- TRUNCATE TABLE `eod_community`.`table_coupon_log`;
-- TRUNCATE TABLE `eod_community`.`table_coupon_temp`;
-- TRUNCATE TABLE `eod_community`.`table_friend`;
-- TRUNCATE TABLE `eod_community`.`table_guild`;
-- TRUNCATE TABLE `eod_community`.`table_guild_join_request`;
-- TRUNCATE TABLE `eod_community`.`table_guild_membership`;
-- TRUNCATE TABLE `eod_community`.`table_guild_skill`;
-- TRUNCATE TABLE `eod_community`.`table_in_game_always_event`;
-- TRUNCATE TABLE `eod_community`.`table_in_game_event`;
-- TRUNCATE TABLE `eod_community`.`table_keyword_coupon`;
-- TRUNCATE TABLE `eod_community`.`table_keyword_coupon_log`;
-- TRUNCATE TABLE `eod_community`.`table_party_squad`;
--
--
---- -----------------------------------------------------------------------------
----  `eod_log`
---- -----------------------------------------------------------------------------
--
-- TRUNCATE TABLE `eod_log`.`table_achievement`;
-- TRUNCATE TABLE `eod_log`.`table_admission`;
-- TRUNCATE TABLE `eod_log`.`table_avatar`;
-- TRUNCATE TABLE `eod_log`.`table_billing`;
-- TRUNCATE TABLE `eod_log`.`table_daily_mission`;
-- TRUNCATE TABLE `eod_log`.`table_equipment`;
-- TRUNCATE TABLE `eod_log`.`table_friendship_point`;
-- TRUNCATE TABLE `eod_log`.`table_gem`;
-- TRUNCATE TABLE `eod_log`.`table_gold`;
-- TRUNCATE TABLE `eod_log`.`table_guardian_stone`;
-- TRUNCATE TABLE `eod_log`.`table_guild_coin`;
-- TRUNCATE TABLE `eod_log`.`table_item`;
-- TRUNCATE TABLE `eod_log`.`table_mileage`;
-- TRUNCATE TABLE `eod_log`.`table_monthly_mission`;
-- TRUNCATE TABLE `eod_log`.`table_post`;
-- TRUNCATE TABLE `eod_log`.`table_rift_stone`;
-- TRUNCATE TABLE `eod_log`.`table_ruby`;
-- TRUNCATE TABLE `eod_log`.`table_servant`;
-- TRUNCATE TABLE `eod_log`.`table_shopping`;
-- TRUNCATE TABLE `eod_log`.`table_stage_arena_async`;
-- TRUNCATE TABLE `eod_log`.`table_stage_arena_async_reward`;
-- TRUNCATE TABLE `eod_log`.`table_stage_elite`;
-- TRUNCATE TABLE `eod_log`.`table_stage_guardian_raid`;
-- TRUNCATE TABLE `eod_log`.`table_stage_guild_war`;
-- TRUNCATE TABLE `eod_log`.`table_stage_normal`;
-- TRUNCATE TABLE `eod_log`.`table_stage_rift`;
-- TRUNCATE TABLE `eod_log`.`table_stage_transcendence`;
-- TRUNCATE TABLE `eod_log`.`table_stage_weekly`;
-- TRUNCATE TABLE `eod_log`.`table_weekly_mission`;
--
--
---- -----------------------------------------------------------------------------
----  `eod_tool`
---- -----------------------------------------------------------------------------
--
-- -- 관리툴 계정 DB는 특별한 경우가 아니면 삭제 대상이 아님
-- -- TRUNCATE TABLE `eod_tool`.`table_account`;
-- TRUNCATE TABLE `eod_tool`.`table_bulk_insert`;
-- TRUNCATE TABLE `eod_tool`.`table_connect_event`;
-- TRUNCATE TABLE `eod_tool`.`table_coupon`;
-- TRUNCATE TABLE `eod_tool`.`table_in_game_always_event`;
-- TRUNCATE TABLE `eod_tool`.`table_in_game_event`;
-- TRUNCATE TABLE `eod_tool`.`table_keyword_coupon`;
-- TRUNCATE TABLE `eod_tool`.`table_notice`;
-- TRUNCATE TABLE `eod_tool`.`table_sanctions`;

