Project

General

Profile

Download (14.8 KB) Statistics
| Revision:

metacat/src/loaddtdschema-postgres.sql @ 10465

1 4080 daigle 
DELETE FROM xml_catalog
2 
      WHERE entry_type LIKE 'DTD'
3 
        AND public_id LIKE '%@eml-version@%';
4 
DELETE FROM xml_catalog
5 7194 leinfelder 
      WHERE entry_type LIKE 'DTD'
6 
        AND public_id LIKE '%@eml-beta4-version@%';
7 
DELETE FROM xml_catalog
8 4080 daigle 
      WHERE entry_type LIKE 'Schema'
9 
        AND system_id LIKE '%eml%';
10 8609 cjones 
DELETE FROM xml_catalog
11 
      WHERE entry_type LIKE 'Schema'
12 
        AND system_id LIKE '%/dataone/%';
13 
DELETE FROM xml_catalog
14 
      WHERE entry_type LIKE 'Schema'
15 
        AND system_id LIKE '%/dc/%';
16 
DELETE FROM xml_catalog
17 
      WHERE entry_type LIKE 'Schema'
18 8617 cjones 
        AND system_id LIKE '%/dwc/%';
19 
DELETE FROM xml_catalog
20 
      WHERE entry_type LIKE 'Schema'
21 9857 walker 
        AND system_id LIKE '%/dryad/%';
22 
DELETE FROM xml_catalog
23 
      WHERE entry_type LIKE 'Schema'
24 
        AND system_id LIKE '%/onedcx/%';
25 4080 daigle 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
26 
  VALUES ('DTD', '-//ecoinformatics.org//eml-access-@eml-version@//EN',
27 
         '/dtd/eml-access-@eml-version@.dtd');
28 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
29 
  VALUES ('DTD', '-//ecoinformatics.org//eml-attribute-@eml-version@//EN',
30 
          '/dtd/eml-attribute-@eml-version@.dtd');
31 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
32 
  VALUES ('DTD', '-//ecoinformatics.org//eml-constraint-@eml-version@//EN',
33 
          '/dtd/eml-constraint-@eml-version@.dtd');
34 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
35 
  VALUES ('DTD', '-//ecoinformatics.org//eml-coverage-@eml-version@//EN',
36 
          '/dtd/eml-coverage-@eml-version@.dtd');
37 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
38 
  VALUES ('DTD', '-//ecoinformatics.org//eml-dataset-@eml-version@//EN',
39 
          '/dtd/eml-dataset-@eml-version@.dtd');
40 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
41 
  VALUES ('DTD', '-//ecoinformatics.org//eml-entity-@eml-version@//EN',
42 
          '/dtd/eml-entity-@eml-version@.dtd');
43 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
44 
  VALUES ('DTD', '-//ecoinformatics.org//eml-literature-@eml-version@//EN',
45 
          '/dtd/eml-literature-@eml-version@.dtd');
46 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
47 
  VALUES ('DTD', '-//ecoinformatics.org//eml-physical-@eml-version@//EN',
48 
          '/dtd/eml-physical-@eml-version@.dtd');
49 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
50 
  VALUES ('DTD', '-//ecoinformatics.org//eml-project-@eml-version@//EN',
51 
          '/dtd/eml-project-@eml-version@.dtd');
52 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
53 
  VALUES ('DTD', '-//ecoinformatics.org//eml-protocol-@eml-version@//EN',
54 
          '/dtd/eml-protocol-@eml-version@.dtd');
55 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
56 
  VALUES ('DTD', '-//ecoinformatics.org//eml-software-@eml-version@//EN',
57 
          '/dtd/eml-software-@eml-version@.dtd');
58 7194 leinfelder 
-- include 2.0.0beta4
59 4080 daigle 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
60 7194 leinfelder 
  VALUES ('DTD', '-//ecoinformatics.org//eml-access-@eml-beta4-version@//EN',
61 
         '/dtd/eml-access-@eml-beta4-version@.dtd');
