Skip to content
This repository has been archived by the owner on Dec 28, 2019. It is now read-only.

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

Closed
kvmba opened this issue Oct 29, 2019 · 1 comment
Closed

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

kvmba opened this issue Oct 29, 2019 · 1 comment

Comments

@kvmba
Copy link

kvmba commented Oct 29, 2019

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
Copy link
Owner

Issue patched.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants