チーム戦争バッチ修正 #34

チーム戦争issue #13

• [x] matching_team_battle.sh
• [x] team_battle.sh
• [x] team_battle_ranking.sh

---

チーム戦争db作り直し

https://qiita.com/yaboojp/items/85e6356622e30cff88cb

rm -rf Docker_ds/data/mysql57/jrye_teamWar

mysql -e "DROP DATABASE IF EXISTS jrye_teamWar; CREATE DATABASE IF NOT EXISTS jrye_teamWar;"
cat jrye_teamWar.sql | mysql jrye_teamWar

jrye_teamWar.teamWar_lock.status のデフォルトを0に設定
teamWar_userpoint.user_point のデフォルトを0に設定

ALTER TABLE teamWar_lock ALTER COLUMN status SET DEFAULT 0;
ALTER TABLE teamWar_userpoint ALTER COLUMN user_point SET DEFAULT 0;
ALTER TABLE teamWar_userpoint ALTER COLUMN attack SET DEFAULT 0;
ALTER TABLE teamWar_userpoint ALTER COLUMN defense SET DEFAULT 0;

matching_team_battle.shで更新されるデータ

# マッチログ
jrye_teamWar.jryeteamWar_matchlog
# 戦争、一騎打ち時間の設定
jrye_teamWar.teamWar_lock
# war_id（teamWar_lock.war_id）を更新
jrye.team_data
# inspire/war_flgを0に設定
jrye.team_pet
# マッチデータ作成
jrye_teamWar.teamWar_info

ログ削除バッチ

• [x] del_log_teamWar_userpoint.inc #90日後から
• [x] del_log_teamWar_attackList.inc

ログ集計バッチ

cpanel_daily_war_victory_minutely.sh
cpanel_daily_war_analytics.sh
cpanel_daily_war_active_user_minutely.sh
cpanel_daily_war_active_user.sh

集計が必要なテーブル

cpanel_daily_war_active_user_count
cpanel_daily_war_active_user_minutely
cpanel_daily_war_emblem_count
cpanel_daily_war_flag_count
cpanel_daily_war_team_victory_minutely
cpanel_daily_teamWar_ship_analytics