62 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
63 
  VALUES ('DTD', '-//ecoinformatics.org//eml-attribute-@eml-beta4-version@//EN',
64 
          '/dtd/eml-attribute-@eml-beta4-version@.dtd');
65 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
66 
  VALUES ('DTD', '-//ecoinformatics.org//eml-constraint-@eml-beta4-version@//EN',
67 
          '/dtd/eml-constraint-@eml-beta4-version@.dtd');
68 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
69 
  VALUES ('DTD', '-//ecoinformatics.org//eml-coverage-@eml-beta4-version@//EN',
70 
          '/dtd/eml-coverage-@eml-beta4-version@.dtd');
71 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
72 
  VALUES ('DTD', '-//ecoinformatics.org//eml-dataset-@eml-beta4-version@//EN',
73 
          '/dtd/eml-dataset-@eml-beta4-version@.dtd');
74 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
75 
  VALUES ('DTD', '-//ecoinformatics.org//eml-entity-@eml-beta4-version@//EN',
76 
          '/dtd/eml-entity-@eml-beta4-version@.dtd');
77 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
78 
  VALUES ('DTD', '-//ecoinformatics.org//eml-literature-@eml-beta4-version@//EN',
79 
          '/dtd/eml-literature-@eml-beta4-version@.dtd');
80 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
81 
  VALUES ('DTD', '-//ecoinformatics.org//eml-physical-@eml-beta4-version@//EN',
82 
          '/dtd/eml-physical-@eml-beta4-version@.dtd');
83 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
84 
  VALUES ('DTD', '-//ecoinformatics.org//eml-project-@eml-beta4-version@//EN',
85 
          '/dtd/eml-project-@eml-beta4-version@.dtd');
86 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
87 
  VALUES ('DTD', '-//ecoinformatics.org//eml-protocol-@eml-beta4-version@//EN',
88 
          '/dtd/eml-protocol-@eml-beta4-version@.dtd');
89 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
90 
  VALUES ('DTD', '-//ecoinformatics.org//eml-software-@eml-beta4-version@//EN',
91 
          '/dtd/eml-software-@eml-beta4-version@.dtd');
92 
--include schema
93 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
94 4080 daigle 
  VALUES ('Schema', '@eml2_0_1namespace@', '/schema/eml-2.0.1/eml.xsd');
95 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
96 
  VALUES ('Schema', '@eml2_0_0namespace@', '/schema/eml-2.0.0/eml.xsd');
97 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
98 
  VALUES ('Schema', '@stmmlnamespace@', '/schema/eml-2.0.1/stmml.xsd');
99 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
100 7109 leinfelder 
  VALUES ('Schema', '@stmml11namespace@', '/schema/eml-2.1.0/stmml.xsd');
101 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
102 4080 daigle 
  VALUES ('Schema', 'metadata', '/schema/fgdc-std-001/fgdc-std-001-1998.xsd');
103 4797 daigle 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
104 4401 daigle 
  VALUES ('Schema', '@eml2_1_0namespace@', '/schema/eml-2.1.0/eml.xsd');
105 4797 daigle 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
106 5709 leinfelder 
  VALUES ('Schema', '@eml2_1_1namespace@', '/schema/eml-2.1.1/eml.xsd');
107 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
108 4797 daigle 
  VALUES ('Schema', 'http://ecoinformatics.org/registryentry-1.0.0', '/schema/RegistryService/RegistryEntryType.xsd');
109 8608 cjones 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
110 
  VALUES ('Schema', 'http://ns.dataone.org/service/types/v1', '/schema/dataone/dataoneTypes.xsd');
111 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
112 
  VALUES ('Schema', 'http://ns.dataone.org/service/types/v1.1', '/schema/dataone/dataoneTypes_v1.1.xsd');
113 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
114 9210 tao 
  VALUES ('Schema', 'http://ns.dataone.org/service/types/v2.0', '/schema/dataone/dataoneTypes_v2.0.xsd');
115 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
116 8608 cjones 
  VALUES ('Schema', 'http://purl.org/dryad/schema/terms/v3.1', '/schema/dryad/dryad.xsd');
