Project

General

Profile

« Previous | Next » 

Revision 2359

Added by sgarg over 19 years ago

Modified database creation sql code so that in xml_nodes, nodedatanumerical coulmn is added.

View differences:

xmltables-postgres.sql
54 54 
					-- the unique node id (pk)
55 55 
	nodeindex INT8,		-- order of nodes within parent
56 56 
	nodetype VARCHAR(20),	-- type (DOCUMENT, COMMENT, PI,
57 
					-- ELEMENT, ATTRIBUTE, TEXT)
57 
				-- ELEMENT, ATTRIBUTE, TEXT)
58 58 
	nodename VARCHAR(250),	-- the name of an element or attribute
59 59 
        nodeprefix VARCHAR(50), -- the namespace prefix of the node
60 
	nodedata VARCHAR(4000), 	-- the data for this node (e.g.,
61 
					-- for TEXT it is the content)
62 
	parentnodeid INT8,		-- index of the parent of this node
63 
	rootnodeid INT8,		-- index of the root node of this tree
60 
	nodedata VARCHAR(4000), -- the data for this node (e.g.,
61 
				-- for TEXT it is the content)
62 
	parentnodeid INT8,	-- index of the parent of this node
63 
	rootnodeid INT8,	-- index of the root node of this tree
64 64 
	docid VARCHAR(250),	-- index to the document id
65 65 
	date_created DATE,
66 66 
	date_updated DATE,
67 
        nodedatanumerical FLOAT8, -- the data for this node if
68 
				  -- if it is a number
67 69 
   CONSTRAINT xml_nodes_pk PRIMARY KEY (nodeid),
68 70 
   CONSTRAINT xml_nodes_root_fk
69 71 
		FOREIGN KEY (rootnodeid) REFERENCES xml_nodes,

Also available in: Unified diff