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-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