117 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
118 
  VALUES ('Schema', 'http://purl.org/dryad/schema/dryad-bibo/v3.1', '/schema/dryad/dryad-bibo.xsd');
119 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
120 
  VALUES ('Schema', 'http://purl.org/dc/terms/', '/schema/dc/dcterms.xsd');
121 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
122 
  VALUES ('Schema', 'http://purl.org/dc/elements/1.1/', '/schema/dc/dc.xsd');
123 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
124 
  VALUES ('Schema', 'http://purl.org/dc/dcmitype/', '/schema/dc/dcmitype.xsd');
125 8617 cjones 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
126 
  VALUES ('Schema', 'http://rs.tdwg.org/dwc/terms/', '/schema/dwc/tdwg_dwcterms.xsd');
127 8993 cjones 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
128 
  VALUES ('Schema', 'http://purl.org/ornl/schema/mercury/terms/v1.0', '/schema/ornl/ornl-mercury-v1.0.xsd');
129 9239 tao 

      

      

        130
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, system_id)


      

      

        131
        
        
        
        
        
  VALUES ('Schema', 'http://www.isotc211.org/2005/gco', '/schema/isotc211/gco/gco.xsd');


      

      

        132
        
            8608
        
        
            cjones
        
        

      

      

        133
        
            9239
        
        
            tao
        
        
INSERT INTO xml_catalog (entry_type, public_id, system_id)


      

      

        134
        
        
        
        
        
  VALUES ('Schema', 'http://www.isotc211.org/2005/gmd', '/schema/isotc211/gmd/gmd.xsd');


      

      

        135
        
        
        
        
        

      

      

        136
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, system_id)


      

      

        137
        
        
        
        
        
  VALUES ('Schema', 'http://www.isotc211.org/2005/gmi', '/schema/isotc211/gmi/gmi.xsd');


      

      

        138
        
        
        
        
        

      

      

        139
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, system_id)


      

      

        140
        
        
        
        
        
  VALUES ('Schema', 'http://www.opengis.net/gml/3.2', '/schema/isotc211/gml321/gml.xsd');


      

      

        141
        
            8608
        
        
            cjones
        
        

      

      

        142
        
            9239
        
        
            tao
        
        
INSERT INTO xml_catalog (entry_type, public_id, system_id)


      

      

        143
        
        
        
        
        
  VALUES ('Schema', 'http://www.opengis.net/gml', '/schema/isotc211/gml311/gml.xsd');


      

      

        144
        
        
        
        
        

      

      

        145
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, system_id)


      

      

        146
        
        
        
        
        
  VALUES ('Schema', 'http://www.isotc211.org/2005/gmx', '/schema/isotc211/gmx/gmx.xsd');


      

      

        147
        
            8617
        
        
            cjones
        
        

      

      

        148
        
            9239
        
        
            tao
        
        
