Project

General

Profile

Download (7.15 KB) Statistics
| Revision:

metacat/src/loaddtdschema-oracle.sql @ 8630

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

      

      

        123
        
            4104
        
        
            daigle
        
        
INSERT INTO db_version (version, status, date_created)


      

      

        124
        
            8555
        
        
            leinfelder
        
        
  VALUES ('2.4.0',1,CURRENT_DATE);