Project

General

Profile

« Previous | Next » 

Revision 6542

Added by ben leinfelder over 12 years ago

add User-Agent logging to support D1 requirements

View differences:

upgrade-db-to-1.10.0-oracle.sql
50 50 
*/
51 51 
ALTER TABLE xml_access ADD COLUMN guid VARCHAR2(2000);
52 52 

  		




  
  53
  
    
/**


  		




  
  54
  
    
 * track the user-agent for the request


  		




  
  55
  
    
 */


  		




  
  56
  
    
ALTER TABLE acces_log ADD COLUMN user_agent VARCHAR2(512);


  		




  
  57
  
    

  		




  53
  58
  
    
/*


  		




  54
  59
  
    
 * add the nodedatadate column to xml_nodes 


  		




  55
  60
  
    
 * TODO: load the data into it (java?)


  		




  ......




  59
  64
  
    
ALTER TABLE xml_path_index ADD COLUMN nodedatadate TIMESTAMP;


  		




  60
  65
  
    
CREATE INDEX xml_path_index_idx4 ON xml_path_index (nodedatadate);


  		




  61
  66
  
    

  		




  62
  
  
    

  		




  63
  67
  
    
/*


  		




  64
  68
  
    
 * Register the DataONE schemas


  		




  65
  69
  
    
 */


  		












Also available in:  Unified diff