Project

General

Profile

« Previous | Next » 

Revision 2359

Added by sgarg almost 20 years ago

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

View differences:

src/xmltables.sql
105 105 
	docid		VARCHAR2(250),	-- index to the document id
106 106 
	date_created	DATE,
107 107 
	date_updated	DATE,
108 
	nodedatanumerical NUMBER,       -- the data for this node if
109 
					-- it is a number
108 110 
   CONSTRAINT xml_nodes_pk PRIMARY KEY (nodeid),
109 111 
   CONSTRAINT xml_nodes_root_fk
110 112 
		FOREIGN KEY (rootnodeid) REFERENCES xml_nodes,
src/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,
src/xmltables-sqlserver.sql
122 122 
  [rootnodeid]		[bigint] NULL ,
123 123 
  [docid]		[varchar] (250) NULL ,
124 124 
  [date_created]	[datetime] NULL ,
125 
  [date_updated]	[datetime] NULL
125 
  [date_updated]	[datetime] NULL,
126 
  [nodedatanumerical]   [float] NULL
126 127 
) ON [PRIMARY]
127 128 
GO
128 129 

  		












Also available in:  Unified diff