
CREATE TABLE evsc_menu_group (
    id integer NOT NULL,
    is_available boolean,
    icon_path character varying(255) NOT NULL,
    label character varying(255) NOT NULL,
    order_in_gui integer
);


ALTER TABLE public.evsc_menu_group OWNER TO gazelle;

--
-- Name: evsc_menu_group_label_key; Type: CONSTRAINT; Schema: public; Owner: gazelle; Tablespace:
--

ALTER TABLE ONLY evsc_menu_group
    ADD CONSTRAINT evsc_menu_group_label_key UNIQUE (label);


--
-- Name: evsc_menu_group_pkey; Type: CONSTRAINT; Schema: public; Owner: gazelle; Tablespace:
--

ALTER TABLE ONLY evsc_menu_group
    ADD CONSTRAINT evsc_menu_group_pkey PRIMARY KEY (id);



-- Menu
INSERT INTO evsc_menu_group (id, is_available, icon_path, label, order_in_gui) VALUES (1, true, '/img/IHE.gif', 'IHE', 1);

-- Standard


CREATE TABLE evsc_referenced_standard (
    id integer NOT NULL,
    description character varying(255),
    extension character varying(255),
    label character varying(255),
    name character varying(255),
    version character varying(255),
    path_to_xsl character varying(255),
    icon_path character varying(255),
    menu_display_name character varying(255)
);


ALTER TABLE public.evsc_referenced_standard OWNER TO gazelle;

--
-- Name: evsc_referenced_standard_id_key; Type: CONSTRAINT; Schema: public; Owner: gazelle; Tablespace:
--

ALTER TABLE ONLY evsc_referenced_standard
    ADD CONSTRAINT evsc_referenced_standard_id_key UNIQUE (id, label);


--
-- Name: evsc_referenced_standard_pkey; Type: CONSTRAINT; Schema: public; Owner: gazelle; Tablespace:
--

ALTER TABLE ONLY evsc_referenced_standard
    ADD CONSTRAINT evsc_referenced_standard_pkey PRIMARY KEY (id);


--
-- Name: uk_spkb3eg89ry2iue5unqk378m8; Type: CONSTRAINT; Schema: public; Owner: gazelle; Tablespace:
--

ALTER TABLE ONLY evsc_referenced_standard
    ADD CONSTRAINT uk_spkb3eg89ry2iue5unqk378m8 UNIQUE (id, label);




INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (1, 'PDF Document as defined by IHE (PDF/A)', 'IHE', 'PDF', 'PDF', '', '', 'fa fa-file-pdf-o', 'PDF');
INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (2, '', 'FHIR', 'FHIR', 'XML', 'DSTU 2', NULL, 'fa fa-fire', 'FHIR');
INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (3, '', 'IHE', 'ATNA-IHE', 'ATNA', 'RFC3881', NULL, 'fa fa-book', 'Audit messages');
INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (4, 'HL7v2.x messages defined by IHE', 'IHE', 'HL7v2.x - IHE', 'HL7v2', '2.x', NULL, 'gzl-font gzl-hl7', 'HL7v2.x');
INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (5, '', 'C-CDA', 'CDA-C-CDA', 'CDA', '1.0', NULL, 'gzl-font gzl-hl7', 'C-CDA');
INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (6, '', 'CCD', 'CDA-CCD', 'CDA', '1.0', NULL, 'gzl-font gzl-hl7', 'CDA-CCD');
INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (7, '', 'IHE', 'HL7v3-IHE', 'HL7v3', '3', '', 'gzl-font gzl-hl7', 'HL7v3');
INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (8, 'Digital Imaging And Communication in Medicine', 'IHE', 'DICOM', 'DICOM', '', NULL, 'gzl-font gzl-dicom', 'DICOM');
INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (9, 'Healthcare Provider Directory integration profile', 'IHE', 'HPD', 'HPD', '', NULL, 'fa fa-phone', 'Healthcare Provider Directory');
INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (10, 'Sharing Value Set', 'IHE', 'SVS', 'SVS', '', '', 'fa fa-code', 'Sharing Value Set');
INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (11, '', 'IHE', 'XDS-IHE', 'XDS', '', '', 'fa fa-code', 'XD* metadata');
INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (12, '', 'IHE', 'XDW', 'XDW', '', 'https://gazelle.ihe.net/xsl/XDW.xsl', '/resources/img/workflow.png', 'XDW');
INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (13, '', 'IHE', 'TLS-IHE', 'TLS', '', NULL, 'fa fa-certificate', 'Certificates');
INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (14, '', 'IHE', 'SAML-IHE', 'SAML', '1.0', NULL, 'fa fa-bookmark-o', 'Assertions');
INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (15, 'Validation of CDA document in the context of the IHE ', 'IHE', 'CDA-IHE', 'CDA', '', 'https://gazelle.ihe.net/xsl/cda_modular_xsl_all/cda_modular.xsl', 'gzl-font gzl-hl7', 'CDA');
INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (16, 'EXPAND validation, this validator is based on art-decor import of requirements to Gazelle ObjectsChecker, and the integration of the schematrons generated using art-decor', 'EXPAND', 'CDA-EXPAND', 'CDA', '1.0', NULL, 'gzl-font gzl-hl7', 'EXPAND');
INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (17, 'Tools for the validation of wado URL', 'IHE', 'Wado', 'WADO', '', NULL, 'gzl-font gzl-dicom', 'Wado');
INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (18, '', 'WSTrust', 'WSTrust', 'XML', '1.3', NULL, 'fa fa-bookmark', 'WSTrust-1.3');
INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (19, 'Schematron Validation of SDMX 2.1 document', 'IHE', 'SDMX', 'XML', '2.1', '', 'fa fa-code', 'SDMX');
INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (20, '', 'IHE', 'DSUB-IHE', 'DSUB', '', NULL, 'fa fa-flag', 'DSUB');

