Project

General

Profile

« Previous | Next » 

Revision 4080

Added by daigle about 16 years ago

Merge 1.9 changes into Head

View differences:

upgrade-db-to-1.5-postgres.sql
30 30 
 * to local schema or dtd file.
31 31 
 */
32 32 
UPDATE xml_catalog
33 
   SET system_id = '@systemidserver@@html-path@/dtd/eml-access-@eml-version@.dtd'
33 
   SET system_id = '/dtd/eml-access-@eml-version@.dtd'
34 34 
   WHERE public_id = '-//ecoinformatics.org//eml-access-@eml-version@//EN';
35 35 
UPDATE xml_catalog
36 
   SET system_id = '@systemidserver@@html-path@/dtd/eml-attribute-@eml-version@.dtd'
36 
   SET system_id = '/dtd/eml-attribute-@eml-version@.dtd'
37 37 
   WHERE public_id = '-//ecoinformatics.org//eml-attribute-@eml-version@//EN';
38 38 
UPDATE xml_catalog
39 
   SET system_id = '@systemidserver@@html-path@/dtd/eml-constraint-@eml-version@.dtd'
39 
   SET system_id = '/dtd/eml-constraint-@eml-version@.dtd'
40 40 
   WHERE public_id = '-//ecoinformatics.org//eml-constraint-@eml-version@//EN';
41 41 
UPDATE xml_catalog
42 
   SET system_id = '@systemidserver@@html-path@/dtd/eml-coverage-@eml-version@.dtd'
42 
   SET system_id = '/dtd/eml-coverage-@eml-version@.dtd'
43 43 
   WHERE public_id = '-//ecoinformatics.org//eml-coverage-@eml-version@//EN';
44 44 
UPDATE xml_catalog
45 
   SET system_id = '@systemidserver@@html-path@/dtd/eml-coverage-@eml-version@.dtd'
45 
   SET system_id = '/dtd/eml-coverage-@eml-version@.dtd'
46 46 
   WHERE public_id = '-//ecoinformatics.org//eml-coverage-@eml-version@//EN';
47 47 
UPDATE xml_catalog
48 
   SET system_id = '@systemidserver@@html-path@/dtd/eml-dataset-@eml-version@.dtd'
48 
   SET system_id = '/dtd/eml-dataset-@eml-version@.dtd'
49 49 
   WHERE public_id = '-//ecoinformatics.org//eml-dataset-@eml-version@//EN';
50 50 
UPDATE xml_catalog
51 
   SET system_id = '@systemidserver@@html-path@/dtd/eml-entity-@eml-version@.dtd'
51 
   SET system_id = '/dtd/eml-entity-@eml-version@.dtd'
52 52 
   WHERE public_id = '-//ecoinformatics.org//eml-entity-@eml-version@//EN';
53 53 
UPDATE xml_catalog
54 
   SET system_id = '@systemidserver@@html-path@/dtd/eml-literature-@eml-version@.dtd'
54 
   SET system_id = '/dtd/eml-literature-@eml-version@.dtd'
55 55 
   WHERE public_id = '-//ecoinformatics.org//eml-literature-@eml-version@//EN';
56 56 
UPDATE xml_catalog
57 
   SET system_id = '@systemidserver@@html-path@/dtd/eml-physical-@eml-version@.dtd'
57 
   SET system_id = '/dtd/eml-physical-@eml-version@.dtd'
58 58 
   WHERE public_id = '-//ecoinformatics.org//eml-physical-@eml-version@//EN';
59 59 
UPDATE xml_catalog
60 
   SET system_id = '@systemidserver@@html-path@/dtd/eml-project-@eml-version@.dtd'
60 
   SET system_id = '/dtd/eml-project-@eml-version@.dtd'
61 61 
   WHERE public_id = '-//ecoinformatics.org//eml-project-@eml-version@//EN';
62 62 
UPDATE xml_catalog
63 
   SET system_id = '@systemidserver@@html-path@/dtd/eml-protocol-@eml-version@.dtd'
63 
   SET system_id = '/dtd/eml-protocol-@eml-version@.dtd'
64 64 
   WHERE public_id = '-//ecoinformatics.org//eml-protocol-@eml-version@//EN';
65 65 
UPDATE xml_catalog
66 
   SET system_id = '@systemidserver@@html-path@/dtd/eml-software-@eml-version@.dtd'
66 
   SET system_id = '/dtd/eml-software-@eml-version@.dtd'
67 67 
   WHERE public_id = '-//ecoinformatics.org//eml-software-@eml-version@//EN';
68 68 
UPDATE xml_catalog
69 
  SET system_id = '@systemidserver@@html-path@/schema/eml-2.0.0/eml.xsd'
69 
  SET system_id = '/schema/eml-2.0.0/eml.xsd'
70 70 
  WHERE public_id = '@eml2_0_0namespace@';
71 71 
UPDATE xml_catalog
72 
  SET system_id = '@systemidserver@@html-path@/schema/eml-2.0.1/eml.xsd'
72 
  SET system_id = '/schema/eml-2.0.1/eml.xsd'
73 73 
  WHERE public_id = '@eml2_0_1namespace@';
74 74 
UPDATE xml_catalog
75 
   SET system_id = '@systemidserver@@html-path@/schema/eml-2.0.0/stmml.xsd'
75 
   SET system_id = '/schema/eml-2.0.0/stmml.xsd'
76 76 
   WHERE public_id = '@stmmlnamespace@';
77 77
78 78 
/*
......
84 84 
    WHERE docid IN (SELECT docid from xml_documents WHERE doctype LIKE 'eml://ecoinformatics.org/eml-2.0.1');
85 85 

  		




  86
  86
  
    

  		




  
  87
  
    
CREATE SEQUENCE xml_returnfield_id_seq;


  		




  87
  88
  
    

  		




  88
  
  
    

  		




  89
  89
  
    
/*


  		




  90
  90
  
    
 * Returnfields -- table to store combinations of returnfields requested


  		




  91
  91
  
    
 *                  and the number of times this table is accessed


  		




  ......




  96
  96
  
    
        usage_count        INT8,                                             -- the number of times this string has been requested


  		




  97
  97
  
    
        CONSTRAINT xml_returnfield_pk PRIMARY KEY (returnfield_id)


  		




  98
  98
  
    
);


  		




  99
  
  
    
CREATE INDEX xml_returnfield_idx1 ON xml_returnfield(returnfield_string);


  		




  100
  
  
    
                                                                                  


  		




  101
  
  
    
CREATE SEQUENCE xml_returnfield_id_seq;


  		




  102
  
  
    
                                                                                  


  		




  
  99
  
    
CREATE INDEX xml_returnfield_idx1 ON xml_returnfield(returnfield_string);                                                                                 


  		




  
  100
  
    
 


  		




  
  101
  
    

  		




  
  102
  
    
CREATE SEQUENCE xml_queryresult_id_seq;


  		




  
  103
  
    

  		




  103
  104
  
    
/*


  		




  104
  105
  
    
 * Queryresults -- table to store queryresults for a given docid


  		




  105
  106
  
    
 * and returnfield_id


  		




  ......




  115
  116
  
    
               FOREIGN KEY (returnfield_id) REFERENCES xml_returnfield


  		




  116
  117
  
    
);


  		




  117
  118
  
    

  		




  118
  
  
    
CREATE SEQUENCE xml_queryresult_id_seq;


  		




  119
  119
  
    

  		




  120
  120
  
    
ALTER TABLE xml_nodes ADD nodedatanumerical FLOAT8;


  		




  121
  121
  
    

  		












Also available in:  Unified diff