Project

General

Profile

« Previous | Next » 

Revision 2398

Added by Jing Tao almost 20 years ago

Add new query to fix existed xml_relation table datapackage type bug.

View differences:

src/upgrade-db-to-1.5.sql
73 73 
  WHERE public_id = '@eml2_0_1namespace@';
74 74 
UPDATE xml_catalog
75 75 
   SET system_id = '@systemidserver@@html-path@/schema/eml-2.0.0/stmml.xsd'
76 
   WHERE public_id = '@stmmlnamespace@';
76 
   WHERE public_id = '@stmmlnamespace@';
77
78 
/*
79 
 * In Metacat 1.4.0, if user insert a eml201 document and has record in xml_relation
80 
 * table. The package type in xml_relation table will be eml200 rather than eml201.
81 
 * The bug was fixed and we need a sql command to fix exsited records
82 
 */
83 
 UPDATE xml_relation SET packagetype='eml://ecoinformatics.org/eml-2.0.1'
84 
      WHERE xml_relation.docid=xml_documents.docid AND xml_documents.doctype LIKE 'eml://ecoinformatics.org/eml-2.0.1';
85

Also available in: Unified diff