search

TsubakiBotPad / pad-data-pipeline

Original repo: https://github.com/nachoapps/dadguide-data
9 stars 2 forks source link

Keep monster_no_<server> null if not in server #461

Closed chasehult closed 1 year ago

chasehult commented 1 year ago 
ALTER TABLE MONSTERS MODIFY COLUMN monster_no_jp int(11);
ALTER TABLE MONSTERS MODIFY COLUMN monster_no_na int(11);
ALTER TABLE MONSTERS MODIFY COLUMN monster_no_kr int(11);

UPDATE monsters SET monster_no_jp = NULL WHERE on_jp = 0;
UPDATE monsters SET monster_no_na = NULL WHERE on_na = 0;
UPDATE monsters SET monster_no_kr = NULL WHERE on_kr = 0;