15 lines
521 B
MySQL
15 lines
521 B
MySQL
|
-- Place your SQL code here
|
||
|
|
|
||
|
|
USE vn;
|
||
|
|
|
||
|
|
ALTER TABLE vn.itemShelving DROP FOREIGN KEY itemShelvingBuy_FK;
|
||
|
|
ALTER TABLE vn.itemShelving DROP FOREIGN KEY itemShelving_fk2;
|
||
|
|
ALTER TABLE vn.itemShelving DROP INDEX itemShelving_UN;
|
||
|
|
|
||
|
|
ALTER TABLE vn.itemShelving ADD CONSTRAINT itemShelving_fk2 FOREIGN KEY (shelvingFk) REFERENCES vn.shelving(code) ON DELETE CASCADE ON UPDATE CASCADE;
|
||
|
|
ALTER TABLE vn.itemShelving ADD CONSTRAINT itemShelvingBuy_FK FOREIGN KEY (buyFk) REFERENCES vn.buy(id) ON DELETE RESTRICT ON UPDATE RESTRICT;
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|