UPDATE cmn_application_preference SET preference_name = 'x_validation_log_root_oid' WHERE description = 'Root OID for X Validation reports';
UPDATE cmn_application_preference SET preference_value = '1.3.6.1.4.1.12559.11.1.2.1.4.2.' WHERE description = 'Root OID for X Validation reports';

--The preference was deleted in 5.7.2 so it cannot be edited (inserted in 5.7.2)
--UPDATE cmn_application_preference SET preference_name = 'x_validator_root_oid' WHERE description = 'Cross validators root oid';
--UPDATE cmn_application_preference SET preference_value = '1.3.6.1.4.1.12559.11.1.2.1.4.1.' WHERE description = 'Cross validators root oid';
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'x_validator_root_oid', '1.3.6.1.4.1.12559.11.1.2.1.4.1.', 'java.lang.String', 'Cross validators root oid');

--Preference exists in init.sql and is inserted twice in update-5.0.0.sql and update-5.2.0.sql. It never has this description though ..
--UPDATE cmn_application_preference SET preference_name = 'xvalidator_directory' WHERE description = 'Storage directory for cross validation unit tests.';
--UPDATE cmn_application_preference SET preference_value = '/opt/EVSClient_prod/xvalidation' WHERE description = 'Storage directory for cross validation unit tests.';

INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'x_validation_report_xsl_url', 'https://gazelle.ihe.net/GazelleXValidatorRuleEditor/resources/stylesheet/report-mini.xsl', 'java.lang.String', 'XSL URL for x validation report');

ALTER TABLE ut_unit_test ADD COLUMN expected_result_string varchar(255);
UPDATE ut_unit_test SET expected_result_string = 'PASSED' where expected_result = 0;
UPDATE ut_unit_test SET expected_result_string = 'FAILED' where expected_result = 1;
UPDATE ut_unit_test SET expected_result_string = 'ABORTED' where expected_result = 2;
ALTER TABLE ut_unit_test DROP COLUMN expected_result;
ALTER TABLE ut_unit_test RENAME COLUMN expected_result_string TO expected_result;
