Project

General

Profile

« Previous | Next » 

Revision 3917

Added by Jing Tao almost 16 years ago

Check into cvs head. Modify the query of deleting xml_nodes_revisions table.

View differences:

src/edu/ucsb/nceas/metacat/EML201DocumentCorrector.java
100 100
     private String generateXML_Node_RevisionsDeletingSQL()
101 101
     {
102 102
    	 String sql ="delete from xml_nodes_revisions where nodetype='ATTRIBUTE' and nodename='system' and nodedata='document' "+
103
    	                     "and parentnodeid in (select nodeid from xml_nodes where  nodetype='ELEMENT' and nodename='references') and docid in "+
104
    	                     "(select docid from xml_documents where doctype ='eml://ecoinformatics.org/eml-2.0.1')";
103
    	                     "and parentnodeid in (select nodeid from xml_nodes_revisions where  nodetype='ELEMENT' and nodename='references') and docid in "+
104
    	                     "(select docid from xml_revisions where doctype ='eml://ecoinformatics.org/eml-2.0.1')";
105 105
    	 return sql;
106 106
     }
107 107
     

Also available in: Unified diff