INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'application_database_initialization_flag', 'database_successfully_initialized', 'java.lang.String', 'Indicates that the DB has been initialized');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'application_url', 'http://localhost:8080/EVSClient', 'java.lang.String', 'URL to reach the tool');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'cas_enabled', 'false', 'java.lang.Boolean', 'Indicates authentication mechanism to use');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'ip_login', 'true', 'java.lang.Boolean', 'Indicates authentication mechanism to use');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'ip_login_admin', '.*', 'java.lang.String', 'Pattern to grant users as admin based on their IP address');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'cas_url', 'Not defined', 'java.lang.String', 'URL of the CAS service');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'time_zone', 'Europe/Paris', 'java.lang.String', 'Time zone to display time to users');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'atna_repository', '/opt/EVSClient_prod/validatedObjects/ATNA', 'java.lang.String', 'Where to store ATNA messages');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'cda_repository', '/opt/EVSClient_prod/validatedObjects/CDA', 'java.lang.String', 'Where to store CDA documents');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'dicom_repository', '/opt/EVSClient_prod/validatedObjects/DICOM', 'java.lang.String', 'Where to store DICOM files');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'dicom_scp_screener_xsl', 'dicom/TestDicomResults.xsl', 'java.lang.String', 'XSL used to display Dicom SCP Screener results');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'display_SCHEMATRON_menu', 'false', 'java.lang.String', 'Indicates if we need a link to the list of schematrons for download');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'dsub_repository', '/opt/EVSClient_prod/validatedObjects/DSUB', 'java.lang.String', 'Where to store DSUB files');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'epsos_repository_codes', '/opt/EVSClient_prod/bin/EpsosRepository', 'java.lang.String', 'path to epsos codes for epsos-cda-display-tool');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'gazelle_hl7v2_validator_url', 'http://gazelle.ihe.net/GazelleHL7Validator', 'java.lang.String', 'Path to Gazelle HL7 Validator');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'gazelle_home_path', '/opt/EVSClient_prod', 'java.lang.String', 'Absolute path to Gazelle home. Here is where are stored generated datas, reports and other required binaries for application');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'hl7v3_repository', '/opt/EVSClient_prod/validatedObjects/HL7v3', 'java.lang.String', 'Where to store HL7v3 messages');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'hpd_repository', '/opt/EVSClient_prod/validatedObjects/HPD', 'java.lang.String', 'Where to store HPD messages');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'include_country_statistics', 'true', 'java.lang.Boolean', 'Authorize or not the application to query geoip to retrieve the countries the users are from');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'monitor_email', 'test@test.com', 'java.lang.String', 'Contact of the person who monitors the application');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'number_of_segments_to_display', '40', 'java.lang.Integer', 'Number of segment to display when displaying HL7v2 messages');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'object_for_validator_detector_repository', '/opt/EVSClient_prod/validatedObjects/validatorDetector', 'java.lang.String', 'path to the repository where object for validator_detector are stored');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'pdf_repository', '/opt/EVSClient_prod/validatedObjects/PDF', 'java.lang.String', 'Where to store PDF files');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'root_oid', '1.2.3', 'java.lang.String', 'Root of the OID used to uniquely identify validation requests');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'saml_repository', '/opt/EVSClient_prod/validatedObjects/SAML', 'java.lang.String', 'Where to store SAML assertions');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'svs_repository', '/opt/EVSClient_prod/validatedObjects/SVS', 'java.lang.String', 'Where to store SVS messages');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'tls_repository', '/opt/EVSClient_prod/validatedObjects/TLS', 'java.lang.String', 'Where to store certificates');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'xds_repository', '/opt/EVSClient_prod/validatedObjects/XDS', 'java.lang.String', 'Where to store XDS messages');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'xdw_repository', '/opt/EVSClient_prod/validatedObjects/XDW', 'java.lang.String', 'Where to store XDW messages');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'application_admin_email', 'contact@evsclient.net', 'java.lang.String', 'Contact of the person responsible for the application');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'application_admin_name', 'contact', 'java.lang.String', 'Person responsible for the application');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'application_issue_tracker_url', 'http://gazelle.ihe.net/browse/EVSCLT', 'java.lang.String', 'URL of the project in the issue tracking system');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'hl7v2_length_fault_level', 'ERROR', 'java.lang.String', 'How to report errors on length');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'hl7v2_structure_fault_level', 'ERROR', 'java.lang.String', 'How to report errors on structure');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'hl7v2_datatype_fault_level', 'ERROR', 'java.lang.String', 'How to report errors on datatype');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'hl7v2_value_fault_level', 'ERROR', 'java.lang.String', 'How to report errors on value');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'templates_scanned', 'true', 'java.lang.Boolean', 'Scan templates when CDA file is validated');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'x_validation_enabled', 'true', 'java.lang.Boolean', 'Indicates if the X validation module is enabled');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'assertion_manager_url', 'http://gazelle.ihe.net/AssertionManagerGui', 'java.lang.String', 'URL to access Assertion Manager');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'xvalidator_directory', '/opt/EVSClient_prod/xvalidation', 'java.lang.String', 'Where to store X validation files');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'x_validation_log_root_oid', '1.3.6.1.4.1.12559.11.1.2.1.4.2.', 'java.lang.String', 'Root OID for X Validation reports');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'svs_repository_url', 'http://gazelle.ihe.net', 'java.lang.String', 'Default SVS repository for X validation');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'xvalidator_xsl_url', 'http://localhost:8380/EVSClient/stylesheet/gazelleXValidator.xsl', 'java.lang.String', 'Stylesheet for displaying validators');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'x_validation_validator', 'true', 'java.lang.Boolean', 'Whether to enable or not the validator feature of X Validation module');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'x_validation_editor', 'true', 'java.lang.Boolean', 'Whether to enable or not the editor feature of X Validation module');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'path_to_dcmDump', '/usr/bin/dcmdump', 'java.lang.Boolean', 'Path to DcmDump executable on the system hosting the application');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'NUMBER_OF_ITEMS_PER_PAGE', '20', 'java.lang.String', 'Number of lines in tables');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'application_gazelle_documentation_url', 'https://gazelle.ihe.net/content/user-manual', 'java.lang.String', 'EVS Client documentation URL');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'application_admin_title', 'IHE Europe Technical Manager', 'java.lang.String', 'Admin Title ');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'use_specific_smtp', 'false', 'java.lang.Boolean', 'If true will use information from smtp_host, smtp_usernamen and smtp_password. Otherwize will use localhost on port 25  ');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'smtp_host', 'localhost', 'java.lang.String', 'SMTP Host for sending emails');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'smtp_username', 'username', 'java.lang.String', 'SMTP Username for sending emails');

INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'smtp_port', '25', 'java.lang.Integer', 'SMTP Port for sending emails');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'add_ons_enabled', 'true', 'java.lang.Boolean', 'Show add-ons menu');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'cda_scorecard_xsl_path', 'https://gazelle.ihe.net/xsl/scorecard/cda-scorecard.xsl', 'java.lang.String', 'XSL to transform CDA scorecard');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'SAML_file_types', 'xml, XML, saml, SAML, log', 'java.lang.String', 'Files extensions that can be used for SAML Validation');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'ATNA_file_types', 'xml, XML, syslog, log, txt, TXT, log', 'java.lang.String', 'Files extensions that can be used for ATNA Audit message Validation');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'CDA_file_types', 'xml, XML, cda, CDA, txt, TXT, log', 'java.lang.String', 'Files extensions that can be used for CDA Document Validation');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'DSUB_file_types', 'xml, XML, dsub, DSUB, txt, TXT, log', 'java.lang.String', 'Files extensions that can be used for DSUB Document Validation');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'HL7v3_file_types', 'xml, XML, hl7, HL7, hl7v3, HL7V3, HL7v3, txt, TXT, log', 'java.lang.String', 'Files extensions that can be used for DSUB Document Validation');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'HPD_file_types', 'xml, XML, hpd, HPD, txt, TXT, log', 'java.lang.String', 'Files extensions that can be used for HPD Validation');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'SVS_file_types', 'xml, XML, svs, SVS, txt, TXT, log', 'java.lang.String', 'Files extensions that can be used for HPD Validation');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'XML_file_types', 'xml, XML, txt, TXT, log', 'java.lang.String', 'Files extensions that can be used for XML Validation');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'DICOM_file_types', 'dcm, DCM, bin', 'java.lang.String', 'Files extensions that can be used for DICOM Validation');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'X509_file_types', 'pem, txt, PEM, TXT, CRT, crt', 'java.lang.String', 'Files extensions that can be used for X509 certificate Validation');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'reports_path', 'reports', 'java.lang.String', 'Path to jasper reports in gazelle home');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'fhir_repository', '/opt/EVSClient_prod/validatedObjects/FHIR','java.lang.String', 'Where to store FHIR resources');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'FHIR_file_types', 'xml,json', 'java.lang.String', 'Extensions allowed for uploaded files');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'check_CDA_PIDs', 'false', 'java.lang.Boolean', 'Execute script to check patient id before the document upload on the server');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'check_CDA_PIDs_script_localization', 'http://localhost/ruleScript.js', 'java.lang.String', 'URL where the script with the differents CDA rules are stored');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'validation_timeout', '60000', 'java.lang.String', 'used as the tieout after calling an MBVAl validator');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'user_need_to_be_logged_in', 'false', 'java.lang.Boolean', 'Set to true if you would like users to be logged in to access validators and logs');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'default_dsig_validator_name', 'Digital Signature Validator', 'java.lang.String', 'Name of the validator offered by XMLSignatureValidator to be used for validating embedded signatures');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'enable_dsig_validation', 'true', 'java.lang.Boolean', 'Set to true if the tool shall detect and validate Digital signatures in XML documents');
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'show_logs_from_colleagues', 'false', 'java.lang.Boolean', 'Set to true if you would like users from the same organization to share logs');
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');
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');
INSERT INTO cmn_application_preference (id, class_name, description, preference_name, preference_value) VALUES (nextval('cmn_application_preference_id_seq'), 'java.lang.String', 'allowed extensions for XDS validator', 'XDS_file_types', 'xml, XML');