Project

General

Profile

« Previous | Next » 

Revision 165

Added by Matt Jones over 24 years ago

minor modifications to fix problems introduced with AccessionNumber module

View differences:

xmltables.sql
20 20 

  		




  21
  21
  
    
DROP SEQUENCE xml_nodes_id_seq;


  		




  22
  22
  
    
DROP SEQUENCE xml_catalog_id_seq;


  		




  23
  
  
    
DROP SEQUENCE xml_documents_id_seq;


  		




  24
  23
  
    

  		




  25
  24
  
    
DROP TRIGGER xml_nodes_before_insert;


  		




  26
  
  
    
DROP TRIGGER xml_documents_before_insert;


  		




  27
  25
  
    
DROP TRIGGER xml_catalog_before_insert;


  		




  28
  26
  
    

  		




  29
  27
  
    
DROP TABLE xml_index;


  		




  ......




  70
  68
  
    
 * Documents -- table to store XML documents


  		




  71
  69
  
    
 */


  		




  72
  70
  
    
CREATE TABLE xml_documents (


  		




  73
  
  
    
	docid		VARCHAR2(55),	-- the document id #


  		




  74
  
  
    
	rootnodeid	NUMBER(20),	-- refernce to the root node of the DOM


  		




  
  71
  
    
	docid		VARCHAR2(250),	-- the document id #


  		




  
  72
  
    
	rootnodeid	NUMBER(20),	-- reference to root node of the DOM


  		




  75
  73
  
    
	docname		VARCHAR2(100),	-- usually the root element name


  		




  76
  74
  
    
	doctype		VARCHAR2(100),	-- public id indicating document type


  		




  77
  75
  
    
	doctitle	VARCHAR2(1000),	-- title of document if exists


  		












Also available in:  Unified diff