PR

建築イベント報酬建物のステータス再登録 #505

iwamoto opened this at 2020-12-18T18:54:07; closed

Description

opened by iwamoto at 2020-12-18T18:54:07; updated 2023-08-16T11:22:41

建築物ステータス再登録バッチ #499

lv1時のステータス各種確認 : 対象建物(氷の城 6039,6040,6041)
https://docs.google.com/spreadsheets/d/1lRl51OzpxTRm5hb3DRlCANUzOUQ7PmxgR14FJ1SfTx8/edit#gid=269801047

テーブル にDEFAULTを設定(既存のままだとエラーになるので)

ALTER TABLE `master_object_data_detail` ALTER `friend_item1` SET DEFAULT 0;
ALTER TABLE `master_object_data_detail` ALTER `friend_item1_num` SET DEFAULT 0;
ALTER TABLE `master_object_data_detail` ALTER `friend_item2` SET DEFAULT 0;
ALTER TABLE `master_object_data_detail` ALTER `friend_item2_num` SET DEFAULT 0;
ALTER TABLE `master_object_data_detail` ALTER `friend_item3` SET DEFAULT 0;
ALTER TABLE `master_object_data_detail` ALTER `friend_item3_num` SET DEFAULT 0;

ALTER TABLE `master_object_data_lv` ALTER `adjoin_per` SET DEFAULT 0;
ALTER TABLE `master_object_data_lv` ALTER `need_crystal` SET DEFAULT 0;

ALTER TABLE `master_object_data` ALTER `description` SET DEFAULT '';

この方法か、バッチ側にそれぞれ記載した方がいいのか…

Comment

#8790 by iwamoto at 2020-12-18T18:55:02; updated 2020-12-18T18:55:02

@wada
こちらレビューをお願いします。

iwamoto add_label at 2020-12-18T19:00:17: レビュー待ち

Comment

#8796 by wada at 2020-12-21T11:47:48; updated 2020-12-21T11:47:48

@iwamoto
見た目問題なさそうです。

iwamoto merge at 2020-12-21T14:39:25: 建築イベント報酬建物のステータス再登録
iwamoto close at 2020-12-21T14:39:25: Close

Commit range

base2eb5ec0f75552060a0345c0415425ae430ff5f7e
head0c690c87382bc42716ab3a95c2a933e13a986ab6
base branchjolly/jr-web:develop
head branchjolly/jr-web:fix_build_status_bat_499

View commits

Commit details are loaded from Git when a dynamic archive server is running, or can be embedded with --include-commits.
Files changed1 filesView patch
statusfile
modifiedlib/exec/tool_jrce_status.php
Patch body is stored as a separate file to keep this page lightweight.