Fix: Manual normalization directories appearing in METS.xml

refs #4511
Also som cleanup on empty "" pk's.

SET foreign_key_checks = 0;
UPDATE StandardTasksConfigs SET pk = '8971383b-5c38-4818-975f-e539bd993eb8' WHERE pk = '';
UPDATE TasksConfigs SET pk = '33c0dea0-da6c-4b8f-8038-6e95844eea95', taskTypePKReference = '8971383b-5c38-4818-975f-e539bd993eb8' where pk = '';
UPDATE MicroServiceChainLinks SET pk = 'fa5b0c43-ed7b-4c7e-95a8-4f9ec7181260', currentTask = '33c0dea0-da6c-4b8f-8038-6e95844eea95' where pk = '';
UPDATE MicroServiceChainLinksExitCodes SET pk = 'fa5b0c43-ed7b-4c7e-95a8-4f9ec7181260', microServiceChainLink='fa5b0c43-ed7b-4c7e-95a8-4f9ec7181260' where pk = '';
SET foreign_key_checks = 1;

INSERT INTO MicroServiceChainLinks (pk, currentTask, defaultNextChainLink, microserviceGroup)
    VALUES ('75fb5d67-5efa-4232-b00b-d85236de0d3f', '33c0dea0-da6c-4b8f-8038-6e95844eea95', 'ccf8ec5c-3a9a-404a-a7e7-8f567d3b36a0', 'Prepare AIP');
INSERT INTO MicroServiceChainLinksExitCodes (pk, microServiceChainLink, nextMicroServiceChainLink)
    VALUES ('e0935e25-62dc-43c1-b4d3-bb3c1f8f04f9', '75fb5d67-5efa-4232-b00b-d85236de0d3f', 'ccf8ec5c-3a9a-404a-a7e7-8f567d3b36a0');

UPDATE MicroServiceChainLinks SET defaultNextChainLink = '75fb5d67-5efa-4232-b00b-d85236de0d3f' WHERE pk = 'ee438694-815f-4b74-97e1-8e7dde2cc6d5';
UPDATE MicroServiceChainLinksExitCodes SET nextMicroServiceChainLink = '75fb5d67-5efa-4232-b00b-d85236de0d3f' WHERE microServiceChainLink = 'ee438694-815f-4b74-97e1-8e7dde2cc6d5';

UPDATE MicroServiceChainLinks SET defaultNextChainLink = 'fa5b0c43-ed7b-4c7e-95a8-4f9ec7181260' WHERE pk = '88affaa2-13c5-4efb-a860-b182bd46c2c6';
UPDATE MicroServiceChainLinksExitCodes SET nextMicroServiceChainLink = 'fa5b0c43-ed7b-4c7e-95a8-4f9ec7181260' where microServiceChainLink='88affaa2-13c5-4efb-a860-b182bd46c2c6';

UPDATE MicroServiceChainLinks SET defaultNextChainLink = 'cccc2da4-e9b8-43a0-9ca2-7383eff0fac9' WHERE pk = 'fa5b0c43-ed7b-4c7e-95a8-4f9ec7181260';
UPDATE MicroServiceChainLinksExitCodes SET nextMicroServiceChainLink = 'cccc2da4-e9b8-43a0-9ca2-7383eff0fac9' where pk = 'fa5b0c43-ed7b-4c7e-95a8-4f9ec7181260';

UPDATE ee438694-815f-4b74-97e1-8e7dde2cc6d5