INSERT into app_configuration(id, variable, value) VALUES (nextval('app_configuration_id_seq'), 'application_release_note_url', 'Set here the link to the release notes of your tool');
INSERT into app_configuration(id, variable, value) VALUES (nextval('app_configuration_id_seq'), 'documentation_url', 'https://gazelle.ihe.net/gazelle-documentation/YOURAPP/user.html');
INSERT into app_configuration(id, variable, value) VALUES (nextval('app_configuration_id_seq'), 'contact_title', 'Application manager');
INSERT into app_configuration(id, variable, value) VALUES (nextval('app_configuration_id_seq'), 'contact_email', '....@kereval.com');
INSERT into app_configuration(id, variable, value) VALUES (nextval('app_configuration_id_seq'), 'contact_name', 'Who is the contact point for questions regarding the tool');
INSERT into app_configuration(id, variable, value) VALUES (nextval('app_configuration_id_seq'), 'application_issue_tracker', 'https://gazelle.ihe.net/jira/browse/YOUR_PROJECT_KEY_IN_JIRA');
INSERT into app_configuration(id, variable, value) VALUES (nextval('app_configuration_id_seq'), 'application_url', 'http://sake.irisa.fr/GazelleFhirValidator');
INSERT into app_configuration(id, variable, value) VALUES (nextval('app_configuration_id_seq'), 'cas_url', 'https://gazelle.ihe.net/cas');
INSERT into app_configuration(id, variable, value) VALUES (nextval('app_configuration_id_seq'), 'NUMBER_OF_ITEMS_PER_PAGE', '20');
INSERT into app_configuration(id, variable, value) VALUES (nextval('app_configuration_id_seq'), 'application_works_without_cas', 'false');
INSERT into app_configuration(id, variable, value) VALUES (nextval('app_configuration_id_seq'), 'ip_login', 'false');
INSERT into app_configuration(id, variable, value) VALUES (nextval('app_configuration_id_seq'), 'ip_login_admin', 'regex to match IPaddresses');
INSERT into app_configuration(id, variable, value) VALUES (nextval('app_configuration_id_seq'), 'time_zone', 'Europe/Paris');
INSERT into app_configuration(id, variable, value) VALUES (nextval('app_configuration_id_seq'), 'svs_repository_url', 'https://gazelle.ihe.net');
INSERT INTO app_configuration(id, value, variable) VALUES (nextval('app_configuration_id_seq'), '/opt/fhirvalidator/structureDefinitions', 'structure_definition_directory');
INSERT INTO app_configuration(id, value, variable) VALUES (nextval('app_configuration_id_seq'), '/opt/fhirvalidator/ValueSet', 'value_set_location');
INSERT INTO app_configuration(id, value, variable) VALUES (nextval('app_configuration_id_seq'), '/opt/fhirvalidator/CodeSystem', 'code_system_location');
INSERT INTO app_configuration (id, value, variable) VALUES (nextval('app_configuration_id_seq'), 'https://gazelle.ihe.net/xsl/fhir/structureDefinition.xsl', 'structure_definition_stylesheet_location');

-- EncodingEnum.JSON = 0
-- EncodingEnum.XML = 1

INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'), '[ITI-83] Get Corresponding Identifiers', '1.3.6.1.4.1.12559.11.1.2.1.15.1', 'IHE',
        'PIXm', null, false, NULL , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[ITI-83] Parameters Resource XML', '1.3.6.1.4.1.12559.11.1.2.1.15.2', 'IHE',
        'PIXm', 1, FALSE , NULL , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[ITI-83] Parameters Resource JSON', '1.3.6.1.4.1.12559.11.1.2.1.15.3', 'IHE',
        'PIXm', 0, FALSE , NULL , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[ITI-78] Query Patient Resource', '1.3.6.1.4.1.12559.11.1.2.1.15.4', 'IHE',
        'PDQm', null, FALSE , NULL , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[ITI-78] Query Patient Resource response XML', '1.3.6.1.4.1.12559.11.1.2.1.15.5', 'IHE',
        'PDQm', 1, TRUE, NULL , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'Operation Outcome XML', '1.3.6.1.4.1.12559.11.1.2.1.15.6', 'IHE', 'OperationOutcome', 1, TRUE, NULL , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'Operation Outcome JSON', '1.3.6.1.4.1.12559.11.1.2.1.15.7', 'IHE', 'OperationOutcome', 0, TRUE, NULL , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[ITI-78] Query Patient Resource response JSON', '1.3.6.1.4.1.12559.11.1.2.1.15.8', 'IHE',
        'PDQm', 0, TRUE, NULL , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[ITI-78] Retrieve Patient Resource', '1.3.6.1.4.1.12559.11.1.2.1.15.9', 'IHE',
        'PDQm_READ', null, FALSE, NULL , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[ITI-78] Retrieve Patient Resource Response XML', '1.3.6.1.4.1.12559.11.1.2.1.15.10', 'IHE',
        'PDQm', 1, TRUE, NULL , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[ITI-78] Retrieve Patient Resource Response JSON', '1.3.6.1.4.1.12559.11.1.2.1.15.11', 'IHE',
        'PDQm', 0, TRUE, NULL , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'FHIR Resource XML (DSTU3)', '1.3.6.1.4.1.12559.11.1.2.1.15.12', 'FHIR', 'FHIR', 1, TRUE, NULL , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'FHIR Resource JSON (DSTU3)', '1.3.6.1.4.1.12559.11.1.2.1.15.13', 'FHIR', 'FHIR', 0, TRUE, NULL , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[ITI-65] Provide Document Bundle Request XML', '1.3.6.1.4.1.12559.11.1.2.1.15.16', 'IHE',
        'MHD', 1, FALSE, '/opt/fhirvalidator/structureDefinitions/IHE.MHD.ProvideDocumentBundle.Comprehensive.structuredefinition.xml' , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[ITI-65] Provide Document Bundle Request JSON', '1.3.6.1.4.1.12559.11.1.2.1.15.17', 'IHE',
        'MHD', 0, FALSE, '/opt/fhirvalidator/structureDefinitions/IHE.MHD.DocumentManifest.structuredefinition.xml' , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[ITI-66] Find Document Manifests Response XML', '1.3.6.1.4.1.12559.11.1.2.1.15.18', 'IHE',
        'MHD', 1, FALSE, '/opt/fhirvalidator/structureDefinitions/IHE.MHD.ProvideDocumentBundle.Comprehensive.structuredefinition.xml' , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[ITI-66] Find Document Manifests Response JSON', '1.3.6.1.4.1.12559.11.1.2.1.15.19', 'IHE',
        'MHD', 0, FALSE, '/opt/fhirvalidator/structureDefinitions/IHE.MHD.DocumentManifest.structuredefinition.xml' , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[mCSD] Location Resource JSON', '1.3.6.1.4.1.12559.11.1.2.1.15.20', 'IHE',
        'mCSD', 0, FALSE, '/opt/fhirvalidator/structureDefinitions/IHE.mCSD.Location.structuredefinition.xml' , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[mCSD] Location Resource XML', '1.3.6.1.4.1.12559.11.1.2.1.15.21', 'IHE',
        'mCSD', 1, FALSE, '/opt/fhirvalidator/structureDefinitions/IHE.mCSD.Location.structuredefinition.xml' , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[mCSD] Organization Resource JSON', '1.3.6.1.4.1.12559.11.1.2.1.15.22', 'IHE',
        'mCSD', 0, FALSE, '/opt/fhirvalidator/structureDefinitions/IHE.mCSD.Organization.structuredefinition.xml' , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[mCSD] Organization Resource XML', '1.3.6.1.4.1.12559.11.1.2.1.15.23', 'IHE',
        'mCSD', 1, FALSE, '/opt/fhirvalidator/structureDefinitions/IHE.mCSD.Organization.structuredefinition.xml' , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[mCSD] Practitioner Resource JSON', '1.3.6.1.4.1.12559.11.1.2.1.15.24', 'IHE',
        'mCSD', 0, FALSE, '/opt/fhirvalidator/structureDefinitions/IHE.mCSD.Practitioner.structuredefinition.xml' , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[mCSD] Practitioner Resource XML', '1.3.6.1.4.1.12559.11.1.2.1.15.25', 'IHE',
        'mCSD', 1, FALSE, '/opt/fhirvalidator/structureDefinitions/IHE.mCSD.Practitioner.structuredefinition.xml' , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[mCSD] Practitioner Role Resource JSON', '1.3.6.1.4.1.12559.11.1.2.1.15.14', 'IHE',
        'mCSD', 0, FALSE, '/opt/fhirvalidator/structureDefinitions/IHE.mCSD.PractitionerRole.structuredefinition.xml' , TRUE);
INSERT INTO fhir_validator_description(id, name, oid, descriminator, profile, format, execute_schematron_validation, custom_structure_definition, execute_schema_validation)
VALUES (nextval('fhir_validator_description_id_seq'),'[mCSD] Practitioner Role Resource XML', '1.3.6.1.4.1.12559.11.1.2.1.15.15', 'IHE',
        'mCSD', 1, FALSE, '/opt/fhirvalidator/structureDefinitions/IHE.mCSD.PractitionerRole.structuredefinition.xml' , TRUE);