INSERT INTO evsc_referenced_standard (id, description, extension, label, name, version, path_to_xsl, icon_path, menu_display_name) VALUES (1, '', 'IHE', 'XDS-IHE', 'XDS', '', '', 'fa fa-code', 'XD* metadata');


CREATE TABLE evsc_validation_service (
    id integer NOT NULL,
    available boolean,
    description character varying(255),
    keyword character varying(255),
    wsdl character varying(255),
    name character varying(255),
    provider character varying(255),
    engine character varying(255),
    xsl_location character varying(255)
);


ALTER TABLE public.evsc_validation_service OWNER TO gazelle;

--
-- Name: evsc_validation_service_id_key; Type: CONSTRAINT; Schema: public; Owner: gazelle; Tablespace:
--

ALTER TABLE ONLY evsc_validation_service
    ADD CONSTRAINT evsc_validation_service_id_key UNIQUE (id, keyword);


--
-- Name: evsc_validation_service_pkey; Type: CONSTRAINT; Schema: public; Owner: gazelle; Tablespace:
--

ALTER TABLE ONLY evsc_validation_service
    ADD CONSTRAINT evsc_validation_service_pkey PRIMARY KEY (id);


--
-- Name: uk_fl9slp173tnvc3hgodbs6d6ce; Type: CONSTRAINT; Schema: public; Owner: gazelle; Tablespace:
--

ALTER TABLE ONLY evsc_validation_service
    ADD CONSTRAINT uk_fl9slp173tnvc3hgodbs6d6ce UNIQUE (id, keyword);


