PR

【1/19】技玉ガチャ #284

wada opened this at 2023-01-18T12:15:51; closed

Description

opened by wada at 2023-01-18T12:15:51; updated 2023-01-31T15:41:51

技玉リリース前にスキルマニュアル逆引きがリリースされた場合、
リリース前にmaster_item_skill.del_flg=0を対応

select * from master_item_skill where item_no in(
4992,4993,4994,4995,5016,5017,5018,5019,5207,5208,5209,5210,5356,5357,5358,5359,4347,4348,4349,4350,4791,4792,4793,4794,5040,5041,5042,5043,5060,5061,5062,5063,5076,5077,5078,5079,5240,5241,5242,5243,5264,5265,5266,5267,5268,5269,5270,5271,4740,4741,4742,4743,4744,4745,4746,4747,4787,4788,4789,4790,4803,4804,4805,4806,5276,5277,5278,5279,5280,5281,5282,5283,5284,5285,5286,5287
);

update master_item_skill set del_flg = 0 where item_no in(
4992,4993,4994,4995,5016,5017,5018,5019,5207,5208,5209,5210,5356,5357,5358,5359,4347,4348,4349,4350,4791,4792,4793,4794,5040,5041,5042,5043,5060,5061,5062,5063,5076,5077,5078,5079,5240,5241,5242,5243,5264,5265,5266,5267,5268,5269,5270,5271,4740,4741,4742,4743,4744,4745,4746,4747,4787,4788,4789,4790,4803,4804,4805,4806,5276,5277,5278,5279,5280,5281,5282,5283,5284,5285,5286,5287
);

Comment

#25127 by wada at 2023-01-18T12:16:00; updated 2023-01-18T12:16:00

@kouho
レビューお願いします。

kouho add_label at 2023-01-18T19:18:00: 皇甫 LGTM

Comment

#25154 by kouho at 2023-01-18T19:18:06; updated 2023-01-18T19:18:06

@wada
確認OKです

wada merge at 2023-01-19T10:00:27: 【1/19】技玉ガチャ
wada close at 2023-01-19T10:00:27: Close
wada refer at 2023-01-19T18:53:33: 285:【1/23 18:00】技玉ガチャ

Commit range

basee23de339cc600f4b0e9c20fce536a6e5f1d866d9
head50817f56d5ea072b8590bed075e710e6615e1f54
base branchjolly/jrye-db:develop
head branchjolly/jrye-db:skillball_gacha_0123

View commits

Commit details are loaded from Git when a dynamic archive server is running, or can be embedded with --include-commits.
Files changed3 filesView patch
statusfile
modifiedcsv/master_card_skill.csv
modifiedcsv/master_monthly_skillball_gacha.csv
modifiedcsv/master_monthly_skillball_gacha_item.csv
Patch body is stored as a separate file to keep this page lightweight.