Project

General

Profile

« Previous | Next » 

Revision 2276

Added by Matt Jones almost 20 years ago

New schema changes, including upgrade scripts. Includes renamed postgres
scripts.

View differences:

xmltables.sql
32 32 
DROP SEQUENCE xml_catalog_id_seq;
33 33 
DROP SEQUENCE xml_relation_id_seq;
34 34 
DROP SEQUENCE xml_replication_id_seq;
35 
DROP SEQUENCE accnum_uniqueid_seq;
36 35 
DROP SEQUENCE xml_documents_id_seq;
37 36 
DROP SEQUENCE accession_number_id_seq;
38 37 
DROP SEQUENCE access_log_seq;
......
58 57 
DROP TABLE accession_number;
59 58 
DROP TABLE access_log;
60 59 
DROP TABLE harvest_site_schedule;
60 
DROP TABLE harvest_detail_log;
61 61 
DROP TABLE harvest_log;
62 
DROP TABLE harvest_detail_log;
63 62 

  		




  64
  63
  
    
/*


  		




  65
  64
  
    
 *Replication -- table to store servers that metacat is replicated to


  		




  ......




  251
  250
  
    
 */


  		




  252
  251
  
    
CREATE TABLE xml_index (


  		




  253
  252
  
    
	nodeid		NUMBER(20),	-- the unique node id


  		




  254
  
  
    
	path		VARCHAR2(200),	-- precomputed path through tree


  		




  
  253
  
    
	path		VARCHAR2(1000),	-- precomputed path through tree


  		




  255
  254
  
    
	docid		VARCHAR2(250),	-- index to the document id


  		




  256
  255
  
    
	doctype		VARCHAR2(100),	-- public id indicating document type


  		




  257
  256
  
    
        parentnodeid    NUMBER(20),     -- id of the parent of the node 


  		












Also available in:  Unified diff