-- Validation Services
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (1, true, '', 'dcm4che', 'uses an enclosed jar', 'dcm4che', '', '', '');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (2, true, '', 'dcmcheck', '/opt/offis/dicom/bin/dcmcheck', 'dcmcheck', '', '', '');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (3, true, 'Dicom 3 tools validator', 'dicom3tools', '/opt/dicom3tools', 'Dicom 3 tools', 'David Clunie', '', '');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (4, false, '', 'DVTK', 'http://131.254.209.20:10001/DVTK/', 'DVTK', 'IHE Europe', '', '﻿https://gazelle.ihe.net/xsl/DVTKTransform.xsl');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (5, true, '', 'pixelmed', 'uses an enclosed jar', 'Pixelmed', '', '', '');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (6, true, 'Wado', 'Wado', 'http://131.254.209.20:8080/XDStarClient-ejb/WADOModelBasedWSService/WADOModelBasedWS?wsdl', 'Wado', '', 'model-based', 'https://gazelle.ihe.net/xsl/wadoValidatorDetailedResult.xsl');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (7, true, '', 'DCCHECK', 'http://78.117.3.59:34789/DCCHECK', 'DCCHECK', '', '', 'https://gazelle.ihe.net/xsl/dccheckTransform.xsl');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (8, true, '', 'JHOVE', 'null', 'JHOVE', 'Harvard', 'null', 'https://gazelle.ihe.net/xsl/EVSClient/pdf/JhoveResultStylesheetV2.xsl');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (9, true, '', 'MB-XDW', 'https://gazelle.ihe-europe.net/XDWSimulator-ejb/ModelBasedValidationWSService/ModelBasedValidationWS', 'Model-based XDW validator', 'IHE Europe', 'model-based', 'https://gazelle.ihe.net/xsl/hl7v3validatorDetailedResult.xsl');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (10, true, 'model-based validator for XDS', 'MB-XDS', 'https://gazelle.ihe.net/XDStarClient-ejb/ModelBasedValidationWSService/ModelBasedValidationWS?wsdl', 'Model-based XDS Validator', 'IHE Europe', 'model-based', 'https://gazelle.ihe.net/xsl/hl7v3validatorDetailedResult.xsl');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (11, true, 'Model-based validator for HL7v3 messages', 'Gazelle_HL7v3', 'https://gazelle.ihe.net/GazelleHL7v2Validator-ejb/ModelBasedValidationWSService/ModelBasedValidationWS?wsdl', 'Gazelle HL7v3 Validator', 'Gazelle', 'model-based', 'https://gazelle.ihe.net/xsl/EVSClient/hl7v3/hl7v3validatorDetailedResult.xsl');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (12, true, 'Model-based validator embedded in Gazelle HPDSimulator', 'GazelleHPD', 'https://gazelle.ihe.net/HPDSimulator-ejb/ModelBasedValidationWSService/ModelBasedValidationWS?wsdl', 'Gazelle HPD Simulator', 'Gazelle', 'model-based', 'https://gazelle.ihe.net/xsl/EVSClient/HPD/HPDValidatorDetailedResult.xsl');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (13, true, 'Validator for SVS requests and responses (ITI-48 & ITI-60)', 'MB-SVS', 'https://gazelle.ihe.net/SVSSimulator-ejb/ModelBasedValidationWSService/ModelBasedValidationWS?wsdl', 'SVS Model-based validation', 'IHE Europe', 'model-based', 'https://gazelle.ihe.net/xsl/EVSClient/svs/svsDetailedResult.xsl');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (14, true, 'Schematron Validation', 'Gazelle', 'https://gazelle.ihe.net/SchematronValidator-ejb/GazelleObjectValidatorService/GazelleObjectValidator?wsdl', 'Schematron Based Validator', 'IHE Europe', 'schematron', 'https://gazelle.ihe.net/xsl/EVSClient/Schematron/schematronResultStylesheet4EVSC.xsl');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (15, true, '', 'FHIR', 'https://gazelle.ihe.net/SchematronValidator-ejb/GazelleObjectValidatorService/GazelleObjectValidator?wsdl	', 'FHIR®©', 'FHIR', 'schematron', 'https://gazelle.ihe.net/xsl/EVSClient/Schematron/schematronResultStylesheet4EVSC.xsl');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (16, true, '', 'Assertions', 'https://gazelle.ihe.net/gazelle-xua-jar/ModelBasedValidationWSService/ModelBasedValidationWS?wsdl', 'Assertions - Validator', 'IHE Europe', 'model-based', 'https://gazelle.ihe.net/xsl/EVSClient/saml/SAMLvalidatorDetailedResult.xsl');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (17, true, '', 'MB-CDA', 'https://gazelle.ihe.net/CDAGenerator-ejb/ModelBasedValidationWSService/ModelBasedValidationWS?wsdl', 'Model-Based CDA Validator', 'IHE Europe', 'model-based', 'https://gazelle.ihe.net/xsl/mbcdaDetailedResult.xsl');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (18, true, 'https://gazelle.ihe.net/xsl/auditMessagevalidatorDetailedResultV2.xsl', 'AuditMessage', 'https://gazelle.ihe.net/gazelle-atna-ejb/AuditMessageValidationWSService/AuditMessageValidationWS?wsdl', 'AuditMessage - Validator', 'IHE Europe', 'model-based', 'https://gazelle.ihe.net/xsl/EVSClient/auditMessages/auditMessageValidatorDetailedResult.xsl');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (19, true, '', 'HL7v2_GAZELLE', 'https://gazelle.ihe.net/GazelleHL7v2Validator-ejb/gazelleHL7v2ValidationWSService/gazelleHL7v2ValidationWS?wsdl', 'Gazelle HL7v2.x validator', 'IHE Europe', 'null', 'https://gazelle.ihe.net/xsl/EVSClient/hl7v2/resultStylesheetV2.xsl');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (21, true, 'model-based validator for DSUB', 'DSUB', 'https://gazelle.ihe.net/XDStarClient-ejb/DSUBModelBasedWSService/DSUBModelBasedWS?wsdl', 'DSUB', 'IHE Europe', 'model-based', 'https://gazelle.ihe.net/xsl/EVSClient/hl7v3validatorDetailedResult.xsl');
INSERT INTO evsc_validation_service (id, available, description, keyword, wsdl, name, provider, engine, xsl_location) VALUES (22, true, 'calls TLS certificate validation from PKI project', 'TLS', 'https://gazelle.ihe.net/gazelle-atna-ejb/CertificateValidatorService/CertificateValidator?wsdl', 'TLS certificate Validator', 'IHE Europe', 'null', 'https://gazelle.ihe.net/xsl/EVSClient/tls/tlsResultStylesheet.xsl');



