search

TsubakiBotPad / pad-data-pipeline

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

Add third attribute #456

Closed chasehult closed 1 year ago

chasehult commented 1 year ago 
ALTER TABLE monsters ADD COLUMN attribute_3_id int(11) REFERENCES d_attributes (attribute_id) AFTER attribute_2_id;
CREATE INDEX attribute_3_idx ON monsters (attribute_3_id);
ALTER TABLE monsters_na ADD COLUMN attribute_3_id int(11) REFERENCES d_attributes (attribute_id) AFTER attribute_2_id;
CREATE INDEX attribute_3_idx ON monsters_na (attribute_3_id);
RheingoldRiver commented 1 year ago

454 turned out to be attr3!!!!!!!!