search

ronancpl / HeavenMS

An improved server based on MapleSolaxia (v83 MapleStory private server)
GNU Affero General Public License v3.0
1.03k stars 742 forks source link

SQL Foreign key Error (db_database.sql) in last commit. #538

Closed kvmba closed 5 years ago

kvmba commented 5 years ago

QQ截图20191029223034

error code: ALTER TABLE inventoryitems ADD CONSTRAINT fk_itempetid FOREIGN KEY (petid) REFERENCES pets (petid) ON DELETE SET NULL ; # thanks Optimist for noticing queries over petid taking too long, shavit for pointing out an improvement using foreign key

QQ截图20191029223104

foreign key not exists. : )

ronancpl commented 5 years ago

Issue patched.