Project

General

Profile

metacat / src / loaddtdschema-postgres.sql @ 9857

1
DELETE FROM xml_catalog 
2
      WHERE entry_type LIKE 'DTD'
3
        AND public_id LIKE '%@eml-version@%';
4
DELETE FROM xml_catalog 
5
      WHERE entry_type LIKE 'DTD'
6
        AND public_id LIKE '%@eml-beta4-version@%';
7
DELETE FROM xml_catalog 
8
      WHERE entry_type LIKE 'Schema'
9
        AND system_id LIKE '%eml%';
10
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
        AND system_id LIKE '%/dwc/%';
19
DELETE FROM xml_catalog 
20
      WHERE entry_type LIKE 'Schema'
21
        AND system_id LIKE '%/dryad/%'; 
22
DELETE FROM xml_catalog 
23
      WHERE entry_type LIKE 'Schema'
24
        AND system_id LIKE '%/onedcx/%';                
25
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
-- include 2.0.0beta4
59
INSERT INTO xml_catalog (entry_type, public_id, system_id)
60
  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
  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
  VALUES ('Schema', '@stmml11namespace@', '/schema/eml-2.1.0/stmml.xsd');
101
INSERT INTO xml_catalog (entry_type, public_id, system_id)
102
  VALUES ('Schema', 'metadata', '/schema/fgdc-std-001/fgdc-std-001-1998.xsd');
103
INSERT INTO xml_catalog (entry_type, public_id, system_id)
104
  VALUES ('Schema', '@eml2_1_0namespace@', '/schema/eml-2.1.0/eml.xsd');
105
INSERT INTO xml_catalog (entry_type, public_id, system_id)
106
  VALUES ('Schema', '@eml2_1_1namespace@', '/schema/eml-2.1.1/eml.xsd');
107
INSERT INTO xml_catalog (entry_type, public_id, system_id)
108
  VALUES ('Schema', 'http://ecoinformatics.org/registryentry-1.0.0', '/schema/RegistryService/RegistryEntryType.xsd');
109
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
  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
  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
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
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
  
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

    
133
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

    
142
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

    
148
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
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
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

    
174
INSERT INTO db_version (version, status, date_created) 
175
  VALUES ('2.8.0',1,CURRENT_DATE);