2 lines
218 B
MySQL
2 lines
218 B
MySQL
|
ALTER TABLE vn.worker MODIFY COLUMN bossFk int(10) unsigned DEFAULT 103 NOT NULL;
|
||
|
|
ALTER TABLE vn.worker ADD CONSTRAINT workerWorker_FK FOREIGN KEY (bossFk) REFERENCES vn.worker(id) ON DELETE RESTRICT ON UPDATE CASCADE;
|