Project

General

Profile

Download (3.33 KB) Statistics
| Revision:

metacat/src/loaddtdschema-oracle.sql @ 7147

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 
      WHERE entry_type LIKE 'Schema'
6 
        AND system_id LIKE '%eml%';
7 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
8 
  VALUES ('DTD', '-//ecoinformatics.org//eml-access-@eml-version@//EN',
9 
         '/dtd/eml-access-@eml-version@.dtd');
10 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
11 
  VALUES ('DTD', '-//ecoinformatics.org//eml-attribute-@eml-version@//EN',
12 
          '/dtd/eml-attribute-@eml-version@.dtd');
13 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
14 
  VALUES ('DTD', '-//ecoinformatics.org//eml-constraint-@eml-version@//EN',
15 
          '/dtd/eml-constraint-@eml-version@.dtd');
16 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
17 
  VALUES ('DTD', '-//ecoinformatics.org//eml-coverage-@eml-version@//EN',
18 
          '/dtd/eml-coverage-@eml-version@.dtd');
19 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
20 
  VALUES ('DTD', '-//ecoinformatics.org//eml-dataset-@eml-version@//EN',
21 
          '/dtd/eml-dataset-@eml-version@.dtd');
22 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
23 
  VALUES ('DTD', '-//ecoinformatics.org//eml-entity-@eml-version@//EN',
24 
          '/dtd/eml-entity-@eml-version@.dtd');
25 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
26 
  VALUES ('DTD', '-//ecoinformatics.org//eml-literature-@eml-version@//EN',
27 
          '/dtd/eml-literature-@eml-version@.dtd');
28 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
29 
  VALUES ('DTD', '-//ecoinformatics.org//eml-physical-@eml-version@//EN',
30 
          '/dtd/eml-physical-@eml-version@.dtd');
31 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
32 
  VALUES ('DTD', '-//ecoinformatics.org//eml-project-@eml-version@//EN',
33 
          '/dtd/eml-project-@eml-version@.dtd');
34 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
35 
  VALUES ('DTD', '-//ecoinformatics.org//eml-protocol-@eml-version@//EN',
36 
          '/dtd/eml-protocol-@eml-version@.dtd');
37 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
38 
  VALUES ('DTD', '-//ecoinformatics.org//eml-software-@eml-version@//EN',
39 
          '/dtd/eml-software-@eml-version@.dtd');
40 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
41 
  VALUES ('Schema', '@eml2_0_1namespace@', '/schema/eml-2.0.1/eml.xsd');
42 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
43 
  VALUES ('Schema', '@eml2_0_0namespace@', '/schema/eml-2.0.0/eml.xsd');
44 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
45 
  VALUES ('Schema', '@stmmlnamespace@', '/schema/eml-2.0.1/stmml.xsd');
46 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
47 7109 leinfelder 
  VALUES ('Schema', '@stmml11namespace@', '/schema/eml-2.1.0/stmml.xsd');
48 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
49 4104 daigle 
  VALUES ('Schema', 'metadata', '/schema/fgdc-std-001/fgdc-std-001-1998.xsd');
50 4401 daigle 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
51 
  VALUES ('Schema', '@eml2_1_0namespace@', '/schema/eml-2.1.0/eml.xsd');
52 4797 daigle 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
53 5709 leinfelder 
  VALUES ('Schema', '@eml2_1_1namespace@', '/schema/eml-2.1.1/eml.xsd');
54 
INSERT INTO xml_catalog (entry_type, public_id, system_id)
55 6658 leinfelder 
  VALUES ('Schema', '/schema/RegistryService/RegistryEntryType.xsd', '/schema/RegistryService/RegistryEntryType.xsd');
56 4104 daigle 
INSERT INTO db_version (version, status, date_created)
57 6550 leinfelder 
  VALUES ('2.0.0',1,CURRENT_DATE);