#masterブランチにdevelopブランチをマージ
git checkout develop
git pull
git checkout master
git pull
git merge origin/develop
git push
#本番環境に反映
ssh jr-adm
update web
deploy web
#バッチファイルの設定
crontab -e
#RaidMonsterEventAnalytics
10 10 * * * ENVIRONMENT=${JR_ENV} PF=yamada ${JR_DIR}/lib/exec/user_event_raid_analytics.sh
#レイドモンスターデータの設定(event_no = 2)
master_raid_monster_data
master_raid_monster_data_skill
master_raid_monster_data_skill_set開発から本番へ(db)
#開発
ssh jr-dev
cd jrye-db/bin
php mysql2csv.php db名 table名
php mysql2csv.php jrye master_raid_monster_data
php csv2xls.php csv名
php csv2xls.php ../csv/master_raid_monster_data.csv
git add .
git commit -m ""
#local環境(jrey-db develop)にて
git pull
git checkout master
git merge develop
git push
#本番
ssh jr-adm
deploy dbメモ
tableのupdate(しないと前回結果がそのまま反映されます)
#更新
UPDATE `user_mission` SET `raid_point`=0,`raid_point2`=0,`total_raid_point`=0,`m_event_limit`=0;
UPDATE `team_data` SET `raid_stamina`=0,`raid_monster`=0,`raid_monster_vs`=0,`raid_lv`=0,`raid_count`=0,`total_raid_count`=0,`event_raid_count`=0,`war_bonus_time`=0,`event_prize`=0,`raid_vs_end_time`=0;
#確認用
SELECT `user_no`,`raid_point`,`raid_point2`,`total_raid_point`,`m_event_limit` FROM `user_mission` ORDER BY `m_event_limit` DESC
SELECT `raid_stamina`,`raid_monster`,`raid_monster_vs`,`raid_lv`,`raid_count`,`total_raid_count`,`event_raid_count`,`war_bonus_time`,`event_prize`,`raid_vs_end_time` FROM `team_data` WHERE del_flg=0 ORDER BY `raid_stamina` DESC
#log移動(下記対象log)
cd jr-admin
git pull
cd lib/exec/
ENVIRONMENT=production PF=yamada php tool_delete_raid_log.inc
log_user_raid_point;
log_team_raid_monster_vs;
log_team_raid_monster_damage_vs;
log_team_raid_monster;
log_team_raid_monster_damage;
log_team_raid_item;
log_team_raid_matching_lv_up;