salix/db/versions/10908-blueAsparagus/00-createSupplierDms.sql

DELETE FROM vn.supplierDms
	WHERE dmsFk IN (
		SELECT sd.dmsFk
			FROM vn.supplierDms sd
				LEFT JOIN vn.dms d ON d.id = sd.dmsFk
			WHERE d.id IS NULL
	);

DELETE FROM vn.supplierDms
	WHERE supplierFk IN (
		SELECT sd.supplierFk
			FROM vn.supplierDms sd
				LEFT JOIN vn.supplier s ON s.id = sd.supplierFk
			WHERE s.id IS NULL
	);

ALTER TABLE `vn`.`supplierDms`
	MODIFY COLUMN supplierFk int(10) unsigned NOT NULL,
	ADD editorFk INT UNSIGNED NULL,
	ADD CONSTRAINT user_Fk FOREIGN KEY (editorFk) REFERENCES account.`user`(id),
	ADD CONSTRAINT dms_Fk FOREIGN KEY (dmsFk) REFERENCES vn.dms(id) ON DELETE CASCADE ON UPDATE CASCADE,
	ADD CONSTRAINT supplier_Fk FOREIGN KEY (supplierFk) REFERENCES vn.supplier(id) ON UPDATE CASCADE;

ALTER TABLE `vn`.`supplierLog`
	MODIFY COLUMN `changedModel` ENUM('Supplier','SupplierAddress','SupplierAccount','SupplierContact','SupplierDms') NOT NULL DEFAULT 'Supplier';