INSERT INTO xml_catalog (entry_type, public_id, system_id)


      

      

        149
        
        
        
        
        
  VALUES ('Schema', 'http://www.isotc211.org/2005/gsr', '/schema/isotc211/gsr/gsr.xsd');


      

      

        150
        
        
        
        
        

      

      

        151
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, system_id)


      

      

        152
        
        
        
        
        
  VALUES ('Schema', 'http://www.isotc211.org/2005/gss', '/schema/isotc211/gss/gss.xsd');


      

      

        153
        
        
        
        
        

      

      

        154
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, system_id)


      

      

        155
        
        
        
        
        
  VALUES ('Schema', 'http://www.isotc211.org/2005/gts', '/schema/isotc211/gts/gts.xsd');


      

      

        156
        
        
        
        
        

      

      

        157
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, system_id)


      

      

        158
        
        
        
        
        
  VALUES ('Schema', 'http://www.isotc211.org/2005/srv', '/schema/isotc211/srv/srv.xsd');


      

      

        159
        
        
        
        
        

      

      

        160
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, system_id)


      

      

        161
        
        
        
        
        
  VALUES ('Schema', 'http://www.w3.org/1999/xlink', '/schema/isotc211/xlink/xlinks.xsd');


      

      

        162
        
        
        
        
        

      

      

        163
        
            9577
        
        
            tao
        
        
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id) VALUES ('Schema', 'http://www.isotc211.org/2005/gmd', 'http://www.isotc211.org/2005/gmd-noaa', '/schema/isotc211-noaa/gmd/gmd.xsd');


      

      

        164
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id) VALUES ('Schema', 'http://www.isotc211.org/2005/gco', 'http://www.isotc211.org/2005/gmd-noaa', '/schema/isotc211-noaa/gco/gco.xsd');


      

      

        165
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id) VALUES ('Schema', 'http://www.isotc211.org/2005/gmi', 'http://www.isotc211.org/2005/gmd-noaa', '/schema/isotc211-noaa/gmi/gmi.xsd');


      

      

        166
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id) VALUES ('Schema', 'http://www.isotc211.org/2005/gmx', 'http://www.isotc211.org/2005/gmd-noaa', '/schema/isotc211-noaa/gmx/gmx.xsd');


      

      

        167
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id) VALUES ('Schema', 'http://www.isotc211.org/2005/gsr', 'http://www.isotc211.org/2005/gmd-noaa', '/schema/isotc211-noaa/gsr/gsr.xsd');


      

      

        168
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id) VALUES ('Schema', 'http://www.isotc211.org/2005/gss', 'http://www.isotc211.org/2005/gmd-noaa', '/schema/isotc211-noaa/gss/gss.xsd');


      

      

        169
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id) VALUES ('Schema', 'http://www.isotc211.org/2005/gts', 'http://www.isotc211.org/2005/gmd-noaa', '/schema/isotc211-noaa/gts/gts.xsd');


      

      

        170
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id) VALUES ('Schema', 'http://www.isotc211.org/2005/srv', 'http://www.isotc211.org/2005/gmd-noaa', '/schema/isotc211-noaa/srv/srv.xsd');


      

      

        171
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id) VALUES ('Schema', 'http://www.w3.org/1999/xlink', 'http://www.isotc211.org/2005/gmd-noaa', '/schema/isotc211-noaa/xlink/xlinks.xsd');


      

      

        172
        
            9857
        
        
            walker
        
        
INSERT INTO xml_catalog (entry_type, public_id, system_id) VALUES ('Schema', 'http://ns.dataone.org/metadata/schema/onedcx/v1.0', '/schema/onedcx/onedcx.xsd');


      

      

        173
        
            9938
        
        
            tao
        
        
INSERT INTO xml_catalog (entry_type, format_id, no_namespace_schema_location, system_id) VALUES ('NoNamespaceSchema', 'FGDC-STD-001-1998', 'https://www.fgdc.gov/schemas/metadata/fgdc-std-001-1998.xsd', '/schema/fgdc-std-001-1998/fgdc-std-001-1998.xsd');


      

      

        174
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, format_id, no_namespace_schema_location, system_id) VALUES ('NoNamespaceSchema', 'FGDC-STD-001-1998', 'http://www.fgdc.gov/schemas/metadata/fgdc-std-001-1998.xsd', '/schema/fgdc-std-001-1998/fgdc-std-001-1998.xsd');


      

      

        175
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, format_id, no_namespace_schema_location, system_id) VALUES ('NoNamespaceSchema', 'FGDC-STD-001-1998', 'https://www.fgdc.gov/metadata/fgdc-std-001-1998.xsd', '/schema/fgdc-std-001-1998/fgdc-std-001-1998.xsd');


      

      

        176
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, format_id, no_namespace_schema_location, system_id) VALUES ('NoNamespaceSchema', 'FGDC-STD-001-1998', 'http://www.fgdc.gov/metadata/fgdc-std-001-1998.xsd', '/schema/fgdc-std-001-1998/fgdc-std-001-1998.xsd');


      

      

        177
        
            10134
        
        
            tao
        
        
