4 lines
274 B
MySQL
4 lines
274 B
MySQL
|
-- Place your SQL code here
|
||
|
|
ALTER TABLE vn.itemShelving ADD buyFk int(11) NULL;
|
||
|
|
ALTER TABLE vn.itemShelving ADD CONSTRAINT itemShelvingBuy_FK FOREIGN KEY (buyFk) REFERENCES vn.buy(id);
|
||
|
|
ALTER TABLE vn.itemShelving ADD CONSTRAINT itemShelving_UN UNIQUE KEY (buyFk,shelvingFk);
|