4 lines
329 B
MySQL
4 lines
329 B
MySQL
|
-- Place your SQL code here
|
||
|
|
ALTER TABLE vn.worker ADD businessFk int(11) DEFAULT NULL NULL;
|
||
|
|
ALTER TABLE vn.worker ADD CONSTRAINT worker_business FOREIGN KEY (businessFk) REFERENCES postgresql.business(business_id) ON DELETE RESTRICT ON UPDATE CASCADE;
|
||
|
|
ALTER TABLE vn.worker ADD CONSTRAINT worker_business UNIQUE KEY (businessFk);
|