INSERT INTO xml_catalog (entry_type, format_id, no_namespace_schema_location, system_id) VALUES ('NoNamespaceSchema', 'FGDC-STD-001.1-1999', 'https://water.usgs.gov/GIS/metadata/usgswrd/fgdc-std-001-1998.xsd', '/schema/fgdc-bdp/fgdc-std-001.1-1999.xsd');


      

      

        178
        
            9577
        
        
            tao
        
        

      

      

        179
        
            10461
        
        
            tao
        
        
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id)


      

      

        180
        
        
        
        
        
    SELECT 'Schema', 'http://www.isotc211.org/2005/gmd', 'http://www.isotc211.org/2005/gmd-pangaea', '/schema/isotc211-pangaea/gmd.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog WHERE format_id='http://www.isotc211.org/2005/gmd-pangaea' AND public_id='http://www.isotc211.org/2005/gmd');


      

      

        181
        
        
        
        
        

      

      

        182
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id)


      

      

        183
        
        
        
        
        
    SELECT 'Schema', 'http://www.isotc211.org/2005/gss', 'http://www.isotc211.org/2005/gmd-pangaea', '/schema/isotc211-pangaea/gss.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog WHERE format_id='http://www.isotc211.org/2005/gmd-pangaea' AND public_id='http://www.isotc211.org/2005/gss');


      

      

        184
        
        
        
        
        

      

      

        185
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id)


      

      

        186
        
        
        
        
        
    SELECT 'Schema', 'http://www.isotc211.org/2005/gsr', 'http://www.isotc211.org/2005/gmd-pangaea', '/schema/isotc211-pangaea/gsr.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog WHERE format_id='http://www.isotc211.org/2005/gmd-pangaea' AND public_id='http://www.isotc211.org/2005/gsr');


      

      

        187
        
        
        
        
        

      

      

        188
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id)


      

      

        189
        
        
        
        
        
    SELECT 'Schema', 'http://www.isotc211.org/2005/gts', 'http://www.isotc211.org/2005/gmd-pangaea', '/schema/isotc211-pangaea/gts.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog WHERE format_id='http://www.isotc211.org/2005/gmd-pangaea' AND public_id='http://www.isotc211.org/2005/gts');


      

      

        190
        
        
        
        
        

      

      

        191
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id)


      

      

        192
        
        
        
        
        
    SELECT 'Schema', 'http://www.isotc211.org/2005/gco', 'http://www.isotc211.org/2005/gmd-pangaea', '/schema/isotc211-pangaea/gco.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog WHERE format_id='http://www.isotc211.org/2005/gmd-pangaea' AND public_id='http://www.isotc211.org/2005/gco');


      

      

        193
        
        
        
        
        

      

      

        194
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id)


      

      

        195
        
        
        
        
        
    SELECT 'Schema', 'http://www.w3.org/1999/xlink', 'http://www.isotc211.org/2005/gmd-pangaea', '/schema/isotc211-pangaea/xlinks.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog WHERE format_id='http://www.isotc211.org/2005/gmd-pangaea' AND public_id='http://www.w3.org/1999/xlink');


      

      

        196
        
        
        
        
        

      

      

        197
        
        
        
        
        
INSERT INTO xml_catalog (entry_type, public_id, format_id, system_id)


      

      

        198
        
        
        
        
        
    SELECT 'Schema', 'http://www.opengis.net/gml', 'http://www.isotc211.org/2005/gmd-pangaea', '/schema/isotc211-pangaea/gml.xsd' WHERE NOT EXISTS (SELECT * FROM xml_catalog WHERE format_id='http://www.isotc211.org/2005/gmd-pangaea' AND public_id='http://www.opengis.net/gml');


      

      

        199
        
        
        
        
        

      

      

        200
        
        
        
        
        

      

      

        201
        
            4080
        
        
            daigle
        
        
INSERT INTO db_version (version, status, date_created)


      

      

        202
        
            10213
        
        
            tao
        
        
  VALUES ('2.9.0',1,CURRENT_DATE);