Issue

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

iwamoto opened this at 2020-12-16T17:39:56; closed

Description

opened by iwamoto at 2020-12-16T17:39:56; updated 2023-08-17T15:11:19

ステータス各種 - 氷の城:6039,6040,6041
https://docs.google.com/spreadsheets/d/1lRl51OzpxTRm5hb3DRlCANUzOUQ7PmxgR14FJ1SfTx8/edit#gid=269801047

対象バッチ
tool_jrce_status.php

Comment

#8734 by iwamoto at 2020-12-16T19:19:25; updated 2020-12-16T22:28:48

初期値を設定する

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 '';

うーん…バッチ側に値を設定するか…

iwamoto commit at 2020-12-16T21:57:32: 動作修正&ステータス変更 #499 0c690c87382bc42716ab3a95c2a933e13a986ab6
iwamoto refer at 2020-12-18T18:54:07: 505:建築イベント報酬建物のステータス再登録
iwamoto close at 2020-12-22T18:18:07: Close