CREATE TABLE evsc_standard_service (
    validation_service_id integer NOT NULL,
    referenced_standard_id integer NOT NULL
);


ALTER TABLE public.evsc_standard_service OWNER TO gazelle;

--
-- Name: evsc_standard_service_referenced_standard_id_key; Type: CONSTRAINT; Schema: public; Owner: gazelle; Tablespace:
--

ALTER TABLE ONLY evsc_standard_service
    ADD CONSTRAINT evsc_standard_service_referenced_standard_id_key UNIQUE (referenced_standard_id, validation_service_id);


--
-- Name: uk_35eb3h8jcoiykl3tgfgto4ilc; Type: CONSTRAINT; Schema: public; Owner: gazelle; Tablespace:
--

ALTER TABLE ONLY evsc_standard_service
    ADD CONSTRAINT uk_35eb3h8jcoiykl3tgfgto4ilc UNIQUE (referenced_standard_id, validation_service_id);


--
-- Name: fk5387e8f12f456525; Type: FK CONSTRAINT; Schema: public; Owner: gazelle
--

ALTER TABLE ONLY evsc_standard_service
    ADD CONSTRAINT fk5387e8f12f456525 FOREIGN KEY (referenced_standard_id) REFERENCES evsc_referenced_standard(id);


--
-- Name: fk5387e8f18028b7af; Type: FK CONSTRAINT; Schema: public; Owner: gazelle
--

ALTER TABLE ONLY evsc_standard_service
    ADD CONSTRAINT fk5387e8f18028b7af FOREIGN KEY (validation_service_id) REFERENCES evsc_validation_service(id);




INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (1, 8);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (2, 8);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (3, 8);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (4, 8);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (5, 8);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (6, 17);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (7, 8);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (8, 1);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (9, 12);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (10, 11);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (11, 7);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (12, 9);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (13, 10);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (14, 15);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (14, 18);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (15, 2);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (17, 5);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (17, 6);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (17, 15);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (18, 3);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (19, 4);
INSERT INTO evsc_standard_service (validation_service_id, referenced_standard_id) VALUES (21, 20);
CREATE TABLE evsc_menu_standard (
    menu_group_id integer NOT NULL,
    referenced_standard_id integer NOT NULL
);


ALTER TABLE public.evsc_menu_standard OWNER TO gazelle;

--
-- Name: evsc_menu_standard_menu_group_id_key; Type: CONSTRAINT; Schema: public; Owner: gazelle; Tablespace:
--

ALTER TABLE ONLY evsc_menu_standard
    ADD CONSTRAINT evsc_menu_standard_menu_group_id_key UNIQUE (menu_group_id, referenced_standard_id);


--
-- Name: uk_njh624mu7lyjio7qo0gblfdmg; Type: CONSTRAINT; Schema: public; Owner: gazelle; Tablespace:
--

ALTER TABLE ONLY evsc_menu_standard
    ADD CONSTRAINT uk_njh624mu7lyjio7qo0gblfdmg UNIQUE (menu_group_id, referenced_standard_id);


--
-- Name: fk2be0f49f2f456525; Type: FK CONSTRAINT; Schema: public; Owner: gazelle
--

ALTER TABLE ONLY evsc_menu_standard
    ADD CONSTRAINT fk2be0f49f2f456525 FOREIGN KEY (referenced_standard_id) REFERENCES evsc_referenced_standard(id);


