Revision 2442
Added by sgarg over 19 years ago
| 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
Removing code added for creating nodedata column in xml_index table