Project

General

Profile

« Previous | Next » 

Revision 317

Added by bojilova almost 24 years ago

doctype and docid attr added to xml_index table

View differences:

xmltables.sql
45 45 
					-- for TEXT it is the content)
46 46 
	parentnodeid	NUMBER(20),	-- index of the parent of this node
47 47 
	rootnodeid	NUMBER(20),	-- index of the root node of this tree
48 
	docid		VARCHAR2(55),	-- index to the document id
48 
	docid		VARCHAR2(250),	-- index to the document id
49 49 
	date_created	DATE,
50 50 
	date_updated	DATE,
51 51 
   CONSTRAINT xml_nodes_pk PRIMARY KEY (nodeid),
......
135 135 
CREATE TABLE xml_index (
136 136 
	nodeid		NUMBER(20),	-- the unique node id
137 137 
	path		VARCHAR2(200),	-- precomputed path through tree
138 
	docid		VARCHAR2(250),	-- index to the document id
139 
	doctype		VARCHAR2(100),	-- public id indicating document type
138 140 
   CONSTRAINT xml_index_pk PRIMARY KEY (nodeid,path),
139 
   CONSTRAINT xml_nodes_fk FOREIGN KEY (nodeid) REFERENCES xml_nodes
141 
   CONSTRAINT xml_index_nodeid_fk FOREIGN KEY (nodeid) REFERENCES xml_nodes,
142 
   CONSTRAINT xml_index_docid_fk
143 
		FOREIGN KEY (docid) REFERENCES xml_documents
140 144 
);
141 145 

  		




  142
  146
  
    
/* 


  		












Also available in:  Unified diff