Project

General

Profile

« Previous | Next » 

Revision 3922

Added by Jing Tao over 16 years ago

Check into cvs head. Remove "nodedata='document'" in xml_nodes and xml_nodes_revisions deleting query.

View differences:

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

Also available in: Unified diff