Project

General

Profile

« Previous | Next » 

Revision 3917

Added by Jing Tao over 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