Project

General

Profile

Revision 2442

Added by sgarg about 16 years ago

Removing code added for creating nodedata column in xml_index table

View differences:

xmltables.sql
264 264
	doctype		VARCHAR2(100),	-- public id indicating document type
265 265
        parentnodeid    NUMBER(20),     -- id of the parent of the node
266 266
					-- represented by this row
267
	nodedata        VARCHAR2(4000), -- the data for the given path
268 267
   CONSTRAINT xml_index_pk PRIMARY KEY (nodeid,path),
269 268
   CONSTRAINT xml_index_nodeid_fk FOREIGN KEY (nodeid) REFERENCES xml_nodes,
270 269
   CONSTRAINT xml_index_docid_fk
......
275 274
 * Index of the paths in xml_index
276 275
 */
277 276
CREATE INDEX xml_index_idx1 ON xml_index (path);
278
CREATE INDEX xml_index_idx2 ON xml_index (docid);
279 277

  
280 278
CREATE TABLE xml_relation (
281 279
	relationid    NUMBER(20) PRIMARY KEY, -- unique id

Also available in: Unified diff