Project

General

Profile

« Previous | Next » 

Revision 825

Added by bojilova over 23 years ago

added nodeprefix column to xml_nodes table for storing of namespace prefixes per nodes

View differences:

src/xmltables.sql
66 66 
END;
67 67 
/
68 68 

  		




  69
  
  
    
INSERT INTO xml_replication (serverid, server, replicate) VALUES ('1', 'localhost', '0');


  		




  
  69
  
    
INSERT INTO xml_replication (serverid, server, replicate)


  		




  
  70
  
    
 VALUES ('1', 'localhost', '0');


  		




  70
  71
  
    

  		




  71
  72
  
    
/* 


  		




  72
  73
  
    
 * Nodes -- table to store XML Nodes (both elements and attributes)


  		




  ......




  78
  79
  
    
	nodetype	VARCHAR2(20),	-- type (DOCUMENT, COMMENT, PI,


  		




  79
  80
  
    
					-- ELEMENT, ATTRIBUTE, TEXT)


  		




  80
  81
  
    
	nodename	VARCHAR2(250),	-- the name of an element or attribute


  		




  
  82
  
    
	nodeprefix	VARCHAR2(50),	-- the namespace prefix of an element


  		




  
  83
  
    
                                        -- or attribute


  		




  81
  84
  
    
	nodedata	VARCHAR2(4000), -- the data for this node (e.g., 


  		




  82
  85
  
    
					-- for TEXT it is the content)


  		




  83
  86
  
    
	parentnodeid	NUMBER(20),	-- index of the parent of this node


  		




  ......




  144
  147
  
    
	doctype		VARCHAR2(100),	-- public id indicating document type


  		




  145
  148
  
    
	user_owner	VARCHAR2(100),	-- the user owned the document


  		




  146
  149
  
    
	user_updated	VARCHAR2(100),	-- the user updated the document


  		




  147
  
  
    
	server_location NUMBER(20),	-- the server on which this document resides


  		




  148
  
  
    
	rev 		NUMBER(10) DEFAULT 1,--the revision number of the document


  		




  
  150
  
    
	server_location NUMBER(20),	-- the server on which this document 


  		




  
  151
  
    
                                           originates


  		




  
  152
  
    
	rev 		NUMBER(10) DEFAULT 1,--the revision number of the docume


  		




  149
  153
  
    
	date_created	DATE,


  		




  150
  154
  
    
	date_updated	DATE,


  		




  151
  155
  
    
	public_access	NUMBER(1),	-- flag for public access


  		




  ......




  229
  233
  
    
	path		VARCHAR2(200),	-- precomputed path through tree


  		




  230
  234
  
    
	docid		VARCHAR2(250),	-- index to the document id


  		




  231
  235
  
    
	doctype		VARCHAR2(100),	-- public id indicating document type


  		




  232
  
  
    
        parentnodeid    NUMBER(20),     -- id of the parent of the node represented


  		




  233
  
  
    
					-- by this row


  		




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


  		




  
  237
  
    
					-- represented by this row


  		




  234
  238
  
    
   CONSTRAINT xml_index_pk PRIMARY KEY (nodeid,path),


  		




  235
  239
  
    
   CONSTRAINT xml_index_nodeid_fk FOREIGN KEY (nodeid) REFERENCES xml_nodes,


  		




  236
  240
  
    
   CONSTRAINT xml_index_docid_fk 


  		












Also available in:  Unified diff