4 lines
254 B
MySQL
4 lines
254 B
MySQL
|
ALTER TABLE vn.saleTracking MODIFY COLUMN workerFk int(10) unsigned NOT NULL;
|
||
|
|
DELETE FROM vn.saleTracking WHERE workerFk = 0;
|
||
|
|
ALTER TABLE vn.saleTracking ADD CONSTRAINT saleTracking_FK_2 FOREIGN KEY (workerFk) REFERENCES vn.worker(id) ON UPDATE CASCADE;
|