Project

General

Profile

metacat / src / loaddtdschema-oracle.sql @ 4780

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 '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
  VALUES ('Schema', 'metadata', '/schema/fgdc-std-001/fgdc-std-001-1998.xsd');
48
INSERT INTO xml_catalog (entry_type, public_id, system_id)
49
  VALUES ('Schema', '@eml2_1_0namespace@', '/schema/eml-2.1.0/eml.xsd');
50

    
51
INSERT INTO db_version (version, status, date_created) 
52
  VALUES ('1.9.0',1,CURRENT_DATE);