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:

src/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
src/xmltables-postgres.sql
193 193
	doctype VARCHAR(100),	-- public id indicating document type
194 194
        parentnodeid INT8,      -- id of the parent of the node represented
195 195
				-- by this row
196
	nodedata VARCHAR (4000),-- for storing data for a given path
197 196
   CONSTRAINT xml_index_pk PRIMARY KEY (nodeid,path),
198 197
   CONSTRAINT xml_index_nodeid_fk FOREIGN KEY (nodeid) REFERENCES xml_nodes,
199 198
   CONSTRAINT xml_index_docid_fk
......
204 203
 * Index of the paths in xml_index
205 204
 */
206 205
CREATE INDEX xml_index_idx1 ON xml_index (path);
207
CREATE INDEX xml_index_idx2 ON xml_index (docid);
208 206

  
209 207
CREATE SEQUENCE xml_relation_id_seq;
210 208
CREATE TABLE xml_relation (

Also available in: Unified diff