--
-- Name: fk2be0f49f73650c11; Type: FK CONSTRAINT; Schema: public; Owner: gazelle
--

ALTER TABLE ONLY evsc_menu_standard
    ADD CONSTRAINT fk2be0f49f73650c11 FOREIGN KEY (menu_group_id) REFERENCES evsc_menu_group(id);


INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 1);
INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 2);
INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 3);
INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 4);
INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 5);
INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 6);
INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 7);
INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 8);
INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 9);
INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 10);
INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 11);
INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 12);
INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 13);
INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 14);
INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 15);
INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 16);
INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 17);
INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 18);
INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 19);
INSERT INTO evsc_menu_standard (menu_group_id, referenced_standard_id) VALUES (1, 21);




CREATE TABLE doc_stylesheet (
    id integer NOT NULL,
    comment character varying(255),
    name character varying(255) NOT NULL,
    path character varying(255),
    referenced_standard_id integer NOT NULL
);


ALTER TABLE public.doc_stylesheet OWNER TO gazelle;

--
-- Name: doc_stylesheet_pkey; Type: CONSTRAINT; Schema: public; Owner: gazelle; Tablespace:
--

ALTER TABLE ONLY doc_stylesheet
    ADD CONSTRAINT doc_stylesheet_pkey PRIMARY KEY (id);


--
-- Name: fke97203b52f456525; Type: FK CONSTRAINT; Schema: public; Owner: gazelle
--

ALTER TABLE ONLY doc_stylesheet
    ADD CONSTRAINT fke97203b52f456525 FOREIGN KEY (referenced_standard_id) REFERENCES evsc_referenced_standard(id);


INSERT INTO doc_stylesheet (id, comment, name, path, referenced_standard_id) VALUES (1, '', 'cda basic', 'https://gazelle.ihe.net/xsl/cda_modular_xsl_all/CDA_fixed.xsl', 15);
INSERT INTO doc_stylesheet (id, comment, name, path, referenced_standard_id) VALUES (16, '', 'SAML Viewer', 'https://gazelle.ihe.net/xsl/saml2html.xsl', 14);
INSERT INTO doc_stylesheet (id, comment, name, path, referenced_standard_id) VALUES (18, '', 'DocumentToHTML', 'https://gazelle.ihe.net/xsl/FHIR/DocumentToHTML.xslt', 2);
INSERT INTO doc_stylesheet (id, comment, name, path, referenced_standard_id) VALUES (19, 'HL7 CDA Stylesheet v3.0.0', 'cda_basic_v3.0.0', 'https://gazelle.ihe.net/xsl/CDA/hl7/CDA%202.xsl', 15);

INSERT INTO doc_stylesheet (id, comment, name, path, referenced_standard_id) VALUES (24, '', 'ihe', 'https://gazelle.ihe.net/xsl/auditMessage2html.xsl', 3);
INSERT INTO doc_stylesheet (id, comment, name, path, referenced_standard_id) VALUES (5, '', 'xdw basic', 'https://gazelle.ihe.net/xsl/XDW.xsl', 12);
INSERT INTO doc_stylesheet (id, comment, name, path, referenced_standard_id) VALUES (11, 'stylesheet used to display the content of the HPD messages', 'HPD stylesheet', 'https://gazelle.ihe.net/xsl/dsmlStylesheet.xsl', 9);
INSERT INTO doc_stylesheet (id, comment, name, path, referenced_standard_id) VALUES (15, '', 'RFC3881/DICOM Audit message ', 'https://gazelle.ihe.net/xsl/auditMessage2html.xsl', 3);
INSERT INTO doc_stylesheet (id, comment, name, path, referenced_standard_id) VALUES (26, '', 'Nictiz', 'https://gazelle.ihe.net/xsl/CDA/nictiz/cda.xsl', 15);
INSERT INTO doc_stylesheet (id, comment, name, path, referenced_standard_id) VALUES (27, '', 'ELGA', 'https://gazelle.ihe.net/xsl/CDA/elga/ELGA_Stylesheet_v1.0.xsl', 15);
INSERT INTO doc_stylesheet (id, comment, name, path, referenced_standard_id) VALUES (28, '', 'ASIP', 'https://gazelle.ihe.net/xsl/CDA/asip/cda_asip.xsl', 15);
